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

am 09.07.2003 21:37:07 von Karen Ventura

I saw in the archive that someone else had (is having?) the same problem I
am, but I do not see a solution.

I am trying to install DBD::mysql and I'm stuck.

I am running:
Red Hat Linux 7.2
MySQL version: 4.0.13
DBI: 1.37

I can create the Makefile, though I had to use the cflags and libs options
to specify those locations. But it was fine. I ran 'make' with no problem.
But 'make test' produces lots of errors like:

Failed 12/12 tests, 0.00% okay
t/mysql............Can't load
'/usr/local/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mysql. so' for module
DBD::mysql: /usr/local/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mysql.s o:
undefined symbol: net_buffer_length at
/usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm line 229.
at /usr/local/DBD-mysql-2.9002/blib/lib/Mysql.pm line 13
Compilation failed in require at
/usr/local/DBD-mysql-2.9002/blib/lib/Mysql.pm line 13.
Compilation failed in require at t/mysql.t line 34.
BEGIN failed--compilation aborted at t/mysql.t line 34.
t/mysql............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-68

I have no idea what is wrong. Do I need to specify a location of something
else?? Any help would be great! I have been installing everything (Perl,
MySQL, DBI) all from the latest source code.

Thanks.

Karen
-------------------------------------
Karen C. Ventura
kknox@tln.lib.mi.us
Head, Systems & Technology
Novi Public Library - Novi, Michigan

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

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

am 10.07.2003 10:13:32 von Michael Koch

Hello Karen,

This is me that had the same problem.
One suggested that it was because I used pre-compiled binaries of MySQL,
Perl... Since then, I didn't have the time to reinstall all from sources to
see if it solves the problem. And, I didn't find any other workaround.
But apparently, you also have this problem using install from sources...

I use the same MySQL and DBI versions than you. My OS was Solaris 8.

I will continue to investigate this soon, and post here if I find something.
If you find a solution, it would be great if you also post here :-))

Mike

-----Message d'origine-----
De : perl-return-2176-michael.koch=acanthis.fr@lists.mysql.com
[mailto:perl-return-2176-michael.koch=acanthis.fr@lists.mysq l.com]De la
part de Karen Ventura
Envoye : mercredi 9 juillet 2003 21:37
A : perl@lists.mysql.com
Objet : same problem with symbol net_buffer_length not found with 'make
test' for DBD::mysql

I saw in the archive that someone else had (is having?) the same problem I
am, but I do not see a solution.

I am trying to install DBD::mysql and I'm stuck.

I am running:
Red Hat Linux 7.2
MySQL version: 4.0.13
DBI: 1.37

I can create the Makefile, though I had to use the cflags and libs options
to specify those locations. But it was fine. I ran 'make' with no problem.
But 'make test' produces lots of errors like:

Failed 12/12 tests, 0.00% okay
t/mysql............Can't load
'/usr/local/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mysql. so' for module
DBD::mysql: /usr/local/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mysql.s o:
undefined symbol: net_buffer_length at
/usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm line 229.
at /usr/local/DBD-mysql-2.9002/blib/lib/Mysql.pm line 13
Compilation failed in require at
/usr/local/DBD-mysql-2.9002/blib/lib/Mysql.pm line 13.
Compilation failed in require at t/mysql.t line 34.
BEGIN failed--compilation aborted at t/mysql.t line 34.
t/mysql............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-68

I have no idea what is wrong. Do I need to specify a location of something
else?? Any help would be great! I have been installing everything (Perl,
MySQL, DBI) all from the latest source code.

Thanks.

Karen
-------------------------------------
Karen C. Ventura
kknox@tln.lib.mi.us
Head, Systems & Technology
Novi Public Library - Novi, Michigan

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=michael.koch@acanthis.fr

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

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

am 10.07.2003 10:13:32 von Michael Koch

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

am 31.07.2003 22:09:11 von kryptoer

Hello,

I too am having the same problem. Did you or anyone else find a solution
to the DBD::mysql symbol net_buffer_length error?

I am running the following:

OS = SunOS 5.9 Generic_112233-05 sun4u sparc SUNW,Ultra-5_10 Solaris
MySQL = /usr/local/mysql/bin/mysql Ver 12.21 Distrib 4.0.14, for
sun-solaris2.9 (sparc)
Perl = This is perl, v5.8.0 built for sun4-solaris
Perl DBI = DBI-1.37
Perl DBD::MySQL = DBD-mysql-2.9002

