Hi Luc, now i have crypt=1 in /etc/pam.d/imap and crypt=1 in config.inc.php and i updated the password ENCRYPT('secret')
BTW: i have in mysql logs ---------------------------------------------------------------------------- 265 Init DB mail 265 Query select username from accountuser where usern ame='test' and password=ENCRYPT('secret',LEFT(password,2)) ---------------------------------------------------------------------------- does this LEFT(password,2) makes any difference the accounts i have created with web-cryadm gives "division by zero" message. is there any other way (command line, etc) that i can test pam_mysql so that if the problem is not related to pam i can focus more on cyrus. Best wishes Suley ----- Original Message ----- From: "Süleyman Kuran" <[EMAIL PROTECTED]> To: "info-cyrus" <[EMAIL PROTECTED]> Sent: Friday, November 15, 2002 9:34 AM Subject: Re: [Web-cyradm] Postfix+Cyrus+MySQL please help its been 3 days > > Hi Suley > > > > [..] > > > > > Here is /etc/pam.d/imap > > > --------------------------- > > > auth sufficient pam_mysql.so user=mail passwd=secret > > > host=localhost db=mail table=accountuser usercolumn=username > > > passwdcolumn=password crypt=0 > > > auth required pam_mysql.so user=mail passwd=secret > > > host=localhost db=mail table=accountuser usercolumn=username > > > passwdcolumn=password crypt=0 > > > > I guess, you have CRYPT=1 in config.inc.php and crypt=0 in pam.d > > If so, please change pam.d/imap to crypt=1 and encrypt the > > password in the mysql-db with ENCRYPT("secret") > > > > Should help :-) > > > > rgds > > > > Luc > > > > Yes Luc thats right i have CRYPT=1 in config.inc.php > But thats another problem because imtest has nothing to do with > config.inc.php > in pam.d/imap i have CRYPT=0 and i have password 'secret' in clear text for > the user cyrus in accountusers table. > Suley >