A list about the Perl support for MySQL with msql-mysql-modules.

Thomas Whitney | 5 Aug 2003 04:52

RE:same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Hi,

I suppose there is some comfort in the fact that others are having the same
problem but it is minimal.

I too am having the problem with symbol net_buffer_length while doing a make
test with  DBD::mysql.

I am using:
Debian linux  with 2.2 kernel
gcc 2.95.4
perl 5.8.0      - built from source using gcc

mysql 3.23.57   - built form source using the following

CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions \
-fno-rtti" ./configure --prefix=/usr/local/mysql --enable-assembler \
--with-mysqld-ldflags=-all-static

  Note:*  I also tried DBD::mysql make test on a build of mysql 4.0.14 and
the result was the same.   Both mysql  versions run and tested correctly.

DBI 1.37
DBD::mysql 2.9002  - built using the following

perl Makefile.PL --cflags=-I/usr/local/mysql/include/mysql \
--libs=-L/usr/local/mysql/lib/mysql -lmysqlclient -lcrypt -lnsl -lm

and then tried the above adding the following line - still the same result
-L/usr/lib/gcc-lib/i386-linux/2.95.4 -lgcc

(Continue reading)

Rudy Lippan | 5 Aug 2003 15:30

RE:same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

On Mon, 4 Aug 2003, Thomas Whitney wrote:

> Hi,

Hi.

> I suppose there is some comfort in the fact that others are having the same
> problem but it is minimal.
> 
> I too am having the problem with symbol net_buffer_length while doing a make
> test with  DBD::mysql.

Just a guess, but is it possible that you are linking against a 
libmysqlclient.so and then not having it in your LD_LIBRARY_PATH?

maybe try something like:
LD_LIBRARY_PATH=/usr/local/mysql/lib/ make test
LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql/ make test

or 'locate libmysqlclient.so'

Another thing to try is running 'ldd mysql.so' so see what it is linking 
against.

Rudy

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

(Continue reading)

Thomas Whitney | 5 Aug 2003 16:53

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Rudy,

My libmysqlclient.so is located at '/usr/lib/mysql/lib'.  So I tried

   > LD_LIBRARY_PATH=/usr/local/mysql/lib/ make test

That produced the same result.

   > Another thing to try is running 'ldd mysql.so' so see what it is
linking
   > against.

I did that and it did link to something but I cannot tell you what right now
because I shut the computer down and sent it off so I could get it connected
directly to the internet.

Thanks for your suggestions.

-Thomas

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Jim Cromie | 6 Aug 2003 09:27

Re: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Thomas Whitney wrote:

>Rudy,
>
>My libmysqlclient.so is located at '/usr/lib/mysql/lib'.  So I tried
>
>   > LD_LIBRARY_PATH=/usr/local/mysql/lib/ make test
>
>That produced the same result.
>  
>

you need to be more precise:

your lib is in         /usr/lib/mysql,
 but you tried       /usr/local/mysql/lib

Rudy said this, but not quite so EXPLICITLY

youve had some success, but apparently are still having issues.
double check your paths, its often hard to see these things, even as 
they stare back at you.

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Thomas Whitney | 6 Aug 2003 13:31

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

    > > My libmysqlclient.so is located at '/usr/lib/mysql/lib'.  So I tried

Oops, that line left out 'local'

  > your lib is in         /usr/lib/mysql,

My lib is actually at /usr/local/mysql/lib

  > you need to be more precise:

Sure enough, programming is a precise art. It helps to be precise even in
emails -- it helps prevent confusion.

- Thomas

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Rudy Lippan | 5 Aug 2003 16:56

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

On Tue, 5 Aug 2003, Thomas Whitney wrote:

> Rudy,
> 

Ok I have my computer doing the same thing now.  I have not had much of a 
chance to look into this -- and I am about to head off for work; however, 
I will give you what I have so far: 

> My libmysqlclient.so is located at '/usr/lib/mysql/lib'.  So I tried
> 
>    > LD_LIBRARY_PATH=/usr/local/mysql/lib/ make test
> 
> That produced the same result.

This will work:

LD_PRELOAD=/usr/local/mysql/lib/mysql/libmysqlclient.so make test

> 
>    > Another thing to try is running 'ldd mysql.so' so see what it is
> linking
>    > against.
> 
> I did that and it did link to something but I cannot tell you what right now
> because I shut the computer down and sent it off so I could get it connected
> directly to the internet.
> 

mysql.so is not saying that it needs libmysqlcleint.so; however, it is

(Continue reading)

Thomas Whitney | 5 Aug 2003 19:23

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Rudy and all,

I emailed before I had tested it in Apache.

      > LD_PRELOAD=/usr/local/mysql/lib/mysql/libmysqlclient.so make test

