One more time: install using static libmysqlclient.a, not root

am 01.07.2002 23:28:18 von kip

Hello,

I wasn't subscribed to the list when I first sent out this message, and
I'm not sure if it went out. If someone did respond, I would appreciate
it if they forwarded the message(s) to me.

Sorry for the mixup,
Kip

---------- Forwarded message ----------
Date: Fri, 28 Jun 2002 13:31:07 -0400 (EDT)
From: Kip C. Lubliner
Reply-To: kip@jhuacm.org
To: msql-mysql-modules@lists.mysql.com
Subject: install using static libmysqlclient.a, not root

Hello,
I am trying to install DBD::Mysql on a freeBSD box. MySQL isn't installed
as root, it is installed in the user directory.

I wasn't the one to install the Mysql server, but the following files
exist:

~/usr/local/mysql/lib/mysql/libmysqlclient.a
~/usr/local/mysql/include/mysql/mysql.h

I have installed DBD and Data::ShowTable to
~/perllibs
by using CPAN, setting LIB= that dir.

I am trying to install DBD::Mysql via
perl LIB=~/perllibs --cflags=-I~/usr/local/mysql/include/mysql \
--libs='-L~/usr/local/mysql/lib/mysql -lmysqlclient'

Then 'make' works. When I try to do 'make test', I get the following
error message:

PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.
6.1/i386-freebsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base............install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD
/mysql/mysql.so' for module DBD::mysql: blib/arch/auto/DBD/mysql/mysql.so: Undef
ined symbol "mysql_real_escape_string" at /usr/local/lib/perl5/5.6.1/i386-freebs
d/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/00base.t line 38

If anyone knows what I am doing wrong, I would appreciate being clued in.
Thanks a bunch,
Kip.

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1842@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: One more time: install using static libmysqlclient.a, not root

am 01.07.2002 23:51:52 von Jay Lawrence

Kip,

Maybe you need to add a "-static" option to your CFLAGS when you run
Makefile.PL. Haven't built a static linked DBD myself....

Jay

On July 1, 2002 05:28 pm, Kip C. Lubliner wrote:
> Hello,
>
> I wasn't subscribed to the list when I first sent out this message, and
> I'm not sure if it went out. If someone did respond, I would appreciate
> it if they forwarded the message(s) to me.
>
> Sorry for the mixup,
> Kip
>
> ---------- Forwarded message ----------
> Date: Fri, 28 Jun 2002 13:31:07 -0400 (EDT)
> From: Kip C. Lubliner
> Reply-To: kip@jhuacm.org
> To: msql-mysql-modules@lists.mysql.com
> Subject: install using static libmysqlclient.a, not root
>
> Hello,
> I am trying to install DBD::Mysql on a freeBSD box. MySQL isn't installed
> as root, it is installed in the user directory.
>
> I wasn't the one to install the Mysql server, but the following files
> exist:
>
> ~/usr/local/mysql/lib/mysql/libmysqlclient.a
> ~/usr/local/mysql/include/mysql/mysql.h
>
>
>
> I have installed DBD and Data::ShowTable to
> ~/perllibs
> by using CPAN, setting LIB= that dir.
>
>
> I am trying to install DBD::Mysql via
> perl LIB=~/perllibs --cflags=-I~/usr/local/mysql/include/mysql \
> --libs='-L~/usr/local/mysql/lib/mysql -lmysqlclient'
>
> Then 'make' works. When I try to do 'make test', I get the following
> error message:
>
> PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
> -I/usr/local/lib/perl5/5. 6.1/i386-freebsd -I/usr/local/lib/perl5/5.6.1 -e
> 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;'
> t/*.t
> t/00base............install_driver(mysql) failed: Can't load
> 'blib/arch/auto/DBD /mysql/mysql.so' for module DBD::mysql:
> blib/arch/auto/DBD/mysql/mysql.so: Undef ined symbol
> "mysql_real_escape_string" at /usr/local/lib/perl5/5.6.1/i386-freebs
> d/DynaLoader.pm line 206.
> at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at t/00base.t line 38
>
>
>
> If anyone knows what I am doing wrong, I would appreciate being clued in.
> Thanks a bunch,
> Kip.
>
>
>
> ------------------------------------------------------------ ---------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail
> msql-mysql-modules-thread1842@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1843@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: One more time: install using static libmysqlclient.a, not root

am 01.07.2002 23:51:52 von Jay Lawrence

Re: One more time: install using static libmysqlclient.a, not root

am 02.07.2002 23:11:19 von kip

After much digging, I discovered that I am running MySQL 3.22, which
doesn't have the 'mysql_real_escape_string' function. I replaced it with
the 'mysql_escape_string' function, which doesn't respect locales, thusly:

// dbdimp.c

#if defined(WIN32) && defined(WORD)
/* Don't exactly know who's responsible for defining WORD ... :-( */
#undef WORD
typedef short WORD;
#endif

