[horde] MYSQL 1040 Too Many Connections.

[Arjen de Korte]

Citeren Simon Brereton <simon.buongiorno at gmail.com>:

> 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;)

It does, but only if you select the MySQL / PDO backend in the Database tab

     $conf['sql']['phptype'] = 'mysql';

This is not available if (like you) 'mysqli' is used. I would try  
using another backend before anything else.

Arjen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 308 bytes
Desc: PGP digitale ondertekening
URL: <http://lists.horde.org/archives/horde/attachments/20130304/6d45578a/attachment.bin>