[horde] MYSQL 1040 Too Many Connections.

[Simon Brereton]

On 4 March 2013 16:14, Arjen de Korte <arjen+horde at de-korte.org> wrote:
> 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.

Thank Arjen

I've been using mysqli for over 2 years now without every having had a
problem.  Before I just change the backend, I'd like to try to
understand a) why this is now happening and b) what other surprises I
can expect by changing from mysqli to mysql/PDO.

Simon