Postfix+Cyrus+MySQL please help its been 3 days

[Bryntez]

I don't know if you have fixed your problem yet, but I have a working server
with the same config as you have. (Except we're running imap/sasl 2.1.5)

- our saslauthd starts with the following option: -a &pam
- we have also a file in /etc/ called sasldb2.. (do you have this file ?)
- we have "sasl_mech_list: PLAIN LOGIN" in imapd.conf
- and at last "account required pam_mysql.so..... etc" in "pam.d/imap" (not
auth required..)

everything else looks okey to me.....

Good luck

Regards
bryntez


----- Original Message -----
From: <skuran at hacettepe.edu.tr>
To: <info-cyrus at lists.andrew.cmu.edu>
Sent: Friday, November 15, 2002 12:24 AM
Subject: Postfix+Cyrus+MySQL please help its been 3 days


> Hi all,
>
> i was running qmail+Courier-IMAP+mysql+checkpassword+SMTP-auth on RedHat
> 7.3 before i decided to switch to Postfix+Cyrus+MySQL on RedHat 8.0,so i
> setup a test system to see if i could make it. The test system is running
> RedHat 8.0, Postfix 1.1.11-5, MySQL-3.23.52-3, Cyrus-2.1.9
>
> * I rebuilt postfix from src.rpm to have SMTP-auth
> * installed mysql rpm
> * installed Cyrus from tar sources
> * cyrus-sasl is installed by default
> * installed pam_mysql to auth users from mysql database
>
> and followed Luc's HOWTO.
>
> The problem is;
>   Nobody can login IMAP
>   Cyrus user cannot login using Cryadm
>
> even if the pam_mysql query returns TRUE (mysql logs)
>
> Please help, its been 3 days, and im completely lost.
>
>
> 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
> ---------------------------
>
> Here is /etc/cyrus.conf
> -----------------------------------------
> # standard standalone server implementation
>
> START {
>   # do not delete these entries!
>   mboxlist      cmd="ctl_mboxlist -r"
>   deliver       cmd="ctl_deliver -r"
>
>   # this is only necessary if using idled for IMAP IDLE
> #  idled                cmd="idled"
> }
>
> # UNIX sockets start with a slash and are put into /var/imap/socket
> SERVICES {
>   # add or remove based on preferences
>    imap          cmd="imapd" listen="imap" prefork=0
>    imaps         cmd="imapd -s" listen="imaps" prefork=0
> #   pop3          cmd="pop3d" listen="pop3" prefork=0
> #  pop3s         cmd="pop3d -s" listen="pop3s" prefork=0
> #  sieve         cmd="timsieved" listen="sieve" prefork=0
>
>   # at least one LMTP is required for delivery
> #  lmtp         cmd="lmtpd" listen="lmtp" prefork=0
>    lmtpunix      cmd="lmtpd" listen="/var/imap/socket/lmtp" prefork=0
> }
>
> EVENTS {
>   # this is required
>   checkpoint    cmd="ctl_mboxlist -c" period=30
>
>   # this is only necessary if using duplicate delivery suppression
>   delprune      cmd="ctl_deliver -E 3" period=1440
> }
> ------------------------------------------------------
>
> Here is /etc/imapd.conf
> ---------------------------
> postmaster: postmaster
> configdirectory: /var/imap
> partition-default: /var/spool/imap
> admins: cyrus
> allowanonymouslogin: no
> allowplaintext: yes
> sasl_mech_list: PLAIN
> servername: myhostname.mydomain.local
> autocreatequota: 10000
> reject8bit: no
> quotawarn: 90
> timeout: 30
> poptimeout: 10
> dracinterval: 0
> drachost: localhost
> sasl_pwcheck_method: saslauthd
> sendmail: /usr/sbin/sendmail
> unixhierarchysep: yes
> ---------------------------
>
> Here is the result of imtest
> -------------------------------------------------------------
> #imtest -a cyrus -v localhost
> S: * OK myhostname.mydomain.local Cyrus IMAP4 v2.1.9 server ready
> C: C01 CAPABILITY
> S: * CAPABILITY IMAP4 IMAP4rev1 ACL QUOTA LITERAL+ MAILBOX-REFERRALS
> NAMESPACE U
> IDPLUS ID NO_ATOMIC_RENAME UNSELECT CHILDREN MULTIAPPEND SORT
> THREAD=ORDEREDSUBJ
> ECT THREAD=REFERENCES IDLE
> S: C01 OK Completed
> Please enter your password:
> C: L01 LOGIN cyrus {6}
> S: + go ahead
> C: <omitted>
> S: L01 NO Login failed: authentication failure
> Authentication failed. generic failure
> Security strength factor: 0
> -------------------------------------------------------------
> MySQL Log after runing imtest
>
> 021114 23:44:09      38 Connect     myhostname at localhost on myhostname
>                      38 Init DB     mail
>                      38 Query       select username from accountuser where
> usern
> ame='cyrus' and password='secret'
>                      38 Quit
> (the user 'cyrus' exists in the 'accountuser' table and his password is
> 'secret' in plaintext, that is this query returns 'true')
> -------------------------------------------------------------
> System Log
>
> Nov 14 23:44:09 myhostname saslauthd[2503]: AUTHFAIL: user=cyrus
> service=imap realm
> = [PAM acct error]
> Nov 14 23:44:09 myhostname imapd[2728]: badlogin: myhostname[127.0.0.1]
> plaintext cyru
> s SASL(-13): authentication failure: checkpass failed
>
>
> If anyone have any idea why i can't login please help, THANKS for reading.
>
> Suley
>
>
>
>