[horde] MYSQL 1040 Too Many Connections.

[Simon Brereton]

On 4 March 2013 13:43, Simon Brereton <simon.buongiorno at gmail.com> wrote:
> On 4 March 2013 13:31, Ralf Lang <lang at b1-systems.de> wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>>>> Do you happen to use persistent connections?
>>>
>>> Is this a setting in the Horde config?  I don't think I am, but
>>> where should I check?
>>>
>>> Simon
>>>
>>
>> DB Connection settings in horde admin dialog "horde".
>
> I don't see anything that says I am.  You mean in the Database tab of
> the Horde Config, yes?
>
>  23 $conf['sql']['username'] = 'horde';
>  24 $conf['sql']['password'] = 'redacted';
>  25 $conf['sql']['socket'] = '/var/run/mysqld/mysqld.sock';
>  26 $conf['sql']['protocol'] = 'unix';
>  27 $conf['sql']['database'] = 'horde';
>  28 $conf['sql']['charset'] = 'utf-8';
>  29 $conf['sql']['ssl'] = false;
>  30 $conf['sql']['splitread'] = false;
>  31 $conf['sql']['phptype'] = 'mysqli';

According to Chuck (whatever happened to Chuck, you never hear from
him anymore) way back in 2003,
http://lists.horde.org/archives/horde/Week-of-Mon-20030922/021485.html
this shouldn't be what my problem is

I doubt the parameter referenced in the thread even exists in Horde
today ($conf['sql']['persistent'] = true;)

Nonetheless, according to what I read on the php site persistent
connections should be reused, but it would appear that either mine are
not, or they are not being regarded correctly - i.e. some variable
change is taking place between connections that makes them not look
the same.

This is way over my head, but since restarting the mysql daemon this
morning, I'm back to over 110 queries (I temporarily increased the
limit to 150 but that is not a scaleable solution).


Simon