On 04/06/2017 02:17 PM, John Stoffel wrote:
Robert> It seems postfix is impatient with connecting with mysql, as I see in
Robert> maillog entries like:
Robert> Apr 6 11:48:30 z9m9z dovecot: dict: Error: mysql(localhost): Connect
Robert> failed to database (postfix): Can't connect to local MySQL server
Robert> through socket '/var/lib/mysql/mysql.sock' (13) - waiting for 5 seconds
Robert> before retry
Robert> Apr 6 11:48:35 z9m9z dovecot: dict: Error: mysql(localhost): Connect
Robert> failed to database (postfix): Can't connect to local MySQL server
Robert> through socket '/var/lib/mysql/mysql.sock' (13) - waiting for 25 seconds
Robert> before retry
Robert> I suspect it does connect eventually. This is a test system with only
Robert> 1GB of memory and free reports:
Robert> total used free shared buff/cache
Robert> available
Robert> Mem: 1025484 696344 24556 21528 304584
251552
Robert> Swap: 524284 92168 432116
Robert> The production box has 2GB, so if the problem is mysql is
Robert> swapping out, that will be 'fixed', if it is processor, well
Robert> this is an ARMv7 duo core, as is the production box. I am
Robert> considering buying the new quad core.
Robert> Is there anything I can do to get postfix more patient with
Robert> mysql, or just ignore there messages?
Just as a side note, I setup my home server with dovecot, postfix,
mysql and I ended up removing mysql because it was a memory pig for a
not-very big install. In your case, if you're running on an ARMv7
dual CPU box, it also isn't too big so I'd prboably not bother.
sqlite or even flat files should be more than performant enough for
your needs.
I support virtual domains and use postfixadmin.
Granted not many domains and < 10,000 messages per day.
I am currently running on a CubieTruck (duo core, 2GB, ARMv7) with
Redsleeve 6 (Centos 6 clone) and time-matching componenets.
My development to replace it is on a Cubieboard2 (same as above, but
1GB) with Centos 7.
I don't get any of these messages on the current server. So perhaps it
is just a memory thing. I will start testing on another CubieTruck soon
and that will show if memory is the bottleneck.
