<html><head><title>Cyrus Imap final setup problems</title>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
</head>
<body>
<span style=" font-family:'Verdana'; font-size: 10pt;">Hello ,<br>
<br>
I have a setup with the following: <br>
<br>
OpenSuSE 11.0 (x86_64)<br>
Postfix 2.5.1-28.5 (x86_64)<br>
Cyrus SASL 2.1.22-140.1 (x86_64)<br>
Cyrus Imap 2.3.11-31.1 (x86_64)<br>
MySQL 5.1.35-34.1<br>
All of these are on the same computer.<br>
<br>
I've tested SASL with the four main types (plain, login & the two md5 types) and it worked fine.<br>
<br>
Postfix works fine and I made sure it worked before even working on Imap and SASL.<br>
<br>
Cyrus Imap goes through SASL to MySQL but Postfix goes directly to MySQL for now. Postfix accesses the same MySQL data as Imap for its domain and user tests so they should always be in sync on authentication. Postfix communicates with Imap through LMTP.<br>
<br>
I've done the tests in the documention step by step and Cyrus Imap passes.<br>
<br>
I created a user with cyradm and successfully sent and received a message from my email client (The Bat!) using the the imap protocol with that user from a different computer. So far so good.<br>
<br>
However, it stopped receiving messages after two tests and looking at the logs it said it was at it's quota limit so I went back to cyradm to set the quota (I didn't bother the first time so it was at zero) and I got a "quota permission denied" error. This was from the same admin, I created the user with and it showed that the admin had all rights.<br>
<br>
I then used the admin to create another user and immediately tried to set the quota of that new user and got the same permission denied error. I could however remove the user that I could no set the quota for. <br>
<br>
That is my first problem but I have two other as follow:<br>
<br>
Sieve is not working when I try to telnet to it and I get this error:<br>
<br>
neutrino:~ # telnet mydomain.com sieve<br>
Trying nnn.nn.nn.nn...<br>
telnet: connect to address nnn.nn.nn.nn: Connection refused<br>
<br>
This may be that it needs to be compiled and installed but I am not sure. Is it automatically installed with Cyrus Imap? I did however as per the instructions set the /etc/services for it and I commented out the other service (cisco something) that it conflicted with for port 2000.<br>
<br>
The last thing is I am getting a "badlogin" error in my cyrus log as you can see below:<br>
<br>
Jul 8 08:12:00 neutrino SeoWS/imap[20686]: badlogin: localhost [127.0.0.1] CRAM-MD5 [SASL(-13): user not found: no secret in database]<br>
Jul 8 08:12:00 neutrino SeoWS/imap[20694]: sql auxprop plugin using mysql engine<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin Parse the username reg<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin try and connect to a host<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin trying to open db 'mail' on host 'localhost'<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin Parse the username reg<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin try and connect to a host<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin trying to open db 'mail' on host 'localhost'<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin Parse the username reg<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin try and connect to a host<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin trying to open db 'mail' on host 'localhost'<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: begin transaction<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin create statement from userPassword reg neutrino<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin doing query SELECT `password` FROM `accounts` WHERE `user`='reg' AND `realm`='neutrino' AND `virtual` != 0;<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin: no result found<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin create statement from cmusaslsecretPLAIN reg neutrino<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin doing query SELECT `password` FROM `accounts` WHERE `user`='reg' AND `realm`='neutrino' AND `virtual` != 0;<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin: no result found<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: commit transaction<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin Parse the username reg<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin try and connect to a host<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: sql plugin trying to open db 'mail' on host 'localhost'<br>
Jul 8 08:12:03 neutrino SeoWS/imap[20686]: badlogin: localhost [127.0.0.1] plaintext reg SASL(-13): user not found: checkpass failed<br>
Jul 8 08:12:15 neutrino SeoWS/imap[20694]: accepted connection<br>
Jul 8 08:13:39 neutrino SeoWS/imap[20707]: executed<br>
Jul 8 08:13:39 neutrino SeoWS/imap[20707]: sql auxprop plugin using mysql engine<br>
Jul 8 08:14:33 neutrino SeoWS/ctl_cyrusdb[20708]: checkpointing cyrus databases<br>
Jul 8 08:14:33 neutrino SeoWS/ctl_cyrusdb[20708]: archiving log file: /var/lib/imap/db/log.0000000001<br>
Jul 8 08:14:33 neutrino SeoWS/ctl_cyrusdb[20708]: archiving log file: /var/lib/imap/db/log.0000000001<br>
Jul 8 08:14:33 neutrino SeoWS/ctl_cyrusdb[20708]: archiving database file: /var/lib/imap/annotations.db<br>
Jul 8 08:14:33 neutrino SeoWS/ctl_cyrusdb[20708]: archiving database file: /var/lib/imap/mailboxes.db<br>
Jul 8 08:14:33 neutrino SeoWS/ctl_cyrusdb[20708]: archiving log file: /var/lib/imap/db/log.0000000001<br>
Jul 8 08:14:33 neutrino SeoWS/ctl_cyrusdb[20708]: done checkpointing cyrus databases<br>
Jul 8 08:15:00 neutrino SeoWS/imap[20707]: accepted connection<br>
Jul 8 08:15:00 neutrino SeoWS/imap[20712]: executed<br>
Jul 8 08:15:00 neutrino SeoWS/imap[20712]: sql auxprop plugin using mysql engine<br>
Jul 8 08:17:15 neutrino SeoWS/imap[20712]: accepted connection<br>
Jul 8 08:17:15 neutrino SeoWS/imap[20756]: executed<br>
Jul 8 08:17:15 neutrino SeoWS/imap[20756]: sql auxprop plugin using mysql engine<br>
<br>
This makes no sense to me because I don't know where it could get the user "reg" from to do any logging in with in the first place, let alone what it is logging in for since I not receiving or sending emails right now.<br>
<br>
I also noticed, but don't know if it is a problem or just how Imap works that the user I created showed up in two places in the cyrus store. Once in a path like ..../domain/m/mydomain.com/r/user/root/user^sales and once in a path like ..../domain/m/mydomain.com/s/user/sales. I suspect this is just the way Cyrus works but I mention it just in case it's important to know.<br>
<br>
Help will be greatly appreciated! While I am relatively new to Linux as I have had my own Linux box for only about 6 months, I am a seasoned programmer so I'm pick up technical things quick given a pointer or two and certainly don't mind "digging around" until a problem is solved.<br>
<br>
Below are my cyrus.conf & imap.conf files:<br>
<br>
# standard standalone server implementation<br>
<br>
<b><u>CYRUS.CONF<br>
</u></b>START {<br>
# recover - do not delete this entry!<br>
# idled - this is only necessary if using idled for IMAP IDLE<br>
recover cmd="ctl_cyrusdb -r"<br>
idled cmd="idled"<br>
}<br>
<br>
# UNIX sockets start with a slash and are put into /var/lib/imap/socket<br>
SERVICES {<br>
# DEFAULT DOMAIN<br>
imap cmd="imapd" listen="imap" prefork=0<br>
# imaps cmd="imapd -s" listen="imaps" prefork=0<br>
# pop3 cmd="pop3d" listen="pop3" prefork=0<br>
# pop3s cmd="pop3d -s" listen="pop3s" prefork=0<br>
sieve cmd="timsieved" listen="sieve" prefork=0<br>
lmtpunix cmd="lmtpd" listen="/var/lib/imap/socket/lmtp" prefork=0<br>
notify cmd="notifyd" listen="/var/lib/imap/socket/notify" proto="udp" prefork=0<br>
}<br>
<br>
EVENTS {<br>
checkpoint cmd="ctl_cyrusdb -c" period=30<br>
delprune cmd="cyr_expire -E 3" at=0400<br>
tlsprune cmd="tls_prune" at=0400<br>
# cleanup cmd="ipurge -d 30 -f" period=60<br>
}<br>
<br>
<b><u>IMAPD.CONF<br>
</u></b>sasl_auxprop_plugin: sql<br>
sasl_log_level: 7<br>
<br>
sasl_mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5<br>
<br>
sasl_pwcheck_method: auxprop<br>
sasl_sql_hostnames: localhost<br>
sasl_sql_user: cyrus<br>
sasl_sql_passwd: XXX<br>
sasl_sql_database: mail<br>
sasl_sql_select: SELECT `password` FROM `accounts` WHERE `user`='%u' AND `realm`='%r' AND `virtual` != 0<br>
sasl_sql_insert: INSERT INTO `accounts` (`user`, `realm`, `password`) VALUES ('%u', '%r', '%v')<br>
sasl_sql_update: UPDATE `accounts` SET `user`='%u',`realm`='%r',`password`='%v' WHERE `user`='%u' AND `realm`='%r'<br>
<br>
admins: cyrus root<br>
allowplaintext: 1<br>
altnamespace: 1<br>
anyoneuseracl: 0<br>
auth_mech: unix<br>
autocreatequota: 5<br>
configdirectory: /var/lib/imap<br>
drachost: localhost<br>
dracinterval: 0<br>
<br>
foolstupidclients: 1<br>
hashimapspool: 1<br>
improved_mboxlist_sort: 1<br>
lmtp_downcase_rcpt: 1<br>
lmtp_strict_quota: 1<br>
logtimestamps: 1<br>
partition-default: /var/mail/cyrus<br>
popsubfolders: 1<br>
poptimeout: 10<br>
sendmail: /usr/sbin/sendmail<br>
sievedir: /var/mail/sieve<br>
syslog_prefix: SeoWS<br>
unixhierarchysep: 1<br>
virtdomains: on<br>
<br>
<br>
<span style=" font-family:'arial'; font-size: 8pt; color: #c0c0c0;"><i>-- <br>
Reggie <a style=" font-style: normal;" href="mailto:nybbles2byte@gmail.com">mailto:nybbles2byte@gmail.com</a></body>