error: mysql.so: undefined symbol: mysql_init

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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/mys ql.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?

- --

Sean O'Donnell
South Pasadena, CA
sean@seanodonnell.com
http://seanodonnell.com

PGP Public Key ID: 0xAC769035
PGP Public Key Server: http://pgp.mit.edu

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)

iD8DBQFEw2YFCUrh+ax2kDURAsxVAKDbBivsrYwLVHk7JoD8g7/B2YSkzwCf YIyT
lYFL1vQB97mKifRWCon5h0k=
=4yrZ
-----END PGP SIGNATURE-----

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: error: mysql.so: undefined symbol: mysql_init

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Just a follow-up on this post *below*...

I resolved the matter by simply updating DBI to the latest version (1.51).

*ftr*

- --

Sean O'Donnell
South Pasadena, CA
sean@seanodonnell.com
http://seanodonnell.com

PGP Public Key ID: 0xAC769035
PGP Public Key Server: http://pgp.mit.edu

Sean O'Donnell wrote:
> 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/mys ql.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?
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)

iD8DBQFE6KGoCUrh+ax2kDURAtN5AKC1KrmsV6ESgvbbxZaPqvkjuBYMGgCe Kq12
AeQ2LxV2EektXLM+l0svvzc=
=OVsN
-----END PGP SIGNATURE-----

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org