postfix trying to use root to log onto mysql

[mattgrannary]

I decided to revisit the section about aliases and noticed that I had set the two recommended settings to something else when I was trying to figure out the original problem. I've re-edited the aliases file setting the mailer-daemon to postfix and the postmaster to root and root to my user. I ran newaliases and restarted postfix and now I'm seeing the original error where postfix is trying to log in to mysql with my root user....

[TiTex]

the only thing i can think of is that you messed up one of the /etc/postfix/mysql-* files
you should double/triple check and see if in all your files you've setted up the correct mysql credentials/database

[TiTex]

by the way falko should update the howto , he forgot to add a package to the 3rd step , at least for me yum install cyrus-sasl-devel did not install cyrus-sasl-plain and i was getting an error

Mar 16 17:02:29 mail postfix/master[1943]: daemon started -- version 2.6.6, configuration /etc/postfix
Mar 16 17:02:57 mail postfix/smtpd[1949]: warning: dict_nis_init: NIS domain name not set - NIS lookups disabled
Mar 16 17:02:57 mail postfix/smtpd[1949]: connect from localhost[127.0.0.1]
Mar 16 17:02:57 mail postfix/smtpd[1949]: warning: xsasl_cyrus_server_get_mechanism_list: no applicable SASL mechanisms
Mar 16 17:02:57 mail postfix/smtpd[1949]: fatal: no SASL authentication mechanisms
Mar 16 17:02:58 mail postfix/master[1943]: warning: process /usr/libexec/postfix/smtpd pid 1949 exit status 1
Mar 16 17:02:58 mail postfix/master[1943]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
Mar 16 17:04:54 mail postfix/postfix-script[2010]: stopping the Postfix mail system

[falko]

Thanks, will have to check. Maybe that package got already installed during the basic system installation. Fact is, the tutorial works for me.

[TiTex]

my mistake ... i allways use the minimal install iso as i did with the postfix testing instalation

P.S. if your postfix server is on the same box as your MX record you should not add this in your database

INSERT INTO `transport` (`domain`, `transport`) VALUES ('example.com', 'smtp:mail.example.com');

it will create a loop and mail that your are sending to the localdomain (domain hosted on the box) won't be sent and as a result using mailx to send a wellcome message and create the maildir for the user will not work and you'll get an error on the webmail login

ERROR:
ERROR: Connection dropped by IMAP server.

and maillog

Mar 20 09:11:54 server imapd: chdir example.lan/test/: No such file or directory
Mar 20 09:11:54 server imapd: test@example.lan: No such file or directory