I should point out that there are actually two PostgreSQL Apache 
authentication modules, mod_auth_pg and mod_auth_pgsql. It's mod_auth_pgsql 
that allows for the where clause functionality that Jeff mentioned.

I have used both modules and prefer mod_auth_pg even though it seems to 
have less 'features'.

They way I handle logouts is the same way I handle logouts for most of 
my .htaccess enabled apps. My logout link sends a param called 'logout' 
with the value of the current username ( $ENV{'REMOTE_USER'} ). The first 
thing my app does is check for this parameter (logout) and compares it's 
value with $ENV{'REMOTE_USER'}. If they match, I send an HTTP WWW-
Authenticate header, followed by the the html for a 'You have logged out 
page'. This has the effect of popping up a new authentication window, at 
which they can either enter a new username or press cancel to get the 'you 
have logged out page'. The only issue i have with this method is that you 
can't immediately log back in with the same username. So I provide a link 
on my 'you have logged out' page to a 'fresh' page (passing no logout 
parameter).

Christopher S. Hyne
http://www.chyne.com/

On Tue, 30 Apr 2002 12:05:24 -0300 (ADT), Jeff MacDonald 
<[EMAIL PROTECTED]> wrote :

> Hi,
> 
> I use it just to "protect" certain parts of my webserver, but not
> for actual web applications.
> 
> Mod pg auth allows you to setup a where clause for authentication.
> so perhaps set a tag in the db called "logged out", and this only
> get's set to true when they login and enter the first screen of your
> application. all other screens would just check to see if it's true,
> but not bother setting it.
> 
> something like that might work.
> 
> jeff
> 
> On Tue, 30 Apr 2002, Mark Stosberg wrote:
> 
> >
> > Hello,
> >
> > Jesse has written on a number occassions about the merits of handling
> > authentication for web applications at a level seperate from the
> > application logic. While this system appealed to me, I could see how it
> > do it without using mod_perl. Today I ran across another possible
> > solution, The Apache mod_auth_pg module. It allows you to tie .htaccess
> > files into a Postgres database to handle user authentication.
> >
> > More info:
> > http://authpg.sourceforge.net/
> >
> > Has anyone tried this? How did it go? When you are using this kind of
> > system, how do you log someone out?
> >
> > Thanks,
> >
> >    -mark
> >
> > http://mark.stosberg.com/
> >
> >
> > ---------------------------------------------------------------------
> > Web Archive:  http://www.mail-archive.com/cgiapp@lists.vm.com/
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> 
> ------
> Jeff MacDonald - Tsunamicreek IT Consulting
> http://www.tsunamicreek.com
> +1 902 542 2519
> [EMAIL PROTECTED]
> 
> 
> ---------------------------------------------------------------------
> Web Archive:  http://www.mail-archive.com/cgiapp@lists.vm.com/
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 
> 

---------------------------------------------------------------------
Web Archive:  http://www.mail-archive.com/cgiapp@lists.vm.com/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to