Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DBD Module - can't install, can anyone help me out?

Status
Not open for further replies.

peterv12

Technical User
Dec 31, 2008
108
US
I've been trying for days to install the DBI & DBD modules for Perl & MySQL. I finally got the DBI module installed, but not the DBD. Below is the output from the makefile script. Can anyone help me figure out how to fix the problems? I'm a newbie at this, and I really need to get it to work. Any and all suggestions will be welcome!

Code:
peterv@MBP17.local<506>$: sudo Perl Makefile.PL | tee makefile.log
tee: makefile.log: Permission denied


PLEASE NOTE:

For 'make test' to run properly, you must ensure that the 
database user 'root' can connect to your MySQL server 
and has the proper privileges that these tests require such 
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others. 

mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';

You can also optionally set the user to run 'make test' with:

perl Makefile.pl --testuser=username

Use of uninitialized value in printf at Makefile.PL line 175, <PIPE> line 102.
I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/opt/local/mysql/include  -g -Os -arch x86_64 -fno-common   -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT  -DDONT_DECLARE_CXA_PURE_VIRTUAL
  embedded      (mysql_config) = 
  libs          (mysql_config) = -L/opt/local/mysql/lib -lmysqlclient -lz -lm     -lmygcc
  mysql_config  (guessed     ) = mysql_config
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) = 
  testpassword  (default     ) = 
  testsocket    (default     ) = 
  testuser      (            ) = root

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Multiple copies of Driver.xst found in: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/ /System/Library/Perl/Extras/5.10.0/darwin-thread-multi-2level/auto/DBI/ at Makefile.PL line 748
Using DBI 1.608 (for perl 5.010000 on darwin-thread-multi-2level) installed in /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/
Writing Makefile for DBD::mysql

Mon Apr 19 09:43:29 EDT 2010 
/Library/Perl/DBD-mysql-4.011 ->
peterv@MBP17.local<507>$: db.pl
[B][COLOR=red]install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: /opt/local/lib/perl5/site_perl/5.10.1/darwin-multi-2level /opt/local/lib/perl5/site_perl/5.10.1 /opt/local/lib/perl5/site_perl/5.8.9 /opt/local/lib/perl5/site_perl /opt/local/lib/perl5/vendor_perl/5.10.1/darwin-multi-2level /opt/local/lib/perl5/vendor_perl/5.10.1 /opt/local/lib/perl5/vendor_perl /opt/local/lib/perl5/5.10.1/darwin-multi-2level /opt/local/lib/perl5/5.10.1 .) at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a module that DBD::mysql requires hasn't been fully installed
 at /Users/peterv/Perl1/db.pl line 8
[/color][/B]
Mon Apr 19 09:43:29 EDT 2010
I guess one thing I'd like to know is what is the "loadable object module" for DBD::MYSQL? If I knew that, maybe I could find it on my own and move it inside the @INC path.
 

Code:
[COLOR=red][B]Note:  This is being done on an OS X Snow Leopard system[/B][/color]

 
I solved this issue by renaming all the duplicate versions of files in /System/Library/Perl/Extras/5.10.0/darwin-thread-multi-2level/auto/DBI/ directory.

THIS ISSUE IS RESOLVED>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top