Articles in this section

See more

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

Avatar
Alex Davydov
Updated
Follow
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

Comments

6 comments

Sort by Date Votes
  • Avatar
    heidarymr

    f

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

    f

    systemctl status mariadb.service
    ● mariadb.service - MariaDB 10.1.48 database server
    Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
    Active: failed (Result: exit-code) since Thu 2021-10-28 12:38:48 +0330; 4s ago
    Docs: man:mysqld(8)
    https://mariadb.com/kb/en/library/systemd/
    Process: 16732 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
    Process: 16650 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSRE
    Process: 16647 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 16640 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Main PID: 16732 (code=exited, status=1/FAILURE)
    Status: "MariaDB server is down"

    Oct 28 12:38:45 ... systemd[1]: Starting MariaDB 10.1.48 database server...
    Oct 28 12:38:45 ... mysqld[16732]: 2021-10-28 12:38:45 140204800543872 [Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0ubuntu0.18.04.1) starting as process 16732 ...
    Oct 28 12:38:48 ... systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
    Oct 28 12:38:48 ... systemd[1]: mariadb.service: Failed with result 'exit-code'.
    Oct 28 12:38:48 ... systemd[1]: Failed to start MariaDB 10.1.48 database server.

     

     

     

     

     

    0
    Comment actions Permalink
  • Avatar
    Reo Wulf


    root@hopeful-khorana:~# mkdir /var/log/mariadb
    root@hopeful-khorana:~# chown mysql:mysql /var/log/mariadb
    root@hopeful-khorana:~# systemctl start mariadb
    Failed to start mariadb.service: Unit mariadb.service not found.

    0
    Comment actions Permalink
  • Avatar
    Fernando Macías (Edited )

    xxxx:~# mkdir /var/log/mariadb
    mkdir: cannot create directory ‘/var/log/mariadb’: File exists
    xxxx:~# chown mysql:mysql /var/log/mariadb
    xxxx:~# systemctl start mariadb
    Failed to start mariadb.service: Unit mariadb.service failed to load: No such file or directory.

    no se ha reparado el error. Todo sigue igual el directorio ya exite pero no arranca el servicio mariadb
    Al mirar el estado de mariadb.... dice DEAD.  que ha pasado??

    ● mariadb.service
       Loaded: not-found (Reason: No such file or directory)
       Active: inactive (dead)

    Sep 02 20:27:48 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:27:54 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:27:59 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:04 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:09 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:15 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:20 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:25 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:30 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:36 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.

    0
    Comment actions Permalink
  • Avatar
    Muhammad Farooqi

    This is the error I'm getting after this command. 

    root@host:/var/lib/mysql# chown mysql:mysql /var/log/mariadb/
    root@host:/var/lib/mysql# systemctl start mariadb
    Job for mariadb.service failed because a fatal signal was delivered to the control process.
    See "systemctl status mariadb.service" and "journalctl -xe" for details.
    and this is systemctl status mariadb.service response


    ● mariadb.service - MariaDB 10.3.34 database server
         Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
         Active: activating (start) since Sat 2022-09-10 05:48:47 UTC; 526ms ago
           Docs: man:mysqld(8)
                 https://mariadb.com/kb/en/library/systemd/
        Process: 350186 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
        Process: 350190 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
        Process: 350201 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP>
       Main PID: 350266 (mysqld)
          Tasks: 15 (limit: 9439)
         Memory: 57.3M
         CGroup: /system.slice/mariadb.service
                 └─350266 /usr/sbin/mysqld



    Sep 10 05:48:47 host systemd[1]: Starting MariaDB 10.3.34 database server...
    Sep 10 05:48:47 host mysqld[350266]: 2022-09-10  5:48:47 0 [Note] /usr/sbin/mysqld (mysqld 10.3.34-MariaDB-0ubuntu0.20.04.1) starting as process 350266 ...

    And this is the journalctl -xe response 

    root@host:/var/lib/mysql# journalctl -xe

    -- Support: http://www.ubuntu.com/support

    -- 

    -- The unit mariadb.service has entered the 'failed' state with result 'signal'.

    Sep 10 05:50:41 host systemd[1]: Failed to start MariaDB 10.3.34 database server.

    -- Subject: A start job for unit mariadb.service has failed

    -- Defined-By: systemd

    -- Support: http://www.ubuntu.com/support

    -- 

    -- A start job for unit mariadb.service has finished with a failure.

    -- 

    -- The job identifier is 488407 and the job result is failed.

    Sep 10 05:50:41 host systemd[1]: Started Plesk Web Socket Service.

    -- Subject: A start job for unit plesk-web-socket.service has finished successfully

    -- Defined-By: systemd

    -- Support: http://www.ubuntu.com/support

    -- 

    -- A start job for unit plesk-web-socket.service has finished successfully.

    -- 

    -- The job identifier is 488488.

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: [2022-09-10 05:50:41.218] 351309:631c25b1350d2 ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:103

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         CommonPanel_Application_Abstract::initDbAdapter()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 2: /opt/psa/admin/plib/Session/Helper.php:176

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         Plesk\Session\Helper::initStorage()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 3: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:52

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         CommonPanel_Application_Abstract->run()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 4: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:34

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         CommonPanel_Application_Abstract::init()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 5: /opt/psa/admin/plib/pm/Bootstrap.php:16

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         pm_Bootstrap::init()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 6: /opt/psa/admin/plib/sdk.php:11

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         require_once(string '/opt/psa/admin/plib/sdk.php')

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 7: /opt/psa/admin/plib/WebSocket/bin/ws-server.php:3

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] No such file or directory (Mysql.php:79)

    Sep 10 05:50:41 host systemd[1]: plesk-web-socket.service: Main process exited, code=exited, status=1/FAILURE

    lines 2881-2917/2930 100%
    0
    Comment actions Permalink
  • Avatar
    IONOS Support
    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 79
    0
    Comment actions Permalink
  • Avatar
    Badreddine KHEDER

    [root@server ~]# mkdir /var/log/mariadb
    mkdir: cannot create directory ‘/var/log/mariadb’: File exists
    [root@server ~]# chown mysql:mysql /var/log/mariadb
    [root@server ~]# systemctl start mariadb
    Failed to start mariadb.service: Unit mariadb.service not found.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles