vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   database error! (https://vborg.vbsupport.ru/showthread.php?t=269034)

bosanci28 08-24-2011 12:21 AM
database error!
 
for few days i get this database error coming in my email...

and i did not do any mod,or anything to the site in the last week or so,
and i get this error:

Code:
Database error in vBulletin :
 
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User xxxxxx_xxxxxx  already has more than 'max_user_connections' active connections
/home/xxxxx/public_html/xxxxxxx/includes/class_core.php on line 314
 
MySQL Error  :
Error Number  :
Request Date  : Tuesday, August 23rd 2011 @ 07:12:55 PM
Error Date    : Tuesday, August 23rd 2011 @ 07:12:55 PM
Script        : http://xxxxxxxxxx.com/forumdisplay.php?35-Filme-Engleza
Referrer      :
IP Address    : xxxx.xx.xx.xxx
Username      :
Classname    : vB_Database
MySQL Version :
any idea why?
thanks,

HMBeaty 08-24-2011 12:26 AM
Quote:
User xxxxxx_xxxxxx already has more than 'max_user_connections' active connections
Contact your host about this. This is not an issue with vBulletin

bosanci28 08-24-2011 12:35 AM
ok,i will thanks friend,for clarifying this for me!

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

Quote:
Originally Posted by HMBeaty (Post 2237217)
Contact your host about this. This is not an issue with vBulletin
also can you see this error that i got about a week ago,
and i have asked my host and they said that is from the script ,they said that vb script is using
"simultaneous database connections"

and this was the error:

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)
/home5/xxxxx/public_html/xxxx/includes/class_core.php on line 314
 
MySQL Error  :
Error Number  :
Request Date  : Friday, August 12th 2011 @ 04:27:17 AM
Error Date    : Friday, August 12th 2011 @ 04:27:17 AM
Script        : http://xxxxxxx.com/calendar.php?month=3&year=2007&c=1&do=displaymonth
Referrer      :
IP Address    : xxxxx
Username      :
Classname    : vB_Database
MySQL Version :

thank you,for any help...

nhawk 08-24-2011 09:03 PM
This isn't a problem with vBulletin, this is a problem with your shared server limits as set by your host.

If it continues, then you have outgrown the use of the shared server you have and you need to look for a better server.

bosanci28 08-24-2011 09:13 PM
Quote:
Originally Posted by nhawk (Post 2237610)
This isn't a problem with vBulletin, this is a problem with your shared server limits as set by your host.

If it continues, then you have outgrown the use of the shared server you have and you need to look for a better server.
are you talking about the first problem,or the one bellow...

thanks friend

nhawk 08-24-2011 09:21 PM
They are both related.

From what I can recall bluehost limits connections to mysql to 30 simulaneous connects. All it takes to trip that limit is 31 people, spiders, bots, whatever to access the site at the same moment in time. That accounts for the first error.

Also, bluehost had (don't know if they still do have) a 60 second real-time CPU usage limit over a 3 minute period. That can account for the second error.

Those are simplified explanations, but close enough for this purpose. ;)

You can lower the connections a bit by not allowing spiders and unregistered users access to things like the calendar, who's online, member profiles and any other info that might be useless to them.

bosanci28 08-24-2011 09:37 PM
1 Attachment(s)
:::::You can lower the connections a bit by not allowing spiders and unregistered users access to things like the calendar, who's online, member profiles and any other info that might be useless to them.:::::


and how do i do that?


i have notice something on my forum,when i go to see whos online ,i get 14 users/guest

but one ip stands out ,starting with 119....

and if i go here and trace it it comes from japan ,and my site does not have nothing to do with japan,and also see that pic bellow there are a lot of 119.xxx.xxx and finishing with other numbers from the same place!,

thanks

Max Taxable 08-24-2011 09:43 PM
Quote:
Originally Posted by bosanci28 (Post 2237624)
:::::You can lower the connections a bit by not allowing spiders and unregistered users access to things like the calendar, who's online, member profiles and any other info that might be useless to them.:::::


and how do i do that?


i have notice something on my forum,when i go to see whos online ,i get 14 users/guest

but one ip stands out ,starting with 119....

and if i go here and trace it it comes from japan ,and my site does not have nothing to do with japan,and also see that pic bellow there are a lot of 119.xxx.xxx and finishing with other numbers from the same place!,

thanks
The baidu spider, one of the nastiest there is.

bosanci28 08-24-2011 09:47 PM
so i guess ,that whats trriger all that on my site?

is there any mod to stop that?

i mean ,those ip's come with different numbers to the end all the time...

i did install this mod here

but dont know if will it work,it looks like i have to add those ip's all the time..

thanks for any advice!

Eric 08-25-2011 06:28 AM
Quote:
Originally Posted by bosanci28 (Post 2237628)
so i guess ,that whats trriger all that on my site?

is there any mod to stop that?

i mean ,those ip's come with different numbers to the end all the time...

i did install this mod here

but dont know if will it work,it looks like i have to add those ip's all the time..

thanks for any advice!
If I am not mistaken, Baidu Spider will respect robots.txt. So you may want to add this to your robots.txt fle (or create a new file if you do not have one) - this file should be in the root of your website, and add:

Code:
User-agent: Baiduspider
Disallow: /
Other than that, vB 4 is not going to last on shared hosting long. You may want to look into a VPS to start out, or possibly a dedicated server if warranted.

bosanci28 08-25-2011 12:56 PM
Quote:
Originally Posted by Eric (Post 2237783)
If I am not mistaken, Baidu Spider will respect robots.txt. So you may want to add this to your robots.txt fle (or create a new file if you do not have one) - this file should be in the root of your website, and add:

Code:
User-agent: Baiduspider
Disallow: /
Other than that, vB 4 is not going to last on shared hosting long. You may want to look into a VPS to start out, or possibly a dedicated server if warranted.
i used this mod from here and it looks like it works for now,in blocking the maidu spider,but will still checking to see all are okay within the next few days,

and yes,i have to look for a different server ,from November,when my contract finishes with my host right now...will see...


thanks,


All times are GMT. The time now is 10:57 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.01023 seconds
  • Memory Usage 1,749KB
  • 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
  • (4)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (11)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