Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: MYSQL Problem  (Read 3654 times)

0 Members and 1 Guest are viewing this topic.

lucasnet

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 37
    • TUNING 4U
MYSQL Problem
« 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.

??
Logged
LuCaS ( lucas@tuning4u.info ) GG: 40139
---------------------------------------------------------
http://tuning4u.info - best wallpapers and tuning photos

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MYSQL Problem
« Reply #1 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
Logged

opulence

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 46
Re: MYSQL Problem
« Reply #2 on: May 13, 2005, 02:26:38 am »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MYSQL Problem
« Reply #3 on: May 13, 2005, 10:23:13 am »

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

opulence

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 46
Re: MYSQL Problem
« Reply #4 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
Logged

opulence

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 46
Re: MYSQL Problem
« Reply #5 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 ?
Logged

Nibbler

  • Guest
Re: MYSQL Problem
« Reply #6 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 20 queries.