Re: PostgreSQL virtual_mailbox_domain lookups fail, but virtual_alias_maps work just fine, help?

2020-08-09 Thread Wietse Venema
David Reagan: > Thanks. Switching the query to the default '%s' and making sure I didn't > have 'result_format' set fixed it. The postmap query works. > > Is the fact that %d won't work in this context documented anywhere? I > didn't see anything in http://www.postfix.org/pgsql_table.5.html or a

Re: PostgreSQL virtual_mailbox_domain lookups fail, but virtual_alias_maps work just fine, help?

2020-08-09 Thread David Reagan
Thanks. Switching the query to the default '%s' and making sure I didn't have 'result_format' set fixed it. The postmap query works. Is the fact that %d won't work in this context documented anywhere? I didn't see anything in http://www.postfix.org/pgsql_table.5.html or any of the other docs I

Re: PostgreSQL virtual_mailbox_domain lookups fail, but virtual_alias_maps work just fine, help?

2020-08-08 Thread Viktor Dukhovni
On Sat, Aug 08, 2020 at 06:42:16PM -0700, David Reagan wrote: > By key you mean use 'raygun.zat' instead of 'k...@raygun.zat'? The former is the lookup key that Postfix asks the lookup table to find. > Also, if you look at the query, I use '%d'. So, unless I'm > misunderstanding the docs, postf

Re: PostgreSQL virtual_mailbox_domain lookups fail, but virtual_alias_maps work just fine, help?

2020-08-08 Thread David Reagan
Thanks for the response. By key you mean use 'raygun.zat' instead of 'k...@raygun.zat'? I did try that. The output that gave was the same, just no 'postmap: dict_pgsql_lookup: retrieved 1 rows' line. Also, if you look at the query, I use '%d'. So, unless I'm misunderstanding the docs, postfi

Re: PostgreSQL virtual_mailbox_domain lookups fail, but virtual_alias_maps work just fine, help?

2020-08-08 Thread Noel Jones
On 8/8/2020 1:52 PM, David Reagan wrote: Hey all, I'm working on configuring a mailserver that uses a PostgreSQL database for virtual information. The database is managed by Vimbadmin. I think I've found at least part of the problem. The virtual_mailbox_domains setting likely isn't getting t

PostgreSQL virtual_mailbox_domain lookups fail, but virtual_alias_maps work just fine, help?

2020-08-08 Thread David Reagan
Hey all, I'm working on configuring a mailserver that uses a PostgreSQL database for virtual information. The database is managed by Vimbadmin. I think I've found at least part of the problem. The virtual_mailbox_domains setting likely isn't getting the correct output when it is checking for