Dear list members, I seem to have the most bizarre situation on my new setup.
FreeBSD 5.3 Cyrus-imap2 2.2.8 Cyrus-saslauthd 2.1.19_1 pam-mysql mysql 5.0.0.2 Postfix - 2.1.4 Squirrelmail - 1.4.3a Setup and delivery is fine.I can check mail from the respective accounts created in mysql and cyradm with *ANY* PASSWORD!. in this case i have tried both through Webmail (Squirrelmail) and mail client. I can see the following from messages log Mar 29 19:16:23 mail pop3[868]: starttls: TLSv1 with cipher RC4-MD5 (128/128 bits new) no authentication Mar 29 19:16:23 mail pop3[868]: login: [x.x.x.x] info PLAIN+TLS User logged in I thought that my setup was wrong so i tried to debug by putting a wrong username or password or DB in the /etc/pam.d/pop and imap files Well i can see that an sql error is generated in auth.log as follows. Mar 29 19:15:25 mail saslauthd[569]: pam_mysql: MySQL err Access denied for user: 'xxx'@'localhost' to database 'mail' Mar 29 19:15:32 mail saslauthd[565]: pam_mysql: MySQL err Access denied for user: 'xxx'@'localhost' to database 'mail' however am still able to check mail through the webclient or Kmail. My /etc/pam.d/imap & pop files are as follows. # auth #auth required pam_nologin.so no_warn #auth sufficient pam_krb5.so no_warn try_first_pass #auth sufficient pam_ssh.so no_warn try_first_pass #auth required pam_unix.so no_warn try_first_pass auth sufficient pam_mysql.so user=xxxxxx passwd=xxxxx host=localhost db=mail tabl e=accountuser usercolumn=username passwdcolumn=password crypt=0 account required pam_mysql.so user=xxxxxx passwd=xxxxx host=localhost db=mail tab le=accountuser usercolumn=username passwdcolumn=password crypt=0 imap.conf file has the following options uncommented from the default settings. configdirectory: /var/imap partition-default: /home/mail allowanonymouslogin: no allowplaintext: yes timeout: 30 poptimeout: 10 admins: cyrus reject8bit: no sieveusehomedir: false sievedir: /home/sieve sendmail: /usr/sbin/sendmail sasl_pwcheck_method: saslauthd sasl_mech_list: PLAIN LOGIN tls_cert_file:/var/imap/server.pem tls_key_file:/var/imap/key.pem tls_ca_file:/var/imap/server.pem tls_ca_file:/var/imap/server.pem # # EOF Where am i going wrong? Regards, --- Cyrus Home Page: http://asg.web.cmu.edu/cyrus Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
