Re: mod_auth_pgsql trouble (SOLVED)

2010-11-30 Thread Jason Dixon
On Tue, Nov 30, 2010 at 03:16:37PM +0100, Michael wrote: > > The problem here was the > > where user='name' > > part. When I used phpPgAdmin to generate that select it gave me > > where "user" = 'name' > > instead and that worked. So user seems to be some special name. After I > renamed the ro

Re: mod_auth_pgsql trouble (SOLVED)

2010-11-30 Thread Michael
Hello Daniel, Am 30.11.2010 13:29, schrieb LEVAI Daniel: > On Tue, Nov 30, 2010 at 12:56:32 +0100, Michael wrote: >> >> I am having trouble authenticating httpd users against a PostgreSQL >> database. Maybe someone here is using that module and can help me? > [...] > > Check the pgsql logs for th

Re: mod_auth_pgsql trouble

2010-11-30 Thread LEVAI Daniel
On Tue, Nov 30, 2010 at 12:56:32 +0100, Michael wrote: > Hello, > > I am having trouble authenticating httpd users against a PostgreSQL > database. Maybe someone here is using that module and can help me? [...] Check the pgsql logs for the actual query when trying to authenticate (adjust postgres

mod_auth_pgsql trouble

2010-11-30 Thread Michael
Hello, I am having trouble authenticating httpd users against a PostgreSQL database. Maybe someone here is using that module and can help me? The error_log shows only the following message. It doesn't matter if the user/pass actually exists or not: [Tue Nov 30 12:06:51 2010] [error] access to /p