DBD::mysql make fails on RHEL 4 IA64 w/MySQL 5.1.24

DBD::mysql make fails on RHEL 4 IA64 w/MySQL 5.1.24

am 26.08.2008 20:45:26 von Peter Wood

Greetings,

I'm trying to compile DBD::mysql on a server with the following specs:

* 64-bit Intel architecture
* Red Hat Enterprise Linux ES release 4 (Nahant Update 6)
* MySQL community server 5.1.24 for rhel4 ia64, installed via RPM from
MySQL.com
* Perl 5.8.5
* DBD::mysql 4.008

I run perl Makefile.PL with default settings, then make. Make then dies.
Here is a transcript of my "make" session:

# make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c
-I/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-mul ti/auto/DBI
-I/usr/include/mysql -g -no-ftz -no-prefetch -DUNIV_LINUX -g
-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64
-I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=3D\"4.008\"
-DXS_VERSION=3D\"4.008\" -fPIC
"-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" dbdimp.c
gcc: unrecognized option `-no-ftz'
gcc: unrecognized option `-no-prefetch'
dbdimp.c: In function `alloc_param':
dbdimp.c:112: warning: comparison is always false due to limited range
of data type
dbdimp.c: In function `alloc_bind':
dbdimp.c:130: warning: comparison is always false due to limited range
of data type
dbdimp.c: In function `alloc_fbind':
dbdimp.c:146: warning: comparison is always false due to limited range
of data type
dbdimp.c: In function `alloc_fbuffer':
dbdimp.c:161: warning: comparison is always false due to limited range
of data type
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi /auto/DBI/Dr
iver.xst > mysql.xsi
/usr/bin/perl /usr/lib/perl5/5.8.5/ExtUtils/xsubpp -typemap
/usr/lib/perl5/5.8.5/ExtUtils/typemap mysql.xs > mysql.xsc && mv
mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line
225
Warning: duplicate function definition 'rows' detected in mysql.xs, line
650
gcc -c
-I/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-mul ti/auto/DBI
-I/usr/include/mysql -g -no-ftz -no-prefetch -DUNIV_LINUX -g
-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64
-I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=3D\"4.008\"
-DXS_VERSION=3D\"4.008\" -fPIC
"-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" mysql.c
gcc: unrecognized option `-no-ftz'
gcc: unrecognized option `-no-prefetch'
mysql.xs: In function `XS_DBD__mysql__db_do':
mysql.xs:330: warning: comparison is always false due to limited range
of data type
mysql.xs:331: warning: comparison is always false due to limited range
of data type
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/lib/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm =20
/usr/lib/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


Any ideas as to what could be causing this? I did check the mailing list
and saw other people with the "bad value" error, but with different
symptoms leading up to it.

Thanks,

Peter

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

RE: DBD::mysql make fails on RHEL 4 IA64 w/MySQL 5.1.24

am 27.08.2008 15:40:49 von Peter Wood

Hi all,

I've discovered the problem, and it's totally unrelated to DBD::mysql.
Turns out I was confused about what architecture I was running on and
which MySQL packages to download. We have an Intel Xeon which is x86_64.
However, when I went to download the MySQL devel package, I didn't see
x86_64, just AMD64. I thought IA64 looked like the closest thing, so
that's what I installed. Whoops! I now realize that AMD64 works on both
AMD64 and Intel x86_64, though I have to say that the package labeling
could be a bit clearer.

Sorry for the confusion!

Peter


-----Original Message-----
From: Peter Wood=20
Sent: Tuesday, August 26, 2008 2:45 PM
To: 'perl@lists.mysql.com'
Subject: DBD::mysql make fails on RHEL 4 IA64 w/MySQL 5.1.24

Greetings,

I'm trying to compile DBD::mysql on a server with the following specs:

* 64-bit Intel architecture
* Red Hat Enterprise Linux ES release 4 (Nahant Update 6)
* MySQL community server 5.1.24 for rhel4 ia64, installed via RPM from
MySQL.com
* Perl 5.8.5
* DBD::mysql 4.008

I run perl Makefile.PL with default settings, then make. Make then dies.
Here is a transcript of my "make" session:

# make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c
-I/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-mul ti/auto/DBI
-I/usr/include/mysql -g -no-ftz -no-prefetch -DUNIV_LINUX -g
-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64
-I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=3D\"4.008\"
-DXS_VERSION=3D\"4.008\" -fPIC
"-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" dbdimp.c
gcc: unrecognized option `-no-ftz'
gcc: unrecognized option `-no-prefetch'
dbdimp.c: In function `alloc_param':
dbdimp.c:112: warning: comparison is always false due to limited range
of data type
dbdimp.c: In function `alloc_bind':
dbdimp.c:130: warning: comparison is always false due to limited range
of data type
dbdimp.c: In function `alloc_fbind':
dbdimp.c:146: warning: comparison is always false due to limited range
of data type
dbdimp.c: In function `alloc_fbuffer':
dbdimp.c:161: warning: comparison is always false due to limited range
of data type
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi /auto/DBI/Dr
iver.xst > mysql.xsi
/usr/bin/perl /usr/lib/perl5/5.8.5/ExtUtils/xsubpp -typemap
/usr/lib/perl5/5.8.5/ExtUtils/typemap mysql.xs > mysql.xsc && mv
mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line
225
Warning: duplicate function definition 'rows' detected in mysql.xs, line
650
gcc -c
-I/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-mul ti/auto/DBI
-I/usr/include/mysql -g -no-ftz -no-prefetch -DUNIV_LINUX -g
-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64
-I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=3D\"4.008\"
-DXS_VERSION=3D\"4.008\" -fPIC
"-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" mysql.c
gcc: unrecognized option `-no-ftz'
gcc: unrecognized option `-no-prefetch'
mysql.xs: In function `XS_DBD__mysql__db_do':
mysql.xs:330: warning: comparison is always false due to limited range
of data type
mysql.xs:331: warning: comparison is always false due to limited range
of data type
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/lib/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm =20
/usr/lib/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


