View Single Post
  #1  
Old 6th November 2005, 14:26
Pelle Pelle is offline
Junior Member
 
Join Date: Sep 2005
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problems with postfix-mysql

I have followered the tut:
http://howtoforge.com/virtual_postfi..._quota_courier

I finished the tutorial with no problems, now I'm trying to test the mail system by sending a mail to a given email I have put in to the database!

It looks like there are severel problems, but the first is that postfix can not access the mysql database?

syslog:
Code:
Nov  6 05:22:44 houston2 postfix/smtpd[32212]: connect from xproxy.gmail.com[66.249.82.199]
Nov  6 05:22:45 houston2 postfix/proxymap[32213]: warning: connect to mysql server 127.0.0.1: #HY000Host 'gmlitconsultis' is not allowed to connect to this MySQL server
Nov  6 05:22:45 houston2 postfix/proxymap[32213]: warning: connect to mysql server 127.0.0.1: #HY000Host 'gmlitconsultis' is not allowed to connect to this MySQL server
Nov  6 05:22:45 houston2 postfix/trivial-rewrite[32214]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Nov  6 05:22:46 houston2 postfix/smtpd[32212]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
How can I solve this, Have tried looking for solutions for the connect problem (found this http://forums.mysql.com/read.php?86,...3619#msg-23619 ) but dosent help, because the solution there was to create the database user, but I have.. and the password is correct!

Then the next problem I think I have a solution for:
Code:
/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
If I look at this file then

Code:
user = mail_admin
password = mail_admin_password
dbname = mail
table = domains
select_field = 'virtual'
where_field = domain
hosts = 127.0.0.1
but in this table, 'virtual' dosent exist only the collumm "domain" do.
Should this bee domain instead?
Sponsored Links