[wellylug] mod-auth-pgsql

[Enkidu]

On Thu, 03 Jun 2004 16:42:24 +1200, you wrote:

>Hey,
>
>I'm trying to get this going against a postgres database. I keep getting
>failures:
>reason: PG user jamie: password mismatch
>
>Here is my apache snippet:
>AuthType basic
>        AuthName "Access via Postgres"
>        Auth_PG_host            aa.bb.cc.dd
>        Auth_PG_port            5432
>        Auth_PG_user            xxxxxxx
>        Auth_PG_database        xxx
>        Auth_PG_pwd             xxxxxxxxxxx
>        Auth_PG_pwd_table       users
>        Auth_PG_uid_field       name
>        Auth_PG_pwd_field       password
>        Auth_PG_encrypted       on
>        Auth_PG_hash_type       MD5
>        <LIMIT GET POST>
>                require valid-user
>        </LIMIT>
>
>Is there any special magic that I'm missing?
>
>About the only thing I can think of is that the app that's populating
>the database is encrypting the passwords in a format that mod_auth_pgsql
>doesn't understand.
>
I think the default encryption method is 'password' not 'MD5', isn't
it? 

Cheers,

Cliff