Atomicorp

Security for Everyone
https://forums.atomicorp.com/

ERROR: PleskFatalException: Unable to connect to database

https://forums.atomicorp.com/viewtopic.php?t=7503

Page 1 of 1

ERROR: PleskFatalException: Unable to connect to database

Posted: Wed Feb 12, 2014 5:30 pm
by 12lamat
Hello, my server seems to have problems with mysql

ERROR: PleskFatalException: Unable to connect to database: mysql_connect(): No such file or directory (auth.php:142)

I performed a yum update and i think mysql had an update!

This is what i get when i go to a joomla website:
Error displaying the error page: Application Instantiation Error

or on another webpage it states not able to connect to database.

And i als o got this in plesk CP
ERROR: Zend_Controller_Exception: SQLSTATE[HY000] [2002] Connection refused#0 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(109): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php(459): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array)
#3 /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(19): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select), Array)
#4 /usr/local/psa/admin/externals/Zend/Db/Table/Abstract.php(1534): Db_Adapter_Pdo_Mysql->query(Object(Zend_Db_Table_Select))
#5 /usr/local/psa/admin/externals/Zend/Db/Table/Abstract.php(1349): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select))
#6 /usr/local/psa/admin/plib/CommonPanel/Controller/Helper/Front.php(77): Zend_Db_Table_Abstract->fetchAll()
#7 /usr/local/psa/admin/plib/CommonPanel/Controller/Action/Abstract.php(62): CommonPanel_Controller_Helper_Front::appendGlobalIncludes(Object(Zend_View))
#8 /usr/local/psa/admin/plib/AdminPanel/Controller/Action/Abstract.php(30): CommonPanel_Controller_Action_Abstract->init()
#9 /usr/local/psa/admin/plib/AdminPanel/Controller/Action/Admin.php(55): AdminPanel_Controller_Action_Abstract->init()
#10 /usr/local/psa/admin/panel/application/controllers/ErrorController.php(17): AdminPanel_Controller_Action_Admin->init()
#11 /usr/local/psa/admin/externals/Zend/Controller/Action.php(133): ErrorController->init()
#12 /usr/local/psa/admin/externals/Zend/Controller/Dispatcher/Standard.php(268): Zend_Controller_Action->__construct(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http), Array)
#13 /usr/local/psa/admin/externals/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#14 /usr/local/psa/admin/plib/AdminPanel/Application/Web.php(21): Zend_Controller_Front->dispatch()
#15 /usr/local/psa/admin/panel/application/public/index.php(14): AdminPanel_Application_Web->run()
#16 {main}

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
MySQL query failed: (Broker.php:336)

What can i do?

Re: ERROR: PleskFatalException: Unable to connect to databas

Posted: Wed Feb 12, 2014 6:58 pm
by mikeshinn
Whats the output of each step in this article:

https://www.atomicorp.com/wiki/index.ph ... 7.0.0.1.27

Re: ERROR: PleskFatalException: Unable to connect to databas

Posted: Wed Feb 12, 2014 7:51 pm
by 12lamat
ps auxwww | grep mysql
mysql 16414 24.2 0.2 773168 45960 pts/0 Sl 00:05 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-grant-tables --log-error=/var/lib/mysql/tinywebserver914.net.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 16434 0.0 0.0 103316 836 pts/1 S+ 00:05 0:00 grep mysql
root 37482 1.2 0.0 108924 3940 pts/0 S Feb12 2:03 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error= --pid-file=/var/run/mysqld/mysqld.pid --user=mysql --skip-grant-tables

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 18018/mysqld
tcp 0 0 127.0.0.1:3306 127.0.0.1:37966 TIME_WAIT -
tcp 0 0 127.0.0.1:37967 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:37999 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:38010 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:3306 127.0.0.1:37980 TIME_WAIT -
tcp 0 0 127.0.0.1:37972 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:3306 127.0.0.1:38002 TIME_WAIT -
tcp 0 0 127.0.0.1:37984 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:38003 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:37990 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:37981 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:38015 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:38001 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:38008 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:37996 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:38000 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:37991 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:37993 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:3306 127.0.0.1:37977 TIME_WAIT -
tcp 0 0 127.0.0.1:37987 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:38004 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:3306 127.0.0.1:37971 TIME_WAIT -
tcp 0 0 127.0.0.1:37963 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:37978 127.0.0.1:3306 TIME_WAIT -

