Unable to login the Plesk Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 12:46:47 UTC

Modified:

2016-12-21 19:11:37 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to login the Plesk Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)

Symptoms

Unable to login to Plesk. The following error appears:

Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)

Websites shows blank pages or "Unable to connect to database" error.

Despite on this Mysql engine can be successfully started:

# /etc/init.d/mysql start
* Starting MySQL database server mysqld [ OK ]

Cause

Mysql configuration file is broken.

Resolution

  1. Download mysql-libs rpm package from Centos repository .For Centos 6 x64 it is http://mirror.centos.org/centos/6.6/os/x86_64/Packages/ :

    # mkdir test && cd test
    # wget http://mirror.centos.org/centos/6.6/os/x86_64/Packages/mysql-libs-5.1.73-3.el6_5.x86_64.rpm
  2. Extract RPM file using rpm2cpio and cpio command:

    # rpm2cpio mysql-libs-5.1.73-3.el6_5.x86_64.rpm | cpio -idmv
  3. Backup current mysql configuration file and replace it default one:

    # cp /etc/my.cnf /etc/my.cnf_backup
    # cp ./etc/my.cnf /etc/my.cnf
  4. Make sure to add specific parameters in each section for innodb :

    # cat /etc/my.cnf

    [mysqld]
    local-infile=0
    ...
    innodb_buffer_pool_size=2M
    innodb_additional_mem_pool_size=500K
    innodb_log_buffer_size=500K
    innodb_thread_concurrency=2

    [mysqld_safe]
    ...
    innodb_buffer_pool_size=2M
    innodb_additional_mem_pool_size=500K
    innodb_log_buffer_size=500K
    innodb_thread_concurrency=2
Have more questions? Submit a request
Please sign in to leave a comment.