[rt-users] database: user password encryption

[Jamie Baddeley]

Hi,

I'm wanting to use mod_auth_pgsql to connect to the user table of the 
database so I can use my RT user/pass pair for apache authentication.

I want to use my RT DB as the master user db for other websites.

mod_auth_pgsql can deal with crypt and MD5 coded passwords.....

what format does rt store the passwords in? Because it's not working for
me....saying there's a password mismatch..

My apache snippet looks like this:

 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>



tia,

jamie
--