Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
jdbc4.CommunicationsException
-
I have some problems. i add sql Datasource and set
driver class name : com.mysql.jdbc.Driver
Connection string : jdbc:mysql://localhost:3306/mt4
*mt4 is database name
and fill Username and passwordi try to Statement test. mango show masage :
- class com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
please Help me?
-
solved
point: For the solutions that you need to change the MySQL settings, you can refer to the following not:Linux: /etc/my.cnf
Windows: D:\Program Files\mysql\bin\my.inicommenting out "skip-networking"
If there is a "skip-networking" line in your MySQL config file, make it comment by adding "#" sign at the beginning of that line. -
Hi te36051,
Interesting! Thanks for sharing the solution. I wasn't familiar with that mysql option. The same problem may be solvable by modifying the connection string to use whatever pipe that configuration was creating. Some relevant information here: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html
But, I would think binding the loopback address (127.0.0.1) would be adequate for most situations.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login