Thread: Database error

Hi, I get the following error when working with the control panel.

Warning: mysql_pconnect(): Too many connections in /home/emailgir/public_html/friends/inc/db.inc.php on line 20

Warning: mysql_select_db(): Too many connections in /home/emailgir/public_html/friends/inc/db.inc.php on line 29

Warning: mysql_select_db(): A link to the server could not be established in /home/emailgir/public_html/friends/inc/db.inc.php on line 29

Warning: mysql_select_db(): Too many connections in /home/emailgir/public_html/friends/inc/db.inc.php on line 29

Warning: mysql_select_db(): A link to the server could not be established in /home/emailgir/public_html/friends/inc/db.inc.php on line 29
Error
Database activation failed


I keep going to my web site contol panel and clicking the repair option, then its ok for awhile, then starts again after being log on to the admin panel for about 15 minutes.

How can I correct this?

Niña

Hi,

Do you have access to the mysql console? You'll have to increase the max_connections setting of mysql (default is 100, maximum recommended without optimisations is 1000). The following will increase this value for the running instance (enter at the mysql prompt, I guess you could enter it at the "enter SQL" option at phpmyadmin as well):

SET GLOBAL max_connections=1000

To make the change permanent (so it will survive a restart of the mysql daemon), you need to add this line in /etc/my.cnf (don't know where this is on Windows):

max_connections=1000

/ken

Hi Ken,

Success! I located the /etc/my.cnf by going through my online web host control panel, clicking on file management, finding the etc directory, then my.cnf and updated the sttings. The connection is great and no more database errors so far.

I am very thankful for people like yourself for being here.

Wishing you all the best!

Niña

Hi,

This is ok - but perhaps it is better to disable pconnect.

Search modmysite for pconnect to find threads about this.

Smoge

Hi Smoge, thank you for addressing my database error issue. Yes, I will search the pcconnect topics to find out how to disable it.

Thank you so much for your assistance.

Cheryll

Its 4am. I just woke up to the sound of "clicks" in my email. It went non stop for about ten minutes. I ended up with over 700 error messages in my mail box. (I use Dolphin 5.2)

As I tried to go to my website, the only thing that would show up was a blank screen that said "Database Activation Failed".

Once the emails stopped, everything went back to normal. My site is back up and running fine. Anyone have any clues?

btw, I did a search for pcconnect and pc connect and it came up with nothing

Thanks for your help. I need to sleep a full night, one of these days lol

Hi,

It's "pconnect" not "pcconnect" as emailgirls mentioned.

Try a search on "pconnect".

Rob

hi, i just got the same error 5 minutes ago igot 365 mail like this once below

Error in /imctrl.php: Access denied for user 'nobody'@'localhost' (using password: NO)

imctrl.php is this instan messanger? as i tried to chat to a person that was online but not full memebr so she could not use the instant messanger.

and i also tried to send her message by mail and instant, but she as said before was not full member so she could not recive.

is this maybe a bug or something?

after that i got all the error mails


anyone have any clues on this?

crazy i still get this error mail every 5 min is not stopping.


regards anders

All ok now? Or still a problem.

You guys are not giving me enough information to be able to make any further comments about your posts.

Smoge

Hi smoge,

sorry for the delay. i still have the problem i just tested it agian. if i open im messeanger up and see a person there and try to send a message i get hundreds of mail like this

Error in /imctrl.php: Access denied for user 'nobody'@'localhost' (using password: NO)

and i also get the error message.

Regards anders