postfix mysql on fedora core5

Discussion in 'Installation/Configuration' started by igongora, Apr 14, 2007.

  1. igongora

    igongora New Member

    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?
     
  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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)?
     
  3. igongora

    igongora New Member

    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)
    
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

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

    igongora New Member

    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?
     
  6. igongora

    igongora New Member

    I just want to make a correction,
    Code:
    mysql -h 127.0.0.1 -u mail_admin -p
    
    works fine too..
     
  7. igongora

    igongora New Member

  8. igongora

    igongora New Member

    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
     

Share This Page