Has anyone sucessful in compiling DBD-mysql in HPUX with gcc

[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. 3 weeks back I posted another message with almost same details and some good folks
told me to compile perl myself and start . Here is the result .

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 I remove -lz option, gmake is complete fine,
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/mysql.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

[Madhu Kangara]

could some one please help me if you know the trick to fix this issue

[Madhu Kangara]

Looks like no one had tried this in HPUX.

As I am struck with this for the last 2 months, could some one please help me with trying this on your server. If you are looking for mysql libraries , I could give or you could download it from www.mysql.com

No real help from DBD-mysql or mysql newsgroup as only few newsgroup people have access to HPUX

[Madhu Kangara]

Would it be possible for you to recompile with gcc whenever you get time to check if this is a gcc issue. Or how can I get a binary version of that DBD-mysql module from you.

I don't have HP C compiler.
Could you please help me

[H.Merijn Brand (procura]

HTH http://www.cmve.net/~merijn/MySQL.tgz

From there you're on your own. Don't forget the points.

Enjoy, have FUN! H.Merijn

[Madhu Kangara]

Big thanks.
looks like I need to edit the Makefile to change all references of your /opt/perl to my /usr/local

Am I going in wrong direction or any other easy way.

[H.Merijn Brand (procura]

Could very well be the only thing to change.

Good luck. BTW what perl do you use? Where did you get it?

Enjoy, have FUN! H.Merijn

[Madhu Kangara]

sorry to tell you that that did not help me. Since I already had a perl downloaded from your website and installed in /opt/perl

I edited only the references for mysql lib and include file and tried gmake install thinking that it will be copy your already compiled DBD-mysql modules to the relevent perl locations.

Infact it started compiling modules with gcc
and I am getting same error message.
After looking at your Makefile, it looks like you also used gcc to compile
So what is my issue ?
I am running out of ideas. any tips

[H.Merijn Brand (procura]

Strange, my 32bit 5.8.1 already has some MySQL stuff:

a5:/opt 103 > find perl* -type f | grep -i mysql
perl/lib/site_perl/5.8.0/PA-RISC2.0/Bundle/DBD/mysql.pm
perl/lib/site_perl/5.8.0/PA-RISC2.0/DBD/mysql.pm
perl/lib/site_perl/5.8.0/PA-RISC2.0/DBD/mysql.pod
perl/lib/site_perl/5.8.0/PA-RISC2.0/DBD/mysql/INSTALL.pod
perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBD/mysql/mysql.sl
perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBD/mysql/mysql.bs
perl/lib/site_perl/5.8.0/PA-RISC2.0/auto/DBD/mysql/.packlist
perl/lib/site_perl/5.8.0/PA-RISC2.0/Mysql.pm
perl/lib/site_perl/5.8.0/PA-RISC2.0/Mysql/Statement.pm
perl/man/man3/Mysql.3
perl/man/man3/DBD::mysql::INSTALL.3
perl/man/man3/DBD::mysql.3
perl/man/man3/Bundle::DBD::mysql.3
a5:/opt 104 >

Do *YOU* have those? Or did you download a pa-risc1.1 version, or did I add them later for someone else?

Enjoy, have FUN! H.Merijn

[Madhu Kangara]

This is the output of REAME file under /opt/perl58 directory

This is 32 bit version of Perl 5.8 for HPUX 11.00
installed into /opt/perl/lib/site_perl/5.8.0 over the default dist:

Test-Simple 0.46
Compress::Zlib 1.16
Archive::Tar 0.22
Archive::Zip 1.01
Heap 0.50
Graph 0.201
Bit::Vector 6.1
Date::Calc 5.0
Date::Manip 5.40
DBI 1.30
Proc::ProcessTable 0.35
Text::CSV_XS 0.23
Text-Format+NWrap 0.52
Tk 800.024
Tk::Clock 0.07
Tk-TreeGraph 1.024
X11-Protocol 0.04
Devel-ptkdb 1.108
README: END

I will be happy to install your 5.8.1 perl if it has MySQL modules too

[H.Merijn Brand (procura]

Try that find command. I can't assure the README is up to date :/

If there's none, you'll have to wait till Monday for me to make those available: system is down for the weekend due to network maintainance and re-cabling

Enjoy, have FUN! H.Merijn

[Madhu Kangara]

That is fine. I could wait till Monday. Are you planning to built both 32 bit and 64 bit perl ?

BTW , here is the find output
$ pwd
/opt
$ find perl* -type f |grep -i mysql
$

Are you using gcc or HP C.
Once you built this, could you please share your compile commands so that we could try those for accadamic interest.

[H.Merijn Brand (procura · Accepted solution]

Yep. For 11.00 32- and 64-bit are already available on http://www.cmve.net/~merijn or https://www.beepz.com/personal/merijn
For 10.20 one cannot build 64bit objects, and /if/ I get that darn D370 up and running the way I want, expect 32- and 64-bit stuff for 11i soon.

Enjoy, have FUN! H.Merijn

[H.Merijn Brand (procura]

Very good. Nice info. Can you also specify 'perl -V', so this thread can act as a reference to others that try?

If you were using my perl, I am willing to put this mysql perl module on my site with your reference. I've got no idea how well different MySQL ports can works with different DBD::MySQL's but we'll find out pretty soon :)

Enjoy, have FUN! H.Merijn

[Madhu Kangara]

I verified this build with perl downloaded from HP software depot and from http://www.cmve.net/~merijn/