gcc = gcc (GCC) 3.3
make = GNU Make 3.80

MySQL 4.0.14 and Perl 5.8 were both compiled and built from source. DBI
1.37 and DBD::mysql was initially manually built manuall from source. All
software packages have had no problems configuring and building from
source.

The only package that has given me a problem is DBD::mysql. It configures
and builds without any problems. The problem comes when you do a make
test. Basically almost all test fail. make test of DBD::mysql issues the
following error:

Running make test
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/lib/perl5/5.8.0/CPAN/build/DBD-mysql-2.9002/blib /arch/auto/DBD/mysql/mysql.so'
for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation
error: file
/usr/local/lib/perl5/5.8.0/CPAN/build/DBD-mysql-2.9002/blib/ arch/auto/DBD/mysql/mysql.so:
symbol net_buffer_length: referenced symbol not found at
/usr/local/lib/perl5/5.8.0/sun4-solaris/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/00base.t line 38
t/00base...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5

If you install DBD::mysql with the failed make test and try to use
DBD::mysql perl throws the following error:

Can't load
'/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBD/ mysql/mysql.so'
for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation
error: file
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBD/m ysql/mysql.so:
symbol net_buffer_length: referenced symbol not found at
/usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/Mysql.pm line 13
Compilation failed in require at
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/Mysql.pm line 13

So installation is pointless.

I have since configured CPAN and have removed DBI and DBD::mysql and
re-installed via CPAN. I basically hit the same error when CPAN attempts
to install DBD::mysql.

I have tried older versions of DBI and DBD::mysql. This has not helped.

Does anyone have any clues to offer me?

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

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

am 31.07.2003 22:09:11 von kryptoer

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

am 01.08.2003 10:57:56 von Michael Koch

Hello,

I have not yet find a solution for this :-(
However, Evert Konings contacted me two days ago with the same issue, and
said me that he solved this by installing the Perl package
"Msql-Mysql-modules-1.2219".

Unfortunately, I tried this, and it didn't help for me :-(

I am currently trying to install everything from sources, but now this is
the MySQL 4.0.14 compilation that fails with:
sql_lex.cc: In function `void lex_init()':
sql_lex.cc:85: error: `symbols' undeclared (first use this function)
sql_lex.cc:85: error: (Each undeclared identifier is reported only once for
each function it appears in.)
sql_lex.cc:87: error: `sql_functions' undeclared (first use this function)
sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)':
sql_lex.cc:171: error: `get_hash_symbol' undeclared (first use this
function)

Why does it have to be soooo complicated to compile a damn thing !

Good luck with this. If you found a solution, please tell us :-)

Mike

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

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

am 01.08.2003 10:57:56 von Michael Koch

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

am 05.08.2003 04:52:31 von Thomas Whitney

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

The make for DBD::mysql seems to go fine.
Then make test fails about 95% of the tests with the same error

t/mysql............Can't load
'/usr/local/src/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/my sql.so' for
module DBD::mysql:
/usr/local/src/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mys ql.so: undefined
symbol: net_buffer_length at
/usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm line 229.

I've tried using CPAN and CPANPLUS to install DBD::mysql. It always stops
with errorrs.
I tried Bundle::DBD::mysql from CPANPLUS
I tried a manual install of Msql-Myslq-modules-1.2219 (there error was
different but it still would not test correctly)
I tried re-building both perl 5.8.0 and mysql making sure both were using
gcc. No go.
AND if you try to force the install, Apache will not run through a
configtest without an mysql error.

Hopefully someone will figure this out because there is no moving forward
until this can be resolved. It seems to be somewhat of a common problem. So
the more that report it the more likely it is that someone will figure it
out.

I will provide any results of make or make test to anyone who is interested
and I will definitely post a solution here if I run across one.

Thanks,
Thomas Whitney

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

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

am 05.08.2003 04:52:31 von Thomas Whitney

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

am 05.08.2003 15:30:44 von Rudy Lippan

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@m .gmane.org

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

am 05.08.2003 15:30:44 von Rudy Lippan

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

am 05.08.2003 16:08:39 von Thomas Whitney

Jochen,

> and still am convinced that its related to incompatibe
> binaries.

