From: Wietse Venema (wietseporcupine.org)
Date: Mon Mar 05 2007 - 20:01:14 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Victor Duchovni:
> On Mon, Mar 05, 2007 at 06:21:46PM -0500, Jonathan Towne wrote:
>
> > Hello all,
> >
> >
> > I'm trying to setup a pgsql based map for mynetworks lookups
> > because I've got 60+ mailservers to deal with and separate
> > networks for each. They'll all be using one database server
> > for vmailbox lookups, and I'd prefer they do the same for the
> > mynetworks settings.
> >
> > My problem is: I've got it setup with what I think is a
> > reasonable configuration, but it looks like postfix is
> > passing the FQDN instead of the connecting IP to my query.
> >
> >
> > The error is as follows:
> >
> > Mar 5 18:17:31 mail postfix/smtpd[64488]: warning: pgsql query failed: fatal error from host 1.2.3.4: ERROR: invalid input syntax for type inet: "my.clienthost.com"?
> > Mar 5 18:17:31 mail postfix/smtpd[64488]: fatal: pgsql:/usr/local/etc/postfix/relaynets-db.cf(0,lock|fold_fix): table lookup problem
> >
>
> You need to filter out input keys that don't look like IP addresses.

Like many table lookups, the order of Postfix access map queries
should be customizable, but that hasn't happened yet.

        Wietse

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]