Unable to create subscription

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux
  • MT:2ea0cd4d2fa671572c92a836c0704b2f
  • MG:399a3bb8ccd3539d69e021f623bd27ab
  • MT:8487cd279b6c23295fa0afef6078a5bd
  • MG:07dd9968eeafdc3a09597fd71fb494aa
  • MT:a7d037106dee51f681daf0c209124ab1
  • MT:17f5c6fe642058beca113939d25c9e20
  • MG:3331c9de17024c252dfe55f898730404
  • MT:8299c72121623ce98c2e6d438f9ecdbc
  • MT:e26d6c16389a5e927469ff90abc5c8d1

Created:

2016-11-16 13:09:42 UTC

Modified:

2017-02-13 06:36:31 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create subscription

Symptoms

Unable to create subscription in Plesk. One of the either errors (or both) occurs:

Exception: Cannot load library: /usr/lib64/libmysqlserver.so.2
file: /usr/share/aps_php/aps_php.php
line: 11933
code: 0

Or:

Exception: ODBC error #01000: [unixODBC][Driver Manager]Can't open lib '/usr/lib64/odbc/libmyodbc.so' : file not found 
file: /usr/share/aps_php/aps_php.php line: 11933

Or the following error can be found in /var/log/plesk/install/plesk_12.5.30_repair.log file:

Connection to APSC DB is not possible: Cannot load library: /usr/lib/x86_64-linux-gnu/libmysqlserver.so.2

Cause

Libraries libmysqlserver.so.2 and/or libmyodbc.so are/is not located in /usr/lib64/ directory or by some reason ODBC library is not compatible with running MySQL server version.

Resolution

  1. Find the location of mentioned libraries:

    # find / \\( -name libmysqlserver.so.2 -o -name libmyodbc.so \\) -print 2>/dev/null
    /usr/lib64/libmysqlserver.so.2
    /usr/lib64/odbc/libmyodbc.so
  2. Correct location path of libmysqlserver.so.2 library in /etc/psa/psa.conf to existing one:

    # grep -i APS_DB_DRIVER_LIBRARY /etc/psa/psa.conf
    APS_DB_DRIVER_LIBRARY /usr/lib64/libmysqlserver.so.2
  3. Correct driver path for libmyodbc5.so in /etc/odbcinst.ini :

    # less /etc/odbcinst.ini:
    [MySQL]
    Description = MySQL driver for Plesk
    Driver = /usr/lib/libmyodbc5.so
    Setup =
    FileUsage = 1
    Driver64 =
    Setup64 =
    UsageCount = 1
  4. In case if find utility does not return the path of a package, try to install it using yum utility:

    # yum provides */libmysqlserver.so.2
    Loaded plugins: fastestmirror
    Loading mirror speeds from cached hostfile
    * base: mirror.yandex.ru
    * extras: mirror.yandex.ru
    * updates: mirror.yandex.ru
    updates/filelists_db | 1.6 MB 00:00
    rdbmspp-2.0-735641.13073116.x86_64 : rdbms++ Database Isolation Library
    Repo : installed
    Matched from:
    Filename : /usr/lib64/libmysqlserver.so.2

    # yum install rdbmspp-2.0-735641.13073116.x86_64

NOTE: The library may be provided by a different package on your system. Install the appropriate one.

If steps above was not helped:

  1. Download ODBC driver from MySQL site for your system.
  2. Unpack it and put libmyodbc5w.so file into driver path from /etc/odbcinst.ini file.
  3. Modify /etc/odbcinst.ini file and set
    Driver      = /usr/lib/libmyodbc5w.so
Have more questions? Submit a request
Please sign in to leave a comment.