Gossamer Forum
Home : Products : Gossamer Links : Discussions :

DBI Problem

Quote Reply
DBI Problem
Hi:



Sorry- newbie problem here. I can't seem to get DBI installed right. I installed

Module DBI (T/TI/TIMB/DBI-1.22.tar.gz)



From CPAN, and it installed OK. But on my test version of Links, I get this error:



Reason: Can't locate DBI.pm in @INC



Did I install the wrong module (and if so, which is the right one?) or did I install it wrong? Or do I need to make some other tweak to get this going?



Thanks! Have a great weekend!


dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] DBI Problem In reply to
This is a database problem & question, which more belongs here:
Home: General: Databases and SQL

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Quote Reply
Re: [carfac] DBI Problem In reply to
How did you install it?

Did you do it from telnet?....
Quote Reply
Re: [Paul] DBI Problem In reply to
Paul:



Sorry for the delay in response.- was out of town!



I have tried both a CPAN install, and downloading the tarball and make and make install...



dave
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] DBI Problem In reply to
Do you have more than one version of perl installed?

Try:

perl[version] -MCPAN -e 'install DBI'

..for example:

perl5.6.0 -MCPAN -e 'install DBI'
Quote Reply
Re: [Paul] DBI Problem In reply to
Paul:



OK, sounds good! I went to ENV to find out if I had moire than one perl.... I thought I only had one, but (as you can tell), I do not know 100% for sure. Here is what I got:



/usr/home/c/cartoon/public_html/bcdb/admin
/home/c/cartoon/public_html/bcdb/admin
/usr/local/lib/perl5/5.6.1/i386-freebsd
/usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd
/usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd
/usr/local/lib/perl5/site_perl/5.005
/usr/local/lib/perl5/site_perl


So, I should run:



perl5.6.1 -MCPAN -e 'install DBI'



Right?



Trying now!



Dave
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] DBI Problem In reply to
Yeah you can try that.

Also try:

locate DBI.pm

...to see where the other one was installed.
Quote Reply
Re: [Paul] DBI Problem In reply to
Paul:



I Ran Locate:



bash-2.04$ locate DBI.pm
/root/.cpan/Bundle/DBI.pm
/root/.cpan/build/DBI-1.22/DBI.pm
/root/.cpan/build/DBI-1.22/blib/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.22/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.22/lib/Bundle/DBI.pm
/usr/local/DBI-1.21/DBI.pm
/usr/local/DBI-1.21/blib/lib/Bundle/DBI.pm
/usr/local/DBI-1.21/blib/lib/DBI.pm
/usr/local/DBI-1.21/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.6.1/Apache/AuthDBI.pm
/usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm
/usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/DBI.pm



is that right?



(Sorry, I am just really DUMB in UNIX..)



dave
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [Paul] DBI Problem In reply to
Paul:



OK, I ran the perl5.6.1 -MCPAN -e 'install DBI' and it installed just fine!



BUT!!!



I ran INC again, and it is not there: (But it idoes show in Environment:



Perl Version: 5.006001
Links SQL Version: 1.2 dev
DBI.pm Version: 1.22
Persistant Env: mod_perl (1) SpeedyCGI (0)
Mod Perl Version: 1.26
@INC =
/usr/home/c/cartoon/public_html/bcdb/admin
/home/c/cartoon/public_html/bcdb/admin
/usr/local/lib/perl5/5.6.1/i386-freebsd
/usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd
/usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd
/usr/local/lib/perl5/site_perl/5.005
/usr/local/lib/perl5/site_perl
.
/usr/local/apache/
/usr/local/apache/lib/perl
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] DBI Problem In reply to
It looks like DBI isn't installed at all :(

Try:

perl5.6.1 -MCPAN -e 'install DBI'
Quote Reply
Re: [Paul] DBI Problem In reply to
Paul:



It replied:



www# perl5.6.1 -MCPAN -e 'install DBI'
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Tue, 28 May 2002 10:40:05 GMT
DBI is up to date.

dave
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [Paul] DBI Problem In reply to
Ok I tell a lie....it says DBI version 1.22 so I don't know why it isn't showing in the module list.
Post deleted by Paul In reply to

Last edited by:

Paul: May 28, 2002, 10:07 AM
Quote Reply
Re: [carfac] DBI Problem In reply to
Ok all our posts are crossing over and Im getting confused :)

I can take a look if you want?

Last edited by:

Paul: May 28, 2002, 10:09 AM
Quote Reply
Re: [Paul] DBI Problem In reply to
Paul:



I would be very happy to give you access.... but I have that nasty firewall that does not allow outside access...
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] DBI Problem In reply to
Oh yeah I forgot about that eek.

Ok what I suggest as a last resort is copying DBI.pm into one of the lib trees that is actually showing under the "Environment" menu in Links SQL.
Quote Reply
Re: [Paul] DBI Problem In reply to
Paul:



Well, all of a sudden the MySQL Man Is working!



So, whatever happened, it worked!



dave
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [carfac] DBI Problem In reply to
i did the same commands for installing as stated above, and receive a similar response, but however is till recieve when trying to setup Links SQL

Error: Could not connect to database. Reason: DBI module not installed. You must install the perl database module DBI from: http://www.perl.com/...odules/by-module/DBI



www# perl5.6.1 -MCPAN -e 'install DBI'
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Tue, 28 May 2002 10:40:05 GMT
DBI is up to date.
Quote Reply
Re: [xpert] DBI Problem In reply to
Problem solved, seem like DBI dun liek the newest version of activeperl!