JDBC Test connection error

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

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

2

Hi @saikumar39,

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

3

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.

4

Hi @jesvin90 ,

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

5

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

6

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

3 Likes