Can't get port from RDS DatabaseCluster Endpoint

[joehillen]

Describe the bug
I can't pass the RDS port from one stack to another.

I open a question on StackOverflow about it, but now I think it's actually a bug.

To Reproduce

class DbStack extends cdk.Stack {
  constructor(scope: cdk.Construct, id: string, props: { vpc: ec2.Vpc }) {
    super(scope, id);
    const { vpc } = props;
    const db = new DatabaseCluster(this, "Database", {
      engine: rds.DatabaseClusterEngine.AuroraPostgresql,
      engineVersion: "10.7",
      masterUser: {
        username: "admin",
      },
      defaultDatabaseName: "main",
      instanceProps: {
        instanceType: new ec2.InstanceType("r5.large"),
        vpcSubnets: {
          subnetType: ec2.SubnetType.Private,
        },
        vpc,
      },
      storageEncrypted: true,
      parameterGroup: {
        parameterGroupName: "default.aurora-postgresql10",
      } as any,
    });
    console.log(db.clusterEndpoint);
    console.log(db.clusterEndpoint.hostname);
    console.log(db.clusterEndpoint.port);
    console.log(db.clusterEndpoint.socketAddress);
  }
}

The console output is:

Endpoint {
  hostname: '${Token[Resource.Endpoint.Address.148]}',
  port: -1.8881545897087827e+289,
  socketAddress: '${Token[Resource.Endpoint.Address.148]}:{IndirectPort}' }
${Token[Resource.Endpoint.Address.148]}
-1.8881545897087827e+289
${Token[Resource.Endpoint.Address.148]}:{IndirectPort}

Expected behavior

I need a way to determine the port.

Version:

• OS: Linux
• Programming Language: Typescript
• CDK Version: 0.33.0

[joehillen]

This might be a duplicate of #2679, but not exactly.

[joehillen]

Just confirmed. Still happening in v0.34

[cjyclaire]

+1 for this, seeing the same behavior

[jogold]

This should be fixed in the next release, as a temporary workaround in v0.34.0 you can do this to use the socketAddress somewhere

const socketAddress = `${db.clusterEndpoint.hostname}:${new cdk.Token(db.clusterEndpoint.port)}`;

[dekoza]

The problem is still present on 1.45.0 - I get port number -1.8881545897087736e+289 instead of 3306. Looks like overflow.

[emisbalu]

This issue is still there in 1.82, Please provide a fix for this

Name: ....
Value:
  Fn::Join:
    - ""
    - - jdbc:postgresql://
      - Fn::GetAtt:
          - RDSDBInstanceD5E32DDA
          - Endpoint.Address
      - :-1.8881545897088128E289/maindb

[skinny85]

@balupraveendatty maybe you're missing a call to Token.asString() somewhere where you're passing the port directly as a number, where a string is expected? For example, this works for me:

        const vpc = new ec2.Vpc(this, 'Vpc');
        const db = new rds.DatabaseCluster(this, "Database", {
            engine: rds.DatabaseClusterEngine.auroraPostgres({
                version: rds.AuroraPostgresEngineVersion.VER_10_7,
            }),
            instanceProps: {
                vpc,
            },
        });
        new cdk.CfnOutput(this, 'Output', {
            value: cdk.Token.asString(db.clusterEndpoint.port),
        });

Produces:

Outputs:
  Output:
    Value:
      Fn::GetAtt:
        - DatabaseB269D8BB
        - Endpoint.Port

[emisbalu]

Nice one, cheers @skinny85

[v1pz3n]

Thanks @skinny85 , you saved me 🥰

[moltar]

Looks like this is still an issue.

When I console.log the port:

console.log('port', cluster.clusterEndpoint.port)

I get:

port -1.8881545897088303e+289

[moltar]

Btw, I can fix it like this:

Object.assign(cluster.clusterEndpoint, { port: 5432 })

[skinny85]

@moltar #2711 (comment)

[moltar]

@skinny85 But I don't have the option to wrap in cdk.Token.asString, as I am passing the entire cluster instance to another construct (see linked issue above my first comment). Should the third party construct be handling this then?

[skinny85]

OK... can you show the consuming code then?

[moltar]

https://github.com/moia-oss/bastion-host-forward/blob/81eedc3077db756f4f6737038f7e4728e95c302f/lib/aurora-serverless.ts#L50-L52

[skinny85]

Right. Exactly like I said in #2711 (comment), the code should be:

      port: Token.toString(props.serverlessCluster.clusterEndpoint.port),

, not:

      port: props.serverlessCluster.clusterEndpoint.port.toString(),

[sangheestyle]

cdk.Token.asString(

not Token.toString but cdk.Token.asString which you earlier mentioned. :)