Log in

View Full Version : Is this a highjack attempt?


Nintendo-Daily
04-20-2010, 11:17 PM
I received a database error email a little bit ago. Would someone mind enlightening me as to what this means. Is this malicious and would someone be able to add themselves without registering some how?

-----------------------------------

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT userid, username, email
FROM user
WHERE email = 'razorxr1@googlemails.net';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, April 20th 2010 @ 07:02:39 PM
Error Date : Tuesday, April 20th 2010 @ 07:03:21 PM
Script : http://www.nintendo-daily.com/forums/register.php?do=addmember
Referrer : http://www.nintendo-daily.com/forums/register.php?
IP Address : 204.45.58.186
Username : neodssobamors
- Hide quoted text -
Classname : vB_Database
MySQL Version :

-----------------------------------

ForumsMods
04-20-2010, 11:40 PM
This is a server issue.
See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway (http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway) and this: http://www.vbulletin.com/forum/showt...265#post310265 (http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265)

Nintendo-Daily
04-20-2010, 11:46 PM
Hmm...I'll get with my host I suppose. Thanks for being so prompt.

Would you mind doing me a huge favor?

Would you mind trying to register to see if it works? I haven't received any new members in quite some time.

Something is just strange about this to me.

Thanks for your promptness, vB Style.

ForumsMods
04-21-2010, 12:22 AM
I registered fine.

Nintendo-Daily
04-21-2010, 12:34 AM
Interesting...thanks vB Style.

What do you think caused the error above?

TheLastSuperman
04-21-2010, 12:40 AM
Interesting...thanks vB Style.

What do you think caused the error above?

Could be a number of things.. have them check the settings in php.ini for max users and there's more, if they are a half-arsed decent host they will know what to look for otherwise there is recommended server settings at vb.com.

Naan-Kadavul
04-25-2010, 06:40 AM
its a database error.. you can fix it easily..see whats wrong actually...

and if u can't replace it with a recent backup that you have taken...

wish you the best...

Nintendo-Daily
07-16-2010, 03:49 PM
Hey guys, its me again.

This seems to be happening more and more often as of late and its becoming quite frustrating. Last week I received a ton of database error emails and got with my host about it. They said everything looked fine on their end. A day or two after submitting my trouble ticket to the host, the problem went away and everything returned to normal. I don't believe the host did anything to fix the issue because I received an email from one of the database admins where he asked me a few questions. I didn't respond to the email because I wanted to see if the problem fixed itself, and it seems to have done just that. I really don't think the host has anything to do with the issue. Here's why...

The location of my forums is:
http://www.nintendo-daily.com/forums

The location of my website is:
http://www.nintendo-daily.com

My forums and website use two completely different databases. I can navigate anywhere within my website without going to /forums and everything works perfect.

Whenever I start to receive all the database error emails, I get strange things like this:

Invalid SQL:

SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity, session.badlocation,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1279296520

ORDER BY username ASC;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 16th 2010 @ 11:38:40 AM
Error Date : Friday, July 16th 2010 @ 11:39:22 AM
Script : http://www.nintendo-daily.com/forums/
Referrer : http://www.nintendo-daily.com/forums/
IP Address : 122.228.203.155

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,mgcugp.mgc_cb_evo_default_color,mgcugp.mgc_cb_evo _chanid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid)
WHERE user.userid = 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 16th 2010 @ 11:35:21 AM
Error Date : Friday, July 16th 2010 @ 11:36:04 AM
Script : http://www.nintendo-daily.com/forums/showthread.php?t=574


Invalid SQL:

SELECT cron.*
FROM cron AS cron
LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1279293989 AND cron.active = 1
AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun
LIMIT 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 16th 2010 @ 10:26:29 AM
Error Date : Friday, July 16th 2010 @ 10:27:11 AM
Script : http://www.nintendo-daily.com/forums/cron.php?rand=1279293945
Referrer : http://www.nintendo-daily.com/forums/showthread.php?t=3096
IP Address : 74.234.84.227

Invalid SQL:

SELECT userid, username, email
FROM user
WHERE email = 'suiyrg@mail.ru';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 16th 2010 @ 09:50:45 AM
Error Date : Friday, July 16th 2010 @ 09:51:28 AM
Script : http://www.nintendo-daily.com/forums/register.php?do=addmember
Referrer : http://www.nintendo-daily.com/forums/register.php?
IP Address : 212.95.54.24
Username : Defshiste

I'm at the point now where I need some better direction because I really don't believe its a hosting issue. If anyone wants to help out with this I would really appreciate it.