Unable to access Plesk: psaerror(string 'Unable to connect to database: mysql_connect()

Created:

2016-11-16 13:05:36 UTC

Modified:

2016-12-21 19:56:16 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to access Plesk: psaerror(string 'Unable to connect to database: mysql_connect()

Symptoms

  • Unable to log in to Plesk, the following error is shown:

    ERROR: PleskFatalException
    Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory

    0: common_func.php3:153
    psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory')
    1: auth.php3:112
  • Unable to login to MySql, the following error is show:

    "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"
  • The following warning can be observed in the /var/log/mysql/error.log :

    140410 17:32:26InnoDB: Warning: difficult to find free blocks from
    InnoDB: the buffer pool (986 search iterations)! Consider
    InnoDB: increasing the buffer pool size.
    InnoDB: It is also possible that in your Unix version
    InnoDB: fsync is very slow, or completely frozen inside
    InnoDB: the OS kernel. Then upgrading to a newer version
    InnoDB: of your operating system may help. Look at the
    InnoDB: number of fsyncs in diagnostic info below.
    InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0
    InnoDB: 139 OS file reads, 0 OS file writes, 0 OS fsyncs
    InnoDB: Starting InnoDB Monitor to print further
    InnoDB: diagnostics to the standard output.

Cause

MySql service fails to start.

Resolution

Increase innodb_buffer_pool_size in the my.cnf configuration file, you may set it to 100M.

# grep innodb_buffer_pool_size /etc/mysql/my.cnf
innodb_buffer_pool_size=100M
innodb_buffer_pool_size=100M
Have more questions? Submit a request
Please sign in to leave a comment.