I'm installing postfix on a fedora core 5 box, I'm following the installation according to http://www.howtoforge.com/fedora_virtual_postfix_mysql_quota_courier I followed step by step, the only thing I made different was the initial installation because I had mysql, httpd, php running. When I finished the installation I tried to login I started getting this error messages Code: Apr 14 00:57:38 cl-t022-500cl postfix/smtpd[407]: warning: 216.230.147.190: hostname 190.147.intelnet.net.gt verification fa iled: Name or service not known Apr 14 00:57:38 cl-t022-500cl postfix/smtpd[407]: connect from unknown[216.230.147.190] Apr 14 00:57:44 cl-t022-500cl postfix/proxymap[31587]: warning: connect to mysql server 127.0.0.1: Access denied for user 'm ail_admin'@'localhost' (using password: YES) Apr 14 00:57:44 cl-t022-500cl postfix/trivial-rewrite[409]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem Apr 14 00:57:44 cl-t022-500cl postfix/trivial-rewrite[411]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem Apr 14 00:57:44 cl-t022-500cl postfix/proxymap[413]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mai l_admin'@'localhost' (using password: YES) Apr 14 00:57:44 cl-t022-500cl postfix/trivial-rewrite[414]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem Apr 14 00:57:44 cl-t022-500cl postfix/trivial-rewrite[416]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem Apr 14 00:57:44 cl-t022-500cl postfix/trivial-rewrite[418]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem Apr 14 00:57:44 cl-t022-500cl postfix/trivial-rewrite[419]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[32303]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[32303]: warning: problem talking to service rewrite: Success Apr 14 00:57:45 cl-t022-500cl postfix/master[31568]: warning: process /usr/libexec/postfix/trivial-rewrite pid 409 exit stat us 1 Apr 14 00:57:45 cl-t022-500cl postfix/master[31568]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- t hrottling Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31931]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31931]: warning: problem talking to service rewrite: Connection reset by peer Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31637]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/master[31568]: warning: process /usr/libexec/postfix/trivial-rewrite pid 411 exit stat us 1 Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31637]: warning: problem talking to service rewrite: Success Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31586]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31586]: warning: problem talking to service rewrite: Connection reset by peer Apr 14 00:57:45 cl-t022-500cl postfix/master[31568]: warning: process /usr/libexec/postfix/trivial-rewrite pid 414 exit stat us 1 Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31898]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31898]: warning: problem talking to service rewrite: Success Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31852]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31852]: warning: problem talking to service rewrite: Connection reset by peer Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31945]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/master[31568]: warning: process /usr/libexec/postfix/trivial-rewrite pid 416 exit stat us 1 Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31945]: warning: problem talking to service rewrite: Success Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[32094]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[32094]: warning: problem talking to service rewrite: Connection reset by peer Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[32517]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[32517]: warning: problem talking to service rewrite: Success Apr 14 00:57:45 cl-t022-500cl postfix/master[31568]: warning: process /usr/libexec/postfix/trivial-rewrite pid 418 exit stat us 1 Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[31978]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[407]: warning: problem talking to service rewrite: Connection reset by peer Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[32647]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Apr 14 00:57:45 cl-t022-500cl postfix/smtpd[32647]: warning: problem talking to service rewrite: Success Apr 14 00:58:40 cl-t022-500cl pop3d-ssl: Connection, ip=[::ffff:216.230.147.190] I have checked for white spaces and I'm still getting this errors Some suggestion?
This is the problem: Make sure you use the correct password for the mail_admin user. What's the result of Code: SELECT * FROM user WHERE User = 'mail_admin'; (must be run in the mysql database)?
Falko, here is the result from the mysql query, I added the user 'mail_admin'@'localhost', 'mail_admin'@'localhost.localdomain', and after doing some research I added 'mail_admin'@'%' just to check but none of the worked my password works fine if I use the command Code: mysql -u mail_admin -p Code: mysql> SELECT * FROM user WHERE User = 'mail_admin'; +-----------------------+------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | +-----------------------+------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ | localhost | mail_admin | 002d429a556745e8 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | | localhost.localdomain | mail_admin | 002d429a556745e8 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | | % | mail_admin | 002d429a556745e8 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | +-----------------------+------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+ 3 rows in set (0.00 sec)
Did you do a Code: FLUSH PRIVILEGES; after your changes in the user table? Otherwise they don't take effect.
Hello Falko, I flushed privileges, However when I try to connect to mysql using: Code: mysql -u mail_admin -p It works fine, but when I try Code: mysql -h 127.0.0.1 -u mail_admin -p it doesn't accept the user. Could that be the reason? if so how do I fix it?
I forgot to mention that during recompilation of postfix it failed, so I downloaded the rpm at http://downloads.howtoforge.com/fedora_virtual_postfix_mysql_quota_courier/postfix-2.2.8-1.2.i386.rpm
It working now, I removed postfix, courier IMAP, remove erased mail_admin from the users database, and did all over again and its working, I just need to install clamv, and amavis to finish the instalation Regards, Ismael Gongora
