This is a MySQL error, not Cyrus. You need to give the user foo access
to SELECT from the database on localhost.
Paul
Tim Evans wrote:
>
> >It would greatly assist us in helping you if you post some configuration
> >details, error messages, or symptoms for those of us that are familiar
> >with this combination.
> >
>
> Thanks, the system is a Cobalt RAQ4i, running Cobalt's modified Red Hat 6.x,
> Apache 1.3.12. I have separately installed PHP 4.03pl1, MySQL 3.22.30,
> Cyrus imapd 1.6.24, Cyrus SASL 1.5.24, horde 1.2.3, IMP 2.2.3, and pam_mysql
> 0.4.7.
>
> Here is /etc/imapd.conf:
>
> configdirectory: /var/imap
> partition-default: /var/spool/imap
> admins: cyrus root tkevans
> srvtab: /var/imap/srvtab
> allowanonymouslogin: no
> #sasl_pwcheck_method: pam
> sasl_pwcheck_method: shadow
>
> NOTE: 'shadow' works here; IMP users can authenticate against it, once I
> cut-and-paste their encrypted password from the MySQL database into
> /etc/shadow.
>
> Here are the pam_mysql pam config file entries:
> #%PAM-1.0
> auth optional /lib/security/pam_mysql.so user=foo password=bar
> db=healthhub table=auth usercolumn=username passwdcolumn=password crypt=1
> account required /lib/security/pam_mysql.so user=foo password=bar
> db=healthhub table=auth usercolumn=username passwdcolumn=password crypt=1
>
> NOTE: I've been putting this in place of the standard imap file in /etc/
> pam.d. Not sure if this is the right thing.
>
> This is what I get in syslog when users try to get into IMP:
>
> Dec 10 14:06:42 msdhub-raq imapd[6610]: pam_mysql: MySQL err Access denied for
> user: 'foo@localhost' (Using password: NO)
>
> The username "foo" is there for all account logins, so it looks as if the
> pam.d file is being consulted.
>
> But it appears the password isn't being presented, only the userid.
> --
> Tim Evans [EMAIL PROTECTED] | 5 Chestnut Court
> http://www.tkevans.com/tkevans.html | Owings Mills, MD 21117
> (443) 394-3864 | (800) 946-4646, PIN #1716638
