On Wed, 8 Sep 2004, Ken Jones wrote:

> On Wednesday 08 September 2004 12:25 pm, Chris Ess wrote:


> 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?


Chris Ess
System Administrator / CDTT (Certified Duct Tape Technician)

Reply via email to