Le mercredi 1 juillet 2009 03:26:35, Antoine Nguyen a écrit :
> Hi,
>
> I'm actually working on a management tool for Amavis SQL quarantine. My
> first question is about email releasing. I've noticed there is a 'ds'
> field inside the msgrcpt table that is used to indicate messages status.
> When releasing a message, what value should this field take? ('R', 'D',
> ??) On the same idea, do I have to delete a message that has just been
> released from the quarantine?
>
> Talking about deletion, I've also noticed the partition_tag field added
> recently that simplify purge of old records. What about released
> messages? (If I have to delete them after releasing) Is it faster to
> planify a script (daily for example) that checks for all messages with
> their 'ds' field == 'R'?
>
> Last question, is there some documentation somewhere that explains how
> management softwares should use/understand database fields? (like 'ds')
>
> Thanks.
>
> Antoine Nguyen
>
>
> ---------------------------------------------------------------------------
>--- _______________________________________________
> AMaViS-user mailing list
> AMaViS-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/amavis-user
> AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
> AMaViS-HowTos:http://www.amavis.org/howto/
Bonjour Antoine,
You have same problem as mine. I'm modifying mailzu-ng to give more
capabilities. I've done an analysis of mysql database here:
http://imagebin.ca/view/dDS5l06N.html
if you wonder.
About table msgrcpt i found that:
rs field is empty when message is not spam, nor virii, nor banned, nor badh OR
when SPAM and in quarantine
rs is R when released
rs is D when deleted
Regards,
LD
------------------------------------------------------------------------------
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