I thought maybe I had found the key by adding 'CC=gcc' to the configuration
for mysql. I configured mysql 4.0-.14 with the following.
CFLAGS="-O3 -mpentiumpro" CC=gcc CXX=gcc CXXFLAGS="-O3 -mpentiumpro \
-felide-constructors -fno-exceptions -fno-rtti" \
../configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldfla
gs=-all-static
Unfortunately, when I did the make test on DBD::mysql it still failed most
of the tests. The initial error was slightly different. Here is the
beginning of the test result.
===== Make Test ===========================
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/my sql.so' for
module DBD::mysql:
/usr/local/src/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mys ql.so: undefined
symbol: net_buffer_length 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/00base.t line 38
t/00base...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
===== End Make Test snippet =======================
> If someone can provide me a shell account on his machine, I'll dig into
the problem.
> Root privileges are not required.
To help get this problem solved I would be happy to give you root access.
This is a test machine running on an internal network. I'm connected to the
Internet through a MSN dsl modem that does not allow port 80 to pass
through. At least I have never been able to get it to work. But, I going
to arrange to have this machine hooked up in my office where we have a T1
and then you could look around. I'll let you know when it is ready.
Thanks,
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@m .gmane.org

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

am 05.08.2003 16:08:39 von Thomas Whitney

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

am 05.08.2003 16:47:55 von Thomas Whitney

Jochen,

> A question: After some research on the net I would assume that you are
> using a precompiled binary of MySQL. Can you confirm this? Is it the
> same for all users achieving the same problems?

No, I am building MySQL from source.

-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@m .gmane.org

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

am 05.08.2003 16:47:55 von Thomas Whitney

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

am 05.08.2003 16:53:58 von Thomas Whitney

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@m .gmane.org

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

am 05.08.2003 16:53:58 von Thomas Whitney

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

am 05.08.2003 16:56:23 von Rudy Lippan

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
leaving net_buffer_length undefined, which it should be getting from
libmysqlclient.a

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@m .gmane.org

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

am 05.08.2003 16:56:23 von Rudy Lippan

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

am 05.08.2003 18:41:07 von Karen Ventura

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@remotelinux.com]
Sent: Tuesday, August 05, 2003 10:56 AM
To: Thomas Whitney
Cc: Rudy Lippan; perl@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
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
leaving net_buffer_length undefined, which it should be getting from
libmysqlclient.a

Rudy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=kknox@tln.lib.mi.us

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

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

am 05.08.2003 18:41:07 von Karen Ventura

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

am 05.08.2003 19:04:32 von Thomas Whitney

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@m .gmane.org

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

am 05.08.2003 19:04:32 von Thomas Whitney

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

am 05.08.2003 19:07:12 von Michael Koch

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@m .gmane.org

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

am 05.08.2003 19:07:12 von Michael Koch

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

am 05.08.2003 19:23:56 von Thomas Whitney

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/my sql/mysql.so'
for module DBD::mysql:
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mys ql/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@m .gmane.org

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

am 05.08.2003 19:23:56 von Thomas Whitney

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

am 05.08.2003 19:30:16 von Karen Ventura

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@centervision.com]
Sent: Tuesday, August 05, 2003 1:24 PM
To: Rudy Lippan
Cc: perl@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/my sql/mysql.so'
for module DBD::mysql:
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mys ql/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=kknox@tln.lib.mi.us

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

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

am 05.08.2003 19:30:16 von Karen Ventura

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

am 05.08.2003 19:57:43 von Rudy Lippan

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=' 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@m .gmane.org

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

am 05.08.2003 19:57:43 von Rudy Lippan

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

am 05.08.2003 20:37:56 von Karen Ventura

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@remotelinux.com]
Sent: Tuesday, August 05, 2003 1:58 PM
To: Michael Koch
Cc: trwhitney@centervision.com; Rudy Lippan; kknox@tln.lib.mi.us;
perl@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.

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=' 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@m .gmane.org

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

am 05.08.2003 20:37:56 von Karen Ventura

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

am 05.08.2003 22:28:05 von kryptoer

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 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
>
> -----Original Message-----
> From: Rudy Lippan [mailto:rlippan@remotelinux.com]
> Sent: Tuesday, August 05, 2003 10:56 AM
> To: Thomas Whitney
> Cc: Rudy Lippan; perl@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
> 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
> leaving net_buffer_length undefined, which it should
> be getting from
> libmysqlclient.a
>
> Rudy
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
>
http://lists.mysql.com/perl?unsub=kknox@tln.lib.mi.us
>

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

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

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

am 05.08.2003 22:28:05 von kryptoer

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

am 05.08.2003 23:12:02 von Rudy Lippan

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@m .gmane.org

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

am 05.08.2003 23:12:02 von Rudy Lippan

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

