Bug #75801 for DBIx-Class-Migration: problems with code in tutorial

Thu Mar 15 17:18:11 2012 fs5 [...] sanger.ac.uk - Ticket created

Subject:	problems with code in tutorial
Date:	Thu, 15 Mar 2012 21:17:59 +0000
To:	bug-DBIx-Class-Migration [...] rt.cpan.org
From:	Frank Schwach <fs5 [...] sanger.ac.uk>

installed version of DBIx::Class::Migration: 0.017 perl version 5.8.8 I'm following along with your tutorial and found the following problem: in DBIx::Class::Migration::Tutorial::FirstMigration the command dbic-migration version --schema_class MusicBase::Schema -Ilib doesn't work. Error output: Attribute (dsn) does not pass the type constraint because: Validation failed for 'Str' with value undef at constructor DBIx::Class::Migration::Script::new (defined at /software/team131/lib/perl5/DBIx/Class/Migration/Script.pm line 201) line 66 DBIx::Class::Migration::Script::new('DBIx::Class::Migration::Script', 'ARGV', 'ARRAY(0x156a060)', 'extra_argv', 'ARRAY(0x19921c0)', 'usage', 'Getopt::Long::Descriptive::Usage=HASH(0x1783970)', 'schema_class', 'MusicBase::Schema', 'includes', 'ARRAY(0x156a000)') called at /software/team131/lib/perl5/MooseX/Getopt/Basic.pm line 96 MooseX::Getopt::Basic::new_with_options('DBIx::Class::Migration::Script') called at /software/team131/lib/perl5/DBIx/Class/Migration/Script.pm line 192 DBIx::Class::Migration::Script::run_with_options('DBIx::Class::Migration::Script') called at /software/team131/bin/dbic-migration line 4 You have to supply some string value for --dsn to get the output you gave in the tutotial. Likewise, I had to supply a dsn to connect to a local sqlite db and get the status and set up the db like this: dbic-migration --schema_class MusicBase::Schema -Ilib --dsn "dbi:SQLite:dbname=share/musicbase-schema.db" status without that, the same error (undefined dsn) was thrown. Thanks for looking into this and thanks for providing this module! Frank -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE.

Fri Mar 16 08:31:48 2012 jjnapiork [...] cpan.org - Correspondence added

On Thu Mar 15 17:18:11 2012, fs5@sanger.ac.uk wrote: Show quoted text

> installed version of DBIx::Class::Migration: 0.017 > perl version 5.8.8 > > I'm following along with your tutorial and found the following > problem: > in DBIx::Class::Migration::Tutorial::FirstMigration > > the command > > dbic-migration version --schema_class MusicBase::Schema -Ilib > > doesn't work. Error output: > > Attribute (dsn) does not pass the type constraint because: Validation > failed for 'Str' with value undef at constructor > DBIx::Class::Migration::Script::new (defined at > /software/team131/lib/perl5/DBIx/Class/Migration/Script.pm line 201) > line 66 > > DBIx::Class::Migration::Script::new('DBIx::Class::Migration::Script', > 'ARGV', 'ARRAY(0x156a060)', 'extra_argv', 'ARRAY(0x19921c0)', 'usage', > 'Getopt::Long::Descriptive::Usage=HASH(0x1783970)', 'schema_class', > 'MusicBase::Schema', 'includes', 'ARRAY(0x156a000)') called at > /software/team131/lib/perl5/MooseX/Getopt/Basic.pm line 96 > > MooseX::Getopt::Basic::new_with_options('DBIx::Class::Migration::Script') > called > at /software/team131/lib/perl5/DBIx/Class/Migration/Script.pm line 192 > > DBIx::Class::Migration::Script::run_with_options('DBIx::Class::Migration::Script') > called at /software/team131/bin/dbic-migration line 4 > > > You have to supply some string value for --dsn to get the output you > gave in the tutotial. > > Likewise, I had to supply a dsn to connect to a local sqlite db and > get > the status and set up the db like this: > > dbic-migration --schema_class MusicBase::Schema -Ilib --dsn > "dbi:SQLite:dbname=share/musicbase-schema.db" status > > without that, the same error (undefined dsn) was thrown. > > Thanks for looking into this and thanks for providing this module! > > Frank > > >

Frank, I'm wondering if there is some dependency that needs updating somewhere in the dependency list. In my Makefile.PL I don't specify a lot of minimum version numbers except in the cases where I know I need a particular minimum. What version of Moose are you on? In theory if you fail to supple the connect string that is the signal that we are using the sandbox. So it might be something in the code that does that detection. perl -e 'use Moose; warn $Moose::VERSION' or similar. I will also install Perl 5.8.8 and give it a go. Thanks for the report! John Show quoted text

