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 >