From owner-freebsd-questions@FreeBSD.ORG Wed Mar 16 00:59:50 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 416FC16A4CE for ; Wed, 16 Mar 2005 00:59:50 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.200]) by mx1.FreeBSD.org (Postfix) with ESMTP id F27F043D4C for ; Wed, 16 Mar 2005 00:59:48 +0000 (GMT) (envelope-from talonz@gmail.com) Received: by rproxy.gmail.com with SMTP id a41so2274838rng for ; Tue, 15 Mar 2005 16:59:48 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=CAqFa0YjG2JzRNMYXmq2XRD4Z78XGU+Bwxt5wLb1Ecpyuau6aYYYVpO1oAwJGlDlfKR7N9vJd+LqMM4eRqiA+aV/D0ednIdetE+sIaLbIjXQAdwIadqHcqIerQaZJaEu7h4kRv3QJDEQrOvByn6gP9hplv7+GtPyx1IscOakHfI= Received: by 10.39.1.24 with SMTP id d24mr14024rni; Tue, 15 Mar 2005 16:59:48 -0800 (PST) Received: by 10.39.1.27 with HTTP; Tue, 15 Mar 2005 16:59:48 -0800 (PST) Message-ID: Date: Wed, 16 Mar 2005 11:59:48 +1100 From: Jason M aka Talon To: freebsd-questions@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Subject: Mysql postfix SASL cyrus imap problem X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: talon@unix.org.au List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 16 Mar 2005 00:59:50 -0000 Sorry if this was a double post my subscribe was not working :( Im not sure if the original mail went through. 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 Regards 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) ## this is the bit that has me stumped 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' #######################################################################################################################################