vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   vBulletin database errors caused by foreign IP addresses (https://vborg.vbsupport.ru/showthread.php?t=187480)

jdelasko 08-07-2008 04:18 PM

vBulletin database errors caused by foreign IP addresses
 
Quote:

INSERT IGNORE INTO vbsession
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('97b54255fd2b947dea29d05615a3e756', 0, '189.19.74.214', '517585b3b2f212d51c31145e433b3e4e', 1218118635, '/forums/index.php', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Update a; AOL 6.0; Windows 98)', 0, 0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Thursday, August 7th 2008 @ 09:17:50 AM
Script : http://www.majorleaguetalk.com/forums/index.php
Referrer : http://www.majorleaguetalk.com/forums/index.php
IP Address : 189.19.74.214
Username : Unregistered
Classname : vB_Database


I've been geting a lot of alerts similar to the one above lately. The IP addresses listed are from places like China, Korea, Russia, etc. I have never received an alert like this with an IP address that belongs to a registered user.

Can anyone tell me if this error may be due to some sort of hacking attempt? I'm getting several of these every day and it's getting a little annoying. My vB version is 3.6.4

I've been begging my hosting company to install GeoIP so I can easily block the entire other side of the planet, but that hasn't happened yet.

I don't know enough about mySQL to decipher the above error alert. Can somebody please explain to me why this may be occurring?

Opserty 08-07-2008 04:51 PM

<a href="http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway" target="_blank">Lost connection to MySQL server during query</a>

jdelasko 08-07-2008 05:21 PM

Quote:

Originally Posted by Opserty (Post 1593551)

I gathered that much. I was hoping someone could explain this in greater detail....like what was this user in Uruguay trying to do when this error occurred

Lynne 08-07-2008 05:53 PM

Quote:

Originally Posted by jdelasko (Post 1593583)
I gathered that much. I was hoping someone could explain this in greater detail....like what was this user in Uruguay trying to do when this error occurred

It shows he was just viewing the index.php page as an unregistered user. Kinda weird that you are only getting these errors from foreign unregistered users.

jdelasko 08-07-2008 06:35 PM

Quote:

Originally Posted by Lynne (Post 1593608)
It shows he was just viewing the index.php page as an unregistered user. Kinda weird that you are only getting these errors from foreign unregistered users.

I find it pretty hard to believe that a simple page view can generate an sql error. I had a bunch of these from a chinese IP a few days ago.

davide101 08-08-2008 12:12 AM

Every pageview, whether logged in or not, queries the database. That's how it gets information to display the page. I get these messages periodically when the server is queried and times out. Out of a million visitors a year, it will happen about a dozen times.


All times are GMT. The time now is 09:20 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01045 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete