List:General Discussion« Previous MessageNext Message »
From:steve Date:June 23 1999 1:40am
Subject:Re: MySQl and Perl DBI Problem
View as plain text  
I had a similar problem and I believe I solved it being sure that all of 
the directories that  the @INC statement looks for were in fact created 
and then went back and re-compiled the driver Msql-MySQL-modules.

If you running RedHat..
I believe the most recent versions of the driver are looking for 
RH6.0(which comes with Perl 5.005) hooks so if you are running RH5.x this 
problem occurs.


>Mick Gyure writes:
> > I am having problems connecting to a mysql database using Perl.  I have 
>the
> > MySQL database working fine form the mysql monitor and I am able to work
> > with the database with no problem.  I did install the MySQL DBI modules 
>and
> > the the make tests went fine. I am executing the following code to test 
>the
> > connect:
> > 
> > #!/usr/bin/perl
> > use DBI;
> > $drh = (DBI->connect("DBI:mysql:liveat", 'myusername','mypassword')) || 
>die
> > "can't open database";
> > print $drh;
> > $dhc = disconnect;
> > 
> > and I get the following error message:
> > 
> > install_driver(mysql) failed: Can't locate loadable object for module
> > DBD::mysql in @INC (@INC contains: /usr/lib/perl5/mips-linux/5.00404
> > /usr/lib/perl5 /usr/lib/perl5/site_perl/mips-linux 
>/usr/lib/perl5/site_perl
> > .) at (eval 1) line 2 Perhaps a module that DBD::mysql requires hasn't 
>been
> > fully installed at /home/sites/site2/cgi-bin/db.cgi line 3
> > 
> > Any help anyone can give me would be greatly appreciated.
> > - Mick
> > 
>
>Hello Mick,
>
>Did you install both DBI-1.0X and Msql-Mysql-modules,
>especially, did you remember to do make install after
>make with Msql-Mysql-modules?
>
>Regards,
>
>- Jani
>
>-- 
>+---------------------------------------------------------------------+
>| TcX  ____  __     _____   _____  ___                                |
>|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen             |
>|    /*/ /*/ /*/   \*\_   |*|   |*||*|       mailto: jani@stripped   |
>|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki                 |
>|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland                  |
>|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
>|             /*/             \*\                   Developers Team   |
>+---------------------------------------------------------------------+
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread5623@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.



 ***********************************************
* Stephen J. Schilt - Internet Easy             *
* Internet Training, Programming & Web Services *
* steve@stripped *  http://interneteasy.com/      *
* Tel:(714)641-4808 & (949)673-5494             *
* Fax:(714)641-4804 & (949)673-3506             *
 ***********************************************



Thread
MySQl and Perl DBI ProblemMick Gyure15 Jun
  • MySQl and Perl DBI ProblemJani Tolonen22 Jun
Re: MySQl and Perl DBI Problemsteve23 Jun