From: Date: November 4 2003 5:43pm Subject: RE: DBD::mysql install issues on HPUX 11.0 List-Archive: http://lists.mysql.com/perl/2548 Message-Id: <1989F6F0D512A7428593D724A81986F01B05B4@waprdms01.gsm1900.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" 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=madhu.kangara@stripped