Database errors

[bosss]

hello!

get a lot of database errors



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)/home/belapla/public_html/libar/vb/includes/class_core.php on line 311MySQL Error : Error Number : Request Date : Tuesday, December 16th 2008 @ 07:39:48 AMError Date : Tuesday, December 16th 2008 @ 07:39:48 AMScript : http://libar-libar.com/libar/vb/cmps_index.php (http://libar-libar.com/libar/vb/cmps_index.php)Referrer : IP Address : 85.229.67.154Username : Classname : vB_DatabaseMySQL Version :

and if some is not active in few sec ... you are logout from board

some help?

have vb 3.7.4 Pl1

regards

bosss

[Lynne]

See this page for the causes of this error: http://www.vbulletin.com/docs/html/cantconnect

[bosss]

Thanks for help - send this to my webhostage and still get database errors by email ---lot of them ... what to do ?
and from my admincp i was logged out after few sec .... (10-20)

regards

bosss

[Lynne]

Did your site used to be up and running fine? If so, it sounds like maybe your host changed something (assuming you didn't). This is really something you need to have your host deal with. It's a server issue.

[bosss]

site works fine ... but get database errors and never before erors like this ...will logged out or check private message ...come database error and next click works fine .... what to do ?


regards

bosss

[Lynne]

.... what to do ?

You talk to your host. They are the only ones who can do something about this.

[bosss]

hello Lynne!

get this answer but still database errors comes (lot of them)


There is an option in admin cp to set the cookie time out. This will determine the session time out. Currently it is set to 1800 seconds(30 minutes) in your board.

We have now increased the connect_time out parameter of mysql in the server to 30. Also we have increased the 'max_user_connections' to 40. Earlier it was set to 25. If the number of simultaneous user connection exceed that limit, it will give database error. So we increased that. We cannot increase it further as it is a server wide value.

Please let us know whether your problem is solved now.


some help?

regards

bosss

[Lynne]

Without being able to configure the variables for mysql yourself, there is really nothing else you can do. The only other thing you can do is tell your host you are still having the same problem and have them see if they can change things again. They may tell you that the only way for them to fix it is for you to upgrade your hosting package with them.

[bosss]

i still get database errors and have "ultimate package" - those errors happend were is one or few users on board or maybe some guest click to see some thread ! (not many users at all)

those errors starts for 2 days before - no before!

thanks

bosss

edit : Lynne i have one test board - vb 3.8 rc1 (2 users only) and there not get those error messages - but only logged out from admincp in 10-20 sec
some solution ? make new board? destroyed libar?

[supergper]

hello Lynne!

get this answer but still database errors comes (lot of them)




some help?

regards

bosss
Personally, I'd drop your host ASAP! The connect_timeout variable in MySQL is in seconds. So they have your time out set to 30 seconds. Have them up that another 60 seconds to 90 and see if it helps. Default is something like 8 hours (I think). How busy is your site?

[Lynne]

You have a ton of modifications on your main site. It could be that one of them is causing the issue. Have you installed any lately? You can try turning them off and see if that fixes the issue -
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php


define('DISABLE_HOOKS', true);

[bosss]

hello!

i had those modifications before database errors ... and my site is not so busy...

i will try uninstall some modifications ... maybe that helps ...

regards

bosss

on my test site i have no modifications - http://libar-libar/test but also logged out from my admincp after 10-20 sec

[Lynne]

Make sure your session timeout is set at default 900 - vboptions > cookies > session timeout

The only other thing I can think of is that mysql is getting restarted ofter for some reason. Again, you'd have to ask your host about that.

(Also, unless you have a separate license for your test site, you must have it password protected - see the license agreement.)

[bosss]

i pasword protected my test board and thanks to remind me ... i wrote to my hostage and will see ..but errors still coming ...

regards

bosss

[bosss]

hello again ... get this message from my webhostage


We have fixed your issue. The Mysql in the server was restarting frequently in every 7 minutes, so that you were getting the errors while loading your admin page.

It was due to the Service manager in the server which was monitoring the MySQL server wrongly. We have restarted the 'chkservd' and the mysql is not get restarted for last 58 minutes.
---------
[root@eta ~]# mysql -e STATUS|grep -i uptime
Uptime: 58 min 34 sec
---------

We are continuously monitoring the server. Please let us know if you are still getting the mails as you specified before. As of now, the issue seems to be fixed. We have took the admin page several times and not getting any database errors. Please let us know if you are still getting the mails related the error, we will check the server and verify whether mysql is again get restarted or not. We are really sorry for the inconvenience caused.


now is ok and there are no error messages ....
THANKS FOR HELP

regards

bosss