I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 16.03.2004 03:25:30 von Simon Taylor

Hello all,

Has anyone else had this problem and beeen able to resolve it?

I can't get DBD-mysql-2.9003 to compile on any of three HPUX-11.11 machines
I have access to.

I'm using MySQL 4.0.18, (for hp-hpux11.11 on hppa2.0w), downloaded
from mysql.com today. The machines are a vanilla hpux 11.11 with perl 5.8.3
and no gcc environment installed.

The make fails with:

/usr/bin/ld: Invalid loader fixup in text space needed in output file
for symbol "$0000004B" in input file
"/usr/local/mysql/lib/libmysqlclient.a(libmysql.o)"

See below for the gory details. I would really value hearing anyone's else
experience with DBD and hpux 11.11 (BTW, I get the same problem with mysql
4.0.17).

Regards,

Simon Taylor

DETAILS:

$ perl Makefile.PL --cflags="-I/usr/local/mysql/include +DAportable"
--libs="-L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl -lm"
I will use the following settings for compiling and testing:

cflags (Users choice) = -I/usr/local/mysql/include +DAportable
libs (Users choice) = -L/usr/local/mysql/lib -lmysqlclient -lcrypt
-lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Using DBI 1.40 (for perl 5.008003 on PA-RISC2.0-thread-multi) installed in
/opt/perl5/lib/site_perl/5.8.3/PA-RISC2.0-thread-multi/auto/ DBI
Writing Makefile for DBD::mysql

$ make
cc -c
-I/opt/perl5/lib/site_perl/5.8.3/PA-RISC2.0-thread-multi/aut o/DBI
-I/usr/local/mysql/include +DAportable -D_POSIX_C_SOURCE=199506L
-D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 +O2 +Onolimit
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" +Z
"-I/opt/perl5/lib/5.8.3/PA-RISC2.0-thread-multi/CORE" dbdimp.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier: "sendfile" will have
internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier: "sendpath" will have
internal linkage.
cc -c
-I/opt/perl5/lib/site_perl/5.8.3/PA-RISC2.0-thread-multi/aut o/DBI
-I/usr/local/mysql/include +DAportable -D_POSIX_C_SOURCE=199506L
-D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 +O2 +Onolimit
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" +Z
"-I/opt/perl5/lib/5.8.3/PA-RISC2.0-thread-multi/CORE" mysql.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier: "sendfile" will have
internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier: "sendpath" will have
internal linkage.
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.sl
LD_RUN_PATH="" /usr/bin/perl myld /usr/bin/ld -b +vnocompatwarnings
-L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.sl
-L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl -lm
/usr/bin/ld: Invalid loader fixup in text space needed in output file for
symbol "$0000004B" in input file
"/usr/local/mysql/lib/libmysqlclient.a(libmysql.o)"
*** Error exit code 1

Stop.
$

--
Unisolve Pty Ltd - Melbourne, Australia
+61 3 9568 2005

--
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: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 16.03.2004 08:10:32 von Jochen Wiedmann

Simon Taylor wrote:

> cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
> "sendfile" with a different storage class specifier: "sendfile" will have
> internal linkage.
> cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
> "sendpath" with a different storage class specifier: "sendpath" will have
> internal linkage.

This one can be ignored, according to "perldoc perl581delta", "Platform
Specific Problems".

> LD_RUN_PATH="" /usr/bin/perl myld /usr/bin/ld -b +vnocompatwarnings
> -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.sl
> -L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl -lm
> /usr/bin/ld: Invalid loader fixup in text space needed in output file for
> symbol "$0000004B" in input file
> "/usr/local/mysql/lib/libmysqlclient.a(libmysql.o)"

I must admit, that I have no clue based on the error message. But most
probably you have one of the typical problems on commercial Unixes:

a) You are mixing binaries compiled from different sources. For example,
a version of MySQL, picked up from www.mysql.com and a version of
Perl, compiled on your machine. It is definitely recommended to
compile everything locally and not using external binaries. At least
not, when problems like that arise. :-)

Note, that in the case of MySQL, it is sufficient to compile the
MySQL client libraries locally: A server from www.mysql.com or
somewhere else can still be used. See in particular the configure
option --without-server.

b) Special case of a): You are mixing 64bit and 32bit binaries. See
above for a solution.

c) You are using a version of libmysqlclient.so, which is not compiled
with +z or +Z. See a) for getting a propert client.

Jochen

--
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: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 16.03.2004 08:10:32 von Jochen Wiedmann

MySql replication or remote access

am 16.03.2004 13:40:47 von lshen

Dose anyone know how to do the replication or remote access (proxy table)
setup?
thank you

Brian
----- Original Message -----
From: "Jochen Wiedmann"
To:
Cc: ; "John Bolland" ; "Simon
Green" ;
Sent: Tuesday, March 16, 2004 02:10 AM
Subject: Re: I can't get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

