Re: [Catalyst] how to authenticate using database users

2009-03-23 Thread Tomas Doran
Adam Witney wrote: For general information, with a *lot* of help from mst on IRC, i have something working using a custom Catalyst::Authentication::Store::*. I will get it packaged up and submit it when i have written some docs for it Thats awesome :_) If you can get it somewhere in the Catal

Re: [Catalyst] how to authenticate using database users

2009-03-23 Thread Adam Witney
On 20 Mar 2009, at 07:42, Jonathan Rockway wrote: * On Thu, Mar 19 2009, Adam Witney wrote: Hi Bill, This is using PostgreSQL. The other apps are fat clients that can pull data from external sources, it was therefore necessary to have the security levels built into the database. Actually

Re: [Catalyst] how to authenticate using database users

2009-03-20 Thread Tomas Doran
Karl Forner wrote: 2) write a custom Authentication plugin, the your specific code is in _authenticate_against_SGDB package Serono::Gecko::Business::CredentialVerifier; use Catalyst::Plugin::Authentication::User::Hash; sub authenticate { my ( $self, $c, $realm, $authinfo ) = @_; You kn

Re: [Catalyst] how to authenticate using database users

2009-03-20 Thread Karl Forner
Hi, I have implemented such an authentication sheme. I'm rather new to catalyst so I do not pretend it si the best way. Anyway what I've done is : 1) add the session and authentication plugins to catalyst app: use Catalyst qw/... Authentication Session Session::Store::FastMmap Session:State::Coo

Re: [Catalyst] how to authenticate using database users

2009-03-20 Thread Karl Forner
> > > Actually, there is really no reason to rely on the database for this. I absolutely disagree. There's an authentication mechanism already implemented in SGBD so why on earth not use it. Moreover if you want to benefit for logging features of SGBD like Oracle, your users have to be logged us

Re: [Catalyst] how to authenticate using database users

2009-03-20 Thread Jonathan Rockway
* On Thu, Mar 19 2009, Adam Witney wrote: > Hi Bill, > > This is using PostgreSQL. The other apps are fat clients that can pull > data from external sources, it was therefore necessary to have the > security levels built into the database. Actually, there is really no reason to rely on the databas

Re: [Catalyst] how to authenticate using database users

2009-03-19 Thread Adam Witney
On 19 Mar 2009, at 01:34, bill hauck wrote: --- On Wed, 3/18/09, Adam Witney wrote: From: Adam Witney Subject: Re: [Catalyst] how to authenticate using database users To: "The elegant MVC web framework" Date: Wednesday, March 18, 2009, 4:33 PM On 18 Mar 2009, at 16:24, Micha

Re: [Catalyst] how to authenticate using database users

2009-03-18 Thread bill hauck
--- On Wed, 3/18/09, Adam Witney wrote: > From: Adam Witney > Subject: Re: [Catalyst] how to authenticate using database users > To: "The elegant MVC web framework" > Date: Wednesday, March 18, 2009, 4:33 PM > On 18 Mar 2009, at 16:24, Michael Reddick wrote: >

Re: [Catalyst] how to authenticate using database users

2009-03-18 Thread Adam Witney
On 18 Mar 2009, at 16:24, Michael Reddick wrote: On Wed, Mar 18, 2009 at 10:51 AM, Adam Witney wrote: Hi, Our database uses actual database users rather than a table containing usernames and password. Why are you doing that? The database has a row level security model implemente

Re: [Catalyst] how to authenticate using database users

2009-03-18 Thread Michael Reddick
On Wed, Mar 18, 2009 at 10:51 AM, Adam Witney wrote: > > Hi, > > Our database uses actual database users rather than a table containing > usernames and password. Why are you doing that? -michael ___ List: Catalyst@lists.scsys.co.uk Listinfo: http://

[Catalyst] how to authenticate using database users

2009-03-18 Thread Adam Witney
Hi, Our database uses actual database users rather than a table containing usernames and password. How would I authenticate against the database itself? The examples I have come across in the Tutorial and various Catalyst::Authentication::* modules all seem to require the presence of a t