← Back to team overview

maria-discuss team mailing list archive

Re: Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)


Am 18.06.2014 13:30, schrieb Tanstaafl:
> I'm very inexperienced mariadb/mysql/sql user/admin, but not totally clueless, been maintaining a tiny mysql DB for
> postfixadmin for years, then converted it to mariadb.
> We recently started using SOGo (groupware). I hired the SOGo guys to help with the install/config, and have been
> using it trouble-free for a few months now (love it for the most part), until now.
> Everything seems to be working fine, but since the upgrade to SOGo 2.2.4 on 6/12, which I am told increases the
> number of connections it uses to the DB, I have been getting very occasional errors like this (the system error is
> always either 104 or 0):
> 2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4 connection to database 'sogo'

the client seems to use the very outdated mysql4 protocol
which is not compatible - no idea why it does that only
sometimes - maybe a completly wrong error message from
the software!

> which I am told increases the number of connections
> Should I be looking at tuning:
> max_connections
> max_user_connections

surely, the have to tell you *how many connections*
and not only "increases", there must be a upper limit
controlled by the software and multiply it by the
users tells you how many connections you need to allow

Attachment: signature.asc
Description: OpenPGP digital signature

Follow ups