#1  
Old 14th April 2007, 07:34
igongora igongora is offline
Junior Member
 
Join Date: Apr 2007
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy postfix mysql on fedora core5

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

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?
Reply With Quote
Sponsored Links
  #2  
Old 14th April 2007, 14:29
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

This is the problem:
Quote:
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
Code:
SELECT * FROM user WHERE User = 'mail_admin';
(must be run in the mysql database)?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 14th April 2007, 17:45
igongora igongora is offline
Junior Member
 
Join Date: Apr 2007
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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)
Reply With Quote
  #4  
Old 15th April 2007, 11:34
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Did you do a
Code:
FLUSH PRIVILEGES;
after your changes in the user table? Otherwise they don't take effect.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 16th April 2007, 17:27
igongora igongora is offline
Junior Member
 
Join Date: Apr 2007
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?
Reply With Quote
  #6  
Old 16th April 2007, 19:19
igongora igongora is offline
Junior Member
 
Join Date: Apr 2007
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
Virtual Users And Domains With Postfix, Courier And MySQL (Fedora Core 5) ed bad exit wsand70 HOWTO-Related Questions 2 25th February 2007 21:52
Virtual Users And Domains With Postfix, Courier And MySQL (Fedora Core 5) sapphire327 HOWTO-Related Questions 10 25th December 2006 15:59
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 15:47
Verify email setup meekish Installation/Configuration 28 27th October 2006 15:36


All times are GMT +2. The time now is 19:24.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.