DBD::Mysql and HPUX
I spent a good portion of the afternoon trying to get the perl module, DBD::mysql installed on one of our HPUX servers. I think I’ve decided it just wasn’t meant to be. The problem seems to be caused by the compilers. I downloaded the latest perl binary distribution (5.8.3) for HPUX 11.00 and then downloaded the DBI and DBD::mysql modules. I first tried compiling DBI but the compile failed. It seems the perl binary distribution I downloaded was compiled with gcc using the GNU assembler. However, my system was setup to use the HPUX assembler with gcc. I spent a while trying to figure out how to change assemblers with no luck.
Eventually I decided to try a different binary distribution (5.8.2) which had been compiled with the HPUX compiler (cc). This time the DBI module compiled and installed with no problem but the DBD::mysql failed. The cause was basically the same. Incompatibility between compilers. I tried another binary and this time DBD::mysql indicated that the mysql client was compiled without a required option. I tried to compile a new mysql client binary but that also failed (once again, due to compiler/version issues).
I was ready to try and compile perl on my own instead of using the binary but from all the information I read, it can be an even bigger hassle. I’ve yet to find a post where someone indicated they were able to get DBD::mysql running on HPUX 11.00.
Anyway at the end of the day I was no closer to getting DBD::mysql up and running and I couldn’t help but ask myself if there shouldn’t be an easier way.
UPDATE: I finally got it working. See this post.
July 22nd, 2004 at 8:28 am
I remember working with HP-UX on a daily basis and went through similar experiences trying to get things to work. If only you could just install RPMs or better yet, a simple
perl -MCPAN -e ‘install DBD:mysql’
Alas.
July 26th, 2004 at 1:11 pm
Yeah, I tried that initially but since it’s just an automated way to compile and install the module it failed. It’d be great if it really was that simple.