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

Created:

2016-11-16 13:05:36 UTC

Modified:

2017-08-08 13:24:04 UTC

0

Was this article helpful?


Have more questions?

Enviar una solicitud

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

Applicable to:

  • Plesk for Linux/Unix

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
¿Tiene más preguntas? Enviar una solicitud
Inicie sesión para dejar un comentario.