am 05.08.2003 23:58:10 von Karen Ventura

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@remotelinux.com]
Sent: Tuesday, August 05, 2003 5:12 PM
To: Karen Ventura
Cc: Rudy Lippan; Michael Koch; trwhitney@centervision.com;
perl@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:

> 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@m .gmane.org

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

am 05.08.2003 23:58:10 von Karen Ventura

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

am 06.08.2003 00:25:39 von Thomas Whitney

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/my sql.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/00base.t line 38
t/00base...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/10dsnlist........install_driver(mysql) failed: Can't load
'/usr/local/src/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/my sql.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

==END Test Result ====================

- 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@m .gmane.org

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

am 06.08.2003 00:25:39 von Thomas Whitney

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

am 06.08.2003 01:05:33 von Rudy Lippan

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/my sql.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 :

export LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql to libmysqlclient.so.12 is.

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@m .gmane.org

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

am 06.08.2003 01:05:33 von Rudy Lippan

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

am 06.08.2003 01:48:18 von Thomas Whitney

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 > 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@m .gmane.org

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

am 06.08.2003 01:48:18 von Thomas Whitney

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

am 06.08.2003 09:27:26 von Jim Cromie

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@m .gmane.org

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

am 06.08.2003 09:27:26 von Jim Cromie

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

am 06.08.2003 13:31:18 von Thomas Whitney

> > 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@m .gmane.org

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

am 06.08.2003 13:31:18 von Thomas Whitney

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

am 06.08.2003 19:04:35 von Rudy Lippan

On Wed, 6 Aug 2003, Jochen Wiedmann wrote:

> Three questions:
>
> 1.) If the problem *now* is, that libmysqlclient.so wasn't
> found: What had been the problem before?

Before the problem was that mysql.so was not being linked against
libmysqlclient, so it had undefined symbols but did not know that it
needed to load up libmysqlclient.so to resolve them. Which is why
LD_PRELOAD worked.

>
> 2.) Related to that: What did the linker statement
>
> 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
>
> effectively change? IMO this was right as in some other mails?
>
They linker command that I somehow ended up with was missing the
'-lmysqlclient' (or put it before mysql.so -- I dont' remember) I still
don't know exactly what was/is going on here and what causes this...

Wait.... Here is something:

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

Looses -lmysqlclient -lcrypt &al. the command should be:

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

> 3.) Doesn't the above again depend on the presence of the environment
> variable? As was the case for LD_PRELOAD before? IMO a real solution
> should avoid the necessity of a variable.
>

LD_LIBRARY_PATH just tells the dynamic linker where to search for its
shared object. If you don't want to use LD_LIBRARY_PATH, you can modifiy
/etc/ld.so.conf and add the path to where the shared object lives -- which
is the standard why of doing things if you have root access to the system.

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@m .gmane.org

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

am 06.08.2003 19:04:35 von Rudy Lippan

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

am 06.08.2003 19:48:57 von Karen Ventura

Rudy,

Your clarified "perl Makefile.pl" command has made all the difference.
Using that to begin with, I no longer have any problems with DBD. So the
key for me was to install as:

perl
Makefile.PL --cflags=-I/usr/local/mysql/include/mysql --libs='-L/usr/local/m
ysql/lib/mysql -lmysqlclient -lcrypt -lnsl -lm'
make
make test
make install

Then, everything was great. Thanks again!! :)

Karen

-----Original Message-----
From: Rudy Lippan [mailto:rlippan@remotelinux.com]
Sent: Wednesday, August 06, 2003 1:05 PM
To: Jochen Wiedmann
Cc: Thomas Whitney; kknox@tln.lib.mi.us; Michael Koch;
perl@lists.mysql.com
Subject: RE: same problem with symbol net_buffer_length not found with
'make test' for DBD::mysql

On Wed, 6 Aug 2003, Jochen Wiedmann wrote:

> Three questions:
>
> 1.) If the problem *now* is, that libmysqlclient.so wasn't
> found: What had been the problem before?

Before the problem was that mysql.so was not being linked against
libmysqlclient, so it had undefined symbols but did not know that it
needed to load up libmysqlclient.so to resolve them. Which is why
LD_PRELOAD worked.

