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_vir..._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..