> Simon Taylor wrote:
>
> > cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
> > "sendfile" with a different storage class specifier: "sendfile" will
have
> > internal linkage.
> > cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
> > "sendpath" with a different storage class specifier: "sendpath" will
have
> > internal linkage.
>
> This one can be ignored, according to "perldoc perl581delta", "Platform
> Specific Problems".
>
>
> > LD_RUN_PATH="" /usr/bin/perl myld /usr/bin/ld -b
+vnocompatwarnings
> > -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.sl
> > -L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl -lm
> > /usr/bin/ld: Invalid loader fixup in text space needed in output file
for
> > symbol "$0000004B" in input file
> > "/usr/local/mysql/lib/libmysqlclient.a(libmysql.o)"
>
> I must admit, that I have no clue based on the error message. But most
> probably you have one of the typical problems on commercial Unixes:
>
> a) You are mixing binaries compiled from different sources. For example,
> a version of MySQL, picked up from www.mysql.com and a version of
> Perl, compiled on your machine. It is definitely recommended to
> compile everything locally and not using external binaries. At least
> not, when problems like that arise. :-)
>
> Note, that in the case of MySQL, it is sufficient to compile the
> MySQL client libraries locally: A server from www.mysql.com or
> somewhere else can still be used. See in particular the configure
> option --without-server.
>
> b) Special case of a): You are mixing 64bit and 32bit binaries. See
> above for a solution.
>
> c) You are using a version of libmysqlclient.so, which is not compiled
> with +z or +Z. See a) for getting a propert client.
>
>
> Jochen
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
http://lists.mysql.com/perl?unsub=lshen@pop900.gsfc.nasa.gov
>
>

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

MySql replication or remote access

am 16.03.2004 13:40:47 von lshen

RE: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 16.03.2004 17:40:18 von Madhu.Kangara

Some time back I have published a small HOWTO on Mysql and DBD on HP 11.00 in our newsgroup. Did you read that. It might be useful. The bottom line is you need to compile atleast Mysql client yourself and then try building DBD. If you don't have costly HP C compiler, then you need to have gcc.

Madhu

-----Original Message-----
From: Simon Taylor [mailto:simon@unisolve.com.au]
Sent: Monday, March 15, 2004 6:26 PM
To: perl@lists.mysql.com
Cc: John Bolland; Simon Green; becky@unisolve.com.au
Subject: I can't get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

Hello all,

Has anyone else had this problem and beeen able to resolve it?

I can't get DBD-mysql-2.9003 to compile on any of three HPUX-11.11 machines
I have access to.

I'm using MySQL 4.0.18, (for hp-hpux11.11 on hppa2.0w), downloaded
from mysql.com today. The machines are a vanilla hpux 11.11 with perl 5.8.3
and no gcc environment installed.

The make fails with:

/usr/bin/ld: Invalid loader fixup in text space needed in output file
for symbol "$0000004B" in input file
"/usr/local/mysql/lib/libmysqlclient.a(libmysql.o)"

See below for the gory details. I would really value hearing anyone's else
experience with DBD and hpux 11.11 (BTW, I get the same problem with mysql
4.0.17).

Regards,

Simon Taylor

DETAILS:

$ perl Makefile.PL --cflags="-I/usr/local/mysql/include +DAportable"
--libs="-L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl -lm"
I will use the following settings for compiling and testing:

cflags (Users choice) = -I/usr/local/mysql/include +DAportable
libs (Users choice) = -L/usr/local/mysql/lib -lmysqlclient -lcrypt
-lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Using DBI 1.40 (for perl 5.008003 on PA-RISC2.0-thread-multi) installed in
/opt/perl5/lib/site_perl/5.8.3/PA-RISC2.0-thread-multi/auto/ DBI
Writing Makefile for DBD::mysql

$ make
cc -c
-I/opt/perl5/lib/site_perl/5.8.3/PA-RISC2.0-thread-multi/aut o/DBI
-I/usr/local/mysql/include +DAportable -D_POSIX_C_SOURCE=199506L
-D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 +O2 +Onolimit
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" +Z
"-I/opt/perl5/lib/5.8.3/PA-RISC2.0-thread-multi/CORE" dbdimp.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier: "sendfile" will have
internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier: "sendpath" will have
internal linkage.
cc -c
-I/opt/perl5/lib/site_perl/5.8.3/PA-RISC2.0-thread-multi/aut o/DBI
-I/usr/local/mysql/include +DAportable -D_POSIX_C_SOURCE=199506L
-D_REENTRANT -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 +O2 +Onolimit
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" +Z
"-I/opt/perl5/lib/5.8.3/PA-RISC2.0-thread-multi/CORE" mysql.c
cc: "/usr/include/sys/socket.h", line 504: warning 562: Redeclaration of
"sendfile" with a different storage class specifier: "sendfile" will have
internal linkage.
cc: "/usr/include/sys/socket.h", line 505: warning 562: Redeclaration of
"sendpath" with a different storage class specifier: "sendpath" will have
internal linkage.
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.sl
LD_RUN_PATH="" /usr/bin/perl myld /usr/bin/ld -b +vnocompatwarnings
-L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.sl
-L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl -lm
/usr/bin/ld: Invalid loader fixup in text space needed in output file for
symbol "$0000004B" in input file
"/usr/local/mysql/lib/libmysqlclient.a(libmysql.o)"
*** Error exit code 1

