# Perl DBD hell

**URL:** <https://forums.percona.com/t/perl-dbd-hell/2853>\
**Category:** Percona Toolkit\
**Created:** [July 30, 2013, 2:18pm UTC](https://forums.percona.com/t/perl-dbd-hell/2853 "2013-07-30T14:18:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![skunkwerk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/skunkwerk/32/920_2.png) [@skunkwerk](https://forums.percona.com/u/skunkwerk)\
**Post date:** [July 30, 2013, 2:18pm UTC](https://forums.percona.com/t/perl-dbd-hell/2853/1 "2013-07-30T14:18:51Z")

</div>

I’m trying to run pt-online-schema-change on a Centos 5 server. It worked perfectly on my test database which runs on a different server, but this server keeps giving me this error:  
perl: symbol lookup error: /usr/lib/perl5/site\_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so: undefined symbol: mysql\_init

I’ve installed DBD version 4 like this:  
perl Makefile.PL --libs=“-L/usr/lib -lmysqlclient.so.15” \ –cflags=-I/usr/include/mysql  
sudo make install

and I’ve run ldconfig, but the .so still doesn’t point to libmysqlclient:  
ldd /usr/lib/perl5/site\_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so  
linux-gate.so.1 =\> (0x003e5000)  
libc.so.6 =\> /lib/i686/nosegneg/libc.so.6 (0x00b28000)  
/lib/ld-linux.so.2 (0x00ab3000)

And I’ve tried everything in this list:  
[URL][http://dev.mysql.com/doc/refman/5.6/en/perl-support-problems.html[/URL]](http://dev.mysql.com/doc/refman/5.6/en/perl-support-problems.html%5B/URL%5D)

Any ideas?

thanks,  
imran

---

<div class="post-metadata">

**Author:** ![jaime](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@jaime](https://forums.percona.com/u/jaime)\
**Post date:** [August 11, 2013, 12:31am UTC](https://forums.percona.com/t/perl-dbd-hell/2853/2 "2013-08-11T00:31:23Z")

</div>

Hi Imran,  
When I tested your command, I got this error:

Note (probably harmless): No library found for -lmysqlclient.so.15

You should try again with -lmysqlclient instead and also make sure that -L path contains the libmysqlclient.so\* files. In my case they were stored in /usr/lib64/mysql on CentOS 5 64bit:

perl Makefile.PL --libs=“-L/usr/lib64/mysql -lmysqlclient” --cflags=-I/usr/include/mysql  
make  
make install

Here’s my ldd:

ldd /usr/lib64/perl5/site\_perl/5.8.8/x86\_64-linux-thread-multi/auto/DBD/mysql/mysql.so  
linux-vdso.so.1 =\> (0x00007fff10b8c000)  
libmysqlclient.so.15 =\> /usr/lib64/mysql/libmysqlclient.so.15 (0x00002b1240e35000)

I am curious why you need to link to that particular libmysqlclient.so.15? What nuances do you have in your configuration?
