4 messages in net.sourceforge.lists.courier-usersRE: [courier-users] mailbot for virtu...
FromSent OnAttachments
Mitch (WebCob)Jul 24, 2004 11:03 pm 
Gordon MessmerJul 26, 2004 2:58 pm 
Mitch (WebCob)Jul 26, 2004 5:38 pm 
Gordon MessmerJul 27, 2004 10:35 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:RE: [courier-users] mailbot for virtual users? Read message from MySQL?Actions...
From:Mitch (WebCob) (mit@webcob.com)
Date:Jul 26, 2004 5:38:45 pm
List:net.sourceforge.lists.courier-users

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.