Re: Problems installing DBD::mysql W/ MySQL 4.2 on Debian Linux

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.

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]