From: | "Jeffrey Brower" <Jeff(at)PointHere(dot)net> |
---|---|
To: | <Jeff(at)PointHere(dot)net>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Apache2 PostgreSQL http authentication |
Date: | 2007-10-07 20:28:55 |
Message-ID: | 518a01c80920$af0fa260$1602a8c0@warpcore |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Jeffrey Brower
Sent: Sunday, October 07, 2007 3:08 PM
To: pgsql-performance(at)postgresql(dot)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(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of A.M.
Sent: Sunday, October 07, 2007 11:20 AM
To: pgsql-performance(at)postgresql(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 2007-10-07 20:44:57 | Re: Apache2 PostgreSQL http authentication |
Previous Message | Jeffrey Brower | 2007-10-07 19:07:36 | Re: Apache2 PostgreSQL http authentication |