Articles in this section

Unable to access Plesk with 500 error message: [2002] No such file or directory

Alexander Davydov
Updated
Plesk for Linux kb: technical

Applicable to:

  • Plesk for Linux

Symptoms

  • Unable to log into Plesk with the following error:

    Server Error
    500 Plesk\Exception\Database
    DB query failed: SQLSTATE[HY000] [2002] No such file or directory
    Type Plesk\Exception\Database
    Message DB query failed: SQLSTATE[HY000] [2002] No such file or directory
    File Mysql.php
    Line 64

  • The following error messages can be found in /var/log/messages:

    Jan 28 14:49:37 hostname systemd: Starting MariaDB database server...
    Jan 28 14:49:37 hostname mariadb-prepare-db-dir: The directory /var/log/mariadb does not exist.
    Jan 28 14:49:37 hostname systemd: mariadb.service: control process exited, code=exited status=1
    Jan 28 14:49:37 hostname systemd: Failed to start MariaDB database server.

Cause

Directory /var/log/mariadb is missing on the server.

Resolution

  1. Connect to the server via SSH.

  2. Create the directory /var/log/mariadb:

    # mkdir /var/log/mariadb

  3. Assing correct user and group:

    # chown mysql:mysql /var/log/mariadb

  4. Start MariaDB:

    # systemctl start mariadb

Was this article helpful?

Comments

1 comment
Date Votes
  • Avatar
    Sebastien SCHAFFHAUSER

    systemctl start mariadb
    Job for mariadb.service failed because the control process exited with error code.
    See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.

    0

Please sign in to leave a comment.