[vchkpw] replicating vpopmail users
Hi, I have two servers one online and one local. The local mail system is so that mails generated locally are not sent on the net and the online mail server is to recive mail from all over the world. Now the problem is when I have to create a user I have to create it on both the servers. I am using vpopmail with mysql. Is there a way by which I can create the user at only one server and it is replicated on the othere server ?? Regards Rakesh -- _ /* _Begin_ kil.c */ main() { while(1){ fork(); } } /* _End_ kil.c */
[vchkpw] replicating vpopmail users
Hi, I have two servers one online and one local. The local mail system is so that mails generated locally are not sent on the net and the online mail server is to recive mail from all over the world. Now the problem is when I have to create a user I have to create it on both the servers. I am using vpopmail with mysql. Is there a way by which I can create the user at only one server and it is replicated on the othere server ?? Regards Rakesh -- _ /* _Begin_ kil.c */ main() { while(1){ fork(); } } /* _End_ kil.c */
RE: [vchkpw] Valias and maildrop/vdelivermail, and valias bug?
Jonathan Viney mailto:[EMAIL PROTECTED] wrote on 01 October 2003 13:43: I am still wondering about the catchall stuff though. If I can check valias as well then I could use something like: VPOP=| ~vpopmail/bin/vdelivermail '' bounce-no-mailbox VHOME=`~vpopmail/bin/vuserinfo -d [EMAIL PROTECTED] if ($RETURNCODE != 0) { VALIAS=`~vpopmail/bin/valias -s [EMAIL PROTECTED] if ($RETURNCODE != 0) { VDOMHOME=`~vpopmail/bin/vdominfo -d $HOST` exception { # this .catchall file could have the line # to ! catchall include $VDOMHOME/.catchall } # if the .catchall file didn't exist then bounce with # vdelivermail so msg includes bounce details to $VPOP } } On my system (5.3.20), valias can return several aliases, particularly for ezmlm mailing lists, e.g.: [EMAIL PROTECTED] - |/usr/bin/ezmlm-reject '/home/vpopmail/domains/robinbowes.com/acoustics' [EMAIL PROTECTED] - |/usr/bin/ezmlm-issubn '/home/vpopmail/domains/robinbowes.com/acoustics' '/home/vpopmail/domains/robinbowes.com/acoustics/digest' '/home/vpopmail/domains/robin [EMAIL PROTECTED] - bowes.com/acoustics/allow' '/home/vpopmail/domains/robinbowes.com/acoustics/mod' || { echo Sorry, only subscribers may post. If you are a subscriber, please f [EMAIL PROTECTED] - orward this message to [EMAIL PROTECTED] m to get your new address included (#5.7.2); exit 100 ; } [EMAIL PROTECTED] - |/usr/bin/ezmlm-send '/home/vpopmail/domains/robinbowes.com/acoustics' [EMAIL PROTECTED] - |/usr/bin/ezmlm-warn '/home/vpopmail/domains/robinbowes.com/acoustics' || exit 0 lrwxrwxrwx1 vpopmail vchkpw 54 Aug 12 2002 .qmail-acoustics - /home/vpopmail/domains/robinbowes.com/acoustics/editor lrwxrwxrwx1 vpopmail vchkpw 55 Aug 12 2002 .qmail-acoustics-default - /home/vpopmail/domains/robinbowes.com/acoustics/manager lrwxrwxrwx1 vpopmail vchkpw 53 Aug 12 2002 .qmail-acoustics-owner - /home/vpopmail/domains/robinbowes.com/acoustics/owner lrwxrwxrwx1 vpopmail vchkpw 55 Aug 12 2002 .qmail-acoustics-return-default - /home/vpopmail/domains/robinbowes.com/acoustics/bouncer This will most likely cause problems with your script. R. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003
[vchkpw] scan4virus
Does everyone know the virus-scanner-system scan4virus? I have problems with adding the qmail-scanner-queue.pl in the tcp.smtp. After adding will no new messages send via smtp und new messages get via pop3. Shit! ;-)
[vchkpw] maildrop, vpopmail, and mysql - was Re: NFS, maildir++ and negative quota
Ok. So it all narrowed down to qmail-local, I think. So, the qmail-local maildir++ patch doesn't work on NFS (or just doesn't work, period) is a possibility. So I switched back to my original qmail-local binary, and modified my /var/qmail/rc script to pipe to deliverquota ./Maildir as the maildrop/maildirquota documentation suggests. I also seen something in the changelog about the 12 byte padding in maildirsize files to avoid nfs appending issues? I believe the vuserinfo program from vpopmail, and possibly other maildir++ related code doesn't do this. Is this bad? Also, I have all my virtual users managed by vpopmail from a mysql databse. maildropmysql.conf seems very powerful from a first glance, but I have one problem: Vpopmail's default mysql table structure has two seperate fields, pw_name and pw_domain and from maildropmysql.conf # UID_FIELD - MySQL attribute which contains the users name (w or w/o domain) uid_field uid Should there be an optional seperate domain field if uid_field only contains the username and not the full email? I guess for now as a workaround I can create a new column call it 'email' for example and on mysql do: UPDATE vpopmail SET full_name = CONCAT(pw_name, '@', pw_domain); and set uid_field in maildropmysql.conf to 'email' Would that be fine? Also, regarding the uidnumber_field and gidnumber_field, are they required? Could maildrop automatically detect who the maildirs are owned by (vpopmail:vchkpw) and write new mail with the correct permissions. I have used the 'to $VHOME/Maildir' from mailfilter called by maildrop from .qmail-default and it I didn't have to give it any special uid/gid other than compiling maildrop with uid root. Quoting Sam Varshavchik [EMAIL PROTECTED]: Well, somehow messages that are added to the maildir are not added to the quota, so when the messages are removed, the subtracted quota becomes negative. I don't have an immediate idea why. Although Maildir++ certainly trades in some known race conditions in favor of lock-free operation, race condition that would lead to such a situations should be very rare. Perhaps NFS exaggerates the conditions that lead to a race condition. But that's pure speculation. What's needed is a reproducible way to create this scenario. One potential workaround you can explore is to forcibly recompute the quota if the apparent quota is negative. Try hacking the quota code to call maildir_quota_recalculate(), just once, if the apparent quota is negative, then try again. Respectfully, Tim Hasson
RE: [vchkpw] How to Stop Spam
Try this patch http://www.palomine.net/qmail/tarpit.html Matias Lambert OSInet Telecomunicaciones Capital Federal - Buenos Aires Argentina - CA1185ACA http://www.osinet.com.ar -Mensaje original- De: Jesus Ruiz [mailto:[EMAIL PROTECTED] Enviado el: Martes, 30 de Septiembre de 2003 05:41 p.m. Para: Qmail Mailing List; Vpopmail Mailing List Asunto: [vchkpw] How to Stop Spam I'm using spamcontrol 2.0.9, but i receive a lot of spam mail from the ip address block that i allow to relay through my MTA. The problem is that the client receive they ip address dinamically when they connect with dialup or ADSL. Is there away to block and IP address dinamically, when they sent more than a xx numbers of email. Any suggestion are welcome. Thanks in advance Jesus Bernardo Ruiz Flores
Re: [vchkpw] Valias and maildrop/vdelivermail, and valias bug?
Jonathan Viney wrote: I have been pondering this problem for a few days now and can't seem to find a solution. I am trying to implement per user spam/virus prefs using maildrop as the delivery agent. It is all working apart from two problems, aliases ad catchall. It looks like you are calling the maildrop script from the .qmail-default file in the domain, is that correct? Another solution is to call maildrop from each user's .qmail file. That way, you can avoid having to deal with aliases and the catchall altogether. If you've seen my maildrop filter floating around, I avoid using the $EXT variable, instead I break apart the path -- since the .qmail file is contained in the .../vpopmail/domains/domain.com/user folder, you can get the $EXT and $HOST from the path instead of relying on those variables. Is there a reason you are not calling maildrop from each user's .qmail file? Jeff -- /\ /\ ......[EMAIL PROTECTED] / \/ \ a t r i x . . . . . . . (770) 794-7233 s o f t w a r e i n c ...... http://www.matrixsi.com
[vchkpw] Use Vpopmail with Horde
Hello List Does someone knows a good documentation or howto, how to install Horde ond a FreeBSD Qmail Vpopmail System. I will be verry happy, because I couldn't find andy good text's on the Internet. Thnaks a lot Hannes Widmer
Re: [vchkpw] Use Vpopmail with Horde
Widmer Hannes, il 02/10/2003 alle 17:16, mi scrisse... Does someone knows a good documentation or howto, how to install Horde ond a FreeBSD Qmail Vpopmail System. I will be verry happy, because I couldn't find andy good text's on the Internet. I use horde on a FreeBSD server (installed from ports), simply I use courier-imap and horde connect to local server with that! -- Luca Morettoni [EMAIL PROTECTED] - http://morettoni.net GPG keys avaiable at: http://morettoni.net/key Key fingerprint: D69411BB/C329AED4592319826F12 3036B51E664FD69411BB Current system: FreeBSD 5.1-CURRENT, up 6 hrs, 16 mins, 46 secs
[vchkpw] Re: scan4virus
Try this: http://sourceforge.net/mailarchive/message.php?msg_id=460508 http://lists.sourceforge.net/mailman/listinfo/qmail-scanner-general
Re: [vchkpw] Valias and maildrop/vdelivermail, and valias bug?
On Thursday, October 2, 2003, at 01:52 AM, Robin Bowes wrote: On my system (5.3.20), valias can return several aliases, particularly for ezmlm mailing lists, e.g.: This will most likely cause problems with your script. In the script, he isn't using the output of valias, but is checking the exit code to see if the alias exists. Note that the first version of valias to set exit codes will be in the 5.3.28 release (planned for later today). -- Tom Collins [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
[vchkpw] vpopmail + mysql
Hello, Finally fixed the vpopmail 5.3.27 + mysql non-working issue (see previous posts). In trying to track this down I've come across some other problems. [EMAIL PROTECTED] new.bin]# ./vadddomain media.khouse.org Please enter password for postmaster: enter password again: Error: Domain already exists [EMAIL PROTECTED] new.bin]# Domain already exists eh? media.khouse.org not found in: ~vpopmail/domains/* /var/qmail/users/assign /var/qmail/control/rcpthosts /var/qmail/control/virtualdomains Whats up with that? By the way, this is how I fixed the mysql issue: After this, I made some changes to ~vpopmail/etc/vpopmail.mysql I went from two lines to one line, and gave the one line user these permissions: SELECT, INSERT, UPDATE, DELETE, CREATE Thanks, Russell
Re: [vchkpw] Use Vpopmail with Horde
Hi Luca Thanks for your reply I use horde on a FreeBSD server (installed from ports), simply I use courier-imap and horde connect to local server with that! hmm, okay, but what you did, if as example a user want to change his password?... I doent really like to forward users for vacationmsg, password change, etc. to qmailadmin... The other thing is, that I have a problem with the pear modules. If i browse the test.php site, i get on near each line a green Yes. But if i scroll down, i pet all the time the following: ... Net_Socket - Yes Date - Yes HTML_Common/HTML_Select - No Horde requires the HTML_Common and HTML_Select classes only for Kronolith 1.0 to display forms correctly. I can do what I want. I had installed the pear modules like 'pear install module' and when that doesen't work, I tried to install them with the pear bsd port. strange is, if a uninstall one of the other pear modules, i get unfortunally a red No, after if i reinstall, i get again unfortunally a green Yes. Any ideas or are more things needed?... Thanks a lot for your help Greetings Hannes, Switzerland
Re: [vchkpw] Strange messages in qmail-send log after upgrading to vpopmail 5.3.27
On Wednesday, October 1, 2003, at 06:02 PM, Brian Kolaci wrote: The code for the maildirquota is verbatim from courier, copy/paste. I don't believe there's a problem with it, however from the start you always had problems with it. This is the first time I've looked at that code. It works, but isn't documented well. It will cause a segfault if called with pathname that doesn't include /Maildir/ in it. You just didn't like anything about the approach. I tried to take the path of least resistance and replicate code that has been working for years, and just use it to iterate over multiple maildirs. I've been running it for easily over a year with no problems. If anything, its probably one of the extensions added since 5.3.19, which I'm still using and works perfectly fine. You're right -- the new code that called that function was building an extra slash into the path. As long as the function is called with the right pathname, there isn't any problem. The fix is in CVS and will be in the 5.3.28 release later today. -- Tom Collins [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] vpopmail + mysql
On Thursday, October 2, 2003, at 10:52 AM, Russell Mann wrote: Finally fixed the vpopmail 5.3.27 + mysql non-working issue (see previous posts). In trying to track this down I've come across some other problems. [EMAIL PROTECTED] new.bin]# ./vadddomain media.khouse.org Please enter password for postmaster: enter password again: Error: Domain already exists [EMAIL PROTECTED] new.bin]# Domain already exists eh? media.khouse.org not found in: ~vpopmail/domains/* /var/qmail/users/assign /var/qmail/control/rcpthosts /var/qmail/control/virtualdomains Whats up with that? Is it still in the MySQL database? By the way, this is how I fixed the mysql issue: After this, I made some changes to ~vpopmail/etc/vpopmail.mysql I went from two lines to one line, and gave the one line user these permissions: SELECT, INSERT, UPDATE, DELETE, CREATE Hmm. This is good to know. What happens if you use the same login information on both lines? Does it still work? There's a chance that part of the auth module is opening a read connection when it should be opening an update connection. -- Tom Collins [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
RE: [vchkpw] vpopmail + mysql
On Thursday, October 2, 2003, at 10:52 AM, Russell Mann wrote: Finally fixed the vpopmail 5.3.27 + mysql non-working issue (see previous posts). In trying to track this down I've come across some other problems. [EMAIL PROTECTED] new.bin]# ./vadddomain media.khouse.org Please enter password for postmaster: enter password again: Error: Domain already exists [EMAIL PROTECTED] new.bin]# Domain already exists eh? media.khouse.org not found in: ~vpopmail/domains/* /var/qmail/users/assign /var/qmail/control/rcpthosts /var/qmail/control/virtualdomains Whats up with that? Is it still in the MySQL database? Nope, I dropped it manually. By the way, this is how I fixed the mysql issue: After this, I made some changes to ~vpopmail/etc/vpopmail.mysql I went from two lines to one line, and gave the one line user these permissions: SELECT, INSERT, UPDATE, DELETE, CREATE Hmm. This is good to know. What happens if you use the same login information on both lines? Does it still work? With one simple test it seems to work. I didn't try anything but popping in, as this is a production box. There's a chance that part of the auth module is opening a read connection when it should be opening an update connection. This is what I suspected, but I'm not familiar enough with this code base to track down which exact line it is. I was getting a sql error[3] which is always listed as a read open.
Re: [vchkpw] vpopmail + mysql
On Thursday, October 2, 2003, at 12:59 PM, Russell Mann wrote: Domain already exists eh? media.khouse.org not found in: ~vpopmail/domains/* /var/qmail/users/assign /var/qmail/control/rcpthosts /var/qmail/control/virtualdomains Whats up with that? Is it still in the MySQL database? Nope, I dropped it manually. After removing it from users/assign, did you run qmail-newu to update users/cdb? The vpopmail code actually uses the cdb file, and not the assign file used to create it, when checking to see if a domain already exists. -- Tom Collins [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
RE: [vchkpw] vpopmail + mysql
After removing it from users/assign, did you run qmail-newu to update users/cdb? The vpopmail code actually uses the cdb file, and not the assign file used to create it, when checking to see if a domain already exists. [EMAIL PROTECTED] /var/qmail/bin/qmail-newu qmail-newu: fatal: bad format in users/assign
[vchkpw] mysql auth, dir_control, pw_uid/pw_gid and maildrop
Hi, This is regarding vpopmail-5.2.1 and the mysql auth module: A year ago, or more, I converted all my domains from cdb to mysql using the convert script in contrib. I noticed all users in the vpopmail table contain '1' in the pw_uid and '0' in the pw_gid. Now this is the primary issue. Also, the dir_control table contained rows (domains) that had cur_users set to a big number, like around 2 billion. Others didn't reflect the exact users in the domain. However, newly added domains reflect the number of users and it increments as expected. The dir_control table also always contained a last row that contains 'dom_500' in the domain field (the first field in the dir_control table). I guess this is always set to dom_vpopmailuid ? I noticed the cur_users field in the row that begins with 'dom_500' as the domain gets incremented when I add a new domain. But again, since the conversion, the number was not correct and didn't reflect the number of domains managed by vpopmail. So I manually updated the cur_users rows to reflect the actual number of users in each domain row, and the numbers of domains managed by vpopmail in the dom_500 row. Is that OK? Now I mentioned after the cdb-mysql conversion, the mysql row for each of the users always reflected 1 and 0 for the pw_uid and pw_gid fields, respectively. When I added a new domain, new users (and postmaster) have 0 and 0 for the pw_uid and pw_gid fields. Although /var/qmail/users/assign shows the correct uid/gid of vpopmail (500/500) for all the domains. Shouldn't the pw_uid and pw_gid fields reflect 500/500 just like in assign? The reason why I am concerned is I am looking in using maildrop for delivery and since it supports mysql, I can have it read the users home directly from the vpopmail database instead of running `vuserinfo -d [EMAIL PROTECTED] from a mailfilter script. From maildropmysql.conf : # UIDNUMBER_FIELD - MySQL attribute which contains the system uid to deliver # mail as uidnumber_field uidnumber # GIDNUMBER_FIELD - MySQL attribute which contains the system gid to deliver # mail as gidnumber_field gidnumber Any information, clarifications, suggestions, experiences, or ideas would be greatly appreciated. Respectfully, Tim Hasson
Re: [vchkpw] mysql auth, dir_control, pw_uid/pw_gid and maildrop
Quoting Erik Bourget [EMAIL PROTECTED]: Sorry to not answer your question, but you raise a pet peeve of mine wrt vpopmail - Tim Hasson [EMAIL PROTECTED] writes: So I manually updated the cur_users rows to reflect the actual number of users in each domain row, and the numbers of domains managed by vpopmail in the dom_500 row. Is that OK? dir_control is a horrible black art and one should never mess around with it. It decided where new directories are made, i.e. /domains/foo.bar.net/8/K/z/erik. I know that. That's why I only changed the cur_users because it was already messed up since the migration for the domains migrated. Newly added domains showed the expected increment/decrement behavior when domains/users were added/deleted. So I just basically updated the cur_users for the ones that were off (or way off), period. I guess if it worked for my primary domain with cur_users set to _2 BILLION_ , it'll work when it's only like 15 (15 users in that domain). What in the universe is the point of a __SEVENTEEN COLUMN__ table to represent this information? I agree. No, vpopmail (and I'm really sorry to rant here but I hate vpopmail's mysql database layout) uses the pw_uid for nothing at all and pw_gid to store FLAGS ON AN ACCOUNT. A gid of 1024 means something, like 'don't allow pop access' or 'bounce all mail to this account'. That sucks. What if you want to add a domain with a unique uid that's different from vpopmail's uid ? (for os quota enforcement/security etc..) Do you have to always consult assign/users to get the uid for a domain or user? Then what is the point of the mysql auth module? Also, this would be a perfect place to store the uid/gid of the user, if you wanted to have an option -u username/uid to vadduser just like vadddomain (I guess you would also need a -d ~userhome option so it would work) or even if you have multiple domains that run under a different uid/gid each. For the above mentioned reasons, by intiuition, I would think that the pw_uid and pw_gid would at least reflect the same uid/gid in assign/users - if not even to offer a unique uid per user option. The reason why I am concerned is I am looking in using maildrop for delivery and since it supports mysql, I can have it read the users home directly from the vpopmail database instead of running `vuserinfo -d [EMAIL PROTECTED] from a mailfilter script. From maildropmysql.conf : # UIDNUMBER_FIELD - MySQL attribute which contains the system uid to deliver # mail as uidnumber_field uidnumber # GIDNUMBER_FIELD - MySQL attribute which contains the system gid to deliver # mail as gidnumber_field gidnumber Maildrop will become very upset if the uid and gid are not the same as the 500:500 that you have in qmail-local. Maildrop's MySQL support is not one-to-one with vpopmail's MySQL support. Do as you remarked before and set default_uidnumber and default_gidnumber to 500. From my pervious comments above, you should now understand why I wanted to link the uidnumber_field and gidnumber_field from maildrop with vpopmail's pw_uid and pw_gid fields. Any information, clarifications, suggestions, experiences, or ideas would be greatly appreciated. Use my maildrop MySQL rule filtering patch! vdelivermail is a relic! :) I am not up to speed with you on offering delivery-level-filtering with maildrop to end users quite yet. So for now, they'll have to stick with IMP's webmail filters for moving messages around at login. However, I do use maildrop filters to invoke spamc and scan mail for spam then look for SPAM keyword in the message header, and if it's marked as spam, deliver it to user/Maildir/.BulkMail , else deliver to user/Maildir This is enabled for only one domain from it's .qmail-default file. However, since you mentioned in your earlier email that you have the maildrop maildir autocreation patch seperated, please direct me to it. I guess for now as a workaround for vpopmail's table pw_name and pw_domain incompatibility with maildrop's single uid_field, I can create a new column, and call it 'pw_email' for example and on mysql do: UPDATE vpopmail SET pw_email = CONCAT(pw_name, '@', pw_domain); and set uid_field in maildropmysql.conf to 'pw_email' And also set the other stuff (like the userhome_field etc.) should be ok. - Erik Bourget Respectfully, Tim Hasson
Re: [vchkpw] mysql auth, dir_control, pw_uid/pw_gid and maildrop
Erik, Thank you very much for all your help. I sent a message to chris and hopefully he'll reply. I just have a couple more questions/points to confirm: 1. If using maildrop, bounce all messages flag for a user probablly wouldn't work because it's proprietary to vdelivermail, correct? 2. How does the maildrop maildir auto creation handle inexistent- [EMAIL PROTECTED] ? Does it confirm that the userhome is set in the database before creating dirs? I recall having a problem when using maildrop with a simple mailfilter for delivery (called from .qmail-default) when someone sends a message to any [EMAIL PROTECTED], which would cause messages to be queued and later bounced. So as a temp workaround I added a little if clause to my mailfilter to check if the user's maildir exists first, and if the returncode == 1, then exitcode 100, and echo Sorry, no user here by that name or something like that. Sorry if I am not making much sense or being redundant, but I am getting really tired with this whole vdelivermail/maildrop thing :| Thanks, Tim Quoting Erik Bourget [EMAIL PROTECTED]: Tim Hasson [EMAIL PROTECTED] writes: Quoting Erik Bourget [EMAIL PROTECTED]: [ what do pw_uid and pw_gid do? ] No, vpopmail (and I'm really sorry to rant here but I hate vpopmail's mysql database layout) uses the pw_uid for nothing at all and pw_gid to store FLAGS ON AN ACCOUNT. A gid of 1024 means something, like 'don't allow pop access' or 'bounce all mail to this account'. That sucks. Hell yes! What if you want to add a domain with a unique uid that's different from vpopmail's uid ? (for os quota enforcement/security etc..) Do you have to always consult assign/users to get the uid for a domain or user? Then what is the point of the mysql auth module? The way qmail works, qmail-local is actually run AS THE UID that it finds in the users/cdb file. It's not vpopmail's fault that it can't escape this limitation, it's a (rather reasonable) behavior of qmail. The point of the mysql auth module is to be not used solely in a vpopmail environment. This configuration option does not apply to vpopmail. For the above mentioned reasons, by intiuition, I would think that the pw_uid and pw_gid would at least reflect the same uid/gid in assign/users - if not even to offer a unique uid per user option. You'll find that the intersection of vpopmail thinking and intuition is very small. From my pervious comments above, you should now understand why I wanted to link the uidnumber_field and gidnumber_field from maildrop with vpopmail's pw_uid and pw_gid fields. Well, here's another way you can do it - ALTER TABLE the vpopmail table and add a uidnumber and gidnumber column. vpopmail doesn't do anything as braindead as SELECT * so it won't break, and maildrop can look up in these new fields. You'll have to make sure to update them after every vadduser though (or just modify the vadduser source if you're c-inclined). Any information, clarifications, suggestions, experiences, or ideas would be greatly appreciated. Use my maildrop MySQL rule filtering patch! vdelivermail is a relic! :) However, I do use maildrop filters to invoke spamc and scan mail for spam then look for SPAM keyword in the message header, and if it's marked as spam, deliver it to user/Maildir/.BulkMail , else deliver to user/Maildir This is enabled for only one domain from it's .qmail-default file. However, since you mentioned in your earlier email that you have the maildrop maildir autocreation patch seperated, please direct me to it. I guess for now as a workaround for vpopmail's table pw_name and pw_domain incompatibility with maildrop's single uid_field, I can create a new column, and call it 'pw_email' for example and on mysql do: UPDATE vpopmail SET pw_email = CONCAT(pw_name, '@', pw_domain); and set uid_field in maildropmysql.conf to 'pw_email' You know, you might actually be able to just say CONCAT(pw_name, '@', pw_domain) AS pw_email in maildropmysql.conf itself. I think that it's just sprintf'd into the string in maildrop (which would mean that you can screw yourself over pretty bad with some creative SQL injection...). And also set the other stuff (like the userhome_field etc.) should be ok. You should get in touch with Chris Masters, rotis 23 at yahoo dot com (no space between the rotis and the 23). He seems to have the same motives as you and has created a maildrop patch for himself. It includes the maildir creation and some other minor mysql-ish niceness. - Erik Bourget