Hi Luka,

Perhaps I miss-read the info on 
http://search.cpan.org/~janus/Catalyst-Authentication-Store-DBI-0.01/lib/Catalyst/Authentication/Store/DBI.pm

But from what I can see it expects you to map specific fields in a table as 
well as have a user role table with specific data mapping?

[quote] __PACKAGE__->config->{'authentication'} = {
    'default_realm' => 'default',
    'realms' => {
      'default' => {
        'credential' => {
          'class'               => 'Password',
          'password_field'      => 'password',
          'password_type'       => 'hashed',
          'password_hash_type'  => 'SHA-1',
        },
        'store' => {
          'class'              => 'DBI',
          'user_table'         => 'login',
          'user_key'           => 'id',
          'user_name'          => 'name',
          'role_table'         => 'authority',
          'role_key'           => 'id',
          'role_name'          => 'name',
          'user_role_table'    => 'competence',
          'user_role_user_key' => 'login',
          'user_role_role_key' => 'authority',
        },
      },
    },
  };[/quote]

Have I read the above incorrectly?

I have a non-normalised DB , with an application that functions in a particular 
way, I deal with user roles and other such stuff in my own way and I cannot 
refactor to use catalyst without ensuring all sections of the system function 
the same along with the back end admin system, I can't rewrite both parts at 
the same time, this is a live app in production that works currently, I'm 
simply trying to learn Catalyst & MVC cuteness, not start from scratch.

>From what I can see using any of those authentication modules expects certain 
>data I don't have or use nor want.

Please correct  me if I'm reading the CPAN documentation incorrectly.

I want to refactor my app to be MVC using Catalyst without being forced to do 
any other than MVC cuteness and work the way I want to with the a database that 
already exists, I got the feeling Catalyst allows this unlike ROR or other MVC 
frameworks.

Again, have I got this wrong?

If to use Catalyst I have to have a normalised DB, use specific modules with 
data in a particular format, then I will just refactor our systems myself using 
my own modules and such, best to find this out now before I spend any more time 
on something that isn't suitable.

Thanks,

Craig.


-----Original Message-----
From: Lukas Thiemeier [mailto:spamcatc...@thiemeier.net]
Sent: 29 October 2012 16:42
To: catalyst@lists.scsys.co.uk
Subject: Re: [Catalyst] Unable to output anything in Root.pm -> 'auto'


Hey Craig,

I got it. You want to store your credentials in a database, but you don't want 
to use DBIx::Class?

What about Catalyst::Authentication::Storage::DBI?

If this doesn't help, you might me right. Maybe you have to write your own 
authentication module. In that case, consider making it a 
Catalyst::Authentication::Store module, and publish it on cpan. It might be 
useful for others, too...

By the way: Catalyst::Model::DBI is a ORM-less, raw DBI model for catalyst. So 
"... whenever I look at how it implements anything to do with DB access, it 
forces ORM upon you ..." is not correct. There are very few things which are 
really forced by catalyst. Using DBIx::Class is just considered "good 
practice". A lot of people use it, thats why it is used in most tutorials and 
examples.

Lukas



On 10/29/2012 05:09 PM, Craig Chant wrote:
> Yes, but I need to keep a backed DB up-to-date with current logins, where in 
> the system they are etc...
>
> So local server disk won't help in this situation.
>
> -----Original Message-----
> From: Denny [mailto:2...@denny.me]
> Sent: 29 October 2012 15:50
> To: The elegant MVC web framework
> Subject: RE: [Catalyst] Unable to output anything in Root.pm -> 'auto'
>
> On Mon, 2012-10-29 at 15:43 +0000, Craig Chant wrote:
>> "By the way, what do you need the session-id for? Catalyst handles sessions 
>> in a transparent way"
>>
>> To authenticate users, I don't want to store authentication in the hash and 
>> it seems the only other way to do this is via ORM, which I don't want to use 
>> either.
>>
>> I find catalyst whenever I look at how it implements anything to do with DB 
>> access, it forces ORM upon you, so I need to write my own authentication 
>> code don't I ?
>
> I'm pretty sure the default storage for session stuff is disk-based.
>
>
>
> _______________________________________________
> List: Catalyst@lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/ This Email and any attachments
> contain confidential information and is intended solely for the
> individual to whom it is addressed. If this Email has been
> misdirected, please notify the author as soon as possible. If you are
> not the intended recipient you must not disclose, distribute, copy,
> print or rely on any of the information contained, and all copies must
> be deleted immediately. Whilst we take reasonable steps to try to
> identify any software viruses, any attachments to this e-mail may
> nevertheless contain viruses, which our anti-virus software has failed
> to identify. You should therefore carry out your own anti-virus checks
> before opening any documents. HomeLoan Partnership will not accept any
> liability for damage caused by computer viruses emanating from any
> attachment or other document supplied with this e-mail. HomeLoan
> Partnership reserves the right to monitor and archive all e-mail
> communications through its network. No representative or employee of
> HomeLoan Partn
 ership ha
s the authority to enter into any contract on behalf of HomeLoan Partnership by 
email. HomeLoan Partnership is a trading name of H L Partnership Limited, 
registered in England and Wales with Registration Number 5011722. Registered 
office: 26-34 Old Street, London, EC1V 9QQ. H L Partnership Limited is 
authorised and regulated by the Financial Services Authority.
>
>
>
> _______________________________________________
> List: Catalyst@lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/


_______________________________________________
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/
This Email and any attachments contain confidential information and is intended 
solely for the individual to whom it is addressed. If this Email has been 
misdirected, please notify the author as soon as possible. If you are not the 
intended recipient you must not disclose, distribute, copy, print or rely on 
any of the information contained, and all copies must be deleted immediately. 
Whilst we take reasonable steps to try to identify any software viruses, any 
attachments to this e-mail may nevertheless contain viruses, which our 
anti-virus software has failed to identify. You should therefore carry out your 
own anti-virus checks before opening any documents. HomeLoan Partnership will 
not accept any liability for damage caused by computer viruses emanating from 
any attachment or other document supplied with this e-mail. HomeLoan 
Partnership reserves the right to monitor and archive all e-mail communications 
through its network. No representative or employee of HomeLoan Partnership has 
the authority to enter into any contract on behalf of HomeLoan Partnership by 
email. HomeLoan Partnership is a trading name of H L Partnership Limited, 
registered in England and Wales with Registration Number 5011722. Registered 
office: 26-34 Old Street, London, EC1V 9QQ. H L Partnership Limited is 
authorised and regulated by the Financial Services Authority.

_______________________________________________
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/

Reply via email to