Re: mod_auth_pgsql trouble (SOLVED)

[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 row to username it suddenly worked.
> 
> Really weird.
> 
> Is that a bug or a feature? Someone able to enlighten me? :-)

USER is a "SQL Key Word" (reserved word) in PostgreSQL.

http://www.postgresql.org/docs/8.4/static/sql-keywords-appendix.html

-- 
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net/

Re: mod_auth_pgsql trouble (SOLVED)

[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 the actual query when trying to authenticate
> (adjust postgresql.conf for more verbose logging if necessary). Execute
> the same query in the psql shell, and see what it returns; check if it's
> what you wanted.
> 
> The httpd.conf part seems ok to me, I'm using the same options, but
> with encrytion and without the logging.
> Also it may be easier to debug and to see through the situation if you
> omit the currently irrelevant parts from you config, like the pgsql
> logging.

Thanks a lot for your hint regarding the pgsql logs. After logging the
queries I could reproduce the problem using psql.

The query basically was:
select pass from table_name where user='name';

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 row to username it suddenly worked.

Really weird.

Is that a bug or a feature? Someone able to enlighten me? :-)

Thanks for your help!

Michael