Problems installing DBD::mysql
Marek Stepanek
Hello all!
This is my first posting here, after a long silent time, receiving the
postings of this group.
I have a problem, which I am unable to resolve on myself:
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!
Best greetings from Munich
marek
Send instant messages to your online friends http://uk.messenger.yahoo.com
Marek Stepanek
> Have you installed the mysql libraries on your OS X system first?
>
> You need more that just the perl bindings to MySQL, you need to have MySQL installed on your machine, along with whatever libraries needed to run it. That is to say, runtime and buildtime dependencies.
>
> BTW, you may want to look into Postgres since MySQL was recently bought by Oracle.
>
>
> Regards,
>
> Jeremiah
>
>
Sorry, Jeremiah, I answered off list, privately. Here the contents of my
answer:
Hello Jeremiah!
Thank you for your answer! At least, there was one. I could not answer
you in time, because my only computer, my life partner, PBP 17' was in
clinic for two weeks. Now I have a new logic board, but still now
DBD::mysql module and not many answers in this group :-(
Of course I have mysql installed; and for the next one, asking
questions: yes, on my $PATH there are the mysql bin included:
% echo $PATH
/sw/bin:/sw/sbin:/usr/local/sbin:/sw/include:/usr/local/bin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/texbin:/usr/X11/bin:/usr/X11R6/bin
Best greetings to all
Celeste Suliin Burris
perl modules where the developer has made no allowance for the mixture of
32 bit and 64 bit Macs, and then the binaries won't compile.
I have no good workaround, I am not enough of a Makefile expert to fix the
flags.
Chip Howland
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