Cannot connect from Glue to RDS MYSQL

Question

Hello, I'm trying to connect from Glue to Mysql, when testing the connection I'm getting the following error:
ERROR StatusLogger Unrecognized format specifier [d]
ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [thread]
ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [level]
ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [logger]
ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [msg]
ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [n]
ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [d]
ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [thread]
ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [level]
ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [logger]
ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [msg]
ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [n]
ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

*** I can connect to the database from my laptop, also the inbound &outbound have rules referencing the SG. please help me.

re:Post Agent · Answer

The error messages you're seeing are related to the test connection functionality in AWS Glue, which is known to use older drivers that may produce these log messages. These particular error messages don't necessarily indicate a connection problem, but rather issues with the logging format specifiers.

To troubleshoot the connection issue between AWS Glue and your RDS MySQL instance, consider the following steps:

1. Verify that the security group associated with your RDS MySQL instance allows inbound connections from the AWS Glue service. Ensure that the appropriate ports (typically 3306 for MySQL) are open.

2. Check if your RDS MySQL instance is in a private subnet. If so, make sure that AWS Glue has the necessary network access, possibly through a NAT Gateway.

3. Confirm that the IAM role used by AWS Glue has the required permissions to access the RDS MySQL instance.

4. Instead of relying solely on the test connection feature, try creating an actual AWS Glue job or notebook to test the connection. This approach uses more up-to-date drivers and may provide more accurate results.

5. If you're still encountering issues, review the VPC configuration to ensure proper routing between AWS Glue and your RDS MySQL instance.

6. Consider checking the RDS MySQL instance logs for any connection-related errors that might provide more insight into the issue.

If the problem persists after trying these steps, you may need to engage AWS support for further assistance, as there could be more complex networking or configuration issues at play.  
**Sources**  
[Can't create Glue Connection to RDS MySQL - [Error] Failed to test connection due to FAILED status. | AWS re:Post](https://repost.aws/questions/QUII9-vGBPQ0OwbOuk00M68g/can-t-create-glue-connection-to-rds-mysql-error-failed-to-test-connection-due-to-failed-status)  
[Troubleshooting connections to your MySQL DB instance - Amazon Relational Database Service](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToInstance.Troubleshooting.html)

Cannot connect from Glue to RDS MYSQL

Relevant content