10 messages in com.mysql.lists.perlRe: Problems installing DBD::mysql W/...
FromSent OnAttachments
Hal Vaughan29 Aug 2004 02:10 
Rudy Lippan29 Aug 2004 17:45 
Hal Vaughan30 Aug 2004 08:07 
Dan Bolser30 Aug 2004 09:46 
Hal Vaughan30 Aug 2004 09:58 
Dan Bolser30 Aug 2004 09:59 
Hal Vaughan30 Aug 2004 10:06 
Dan Bolser30 Aug 2004 10:24 
Dan Bolser30 Aug 2004 10:42 
Hal Vaughan30 Aug 2004 11:34 
Subject:Re: Problems installing DBD::mysql W/ MySQL 4.2 on Debian Linux
From:Hal Vaughan (ha@thresholddigital.com)
Date:08/30/2004 08:07:24 AM
List:com.mysql.lists.perl

On Sunday 29 August 2004 08:45 pm, Rudy Lippan wrote:

On Sun, 29 Aug 2004, Hal Vaughan wrote:

So what can I do to install this?  I'd prefer to get it working with the later version of MySQL, but if I have to wipe that and go with apt-get packages, I can do that.  At this point, I ma very frustrated because it's not working with the "official" package and it doesn't work with the Debian .deb files (they don't include mysql_config, and it always complains about not finding that).

the missing net_buffer_lengh symbol normally means that the mysql libraries cannot be found; however, I vaguely remember a problem with the later 4.1.x servers when MYSQL_CLIENT is not defined. So if you can build DBD::mysql against an older mysql, you might want to try looking at adding a -DMYSQL_CLIENT(sp) to the Makefile (or makefile.pl) otherwise look into making sure that DBD::mysql can find the mysql libraries.

And of course, I would like to know what the solution ended up being so that I can change Makefile.PL if needed.

Okay, here's what worked. Some of this is the same.

I unpacked MySQL 4.2 and installed it to /usr/local/mysql. cp /usr/local/mysql/lib/* /usr/lib/* cp /usr/local/mysql/include/* /usr/include/

THEN I did perl Makefile.PL ... etc. and it worked.

I had tried to install a number of times the Debian way -- by apt-get'ing mysql-common, mysql-server, libdbd-mysql-perl and, I think, 2 other packages (as per instructions in DBD::MySQL). I would get an error because it couldn't find mysql_config. I know absolutely nothing about C and compiling C. I also don't know if Debian is supposed to have .debs for Perl modules, but it would seem to me for this to work well on Debian based systems, that it would be necessary to find a way to bypass mysql_config or, since it's a Perl script, and open source, would it be possible to just incorporate it into the DBD::mysql package? (I don't know -- I've never done any packaging, but it's just a thought).

Hal

Rudy.