Bug #27393 for WWW-Myspace-Data: Database integration in svn 341

Sun Jun 03 00:18:54 2007 hughesjames [...] bellsouth.net - Ticket created

Subject:	Database integration in svn 341
Date:	Sun, 03 Jun 2007 00:18:32 -0400
To:	bug-www-myspace [...] rt.cpan.org
From:	James Hughes <hughesjames [...] bellsouth.net>

I have tried to get this working for nearly two days. I think it's my setup with DBI::Loader. I use DBI with PostgreSQL and it works great, they don't use DBI::Loader though. Here is what I get with Pg and mysql... With PgSQL... Couldn't require loader class "Class::DBI::Loader::Pg", "Can't locate Class/DBI/Pg.pm in @INC (@INC contains: ../lib /usr/lib/perl5/5.8.7/i486-linux /usr/lib/perl5/5.8.7 /usr/lib/perl5/site_perl/5.8.7/i486-linux /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl . ../lib) at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader/Pg.pm line 9, <STDIN> line 2. Compilation failed in require at (eval 791) line 2, <STDIN> line 2. BEGIN failed--compilation aborted at (eval 791) line 2, <STDIN> line 2. " at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader.pm line 81, <STDIN> line 2. With mysql... Couldn't require loader class "Class::DBI::Loader::mysql", "Can't locate Class/DBI/mysql.pm in @INC (@INC contains: ../lib /usr/lib/perl5/5.8.7/i486-linux /usr/lib/perl5/5.8.7 /usr/lib/perl5/site_perl/5.8.7/i486-linux /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl . ../lib) at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader/mysql.pm line 8, <STDIN> line 2. Compilation failed in require at (eval 791) line 2, <STDIN> line 2. BEGIN failed--compilation aborted at (eval 791) line 2, <STDIN> line 2. " at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader.pm line 81, <STDIN> line 2. Did you do anything unusual to the DBI and DBI::Loader to get yours working? I am considering building some scripts to interact with PgSQL if I can't get this working. I'd rather contribute to what you guys are working on though. Thanks, ~james -- Check out "The BlueWall Groove" @ Myspace http://www.myspace.com/bluewallgroove

Sun Jun 03 01:46:52 2007 olaf [...] wundersolutions.com - Correspondence added

