Re: Problems installing DBD::mysql

At 7:12 AM +0100 1/31/11, Marek Stepanek wrote:

>I want to install since four days now DBD::mysql on my MBP, with 64bit
>Intel chip.
>
>I tried with both version of MYSQL Community Server:
>
>	mysql-5.5.8-osx10.6-x86_64.tar.gz (the 64bit version)
>and
>	mysql-5.5.8-osx10.6-x86.tar.gz    (the 32bit version)
>
>I think I am not doing something wrong, installing the MYSQL Server. (:
>Meanwhile I am a Professional, doing it :)
>
>But installing DBD::mysql fails already with make, and both servers: the
>64bit and the 32bit ...
>
>First my Perl:
>
>% perl -v
>
>This is perl, v5.10.0 built for darwin-thread-multi-2level
>
>The installing procedure of DBD::mysql fails like follows. I am in the
>folder ~/.cpanplus/5.10.0/build/DBD-mysql-4.018:
>
>
>1.
>
>	% perl Makefile.PL
>
>Here one warning is perhaps important:
>
>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 907
>Using DBI 1.611 (for perl 5.010000 on darwin-thread-multi-2level)
>installed in /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/
>
>2. I fire up the MYSQL-Server to grant the privileges for the test user:
>
>	% mysql> grant all privileges on test.* to 'mstep'@'localhost'
>	  identified by 's3kr1t';
>
>3. 	% make
>
>And here are starting serious problems: I get plenty of following warnings:
>
>dbdimp.c: In function 'alloc_param':
>dbdimp.c:212: warning: format not a string literal and no format arguments
>
>4. 	% make test
>4.(Var) % sudo make test
>
>Both are failing with following messages:
>
>PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
>"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
>t/00base.t .................. 1/6
>#   Failed test 'use DBD::mysql;'
>#   at t/00base.t line 21.
>#     Tried to use 'DBD::mysql'.
>#     Error:  Can't load
>'/Users/mstep/.cpanplus/5.10.0/build/DBD-mysql-4.018/blib/arch/auto/DBD/mysql/mysql.bundle'
>for module DBD::mysql:
>dlopen(/Users/mstep/.cpanplus/5.10.0/build/DBD-mysql-4.018/blib/arch/auto/DBD/mysql/mysql.bundle,
>2): Library not loaded: libmysqlclient.16.dylib
>#   Referenced from:
>/Users/mstep/.cpanplus/5.10.0/build/DBD-mysql-4.018/blib/arch/auto/DBD/mysql/mysql.bundle
>#   Reason: image not found at
>/System/Library/Perl/5.10.0/darwin-thread-multi-2level/DynaLoader.pm
>line 207.
>#  at (eval 7) line 2
># Compilation failed in require at (eval 7) line 2.
># BEGIN failed--compilation aborted at (eval 7) line 2.
>Bailout called.  Further testing stopped:  Unable to load DBD::mysql
>FAILED--Further testing stopped: Unable to load DBD::mysql
>make: *** [test_dynamic] Error 255
>
>Could somebody help me out? Please!


These are the notes I made the last time I spent a week trying to 
install MySQL, DBI and DBD. They worked for me at the time. Some of 
these steps may no longer be necessary or correct.

I hope this helps. Good luck.

Installing MySQL, DBI & DBD

MySQL

	Download MySQL package installer from MySQL.org

	Install MySQL

	Install MySQLStartupItem.pkg

	Restart

	> mysqladmin -u root password [ new password ]


DBI

	cpan> install Bundle::DBI


DBD

	cpan> look DBD::mysql

	> perl Makefile.PL --testhost=your_server --testport=3306 
--testdb=test --testuser=root --testpassword=your_root_password 
--mysql_config="/usr/local/mysql/bin/mysql_config"

	> sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql

	> make

	> make test

	> sudo make install


Other resources:

http://www.thescripts.com/forum/thread676055.html
http://bugs.mysql.com/bug.php?id=367
http://forums.mysql.com/read.php?51,168255,173617#msg-173617
http://bugs.mysql.com/bug.php?id=30160