Hello Claus, 

> I am trying to get aprox. 200 Users into web-cyradm using a mysql db.
> 
> I'd like to use md5 for the password encryption.
> 
> The users old passwords are stored in /etc/shadow. They are 
> md5 encrypted, but it seems, that it is not compatible with 
> the md5 in the mysql table.

Are you shure that they're in md5 encrypted? Standard is crypt 
i think, but i'm not 100Percent shure.

> 
> I am running web-cyradm on a Debian Sarge Server.
> 
> Everything Authentication, TLS, ... works fine, at the moment 
> I am using $CRYPT = "crypt". But it rather like to use md5.

Whith the new pam_mysql-pre Version you can use md5 ass well.

> 
> I just really would like to bulk import the users into mysql 
> along with their current password.
> 
> I can generate a textfile with username and password (If 
> necessary even new ones in plain text). Is there a script 
> which can do this? 

No, i think you must write it in php or perl to do this. Look at the 
sql structure it is very simple to understand the structure.

> I mean insert them into the mysql db and 
> if needed (in case of plain text passwords) convert them into md5.

If you wan't to convert the passwords to md5, you must have the 
passwords in plaintext so that you can use this in your sql query: 
"INSERT INTO tablename(username, password, ...) VALUES('marcel',
'".md5($:POST["password"])."', '...');" Then he writes the passes in md5.
Then you must change in 
pamfiles the crypt=3 for md5 encryption and in config.inc.php from
web-cyradm
use md5 too.

> That should be enough, as the users inbox can be created when 
> they receive their first email, shouldn't it? 

If you have set up the correct users and Pathes the web-cyradm uses the
cyradm
programm to create or delete the mailboxes in cyrus-imapd. The first mail
woul'd 
only be delivered to the mailbox if the cyradm has created the mailbox in
cyrus-imapd,
or if the user logs in with a mua, then cyrus-imapd will create the folders,
if there
aren't exists.

> I'd just have 
> to set the right parameter in imapd.conf, which I can't 
> remember right now. BTW I am running cyrus 2.1.18.

You can read it all in the web-cyradm HowTo from Luc at:
www.delouw.ch/linux/Postfix-Cyrus-Web-cyradm-HOWTO/html/index.html

if you want to have names like this: [EMAIL PROTECTED] you must
use the "unixhierarchysep: yes" in imapd.conf.

> 
> I have tried to generate a test md5 like this: echo "test" | md5sum.
> 
> But the result differed from the md5 in the password field 
> when I created it via the web interface.

At the to you have wrote, that you have configured the pam module with
crypt!
There are two Parameters you must set! 1. in pam files, 2. in web-cyradm
config file.

> 
> Any help or hints will be appreciated.

I hope this helps a little bit.

Regards
  Marcel


.::::::::::::::::::::::::::::::::::::::::::::::::::::::.

  Marcel Hartmann
  Tel. 04 41 - 960 34 49        Fax 04 41 - 960 34 47
  Internet                              www.marcel-hartmann.com
  e-Mail                                [EMAIL PROTECTED]

`::::::::::::::::::::::::::::::::::::::::::::::::::::::`


_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch

_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm

Reply via email to