Problem with postgres transport_maps

[Frank Abel Cancio Bello]

Hi all,

I have a really estrange problem while trying store my "transport_maps"
on postgres.

I have a config that work fine and have a line:
"transport_maps = hash:/etc/postfix/transport"

but when I replace that line by the following line:
"transport_maps = pgsql:/etc/postfix/pgsql-transport.cf"

in my logs appear the following messages:
"
May 24 16:48:03 cujae postfix/trivial-rewrite[17776]: maps_find:
transport_maps: [hidden email]: search aborted  

May 24 16:48:03 cujae postfix/trivial-rewrite[17776]: warning:
transport_maps lookup failure

....

May 24 16:48:06 cujae postfix/smtpd[17789]: NOQUEUE: reject: RCPT from
static-adsl201-232-110-196.epm.net.co[201.232.110.196]
: 451 <[hidden email]>: Temporary lookup failure;
from=<[hidden email]> to=<rcastellanos@ceis.
cujae.edu.cu> proto=SMTP helo=<dsldevice.lan>
"

Is a very rare behavior because on command line when I execute:
"
postmap -q "[hidden email]"
pgsql:/etc/postfix/pgsql-transport.cf
"

the result is:
"discard:"

I mean, the postgres conf and "/etc/postfix/pgsql-transport.cf" content
seen fine because otherwise not reply could be given by the postmap
command.

Just wandering what are the differences between the postmap lookup and
postfix trivial-rewrite daemon lookup.

Posfix version
2.2.4

Any tips about this problem?

Thanks in advance.

Cheers
Frank Abel

[mouss-2]

Frank Abel Cancio Bello wrote:

> Hi all,
>
> I have a really estrange problem while trying store my "transport_maps"
> on postgres.
>
> I have a config that work fine and have a line:
> "transport_maps = hash:/etc/postfix/transport"
>
> but when I replace that line by the following line:
> "transport_maps = pgsql:/etc/postfix/pgsql-transport.cf"
>
> in my logs appear the following messages:
> "
> May 24 16:48:03 cujae postfix/trivial-rewrite[17776]: maps_find:
> transport_maps: [hidden email]: search aborted  
>
> May 24 16:48:03 cujae postfix/trivial-rewrite[17776]: warning:
> transport_maps lookup failure
>
> ....
>
> May 24 16:48:06 cujae postfix/smtpd[17789]: NOQUEUE: reject: RCPT from
> static-adsl201-232-110-196.epm.net.co[201.232.110.196]
> : 451 <[hidden email]>: Temporary lookup failure;
> from=<[hidden email]> to=<rcastellanos@ceis.
> cujae.edu.cu> proto=SMTP helo=<dsldevice.lan>
> "
>
> Is a very rare behavior because on command line when I execute:
> "
> postmap -q "[hidden email]"
> pgsql:/etc/postfix/pgsql-transport.cf
> "
>
> the result is:
> "discard:"
>
> I mean, the postgres conf and "/etc/postfix/pgsql-transport.cf" content
> seen fine because otherwise not reply could be given by the postmap
> command.
>
> Just wandering what are the differences between the postmap lookup and
> postfix trivial-rewrite daemon lookup.
>
> Posfix version
> 2.2.4
>
> Any tips about this problem?
>  

- anything chrooted? if so, consider accessing postgres using TCP
- do you see any errors in your postgres logs? (maybe permission issues).


try  

transport_maps = proxy:pgsql:/etc/postfix/pgsql-transport.cf

[Frank Abel Cancio Bello]

On Sun, 2008-05-25 at 18:59 +0200, mouss wrote:

> Frank Abel Cancio Bello wrote:
> > Hi all,
> >
> > I have a really estrange problem while trying store my "transport_maps"
> > on postgres.
> >
> > I have a config that work fine and have a line:
> > "transport_maps = hash:/etc/postfix/transport"
> >
> > but when I replace that line by the following line:
> > "transport_maps = pgsql:/etc/postfix/pgsql-transport.cf"
> >
> > in my logs appear the following messages:
> > "
> > May 24 16:48:03 cujae postfix/trivial-rewrite[17776]: maps_find:
> > transport_maps: [hidden email]: search aborted  
> >
> > May 24 16:48:03 cujae postfix/trivial-rewrite[17776]: warning:
> > transport_maps lookup failure
> >
> > ....
> >
> > May 24 16:48:06 cujae postfix/smtpd[17789]: NOQUEUE: reject: RCPT from
> > static-adsl201-232-110-196.epm.net.co[201.232.110.196]
> > : 451 <[hidden email]>: Temporary lookup failure;
> > from=<[hidden email]> to=<rcastellanos@ceis.
> > cujae.edu.cu> proto=SMTP helo=<dsldevice.lan>
> > "
> >
> > Is a very rare behavior because on command line when I execute:
> > "
> > postmap -q "[hidden email]"
> > pgsql:/etc/postfix/pgsql-transport.cf
> > "
> >
> > the result is:
> > "discard:"
> >
> > I mean, the postgres conf and "/etc/postfix/pgsql-transport.cf" content
> > seen fine because otherwise not reply could be given by the postmap
> > command.
> >
> > Just wandering what are the differences between the postmap lookup and
> > postfix trivial-rewrite daemon lookup.
> >
> > Posfix version
> > 2.2.4
> >
> > Any tips about this problem?
> >  
>
> - anything chrooted? if so, consider accessing postgres using TCP
> - do you see any errors in your postgres logs? (maybe permission issues).
>
>
> try  
>
> transport_maps = proxy:pgsql:/etc/postfix/pgsql-transport.cf
>
>
>

I don't have anything chrooted and postgres logs don't show anything, it
just show something when I use postmap command.

I add proxy: and all work fine, what strange problem eh? Seen like a
different between the proxymap server and trivial-rewrite server, but
witch one?

Thanks a lot for you help!

Cheers
Frank Abel