Config help?

[Mike O'Rourke]

>> >  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='%u@%r';"
>> > 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