Using mysql for mynetworks

2 msg	Remote backup Postfix server
7 msg	chose interface for outgoing mail
2 msg	Illegal address syntax ... in MAIL command: <...
1 msg	Mail Infrastructure and Zertificon
1 msg	sasl password
6 msg	postfix TLS (configuration/user) problem
7 msg	Virtual Alias Domain
3 msg	copy of email
2 msg	DNS Caching?

Using mysql for mynetworks
\ Keith (12 Mar 2008)
. \ Magnus Bäck (12 Mar 2008)
. . \ Keith (12 Mar 2008)
. . . \ mouss (12 Mar 2008)
. . . . \ Keith (12 Mar 2008)

5 msg	Blocking e-mail from a domain, to a particular ...
5 msg	prevent open relay
15 msg	cannot get mail from outside to my smtp server
6 msg	Error connecting Postfix to LDAP
5 msg	Config ok for TLS/SASL/Client Cert via port 587?
7 msg	mail flow architecture
3 msg	virtual forward + deliver
1 msg	Re: RESOLVED: Using Canonical Maps as an Overri...
14 msg	dual mail server
3 msg	how to specify different outgoing IP

Subject:	Using mysql for mynetworks
Group:	Postfix-users
From:	Keith
Date:	12 Mar 2008

I'm missing something simple I think.

I have been experimenting on using mysql for mynetworks.

I have:

mynetworks = mysql:/etc/postfix/mysql/access.conf

user = <user>
password = <password>
dbname = postfix
table = access
select_field = action
where_field = ip
hosts = localhost

This is access.conf setup for the sql query.

I have access table:

action IP
relay 64.114.232.0/22

I try and send an email from a client on: 64.114.232.10 and I get relay
access denied.

I add the single IP to the access table:

action IP
relay 64.114.232.10

and the client can send mail.

I take out mynetworks from using an sql query and just have:

mynetworks = /etc/postfix/mynetworks

in mynetworks:

64.114.232.0/22 relay

and the client can relay through postfix.

Does postfix use the slash notation in mysql lookups for mynetworks? Or is
it just for the flat file postfix will do the slash for IP lookups?

Thanks,
Keith