>
> 2.) Related to that: What did the linker statement
>
> 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
>
> effectively change? IMO this was right as in some other mails?
>
They linker command that I somehow ended up with was missing the
'-lmysqlclient' (or put it before mysql.so -- I dont' remember) I still
don't know exactly what was/is going on here and what causes this...

Wait.... Here is something:

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

Looses -lmysqlclient -lcrypt &al. the command should be:

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

> 3.) Doesn't the above again depend on the presence of the environment
> variable? As was the case for LD_PRELOAD before? IMO a real solution
> should avoid the necessity of a variable.
>

LD_LIBRARY_PATH just tells the dynamic linker where to search for its
shared object. If you don't want to use LD_LIBRARY_PATH, you can modifiy
/etc/ld.so.conf and add the path to where the shared object lives -- which
is the standard why of doing things if you have root access to the system.

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@m .gmane.org

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

am 06.08.2003 19:48:57 von Karen Ventura

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

am 06.08.2003 22:51:44 von Thomas Whitney

Rudy,

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

What a difference a couple of single quotes make. Everything works
correctly.

It was a bit of a headache dealing with this, BUT it is just a gentle
reminder of how glad I am that I am NOT dealing with ASP or COM or .NET --
I started out using ASP on a IIS server and sometimes ended up wading
through massive volumes of complex and sometimes contradictory documentation
(Microsoft's knowledge base). That could give one a real headache -- AND it
it could go on for days with very little relief. Now, after a minor
incident like this, I can move forward and appreciate the great software
that is created from a desire to serve to the computing community.

So, thanks for your efforts and attention to this!

-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@m .gmane.org

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

am 06.08.2003 22:51:44 von Thomas Whitney

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

am 07.08.2003 05:21:20 von Rudy Lippan

On Thu, 7 Aug 2003, Jochen Wiedmann wrote:

> Quoting Thomas Whitney :
>
> > > perl Makefile.PL --cflags=-I/usr/local/mysql/include/mysql
> > > --libs='-L/usr/local/mysql/lib/mysql -lmysqlclient -lcrypt -lnsl -lm'
> >
> > What a difference a couple of single quotes make. Everything works
> > correctly.
>
> Do I get this right that the whole thing was about lack of clarity in the
> documentation so that people used something like
>
> --libs=-L/usr/local/mysql/lib/mysql -lmysqlclient -lcrypt -lnsl -lm

Yep Regualar olde ID-10-T error :) That is why I could only reproduce it
about 1/2 the time... It took your question for clarification before I
noticied the connexion between the '' and the times it worked and the
times I cut-and-pasted the build line, hehe. But at least it was not as
bad the editing a file on the wrong server and then wondering why the
changes are not taking :)

>
> ? If so, I suggest that someone counterreads the README and the INSTALL.html
> and proposes modifications.

Or how about a modification to Makefile.PL viz.,

Index: Makefile.PL
============================================================ =======
RCS file: /cvs/public/modules/DBD-mysql/Makefile.PL,v
retrieving revision 1.2
diff -u -r1.2 Makefile.PL
--- Makefile.PL 10 Jun 2003 02:15:46 -0000 1.2
+++ Makefile.PL 7 Aug 2003 03:06:07 -0000
@@ -19,7 +19,7 @@
"testuser=s", "testpassword=s",
"cflags=s", "libs=s", "verbose",
"nocatchstderr",
- "ssl!","nofoundrows!");
+ "ssl!","nofoundrows!") || die Usage();
my $source = {};

foreach my $key (qw/testdb testhost testuser testpass

That way the 'perl Makefile.PL' will thow an error message in this
situation because -lmysqlcient is not a valid option that can be passed to
Makefile.PL.

Oh and BTW, the README does use quotes in the ' -lib=" "' line.

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@m .gmane.org

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

am 07.08.2003 05:21:20 von Rudy Lippan

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

am 07.08.2003 08:50:28 von Rudy Lippan

On Thu, 7 Aug 2003, Jochen Wiedmann wrote:

> > Oh and BTW, the README does use quotes in the ' -lib=" "' line.
>
> Have just read it and found that it does - but in the section on
> Windows/CygWin, which is most probably not where Linux or Solaris
> users waste much time. :-)
>

Okay, I will look at the docs. I was using vi's 's/-lib/' while editing
the generated HTML doc, so I did not spend much time reading around the
html -- just long enough to see that it did have quotes around the -lib
args :)

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@m .gmane.org

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

am 07.08.2003 08:50:28 von Rudy Lippan

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

am 07.08.2003 14:35:51 von Thomas Whitney

JOchen,

> ? If so, I suggest that someone counterreads the README and the
> INSTALL.html and proposes modifications.

