Imapd SASL Auxprop problem

Tue Mar 15 15:46:46 PST 2005

If I am posting to the wrong forum please feel free to flame my sox off  

Hi All 
I have a problem with my cyrus imap / mysql install 
after 3 days on google looking around i am ripping my hair out  
I have tried everything i have found in the faq's / howto's 
but just cant seem to get it to work. 

Postfix works nicely and delivers to maildir etc 
when i use the sasldb for cyrus i have no problems users can log in 
auxprop has not been nice to me grrrr. 

If any one has the time could they have a look at my configuration and 
give me a pointer on what I am doing wrong. 

Any help would be greatly appreciated 

Jason M aka Talon (talonz[at]gmail.com) 

#######################################################################################################################################
## version information 

OS FreeBSD 5.3-RELEASE-p5 
Postfix Version postfix 2.1.5 
MySQL server version: 5.0.0-alpha 
Cyrus Version cyrus-imapd 2.2.10 
SASL Version cyrus-sasl 2.1.20 

All installed from ports 

#######################################################################################################################################

## /var/log/messages :: Errors when imapd is started 

forsaken master[60842]: process started 
forsaken ctl_cyrusdb[60843]: recovering cyrus databases 
forsaken ctl_cyrusdb[60843]: skiplist: recovered
/var/imap/mailboxes.db (3 records, 584 bytes) in 0 seconds
forsaken ctl_cyrusdb[60843]: skiplist: recovered
/var/imap/annotations.db (0 records, 144 bytes) in 0 seconds
forsaken ctl_cyrusdb[60843]: done recovering cyrus databases 
forsaken master[60842]: unable to create lmtpunix listener socket: No
such file or directory
forsaken master[60842]: ready for work 
forsaken ctl_cyrusdb[60844]: checkpointing cyrus databases 
forsaken ctl_cyrusdb[60844]: DBERROR: error listing log files:
DB_NOTFOUND: No matching key/data pair found
forsaken ctl_cyrusdb[60844]: DBERROR: archive /var/imap/db: cyrusdb error 
forsaken ctl_cyrusdb[60844]: DBERROR: error listing log files:
DB_NOTFOUND: No matching key/data pair found
forsaken ctl_cyrusdb[60844]: DBERROR: archive /var/imap/db: cyrusdb error 
forsaken ctl_cyrusdb[60844]: done checkpointing cyrus databases 

#######################################################################################################################################
## Login errors (after telnet localhost imap // o login test test) 

forsaken imap[60846]: sql_select option missing 
forsaken imap[60846]: auxpropfunc error no mechanism available 
forsaken imap[60846]: no user in db 
forsaken imap[60846]: no user in db 
forsaken imap[60846]: badlogin: localhost [127.0.0.1] plaintext test
SASL(-13): user not found: checkpass failed

#######################################################################################################################################
## Start Configuration 

#######################################################################################################################################
## postfix main.cf 
queue_directory = /var/spool/postfix 
command_directory = /usr/local/sbin 
daemon_directory = /usr/local/libexec/postfix 
mail_owner = postfix 
myhostname = forsaken.unix.org.au 
mydomain = unix.org.au 
inet_interfaces = all 
mydestination = $myhostname, localhost.$mydomain, localhost 
unknown_local_recipient_reject_code = 550 
relay_domains = $mydestination 

debug_peer_level = 2 
debugger_command = 
PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin 
xxgdb $daemon_directory/$process_name $process_id & sleep 5 

sendmail_path = /usr/local/sbin/sendmail 
newaliases_path = /usr/local/bin/newaliases 
mailq_path = /usr/local/bin/mailq 
setgid_group = maildrop 
html_directory = no 
manpage_directory = /usr/local/man 
sample_directory = /usr/local/etc/postfix 
readme_directory = no 

# header/body checking 
header_checks = regexp:/usr/local/etc/postfix/header_checks 
body_checks = regexp:/usr/local/etc/postfix/body_checks 

# use cyrus or virtual 
mailbox_transport = cyrus 

virtual_alias_maps = mysql:/usr/local/etc/postfix/mysql_virtual_alias_maps.cf 
virtual_gid_maps = static:125 
virtual_mailbox_base = /usr/local/virtual 
virtual_mailbox_domains =
mysql:/usr/local/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000 
virtual_mailbox_maps =
mysql:/usr/local/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 125 

# use cyrus or virtual 
virtual_transport = virtual 
virtual_uid_maps = static:125 
virtual_create_maildirsize = yes 
virtual_mailbox_extended = yes 
virtual_mailbox_limit_maps =
mysql:/usr/local/etc/postfix/mysql_virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes 
virtual_maildir_limit_message = Sorry, Account Is Suspended. (This
User Has Exeeded There Quota Limit).
virtual_overquota_bounce = yes 

# sasl settings for cyrus 
broken_sasl_auth_clients = yes 
smtpd_recipient_restrictions = 
permit_mynetworks, 
permit_sasl_authenticated, 
reject_non_fqdn_hostname, 
reject_non_fqdn_sender, 
reject_non_fqdn_recipient, 
reject_unauth_destination, 
reject_unauth_pipelining, 
reject_invalid_hostname, 
reject_rbl_client opm.blitzed.org, 
reject_rbl_client list.dsbl.org, 
reject_rbl_client bl.spamcop.net, 
reject_rbl_client sbl-xbl.spamhaus.org 

smtpd_sasl_auth_enable = yes 
smtpd_sasl_local_domain = 
smtpd_sasl_security_options = noanonymous 

#######################################################################################################################################
## cyrus.conf 

START { 
recover cmd="ctl_cyrusdb -r" 
} 

SERVICES { 
# add or remove based on preferences 
imap cmd="imapd" listen="imap" prefork=0 
pop3 cmd="pop3d" listen="pop3" prefork=0 

lmtpunix cmd="lmtpd" listen="/var/imap/socket/lmtp" prefork=0 
} 

EVENTS { 
checkpoint cmd="ctl_cyrusdb -c" period=30 
delprune cmd="cyr_expire -E 3" at=0400 
tlsprune cmd="tls_prune" at=0400 
} 

#######################################################################################################################################
## imapd.conf 

configdirectory: /var/imap 
partition-default: /var/spool/imap 

servername: forsaken.unix.org.au 
allowanonymouslogin: no 
allowplaintext: yes 

admins: cyrus root 
sieveusehomedir: false 
sievedir: /var/imap/sieve 

sasl_pwcheck_method: auxprop 
sasl_mech_list: plain cram-md5 digest-md5 

lmtpsocket: /var/imap/socket/lmtp 

#######################################################################################################################################
## smtpd.conf 
sasl_pwcheck_method: auxprop 
sasl_auxprop_plugin: sql 
sasl_sql_engine: mysql 
sasl_mech_list: PLAIN LOGIN DIGEST-MD5 CRAM-MD5 
sasl_sql_hostnames: localhost 
sasl_sql_user: postfix 
sasl_sql_passwd: postfix_password 
sasl_sql_database: postfix 
sasl_sql_verbose: yes 

sasl_sql_select: SELECT password FROM mailbox WHERE username = '%u' 

#######################################################################################################################################