Perl DBD-mysql install problem

[Madhu Kangara]

I am getting errors while compiling DBD-mysql 2.9002 on HP-UX 11.00
I have perl 5.8 downloaded from HP depot installed at /opt/perl
Mysql 4.0.13 compiled myself with gcc with Mysql recommended options and working fine

I am getting this error

....
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:/usr/local/lib:/lib" /opt/perl/bin/perl
myld gcc -shared -static-libgcc -fPIC dbimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.sl -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
gmake: *** [blib/arch/auto/DBD/mysql/mysql.sl] Error 1

How can I fix this ?, any tips?

Thanks

[Kevin Wright]

I had a problem building DBD::oracle the other day with the depot perl. I rebuilt perl 5.8 myself, using just the HP ANSI C compiler, then the module built correctly.

You may want to try building your own perl.

[James Specht]

I ran into this problem myself many times. The mysql objects used in the PERL build are not compatible with mysql 4.0s. I find this to be a problem with the pre-built depots. You have to use the same support objects as were used in the build. It makes sense, don't get me wrong, but I like to use the latest and greatest programs myself, not ones built months ago. I try to compile everything from the source to avoid these problems. It may take a little longer at first, but it is well worth it in the long run. Any upgrades you wish to do will be easier also.

My 2 cents.

[Madhu Kangara]

So you mean, I need to start compiling my own perl , (I have already compiled my own mysql and php) and then try building DBD-mysql

Sounds OK

But I have only gcc. Any issues you see at front


Thanks

[Madhu Kangara]

As I am not conviced about the posting that I need to compile my own perl to overcome this issue, I downloaded 32 bit perl binary for HP11.00 (my mysql is 32bit) and tried compiling DBD-mysql.
Same error.
BTW , I am trying with Mysql 4.0.13

So Does anyone sucessfully compiled DBD-mysql with Mysql 4 series on HP 11.00 with gcc

[Kevin Wright]

Don't take anyone's word for it, try it yourself. I am just telling you that's how it worked for me..I however used HP's CC compiler...it should take you less than an hour to build a new perl, and try to build your modules again.