[MLUG] DBD::MySQL saga

["Phoebe Kempe" <EMAIL:PROTECTED>]

I am setting up a dev box and ran into some interesting difficulties with DBD::MySQL source installation.

When invoking Makefile.PL with what *appeared* the correct linker options (-I'/usr/local/mysql/include' and -L'/usr/local/mysql/lib/mysql' -lmysqlclient -lnsl -lm -lz -lcrypt), everything compiled fine but make test failed miserably (717 out of 721 tests :-( ) with one error reading "perhaps a standard library or dll is not where it is expected". After interrogating the usual suspects -- "known problems" in the documentation -- and trying all of the pertinent suggestions, I went looking for mysql_config.

Well, wouldn't you know, the mysql-3.22.30 tarball included with my version of i386-slackware-linux didn't include mysql_config. find turned up squat (a technical term in my book). After much ado, I downloaded the latest stable mysql tarball and decided to reinstall.

Fortunately, mysql-3.23.39 *does* contain mysql_config. Unfortunately, the libs linker option it output was exactly the same AND Makefile.PL kept truncating my options. 

Alas, it dawned on me that, well, I'm passing a string argument to a pl file. Hm? Perhaps I should tweak the suggested linker flag to read:

-L'/usr/local/mysql/lib/mysql -lmysqlclient -lnsl -lm -lz -lcrypt'

Bingo! make test passed. dbish is happy (a little anthropomorphism) and I upgraded in the process.

The moral of the story: don't quote me on that. 

Just thought I'd pass this on in case anyone else takes the documentation or mysql_config output too literally.

--Phoebe

BTW: I'm new to MLUG.

---

Get your FREE download of MSN Explorer at http://explorer.msn.com

--
To manage your subscription, go to http://mlug.missouri.edu/members/edit.php

Archives are available at http://mlug.missouri.edu/list-archives/