Cyrus-Imapd SERIOUS problem Please HELP

[Simon Matter]

> 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

Seems you posted the wrong link, its http://nightwish.gr/postfix/

You should also tell the list which versions you are using.

>
> 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
>
> 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

Without knowing much about pam_mysql, it seems that it doesn't like the
results from the query. Are you sure your database entries are okay?

Simon

> 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