Hi guys,
I'm seeing this in the logs:
Mar 2 18:18:05 web postfix/cleanup[27207]: warning: mysql query failed:
MySQL server has gone away
Mar 2 18:18:05 web postfix/cleanup[27207]: warning: D1D1A71029C:
virtual_alias_maps map lookup problem for donny_bra...@example.co.uk
Mar 2 18:18:28 web postfix/smtpd[27153]: connect from
unknown[xxx.xxx.xxx.xxx]
Mar 2 18:18:29 web postfix/trivial-rewrite[27154]: warning: mysql query
failed: MySQL server has gone away
Mar 2 18:18:29 web postfix/trivial-rewrite[27154]: fatal:
mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table
lookup problem
Mar 2 18:18:30 web postfix/pickup[26468]: E381E7102B3: uid=48 from=<apache>
Mar 2 18:18:30 web postfix/smtpd[27153]: warning: premature
end-of-input on private/rewrite socket while reading input attribute name
Mar 2 18:18:30 web postfix/smtpd[27153]: warning: problem talking to
service rewrite: Success
Mar 2 18:18:30 web postfix/cleanup[27207]: warning: premature
end-of-input on private/rewrite socket while reading input attribute name
Mar 2 18:18:30 web postfix/cleanup[27207]: warning: problem talking to
service rewrite: Connection reset by peer
Mar 2 18:18:30 web postfix/master[21481]: warning: process
/usr/libexec/postfix/trivial-rewrite pid 27154 exit status 1
Mar 2 18:18:31 web postfix/cleanup[27207]: E381E7102B3:
message-id=<kfw5i5.rhs...@web.example.com>
Mar 2 18:18:31 web postfix/cleanup[27207]: warning: E381E7102B3:
virtual_alias_maps map lookup problem for donny_bra...@example.co.uk
Mar 2 18:18:32 web postfix/smtpd[27153]: warning: mysql query failed:
MySQL server has gone away
Mar 2 18:18:32 web postfix/smtpd[27153]: NOQUEUE: reject: RCPT from
unknown[xxx.xxx.xxx.xxx]: 451 4.3.0 <sa...@some_domain.com>: Temporary
lookup failure;
e-mail addresses in the above is, of course, fictitious.
donny_bra...@example.co.uk is hosted elsewhere, sa...@some_domain.com
is hosted on this box. The server is running RHEL5, with the stock Red
Hat rpm recompiled with mysql support.
The mysql database sits on another server, and is mostly idle (the
Postfix box has very low traffic so far). I am unable to reproduce any
query problems outside of postfix. Doing the queries directly in the
mysql shell just works. The following also works 100%:
# postmap -q sa...@some_domain.com
mysql:/etc/postfix/mysql_virtual_alias_maps.cf
sa...@some_domain.com
I have verified the usernames/passwords in the mysql_*.cf files.
Nothing was changed in the last few days. So I have two questions about
the above:
1. What could possibly cause postfix to have lookup problems when
nothing else does? The server did run out of disc space a few days
ago. I did a postsuper -s -v which didn't show any problems. Could the
disc space issue have damaged something?
2. Is there a way to enable debugging output for connections from apache?
3. I looks like the query fails when the mysql connection has timed
out. Can postfix be told to reconnect automatically instead of
accepting it as a failure?
Thanks
--kj