Hi Everyone,
I am first time configuring JDBC connector, I am providing MySQL configuration details as below,
But still I am getting below error while Test Connection.
Could you please assist to fix it ?
Thanks
Hi @hkhandale - is “localhost” the correct host configuration for Database URL?
Hi Harsh,
I guess the VA is a separate VM itself installed on top of your local machine and the DB is installed directly in your local machine.
For the VA to connect to your DB installed on your local machine, you need to use the IP address, something like this - instead of localhost:33006 try IP address:3306 (example: 192.165.2.1:3306)
Hi @Snaren951 ,
I am using JDBC SaaS and for that we don’t required to configure VA in IDN , i tried localhost ip of machine still it is giving me same error.
but when i fetch it via JAVA in intelliJ it is working fine.
Hi @hkhandale Is the root MySQL user you are using able to connect from all hosts ie:
root@%
rather than
root@localhost
use
SELECT user,host FROM mysql.user;
on the MySQL command prompt to check
And make sure you are using the actual hostname (or IP), rather than localhost, in the database url.
Hi @j_place , No root is username of MySQL, i am using same in IIQ and it is working fine in IIQ.
Hi @hkhandale the root user may have been scoped to the IIQ server as IIQ has fixed IP address. I would still suggest that you check it can connect from all hosts (clients).
1 Like
Hi @hkhandale
In general the Communication link failure error indicates whether the database server is down or something is wrong with the credentials can u check through them once
Thanks
Tulasi
@hkhandale Hi Harsh, I don’t think the JDBC Saas connector will work for this scenario. Given that it is a locally hosted DB (which isn’t publicly available), You need to use a JDBC connector, not the JDBC Saas connector.