Any ideas as to what could be causing this? I did check the mailing list
and saw other people with the "bad value" error, but with different
symptoms leading up to it.

Thanks,

Peter

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

Re: DBD::mysql make fails on RHEL 4 IA64 w/MySQL 5.1.24

am 27.08.2008 18:37:53 von Patrick Galbraith

Peter,

This is one reason why I wish I could have a separate client source
distribution to package with DBD::mysql.

--Patrick

Peter Wood wrote:
> Hi all,
>
> I've discovered the problem, and it's totally unrelated to DBD::mysql.
> Turns out I was confused about what architecture I was running on and
> which MySQL packages to download. We have an Intel Xeon which is x86_64.
> However, when I went to download the MySQL devel package, I didn't see
> x86_64, just AMD64. I thought IA64 looked like the closest thing, so
> that's what I installed. Whoops! I now realize that AMD64 works on both
> AMD64 and Intel x86_64, though I have to say that the package labeling
> could be a bit clearer.
>
> Sorry for the confusion!
>
> Peter
>
>
> -----Original Message-----
> From: Peter Wood
> Sent: Tuesday, August 26, 2008 2:45 PM
> To: 'perl@lists.mysql.com'
> Subject: DBD::mysql make fails on RHEL 4 IA64 w/MySQL 5.1.24
>
> Greetings,
>
> I'm trying to compile DBD::mysql on a server with the following specs:
>
> * 64-bit Intel architecture
> * Red Hat Enterprise Linux ES release 4 (Nahant Update 6)
> * MySQL community server 5.1.24 for rhel4 ia64, installed via RPM from
> MySQL.com
> * Perl 5.8.5
> * DBD::mysql 4.008
>
> I run perl Makefile.PL with default settings, then make. Make then dies.
> Here is a transcript of my "make" session:
>
> # make
> cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
> cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
> cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
> cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
> gcc -c
> -I/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-mul ti/auto/DBI
> -I/usr/include/mysql -g -no-ftz -no-prefetch -DUNIV_LINUX -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=\"4.008\"
> -DXS_VERSION=\"4.008\" -fPIC
> "-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" dbdimp.c
> gcc: unrecognized option `-no-ftz'
> gcc: unrecognized option `-no-prefetch'
> dbdimp.c: In function `alloc_param':
> dbdimp.c:112: warning: comparison is always false due to limited range
> of data type
> dbdimp.c: In function `alloc_bind':
> dbdimp.c:130: warning: comparison is always false due to limited range
> of data type
> dbdimp.c: In function `alloc_fbind':
> dbdimp.c:146: warning: comparison is always false due to limited range
> of data type
> dbdimp.c: In function `alloc_fbuffer':
> dbdimp.c:161: warning: comparison is always false due to limited range
> of data type
> /usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
> /usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi /auto/DBI/Dr
> iver.xst > mysql.xsi
> /usr/bin/perl /usr/lib/perl5/5.8.5/ExtUtils/xsubpp -typemap
> /usr/lib/perl5/5.8.5/ExtUtils/typemap mysql.xs > mysql.xsc && mv
> mysql.xsc mysql.c
> Warning: duplicate function definition 'do' detected in mysql.xs, line
> 225
> Warning: duplicate function definition 'rows' detected in mysql.xs, line
> 650
> gcc -c
> -I/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-mul ti/auto/DBI
> -I/usr/include/mysql -g -no-ftz -no-prefetch -DUNIV_LINUX -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=\"4.008\"
> -DXS_VERSION=\"4.008\" -fPIC
> "-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" mysql.c
> gcc: unrecognized option `-no-ftz'
> gcc: unrecognized option `-no-prefetch'
> mysql.xs: In function `XS_DBD__mysql__db_do':
> mysql.xs:330: warning: comparison is always false due to limited range
> of data type
> mysql.xs:331: warning: comparison is always false due to limited range
> of data type
> 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/lib/mysql -lmysqlclient -lz
> -lcrypt -lnsl -lm
> /usr/lib/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
>
>
> Any ideas as to what could be causing this? I did check the mailing list
> and saw other people with the "bad value" error, but with different
> symptoms leading up to it.
>
> Thanks,
>
> Peter
>
>


--
Patrick Galbraith, Senior Programmer
Grazr - Easy feed grazing and sharing
http://www.grazr.com

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




--
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