Hi all,

I'm using mysql-max-5.0.18-linux-i686-glibc23, perl-5.8.7, and DBD-mysql-3.0006 on Slackware 10.2, and I've run into an error that I can't find a solution for on google.

---

# code

my $db_conn = DBI->connect($mysql_dsn, $mysql_username, $mysql_password) or die 'Connection Error: $DBI::err($DBI::errstr)';

---

# error

/usr/bin/perl: symbol lookup error: /usr/lib/perl5/site_perl/5.8.7/i486-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init

---

From the search results I've read through, I followed the following suggestion and set my LD_LIBRARY_PATH environment variable to include the path that was returned from the following commands/results:

$ locate libmysql /usr/local/mysql/lib/libmysqlclient.a /usr/local/mysql/lib/libmysqlclient_r.a /usr/local/mysql/lib/libmysql

$ locate libmysqlclient /usr/local/mysql/lib/libmysqlclient.a /usr/local/mysql/lib/libmysqlclient_r.a.imp

$ LD_LIBRARY_PATH=/usr/local/mysql/lib/ $ export LD_LIBRARY_PATH

but no luck.

The code worked fine last time I used this script, but it's been so long since I used it last, that I honestly can't remember if it was the current version of mysql that's running now, or if I've upgraded mysql since then. I suspect that it is due to the upgrade, but I'm pretty sure it was working with at least mysql 5.0 (or higher) before.

Any suggestions?