MySQL error when starting the Xchange Network Server

Question:
Why do I get the error: "The integrated MySQL instance is not currently running. Please ensure that the mysqld process is running and then start the Xchange Network server again." when starting the Xchange Network server?

Answer:
The Xchange Network Server startup script outputs this error when it is unable to connect to MySQL or when 'netstat' does not report anything listening on port 3306.

Reasons:

1.  The MySQL instance you have chosen to integrate with is currently not running.  Try starting it and then execute the startxcnetwork.sh script again.

2.  If the MySQL instance is definitely running and you continue to receive this message it is most likely due to having TCP/IP connections disabled in MySQL.  The Xchange Network server needs to communicate with MySQL via TCP/IP.  To check if this is the case, login to MySQL and execute the command 'SHOW VARIABLES;'.  Look for the line:

| port                            | [value]

If [value] is 0, then you most likely have TCP/IP connections disabled.  To resolve this, look for the --skip-networking flag in the MySQL startup script you are using, or look for:

[mysqld]
...
skip-networking

in the my.cnf file that MySQL uses (usually /etc/my.cnf).  If the 'skip-networking' argument is present in either place, please remove it and then restart the MySQL server.

The goal is to get a response to executing the command:
netstat -a -n | grep 3306.*LISTEN

like:
tcp        0      0 0.0.0.0:3306           0.0.0.0:*               LISTEN

Once you get a result like the one above, it means MySQL is listening on port 3306 and you should be able to start the server without error.

If you still cannot get MySQL to listen on port 3306, or have any other questions or concerns please contact support for assistance.

Please rate this article (1 being worst, 5 being best):
1 2 3 4 5

Click here to send specific feedback about this article.

home products buy now try now xc bridge partners support contact about us knowledge base site map privacy