RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11

"Tim Maynard" <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <31D549ADED852D428CDC2A05ED1F38B38BD810@mailsrvr2.klem.redeyeusa.com> 
i have tried recompiling everything for gcc 3.2.2
	perl 5.8.6 compiled and installed successfully with gcc
	mysql 4.1.11 compiled and installed successfully with gcc
	DBD::mysql compiled, but failed intial test.
here is everything that the mysql.so fails to have for the test.

--------------------------------------------------------------
ldd -r blib/arch/auto/DBD/mysql/mysql.so

	libmysqlclient.so.14 => /usr/lib/mysql/libmysqlclient.so.14
(0x40012000)
	libz.so.1 => /usr/lib/libz.so.1 (0x40204000)
	libcrypt.so.1 => /lib/libcrypt.so.1 (0x40224000)
	libnsl.so.1 => /lib/libnsl.so.1 (0x40251000)
	libm.so.6 => /lib/tls/libm.so.6 (0x40266000)
	libssl.so.4 => /lib/libssl.so.4 (0x40289000)
	libcrypto.so.4 => /lib/libcrypto.so.4 (0x402be000)
	libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
	libresolv.so.2 => /lib/libresolv.so.2 (0x403af000)
	libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2
(0x403c1000)
	libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x403d4000)
	libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3
(0x40433000)
	libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3
(0x40443000)
	libdl.so.2 => /lib/libdl.so.2 (0x40445000)
	/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
undefined symbol: PL_perl_destruct_level
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_sv_undef   (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_stack_max  (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_markstack_ptr
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_markstack_max
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_sv_yes     (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_stack_base (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_stack_sp   (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_sv_no      (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_curpad     (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_memory_wrap
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_op (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PL_dirty      (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_croak    (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_free  (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_markstack_grow
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_dowantarray
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_setiv (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_2pv_flags
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: PerlIO_printf (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_mg_set   (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_newmortal
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_2bool (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_stack_grow
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newSVsv  (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_form     (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_av_extend
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_backoff
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_safesysfree
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_mg_size  (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_warn     (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newSVpvn (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newSVpv  (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_setpv (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_2mortal
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newXS    (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_av_make  (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newRV    (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_get_sv   (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newAV    (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newHV    (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: mysql_drop_db (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_av_push  (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: mysql_create_db
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_looks_like_number
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_call_method
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_hv_store (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newSViv  (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newSV    (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_hv_fetch (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_newRV_noinc
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_2iv   (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_setnv (blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_setpvn
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_safesysmalloc
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_sv_2pv_nolen
(blib/arch/auto/DBD/mysql/mysql.so)
undefined symbol: Perl_mg_get   (blib/arch/auto/DBD/mysql/mysql.so)

--------------------------------------------------------------
after looking into the problems with DBD's mysql.so, i wanted to see if
there
were any issues with other libraries like mysql, mysqlclient, or perl:

--------------------------------------------------------------
ldd -r /usr/lib/libperl.so

	libnsl.so.1 => /lib/libnsl.so.1 (0x40104000)
	libdl.so.2 => /lib/libdl.so.2 (0x40119000)
	libm.so.6 => /lib/tls/libm.so.6 (0x4011c000)
	libcrypt.so.1 => /lib/libcrypt.so.1 (0x4013e000)
	libutil.so.1 => /lib/libutil.so.1 (0x4016b000)
	libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
	libz.so.1 => /usr/lib/libz.so.1 (0x4016f000)
	/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

--------------------------------------------------------------
ldd -r /usr/lib/libmysqlclient.so
	
	libcrypt.so.1 => /lib/libcrypt.so.1 (0x40205000)
	libnsl.so.1 => /lib/libnsl.so.1 (0x40232000)
	libm.so.6 => /lib/tls/libm.so.6 (0x40247000)
	libz.so.1 => /usr/lib/libz.so.1 (0x40269000)
	libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
	/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

--------------------------------------------------------------
ldd -r /usr/lib/libmysql.so

	libmysqlclient.so.10 => libmysqlclient.so.10 (0x40005000)
	libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
	libcrypt.so.1 => /lib/libcrypt.so.1 (0x42000000)
	libnsl.so.1 => /lib/libnsl.so.1 (0x40236000)
	lidm.so.6 => /lib/tls/libm.so.6 (0x4024b000)
	libz.so.1 => libz.so.1 (0x4026e000)
	/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
undefined symbol: _dbd_result_set_numfields     (/usr/lib/libmysql.so)
undefined symbol: _dbd_row_allocate     (/usr/lib/libmysql.so)
undefined symbol: _dbd_result_create    (/usr/lib/libmysql.so)
undefined symbol: _dbd_row_finalize     (/usr/lib/libmysql.so)
undefined symbol: _error_handler        (/usr/lib/libmysql.so)
undefined symbol: dbi_conn_get_option   (/usr/lib/libmysql.so)
undefined symbol: dbi_conn_get_option_numeric   (/usr/lib/libmysql.so)
undefined symbol: _dbd_result_add_field (/usr/lib/libmysql.so)
undefined symbol: _isolate_attrib       (/usr/lib/libmysql.so)

--------------------------------------------------------------
i have libmysqlclient.so.14.0.0 available on my system...
how come the libmysql.so chooses the libmysqlclientso.10 instead?

i am still receiving errors about 'undefined symbol: mysql_drop_db'
in the 'install_driver(mysql) failure' test portion.

--TM

-----Original Message-----
From: Rudy Lippan [mailto:[email protected]] 
Sent: Thursday, May 05, 2005 9:39 AM
To: Tim Maynard
Cc: [email protected]
Subject: RE: test error on installation of DBD::mysql v2.1026 with mysql
v4.1.11


On Thu, 5 May 2005, Tim Maynard wrote:

> im using v2.9006 [DBD-mysql-2.9006] and i just found v2.9007 on cpan, 
> but the changelog for this didnt seem significant for my issues.


If you are still getting the segfaults with the latest version, send a
DBI->trace(9) and a stack trace. You might also want to verify that you 
DBI->are
linking against the correct client libraries when building DBD::mysql.


rudy



-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.