1

Topic: Amavis and MySQL

==== Required information ====
- iRedMail version: 0.8.5
- Store mail accounts in which backend: MySQL 5.5.34
- Linux/BSD distribution name and version: Ubuntu 12.04.3 LTS
- Related log if you're reporting an issue:
====

Hi,

I found this notices in my mail.log:

Jan 19 06:25:21 mailsrv01 amavis[12282]: (12282-08) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 100) line 166, <GEN32> line 694.
Jan 20 06:25:04 mailsrv01 amavis[12287]: (12287-10) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 100) line 166, <GEN32> line 1084.
Jan 20 06:25:08 mailsrv01 amavis[12302]: (12302-09) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 100) line 166, <GEN32> line 1565.
Jan 20 06:25:13 mailsrv01 amavis[12300]: (12300-14) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 100) line 166, <GEN32> line 1748.

I already modifyed my amavis config (user-50.conf) and added the suggested $max_servers = 1; and $max_requests = 1; lines.
( http://www.iredmail.org/forum/topic2536 … ailed.html )
Which didn't help.

Currently my /etc/mysql/my.cnf max_connections=300

At the moment this server isn't do much, but it will serv 2000-3000 mails/day, what is your suggestion for this amount of mails?

Thanks, Robert

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Amavis and MySQL

No idea yet. I suggest asking in Amavisd mailing list instead: http://www.ijs.si/software/amavisd/#support