Yes, I can connect manually (mysql command line) and via TCP/IP to localhost. Postfix uses mysql to get the usernames and mailboxes to deliver mail. IMAP uses the same database (and UN and PW) to verify (Courier-IMAP, and Courier-IMAP-SSL via authdaemon) There is no record of anything in the MySQL logs when I try to connect via SASL, but in the auth logs, it says
postfix/smtpd[17310]: sql auxprop plugin using mysql engine On Tue, Oct 14, 2008 at 12:45 PM, mouss <[EMAIL PROTECTED]> wrote: > Issac Kelly a écrit : >> 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 > > yes. use 127.0.0.1. > >> 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 >> > > I guess you can connect manually to mysql (on the same host), right? > Then make sure it's not apparmor preventing postfix from accessing > mysql. Also recheck the mysql login:password in smtpd.conf. > >> >> /var/log/mysql/mysql is silent however (and set to log queries) >> > > did you enable logging in my.cnf? should be something like > > log = /var/log/mysql/mysql.log > > (disable it once everything works, as it is not very good for > performances, nor for disk space if it gets a lot of queries). > > >> [snip] >> > > -- ------- Issac Kelly servee.com issackelly.com --------------------------
