Wordpress and missing MYSQL db problem

busterkat

Active Member
Aug 20, 2007
41
0
56
NY
Hello,

Two wp installations have been returning "Error establishing a database connection".

One of them (ABC) shows no databases or users set up.
The other( DEF) shows the corrects database and user.

Both are unreachable and went down almost simultaneously.
Last action I performed was an attempted wp update via cpanel.

These items in my error_log refer:

Code:
[2014-10-06 14:33:40 -0400] warn [cpwrap] cpwrap is deprecated, please use Cpanel::Wrap instead, caller info: [pid]=[31436] [exe]=[] [cmdline]=[/usr/local/cpanel/3rdparty/bin/perl /usr/local/cpanel/whostmgr/docroot/cgi/cpaddons_report.pl] cwd=[/] at bin/cpwrap line 66
[2014-10-06 14:33:40 -0400] info [cpmysql] Dropping MySQL database abc_wp1 for user ABC
[2014-10-06 14:33:40 -0400] warn [cpwrap] cpwrap is deprecated, please use Cpanel::Wrap instead, caller info: [pid]=[31436] [exe]=[] [cmdline]=[/usr/local/cpanel/3rdparty/bin/perl /usr/local/cpanel/whostmgr/docroot/cgi/cpaddons_report.pl] cwd=[/] at bin/cpwrap line 66
[2014-10-06 14:33:40 -0400] info [cpmysql] MYSQL: Remove dbuser ABC_wp1 for owner ABC on 178.3xxcc.10
[2014-10-06 14:33:40 -0400] warn [servers_queue] Cannot queue task dbstoregrants binval ( no id, probably a duplicate ) at /usr/local/cpanel/Cpanel/LoggerAdapter.pm line 26
	Cpanel::LoggerAdapter::warn(Cpanel::LoggerAdapter=HASH(0x1ca8748), 'Cannot queue task dbstoregrants ABC ( no id, probably a duplicate )') called at /usr/local/cpanel/bin/servers_queue line 90
	main::queue_tasks('dbstoregrants binval') called at /usr/local/cpanel/bin/servers_queue line 75
[2014-10-07 15:07:36 -0400] info [cpses_tool] MYSQL: Remove dbuser cpses_biwbp9vAeU for owner ABC on 174.3xxcc.10
[2014-10-07 15:11:47 -0400] info [cpses_tool] MYSQL: Remove dbuser cpses_glo67sphCD for owner DEF on 174.3xxcc.10

I read this post, https://forums.cpanel.net/f185/mysq...lso-wordpress-wp-config-php-files-431191.html but the mapping tool says
ABC_wp1 does not exist in the database
.

CP MYSQL Databases show no dbs or users for ABC.

I don't know how to fix this.

Really need help please.

I see this in error file:

Code:
141007 14:50:05 [ERROR] /usr/sbin/mysqld: Table './gladdev_wp/wp_options' is marked as crashed and should be repaired
141007 14:53:10 [Note] /usr/sbin/mysqld: Normal shutdown

141007 14:53:10 [Note] Event Scheduler: Purging the queue. 0 events
141007 14:53:10  InnoDB: Starting shutdown...
141007 14:53:13  InnoDB: Shutdown completed; log sequence number 0 37294568
141007 14:53:13 [Note] /usr/sbin/mysqld: Shutdown complete

141007 14:53:13 mysqld_safe mysqld from pid file /var/lib/mysql/server1.xyz.net.pid ended
141007 14:53:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141007 14:53:14 [Note] Plugin 'FEDERATED' is disabled.
141007 14:53:14  InnoDB: Initializing buffer pool, size = 8.0M
141007 14:53:14  InnoDB: Completed initialization of buffer pool
141007 14:53:14  InnoDB: Started; log sequence number 0 37294568
141007 14:53:14 [Note] Event Scheduler: Loaded 0 events
141007 14:53:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.73-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPLv2)
141007 14:55:04 [ERROR] /usr/sbin/mysqld: Table './def_wp/wp_options' is marked as crashed and should be repaired
One of the databases in question is NOT in /var/lib/mysql/ !

Help please

Repaired wp_options table table in database def which fixed issue for that.

Problem continues with database abc
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
Hello :)

Do you have a backup of the account or database available so you can restore the database? It will likely need to be restored if it does not exist in the /var/lib/mysql directory.

Thank you.
 

busterkat

Active Member
Aug 20, 2007
41
0
56
NY
mysql> use abc_wp1
ERROR 1049 (42000): Unknown database 'abc_wp1'
mysql> Write failed: Broken pipe

I have a backup of the account in /backup/cpbackup/monthly/abc/mysql.

I need to know how and why this happened and how to fix it.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
You could review the cPanel access log to see if someone with access to that account removed the database. It's located at:

/usr/local/cpanel/logs/access_log

You would need to use "grep" to search for the account username to help filter down the results.

Thank you.
 

busterkat

Active Member
Aug 20, 2007
41
0
56
NY
Don't see in the access_log where db was removed .

Looked in the bad behavior table in the backup dump and there are what looks like (in my not expert opinion) huge number of links spams and other unhealthy stuff
Code:
登录\nredirect_to: http://www.cnseay.com/wp-admin/\ntestcookie: 1\n','17566707'),(144530,'195.78.211.2','2014-09-24 01:00:21','HEAD','/','HTTP/1.0','HEAD / HTTP/1.0\n','','','00000000'),(144531,'100.43.81.129','2014-09-24 01:31:00','GET','/robots.txt','HTTP/1.1','GET /robots.txt HTTP/1.1\nConnection: Keep-Alive\nFrom: [email protected]\nHost: www.youvebeenvalidated.com\nUser-Agent: Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)\n','Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)','','17566707'),(144296,'119.63.193.195','2014-09-21 04:55:02
All sorts of junk in the wp_users table .

wp_options table etc,etc
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
cPanel does not remove databases automatically. It's possible the database was dropped by someone with access to do so, or you may want to see if it's possible the account was exploited.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
There's no single method of determining if an account was hacked. You can try searching for "wordpress hacked" on our forums or elsewhere to see how others determined the source of the attack. You can review the domain access logs for the account to see if you notice anything out of the ordinary.

Thank you.