Re: [Catalyst] DBIC connecting to remote MySQL

2010-05-25 Thread Dan
On Sun, 2010-05-23 at 21:13 +0700, Ben van Staveren wrote: > >> script/easysaver_create.pl model ESDB DBIC::Schema EasySaver::Schema > >> dbi:mysql:EasySaver:archeopteryx 'user' 'pass' '{ AutoCommit => 1 }' > >> > > > > We're getting closer now. Now I get an error that EasySaver::Schema > >

Re: [Catalyst] DBIC connecting to remote MySQL

2010-05-23 Thread Ben van Staveren
script/easysaver_create.pl model ESDB DBIC::Schema EasySaver::Schema dbi:mysql:EasySaver:archeopteryx 'user' 'pass' '{ AutoCommit => 1 }' We're getting closer now. Now I get an error that EasySaver::Schema isn't found ... and the above didn't create it :( My bad! Forgot one parameter

Re: [Catalyst] DBIC connecting to remote MySQL

2010-05-23 Thread Dan
Hi Ben. Thanks for the response. On Sun, 2010-05-23 at 20:44 +0700, Ben van Staveren wrote: > > d...@sabayon:~/src/EasySaver$ script/easysaver_create.pl model ESDB > > DBIC::Schema EasySaver dbi:mysql:EasySaver:archeopteryx 'username' > > 'password' '{ AutoCommit => 1 }' > > > > > The above wo

Re: [Catalyst] DBIC connecting to remote MySQL

2010-05-23 Thread Ben van Staveren
d...@sabayon:~/src/EasySaver$ script/easysaver_create.pl model ESDB DBIC::Schema EasySaver dbi:mysql:EasySaver:archeopteryx 'username' 'password' '{ AutoCommit => 1 }' The above won't work because you tell it your schema is 'EasySaver.pm' - which is your main app file, so it's never created

Re: [Catalyst] DBIC connecting to remote MySQL

2010-05-23 Thread Dan
Hi Robert. Thanks for the response :) Comments inline. On Sun, 2010-05-23 at 07:50 -0500, Robert Wohlfarth wrote: > On Sun, May 23, 2010 at 6:38 AM, Dan > wrote: > __PACKAGE__->config( >schema_class => 'EasySaver', > >connect_info => { >ds

Re: [Catalyst] DBIC connecting to remote MySQL

2010-05-23 Thread Dan
Hi Will. Thanks for the response. Interesting suggestion :) I have the perl debugger with a passion :) Clunky damned thing. I'm using Eclipse with the EPIC plugin, and ( at work ) Komodo. Anyway, I stepped through a bit of code ( quite a bit ) before I got bored with this and tried something else.

Re: [Catalyst] DBIC connecting to remote MySQL

2010-05-23 Thread Robert Wohlfarth
On Sun, May 23, 2010 at 6:38 AM, Dan wrote: > __PACKAGE__->config( >schema_class => 'EasySaver', > >connect_info => { >dsn => 'dbi:mysql:dbname=EasySaver;host=archeopteryx', >user => 'username', >password => 'password', >AutoCommit => q{1}, >} > ); > >

Re: [Catalyst] DBIC connecting to remote MySQL

2010-05-23 Thread w...@serensoft.com
Well I'm kinda new to Catalyst and the MVC world myself, and I would have tried exactly what you've tried. So my small-time suggestion to you is to try it with perl debugging on, and then use this to drop into single-step mode somewhere prescient: $DB::single = 1; Then you $ perl -d script/easysa

[Catalyst] DBIC connecting to remote MySQL

2010-05-23 Thread Dan
Greetings. I realise that this is slightly off-topic ... I tried to sign up to the DBIC mailing list, but haven't received anything yet ( and have checked spam filter ). I'm trying to teach myself Catalyst. At the same time, I'm trying to get my head around a whole heap of other things, eg MVC (