It worked for make test, BUT when you run a configtest in Apache after the
make install this happens.

Tue Aug  5 04:59:13 2003] [error] Can't load
'/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at
/usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm line 229.

So it appears that it fixed it for the test but not for the install.

- Thomas

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Karen Ventura | 5 Aug 2003 19:30

Picon

Picon

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Thomas,

Right - I had a similar problem with the application I was using DBD with
(Movable Type) - the error reappeared.  I emailed Rudy direct as well.
Somehow we have to set this directory permanently, not just for the make
test.

	Karen

-----Original Message-----
From: Thomas Whitney [mailto:trwhitney <at> centervision.com]
Sent: Tuesday, August 05, 2003 1:24 PM
To: Rudy Lippan
Cc: perl <at> lists.mysql.com
Subject: RE: same problem with symbol net_buffer_length not found with
'make test' for DBD::mysql

Rudy and all,

I emailed before I had tested it in Apache.

      > LD_PRELOAD=/usr/local/mysql/lib/mysql/libmysqlclient.so make test

It worked for make test, BUT when you run a configtest in Apache after the
make install this happens.

Tue Aug  5 04:59:13 2003] [error] Can't load
'/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so:

(Continue reading)

Thomas Whitney | 5 Aug 2003 19:04

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql


Rudy,

	> This will work:

	> LD_PRELOAD=/usr/local/mysql/lib/mysql/libmysqlclient.so make test

 That did work.  Thank You! (It was so nice not to see all those FAILED's
and DIED's)

 -Thomas

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Michael Koch | 5 Aug 2003 19:07

Picon

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Hello all,

At last some good news on this !
I didn't test it yet because I was in the process of completely scratching
my install. But as it solved the problem for all of you I'm confident )

Rudy, I would like to understand why the LD_PRELOAD has solved this issue.
Could you explain it ? 

Michael

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Rudy Lippan | 5 Aug 2003 19:57

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

On Tue, 5 Aug 2003, Michael Koch wrote:

> Hello all,
> 
> At last some good news on this !
> I didn't test it yet because I was in the process of completely scratching
> my install. But as it solved the problem for all of you I'm confident )
> 
> Rudy, I would like to understand why the LD_PRELOAD has solved this issue.
> Could you explain it ? 

Setting the LD_PRELOAD tells the linker to load the library before loading 
other libraries, so by loading mysql.so net_buffer_length is already in 
memory before mysql.so looks for it.

This was  was just a hack to get it to pass the tests :) Now, if you 
want LD_PRELOAD to hang around you can export it, like so, 'export 
LD_PRELOAD=<path to lib>'  But this is not a solution, just a hack :)

Rudy

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Karen Ventura | 5 Aug 2003 20:37

Picon

Picon

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Rudy,

So is there something that would be a solution?  Is there a reason that it
doesn't load this library so that it can be found?

	Karen

-----Original Message-----
From: Rudy Lippan [mailto:rlippan <at> remotelinux.com]
Sent: Tuesday, August 05, 2003 1:58 PM
To: Michael Koch
Cc: trwhitney <at> centervision.com; Rudy Lippan; kknox <at> tln.lib.mi.us;
perl <at> lists.mysql.com
Subject: RE: same problem with symbol net_buffer_length not found with
'make test' for DBD::mysql

On Tue, 5 Aug 2003, Michael Koch wrote:

> Hello all,
>
> At last some good news on this !
> I didn't test it yet because I was in the process of completely scratching
> my install. But as it solved the problem for all of you I'm confident )
>
> Rudy, I would like to understand why the LD_PRELOAD has solved this issue.
> Could you explain it ? 

Setting the LD_PRELOAD tells the linker to load the library before loading
other libraries, so by loading mysql.so net_buffer_length is already in
memory before mysql.so looks for it.

(Continue reading)

Rudy Lippan | 5 Aug 2003 23:12

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

On Tue, 5 Aug 2003, Karen Ventura wrote:

> Rudy,
> 
> So is there something that would be a solution?  Is there a reason that it
> doesn't load this library so that it can be found?
> 

Try this:

make
cc  -shared -L/usr/local/mysql/lib/mysql -L/usr/local/lib dbdimp.o 
mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so -lmysqlclient -lz

make test

Rudy

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Thomas Whitney | 6 Aug 2003 00:25

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Rudy,

It is also failing most of the test for me.
I did the following

make clean

perl Makefile.PL --cflags=-I/usr/local/mysql/include/mysql \
--libs=-L/usr/local/mysql/lib/mysql -lmysqlclient -lcrypt -lnsl -lm

make

cc  -shared -L/usr/local/mysql/lib/mysql -L/usr/local/lib dbdimp.o \
mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so -lmysqlclient

