postfix mysql on fedora core5

[igongora]

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


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?

[falko]

This is the problem:
Apr 14 00:57:44 cl-t022-500cl postfix/proxymap[31587]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES)Make sure you use the correct password for the mail_admin user.
What's the result of
SELECT * FROM user WHERE User = 'mail_admin'; (must be run in the mysql database)?

[igongora]

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


mysql -u mail_admin -p



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)

[falko]

Did you do a FLUSH PRIVILEGES; after your changes in the user table? Otherwise they don't take effect.

[igongora]

Hello Falko,

I flushed privileges,

However when I try to connect to mysql using:

mysql -u mail_admin -p


It works fine, but when I try


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?

[igongora]

I just want to make a correction,

mysql -h 127.0.0.1 -u mail_admin -p


works fine too..

[igongora]

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

[igongora]

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