Prev Previous Post   Next Post Next
  #1  
Old 6th November 2005, 15: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
 

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
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota... killfrog HOWTO-Related Questions 3 25th September 2009 22:45
Problems with postfix vervem Installation/Configuration 5 27th March 2008 20:40
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs pontifex HOWTO-Related Questions 2 26th October 2005 18:54
Removed PostFix, Now MySql Problems!!! sapient Installation/Configuration 10 24th October 2005 08:11
postfix problems. jernis Installation/Configuration 2 16th September 2005 22:14


All times are GMT +2. The time now is 22:27.


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