vb.org Archive - Fighting this PROBLEM !!

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Fighting this PROBLEM !! (https://vborg.vbsupport.ru/showthread.php?t=183615)

DieselMinded

06-26-2008 03:18 PM

Fighting this PROBLEM !!

I havent had a DB error in 6 mths probably , I sent a mass email out at About 2:40AM and i got 15 Database errors

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home/dieselminded/dieselbombers.com/html/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Thursday, June 26th 2008 @ 02:41:15 AM
Error Date : Thursday, June 26th 2008 @ 02:41:15 AM
Script : http://www.dieselbombers.com/
Referrer : http://www.dieselbombers.com/
IP Address : *********************
Username :
Classname : vB_Database
MySQL Version :

What do i do about it

Dismounted

06-27-2008 10:17 AM

This is because you are hitting the database with too many connections. To get rid of the error, up the max_connections value in my.cnf.

DieselMinded

06-27-2008 09:17 PM

I have already increased this ,

This is from my Host

Quote:

You will need to find out which scripts was using up all your MySQL connections. You can see the processlist of your MySQL through the shell access by running "mysqladmin processlist", when the connections are all used up. The list will show you the database user, database name for each connections. Once you found which of your scripts are making the connection, you will need to fix/troubleshoot the script.

Im not sure how to do this and what risks i take by doing it on a live board

Dismounted

06-28-2008 05:09 AM

Running those commands will not risk anything...

DieselMinded

07-05-2008 10:10 PM

How do i do it ?

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

Well I got over 1000 Database errors Too many Connections today , they came from 2 diffrent ips , i went threw my logs and they matched with the last time this happened so i banned them ,

Now my VPS host says

Quote:

It seems some other people are trying to connect to your mysql remotely. Since you only need the mysql server working remotely, you can close on your mysql ports using firewall to prevent any remote mysql connection. We have an article on our knowledgebase that describes how to install a firewall on a linux VPS using iptables;

Is there anyset back to using iptables with Vbulletin?

TIA

Dismounted

07-06-2008 06:33 AM

As said, vBulletin does not require remote MySQL connections to be allowed. In fact, they should be disabled and blocked on any server by default unless you need it.

DieselMinded

07-06-2008 07:06 AM

I had my host install a firewall on my VPS thanks

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01030 seconds Memory Usage 1,725KB 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)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
Messages: