Issue SQLSTATE[HY000] [2002] Connection refused:

[Jasper_SDC]

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

 

[IgorG]

You need to check why your MySQL server can't start. Look at mysql log, try to restart service at least.

 

[Jasper_SDC]

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