Scott,
Better success this time. I first had to symlink mysql_config to
/usr/local/bin as it was not in my path, and the module expects it to be:
************
ln -s /opt/mysql/bin/mysql_config /usr/local/bin/.
************
Then I ran the following with success:
************
nanokov:/home/vlima/DBD-mysql-2.9004> perl Makefile.PL
"--libs=-L</opt/mysql/lib -lmysqlclient"
I will use the following settings for compiling and testing:
cflags (mysql_config) = -I'/opt/mysql/include/mysql'
libs (Users choice) = -L</opt/mysql/lib -lmysqlclient
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'.
Note (probably harmless): No library found for -lmysqlclient
Using DBI 1.21 installed in
/opt/perl/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI
Writing Makefile for DBD::mysql
**************
Then I ran make:
**************
nanokov:/home/vlima/DBD-mysql-2.9004> make
gcc -c -I/opt/perl/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI
-I'/opt/mysql/include/mysql' -fno-strict-aliasing -O -DVERSION=\"2.9004\"
-DXS_VERSION=\"2.9004\" -fpic -I/opt/perl/lib/5.6.1/9000/800-hpux/CORE
dbdimp.c
In file included from /usr/include/locale.h:157,
from /opt/perl/lib/5.6.1/9000/800-hpux/CORE/perl.h:465,
from
/opt/perl/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI/DBIXS.h:19,
from dbdimp.h:20,
from dbdimp.c:19:
/opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.3/include/stdio.h:30:
warning: `__va__list' redefined
/usr/include/locale.h:26: warning: this is the location of the previous
definition
In file included from /opt/perl/lib/5.6.1/9000/800-hpux/CORE/perl.h:482,
from
/opt/perl/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI/DBIXS.h:19,
from dbdimp.h:20,
from dbdimp.c:19:
/usr/include/setjmp.h:26: warning: `__va__list' redefined
/opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.3/include/stdio.h:30:
warning: this is the location of the previous definition
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" <
/opt/perl/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI/Driver.xst >
mysql.xsi
/usr/bin/perl -I/opt/perl/lib/5.6.1/9000/800-hpux
-I/opt/perl/lib/5.6.1 /opt/perl/lib/5.6.1/ExtUtils/xsubpp -typemap
/opt/perl/lib/5.6.1/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc
mysql.c
Warning: duplicate function definition 'rows' detected in mysql.xs, line
294
gcc -c -I/opt/perl/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI
-I'/opt/mysql/include/mysql' -fno-strict-aliasing -O -DVERSION=\"2.9004\"
-DXS_VERSION=\"2.9004\" -fpic -I/opt/perl/lib/5.6.1/9000/800-hpux/CORE
mysql.c
In file included from /usr/include/locale.h:157,
from /opt/perl/lib/5.6.1/9000/800-hpux/CORE/perl.h:465,
from
/opt/perl/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI/DBIXS.h:19,
from dbdimp.h:20,
from mysql.xs:14:
/opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.3/include/stdio.h:30:
warning: `__va__list' redefined
/usr/include/locale.h:26: warning: this is the location of the previous
definition
In file included from /opt/perl/lib/5.6.1/9000/800-hpux/CORE/perl.h:482,
from
/opt/perl/lib/site_perl/5.6.1/9000/800-hpux/auto/DBI/DBIXS.h:19,
from dbdimp.h:20,
from mysql.xs:14:
/usr/include/setjmp.h:26: warning: `__va__list' redefined
/opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/2.95.3/include/stdio.h:30:
warning: this is the location of the previous definition
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 ld -b -L/usr/local/lib dbdimp.o
mysql.o -o blib/arch/auto/DBD/mysql/mysql.sl
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/DBD::mysql::INSTALL.3
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/Bundle::DBD::mysql.3
Manifying blib/man3/Mysql.3
nanokov:/home/vlima/DBD-mysql-2.9004>
***************
Again, my perl information:
***************
nanokov:/home/vlima/DBD-mysql-2.9004> perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=hpux, osvers=11.00, archname=9000/800-hpux
uname='hp-ux nanokov b.11.00 a 9000800 130931527 two-user license '
config_args='-Dcc=gcc -Dprefix=/opt/perl'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='gcc', ccflags ='-fno-strict-aliasing',
optimize='-O',
cppflags='-fno-strict-aliasing'
ccversion='', gccversion='2.95.3 20010315 (release)',
gccosandvers='hpux11.00'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=4
alignbytes=8, usemymalloc=y, prototype=define
Linker and Libraries:
ld='ld', ldflags =' -L/usr/local/lib'
libpth=/opt/gcc/lib /usr/local/lib /lib /usr/lib
libs=-lnsl -lnm -lndbm -ldbm -ldld -lm -lc -lndir -lcrypt -lsec -lBSD
-lPW
perllibs=-lnsl -lnm -ldld -lm -lc -lndir -lcrypt -lsec -lBSD -lPW
libc=/usr/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fpic', lddlflags='-b -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under hpux
Compiled at Feb 5 2002 16:07:56
@INC:
/opt/perl/lib/5.6.1/9000/800-hpux
/opt/perl/lib/5.6.1
/opt/perl/lib/site_perl/5.6.1/9000/800-hpux
/opt/perl/lib/site_perl/5.6.1
/opt/perl/lib/site_perl
.**************************
And my operating system info:
nanokov:/home/vlima/DBD-mysql-2.9004> uname -a
HP-UX nanokov B.11.00 A 9000/800 130931527 two-user license
Hope this helps.
Vinnie.
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use of
e-mail for such purpose.
----------------------------------------------------------------------------------------
"NIPP, SCOTT V \(SBCSI\)" <sn4265
@sbc.com>
08/20/2004 12:56 PM
To: <[EMAIL PROTECTED]>
cc:
Subject: DBD driver compile on HP...
I know that this question has come up before. I think I
have
even asked it long, long ago. Unfortunately, this is not something I do
even infrequently, more like once in a blue moon. The problem is once
again getting DBD::MySQL to compile and play nice on HP-UX. Here are
the errors I am seeing:
system(root):/home/user/perl/DBD-mysql-2.9004# make
gcc -c
-I/opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi/auto/DBI
-I'/usr/include/mysql' -DDBD_MYSQL_WITH_SSL -D_POSIX_C_SOURCE=199506L
-D_HPUX_SOURCE -L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC
-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"2.9004\"
-DXS_VERSION=\"2.9004\" -fPIC
-I/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE dbdimp.c
cc1: warning: changing search order for system directory
"/usr/local/include"
cc1: warning: as it has already been specified as a non-system
directory
In file included from
/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE/perl.h:713,
from
/opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi/auto/DBI/DBIXS.h:1
9,
from dbdimp.h:20,
from dbdimp.c:19:
/usr/include/sys/socket.h:484: parse error before "sendfile"
/usr/include/sys/socket.h:485: parse error before "bsize_t"
/usr/include/sys/socket.h:486: parse error before "sendpath"
/usr/include/sys/socket.h:487: parse error before "bsize_t"
/usr/include/sys/socket.h:501: parse error before "__sendfile64"
/usr/include/sys/socket.h:501: parse error before "bsize_t"
/usr/include/sys/socket.h:502: parse error before "__sendpath64"
/usr/include/sys/socket.h:502: parse error before "bsize_t"
/usr/include/sys/socket.h:504: parse error before "sendfile"
/usr/include/sys/socket.h: In function `sendfile':
/usr/include/sys/socket.h:504: parse error before "bsize_t"
/usr/include/sys/socket.h: At top level:
/usr/include/sys/socket.h:505: parse error before "sendpath"
/usr/include/sys/socket.h: In function `sendpath':
/usr/include/sys/socket.h:505: parse error before "bsize_t"
*** Error exit code 1
Stop.
Here is the Perl information...
system(root):/home/user/perl/DBD-mysql-2.9004# perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=hpux, osvers=11.00, archname=PA-RISC1.1-thread-multi
uname='hp-ux llbertha b.11.00 u 9000800 2002402864 unlimited-user
license '
config_args='-des -Dcf_by=ActiveState
[EMAIL PROTECTED] -Uinstallusrbinperl -Dusethreads
-Duseithreads -Duselargefiles -Dinc_version_list=5.6.0/$archname 5.6.0
-Dcc=gcc -Accflags=-mpa-risc-1-1 -fPIC -Dcccdlflags=-fPIC
-Dd_attribut=undef -Darchname=PA-RISC1.1 -Dprefix=/opt/perl'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='gcc', ccflags ='-D_POSIX_C_SOURCE=199506L -D_HPUX_SOURCE
-L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC
-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-D_POSIX_C_SOURCE=199506L -D_HPUX_SOURCE -L/lib/pa1.1
-DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC -fno-strict-aliasing
-I/usr/local/include'
ccversion='', gccversion='2.9-hppa-991112', gccosandvers='hpux11.00'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, usemymalloc=n, prototype=define
Linker and Libraries:
ld='ld', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lnsl -lnm -lndbm -lmalloc -ldld -lm -lpthread -lc -lndir
-lcrypt -lsec
perllibs=-lnsl -lnm -lmalloc -ldld -lm -lpthread -lc -lndir -lcrypt
-lsec
libc=/lib/libc.sl, so=sl, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=undef, ccdlflags='-Wl,-E '
cccdlflags='-fPIC', lddlflags='-b -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
PERL_IMPLICIT_CONTEXT
Locally applied patches:
ActivePerl Build 627
Built under hpux
Compiled at Jun 20 2001 21:42:53
@INC:
/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi
/opt/perl/lib/5.6.1
/opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi
/opt/perl/lib/site_perl/5.6.1
/opt/perl/lib/site_perl
.
Thanks for the help. Sorry for asking the same question
yet
again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
