CMWK

I have already installed MySQL and DBI like this.

I used rpms via Download MySQL Community Server

$ rpm -qa | grep -i mysql
MySQL-shared-compat-5.5.29-1.linux2.6.x86_64
MySQL-server-5.5.29-1.linux2.6.x86_64
MySQL-devel-5.5.29-1.linux2.6.x86_64
MySQL-client-5.5.29-1.linux2.6.x86_64

DBI is below.

$ cpanm DBI

Okay, I will show you my steps.

First of all, I got source code of DBD::mysql from github.

$ git clone https://github.com/CaptTofu/DBD-mysql.git
$ cd DBD-mysql
$ perl Makefile.PL
$ make

I saw an error in runing make.

$ make
/usr/bin/ld: cannot find -lmysqlclient

hmm. I was looking for resolving this error. I got a hint which add libs option.

$ perl Makefile.PL --libs="-L/usr/lib64/mysql -lmysqlclient"

Okay, I ran make successfully.

Next, I will run make test.

$ make test
t/00base.t ........................... 1/6 Bailout called.  Further testing stopped:  Unable to load DBD::mysql

#   Failed test 'use DBD::mysql;'

#   at t/00base.t line 21.

#     Tried to use 'DBD::mysql'.

#     Error:  Can't load '/home/shigeta/tmp/DBD-mysql/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: /home/shigeta/tmp/DBD-mysql/blib/arch

/auto/DBD/mysql/mysql.so: undefined symbol: pthread_mutex_trylock at /home/shigeta/perl5/perlbrew/perls/perl-5.12.5/lib/5.12.5/x86_64-linux/DynaLoade

r.pm line 200.

hmm. I read pod again. I found this. I tried to run below.

$ mysql_config --libs
-L/usr/lib64 -lmysqlclient -lpthread -lm -lrt -ldl

Ah, I need to add -pthread option. So, I tried to run like below.

$ perl Makefile.PL --libs="-L/usr/lib64/mysql -lmysqlclient -lpthread"

Grrr, I saw an error again.

$ make test
t/80procs.t .......................... 1/29 DBD::mysql::db do failed: alter routine command denied to user ''@'localhost' for routine 'test.testproc'
 at t/80procs.t line 41.

Okay, I needed to add an option, --testuser=root.

$ perl Makefile.PL --libs="-L/usr/lib64/mysql -lmysqlclient -lpthread" --testuser=root
$ make
$ make test

Finally, I installed DBD::mysql successfully like below.

$ git clone https://github.com/CaptTofu/DBD-mysql.git
$ cd DBD-mysql
$ perl Makefile.PL --libs="-L/usr/lib64/mysql -lmysqlclient -lpthread" --testuser=root
$ make
$ make test
$ make install

Yay :)

Anyway, DBD::mysql revision was below.

$ git log  --pretty=oneline -1
6e75c2e30ffbc2a6cb2554a7459b929e1f44ad1e Merge pull request #31 from 9re/master