Using RDS token returns connection refused

[KikeMendez]

Hi, I'm having issues connecting to and RDS using token authentication

The error reported by the server was: SQLSTATE[HY000] [1045] Access denied for user 'iam_user'@'xx.xxxx.xx.xxx' (using password: YES)

So far my investigation down to:

• Connect by using user and password (no the generated RDS token ) - works
• Connect by using user and RDS token - does not works
• Run a test using php mysqli instead PDO with (user and RDS token) - works

Example of token generated:
myDatabase-dev-cluster.cluster-cwujoxa2wlgn.us-east-1.rds.amazonaws.com:3306/?Action=connect&DBUser=iam_user&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKLIOLRyTos5FYBGXRKLA%2F20200314%2Fus-east-1%2Frds-db%2Faws4_request&X-Amz-Date=20200314T031933Z&X-Amz-SignedHeaders=host&X-Amz-Expires=900&X-Amz-Signature=a7373b21f52361addef02848382yg1232c538c730f1273d35fe84af947a12d2

I am wondering if a PDO issue and if is possible to use RDS Token with datatable somehow

Our libraries don't support mysqli unfortunately - they use PDO only. Do you have PHP MySQL PDO drivers installed on your server? You can check using phpinfo().

[KikeMendez]

Hi, thanks for replying, yes I got PDO enabled,
and DataTables works fines if I use user and password, Like: user: John, pass: mypass

It doesn't work when I use the token generated as password.

The mysqli was a separated test just to confirm if the token was working.

That's why I am wondering is is a PDO issue, maybe doesn't like myDatabase-dev-cluster.cluster-cwujoxa2wlgn.us-east-1.rds.amazonaws.com:3306/? that contains a forward slash in the token ??

Are you able to use PDO to connect to your database without the Editor libraries? If not, then you'ld probably be nest asking on bugs.php.net or StackOverflow.

[KikeMendez]

Yeah I got the same thing by connecting to PDO out of datatable editor.
I've been searching about this for the last two days but I couldn't find anything that guide me to find out what the issue is.
I couldn't find anything related to this in stackoverflow
Do you know if there's any PDO group or slack channel where I can jump in and ask?

Sorry - bugs.php.net or StackOverflow as I mentioned are my best suggestions.