Sebastjan Trepca
2005-Dec-15 15:02 UTC
[Dovecot] Variable '%r' doesn't transfomr in Postgres query
Hi,
i'm using postgres for authorization. When I switched from a4 to a5
authorization stoped working.
Query in conf file for postgres looks like this:
password_query = select password from auth('%u','%r');
But in logs, the transformed query looks like this:
Performing query: select password from auth('test','%r');
Looks like you don't transform that remote IP parameter?
Sebastjan
Sebastjan Trepca
2005-Dec-15 20:36 UTC
[Dovecot] Re: Variable '%r' doesn't transfomr in Postgres query
Sorry, our mistake. There was the old version(0.9) installed after a4 and everything got mixed up. Regards, Sebastjan On 15/12/05, Sebastjan Trepca <trepca@gmail.com> wrote:> Hi, > > i'm using postgres for authorization. When I switched from a4 to a5 > authorization stoped working. > > Query in conf file for postgres looks like this: > > password_query = select password from auth('%u','%r'); > > But in logs, the transformed query looks like this: > > Performing query: select password from auth('test','%r'); > > Looks like you don't transform that remote IP parameter? > > Sebastjan >