my.conf file as attachement

After changinng OSSEC_DATABASE_SERVER to server IP in ASL configuration I got this:
netstat -anp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 24892/mysqld
tcp 0 0 5.79.64.229:3306 5.79.64.229:51505 TIME_WAIT -
tcp 0 0 5.79.64.229:51448 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51467 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:3306 5.79.64.229:51512 TIME_WAIT -
tcp 0 0 5.79.64.229:51460 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:3306 5.79.64.229:51469 FIN_WAIT2 -
tcp 0 0 5.79.64.229:51459 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51468 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51447 5.79.64.229:3306 TIME_WAIT -
tcp 1 0 5.79.64.229:51469 5.79.64.229:3306 CLOSE_WAIT 22316/tortixd
tcp 0 0 5.79.64.229:3306 5.79.64.229:51519 ESTABLISHED 24892/mysqld
tcp 0 86 5.79.64.229:51519 5.79.64.229:3306 ESTABLISHED 24554/ossec-dbd
tcp 0 0 5.79.64.229:51458 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:3306 5.79.64.229:51463 TIME_WAIT -
tcp 0 0 5.79.64.229:51461 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51462 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51510 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51503 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51464 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51449 5.79.64.229:3306 TIME_WAIT

/etc/init.d/mysqld restart
Stoppen van mysqld: [ OK ]
Starten van mysqld: [ OK ]
-

grep skip-networking /etc/my.cnf

/etc/init.d/mysqld restart
Stoppen van mysqld: [ OK ]
Starten van mysqld: [ OK ]
[root@tinywebserver914 ~]# /etc/init.d/ossec-hids restart
Shutting down ossec-hids: [ OK ]
Starting ossec-hids: [ OK ]

netstat -anp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 27476/mysqld
tcp 0 0 5.79.64.229:51813 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51816 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51838 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51829 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51826 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51822 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51841 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51828 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51833 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:3306 5.79.64.229:51815 TIME_WAIT -
tcp 0 0 5.79.64.229:51849 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51825 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51821 5.79.64.229:3306 ESTABLISHED 27383/ossec-dbd
tcp 0 0 5.79.64.229:51834 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51831 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51823 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51837 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51835 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51827 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51862 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:3306 5.79.64.229:51821 ESTABLISHED 27476/mysqld
tcp 0 0 5.79.64.229:51814 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51824 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51839 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:51830 5.79.64.229:3306 TIME_WAIT -

telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
R
5.5.36-cll-lve]aPMqoY�h8{)US~Bjqx+mysql_native_passwordConnection closed by foreign host.

/etc/init.d/iptables stop
iptables: Instellen van regels naar beleid ACCEPT: raw mang[ OK ]ilter
iptables: Wissen van firewall regels: [ OK ]
iptables: Verwijderen van modules: iptable_raw iptable_man[MISLUKT]le_nat
[root@tinywebserver914 ~]# netstat -anp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 34903/mysqld
tcp 0 0 5.79.64.229:52351 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:39577 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:52390 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:39587 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:39580 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:39579 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:3306 127.0.0.1:39584 ESTABLISHED 34903/mysqld
tcp 0 0 127.0.0.1:39588 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:39589 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:39578 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:39576 127.0.0.1:3306 TIME_WAIT -
tcp 0 89 127.0.0.1:39584 127.0.0.1:3306 ESTABLISHED 34190/ossec-dbd
tcp 0 0 5.79.64.229:52389 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:52391 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:39586 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:39585 127.0.0.1:3306 TIME_WAIT -
tcp 0 0 5.79.64.229:52388 5.79.64.229:3306 TIME_WAIT -
tcp 0 0 127.0.0.1:3306 127.0.0.1:39563 TIME_WAIT -
All times are UTC-04:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited