Cyradm - bug or incorrect settings ?

[Oleg Kostyuk]

Hello all!

I have problem with connecting to cyrus via cyradm.

This my configuration:

=== from imapd.conf ===
virtdomains: userid
defaultdomain: cub.org.ua
loginrealms: cub.org.ua home.cub.org.ua
sasl_pwcheck_method: auxprop
sasl_auxprop_plugin: sql
sasl_mech_list: PLAIN
sasl_sql_engine: sqlite
sasl_sql_database: /etc/sasldb2.sqlite
sasl_sql_select: select password from sasl_users where username = '%u'
and domain='%r'
=== end imapd.conf ===


=== from sasldb2.sqlite ===
# echo "select username, domain, password from sasl_users;" | sqlite
/etc/sasldb2.sqlite
cyrus||MailAdmin
cyrus|cub.org.ua|MailAdmin
#
=== end sasldb2.sqlite ===


=== from host command line ===
# hostname
hosting
# hostname -f
hosting.cub.org.ua
# ls -la /etc/sasldb2.sqlite
-rw-rw---- 1 cyrus sasl 4096 2008-02-12 18:25 /etc/sasldb2.sqlite
#
=== end of host command line ===

=== try to connect ===
# cyradm --user cyrus at cub.org.ua localhost
IMAP Password:
               at /usr/lib/perl5/Cyrus/IMAP/Admin.pm line 119
cyradm: cannot authenticate to server as cyrus at cub.org.ua
#
=== end of try ===

=== errors in log ===
==> /var/log/auth.log <==
Feb 12 18:27:10 hosting cyrus/imap[9940]: sql auxprop plugin using sqlite engine
Feb 12 18:27:10 hosting perl: No worthy mechs found
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin Parse the username cyrus
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin try and connect to a host
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin trying to open db
'/etc/sasldb2.sqlite' on host 'localhost'
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin Parse the username cyrus
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin try and connect to a host
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin trying to open db
'/etc/sasldb2.sqlite' on host 'localhost'
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin Parse the username cyrus
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin try and connect to a host
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin trying to open db
'/etc/sasldb2.sqlite' on host 'localhost'
Feb 12 18:27:14 hosting cyrus/imap[9940]: begin transaction
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin: unable to open
database file
Feb 12 18:27:14 hosting cyrus/imap[9940]: Unable to begin transaction
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin create statement
from userPassword cyrus hosting
Feb 12 18:27:14 hosting cyrus/imap[9940]: sql plugin doing query
select password from sasl_users where username = 'cyrus' and
domain='hosting';

==> /var/log/syslog <==
Feb 12 18:27:16 hosting cyrus/master[9803]: process 9940 exited,
signaled to death by 11
Feb 12 18:27:16 hosting cyrus/master[9803]: service imap pid 9940 in
BUSY state: terminated abnormally
=== end of errors ===

And finally, my questions:
1) why cyradm tries "hosting" realm, instead of "cub.org.ua" ? This is
bug or my mistake ?
2) from where coming "sql plugin: unable to open database file" error ?

Btw, if I create entry in database with domain == "hosting" - all
things work correctly (except ignoring "cub.org.ua" realm).

I'm using Debian Etch, and all software installed from stable branch
(cyrus is 2.2.13-10 and sasl2 is 2.1.22.dfsg1-8).

-- 
Sincerely yours,
Oleg Kostyuk (CUB-UANIC)