Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-21-2006, 02:53 AM
rantrave's Avatar
rantrave rantrave is offline
 
Join Date: Feb 2005
Location: Texas
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Hundreds of MySQL Errors by 1 IP Daily

Here's a copy of the error:

mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11)

/forums/includes/class_core.php on line 279

I get this same error from the same ip everyday, is it possible that it's an attack? Also, what in layman's terms does this error mean. It's causing my host mucho trouble, and could get the boot, so your assistance is greatly needed.
Reply With Quote
  #2  
Old 05-21-2006, 02:59 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's your hosts problem - that's a failure of mysql.
Reply With Quote
  #3  
Old 05-21-2006, 03:03 AM
rantrave's Avatar
rantrave rantrave is offline
 
Join Date: Feb 2005
Location: Texas
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M
It's your hosts problem - that's a failure of mysql.
Could it be attributed to the vbulletin software in some way? The reason I ask, you know hosting companies, if they think vb is doing it, I get cancelled. The server has crashed 2 out of the past three days after a forum attack (DoS I think), I want to cover my bases.
Reply With Quote
  #4  
Old 05-21-2006, 03:10 AM
Dan's Avatar
Dan Dan is offline
 
Join Date: Dec 2002
Location: Titusville, Florida
Posts: 1,787
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How big is your board? Do you have a lot of hacks installed that might cause high server load?
Reply With Quote
  #5  
Old 05-21-2006, 03:18 AM
rantrave's Avatar
rantrave rantrave is offline
 
Join Date: Feb 2005
Location: Texas
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by fewyn
How big is your board? Do you have a lot of hacks installed that might cause high server load?
Not that large, but growing....

744 Members
5682 Threads
157,714 Posts

Average Contections - About 50-100 all the time
Hacks: 3 minor 1 major (VB Image)

I stripped everything I thought could cause problems, but obviously to no avail.
Reply With Quote
  #6  
Old 05-21-2006, 03:20 AM
Dan's Avatar
Dan Dan is offline
 
Join Date: Dec 2002
Location: Titusville, Florida
Posts: 1,787
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What kind of hosting enviroment are you in? Might be time to look into upgrading.
Reply With Quote
  #7  
Old 05-21-2006, 03:32 AM
rantrave's Avatar
rantrave rantrave is offline
 
Join Date: Feb 2005
Location: Texas
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by fewyn
What kind of hosting enviroment are you in? Might be time to look into upgrading.
Although I can't argue that point (and it is being investigated), my load averages stay within .02-1.0 range, clearly an acceptable range for even a virtual dedicated server, yes? I know VDS is not good, that's a whole 'nother conversation....:cross-eyed:
Reply With Quote
  #8  
Old 05-21-2006, 03:38 AM
Dan's Avatar
Dan Dan is offline
 
Join Date: Dec 2002
Location: Titusville, Florida
Posts: 1,787
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well if there's a lot of queries going in and out of the MySQL server that might cause it to crash.... don't know a lot about VDS though, if it runs a MySQL server for each virtual instance. If so It could be fine if not it could be that one of the other customers on the server could be contributing to the server crashes.
Reply With Quote
  #9  
Old 05-21-2006, 03:44 AM
rantrave's Avatar
rantrave rantrave is offline
 
Join Date: Feb 2005
Location: Texas
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by fewyn
Well if there's a lot of queries going in and out of the MySQL server that might cause it to crash.... don't know a lot about VDS though, if it runs a MySQL server for each virtual instance. If so It could be fine if not it could be that one of the other customers on the server could be contributing to the server crashes.
Thanks for the info!

I am also inquiring to the hosting company about the database error in question. It's ridiculous to be crashed 2 out of 3 days!

I will still accept any other information that you have that could resolve this issue. Thanks.
Reply With Quote
  #10  
Old 05-21-2006, 03:04 PM
hambil's Avatar
hambil hambil is offline
 
Join Date: Jun 2004
Location: Seattle
Posts: 1,719
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by rantrave
Here's a copy of the error:

mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11)

/forums/includes/class_core.php on line 279

I get this same error from the same ip everyday, is it possible that it's an attack? Also, what in layman's terms does this error mean. It's causing my host mucho trouble, and could get the boot, so your assistance is greatly needed.
From a single IP is suspicious. Have you looked up the ip? One option is to ban the ip in your hosts cp-panel. There are websites out there designed for load testing that can and are abused to attack boards. I won't link to one for obvious reasons.

The error most likely means you've exceeded max connections. What MySQL version are you using?
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 12:41 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.06720 seconds
  • Memory Usage 2,255KB
  • Queries Executed 13 (?)
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
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_postinfo_query
  • fetch_postinfo
  • 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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete