PDA

View Full Version : Attacked maybe? A few server errors (220 of them) for 4 hours, but everything AOK...


dieslcruisrhead
09-11-2009, 03:30 PM
Subject basically says it all. For some reason for the first time ever I got about 220 error messages between two vbulletin communities I own, one that is brand new (and hardly any traffic) and another with 10K members. This was between about 2AM and 5:30AM our time but they went away and everything seems to be functioning 100% as if nothing happened. Here are the messages, let me know your thoughts!

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache','smiliecache','bbcodecach e','mailqueue','bookmarksitecache');

MySQL Error : Table 'datastore' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Friday, September 11th 2009 @ 07:06:49 AM
Error Date : Friday, September 11th 2009 @ 07:06:49 AM
Script : http://www.4btswaps.com/forum/showthread.php?p=41354
Referrer :
IP Address : 72.30.79.25
Username :
Classname : vB_Database
MySQL Version :


Database error in vBulletin 3.8.2:

Invalid SQL:

UPDATE cron
SET nextrun = 1252666800
WHERE cronid = 17 AND nextrun = 1252666200;

MySQL Error : Incorrect key file for table './cumm4bt_forumdatabase/cron.MYI'; try to repair it
Error Number : 126
Request Date : Friday, September 11th 2009 @ 06:58:28 AM
Error Date : Friday, September 11th 2009 @ 06:58:28 AM
Script : http://www.4btswaps.com/forum/cron.php?rand=1252666707
Referrer : http://www.4btswaps.com/forum/login.php?do=login
IP Address : 96.48.54.25
Username : Unregistered
Classname : vB_Database
MySQL Version :



Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) /home/cumm4bt/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Friday, September 11th 2009 @ 06:36:18 AM
Error Date : Friday, September 11th 2009 @ 06:36:18 AM
Script : http://www.4btswaps.com/forum/showthread.php?t=9950
Referrer : http://www.google.co.in/url?sa=t&source=web&ct=res&cd=7&url=http%3A%2F%2Fwww.4btswaps.com%2Fforum%2Fshowth read.php%3Ft%3D9950&ei=wyOqSsefGIiIkAWX7d2VBg&rct=j&q=bendix+compressor+TU+FLO+550&usg=AFQjCNGURO6iNkIlq3ceLOo2iKmakXzzLA
IP Address : 117.99.17.240
Username :
Classname : vB_Database
MySQL Version :

Marco van Herwaarden
09-11-2009, 04:12 PM
No indication that this is related to an attack.

The first 2 errors should be solved if you repair tables, see below.

See the manual on hte 3rd error: Can't connect to local MySQL server through socket (http://www.vbulletin.com/docs/html/cantconnect)

Repairing tables:
To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

dieslcruisrhead
09-14-2009, 07:27 PM
Awesome, thank you.. I am the admin so not a problem to get in there...

There is also one more error I keep getting which is related to 'max user connections' which I think is a hosting issue now that our forum is getting larger. I'll post that sometime as well. I have a feeling its just a server error...

Paul M
09-14-2009, 08:08 PM
The final error simply means the forum could not connect to mysql, most likely because it was not running.