On Wednesday 08 September 2004 12:25 pm, Chris Ess wrote: > On Wed, 8 Sep 2004, Ken Jones wrote: > > Hi, > > > > Here is something we built into vpopmail for sites like yours. > > > > Use mysql on the email server. Have the billing system > > insert an entry in the vpopmail table, leaving the directory > > field blank. vpopmail will automatically create the users > > directory and update the database when any program > > tries to deliver mail to the user, or authenticate as the user. > > That's really neat! I didn't realize you could do this. (Now someone > will tell me that it's in the documentation that I seem to've not read > recently.)
It is probably in the mailing list archives. I'm not sure if anyone has updated the documentation. > > (I know this is getting offtopic...) So I could use an INSERT statement in > SQL instead of vadduser? Or am I not understanding this correctly? That is the idea. A while back some folks wanted to hook up their billing systems to vpopmail. Basicly they would insert into the vpopmail sql table. The only thing they couldn't do easily was create the hashed directory path. So we put in vpopmail code to check if the path is blank and automatically create the new path and update the database. You will also need to set the encrypted password using mysql's CRYPT function. Mysql's standard encryption functions are not compatible with unix/linux. Ken
