Print Page - MYSQL Problem

Title: MYSQL Problem
Post by: lucasnet on January 08, 2005, 07:52:16 PM

I see that error:

Coppermine critical error:
Unable to connect to database !
MySQL said: User xxx_blax has already more than 'max_user_connections' active connections

My admin said me that my script has got an error. Max 20 connections are open and dont close.

??

Title: Re: MYSQL Problem
Post by: Joachim Müller on January 08, 2005, 07:54:17 PM

The connections close when the script finishes, see http://www.php.net/manual/en/function.mysql-close.php

Joachim

Title: Re: MYSQL Problem
Post by: opulence on May 13, 2005, 02:26:38 AM

I'm having the same problem... will it go away?

Title: Re: MYSQL Problem
Post by: Joachim Müller on May 13, 2005, 10:23:13 AM

ask your webhost for support, this is not coppermine-related.

Title: Re: MYSQL Problem
Post by: opulence on May 13, 2005, 03:48:57 PM

lol that's funny because my admin is saying the opposite :(

He's saying it's because the script isn't closing too!

*sigh* it sucks being stuck as the middle man

Title: Re: MYSQL Problem
Post by: opulence on May 13, 2005, 04:17:29 PM

I think it might have something to do with idle persistent connections.

Is there someplace in coppermine where I can set a lower "wait_timeout" ?

does coppermine use mysql_connect or mysql_pconnect ?

Title: Re: MYSQL Problem
Post by: Nibbler on May 13, 2005, 05:38:51 PM

Coppermine only uses mysql_connect, which drops the connection as soon as the script ends and the page is displayed.

coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: lucasnet on January 08, 2005, 07:52:16 PM