JDBC Test connection error

[saikumar39 (sai kumar)]

Hi ,

I was trying to onboard a JDBC application with MYSQL Database and getting below error.

Error Received:

[ ConnectorException ] [ Error details ] The server encountered an unexpected error while contacting target system during test configuration operation. Please check the logs. null, message from server: “Host ‘100.100.100.146’ is not allowed to connect to this MySQL server”

Any one have idea about above error ?

Thanks,
Saikumar

[jesvin90 (Jesvin Joseph)]

Hi @saikumar39,

Have you enabled the firewall traffic between your VA and the Database server.?

[kjakubiak (Kamil Jakubiak)]

When creating user in MySQL you have to explicitly allow him to connect remotely to the database

CREATE USER 'sammy'@'remote_server_ip' IDENTIFIED BY 'password';

part after @ is important you can also use % as wildcard.

[saikumar39 (sai kumar)]

@saikumar39

e have idea about above error ?

Hi @jesvin90 ,

All IP’s are internal ip’s.
There will be no firewall between them

[amansingh (Aman Kumar Singh)]

Is your VA’s IP sddress whitelisted to connect to the mysql server?

[Shanmukh (Shanmukh Gali)]

Hi @saikumar39,

Have you tried the below troubleshooting steps:

1. Verify the IP address is whitelisted.
2. Verify the hostname is whitelisted.
3. Verify if IP address and hostname is reachable from VA.
4. Check if there is any TLS enabled on DB side and try to establish TLS connection by adding the cert on VA and using the JDBC TLS URL.

Thank you.
Shanmukh Gali