Yeah - problem would be support thereof... If I just did it say once every
10 minutes, I'd be guaranteed to have 1 in 1000 freaking out because of a
horendous typo they just found out about, which they corrected and isn't
reflected in their tests (assuming they test ;-)
I'd have to dump them all pretty often, or have to change the database to
detect change time on the memo and select / dump based on that, which I
guess I could do as well, just seemed like an icky work around.
Figured I'd see if someone else was struggling with the same issue ;-)
I wonder which would be worse - a query per mail for the small percentage of
users on vacation, or a query per minute for all the users, rewriting
changed vacation messages as I go ;-)
Thanks for the refinement of the idea.
m/
-----Original Message-----
From: cour...@lists.sourceforge.net
[mailto:cour...@lists.sourceforge.net]On Behalf Of Gordon
Messmer
Sent: Monday, July 26, 2004 2:58 PM
To: cour...@lists.sourceforge.net
Subject: Re: [courier-users] mailbot for virtual users? Read message
from MySQL?
Mitch (WebCob) wrote:
I'd like to start using mailbot, but I've got a bit of a problem... I
maintain my vacation messages in a MySQL database along with
the login info
etc.
...
One alternative I see, is to forge dumping the message from
MySQL to a temp
file every time a vacation message is to be sent, but that
seems wasteful.
You could periodically dump the users' messages to plain text files in
their home directories. It's probably more efficient than dumping files
every time a message is sent, and requires no changes to mailbot.