Stop.
$

--
Unisolve Pty Ltd - Melbourne, Australia
+61 3 9568 2005

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=madhu.kangara@t-mobile.com

--
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: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 16.03.2004 17:40:18 von Madhu.Kangara

Re: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 17.03.2004 00:09:39 von Simon Taylor

Hello Madhu and Jochen,

Mahdu wrote:
> Some time back I have published a small HOWTO on Mysql and DBD on HP 11.00
> in our newsgroup. Did you read that. It might be useful. The bottom line is
> you need to compile atleast Mysql client yourself and then try building
> DBD. If you don't have costly HP C compiler, then you need to have gcc.

Thanks for your reply. I've found the HOWTO you mentioned and now I'm
considering my options.

Naturally, the *last* thing I want to do is to have to compile the MySQL
client libraries from source on an architecture as foreign (to me) as HPUX
11.11, this seems an incredibly involved (and error-prone) step to undertake
just to get perl talking to MySQL. (I understand the architectural
reasons why this is necessary, but commercially I'm not sure that I can
justify the time it will no doubt take to wrestle with this build on the HP).

But thanks again for your help. And thanks also Jochen for your thoughtful
reply.

Regards,

Simon Taylor
--
Unisolve Pty Ltd - Melbourne, Australia
+61 3 9568 2005

--
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: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 17.03.2004 00:09:39 von Simon Taylor

Re: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 17.03.2004 04:14:36 von Jochen Wiedmann

Simon Taylor wrote:

> Naturally, the *last* thing I want to do is to have to compile the MySQL
> client libraries from source on an architecture as foreign (to me) as HPUX
> 11.11, this seems an incredibly involved (and error-prone) step to undertake
> just to get perl talking to MySQL.

In contrary, this is the *first* thing you should consider. Recompiling
the client is by no means "error-prone" or the like. It is simply
configure, make and make install.

If you care for existing binaries, there is no reason why you should
not have a second client library in another location.

Jochen

--
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: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 17.03.2004 04:14:36 von Jochen Wiedmann

Re: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 17.03.2004 05:16:48 von Simon Taylor

Hi Jochen,

> > Naturally, the *last* thing I want to do is to have to compile the MySQL
> > client libraries from source on an architecture as foreign (to me) as
> > HPUX 11.11, this seems an incredibly involved (and error-prone) step to
> > undertake just to get perl talking to MySQL.
>
> In contrary, this is the *first* thing you should consider. Recompiling
> the client is by no means "error-prone" or the like. It is simply
> configure, make and make install.

I wish it was always so. ;-)

Following your earlier response and some hints in the mysql documentation, I
have managed to get DBD working on one HP host, (one with a plain HP cc
compiler and no gcc/g++ environment), so I am indebted to you for your
assistance.

But this was by no means a plain "configure, make and make install".

In fact, for the sake of documenting it for others, in order to build a
libmysqlclient.a that DBD-mysql-2.9003 could link to, I had to:

1. Work out that in this vanilla HP cc environment, the machine had
no c++ compiler, which is required for the 'mysql' executable

2. Edit the MySQL "configure" script by hand to remove the checks it does
for c++/g++ compilers

3. ./configure --without-server

4. make

5. make -k to restart the make process after it falls over because it
can't make the 'mysql' executable

6. make -k install

And I'm still not clear whether or not the editing I did at step 2 was
correct, because I would have expected step 4 to succeed, and not require the
subsequent 'make -k' to recover the situation.

And now, on to another HP host with a gcc/g++ environment. I'm hopefull that
Madhu's HOWTO will help there....

> If you care for existing binaries, there is no reason why you should
> not have a second client library in another location.

Good point.

Again, my quibble isn't with MySQL code or DBD for that matter, but if you
have to work a lot with some of the more exotic Unixes *and* if you don't
always have the freedom to simply install gcc, making large packages like
MySQL from source can be vexing to say the least.

All the best,

Simon
--
Unisolve Pty Ltd - Melbourne, Australia
+61 3 9568 2005

--
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: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 17.03.2004 05:16:48 von Simon Taylor

Re: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 17.03.2004 10:14:41 von Jochen Wiedmann

Simon Taylor wrote:

> 1. Work out that in this vanilla HP cc environment, the machine had
> no c++ compiler, which is required for the 'mysql' executable
>
> 2. Edit the MySQL "configure" script by hand to remove the checks it does
> for c++/g++ compilers

Ok, then replace "configure, make, make install" with
"install gcc, configure, make, make install". :-)

I tend to have gcc installed on each Unix host within 5 minutes after my
first touch. It simplifies so many things.

Jochen

--
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: I can"t get no satisfaction (DBD-mysql-2.9003 on HPUX 11.11)

am 17.03.2004 10:14:41 von Jochen Wiedmann