We are running the following vpopmail-5.4.18 courier-imap-4.1.2 courier-authlib-0.59.1 autorespond-2.0.4 netqmail-1.05
Vpopmail is setup to use MySQL with valias table created. We can create users directly in MySQL and everything works great the users pw_dir field is populated and the actual mailbox dir is created when the user logs in for the first time or receives their first email. We can create aliases in the valias table "alias, domain, valias_line" that point to an existing users email box, as well as single forwards (no box on system) Example Alias - record alias - joe, domain - mydomain.com, valias_line - &[EMAIL PROTECTED] Example Forward - record alias - bill, domain - mydomain.com, valias_line - &[EMAIL PROTECTED] What we would like to be able to do is take the remaining features in qmailadmin and push them to MySQL as well by getting rid of .qmail files in the users mail dir. Copy and Forward - example .qmail &[EMAIL PROTECTED] /home/vpopmail/domains/mydomain.com/bob/Maildir/ Vacation Message - example .qmail /home/vpopmail/domains/mydomain.com/bob/Maildir/ | /usr/local/bin/autorespond 86400 3 /home/vpopmail/domains/mydomain.com/bob/vacation/message /home/vpopmail/domains/mydomain.com/bob/vacation Robot - example .qmail |/usr/local/bin/autorespond 10000 5 /home/vpopmail/domains/mydomain.com/ROBOT/message /home/vpopmail/domains/mydomain.com/ROBOT &[EMAIL PROTECTED] With the Vacation Message and Robot we would like to have the contents of the directory stored in MySQL as well. The ultimate goal is to allow for a custom web frontend that can be incorporated into what ever web email client we run. I have see the file dotqmail2valias but from what I can tell it makes changes for alias and forwards only not anything above. Has anyone looked at this before or been able to get it to work? Any help or ideas would be appreciated. Thanks Ron