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 10-12-2013, 08:52 PM
SwalyAaron SwalyAaron is offline
 
Join Date: Jan 2013
Posts: 86
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Persistent DB errors

Not sure if someone is trying to inject my forums on a daily basis basically non stop or something is wrong with my forums, I'm getting a mix of fatal errors, I just recently checked the email I use for vbulletin error reporting. Please check these out I'll try and spoiler them


Error 1 (looks like an injection tbh).
Code:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/public_html/forums/includes/class_core.php on line 311

MySQL Error : 
Error Number : 
Request Date : Saturday, October 12th 2013 @ 11:19:14 AM
Error Date : Saturday, October 12th 2013 @ 11:19:14 AM
Script : http://www.mywebsite.org/forums/misc.php?do=form&fid=3%20aNd%20(select%20ASCII(SUBSTRING(name,60,1))%20from%20%5Bmaster%5D..%5Bsysdatabases%5D%20where%20dbid=16)=254
Referrer : 
IP Address : REMOVED
Username : 
Classname : vB_Database
MySQL Version :
Error 2.
Code:
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)
/public_html/forums/includes/class_core.php on line 311

MySQL Error : 
Error Number : 
Request Date : Saturday, October 12th 2013 @ 01:25:53 PM
Error Date : Saturday, October 12th 2013 @ 01:25:54 PM
Script : http://www.mywebsite.org.com/forums/
Referrer : http://www.mywebsite.org/forums/showgroups.php
IP Address : REMOVED
Username : 
Classname : vB_Database
MySQL Version :
Error 3.
Code:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/public_html/forums/includes/class_core.php on line 311

MySQL Error : 
Error Number : 
Request Date : Saturday, October 12th 2013 @ 10:25:54 AM
Error Date : Saturday, October 12th 2013 @ 10:25:54 AM
Script : http://www.mywebsite.org/forums/forumdisplay.php?f=0
Referrer : http://www.mywebsite.org/forums/
IP Address : REMOVED
Username : 
Classname : vB_Database
MySQL Version :
Reply With Quote
  #2  
Old 10-12-2013, 10:50 PM
nerbert nerbert is offline
 
Join Date: May 2008
Posts: 784
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If it's a shared server it could be someone else loading it. In your AdminCP Home page check Server Load Averages. It depends on the number of server cores but the number shouldn't be much bigger than 4 for a 4 core server.
Reply With Quote
Благодарность от:
Max Taxable
  #3  
Old 10-13-2013, 01:15 AM
blind-eddie's Avatar
blind-eddie blind-eddie is offline
 
Join Date: Apr 2006
Location: Michigan
Posts: 2,310
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would say you are getting hammered by bots from the same IP address thus causing to many connections.
Reply With Quote
Благодарность от:
Max Taxable
  #4  
Old 10-13-2013, 04:05 AM
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Location: PopCulturalReferenceLand
Posts: 5,171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I had to shut down my forums a year ago for the same reason blind-eddie suggests. Of course, at that point, I had no active membership. But even so, the server kept crashing with the same type of database errors above. Too many connections from too many bots trying to see things they shouldn't see.
Reply With Quote
  #5  
Old 10-13-2013, 07:08 AM
SwalyAaron SwalyAaron is offline
 
Join Date: Jan 2013
Posts: 86
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by blind-eddie View Post
I would say you are getting hammered by bots from the same IP address thus causing to many connections.
If I can do anything to stop this please give me any suggestion, can I reroute them?


Quote:
Originally Posted by Digital Jedi View Post
I had to shut down my forums a year ago for the same reason blind-eddie suggests. Of course, at that point, I had no active membership. But even so, the server kept crashing with the same type of database errors above. Too many connections from too many bots trying to see things they shouldn't see.
Ah well I can't shutdown my forums got a nice active community going =] Thanks for the input though.

--------------- Added [DATE]1381651823[/DATE] at [TIME]1381651823[/TIME] ---------------

Quote:
Originally Posted by nerbert View Post
If it's a shared server it could be someone else loading it. In your AdminCP Home page check Server Load Averages. It depends on the number of server cores but the number shouldn't be much bigger than 4 for a 4 core server.

"Server Load Averages 13.16 13.54 13.45"
Reply With Quote
  #6  
Old 10-13-2013, 09:34 AM
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Location: USA
Posts: 10,929
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How many users are on you forms when the load is that high, Active Users X, Guests X?

What is the specs of the serve? Is it a shared, VPS or dedicated?
Reply With Quote
  #7  
Old 10-13-2013, 03:51 PM
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Location: PopCulturalReferenceLand
Posts: 5,171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by SwalyAaron View Post
Ah well I can't shutdown my forums got a nice active community going =] Thanks for the input though.
Heh, I wasn't suggesting that. Just pointing out that I've run into the same issue, for possibly the same reasons. My community was dead at the time, so I decided to put it off til later. I hate .htaccess, but I was probably going to have to ban some countries for that reason.
Reply With Quote
Благодарность от:
blind-eddie
  #8  
Old 10-19-2013, 08:42 AM
SwalyAaron SwalyAaron is offline
 
Join Date: Jan 2013
Posts: 86
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Digital Jedi View Post
Heh, I wasn't suggesting that. Just pointing out that I've run into the same issue, for possibly the same reasons. My community was dead at the time, so I decided to put it off til later. I hate .htaccess, but I was probably going to have to ban some countries for that reason.
I see, is there any way I can log the requests I'm getting?
Reply With Quote
  #9  
Old 10-19-2013, 04:34 PM
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Location: PopCulturalReferenceLand
Posts: 5,171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by SwalyAaron View Post
I see, is there any way I can log the requests I'm getting?
You, or your host, should be able to see the raw access logs. If you have cPanel, there should be a place to view those logs as well as bandwidth usage, statistics, etc. Every host is a little different, though
Reply With Quote
  #10  
Old 10-19-2013, 06:16 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The server has maxed out the number of MySQL connections it allows. This is a server-wide limit, not just your forums. All you can do is ask your host to raise the maximum number of connections they allow.

Here is more info on that error:

http://dev.mysql.com/doc/refman/5.0/...nnections.html
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 07:27 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04219 seconds
  • Memory Usage 2,272KB
  • 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
  • (3)bbcode_code
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (3)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit
  • (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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete