RE: DBD::mysql install issues on HPUX 11.0

[Madhu Kangara]

Here is a small HOWTO on compiling DBD::mysql on HPUX 11.0 which I compiled
3 months back

Special thanks to Jochen.
So here is what I have done.
1) Created a new mysql client with gcc 3.2.3 with following options

$ CFLAGS="-fomit-frame-pointer -O3 -fPIC"
$ CXX=gcc
$ CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti -O3 -fPIC"
$ ./configure --without-server --prefix=/usr/local/mysqlc --with-low-memory
--enable-thread-safe-client --enable-local-infile --with-pthread
--with-lib-ccflags=-fPIC --disable-shared

$ gmake 

# gmake install

$ /usr/local/mysqlc/bin/mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4429 to server version: 4.0.13

Reading history-file /home/madhu/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


2) Then compiled DBD-mysql
$ pwd
/apps/depot/sw/DBD-mysql-2.1026

$ perl Makefile.PL --cflags="-I/usr/local/mysqlc/include/mysql"
--libs="-L/usr/l
ocal/mysqlc/lib/mysql -L/usr/local/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.2.3
-lmys
qlclient -lz -lcrypt -lnsl -lm -lgcc" --nocatchstderr
I will use the following settings for compiling and testing:

  cflags        (Users choice) = -I/usr/local/mysqlc/include/mysql
  libs          (Users choice) = -L/usr/local/mysqlc/lib/mysql
-L/usr/local/lib/
gcc-lib/hppa2.0n-hp-hpux11.00/3.2.3 -lmysqlclient -lz -lcrypt -lnsl -lm
-lgcc
  nocatchstderr (Users choice) = 1
  ssl           (guessed     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) = 
  testpassword  (default     ) = 
  testuser      (default     ) = 

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

Checking if your kit is complete...
Looks good
Using DBI 1.30 installed in
/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI
Writing Makefile for DBD::mysql
$ gmake
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/DBD/mysql.pod blib/lib/DBD/mysql.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c  -I/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI
-I/usr/local/mysqlc/
include/mysql -mpa-risc-2-0 -D_HPUX_SOURCE -fno-strict-aliasing
-I/usr/local/inc
lude -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2   -DVERSION=\"2.1026\"
-DXS_
VERSION=\"2.1026\" -fPIC "-I/opt/perl/lib/5.8.0/PA-RISC2.0/CORE"   dbdimp.c
/opt/perl/bin/perl -p -e "s/~DRIVER~/mysql/g" <
/opt/perl/lib/site_perl/5.8.0/PA
-RISC2.0/auto/DBI/Driver.xst > mysql.xsi
/opt/perl/bin/perl /opt/perl/lib/5.8.0/ExtUtils/xsubpp  -typemap
/opt/perl/lib/5
.8.0/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'rows' detected in mysql.xs, line 291
gcc -c  -I/opt/perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBI
-I/usr/local/mysqlc/
include/mysql -mpa-risc-2-0 -D_HPUX_SOURCE -fno-strict-aliasing
-I/usr/local/inc
lude -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2   -DVERSION=\"2.1026\"
-DXS_
VERSION=\"2.1026\" -fPIC "-I/opt/perl/lib/5.8.0/PA-RISC2.0/CORE"   mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.sl
LD_RUN_PATH="/usr/local/mysqlc/lib/mysql:/usr/local/lib:/lib:/usr/local/lib/
gcc-
lib/hppa2.0n-hp-hpux11.00/3.2.3" /usr/bin/ld  -b -L/usr/local/lib dbdimp.o
mysql
.o  -o blib/arch/auto/DBD/mysql/mysql.sl   -L/usr/local/mysqlc/lib/mysql
-L/usr/
local/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.2.3 -lmysqlclient -lz -lcrypt
-lnsl -l
m -lgcc  
chmod 755 blib/arch/auto/DBD/mysql/mysql.sl
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/Mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/Bundle::DBD::mysql.3
$ gmake test
PERL_DL_NONLAZY=1 /opt/perl/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harnes
s(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........ok

t/10dsnlist........ok

t/20createdrop.....ok

t/30insertfetch....ok

t/40bindparam......ok

t/40blobs..........ok

t/40listfields.....ok

t/40nulls..........ok

t/40numrows........ok

t/50chopblanks.....ok

t/50commit.........ok

        14/30 skipped: No transactions
t/60leaks..........skipped
        all skipped: no reason given
t/ak-dbd...........ok

t/akmisc...........ok

t/dbdadmin.........ok

t/insertid.........ok

t/mysql............ok

t/mysql2...........ok

All tests successful, 1 test and 14 subtests skipped.
Files=18, Tests=765, 25 wallclock secs ( 4.10 cusr +  0.30 csys =  4.40 CPU)

With regards
Madhu

-----Original Message-----
From: Jochen Wiedmann [mailto:joe@stripped]
Sent: Monday, November 03, 2003 10:16 PM
To: Keith Paschal
Cc: perl@stripped
Subject: Re: DBD::mysql install issues on HPUX 11.0


Keith Paschal wrote:

> I would say this is not a valid fix:
> 
> # /opt/perl/bin/perl Makefile.PL --libs="-L/other/mysql/lib 
> -lmysqlclient -lcrypt -lnsl -lm +Z"

Sorry, didn't notice that you are using gcc and not the HP compiler.
It's -fPIC then.


Jochen


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=1