On Wed, 8 Sep 2004, Ken Jones wrote: > On Wednesday 08 September 2004 12:25 pm, Chris Ess wrote:
[snip] > It is probably in the mailing list archives. I'm not sure if anyone has > updated the documentation. I wonder if a group of us should get together and update the documentation with all of the neat things mentioned on the mailing list. (Alternatively, I wonder if we'd ever have the time...) > > (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. Okay. Makes sense. > 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. Yep. I'm not sure how far I trust MySQL's ENCRYPT() function since I've had issues with MD5 passwords and the crypt() function in Perl. The 'Change MySQL Password' plugin for squirrelmail at http://www.squirrelmail.org/plugin_view.php?id=25 includes an MD5 password algorithm in PHP which works pretty nicely. I'll have to test out the functionality of the INSERT. I have a vpopmail admin plugin for squirrelmail (have to ask my boss if I can distribute it so don't ask me for a copy yet) that uses a set-uid vadduser to handle adding users. I'd love to get rid of that. While I'm thinking about it, I can use a DELETE query to remove the row for a user and then queue a job (I'll worry about how to set this up) to archive/delete the user's mail, right? Sincerely, Chris Ess System Administrator / CDTT (Certified Duct Tape Technician)
