> Well i have set up a postfix mailserver with cyrus sasl for smtp auth , cyrus > imapd as the IMAP with Mysql as a back-end. Authentication is being done with > pam-mysql > I have a strange problem. When you enter a valid username you can login with > ANY password, the IMAP responds .. OK User Loged in. > > i tried Almost ALL the how-to that exist but i couldnt find anything. so my > last chance is to post here my config files and tell me IF there is a chance > of fix that thing. Sorry for my big log but i am desperate . > > in order NOT to make a HUGE link i will post the config files in links so you > just click the link and you see the config > > postfix main.cf -> www.nightwish.gr/postfix/main.cf > cyrus -> www.nightwish.gr/postfix/cyrus.conf > cyrus-imapd -> www.nightwish.gr/postfix/imapd.conf > > mysql virtual files of postfix > www.nightwish.gr/postfix/mysql_virtual_alias_maps.cf > www.nightwish.gr/postfix/mysql_virtual_domains_maps.cf > www.nightwish.gr/postfix/mysql_virtual_mailbox_maps.cf > > the files of pam.d > www.nightwish.gr/postfix/imap > www.nightwish.gr/postfix/smtp
In your pam.d files for imap & smtp. Change the following: auth sufficient pam_mysql.so to auth required pam_mysql.so > > and finaly the cyrus-sasl file > www.nightwish.gr/postfix/smtpd.conf > > and finaly see the output from the /var/log/messages > > Jul 14 21:29:56 verniki imap[38653]: mysql plugin couldnt connect to any host > Jul 14 21:29:56 verniki imap[38653]: mysql plugin couldnt connect to any host > Jul 14 21:29:56 verniki saslauthd[545]: pam_sm_authenticate called. > Jul 14 21:29:56 verniki saslauthd[545]: dbuser changed. > Jul 14 21:29:56 verniki saslauthd[545]: dbpasswd changed. > Jul 14 21:29:56 verniki saslauthd[545]: host changed. > Jul 14 21:29:56 verniki saslauthd[545]: database changed. > Jul 14 21:29:56 verniki saslauthd[545]: table changed. > Jul 14 21:29:56 verniki saslauthd[545]: usercolumn changed. > Jul 14 21:29:56 verniki saslauthd[545]: passwdcolumn changed. > Jul 14 21:29:56 verniki saslauthd[545]: crypt changed. > Jul 14 21:29:56 verniki saslauthd[545]: sqllog changed. > Jul 14 21:29:56 verniki saslauthd[545]: db_connect called. > Jul 14 21:29:56 verniki saslauthd[545]: returning 0 . > Jul 14 21:29:56 verniki saslauthd[545]: db_checkpasswd called. > Jul 14 21:29:56 verniki saslauthd[545]: pam_mysql: where clause = > Jul 14 21:29:56 verniki saslauthd[545]: SELECT password FROM mailbox WHERE > username='koko' > Jul 14 21:29:56 verniki saslauthd[545]: pam_mysql: select returned more than > one result > Jul 14 21:29:56 verniki saslauthd[545]: returning 9 after db_checkpasswd. > > Please help :s > Thank you in advance > > --- > 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 > --- 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