Subject:	Re: [rt.cpan.org #27393] Database integration in svn 341
Date:	Sun, 3 Jun 2007 01:46:29 -0400
To:	Mike via RT Allred <bug-WWW-Myspace [...] rt.cpan.org>
From:	Olaf Alders <olaf [...] wundersolutions.com>

On 3-Jun-07, at 12:18 AM, James Hughes via RT wrote: Show quoted text

> > Sun Jun 03 00:18:54 2007: Request 27393 was acted upon. > Transaction: Ticket created by hughesjames@bellsouth.net > Queue: WWW-Myspace > Subject: Database integration in svn 341 > Broken in: (no value) > Severity: (no value) > Owner: Nobody > Requestors: hughesjames@bellsouth.net > Status: new > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=27393 > > > > I have tried to get this working for nearly two days. I think it's my > setup with DBI::Loader. I use DBI with PostgreSQL and it works great, > they don't use DBI::Loader though. Here is what I get with Pg and > mysql... > > With PgSQL... > Couldn't require loader class "Class::DBI::Loader::Pg", "Can't locate > Class/DBI/Pg.pm in @INC (@INC contains: ../lib > /usr/lib/perl5/5.8.7/i486-linux /usr/lib/perl5/5.8.7 > /usr/lib/perl5/site_perl/5.8.7/i486-linux /usr/lib/perl5/site_perl/ > 5.8.7 > /usr/lib/perl5/site_perl . ../lib) at > /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader/Pg.pm line 9, <STDIN> > line 2. > Compilation failed in require at (eval 791) line 2, <STDIN> line 2. > BEGIN failed--compilation aborted at (eval 791) line 2, <STDIN> > line 2. > " at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader.pm line 81, > <STDIN> > line 2. > > > With mysql... > Couldn't require loader class "Class::DBI::Loader::mysql", "Can't > locate > Class/DBI/mysql.pm in @INC (@INC contains: ../lib > /usr/lib/perl5/5.8.7/i486-linux /usr/lib/perl5/5.8.7 > /usr/lib/perl5/site_perl/5.8.7/i486-linux /usr/lib/perl5/site_perl/ > 5.8.7 > /usr/lib/perl5/site_perl . ../lib) at > /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader/mysql.pm line 8, > <STDIN> > line 2. > Compilation failed in require at (eval 791) line 2, <STDIN> line 2. > BEGIN failed--compilation aborted at (eval 791) line 2, <STDIN> > line 2. > " at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader.pm line 81, > <STDIN> > line 2. > > > > Did you do anything unusual to the DBI and DBI::Loader to get yours > working? I am considering building some scripts to interact with PgSQL > if I can't get this working. I'd rather contribute to what you guys > are > working on though. > > Thanks, > > ~james

Hi James, I think you can get around this bug by adding a: use Class::DBI; to the top of your script. If this doesn't work, could you send me a sample of the script you're getting this error with? I haven't tried it with PgSQL, but I'm very interested in getting that to work. I'm happy to take contributions, so if we can get this working for you, I think that would be very helpful. All the best, Olaf -- Olaf Alders olaf@wundersolutions.com http://www.wundersolutions.com

Sun Jun 03 01:46:54 2007 The RT System itself - Status changed from 'new' to 'open'

Thu Jun 07 00:51:32 2007 hughesjames [...] bellsouth.net - Correspondence added

Subject:	Re: [rt.cpan.org #27393] Database integration in svn 341
Date:	Thu, 07 Jun 2007 00:51:21 -0400
To:	bug-WWW-Myspace [...] rt.cpan.org
From:	James Hughes <hughesjames [...] bellsouth.net>

Olaf Alders via RT wrote: Show quoted text

> <URL: http://rt.cpan.org/Ticket/Display.html?id=27393 > > > > > Hi James, > > I think you can get around this bug by adding a: > > use Class::DBI; > > to the top of your script. If this doesn't work, could you send me a > sample of the script you're getting this error with? I haven't tried > it with PgSQL, but I'm very interested in getting that to work. I'm > happy to take contributions, so if we can get this working for you, I > think that would be very helpful. > > All the best, > > Olaf > -- > Olaf Alders > olaf@wundersolutions.com > > http://www.wundersolutions.com > > >

SVN 351 (BTW logins were broken in the prior version until I updated to this. Working again now) Still getting the errors. I think this is just the sample_scripts/get_friends with stuff to open a database connection. I was working towards saving all the friends id and info into the database, but couldn't get the connection due to the errors... Couldn't require loader class "Class::DBI::Loader::mysql", "Can't locate Class/DBI/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.7/i486-linux /usr/lib/perl5/5.8.7 /usr/lib/perl5/site_perl/5.8.7/i486-linux /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl .) at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader/mysql.pm line 8, <STDIN> line 2. Compilation failed in require at (eval 791) line 2, <STDIN> line 2. BEGIN failed--compilation aborted at (eval 791) line 2, <STDIN> line 2. " at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader.pm line 81, <STDIN> line 2. #!/usr/bin/perl -w #######!/usr/bin/perl -w -I../lib ## ## Hacking the database interface ## ## use Class::DBI; use WWW::Myspace; use WWW::Myspace::Data; # my $myspace = WWW::Myspace->new(autologin => 1); my $myspace = WWW::Myspace->new(); my %db = ( dsn => 'DBI:mysql:database=friends;host=ascent', user => 'myspace', password => 'bwrox2k', ); my $data = WWW::Myspace::Data->new( $myspace, { db => \%db } ); # setup connection my $loader = $data->loader(); # store MySpace login info my $username='hughesjames@bellsouth.net'; my $password='bwrox2k'; my $account_id = $data->set_account( $username, $password ); $data->update_all_friends(); Thanks, James -- Check out "The BlueWall Groove" @ Myspace http://www.myspace.com/bluewallgroove

Fri Jun 08 12:45:43 2007 olaf [...] wundersolutions.com - Correspondence added

On Thu Jun 07 00:51:32 2007, hughesjames@bellsouth.net wrote: Show quoted text

> Olaf Alders via RT wrote:

> > <URL: http://rt.cpan.org/Ticket/Display.html?id=27393 > > > > > > > > > Hi James, > > > > I think you can get around this bug by adding a: > > > > use Class::DBI; > > > > to the top of your script. If this doesn't work, could you send me a > > sample of the script you're getting this error with? I haven't tried > > it with PgSQL, but I'm very interested in getting that to work. I'm > > happy to take contributions, so if we can get this working for you, I > > think that would be very helpful. > > > > All the best, > > > > Olaf > > -- > > Olaf Alders > > olaf@wundersolutions.com > > > > http://www.wundersolutions.com > > > > > >

> SVN 351 (BTW logins were broken in the prior version until I updated to > this. Working again now) > > Still getting the errors. I think this is just the > sample_scripts/get_friends with stuff to open a database connection. I > was working towards saving all the friends id and info into the > database, but couldn't get the connection due to the errors... > > Couldn't require loader class "Class::DBI::Loader::mysql", "Can't locate > Class/DBI/mysql.pm in @INC (@INC contains: > /usr/lib/perl5/5.8.7/i486-linux /usr/lib/perl5/5.8.7 > /usr/lib/perl5/site_perl/5.8.7/i486-linux /usr/lib/perl5/site_perl/5.8.7 > /usr/lib/perl5/site_perl .) at > /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader/mysql.pm line 8, <STDIN> > line 2. > Compilation failed in require at (eval 791) line 2, <STDIN> line 2. > BEGIN failed--compilation aborted at (eval 791) line 2, <STDIN> line 2. > " at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader.pm line 81, <STDIN> > line 2. >

Hi James, Have verified that Class::DBI::mysql is installed? It it in your @INC path? Could you provide me with the full path to its location? By looking at your ticket, I see that your Myspace password has been exposed. If this password is genuine, I'd encourage you to change it at Myspace as soon as you can. All the best, Olaf

Mon Jun 11 16:02:32 2007 hughesjames [...] bellsouth.net - Correspondence added

Subject:	Re: [rt.cpan.org #27393] Database integration in svn 341
Date:	Mon, 11 Jun 2007 16:02:37 -0400
To:	bug-WWW-Myspace [...] rt.cpan.org
From:	James Hughes <hughesjames [...] bellsouth.net>

Olaf Alders via RT wrote: Show quoted text

> <URL: http://rt.cpan.org/Ticket/Display.html?id=27393 > > > On Thu Jun 07 00:51:32 2007, hughesjames@bellsouth.net wrote: >

>> Olaf Alders via RT wrote: >>

>>> <URL: http://rt.cpan.org/Ticket/Display.html?id=27393 > >>> >>> >>> >>> Hi James, >>> >>> I think you can get around this bug by adding a: >>> >>> use Class::DBI; >>> >>> to the top of your script. If this doesn't work, could you send me a >>> sample of the script you're getting this error with? I haven't tried >>> it with PgSQL, but I'm very interested in getting that to work. I'm >>> happy to take contributions, so if we can get this working for you, I >>> think that would be very helpful. >>> >>> All the best, >>> >>> Olaf >>> -- >>> Olaf Alders >>> olaf@wundersolutions.com >>> >>> http://www.wundersolutions.com >>> >>> >>> >>>

>> SVN 351 (BTW logins were broken in the prior version until I updated to >> this. Working again now) >> >> Still getting the errors. I think this is just the >> sample_scripts/get_friends with stuff to open a database connection. I >> was working towards saving all the friends id and info into the >> database, but couldn't get the connection due to the errors... >> >> Couldn't require loader class "Class::DBI::Loader::mysql", "Can't locate >> Class/DBI/mysql.pm in @INC (@INC contains: >> /usr/lib/perl5/5.8.7/i486-linux /usr/lib/perl5/5.8.7 >> /usr/lib/perl5/site_perl/5.8.7/i486-linux /usr/lib/perl5/site_perl/5.8.7 >> /usr/lib/perl5/site_perl .) at >> /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader/mysql.pm line 8, <STDIN> >> line 2. >> Compilation failed in require at (eval 791) line 2, <STDIN> line 2. >> BEGIN failed--compilation aborted at (eval 791) line 2, <STDIN> line 2. >> " at /usr/lib/perl5/site_perl/5.8.7/Class/DBI/Loader.pm line 81, <STDIN> >> line 2. >> >>

> > Hi James, > > Have verified that Class::DBI::mysql is installed? It it in your @INC > path? Could you provide me with the full path to its location? > >

I was missing Class::DBI::mysql, I was also missing DBD::mysql. I have been working on three systems, so I have now focused on one. I have everything installed now, but get another error message. So, I have given up on mysql and turned my attention toward PgSQL. The script works, mostly, without errors. At least I can move forward now :) So far, the biggest problem I had getting PgSQL to work is the database schema. I will be able to look at this more fairly soon. Show quoted text

> By looking at your ticket, I see that your Myspace password has been > exposed. If this password is genuine, I'd encourage you to change it at > Myspace as soon as you can. > >

Hah! I was so careful to omit it from the script output :) Show quoted text

> All the best, > > Olaf >

Thanks! ~james -- Check out "The BlueWall Groove" @Myspace http://www.myspace.com/bluewallgroove

Tue Jun 12 23:13:41 2007 olaf [...] wundersolutions.com - Correspondence added

Show quoted text

> > Hi James, > > > > Have verified that Class::DBI::mysql is installed? It it in your @INC > > path? Could you provide me with the full path to its location? > > > >

> I was missing Class::DBI::mysql, I was also missing DBD::mysql. I have > been working on three systems, so I have now focused on one. I have > everything installed now, but get another error message. So, I have > given up on mysql and turned my attention toward PgSQL. The script > works, mostly, without errors. At least I can move forward now :)

