Re: FW: FW: maia_mail keeps growin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Michiel van den Berg wrote:

>> mysql> select * from maia_mail_recipients where
mail_id=9536 and
>> type='C';
>> +---------+--------------+------+---------------+
>> | mail_id | recipient_id | type | token         |
>> +---------+--------------+------+---------------+
>> |    9536 |           20 | C    | expired209536 |
>> |    9536 |           31 | C    | expired319536 |
>> +---------+--------------+------+---------------+
>> 2 rows in set (0.02 sec)
> 
>> mysql> delete from maia_mail_recipients where
mail_id=9536 and  
>> type='C'
>> limit 1;
>> Query OK, 0 rows affected (0.00 sec)

Are you sure that this user (presumably your amavis/maia
user) has
DELETE privileges on the Maia database?  This should have
been set
during the Maia installation process, as part of the GRANT
statement, e.g.

GRANT CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE ON
maia.* TO
amavislocalhost IDENTIFIED BY 'passwd';

You might even want to try issuing the GRANT statement
again, to be
sure; if your "mysql" database has become
corrupted it may have
forgotten the privilege assignments you've made.

If this fails, I'd recommend that you dump out the contents
of your Maia
database, drop the current one, create an empty one, and
reload it from
your dump file.  Only uncorrupted records will end up being
backed up
this way, so your new database should function properly.

- --
Robert LeBlanc <rjlrenaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamail
guard.com/>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD4DBQFGhVrUGmqOER2NHewRAjXHAJdHR3peqKFYv6m/0QEA8kgEq3YxAKCO
qbQc
guB+Xzw2mdJNbkEIQEsElw==
=/Zj7
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users