vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Persistent DB errors (https://vborg.vbsupport.ru/showthread.php?t=303316)

SwalyAaron 10-12-2013 08:52 PM
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 :

nerbert 10-12-2013 10:50 PM
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.

blind-eddie 10-13-2013 01:15 AM
I would say you are getting hammered by bots from the same IP address thus causing to many connections.

Digital Jedi 10-13-2013 04:05 AM
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.

SwalyAaron 10-13-2013 07:08 AM
Quote:
Originally Posted by blind-eddie (Post 2452769)
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 (Post 2452821)
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 (Post 2452749)
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"

ozzy47 10-13-2013 09:34 AM
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?

Digital Jedi 10-13-2013 03:51 PM
Quote:
Originally Posted by SwalyAaron (Post 2452843)
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.

SwalyAaron 10-19-2013 08:42 AM
Quote:
Originally Posted by Digital Jedi (Post 2452947)
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?

Digital Jedi 10-19-2013 04:34 PM
Quote:
Originally Posted by SwalyAaron (Post 2454586)
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

ForceHSS 10-19-2013 06:16 PM
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


All times are GMT. The time now is 03:39 PM.

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.01255 seconds
  • Memory Usage 1,740KB
  • 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
  • (3)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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