Hi James, Thanks for the feedback. I've now added some notes on modules that may need to be installed in addition to the WWW::Myspace modules. That's in the repository now. Show quoted text

> > So far, the biggest problem I had getting PgSQL to work is the database > schema. I will be able to look at this more fairly soon.

I've altered the schema in mysql.txt to be more generic. I'm not sure if this is enough to get it work in Postgres, but I'd appreciate any feedback you may have. If Postgres is very different, we can certainly add a "postgres.sql" file to the distribution. Thanks again for all of your feedback. All the best, Olaf

Tue Jun 12 23:29:05 2007 hughesjames [...] bellsouth.net - Correspondence added

Subject:	Re: [rt.cpan.org #27393] Database integration in svn 341
Date:	Tue, 12 Jun 2007 23:29:06 -0400
To:	bug-WWW-Myspace [...] rt.cpan.org
From:	James Hughes <hughesjames [...] bellsouth.net>

Olaf Alders via RT wrote: Show quoted text

> <URL: http://rt.cpan.org/Ticket/Display.html?id=27393 > > > >

>>> Hi James, >>> >>> Have verified that Class::DBI::mysql is installed? It it in your @INC >>> path? Could you provide me with the full path to its location? >>> >>> >>>

>> I was missing Class::DBI::mysql, I was also missing DBD::mysql. I have >> been working on three systems, so I have now focused on one. I have >> everything installed now, but get another error message. So, I have >> given up on mysql and turned my attention toward PgSQL. The script >> works, mostly, without errors. At least I can move forward now :) >>

