cyradm can't connect to server and DBERROR problem

[Steve Johnson]

Hi,

I'm trying to setup Cyrus-IMAP 2.2.10 on NetBSD, with auxprop/mysql 
authentication. cyradm can't connect to the server, so I guess it's 
related to a problem I'm seeing in the logs.

When starting cyrus, I get the following error in the logs:
------------------------------------------------------------
Jan  8 08:40:08 cossin master[14789]: process started
Jan  8 08:40:08 cossin ctl_cyrusdb[3494]: recovering cyrus databases
Jan  8 08:40:08 cossin ctl_cyrusdb[3494]: skiplist: recovered 
/var/imap/mailboxes.db (0 records, 144 bytes) in 0 seconds
Jan  8 08:40:08 cossin ctl_cyrusdb[3494]: skiplist: recovered 
/var/imap/annotations.db (0 records, 144 bytes) in 0 seconds
Jan  8 08:40:08 cossin ctl_cyrusdb[3494]: done recovering cyrus databases
Jan  8 08:40:09 cossin master[14789]: ready for work
Jan  8 08:40:09 cossin ctl_cyrusdb[29092]: checkpointing cyrus databases
Jan  8 08:40:09 cossin ctl_cyrusdb[29092]: DBERROR: error listing log 
files: Permission denied
Jan  8 08:40:09 cossin ctl_cyrusdb[29092]: DBERROR: archive 
/var/imap/db: cyrusdb error
Jan  8 08:40:09 cossin ctl_cyrusdb[29092]: DBERROR: error listing log 
files: Permission denied
Jan  8 08:40:09 cossin ctl_cyrusdb[29092]: DBERROR: archive 
/var/imap/db: cyrusdb error
Jan  8 08:40:09 cossin ctl_cyrusdb[29092]: done checkpointing cyrus 
databases
Jan  8 09:00:00 cossin syslogd: restart
Jan  8 09:10:09 cossin ctl_cyrusdb[28712]: checkpointing cyrus databases
Jan  8 09:10:09 cossin ctl_cyrusdb[28712]: DBERROR: error listing log 
files: Permission denied
Jan  8 09:10:09 cossin ctl_cyrusdb[28712]: DBERROR: archive 
/var/imap/db: cyrusdb error
Jan  8 09:10:09 cossin ctl_cyrusdb[28712]: DBERROR: error listing log 
files: Permission denied
Jan  8 09:10:09 cossin ctl_cyrusdb[28712]: DBERROR: archive 
/var/imap/db: cyrusdb error
Jan  8 09:10:09 cossin ctl_cyrusdb[28712]: done checkpointing cyrus 
databases
------------------------------------------------------------

However, I've checked the files, and they all seemed to have the right 
permissions:
------------------------------------------------------------
ls -la /var/imap
total 47
drwxr-x---  10 cyrus mail    512 Jan  8 09:10 ./
drwxr-xr-x  26 root  wheel   512 Jan  7 14:54 ../
-rw-------   1 cyrus mail    144 Jan  8 08:40 annotations.db
drwxr-xr-x   2 cyrus mail    512 Jan  8 08:40 db/
drwx------   2 cyrus mail    512 Jan  8 09:10 db.backup1/
drwx------   2 cyrus mail    512 Jan  8 08:40 db.backup2/
-rw-------   1 cyrus mail  16384 Jan  8 04:00 deliver.db
drwxr-xr-x   2 cyrus mail    512 Jan  7 14:54 log/
-rw-------   1 cyrus mail    144 Jan  8 08:40 mailboxes.db
drwxr-xr-x   2 cyrus mail    512 Jan  7 14:54 msg/
drwxr-xr-x   2 cyrus mail    512 Jan  7 14:54 proc/
drwxr-xr-x   2 cyrus mail    512 Jan  7 14:54 ptclient/
-rw-r--r--   1 cyrus mail   2229 Jan  7 15:21 server.pem
drwxr-xr-x   2 cyrus mail    512 Jan  8 08:40 socket/
-rw-------   1 cyrus mail  16384 Jan  8 04:00 tls_sessions.db

ls -la /var/imap/db
total 12539
drwxr-xr-x   2 cyrus mail      512 Jan  8 08:40 ./
drwxr-x---  10 cyrus mail      512 Jan  8 09:10 ../
-rw-------   1 cyrus mail    16384 Jan  8 08:40 __db.001
-rw-------   1 cyrus mail   663552 Jan  8 08:40 __db.002
-rw-------   1 cyrus mail    98304 Jan  8 08:40 __db.003
-rw-------   1 cyrus mail 18563072 Jan  8 08:40 __db.004
-rw-------   1 cyrus mail    32768 Jan  8 08:40 __db.005
-rw-------   1 cyrus mail 10485760 Jan  8 08:40 log.0000000001
-rw-------   1 cyrus mail        4 Jan  8 08:40 skipstamp
------------------------------------------------------------

Here's the relevant line in cyrus.conf:
------------------------------------------------------------
recover       cmd="ctl_cyrusdb -r"
------------------------------------------------------------

Here's my imapd.conf
------------------------------------------------------------
configdirectory: /var/imap
partition-default: /var/spool/imap
sieveusehomedir: true
hashimapspool: false
admins: cyrus root
allowanonymouslogin: no
sasl_pwcheck_method: auxprop
sasl_sql_engine: mysql
sasl_sql_database: mailsql
sasl_sql_select: SELECT clear FROM users WHERE email = '%u'
auxprop_plugin: mysql
sasl_sql_verbose: yes
sasl_mech_list: PLAIN
allowplaintext: yes
sendmail: /usr/sbin/sendmail
sieve_maxscriptsize: 32
sieve_maxscripts: 5
sasl_sql_user: mailsql
sasl_sql_passwd: sn1p3r
sasl_sql_hostnames: localhost
imapidresponse: no
tls_cert_file: /var/imap/server.pem
tls_key_file: /var/imap/server.pem
------------------------------------------------------------


And the master process does run under the cyrus user:
------------------------------------------------------------
cyrus    14789  0.0  0.4   160  1064 ?? Ss    8:40AM 0:00.23 
/usr/pkg/cyrus/bin/master -d
------------------------------------------------------------


Any ideas how to fix this?
Thanks a lot,
Steve Johnson
---
Cyrus Home Page: http://asg.web.cmu.edu/cyrus
Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html