If have followed this on a fedora 13 server. Round 1 went fine till I got carried away and installed another set of amavis stuff. So I bailed and started over. Second time should be a charm! No such luck. Now I am stuck on the horrible Oct 7 12:09:11 possak postfix/proxymap[26558]: warning: connect to mysql server unix:/var/lib/mysql/mysql.sock: Access denied for user 'mail_admin'@'localhost' (using password: YES) I tried orig =>127.0.0.1 / localhost /and now even unix:/var/lib/mysql/mysql.sock: but all give exactly the same error. I even tried a % for host "localhost";"root";"*566312ACC9246D99DA116B457CFA157D57FA64F4";"Y";"Y" "possak.shimei.net";"root";"*566312ACC9246D99DA116B457CFA157D57FA64F4" "127.0.0.1";"root";;"Y";"Y";"Y";"Y";"Y";"Y";"Y";"Y";"Y";"Y";"Y";"Y";"Y "localhost";;;"N";"N";"N";"N";"N";"N";"N";"N";"N";"N";"N";"N";"N";"N"; "possak.shimei.net";;;"N";"N";"N";"N";"N";"N";"N";"N";"N";"N";"N";"N"; "localhost";"mail_admin";"*F6EE300906CE1572397AB26E48F3FDB9EA76625F";" "localhost.localdomain";"mail_admin";"*F6EE300906CE1572397AB26E48F3FDB "%";"mail_admin";"*F6EE300906CE1572397AB26E48F3FDB9EA76625F";"Y";"N";" some thing somewhere said reverse lookup was the issue? Here is my host file /etc/postfixossak.shimei.net:## cat /etc/hosts 127.0.0.1 localhost.localdomain localhost 71.185.181.13 possak.shimei.net possak 192.168.10.54 sakkie.shimei.net sakkie This was asked for in other posts: /etc/postfixossak.shimei.net:## netstat -tad Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 *:imaps *:* LISTEN tcp 0 0 *op3s *:* LISTEN tcp 0 0 localhost.localdomain:10024 *:* LISTEN tcp 0 0 localhost.localdomain:10025 *:* LISTEN tcp 0 0 *:mysql *:* LISTEN tcp 0 0 *op3 *:* LISTEN tcp 0 0 *:imap *:* LISTEN tcp 0 0 *:http *:* LISTEN tcp 0 0 *:ssh *:* LISTEN tcp 0 0 *:smtp *:* LISTEN tcp 0 0 sakkie.shimei.net:ssh nixnooi.adnog.org:58321 ESTABLISHED tcp 0 0 sakkie.shimei.net:ssh nixnooi.adnog.org:43245 ESTABLISHED tcp 0 448 possak.shimei.net:ssh wan.ctdi.com:33455 ESTABLISHED tcp 0 0 possak.shimei.net:ssh wan.ctdi.com:45270 ESTABLISHED
Can you log into the mysql server as the user you specified in the postfix configs? Can you post your configs so we can see what is going on?
well this works : not sure how to do -h 127.0.0.1 and -u 'mail_admin'@'localhost' which is sort of what the error says. /etc/postfixossak.shimei.net:## mysql -h 127.0.0.1 -u mail_admin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 178 Server version: 5.1.50 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> /etc/postfixossak.shimei.net:## mysql -h localhost -u mail_admin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 185 Server version: 5.1.50 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
I reverted back to the original hosts = 127.0.0.1 /etc/postfixossak.shimei.net:## more mysql-virtual_domains.cf user = mail_admin password = 'appeltree' --- [SIZE="-1"]don't worry not the real thing but the quotes are there WFIW[/SIZE] dbname = mail query = SELECT domain AS virtual FROM domains WHERE domain='%s' hosts = 127.0.0.1 and the errors currently are Oct 7 15:56:23 possak postfix/smtpd[2557]: connect from wan.ctdi.com[65.213.88.130] Oct 7 15:56:33 possak postfix/proxymap[2558]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES) Oct 7 15:56:33 possak postfix/proxymap[2558]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES) Oct 7 15:56:33 possak postfix/trivial-rewrite[2561]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem Oct 7 15:56:34 possak postfix/master[2552]: warning: process /usr/libexec/postfix/trivial-rewrite pid 2561 exit status 1 Oct 7 15:56:35 possak postfix/trivial-rewrite[2564]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem Oct 7 15:56:36 possak postfix/smtpd[2557]: warning: problem talking to service rewrite: Success Oct 7 15:56:36 possak postfix/master[2552]: warning: process /usr/libexec/postfix/trivial-rewrite pid 2564 exit status 1 Oct 7 15:56:36 possak postfix/master[2552]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling Oct 7 15:57:36 possak postfix/proxymap[2558]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES) Oct 7 15:57:36 possak postfix/proxymap[2558]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES) Oct 7 15:57:36 possak postfix/trivial-rewrite[2566]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem Oct 7 15:57:37 possak postfix/smtpd[2557]: warning: problem talking to service rewrite: Success Oct 7 15:57:37 possak postfix/master[2552]: warning: process /usr/libexec/postfix/trivial-rewrite pid 2566 exit status 1 Oct 7 15:57:37 possak postfix/master[2552]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling
Can you execute the query specified, if you log in manually to the MySQL server? Have you checked the permissions of the mail_admin user in PHPMyAdmin? What does your hosts file look like?
/etc/postfixossak.shimei.net:## cat /etc/hosts 127.0.0.1 localhost.localdomain localhost 71.185.181.13 possak.shimei.net possak 192.168.10.54 sakkie.shimei.net sakkie
/etc/postfixossak.shimei.net:## mysql -u mail_admin -h 127.0.0.1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.50 Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use mail; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SELECT domain AS virtual FROM domains WHERE domain='shimei.net'; +------------+ | virtual | +------------+ | shimei.net | +------------+ 1 row in set (0.00 sec) mysql>
DAMMIT! password = 'appeltree' --- don't worry not the real thing but the quotes are there WFIW well it's worth quite a few hours of my LIFE NO DARN QUOTES if you want it to work. UGHHH