[Maia-users] Upgrade Issues

[Robert LeBlanc]

Danita Zanre wrote:
>>Have you adjusted the GRANT statements in the database to allow your
>>amavis/maia user to connect to it from all of the hosts that need to
>>communicate with it?
> 
> 
> This was one of my first thoughts.  Of course, the server that cannot stay connected IS localhost, and it connects, but then says the server has "gone away."  That said, I even added the IP address of the server just in case.  The server that can connect is an external server, and it also has the proper permissions and does not seem to have any difficulties whatsoever.
> 
> BTW, between the two servers there are about 18 million SMTP connections per month.  In another message you mentioned that a "light load" might cause such problems, but there is no light load here - in fact in the few minutes that I had postfix running the last time I loaded it to test, the active queue directory piled up 700 messages on a Sunday afternoon!  I don't think a "timeout" is what's at play here at all.

If your GRANTs are correct and it's not an idle timeout, it's a matter
of figuring out what else may be causing the MySQL connection to break.
 How often does this happen?  Every time a mail item is received, or
does it only happen occasionally?  Does amavisd-maia /ever/ process any
mail successfully on that host?

As Joel pointed out, the max_allowed_packet setting is another common
culprit, if set too low (the default setting is 1 MB).  If these
disconnects only happen with larger mail items, that would be a
significant clue.

If the connections drop /every/ time amavisd-maia tries to process mail,
then try manually logging into the MySQL console from the amavisd-maia
host, using your amavis/maia login information.  Is the connection
accepted?  Can you issue a SELECT query on any of the Maia-related
tables?  Can you use an UPDATE query to modify the values of columns in
any of these tables?  Admittedly, this is just a test of the GRANT
statements, but it's a good way to rule that out.

-- 
Robert LeBlanc <rjl at renaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamailguard.com/>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
Url : http://www.renaissoft.com/pipermail/maia-users/attachments/20060910/fc57520e/attachment-0001.bin