Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2008, 04:18 PM
jdelasko's Avatar
jdelasko jdelasko is offline
 
Join Date: Jan 2007
Posts: 159
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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?
Reply With Quote
  #2  
Old 08-07-2008, 04:51 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway" target="_blank">Lost connection to MySQL server during query</a>
Reply With Quote
  #3  
Old 08-07-2008, 05:21 PM
jdelasko's Avatar
jdelasko jdelasko is offline
 
Join Date: Jan 2007
Posts: 159
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Opserty View Post
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
Reply With Quote
  #4  
Old 08-07-2008, 05:53 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by jdelasko View Post
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.
Reply With Quote
  #5  
Old 08-07-2008, 06:35 PM
jdelasko's Avatar
jdelasko jdelasko is offline
 
Join Date: Jan 2007
Posts: 159
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
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.
Reply With Quote
  #6  
Old 08-08-2008, 12:12 AM
davide101 davide101 is offline
 
Join Date: Dec 2005
Posts: 100
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:03 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.04065 seconds
  • Memory Usage 2,210KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete