OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
DB Lookup on virtual_mailbox_domains

From: Adrián Ribao Martínez (aribaogmail.com)
Date: Sat May 24 2008 - 15:00:10 CDT


Hello, I need to execute a db lookup for the virtual_mailbox_domains
I use the next configuration line:
virtual_mailbox_domains = pgsql:/etc/postfix/pgsql-domains.cf

Where:
/etc/postfix/pgsql-domains.cf
host= localhost
...
query = SELECT domain FROM users WHERE domain='%s'

I tried also
query = SELECT domain FROM users WHERE domain='%d'

but I get an error like:

.../pgsql-domains.cf(0,lock|fold_fix):table lookup problem

I have no idea what's going on, the only error I see in the postgreSQL log
file is something similar to:
It wasn't possible to accept an SSL connection: EOF detected

Any ideas?
Thank you.

--
Adrián Ribao Martínez

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBIOHPKHZYLQWAPcV8RAhjhAJ9AGxV336uTLpfJgvQ4uRZTJNdKsQCfaf7e
zDLUKD3HSVu5RzSbfyWgDd8=
=3OQG
-----END PGP SIGNATURE-----