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] >