(* Note: I left off -lz because I get an error - can't find -lz.)

make test

== Make Test Result ====================

PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........install_driver(mysql) failed: Can't load
'/usr/local/src/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No
such file or directory at
/usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm line 229.
 at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.

(Continue reading)

Rudy Lippan | 6 Aug 2003 01:05

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

On Tue, 5 Aug 2003, Thomas Whitney wrote:

> It is also failing most of the test for me.
> I did the following
> 
> make clean
> 
> perl Makefile.PL --cflags=-I/usr/local/mysql/include/mysql \
> --libs=-L/usr/local/mysql/lib/mysql -lmysqlclient -lcrypt -lnsl -lm
> 
> make
> 
> cc  -shared -L/usr/local/mysql/lib/mysql -L/usr/local/lib dbdimp.o \
> mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so -lmysqlclient
> 
> (* Note: I left off -lz because I get an error - can't find -lz.)
> 
> make test
> 
> == Make Test Result ====================
> 
> PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/00base...........install_driver(mysql) failed: Can't load
> '/usr/local/src/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mysql.so' for
> module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No

Much better.  You just need to tell your system where to find
libmysqlclient.so.12; so :

(Continue reading)

Thomas Whitney | 6 Aug 2003 01:48

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Rudy,

> Much better.  You just need to tell your system where to find
> libmysqlclient.so.12; so :

> export LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql <or whatever your path
> to libmysqlclient.so.12 is.

> make test;

Very Good! That did it - all tests were successful.  It installed and Apache
was happy.
Might be a little tough to explain whats going on in a INSTALL file, but it
sure works.

Thank You for your help!
- Thomas

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

Karen Ventura | 5 Aug 2003 23:58

Picon

Picon

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Rudy,

When I try this, the make test fails miserably again, just like before.

But - as I look at the error - it's different.  Now it's more like:

install_driver(mysql) failed: Can't load
'/usr/local/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such
file or directory at /usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm
line 229.
 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/30insertfetch.t line 48

Hmmm...

	Karen

-----Original Message-----
From: Rudy Lippan [mailto:rlippan <at> remotelinux.com]
Sent: Tuesday, August 05, 2003 5:12 PM
To: Karen Ventura
Cc: Rudy Lippan; Michael Koch; trwhitney <at> centervision.com;
perl <at> lists.mysql.com
Subject: RE: same problem with symbol net_buffer_length not found with
'make test' for DBD::mysql

On Tue, 5 Aug 2003, Karen Ventura wrote:

(Continue reading)

Karen Ventura | 5 Aug 2003 18:41

Picon

Picon

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

Yes!  This did work.  Thank you, Rudy!!

I used your suggestion of:
	LD_PRELOAD=/usr/local/mysql/lib/mysql/libmysqlclient.so make test

And all tests were successful!

Then I was able to do a "make install" without a problem.

Now...back to what I was doing that required DBD in the first place - let's
see if I can get THAT working!

Thanks again VERY much, Rudy!!

	Karen

-----Original Message-----
From: Rudy Lippan [mailto:rlippan <at> remotelinux.com]
Sent: Tuesday, August 05, 2003 10:56 AM
To: Thomas Whitney
Cc: Rudy Lippan; perl <at> lists.mysql.com
Subject: RE: same problem with symbol net_buffer_length not found with
'make test' for DBD::mysql

On Tue, 5 Aug 2003, Thomas Whitney wrote:

> Rudy,
>

Ok I have my computer doing the same thing now.  I have not had much of a

(Continue reading)

kryptoer | 5 Aug 2003 22:28

Picon

RE: same problem with symbol net_buffer_length not found with 'make test' for DBD::mysql

I have not tried Rudy's suggestion yet. But I actually
was able to get DBD::mysl to make test and install
succesfully. I'm not sure if this will help anyone,
but in my instance I basically downloaded and
installed  a binary version of mysql and then I was
able to install Perls DBD::mysql module succesfully. 

--- Karen Ventura <kknox <at> tln.lib.mi.us> wrote:
> Yes!  This did work.  Thank you, Rudy!!
> 
> I used your suggestion of:
> 
>
LD_PRELOAD=/usr/local/mysql/lib/mysql/libmysqlclient.so
> make test
> 
> And all tests were successful!
> 
> Then I was able to do a "make install" without a
> problem.
> 
> Now...back to what I was doing that required DBD in
> the first place - let's
> see if I can get THAT working!
> 
> Thanks again VERY much, Rudy!!
> 
> 	Karen
>

(Continue reading)

Return

Return to gmane.comp.db.mysql.perl.

Search Archive

Language

Change language

Options

Current view: Threads only / Showing only 20 lines / Not hiding cited text.
Change to All messages, whole messages, or hide cited text.

Post a message
NNTP Newsgroup
Classic Gmane web interface
XML

XML

RSS Feed
List Information

About Gmane