Postfix+Cyrus+MySQL please help its been 3 days

[skuran at hacettepe.edu.tr]

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