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@xxxxxxxxxx localhost IMAP Password: at /usr/lib/perl5/Cyrus/IMAP/Admin.pm line 119 cyradm: cannot authenticate to server as cyrus@xxxxxxxxxx # === 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) ---- 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