Received: from druid.net (druid.net [216.126.72.98])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f2UCaTK32881
	for <pgsql-interfaces@postgresql.org>;
	Fri, 30 Mar 2001 07:36:29 -0500 (EST) (envelope-from darcy@druid.net)
Received: by druid.net (Postfix, from userid 1000)
	id 90E701A6E; Fri, 30 Mar 2001 07:36:29 -0500 (EST)
Subject: Re: mod_auth_pgsql
In-Reply-To: <Pine.BSF.4.21.0103291609140.431-100000@wired.hub.org>
	"from Jeff MacDonald at Mar 29, 2001 04:10:05 pm"
To: Jeff MacDonald <jeff@hub.org>
Date: Fri, 30 Mar 2001 07:36:29 -0500 (EST)
Cc: pgsql-interfaces@postgresql.org
Reply-To: pgsql-interfaces@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL78 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
Message-Id: <20010330123629.90E701A6E@druid.net>
From: darcy@druid.net (D'Arcy J.M. Cain)
X-Archive-Number: 200103/212
X-Sequence-Number: 1374

Thus spake Jeff MacDonald
> Does anyone know what directives to add to a .htaccess file
> to allow mod_auth_pgsql to connnect to password protected
> databases as certain users ?

This first may be required in the httpd.conf file.

LoadModule auth_pg_module /usr/lib/httpd/mod_auth_pg.so

You may also need something like this.

<Directory /> 
    Options FollowSymLinks ExecCGI Indexes
    AllowOverride All
    AuthPGAuthoritative off
</Directory>

In your .htaccess, something like this.

    AuthName "My Realm"
    AuthType Basic
    require valid-user
    AuthPGAuthoritative on
	AuthPGEncrypted off           # needed if you store passwords as plain text
    AuthPGHost "db.mydomain.com"  # needed if database is on other system
    AuthPGDatabase "dbname"
    AuthPGQuery "SELECT pwd FROM table WHERE login = '%s'"

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.