[Web-cyradm] Postfix+Cyrus+MySQL please help its been 3 days

[Süleyman Kuran]

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" <skuran at hacettepe.edu.tr>
To: "info-cyrus" <info-cyrus at lists.andrew.cmu.edu>
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
>