I re-read the INSTALL.html and it is good, I think if the single quots had
been there I would have figured it out. Not being a developer there were a
couple of confusing points, though. I'll look more at them and see if I can
add anything.

- 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@m .gmane.org

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

am 07.08.2003 14:35:51 von Thomas Whitney

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

am 07.08.2003 15:49:24 von Michael Koch

Hello all,

I am carefully following this thread to try to make it work in my
environment.
I am using Solaris 8, Perl 5.8.0(806), MySQL 4.0.13-standard, gcc 3.3.
The difference with you (I suppose) is that all is installed from binaries.
Indeed, I also have a problem compiling MySQL from sources :-(

So to sum up:

- MySQL install is in /opt/mysql (soft link to
/opt/mysql-standard-4.0.13-sun-solaris2.8-sparc-64bit)
- I don't find "libmysqlclient.so" so I can't use the LD_PRELOAD trick. All
I have in /opt/mysql/lib is:
libdbug.a
libmygcc.a
libmysqlclient.a
libmysqlclient_r.a
libmystrings.a
libmysys.a
- Doing:
# make clean
# perl
Makefile.PL --cflags=-I/opt/mysql/include --libs='-L/opt/mysql/lib -lmysqlcl
ient -lcrypt -lnsl -lm'
(OK, no errors)
# make
I have 2 warnings:
Warning: duplicate function definition 'do' detected in mysql.xs, line
193
Warning: duplicate function definition 'rows' detected in mysql.xs,
line 291
# make test
Boom, the usual errors:

PERL_DL_NONLAZY=1 /opt/ActivePerl-5.8/bin/perl "-MExtUtils::Command::MM"
"-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........install_driver(mysql) failed: Can't load
'/data/mkh/modules/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql /mysql.so' for
module DBD::mysql: ld.so.1: /opt/ActivePerl-5.8/bin/perl: fatal: relocation
error: file
/data/mkh/modules/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/ mysql.so: symbol
net_buffer_length: referenced symbol not found at
/opt/ActivePerl-5.8/lib/5.8.0/sun4-solaris-thread-multi/Dyna Loader.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/00base.t line 38
t/00base...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay

(..... a lot of same errors)

and in the end:

Compilation failed in require at
/data/mkh/modules/DBD-mysql-2.9002/blib/lib/Mysql.pm line 13.
Compilation failed in require at t/mysql.t line 34.
BEGIN failed--compilation aborted at t/mysql.t line 34.
t/mysql............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-68
Failed 68/68 tests, 0.00% okay
t/mysql2...........Had to create DBD::mysql::dr::imp_data_size unexpectedly
at /opt/ActivePerl-5.8/lib/site_perl/5.8.0/sun4-solaris-thread- multi/DBI.pm
line 1020.
Use of uninitialized value in subroutine entry at
/opt/ActivePerl-5.8/lib/site_perl/5.8.0/sun4-solaris-thread- multi/DBI.pm
line 1020.
Can't locate object method "connect" via package "Mysql" at
/data/mkh/modules/DBD-mysql-2.9002/blib/lib/Mysql.pm line 71.

Anyone got ideas ?

Thanks,
Mike

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

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

am 07.08.2003 15:49:24 von Michael Koch

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

am 07.08.2003 18:25:04 von Rudy Lippan

On Thu, 7 Aug 2003, Jochen Wiedmann wrote:

> Please provide us the full logs from "perl Makefile.PL" and "make" here.
> And please be so kind to replace the "myld" from the distribution with
> the attached one before creating the logs.

Three questions. 1) What is the diff between the two mylds other than the
one you sent uses strict? -- I did a quick vdiff but did not see anything
else, 2) what is $missing used for? "you don't have lib$missing.(a|so)",
perhaps? And 3) is the attachment ready to be included in the distribution
as a replacement for the current myld?

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@m .gmane.org

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

am 07.08.2003 18:25:04 von Rudy Lippan

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

am 07.08.2003 18:48:39 von Rudy Lippan

On Thu, 7 Aug 2003, Jochen Wiedmann wrote:

> Quoting Rudy Lippan :
>
> > Three questions. 1) What is the diff between the two mylds other than the
> > one you sent uses strict? -- I did a quick vdiff but did not see anything
>
> It is the same than in the patch I sent you a while ago. It mainly moves
> the variable $contents outside of the "if" clause, so that it can be
> seen in an error message.

Oops. Must have missed that one.

