RE: Installing DBD::mysql - problems
Hi Connie, Looks like you have hit http://bugs.mysql.com/bug.php?id=18091 (which hasn't been fixed yet) potential solutions are documented there. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Logg, Connie A. [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 May 2006 5:47 AM To: mysql@lists.mysql.com Subject: Installing DBD::mysql - problems I am trying to install DBD::mysql on the following node: [EMAIL PROTECTED] cal]# uname -a Linux snv1 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64 x86_64 x86_64 GNU/Linux [EMAIL PROTECTED] cal]# more /etc/redhat-release Red Hat Enterprise Linux WS release 4 (Nahant Update 3) [EMAIL PROTECTED] cal]# I have the following rpms installed [EMAIL PROTECTED] cal]# rpm -qa | grep -i mysql MySQL-devel-standard-5.0.20a-0.rhel4 MySQL-client-standard-5.0.20a-0.rhel4 MySQL-shared-standard-5.0.20a-0.rhel4 MySQL-server-standard-5.0.20a-0.rhel4 And DBI installed ok. [EMAIL PROTECTED] utils]$ ./seeperlmods Archive::Tar -- 1.29 CPAN -- 1.87 Compress::Zlib -- 1.41 Cwd -- 3.17 DBD::Multiplex -- 1.98 DBI -- 1.50 <-- DBI::Shell -- 11.93 Data::ShowTable -- undef Digest::MD5 -- 2.36 IO::Tee -- 0.64 IO::Zlib -- 1.04 Net::Daemon -- 0.39 Net::Telnet -- 3.03 Perl -- 5.8.5 RPC::PlServer -- 0.2018 Storable -- 2.15 Term::ReadKey -- 2.30 Term::ReadLine -- 1.01 Text::Reform -- 1.11 When I try to install the DBD::mysql I get errors: [EMAIL PROTECTED] DBD-mysql-3.0002_5]# /usr/bin/perl Makefile.PL I will use the following settings for compiling and testing: cflags(mysql_config) = -I/usr/include/mysql -g -pipe -m64 embedded (mysql_config) = libs (mysql_config) = -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ps-protocol (default ) = 1 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Multiple copies of Driver.xst found in: /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ / usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 741 Using DBI 1.50 (for perl 5.008005 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.5/ x86_64-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::mysql probably ok as it picked one When I run make: [EMAIL PROTECTED] DBD-mysql-3.0002_5]# make gcc -c -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ -I/usr/include/mysql -g -pipe - m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr /local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=\" 3.0002_5\" -DXS_VERSION=\"3.0002_5\" -fPIC "-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" dbdimp. c gcc -c -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ -I/usr/include/mysql -g -pipe - m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr /local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=\" 3.0002_5\" -DXS_VERSION=\"3.0002_5\" -fPIC "-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so /usr/bin/perl myld gcc -shared dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib64/mysql -l mysqlclient -lz -lcrypt -lnsl -lm /usr/bin/ld: /usr/lib64/mysql/libmysqlclient.a(libmysql.o): relocation R_X86_64_32 against `a local symbol' ca n not be used when making a shared object; recompile with -fPIC /usr/lib64/mysql/libmysqlclient.a: could not read symbols: Bad value collect2: ld returned 1 exit status make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1 [EMAIL PROTECTED] DBD-mysql-3.0002_5]# I tried using /usr/bin/perl Makefile.PL --cflags
Installing DBD::mysql - problems
I am trying to install DBD::mysql on the following node: [EMAIL PROTECTED] cal]# uname -a Linux snv1 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64 x86_64 x86_64 GNU/Linux [EMAIL PROTECTED] cal]# more /etc/redhat-release Red Hat Enterprise Linux WS release 4 (Nahant Update 3) [EMAIL PROTECTED] cal]# I have the following rpms installed [EMAIL PROTECTED] cal]# rpm -qa | grep -i mysql MySQL-devel-standard-5.0.20a-0.rhel4 MySQL-client-standard-5.0.20a-0.rhel4 MySQL-shared-standard-5.0.20a-0.rhel4 MySQL-server-standard-5.0.20a-0.rhel4 And DBI installed ok. [EMAIL PROTECTED] utils]$ ./seeperlmods Archive::Tar -- 1.29 CPAN -- 1.87 Compress::Zlib -- 1.41 Cwd -- 3.17 DBD::Multiplex -- 1.98 DBI -- 1.50 <-- DBI::Shell -- 11.93 Data::ShowTable -- undef Digest::MD5 -- 2.36 IO::Tee -- 0.64 IO::Zlib -- 1.04 Net::Daemon -- 0.39 Net::Telnet -- 3.03 Perl -- 5.8.5 RPC::PlServer -- 0.2018 Storable -- 2.15 Term::ReadKey -- 2.30 Term::ReadLine -- 1.01 Text::Reform -- 1.11 When I try to install the DBD::mysql I get errors: [EMAIL PROTECTED] DBD-mysql-3.0002_5]# /usr/bin/perl Makefile.PL I will use the following settings for compiling and testing: cflags(mysql_config) = -I/usr/include/mysql -g -pipe -m64 embedded (mysql_config) = libs (mysql_config) = -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ps-protocol (default ) = 1 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Multiple copies of Driver.xst found in: /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ / usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 741 Using DBI 1.50 (for perl 5.008005 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.5/ x86_64-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::mysql probably ok as it picked one When I run make: [EMAIL PROTECTED] DBD-mysql-3.0002_5]# make gcc -c -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ -I/usr/include/mysql -g -pipe - m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr /local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=\" 3.0002_5\" -DXS_VERSION=\"3.0002_5\" -fPIC "-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" dbdimp. c gcc -c -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ -I/usr/include/mysql -g -pipe - m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr /local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=\" 3.0002_5\" -DXS_VERSION=\"3.0002_5\" -fPIC "-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so /usr/bin/perl myld gcc -shared dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib64/mysql -l mysqlclient -lz -lcrypt -lnsl -lm /usr/bin/ld: /usr/lib64/mysql/libmysqlclient.a(libmysql.o): relocation R_X86_64_32 against `a local symbol' ca n not be used when making a shared object; recompile with -fPIC /usr/lib64/mysql/libmysqlclient.a: could not read symbols: Bad value collect2: ld returned 1 exit status make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1 [EMAIL PROTECTED] DBD-mysql-3.0002_5]# I tried using /usr/bin/perl Makefile.PL --cflags fPIC And doing the make afterword, but that failed miserably with many many errors snip dbdimp.c:3017: error: dereferencing pointer to incomplete type dbdimp.c: In function `mysql_describe': dbdimp.c:3126: error: dereferencing pointer to incomplete type dbdimp.c: In function `mysql_st_fetch': dbdimp.c:3151: error: `MYSQL_ROW' undeclared (first use in this function) dbdimp.c:3151: error: syntax error before "cols" dbdimp.c:3156: error: dereferencing pointer to incomplete type I am at a loss how to resolve this. I would appreciate any guidance. I have also tried DBD-mysql-3.0002_4 and DBD-mysql-3.0002_3 Connie Logg Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-2879 "Happiness is found along the way, not at the end of the road, and 'IF' is the middle word in life." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]