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