[Maia-users] Upgrade Issues

[Danita Zanre]

>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 far as I can tell, it has not successfully processed even one message since I started upgrading packages yesterday to get ready for the upgrade - here's where I've gotten so far:

1.  I shurdown postfix and Maia on that server.

2.  I copied the maia.conf file over to the /etc directory and set it up so that I could run the configtest.pl script.

3.  I ran the script and found the packages that needed upgrading.

4.  I spent a lot of time futzing with various packages - the ones that were difficult were BerkeleyDB and File - but I finally got those upgraded.

5.  amavisd is still 1.0.0. RC5, and nothing has been modified yet on the PHP side.

6.  Obviously the mysql database "works" because the other server is using it happily.  I feel like something has just gone terribly wonky during my attempts to get the packages upgraded so that 1.0.1 could be installed.  :(

> 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.

Yes, I can log in as the maia user with no trouble, issue a Select command, etc. However, I have no idea how to turn on the connection log in mysql!  What do I need to add to the my.cnf for that?

Thanks.

Danita