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] reconnecting the DB model using a different DB account

2009-03-11 Thread Karl Forner
On Wed, Mar 11, 2009 at 5:03 PM, Tomas Doran wrote: > Karl Forner wrote: > >> The problem is that I get error messages >> [error] DBIx::Class::Storage::DBI::ensure_connected(): DBI Connection >> failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH

[Catalyst] reconnecting the DB model using a different DB account

2009-03-10 Thread Karl Forner
Hi all, I'm trying to use DB authentication and afterwards using the DB user account for subsequent DB queries. To do so, in the Root::auto method, if the DB model is already connected with another DB account, I disconnect it and try to reconnect it with the new user and password. I disconnect as

[Catalyst] Re: loading data types from Oracle DB with DBIx::Class::Schema::Loader

2009-02-11 Thread Karl Forner
I believe I fixed the problem (cf my post "bug found in and tentatively fixed in DBIx::Class::Schema::Loader::DBI::Oracle::_tables_list" in the dbix mailing list"). Here's a copy : > We had a problem because DBIx::Class::Schema::Loader did not get the > column_info for our Oracle database : no da

[Catalyst] bug? in t/view_TT.t

2009-02-09 Thread Karl Forner
Hello, I am using catalyst on ubuntu with perl 5.8.8. The script t/view_TT.t generated by default fails: *%prove -l lib t/view_TT.t* t/view_TT1/1 # Failed test 'use My::App::View::TT;' # at t/view_TT.t line 5. # Tried to use 'My::App::View::TT'. # Error: Can't locate object metho

[Catalyst] loading data types from Oracle DB with DBIx::Class::Schema::Loader

2009-02-06 Thread karl . forner
Hello, We are using catalyst with an Oracle database. We are using DBIx::Class::Schema::Loader to create the DBIx::Class interface, with the following command; ./myapp_create.pl model DB DBIC::Schema MyApp::Schema create=static 'dbi:Oracle:sid=BDBDEV;host=ch7ux002.x;port=1521' 'user' 'user'