Re: Migrate passwords from shadow to mysql

2004-02-04 Thread Ken Murchison
Shelley Waltz wrote: Will "autotransition" transition existing md5 crypt passwords into the sql database as md5 crypt passwords using the checkpw patch described in this archive? No, autotransition only works with plaintext passwords. On Fri, 23 Jan 2004, Ken Murchison wrote: Ted Cabeen

Re: Migrate passwords from shadow to mysql

2004-02-04 Thread Shelley Waltz
Will "autotransition" transition existing md5 crypt passwords into the sql database as md5 crypt passwords using the checkpw patch described in this archive? On Fri, 23 Jan 2004, Ken Murchison wrote: Ted Cabeen wrote: > Ken Murchison <[EMAIL PROTECTED]> writes: > > >>Shelley Wal

RE: Migrate passwords from shadow to mysql

2004-02-04 Thread Tero Matinlassi
Lainaus Joe Hrbek <[EMAIL PROTECTED]>: > > I had to use > > pam_mysql and run saslauthd -a pam. Works quite nicely. > > I also > > tried to use the sasl mysql auxprop plugin (or something like > that), > > but it didn't work out then. > > > Auxprop is a way better way to go than to use saslauthd

RE: Migrate passwords from shadow to mysql

2004-02-03 Thread Joe Hrbek
> I had to use > pam_mysql and run saslauthd -a pam. Works quite nicely. > I also > tried to use the sasl mysql auxprop plugin (or something like that), > but it didn't work out then. Auxprop is a way better way to go than to use saslauthd, especially for mysql. imho, -j

Re: Migrate passwords from shadow to mysql

2004-02-03 Thread Tero Matinlassi
Lainaus Shelley Waltz <[EMAIL PROTECTED]>: > The more I have thought about it, I do not wish to have my users' > passwords in plaintext anywhere. I have about 250 users with > already > encrypted md5 passwords in the shadow file. Is there a utility to > migrate > this information the the MySQL m

Re: Migrate passwords from shadow to mysql

2004-02-03 Thread Shelley Waltz
The more I have thought about it, I do not wish to have my users' passwords in plaintext anywhere. I have about 250 users with already encrypted md5 passwords in the shadow file. Is there a utility to migrate this information the the MySQL mail database? This will allow me to manage the user ac

Re: Migrate passwords from shadow to mysql

2004-01-23 Thread Ken Murchison
Shelley Waltz wrote: One other question ... RH ES supplies cyrus-sasl-2.1.15-3 as an rpm in bin or src. I found a cyrus-imapd-2.1.16-6.src.rpm, but could not locate a bin or src rpm for cyrus-sasl-2.1.17. I prefer to be able to upgrade by rpm rather than tar.gz - does anyone know if sasl is avail

Re: Migrate passwords from shadow to mysql

2004-01-23 Thread Shelley Waltz
One other question ... RH ES supplies cyrus-sasl-2.1.15-3 as an rpm in bin or src. I found a cyrus-imapd-2.1.16-6.src.rpm, but could not locate a bin or src rpm for cyrus-sasl-2.1.17. I prefer to be able to upgrade by rpm rather than tar.gz - does anyone know if sasl is available in rpm? On Fri,

Re: Migrate passwords from shadow to mysql

2004-01-23 Thread Ken Murchison
Shelley Waltz wrote: Ken, Thanks for the very clear instructions on how this works. One thing which does not make sense is the removal of the mech_list option subsequent to all users in the shadow file having auth'd once. ??? Because once the users are transitioned to the sql database, then you

Re: Migrate passwords from shadow to mysql

2004-01-23 Thread Shelley Waltz
Ken, Thanks for the very clear instructions on how this works. One thing which does not make sense is the removal of the mech_list option subsequent to all users in the shadow file having auth'd once. ??? Also, why are the transitioned passwords stored in plaintext in the mysql database? rega

Re: Migrate passwords from shadow to mysql

2004-01-22 Thread Ken Murchison
Ted Cabeen wrote: Ken Murchison <[EMAIL PROTECTED]> writes: Shelley Waltz wrote: I am installing a new postfix-cyrus mail server. I currently have cyrus-imap 1.6.24 authing PLAIN from /etc/shadow. I wish to migrate the passwords(md5) from the shadow file to a mysql database and use this to auth

Re: Migrate passwords from shadow to mysql

2004-01-22 Thread Ted Cabeen
Ken Murchison <[EMAIL PROTECTED]> writes: > Shelley Waltz wrote: > >> I am installing a new postfix-cyrus mail server. >> I currently have cyrus-imap 1.6.24 authing PLAIN >> from /etc/shadow. >> I wish to migrate the passwords(md5) from the shadow file to >> a mysql database and use this to auth P

Re: Migrate passwords from shadow to mysql

2004-01-22 Thread Ken Murchison
Shelley Waltz wrote: Ken, Thanks for the reply. Yes, my new server is RH ES3 with all the most recent versions of Cyrus imap/sasl/postfix/mysql ... Which version of SASL? You definitely want 2.1.17. Where do I read about autotransition into the SQL auxprop plugin? Does this mean that after I tra

Re: Migrate passwords from shadow to mysql

2004-01-22 Thread Shelley Waltz
Ken, Thanks for the reply. Yes, my new server is RH ES3 with all the most recent versions of Cyrus imap/sasl/postfix/mysql ... Where do I read about autotransition into the SQL auxprop plugin? Does this mean that after I transition my existing users, I still need to create /etc/shadow entries in

Re: Migrate passwords from shadow to mysql

2004-01-22 Thread Ken Murchison
Shelley Waltz wrote: I am installing a new postfix-cyrus mail server. I currently have cyrus-imap 1.6.24 authing PLAIN from /etc/shadow. I wish to migrate the passwords(md5) from the shadow file to a mysql database and use this to auth PLAIN using TLS. Is there a script available to do so - to mig