RE: [AuthPG] can not authenticate with mod_auth_pg

[John F. <jo...@fe...>]

> I want to set up a web server, which is connected to a database.
> The content
> of the db should only be available for authorized users.
> My configuration is:
> Suse Linux 7.2
> Apache 1.3.20
> mod_auth_pg 1.3
> PostgreSQL 7.1.3
>
> I created the .htaccess file and made the corresponding adjustments in the
> httpd.conf:
> Content of .htaccess:
> AuthName "Customer Support Database"
> AuthType Basic
> AuthPGHost localhost
> AuthPGPort 5432
> AuthPGUser postgres
> AuthPGPassword postgres
> AuthPGDatabase customers
> AuthPGUserTable user_authentication
> AuthPGUserNameField auth_user
> AuthPGPasswordField auth_pwd
> AuthPGQuery "select auth_pwd from user_authentication where auth_user =
> '%s';"

Is the password in cleartext in your DB?  If so, that's the
problem -- authpg looks for a crypt'ed password (you can
crypt it in perl against itself.)  The directive is AuthPGencrypted.
Store the crypt'd version of the password in your db or turn
off that function with the directive.

-John