Re: [vchkpw] Custom Fields ?
The user directory and the corresponding Maildir is created by vdelivermail if it does not exist (make_user_dir(...) in vpopmail.c called from vdelivermail.c) and does not depend on the backend. On Wed, 13 Dec 2006, Joshua Megerman wrote: On Wednesday 13 December 2006 01:47, Rick Widmer wrote: Joshua Megerman wrote: In my experience, as long as you add new fields AFTER the existing vpopmail fields, you shouldn't have any problems. The order of the fields in the table should not matter. I believe vpopmail always uses explicit lists, so as long as you provide all of the required fields it should be happy. OK, I just looked at the MySQL code (the backend I use, and therefore am familiar with) and you're correct. I don't know if that changed since sometime in 5.3.x, when I first played with extending the DB, but at this point it looks like the columns are explicitly stated in order for all relevant SQL queries, so the order in the DB shouldn't matter. Just don't change the order in the query without changing the code - that I know for certain :) I believe vdelivermail has support for creating the Maildir for a user when the first email comes in. All you have to do is create the database entry and wait for a message. (Maybe the one sent by John's onchange patch.) disclamerI may be wrong, I use cdb./disclamer I believe you are correct - the user dir doesn't get created until the first attempt by vpopmail to either read or write to it (e.g., deliver a message, check via pop3, etc.). I don't think this depends on the backend, as every backend stores the location of the user dir effectively the same way. Josh
[vchkpw] Custom Fields ?
Hi, i am trying to use vpopmail to administer qmail base as mysql, i was wondering if there is a way to create new fields when you create a new user, for example when you create new user i would like the option to add maybe a phone number field or an id number field, so the admins can look up records quicker. Cheap talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. http://voice.yahoo.com
Re: [vchkpw] Custom Fields ?
Hi, i am trying to use vpopmail to administer qmail base as mysql, i was wondering if there is a way to create new fields when you create a new user, for example when you create new user i would like the option to add maybe a phone number field or an id number field, so the admins can look up records quicker. In my experience, as long as you add new fields AFTER the existing vpopmail fields, you shouldn't have any problems. Just remember that you're likely to break things if you do something funky. Also, you'll have to populate those fields manually after you create the user unless you want to hack the vpopmail code to do it directly. YMMV... Josh -- Joshua Megerman SJGames MIB #5273 - OGRE AI Testing Division You can't win; You can't break even; You can't even quit the game. - Layman's translation of the Laws of Thermodynamics [EMAIL PROTECTED]
Re: [vchkpw] Custom Fields ?
Joshua Megerman wrote: In my experience, as long as you add new fields AFTER the existing vpopmail fields, you shouldn't have any problems. The order of the fields in the table should not matter. I believe vpopmail always uses explicit lists, so as long as you provide all of the required fields it should be happy. Just remember that you're likely to break things if you do something funky. Yes. The fields vpopmail uses must be the right size and type. Also, you'll have to populate those fields manually after you create the user unless you want to hack the vpopmail code to do it directly. I believe vdelivermail has support for creating the Maildir for a user when the first email comes in. All you have to do is create the database entry and wait for a message. (Maybe the one sent by John's onchange patch.) disclamerI may be wrong, I use cdb./disclamer Rick