Hello Community,
I m trying to set up a JDBC connector to connect to a Mysql database i configured everything well.
I pinged the db host on the VA and it was good,
I also checked with nc -zv the 3306 port and it was good also
but when i try to do the test connection from ISC it gives me the error below:
“Timeout waiting for response to message 1 from client XXXX after 15 seconds.”
Does anybody know how can i resolve this problem please ?
@torry_salamat , try enabling logging for your connector and check the ccg.log file to see what exactly the issue is.
Just like that, it’s difficult to know what the issues might be.
Please get the connector configuration details and make sure you have correct jar file in place, and you have the correct driver class name as mentioned below.
Database URL? try with IP as well as hostname.
jdbc:mysql://<hostname_or_IP>:<port>/<database_name>
Driver Class? make sure you have correct driver class
and Driver jar file name., make sure you have re-uploaded the clean and latest jar file.
Hello @pattabhi, Thank you for your answer, i already checked all of this configuration twice but i don’t see any problem with it i even reuploaded the jar file do you have anything to check apart of this please?
Hi, thank you for your answer, i already enabled it but i don’t see any particular exceptions
Hi @torry_salamat ,
I recently faced similar issue while Test connection on JDBC connector It seems to be firewall blocking issue. Make sure you are able to access DB server from all VA instances. Normally, its network issue.
Hi Tony,
Can you share the ccg.log when you do the test connection ?
Thanks
I have a problem with ccg i can see the docker image but when i tap this command: sudo systemctl status ccg i get Unit ccg.service could not be found
i already confirmed with the network team it has nothing to do with firewall unfortunately
Hi Tony,
Is your Virtual Appliance in Connected state ? Can you please share the screenshot for the same ?
Thanks
Hey,
I dont see the last contact. the CCG Number and IP Address as well. There seems some issue related to Virtual Appliance. Below is the screenshot of Connected VA.
try doing sudo systemctl restart ccg
and sudo restart and test again
can you confirm, your virtual appliance ccg is available in cluster.
you can restart your CCG using below command and try again.
sudo systemctl restart ccg
Hello when i do a sudo docker ps -a | grep ccg => it says that ccg exited 4 hours ago i think it stops every now and then.. When i tried to restart ccg with your command it says : ccg.service not found
Hello again Rakesh, thank you for your answer, yeah sorry i just removed it with paint but it’s like what you are showing me
What about other applications in your tenant, those are working fine with the same cluster,
Hello again,
It was indeed the ccg i started it with sudo docker start ccg and the timeout got resolved thanks again for pointing out that it was from ccg
