>> > cyradm --user=cyrus localhost >> > IMAP Password: >> > at >> > /usr/local/lib/perl5/site_perl/5.6.1/mach/Cyrus/IMAP/Admin.pm line 118 >> > cyradm: cannot authenticate to server with as cyrus >> > >> > Any ideas? Thanks. >> > >> > david >> >> > >> > sasl_pwcheck_method: auxprop >> > sasl_auxprop_plugin: sql >> > sasl_mech_list: PLAIN LOGIN >> > sasl_auto_transition: no >> > sasl_sql_engine: mysql >> > sasl_sql_hostnames: localhost >> > sasl_sql_user: XXXXXX >> > sasl_sql_passwd: XXXXXX >> > sasl_sql_database: XXXXXX >> > sasl_sql_select: "select passwd from users where userid='[EMAIL PROTECTED]';" >> > sasl_sql_verbose: true >> >> On a SuSE machine using standard rpms and auxprop for >> authentification, this message indicates that permissions on the sasldb2 >> file ( on SuSE found in /etc/sasldb2 ) are incorrect. Cyrus should own the >> file a permissions be no greater than 620, I have root as the group. Hope >> this helps. >> Al > >The ownership was wrong, so I corrected it, but still get the same error. > >What's strange is that mysql logs the query being made but I never see the >transaction being completed due to the crash :( > >david > >> > >--- >Home Page: http://asg.web.cmu.edu/cyrus >Wiki/FAQ: http://cyruswiki.andrew.cmu.edu >List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
Hi David, What is in the userid field for your cyrus user in your database? I am not _sure_ about it, but if you do not pass a realm, you would be, in effect, searching your mysql database for a userid of "cyrus@" (as would be the case in an LDAP setup, like I use). Although, possibly, the sql plugin is smart enough to either add a default realm (in which case, this would need to be reflected in the cyrus user's userid) or it can strip off the training "@" in a "realmless" login. Just a thought. Mike. --- Home Page: http://asg.web.cmu.edu/cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
