Hi team,
I'm trying to connect to my RDS MySQL aurora instance via DBeaver from my local machine via SSM following this article :
https://aws.amazon.com/blogs/database/securely-connect-to-an-amazon-rds-or-amazon-ec2-database-instance-remotely-with-your-preferred-gui/?fbclid=IwAR0AYyKOfbWGixDBgyZlsJ8ikAnOgbcHPlB4XcGrov0vh63JkAQGcNslLHc
when I run the command
aws ssm start-session --target ...
I have this message :
Starting session with SessionId: user.user@dom0d4ede5d4d251sd37c
Port 3306 opened for sessionId user.user@dom-0w4cde734x221e91c.
Waiting for connections...
in DBeaver I put the cluster endpoint, the port number, the username and the password I have this message from DBeaver :
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
connect timed out
I'm not sure if it's due to ssm endpoint,
I tried to create SSM endpoint following this article :
https://docs.aws.amazon.com/systems-manager/latest/userguide/setup-create-vpc.html
To create VPC endpoints for Systems Manager
In the first step of this procedure, you create three required and one optional interface endpoints for Systems Manager.
Follow the steps in Create an interface endpoint to create the following interface endpoints:
1 - com.amazonaws.region.ssm – The endpoint for the Systems Manager service.
2 - com.amazonaws.region.ec2messages – Systems Manager uses this endpoint to make calls from SSM Agent to the Systems Manager service.
3 - com.amazonaws.region.ec2 –
the endpoint failed to create :
status = Failed
Status message =
private-dns-enabled cannot be set because there is already a conflicting DNS domain for ec2messages.region.amazonaws.com in the VPC vpc-wee1287dvhdvvsj
Status message =
private-dns-enabled cannot be set because there is already a conflicting DNS domain for ssm.region.amazonaws.com in the VPC vpc-wee1287dvhdvvsj
only this endpoint : com.amazonaws.ca-central-1.ec2 was created successfully
I'm not sure if the timeout I get is due to the SSM endpoints.
any idea would help,
thank you!
Thank you for your answer, I checked the vpc DNS are set, the SG group are set also,
in my local machine what I should put in dbeaver tool for hostname? the RDS MYSQL cluster endpoint?
I put 127.0.0.1,1433 as hostname is seems to work, initially I put the cluster endpoint DNS name
Hi Jess, the remote port forwarding forwards the MySQL port to your machine, so you should use "localhost" as your hostname. And whatever local port you've set (I'd recommend 3306 as well)