> > Hi James, > > Thanks for the feedback. I've now added some notes on modules that may > need to be installed in addition to the WWW::Myspace modules. That's in > the repository now. > >

>> So far, the biggest problem I had getting PgSQL to work is the database >> schema. I will be able to look at this more fairly soon. >>

> > I've altered the schema in mysql.txt to be more generic. I'm not sure > if this is enough to get it work in Postgres, but I'd appreciate any > feedback you may have. If Postgres is very different, we can certainly > add a "postgres.sql" file to the distribution. > > Thanks again for all of your feedback. > > All the best, > > Olaf > > >

Hi Olaf, I will check out the new things ASAP. I would like to have both Postgresql and Mysql working, so this is great. From what I gather, Postgresql is more standardized that Mysql as far as the SQL implementation and Postgresql has some powerful features in the backend. I'm still finding my way around the modules and getting some ideas of things we can do. I'll update things here and let you know how it looks :) ~james -- Check out "The BlueWall Groove" @ Myspace http://www.myspace.com/bluewallgroove

Mon Jul 02 19:53:13 2007 GRANTG [...] cpan.org - Severity Unimportant added

Tue Oct 30 16:58:11 2007 olaf [...] wundersolutions.com - Correspondence added

Hi James, Did you have any luck with this at the end of the day? Best, Olaf On Tue Jun 12 23:29:05 2007, hughesjames@bellsouth.net wrote: Show quoted text

> Olaf Alders via RT wrote:

> > <URL: http://rt.cpan.org/Ticket/Display.html?id=27393 > > > > > > >

> >>> Hi James, > >>> > >>> Have verified that Class::DBI::mysql is installed? It it in your @INC > >>> path? Could you provide me with the full path to its location? > >>> > >>> > >>>

> >> I was missing Class::DBI::mysql, I was also missing DBD::mysql. I have > >> been working on three systems, so I have now focused on one. I have > >> everything installed now, but get another error message. So, I have > >> given up on mysql and turned my attention toward PgSQL. The script > >> works, mostly, without errors. At least I can move forward now :) > >>

> > > > Hi James, > > > > Thanks for the feedback. I've now added some notes on modules that may > > need to be installed in addition to the WWW::Myspace modules. That's in > > the repository now. > > > >

> >> So far, the biggest problem I had getting PgSQL to work is the

database Show quoted text

> >> schema. I will be able to look at this more fairly soon. > >>

> > > > I've altered the schema in mysql.txt to be more generic. I'm not sure > > if this is enough to get it work in Postgres, but I'd appreciate any > > feedback you may have. If Postgres is very different, we can certainly > > add a "postgres.sql" file to the distribution. > > > > Thanks again for all of your feedback. > > > > All the best, > > > > Olaf > > > > > >

> Hi Olaf, I will check out the new things ASAP. I would like to have both > Postgresql and Mysql working, so this is great. From what I gather, > Postgresql is more standardized that Mysql as far as the SQL > implementation and Postgresql has some powerful features in the backend. > I'm still finding my way around the modules and getting some ideas of > things we can do. > > I'll update things here and let you know how it looks :) > > ~james >

Fri Nov 16 17:40:01 2007 GRANTG [...] cpan.org - Queue changed from WWW-Myspace to WWW-Myspace-Data

Mon Aug 18 12:38:18 2008 olaf [...] wundersolutions.com - Correspondence added

Ticket closed due to lack of feedback.

Mon Aug 18 12:38:33 2008 olaf [...] wundersolutions.com - Status changed from 'open' to 'resolved'