Upgrade fails because unable to estabilish connection to APS database via ODBC

Refers to:

  • Plesk 10.4 for Linux
  • Plesk 11.5 for Linux

Created:

2016-11-16 12:59:26 UTC

Modified:

2016-12-21 19:42:20 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Upgrade fails because unable to estabilish connection to APS database via ODBC

Symptoms

The upgrade fails and displays the following error messages in the log:

     Trying to set up APS controller database... Attempting to check APS db connection via ODBC, using /usr/bin/isql (empty output is good) 
[ISQL]ERROR: Could not SQLConnect
Failed, rc = 1.
Failed to establish test connection. Cleaning up.

ERROR while trying to establish test connection to APS database via ODBC
Check the error reason(see log file: /tmp/plesk_10.3.0_installation.log), fix and try again

Diagnosis

  1. Check that the MySQL server is running:

    # /etc/init.d/mysqld status
  2. Check that the MySQL server is accepting connections via TCP IP:

    # mysql -h 127.0.0.1 -P 3306 -uadmin -p`cat /etc/psa/.psa.shadow`

Resolution

If the MySQL server is stopped, it should be started with the following command:

    # /etc/init.d/mysqld start

The MySQL server may not be accepting connections via TCP IP because of your firewall settings, network link or MySQL server settings.For the MySQL server settings, you can check the /etc/my.cnf folder for the "skip-networking" parameter. If this parameter is present, then the MySQL server will not accept network connections via TCP.To enable TCP connections, comment on the "skip-networking" parameter by adding the "#" character ("#skip-networking"). After adding the character, restart the MySQL server by the following command:

    # /etc/init.d/mysqld restart
Have more questions? Submit a request
Please sign in to leave a comment.