On Sun, Mar 30, 2003 at 05:09:49PM -0600, Jerry Amundson wrote:Mircea Damian wrote:I'm looking for a way to convince maildrop to create a Maildir if it doesn't exist. [...]
No, it's not possible with maildrop.
Try having it done through the system, /etc/skel for example, or trigger it
off mysql somehow...
jerry
Hmm... I'm interested to add this feature to maildrop. I'm keen to work on it if this is possible.
Right now I have daemon looking for new accounts that is able to copy a
skel directory for them. This, unfortunately, is an asyncronous method and
is not nice at all.
Couldn't figure out a way to trigger something from mysql directly.
Best I can tell (without being a MySQL guru -- or even a user ;-), you can't trigger it from within MySQL. By my reading of the following page, it appears MySQL doesn't currently support triggers at all:
http://www.mysql.com/doc/en/ANSI_diff_Triggers.html
Do you have the option of using another database, such as PostgreSQL? There are several procedural languages that are pre-defined in PostgreSQL which could almost certainly do what you want. Although I think they have to be explicitly enabled at compile time, they could presumably help out if you have the option.
http://www.postgresql.org/docs/view.php?version=7.3&file=triggers.html
http://www.postgresql.org/docs/ view.php?version=7.3&idoc=1&file=programmer.html
(specifically see sect. II: 9.3, 9.5, 9.8; as well as sect. III)
Of course, having some sort of daemon (or cron job? ick!) that checks for updates is probably a better idea -- if you can reasonably expect to have a useable delay period between the creation of the entry in the database, and the arrival of the first mail.
Obviously, if you can't expect that to be true... then you either need to modify the app on the other end (if you have access) to fire off the process of creating the new maildir, or migrate to a database (again, if you can) that does support triggers and procedural languages, so it can fire off the maildir creation process.
HTH!
-jab
------------------------------------------------------- This SF.net email is sponsored by: The Definitive IT and Networking Event. Be There! NetWorld+Interop Las Vegas 2003 -- Register today! http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