>
>
> > else, 2) what is $missing used for? "you don't have lib$missing.(a|so)",
> > perhaps?
>
> Yes. Depending on the system you have -lz or -lgz.
>
Change made.

>
> > And 3) is the attachment ready to be included in the distribution
> > as a replacement for the current myld?
>
> Yes, of course.

Copied over and checked in.

Thanks,

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@m .gmane.org

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

am 07.08.2003 18:48:39 von Rudy Lippan

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

am 08.08.2003 11:25:51 von Michael Koch

Hello all,

Anybody to help me on this ? Do you think I absolutely have to use the MySQL
source version and not binary ?

Thanks,
Mike

-----Message d'origine-----
De : Michael Koch
Objet : RE: same problem with symbol net_buffer_length not found with
'make test' for DBD::mysql

Hello all,

I am carefully following this thread to try to make it work in my
environment.
I am using Solaris 8, Perl 5.8.0(806), MySQL 4.0.13-standard, gcc 3.3.
The difference with you (I suppose) is that all is installed from binaries.
Indeed, I also have a problem compiling MySQL from sources :-(

So to sum up:

- MySQL install is in /opt/mysql (soft link to
/opt/mysql-standard-4.0.13-sun-solaris2.8-sparc-64bit)
- I don't find "libmysqlclient.so" so I can't use the LD_PRELOAD trick. All
I have in /opt/mysql/lib is:
libdbug.a
libmygcc.a
libmysqlclient.a
libmysqlclient_r.a
libmystrings.a
libmysys.a
- Doing:
# make clean
# perl
Makefile.PL --cflags=-I/opt/mysql/include --libs='-L/opt/mysql/lib -lmysqlcl
ient -lcrypt -lnsl -lm'
(OK, no errors)
# make
I have 2 warnings:
Warning: duplicate function definition 'do' detected in mysql.xs, line
193
Warning: duplicate function definition 'rows' detected in mysql.xs,
line 291
# make test
Boom, the usual errors:

PERL_DL_NONLAZY=1 /opt/ActivePerl-5.8/bin/perl "-MExtUtils::Command::MM"
"-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........install_driver(mysql) failed: Can't load
'/data/mkh/modules/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql /mysql.so' for
module DBD::mysql: ld.so.1: /opt/ActivePerl-5.8/bin/perl: fatal: relocation
error: file
/data/mkh/modules/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/ mysql.so: symbol
net_buffer_length: referenced symbol not found at
/opt/ActivePerl-5.8/lib/5.8.0/sun4-solaris-thread-multi/Dyna Loader.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/00base.t line 38
t/00base...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay

(..... a lot of same errors)

and in the end:

Compilation failed in require at
/data/mkh/modules/DBD-mysql-2.9002/blib/lib/Mysql.pm line 13.
Compilation failed in require at t/mysql.t line 34.
BEGIN failed--compilation aborted at t/mysql.t line 34.
t/mysql............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-68
Failed 68/68 tests, 0.00% okay
t/mysql2...........Had to create DBD::mysql::dr::imp_data_size unexpectedly
at /opt/ActivePerl-5.8/lib/site_perl/5.8.0/sun4-solaris-thread- multi/DBI.pm
line 1020.
Use of uninitialized value in subroutine entry at
/opt/ActivePerl-5.8/lib/site_perl/5.8.0/sun4-solaris-thread- multi/DBI.pm
line 1020.
Can't locate object method "connect" via package "Mysql" at
/data/mkh/modules/DBD-mysql-2.9002/blib/lib/Mysql.pm line 71.

Anyone got ideas ?

Thanks,
Mike

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

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

am 08.08.2003 11:25:51 von Michael Koch

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

am 08.08.2003 12:11:13 von Michael Koch

Hello Jochen,

Sorry I haven't seen your mails asking for more infos and trying compilation
with your myld provided (I didn't receive your mail via the mailing
list...).

Anyways, here are the results:
(with the new myld)

# make clean

# perl
Makefile.PL --cflags=-I/opt/mysql/include --libs='-L/opt/mysql/lib -lmysqlcl
ient -lcrypt -lnsl -lm'
I will use the following settings for compiling and testing:
cflags (Users choice) = -I/opt/mysql/include
libs (Users choice)
= -L/opt/mysql/lib -lmysqlclient -lcrypt -lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Checking if your kit is complete...
Looks good
Using DBI 1.37 installed in
/opt/ActivePerl-5.8/lib/site_perl/5.8.0/sun4-solaris-thread- multi/auto/DBI
Writing Makefile for DBD::mysql

# make
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c -I/opt/ActivePerl-5.8/lib/site_perl/5.8.0/sun4-solaris-threa d-multi/
auto/DBI -I/opt/mysql/include -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -fno-
strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\
"2.9002\" -DXS_VERSION=\"2.9002\" -fPIC
"-I/opt/ActivePerl-5.8/lib/5.8.0/sun4-solaris-thread-multi/C ORE" dbdimp.c
/opt/ActivePerl-5.8/bin/perl -p -e "s/~DRIVER~/mysql/g" <
/opt/ActivePerl-5.8/lib/site_perl/5.8.0/sun4-solaris-thread- multi/auto/DBI/D
river.xst > mysql.xsi
/opt/ActivePerl-5.8/bin/perl
opt/ActivePerl-5.8/lib/5.8.0/ExtUtils/xsubpp -typemap
/opt/ActivePerl-5.8/lib/5.8.0/ExtUtils/typemap mysql.xs > mysql.xsc && mv
mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 193
Warning: duplicate function definition 'rows' detected in mysql.xs, line 291
gcc -c -I/opt/ActivePerl-5.8/lib/site_perl/5.8.0/sun4-solaris-threa d-multi/
auto/DBI -I/opt/mysql/include -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -fno-
strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\
"2.9002\" -DXS_VERSION=\"2.9002\" -fPIC
"-I/opt/ActivePerl-5.8/lib/5.8.0/sun4-solaris-thread-multi/C ORE" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/opt/mysql/lib:/usr/lib" /opt/ActivePerl-5.8/bin/perl myld
cc -G dbdimp.o mysql.o -o
ib/arch/auto/DBD/mysql/mysql.so -L/opt/mysql/lib -lmysqlclient -lcrypt -ln
sl -lm
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/Mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Manifying blib/man3/Bundle::DBD::mysql.3

Hope this helps !

Mike

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

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

am 08.08.2003 12:11:13 von Michael Koch

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

am 08.08.2003 14:43:46 von Michael Koch

Hello Jochen,

Thanks for your help.

(as I used tcsh as shell, I can't enter directly env variables on command
line, so I switched to sh for your test).

# sh
# LD_RUN_PATH="/opt/mysql/lib:/usr/lib" cc -G dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.so
/opt/mysql/lib/libmysqlclient.a -lcrypt -lnsl -lm
ld: warning: file /opt/mysql/lib/libmysqlclient.a(libmysql.o): wrong ELF
class: ELFCLASS64

Hmmm... Is this a problem with 32/64 bits ? I run Solaris on SPARC 64bits...

Regards,
Michael

-----Message d'origine-----
De : Jochen Wiedmann
Envoyé : vendredi 8 août 2003 12:56
À : Michael Koch
Cc : Rudy Lippan; perl@lists.mysql.com
Objet : RE: same problem with symbol net_buffer_length not found with
'make test' for DBD::mysql

Try to enter the following manually:

Quoting Michael Koch :

LD_RUN_PATH="/opt/mysql/lib:/usr/lib" cc -G dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.so /opt/mysql/lib/libmysqlclient.a
-lcrypt -lnsl -lm

(all in a single line) and then rerun "make test". Please make sure,
that I picked the path to libmysqlclient.a right.

Jochen

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

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

am 08.08.2003 14:43:46 von Michael Koch

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

am 08.08.2003 18:33:41 von Michael Koch

Ok thanks for the advice.
I will try this and come back to you.

Unfortunately it won't be until next week now as I'm leaving for home.

Rgds,
Michael

-----Message d'origine-----
De : WWW [mailto:www@webmail.LF.net]De la part de Jochen Wiedmann
Envoyé : vendredi 8 août 2003 14:56
À : Michael Koch
Cc : Rudy Lippan; perl@lists.mysql.com
Objet : RE: same problem with symbol net_buffer_length not found with
'make test' for DBD::mysql

Quoting Michael Koch :

> ld: warning: file /opt/mysql/lib/libmysqlclient.a(libmysql.o): wrong ELF
> class: ELFCLASS64
>
> Hmmm... Is this a problem with 32/64 bits ? I run Solaris on SPARC
64bits...

Quite possible. I suggest, that you recompile the MySQL *client*. Compiling
the server is not required. To compile the client, get yourself the server
sources and use the configure option --without-server (or something similar,
written from memory).

Jochen

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

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

am 08.08.2003 18:33:41 von Michael Koch