Fri Mar 16 08:31:48 2012 The RT System itself - Status changed from 'new' to 'open'

Fri Mar 16 09:04:40 2012 fs5 [...] sanger.ac.uk - Correspondence added

Subject:	Re: [rt.cpan.org #75801] problems with code in tutorial
Date:	Fri, 16 Mar 2012 13:04:18 +0000
To:	bug-DBIx-Class-Migration [...] rt.cpan.org
From:	Frank Schwach <fs5 [...] sanger.ac.uk>

Hi John, my Moose version is 2.0401 Thanks for looking into this! Frank On 16/03/12 12:31, John Napiorkowski via RT wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=75801> > > On Thu Mar 15 17:18:11 2012, fs5@sanger.ac.uk wrote:

>> installed version of DBIx::Class::Migration: 0.017 >> perl version 5.8.8 >> >> I'm following along with your tutorial and found the following >> problem: >> in DBIx::Class::Migration::Tutorial::FirstMigration >> >> the command >> >> dbic-migration version --schema_class MusicBase::Schema -Ilib >> >> doesn't work. Error output: >> >> Attribute (dsn) does not pass the type constraint because: Validation >> failed for 'Str' with value undef at constructor >> DBIx::Class::Migration::Script::new (defined at >> /software/team131/lib/perl5/DBIx/Class/Migration/Script.pm line 201) >> line 66 >> >> DBIx::Class::Migration::Script::new('DBIx::Class::Migration::Script', >> 'ARGV', 'ARRAY(0x156a060)', 'extra_argv', 'ARRAY(0x19921c0)', 'usage', >> 'Getopt::Long::Descriptive::Usage=HASH(0x1783970)', 'schema_class', >> 'MusicBase::Schema', 'includes', 'ARRAY(0x156a000)') called at >> /software/team131/lib/perl5/MooseX/Getopt/Basic.pm line 96 >> >> MooseX::Getopt::Basic::new_with_options('DBIx::Class::Migration::Script') >> called >> at /software/team131/lib/perl5/DBIx/Class/Migration/Script.pm line 192 >> >> DBIx::Class::Migration::Script::run_with_options('DBIx::Class::Migration::Script') >> called at /software/team131/bin/dbic-migration line 4 >> >> >> You have to supply some string value for --dsn to get the output you >> gave in the tutotial. >> >> Likewise, I had to supply a dsn to connect to a local sqlite db and >> get >> the status and set up the db like this: >> >> dbic-migration --schema_class MusicBase::Schema -Ilib --dsn >> "dbi:SQLite:dbname=share/musicbase-schema.db" status >> >> without that, the same error (undefined dsn) was thrown. >> >> Thanks for looking into this and thanks for providing this module! >> >> Frank >> >> >>

> Frank, > > I'm wondering if there is some dependency that needs updating somewhere in the dependency > list. In my Makefile.PL I don't specify a lot of minimum version numbers except in the cases > where I know I need a particular minimum. What version of Moose are you on? > > In theory if you fail to supple the connect string that is the signal that we are using the > sandbox. So it might be something in the code that does that detection. > > perl -e 'use Moose; warn $Moose::VERSION' > > or similar. > > I will also install Perl 5.8.8 and give it a go. > > Thanks for the report! > > John > > > >

-- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE.

Thu Mar 29 10:20:47 2012 jjnapiork [...] cpan.org - Correspondence added

Frank, I upped the version requirements in the newest versions and wondering if you have bit of time to check if that helped? Usually I try to not specify too many hard version requirements since I don't want to force people to install so much, but I figure there's got to be bugs floating around. If you still have it I wonder if I could ask you to consider upgrading each dependency in the list (there's not so many) and seeing if anything fixes the problem. Is a bit of a bugger since I can't replicate it, and I tend to build a clean local-lib for each project and of course that means I usually have the latest everything. The thing that is strange is if you look at the code you can see 'dsn' is not required and would only get a value via MooseX::GetOpt or MooseX::Attribute::ENV, and I did notice some weird compatibility issues with MXA:ENV and MX:Getopt so it is possible if you have older versions of either / or that could be it. I do specify the newest version of MXA:ENV but I don't specify a lower limit on MX:Getopt, so that might be something to try upgrading and see if it solves it. If so let me know and I will up the required lower limited in my Makefile.PL Thanks if you have time to try any of this! John On Fri Mar 16 09:04:40 2012, fs5@sanger.ac.uk wrote: Show quoted text

> Hi John, > > my Moose version is 2.0401 > > Thanks for looking into this! > > Frank > > > > On 16/03/12 12:31, John Napiorkowski via RT wrote:

> > <URL: https://rt.cpan.org/Ticket/Display.html?id=75801> > > > > On Thu Mar 15 17:18:11 2012, fs5@sanger.ac.uk wrote:

> >> installed version of DBIx::Class::Migration: 0.017 > >> perl version 5.8.8 > >> > >> I'm following along with your tutorial and found the following > >> problem: > >> in DBIx::Class::Migration::Tutorial::FirstMigration > >> > >> the command > >> > >> dbic-migration version --schema_class MusicBase::Schema -Ilib > >> > >> doesn't work. Error output: > >> > >> Attribute (dsn) does not pass the type constraint because:

> Validation

> >> failed for 'Str' with value undef at constructor > >> DBIx::Class::Migration::Script::new (defined at > >> /software/team131/lib/perl5/DBIx/Class/Migration/Script.pm line

> 201)

> >> line 66 > >> > >>

> DBIx::Class::Migration::Script::new('DBIx::Class::Migration::Script',

> >> 'ARGV', 'ARRAY(0x156a060)', 'extra_argv', 'ARRAY(0x19921c0)',

> 'usage',

> >> 'Getopt::Long::Descriptive::Usage=HASH(0x1783970)', 'schema_class', > >> 'MusicBase::Schema', 'includes', 'ARRAY(0x156a000)') called at > >> /software/team131/lib/perl5/MooseX/Getopt/Basic.pm line 96 > >> > >>

> MooseX::Getopt::Basic::new_with_options('DBIx::Class::Migration::Script')

> >> called > >> at /software/team131/lib/perl5/DBIx/Class/Migration/Script.pm line

> 192

> >> > >>

> DBIx::Class::Migration::Script::run_with_options('DBIx::Class::Migration::Script')

> >> called at /software/team131/bin/dbic-migration line 4 > >> > >> > >> You have to supply some string value for --dsn to get the output

> you

> >> gave in the tutotial. > >> > >> Likewise, I had to supply a dsn to connect to a local sqlite db and > >> get > >> the status and set up the db like this: > >> > >> dbic-migration --schema_class MusicBase::Schema -Ilib --dsn > >> "dbi:SQLite:dbname=share/musicbase-schema.db" status > >> > >> without that, the same error (undefined dsn) was thrown. > >> > >> Thanks for looking into this and thanks for providing this module! > >> > >> Frank > >> > >> > >>

> > Frank, > > > > I'm wondering if there is some dependency that needs updating

> somewhere in the dependency

> > list. In my Makefile.PL I don't specify a lot of minimum version

> numbers except in the cases

> > where I know I need a particular minimum. What version of Moose are

> you on?

> > > > In theory if you fail to supple the connect string that is the

> signal that we are using the

> > sandbox. So it might be something in the code that does that

> detection.

> > > > perl -e 'use Moose; warn $Moose::VERSION' > > > > or similar. > > > > I will also install Perl 5.8.8 and give it a go. > > > > Thanks for the report! > > > > John > > > > > > > >

> >

Thu Mar 29 10:20:49 2012 jjnapiork [...] cpan.org - Given to JJNAPIORK

Wed Apr 04 09:52:28 2012 fs5 [...] sanger.ac.uk - Correspondence added

Subject:	Re: [rt.cpan.org #75801] problems with code in tutorial
Date:	Wed, 04 Apr 2012 14:52:16 +0100
To:	bug-DBIx-Class-Migration [...] rt.cpan.org
From:	Frank Schwach <fs5 [...] sanger.ac.uk>

Hi John, I'm sorry - it seems that I forgot to answer your email! Thanks a lot for looking into this problem. It does work for me now as advertised (without needing to specify the dsn) but I'm afraid I had already updated everything before I had your email, so I can't tell you which dependency (version) was causing the problem. I guess it must be something with MXA::ENV or MX::Getopt as you say but I can't really check anymore now. Sorry. Cheers, Frank -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE.

Thu Aug 02 10:49:37 2012 jjnapiork [...] cpan.org - Correspondence added

I guess I need to see if I can figure out what needs to be marked higher in the dist.ini, I'll just up a few things that I think are likely issues for now thanks!

Thu Aug 02 10:49:37 2012 jjnapiork [...] cpan.org - Status changed from 'open' to 'resolved'

Bug #75801 for DBIx-Class-Migration: problems with code in tutorial

Preferred bug tracker