Issue SQLSTATE[HY000] [2002] Connection refused:

Discussion in 'Plesk Onyx' started by Jasper_SDC, Jan 12, 2017 at 12:19 AM.

  1. Jasper_SDC

    Jasper_SDC New Pleskian

    3
    20%
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    32
    Location:
    Eindhoven
    Hello guys,

    Im new to Plesk Onyx and its my first VPS... So go easy on me ;)

    The VPS is on Centos 7 with Plesk Onyx 17.0.17, when I reboot the server I get the error below, anyone know how to solve this?

    2017-01-11 22:15:08] ERR [panel] SQLSTATE[HY000] [2002] Connection refused:

    0: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:144

    Zend_Db_Adapter_Pdo_Abstract->_connect()

    1: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php:111

    Zend_Db_Adapter_Pdo_Mysql->_connect()

    2: /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php:460

    Zend_Db_Adapter_Abstract->query(string 'SET sql_mode = ''', array)

    3: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:238

    Zend_Db_Adapter_Pdo_Abstract->query(string 'SET sql_mode = ''', array)

    4: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:30

    Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')

    5: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:90

    CommonPanel_Application_Abstract::initDbAdapter(boolean true)

    6: /usr/local/psa/admin/plib/db.php:10

    db_connect()

    7: /usr/local/psa/admin/plib/modules/watchdog/wdlib.php:1076

    wd__db_connect()

    8: /usr/local/psa/admin/sbin/modules/watchdog/killwdcollect:6

    [2017-01-11 22:15:08] ERR [1] SQLSTATE[HY000] [2002] Connection refused
     
  2. IgorG

    IgorG Forums Analyst Plesk Team

    37
     
    Messages:
    21,978
    Likes Received:
    571
    Trophy Points:
    882
    Location:
    Novosibirsk, Russia
    You need to check why your MySQL server can't start. Look at mysql log, try to restart service at least.
     
  3. Jasper_SDC

    Jasper_SDC New Pleskian

    3
    20%
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    32
    Location:
    Eindhoven
    Hi IgorG,

    Thank you for your reply, I just rebooted the server to see if there are any erros in the mysql log. The error above is still there, but so far as I can see is there no error in the mysql log:

    170112 10:07:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

    170112 10:07:54 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 1758 ...

    170112 10:07:54 InnoDB: The InnoDB memory heap is disabled

    170112 10:07:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins

    170112 10:07:54 InnoDB: Compressed tables use zlib 1.2.7

    170112 10:07:54 InnoDB: Using Linux native AIO

    170112 10:07:54 InnoDB: Initializing buffer pool, size = 128.0M

    170112 10:07:54 InnoDB: Completed initialization of buffer pool

    170112 10:07:54 InnoDB: highest supported file format is Barracuda.

    InnoDB: Log scan progressed past the checkpoint lsn 426118272

    170112 10:07:54 InnoDB: Database was not shut down normally!

    InnoDB: Starting crash recovery.

    InnoDB: Reading tablespace information from the .ibd files...

    InnoDB: Restoring possible half-written data pages from the doublewrite

    InnoDB: buffer...

    InnoDB: Doing recovery: scanned up to log sequence number 426118921

    170112 10:07:55 InnoDB: Starting an apply batch of log records to the database...

    InnoDB: Progress in percents: 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 $

    InnoDB: Apply batch completed

    170112 10:07:56 InnoDB: Waiting for the background threads to start

    170112 10:07:57 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 426118921

    170112 10:07:57 [Note] Plugin 'FEEDBACK' is disabled.

    170112 10:07:57 [Note] Server socket created on IP: '127.0.0.1'.

    170112 10:07:58 [Note] Event Scheduler: Loaded 0 events

    170112 10:07:58 [Note] /usr/libexec/mysqld: ready for connections.

    Version: '5.5.52-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
     

Share This Page

Loading...