#if MYSQL_VERSION_ID < 32314
#define mysql_real_escape_string(ignore, to, from, from_length) \
mysql_escape_string(to, from, from_length)
#endif

DBISTATE_DECLARE;

On Mon, 1 Jul 2002, Jay Lawrence wrote:

>
> Kip,
>
> Maybe you need to add a "-static" option to your CFLAGS when you run
> Makefile.PL. Haven't built a static linked DBD myself....
>
> Jay
>
> On July 1, 2002 05:28 pm, Kip C. Lubliner wrote:
> > Hello,
> >
> > I wasn't subscribed to the list when I first sent out this message, and
> > I'm not sure if it went out. If someone did respond, I would appreciate
> > it if they forwarded the message(s) to me.
> >
> > Sorry for the mixup,
> > Kip
> >
> > ---------- Forwarded message ----------
> > Date: Fri, 28 Jun 2002 13:31:07 -0400 (EDT)
> > From: Kip C. Lubliner
> > Reply-To: kip@jhuacm.org
> > To: msql-mysql-modules@lists.mysql.com
> > Subject: install using static libmysqlclient.a, not root
> >
> > Hello,
> > I am trying to install DBD::Mysql on a freeBSD box. MySQL isn't installed
> > as root, it is installed in the user directory.
> >
> > I wasn't the one to install the Mysql server, but the following files
> > exist:
> >
> > ~/usr/local/mysql/lib/mysql/libmysqlclient.a
> > ~/usr/local/mysql/include/mysql/mysql.h
> >
> >
> >
> > I have installed DBD and Data::ShowTable to
> > ~/perllibs
> > by using CPAN, setting LIB= that dir.
> >
> >
> > I am trying to install DBD::Mysql via
> > perl LIB=~/perllibs --cflags=-I~/usr/local/mysql/include/mysql \
> > --libs='-L~/usr/local/mysql/lib/mysql -lmysqlclient'
> >
> > Then 'make' works. When I try to do 'make test', I get the following
> > error message:
> >
> > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
> > -I/usr/local/lib/perl5/5. 6.1/i386-freebsd -I/usr/local/lib/perl5/5.6.1 -e
> > 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;'
> > t/*.t
> > t/00base............install_driver(mysql) failed: Can't load
> > 'blib/arch/auto/DBD /mysql/mysql.so' for module DBD::mysql:
> > blib/arch/auto/DBD/mysql/mysql.so: Undef ined symbol
> > "mysql_real_escape_string" at /usr/local/lib/perl5/5.6.1/i386-freebs
> > d/DynaLoader.pm line 206.
> > at (eval 1) line 3
> > Compilation failed in require at (eval 1) line 3.
> > Perhaps a required shared library or dll isn't installed where expected
> > at t/00base.t line 38
> >
> >
> >
> > If anyone knows what I am doing wrong, I would appreciate being clued in.
> > Thanks a bunch,
> > Kip.
> >
> >
> >
> > ------------------------------------------------------------ ---------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> > posting. To request this thread, e-mail
> > msql-mysql-modules-thread1842@lists.mysql.com
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.
>
>
> ------------------------------------------------------------ ---------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail msql-mysql-modules-thread1843@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.
>

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1844@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: One more time: install using static libmysqlclient.a, not root

am 02.07.2002 23:11:19 von kip