DB Error

[R.Solutions]

I get a error and i dont know what caused it. please help.

www.centexracingscene.com/forums (http://www.centexracingscene.com/forums)

THanks a lot,.

[King Kovifor]

More information on the error would help.

[R.Solutions]

I just said,i dont knwo what the error is from lol.

Thus, sayin, i dont know what caused it.

[Lynne]

When you get a database error, if you aren't having them mailed to you, you can View Source for the page and it will show the error at the bottom of the page:

<!--
Database error in vBulletin :

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Too many connections
/home/centexra/public_html/forums/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Saturday, March 22nd 2008 @ 03:20:27 PM
Script : http://www.centexracingscene.com/forums/
Referrer : https://vborg.vbsupport.ru/showthread.php?p=1471813
IP Address : xx.xxx.xxx.xx
Username :
Classname : vb_database
-->
Too many connections is a server issue. So, you will need to talk to your host about it.

[R.Solutions]

Ahhh thank you. So what do i need to do fix that? I have my server, a resellers.

[Lynne]

Ahhh thank you. So what do i need to do fix that? I have my server, a resellers.
Your my.cnf file would have to be edited, I believe.

[SEOvB]

You need to increase the mysql_max_connections string in the mysql configuration file. If you can not do that, or do not have access to it, you'll have to try to contact your hosting company.

If they have it set as a hard limit and you can't use any more connections, you'll need to find a new host, or limit the connections some how.

[R.Solutions]

Your my.cnf file would have to be edited, I believe.
\
Okay and thats located where?

You need to increase the mysql_max_connections string in the mysql configuration file. If you can not do that, or do not have access to it, you'll have to try to contact your hosting company.

If they have it set as a hard limit and you can't use any more connections, you'll need to find a new host, or limit the connections some how.


Okay, i'll check that, i think i can do that. located where?

[snakes1100]

Typically /etc/my.cnf or /etc/mysql/my.cnf

From a shell:

find / -name my.cnf -print
or
locate my.cnf

Edit my.cnf and change max_connections to a higher number, increase it by 100 and save it, then restart mysql:
/etc/rc.d/init.d/mysql restart

[R.Solutions]

Hmm im lookin in my WHM, would that be it>?

and i looked in etc/....

and didnt see no cnf file.

[Lynne]

Hmm im lookin in my WHM, would that be it>?

and i looked in etc/....

and didnt see no cnf file.
Typically /etc/my.cnf or /etc/mysql/my.cnf

From a shell:

find / -name my.cnf -print
or
locate my.cnf

Edit my.cnf and change max_connections to a higher number, increase it by 100 and save it, then restart mysql:
/etc/rc.d/init.d/mysql restart

After you change the my.cnf file, you need to restart mysql. Do you have access to do that?

[snakes1100]

whm isnt going to show you the file, you need to open a shell and edit the file.

once you have edited the file restart mysql as i posted previously.

you can also restart mysql in whm, if its a resellers account you may not have permissions to restart mysql