Reply-To: <Jeff@PointHere.net>
From: "Jeffrey Brower" <Jeff@PointHere.net>
To: <Jeff@PointHere.net>,
	<pgsql-performance@postgresql.org>
References: <501201c808e4$06e0a350$1602a8c0@warpcore>
	<B2DD87D3-D7F7-46EA-9406-382E6EBEB206@themactionfaction.com>
	<513501c80915$529fd9b0$1602a8c0@warpcore>
Subject: Re: Apache2 PostgreSQL http authentication
Date: Sun, 7 Oct 2007 16:28:55 -0400
Organization: Green Visor, Inc.
Message-ID: <518a01c80920$af0fa260$1602a8c0@warpcore>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
In-Reply-To: <513501c80915$529fd9b0$1602a8c0@warpcore>
Thread-Index: AcgI+jaLKG6kmQLyQF+3o/QWtBqaiwAGv3LAAAKfIkA=

Not so trivial for me as it turns out.  

Once I got the apxs command ironed out, I still could not compile it as I am
missing all the headers in the blastwave package:  apr.h apr_hooks.h
apr_strings.h httpd.h and so on.  Compilation aborted on me.

I hope I am not looking at rebuilding from source downloads just to get an
authentication working with postgres.

Certainly SOMEONE is doing http authentication under Solaris.

   Jeff


-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Jeffrey Brower
Sent: Sunday, October 07, 2007 3:08 PM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Apache2 PostgreSQL http authentication

Thanks for the reply!  I have used this in the past on Linux systems with
Apache 1  - but I had no idea if the Apache2 version would compile under
Solaris (let alone the Solaris X86 version) and run dependably.  I sent
Giuseppe an email and asked him, but I've gotten no reply.  It looks like it
had been a while since his system was updated (the version for apache2 was
last updated in January of 2006) but that could easily be a testament to its
solid performance since then.

Thank you for letting me know that someone is actually using it under
Solaris 10 X86 and that it will work dependably.  I have heard tale of
failures using the apache supplied module so this makes me happy.

I will post my results here.

Thanks again!

   Jeff 

   
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of A.M.
Sent: Sunday, October 07, 2007 11:20 AM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Apache2 PostgreSQL http authentication


On Oct 7, 2007, at 9:14 , Jeffrey Brower wrote:

> Greetings All,
>
> I have to authenticate against an existing (constantly modified) 
> PostgreSQL database  under Solaris 10 (X86).  While my PHP scripts are 
> an obvious no-brainer, the rest of the contents need to be protected 
> as well (images,
> etc) so the http authentication is required.  I am using the blastwave
> Apache2 and PostgreSQL packages.

I found it trivial to install mod_auth_pgsql.
http://www.giuseppetanzilli.it/mod_auth_pgsql/

As far as performance, only your testing will tell if it is sufficient. In
my setup, the authentication overhead is the least of my worries.

Cheers,
M

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq