Ok, I'm getting closer in /var/log/auth.log Oct 14 07:12:07 postfix/smtpd[15456]: sql auxprop plugin using mysql engine Oct 14 07:18:01 postfix/smtpd[15469]: sql plugin trying to open db 'maildb ' on host 'localhost' Oct 14 07:18:01 postfix/smtpd[15469]: sql plugin could not connect to host localhost Oct 14 07:18:01 postfix/smtpd[15469]: sql plugin couldn't connect to any host Oct 14 07:19:41 saslauthd[15368]: server_exit : master exited: 15368 Oct 14 07:19:41 saslauthd[15580]: detach_tty : master pid is: 15580 Oct 14 07:19:41 saslauthd[15580]: ipc_init : listening on socket: /var/spool/postfix/var/run/saslauthd/mux #at this point, i changed /etc/postfix/sasl/smtp.conf sql_host to 127.0.0.1 to check if it worked Oct 14 07:19:57 postfix/smtpd[15663]: sql auxprop plugin using mysql engine Oct 14 07:20:00 postfix/smtpd[15663]: sql plugin Parse the username [EMAIL PROTECTED] Oct 14 07:20:00 postfix/smtpd[15663]: sql plugin try and connect to a host Oct 14 07:20:00 postfix/smtpd[15663]: sql plugin trying to open db 'maildb ' on host '127.0.0.1' Oct 14 07:20:00 postfix/smtpd[15663]: sql plugin could not connect to host 127.0.0.1 Oct 14 07:20:00 postfix/smtpd[15663]: sql plugin couldn't connect to any host
/var/log/mysql/mysql is silent however (and set to log queries) $ telnet mail.host.com. 25 Trying 75.101.148.70... Connected to mail.host.com. Escape character is '^]'. 220 Servee SMTP ESMTP EHLO test 250-hostname 250-PIPELINING 250-SIZE 10240000 250-ETRN 250-STARTTLS 250-AUTH DIGEST-MD5 LOGIN CRAM-MD5 PLAIN 250-AUTH=DIGEST-MD5 LOGIN CRAM-MD5 PLAIN 250-ENHANCEDSTATUSCODES 250-8BITMIME 250 DSN auth plain dGVzdDJAdGhyZWVmb3VuGC5jb20AcGFzc3dvcmQ= 535 5.7.8 Error: authentication failed: bad protocol / cancel (the above is a hash of a test account) So, I'm guessing that sasl can't connect to mysql because of the chroot or something? I don't know how I would check that, and I could be completely off. That would be strange, considering that postfix knows how to connect to mysql, and is getting through just fine to deliver mail. Thanks much for the help thus far. On Tue, Oct 14, 2008 at 10:08 AM, mouss <[EMAIL PROTECTED]> wrote: > Issac Kelly a écrit : >> Here is my saslfinger output >> >> #saslfinger -c >> saslfinger - postfix Cyrus sasl configuration Tue Oct 14 06:22:13 PDT 2008 >> version: 1.0.2 >> mode: client-side SMTP AUTH >> >> -- basics -- >> Postfix: 2.5.1 >> System: Ubuntu 8.04 \n \l >> >> -- smtp is linked to -- >> libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x00843000) >> >> -- active SMTP AUTH and TLS parameters for smtp -- >> smtp_tls_note_starttls_offer = yes >> >> >> -- listing of /usr/lib/sasl2 -- >> total 796 >> drwxr-xr-x 2 root root 4096 2008-10-14 06:06 . >> drwxr-xr-x 55 root root 12288 2008-05-04 09:48 .. >> -rw-r--r-- 1 root root 13568 2008-04-09 14:50 libanonymous.a >> -rw-r--r-- 1 root root 862 2008-04-09 14:49 libanonymous.la >> -rw-r--r-- 1 root root 12984 2008-04-09 14:50 libanonymous.so >> -rw-r--r-- 1 root root 12984 2008-04-09 14:50 libanonymous.so.2 >> -rw-r--r-- 1 root root 12984 2008-04-09 14:50 libanonymous.so.2.0.22 >> -rw-r--r-- 1 root root 15834 2008-04-09 14:50 libcrammd5.a >> -rw-r--r-- 1 root root 848 2008-04-09 14:49 libcrammd5.la >> -rw-r--r-- 1 root root 15320 2008-04-09 14:50 libcrammd5.so >> -rw-r--r-- 1 root root 15320 2008-04-09 14:50 libcrammd5.so.2 >> -rw-r--r-- 1 root root 15320 2008-04-09 14:50 libcrammd5.so.2.0.22 >> -rw-r--r-- 1 root root 46332 2008-04-09 14:50 libdigestmd5.a >> -rw-r--r-- 1 root root 871 2008-04-09 14:49 libdigestmd5.la >> -rw-r--r-- 1 root root 43020 2008-04-09 14:50 libdigestmd5.so >> -rw-r--r-- 1 root root 43020 2008-04-09 14:50 libdigestmd5.so.2 >> -rw-r--r-- 1 root root 43020 2008-04-09 14:50 libdigestmd5.so.2.0.22 >> -rw-r--r-- 1 root root 13574 2008-04-09 14:50 liblogin.a >> -rw-r--r-- 1 root root 842 2008-04-09 14:49 liblogin.la >> -rw-r--r-- 1 root root 13268 2008-04-09 14:50 liblogin.so >> -rw-r--r-- 1 root root 13268 2008-04-09 14:50 liblogin.so.2 >> -rw-r--r-- 1 root root 13268 2008-04-09 14:50 liblogin.so.2.0.22 >> -rw-r--r-- 1 root root 30016 2008-04-09 14:50 libntlm.a >> -rw-r--r-- 1 root root 836 2008-04-09 14:49 libntlm.la >> -rw-r--r-- 1 root root 29236 2008-04-09 14:50 libntlm.so >> -rw-r--r-- 1 root root 29236 2008-04-09 14:50 libntlm.so.2 >> -rw-r--r-- 1 root root 29236 2008-04-09 14:50 libntlm.so.2.0.22 >> -rw-r--r-- 1 root root 13798 2008-04-09 14:50 libplain.a >> -rw-r--r-- 1 root root 842 2008-04-09 14:49 libplain.la >> -rw-r--r-- 1 root root 13396 2008-04-09 14:50 libplain.so >> -rw-r--r-- 1 root root 13396 2008-04-09 14:50 libplain.so.2 >> -rw-r--r-- 1 root root 13396 2008-04-09 14:50 libplain.so.2.0.22 >> -rw-r--r-- 1 root root 22126 2008-04-09 14:50 libsasldb.a >> -rw-r--r-- 1 root root 873 2008-04-09 14:49 libsasldb.la >> -rw-r--r-- 1 root root 18080 2008-04-09 14:50 libsasldb.so >> -rw-r--r-- 1 root root 18080 2008-04-09 14:50 libsasldb.so.2 >> -rw-r--r-- 1 root root 18080 2008-04-09 14:50 libsasldb.so.2.0.22 >> -rw-r--r-- 1 root root 23696 2008-04-09 14:50 libsql.a >> -rw-r--r-- 1 root root 971 2008-04-09 14:49 libsql.la >> -rw-r--r-- 1 root root 23140 2008-04-09 14:50 libsql.so >> -rw-r--r-- 1 root root 23140 2008-04-09 14:50 libsql.so.2 >> -rw-r--r-- 1 root root 23140 2008-04-09 14:50 libsql.so.2.0.22 >> -rw-r--r-- 1 root root 258 2008-10-14 06:07 smtpd.conf >> >> >> Cannot find the smtp_sasl_password_maps parameter in main.cf. >> Client-side SMTP AUTH cannot work without this parameter! >> >> # saslfinger -s >> #-- basics -- >> Postfix: 2.5.1 >> System: Ubuntu 8.04 \n \l >> >> -- smtpd is linked to -- >> libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x005fc000) >> >> -- active SMTP AUTH and TLS parameters for smtpd -- >> broken_sasl_auth_clients = yes >> smtpd_sasl_auth_enable = yes >> smtpd_sasl_authenticated_header = yes >> smtpd_sasl_local_domain = > > This the default, so remove it. > > >> smtpd_sasl_path = /etc/postfix/sasl:/usr/lib/sasl2 > > This is your problem. The default is "smtpd" which is ok. remove the line. > > [snip] >> >> >> >> -- content of /usr/lib/sasl2/smtpd.conf -- > > debian (thus ubuntu) uses the other file (below). > >> >> -- content of /etc/postfix/sasl/smtpd.conf -- >> pwcheck_method: auxprop >> auxprop_plugin: sql >> mech_list: plain login cram-md5 digest-md5 >> sql_engine: mysql >> sql_hostnames: localhost >> sql_user: --- replaced --- >> sql_passwd: --- replaced --- >> sql_database: maildb >> sql_select: select clear from users where id='[EMAIL PROTECTED]' and enabled >> = 1 > > looks ok. you can add > log_level: 7 > if you want more logs (they should appear in your /var/log/auth.log) > >> [snip] >> > > -- ------- Issac Kelly servee.com issackelly.com --------------------------
