HELP - compiling DBD-mysql on HP-UX 11.00

am 18.08.2003 19:50:03 von Madhu.Kangara

I am trying to compile DBD-mysql on an HP11.00 box with 32 bit gcc and 32bit
perl (compiled from source)
and I am not sucessful.

mysql_config is giving the following output
$ mysql_config
Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
--cflags [-I'/usr/local/mysql/include/mysql']
--libs [-L'/usr/local/mysql/lib/mysql' -lmysqlclient -lz -lcry
pt -lnsl -lm]
--socket [/tmp/mysql.sock]
--port [3306]
--version [4.0.13]
--libmysqld-libs [ -L'/usr/local/mysql/lib/mysql' -lmysqld -lpthread -lz
-lcrypt -lnsl -lm -lpthread -lrt]

If I do gmake with the above libs option, due to -lz option the gmake is
failing. But if I remove -lz option, gmake will be completed with out
errors, but gmake test is giving following errors and all tests are failing

PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harne
ss(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.........../usr/lib/dld.sl: Unresolved symbol: mysql_list_dbs (code)
fr
om /apps/depot/sw/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mys ql.sl
/usr/lib/dld.sl: Unresolved symbol: __udivdi3 (code) from
/apps/depot/sw/DBD-my
sql-2.1026/blib/arch/auto/DBD/mysql/mysql.sl
/usr/lib/dld.sl: Unresolved symbol: mysql_info (code) from
/apps/depot/sw/DBD-m
ysql-2.1026/blib/arch/auto/DBD/mysql/mysql.sl
/usr/lib/dld.sl: Unresolved symbol: mysql_list_fields (code) from
/apps/depot/s
w/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.sl
/usr/lib/dld.sl: Unresolved symbol: mysql_get_host_info (code) from
/apps/depot
/sw/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.sl

Any hints, tips ?
Has anyone sucessfully able to compile DBD-mysql on HP-UX ?
Please help me as I am struggling
Thanks
Madhu

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

Help for EMS MySql Manager

am 18.08.2003 20:33:08 von lshen

I try to connect to database but it comes with error message
--- Can't connect to MySQL server on xxx.xxx.xx.xx'(10061)
can anyone help? thanks

Brian shen
----- Original Message -----
From: "Kangara, Madhu"
To:
Sent: Monday, August 18, 2003 1:50 PM
Subject: HELP - compiling DBD-mysql on HP-UX 11.00

> I am trying to compile DBD-mysql on an HP11.00 box with 32 bit gcc and
32bit
> perl (compiled from source)
> and I am not sucessful.
>
> mysql_config is giving the following output
> $ mysql_config
> Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
> Options:
> --cflags [-I'/usr/local/mysql/include/mysql']
> --libs [-L'/usr/local/mysql/lib/mysql' -lmysqlclient -lz -lcry
> pt -lnsl -lm]
> --socket [/tmp/mysql.sock]
> --port [3306]
> --version [4.0.13]
> --libmysqld-libs [ -L'/usr/local/mysql/lib/mysql' -lmysqld -lpthread -lz
> -lcrypt -lnsl -lm -lpthread -lrt]
>
>
> If I do gmake with the above libs option, due to -lz option the gmake is
> failing. But if I remove -lz option, gmake will be completed with out
> errors, but gmake test is giving following errors and all tests are
failing
>
> PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harne
> ss(0, 'blib/lib', 'blib/arch')" t/*.t
> t/00base.........../usr/lib/dld.sl: Unresolved symbol: mysql_list_dbs
(code)
> fr
> om /apps/depot/sw/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mys ql.sl
> /usr/lib/dld.sl: Unresolved symbol: __udivdi3 (code) from
> /apps/depot/sw/DBD-my
> sql-2.1026/blib/arch/auto/DBD/mysql/mysql.sl
> /usr/lib/dld.sl: Unresolved symbol: mysql_info (code) from
> /apps/depot/sw/DBD-m
> ysql-2.1026/blib/arch/auto/DBD/mysql/mysql.sl
> /usr/lib/dld.sl: Unresolved symbol: mysql_list_fields (code) from
> /apps/depot/s
> w/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.sl
> /usr/lib/dld.sl: Unresolved symbol: mysql_get_host_info (code) from
> /apps/depot
> /sw/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.sl
>
> Any hints, tips ?
> Has anyone sucessfully able to compile DBD-mysql on HP-UX ?
> Please help me as I am struggling
> Thanks
> Madhu
>
>
>
> --
> 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

Help for EMS MySql Manager

am 18.08.2003 20:33:08 von lshen

RE: HELP - compiling DBD-mysql on HP-UX 11.00

am 20.08.2003 17:30:43 von Madhu.Kangara

see my command and output, I am getting same error. Could you please point
our my error in my command.

$ perl Makefile.PL --cflags="-I'/usr/local/mysql/include/mysql'"
--libs=-L'/usr
/local/mysql/lib/mysql -lmysqlclient -lcrypt -lnsl -lm
-L/usr/local/lib/gcc-li
b/hppa2.0n-hp-hpux11.00/3.2.3 -lgcc' --nocatchstderr

I will use the following settings for compiling and testing:

cflags (Users choice) = -I'/usr/local/mysql/include/mysql'
libs (Users choice) = -L/usr/local/mysql/lib/mysql -lmysqlclient
-lcr
ypt -lnsl -lm -L/usr/local/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.2.3 -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'.

Using DBI 1.37 installed in
/usr/local/lib/perl5/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/usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBI
-I'/usr/local
/mysql/include/mysql' -D_HPUX_SOURCE -fno-strict-aliasing
-D_LARGEFILE_SOURCE
-DVERSION=\"2.1026\" -DXS_VERSION=\"2.1026\" -fPIC
"-I/usr/local/lib/perl5/5.8.
0/PA-RISC2.0/CORE" dbdimp.c
/usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" <
/usr/local/lib/perl5/site_perl/
5.8.0/PA-RISC2.0/auto/DBI/Driver.xst > mysql.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap
/usr/lo
cal/lib/perl5/5.8.0/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc
mysql
..c
Warning: duplicate function definition 'do' detected in mysql.xs, line 193
Warning: duplicate function definition 'rows' detected in mysql.xs, line 291
gcc -c -I/usr/local/lib/perl5/site_perl/5.8.0/PA-RISC2.0/auto/DBI
-I'/usr/local
/mysql/include/mysql' -D_HPUX_SOURCE -fno-strict-aliasing
-D_LARGEFILE_SOURCE
-DVERSION=\"2.1026\" -DXS_VERSION=\"2.1026\" -fPIC
"-I/usr/local/lib/perl5/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/mysql/lib/mysql:/lib:/usr/local/lib/ gcc-lib/hppa2.0n
-hp-
hpux11.00/3.2.3" /usr/bin/ld -b -L/usr/local/lib -L/opt/local/lib dbdimp.o
mysq
l.o -o blib/arch/auto/DBD/mysql/mysql.sl -L/usr/local/mysql/lib/mysql
-lmysql
client -lcrypt -lnsl -lm
-L/usr/local/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.2.3 -l
gcc
/usr/bin/ld: DP relative code in file
/usr/local/mysql/lib/mysql/libmysqlclient.
a(libmysql.o) - shared library must be position
independent. Use +z or +Z to recompile.
gmake: *** [blib/arch/auto/DBD/mysql/mysql.sl] Error 1

-----Original Message-----
From: Jochen Wiedmann [mailto:joe@ispsoft.de]
Sent: Wednesday, August 20, 2003 2:18 AM
To: Kangara, Madhu
Cc: perl@lists.mysql.com
Subject: RE: HELP - compiling DBD-mysql on HP-UX 11.00

Quoting "Kangara, Madhu" :

> yes, libgcc.a exists under that directory. I also had doubts about single
> quotes. Could you please tell me what is the correct way if I want to pass
> more library paths to the --libs option

I would assume that

--libs='-L/usr/local/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.2.3 -lgcc
'

should do the trick.

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: HELP - compiling DBD-mysql on HP-UX 11.00

am 20.08.2003 17:30:43 von Madhu.Kangara

RE: HELP - compiling DBD-mysql on HP-UX 11.00

am 20.08.2003 21:15:28 von Madhu.Kangara

Adding -fPIC to cflags did not change anything. Same error message.
Adding -fPIC to --libs gave me Unrecognized argument in LIBS ignored:
'-fPIC'
-----Original Message-----
From: Jochen Wiedmann [mailto:joe@ispsoft.de]
Sent: Wednesday, August 20, 2003 12:00 PM
To: Kangara, Madhu
Cc: perl@lists.mysql.com
Subject: RE: HELP - compiling DBD-mysql on HP-UX 11.00

Quoting "Kangara, Madhu" :

> a(libmysql.o) - shared library must be position
> independent. Use +z or +Z to recompile.
> gmake: *** [blib/arch/auto/DBD/mysql/mysql.sl] Error 1

Add a -fPIC to --cflags or --libs, don't remember which. Let us know
the results.

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: HELP - compiling DBD-mysql on HP-UX 11.00

am 20.08.2003 21:15:28 von Madhu.Kangara