Cyradm - bug or incorrect settings ?

[Simon Matter]

> 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 ===

I recommend to first find out why your imap process dies here. To start I
recommend running 'strace -f' on the master process while trying to login.
If that doesn't show anything useful you may have to produce a coredump,
the list archives discuss how to do that with cyrus.

Simon

>
> 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)
> ----
> Cyrus Home Page: http://cyrusimap.web.cmu.edu/
> Cyrus Wiki/FAQ: http://cyrusimap.web.cmu.edu/twiki
> List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
>