#22 Problems when connecting to cyrus through pam_mysql

closed-works-for-me
nobody
None
5
2006-01-09
2005-10-03
Peter
No

Hi There,

I have for some days now had a problem when logging
into cyrus using pam_mysql. I was running the whole
setup on RH enterprise before, but have now switched to
RH FC4. Simply I cannot login here is the messages log
file:
Oct 3 21:39:43 conundrum pop3[456]: sql_select option
missing
Oct 3 21:39:43 conundrum pop3[456]: auxpropfunc error
no mechanism available
Oct 3 21:39:53 conundrum saslauthd[352]:
pam_sm_authenticate called.
Oct 3 21:39:53 conundrum saslauthd[352]: dbuser changed.
Oct 3 21:39:53 conundrum saslauthd[352]: dbpasswd changed.
Oct 3 21:39:53 conundrum saslauthd[352]: host changed.
Oct 3 21:39:53 conundrum saslauthd[352]: database changed.
Oct 3 21:39:53 conundrum saslauthd[352]: table changed.
Oct 3 21:39:53 conundrum saslauthd[352]: usercolumn
changed.
Oct 3 21:39:53 conundrum saslauthd[352]: passwdcolumn
changed.
Oct 3 21:39:53 conundrum saslauthd[352]: crypt changed.
Oct 3 21:39:53 conundrum saslauthd[352]: logtable changed.
Oct 3 21:39:53 conundrum saslauthd[352]: logmsgcolumn
changed.
Oct 3 21:39:53 conundrum saslauthd[352]: logusercolumn
changed.
Oct 3 21:39:53 conundrum saslauthd[352]: loghostcolumn
changed.
Oct 3 21:39:53 conundrum saslauthd[352]: logpidcolumn
changed.
Oct 3 21:39:53 conundrum saslauthd[352]: logtimecolumn
changed.
Oct 3 21:39:53 conundrum saslauthd[352]: db_connect
called.
Oct 3 21:39:53 conundrum saslauthd[352]: pam_mysql:
MySQL err Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (13)
Oct 3 21:39:53 conundrum saslauthd[352]: returning 7 .
Oct 3 21:39:53 conundrum saslauthd[352]: returning 7
after db_connect.
Oct 3 21:39:53 conundrum saslauthd[352]: do_auth
: auth failure: [user=cyrus] [service=pop] [realm=]
[mech=pam] [reason=PAM auth error]

I've been running all over the net to fins a solution
but with no help, can you help ?

Discussion

  • Moriyoshi Koizumi

    Logged In: YES
    user_id=995831

    It seems that the "host" option is not set to the correct value that
    represents the MySQL socket (e.g. /tmp/mysql.sock).

     
  • Bill Kearney

    Bill Kearney - 2005-11-18

    Logged In: YES
    user_id=13682

    Where does your setup of mysql keep the mysql.sock socket?
    Check your /etc/my.cnf configuration file. Make sure you're
    actually telling pam_mysql to use the correct location.
    That and make sure mysql is running of course.

     
  • Moriyoshi Koizumi

    • status: open --> closed-works-for-me
     

Log in to post a comment.