what exactly is the "learn password" option?
> He can also enable the learn password option in vpopmail, I think
> would be
> an easy way to deal with it myself. What do you think?
> ----- Original Message -----
> From: "Paul L. Allen" <[EMAIL PROTECTED]>
> To: "Oliver Etzel - GoodnGo.COM (R)" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, October 27, 2003 6:47 AM
> Subject: [vchkpw] Re: Inserting new users via mysql-insert into the
> > Oliver Etzel - GoodnGo.COM \(R\) writes:
> > > I want to create new users like [EMAIL PROTECTED] NOT with
> > > BUT with just inserting it via mysql-insert into the vpopmail
> > > database.
> > OK, you have now explained what you want to use instead. Somebody
> > pointed out that the maildir will be created automatically by
> > if the user exists (I hadn't realized it did that until I read
> > message and looked at the code just now) so you can get away with
> > that. What you have yet to explain is any valid or sensible
> > you want to do this.
> > > Any hints,
> > > how I can generate the encrypted password in the column
> > > (looks like this $1$S/TPu$GjMMj7yMJqG.0ckx) ???????
> > Not without breaking out of MySQL and returning to the shell. The
> > hard way is to get a shell prompt, use passwd to set the password
> > dummy system user then copy the crypted password into the MySQL
> > The harder way is to write a perl script that generates some good
> > salt, calls crypt to crypt the password then uses the DBD modules
> > insert the user into MySQL. An easy way to do it is to add the
> > user with MySQL giving garbage for the crypted password then use
> > to set a valid crypted password. The very easy way to do it is to
> > vadduser.
> > You CANNOT do it all from MySQL. You CAN do it all with vadduser.
> > is more, I can see no reason why you would want to add a user but
> > have the maildir created at the same time, which is all you could
> > if you could do it all from MySQL If you have some automation
> > that can only cope with adding MySQL rows then you'll still have
> > modify it to shell out to generate the crypted password, so you
> > as well modify it to shell out and run vadduser anyway. If you
> > domain admins to be able to add users this way because they cannot
> > vadduser you'll still have to write code that validates they can
> > modify their own domains, so you'd be far better off installing
> > like qmailadmin on your server.
> > --
> > Paul Allen
> > Softflare Support