headers
Michael Koch | 1 Aug 2003 10:57
Picon
Favicon

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

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 <at> m.gmane.org
(Continue reading)

Permalink | Reply | 0 comments |
headers
Jason Davis | 2 Aug 2003 00:40

newly installed and never used DBD and DBI....

Hello we are trying to install WebGUI and of course use MySQL with Perl, in
order to do this we installed DBD and DBI, but something appears to have
gone wrong....

The error message from the index.pl is as follows....
bash-2.03# perl index.pl
install_driver(mysql) failed: 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: perl: fatal: relocation error: file
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/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 16) line 3
Compilation failed in require at (eval 16) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at ../lib/WebGUI/Session.pm line 392

but the mentioned files are where it's looking for them and the permissions
are r and x for all three....

Now durning a reinstallation not doing it through perl -MCPAN -e shell the
make test returned something odd of DBI.

        Test returned status 255 (wstat 65280, 0xff00)
Failed Test       Stat Wstat Total Fail  Failed  List of Failed
----------------------------------------------------------------------------
---
t/00base.t         255 65280     5    2  40.00%  4-5
t/10dsnlist.t      255 65280     9    9 100.00%  1-9
t/20createdrop.t   255 65280     5    5 100.00%  1-5
(Continue reading)

Permalink | Reply | 1 comment |
headers
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)

Permalink | Reply | 18 comments |
headers
ben.eisel | 5 Aug 2003 06:57

DBD::MYSQL make test failure

gcc 2.95.2 compiled perl 5.8.0.
gcc 2.95.2 compiled mysql-3.23.36.
added CCFLAGS -L<location of libgcc.a> -lgcc   as per KNOWN PROBLEMS

still mass failure on make test.

if there is a solution to this,  please let me know.

thanks,

- ben eisel

bash-2.02# make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
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 -B/usr/ccs/bin/ -c  -I/opt/perl-5.8.0/lib/site_perl/5.8.0/sun4-solaris-multi/auto/DBI -I/u
sr/local/mysql-3.23.36/include/mysql -I../dbd -I/opt/perl-5.8.0/lib/site_perl/5.8.0/sun4-solar
is-multi/auto/DBI -I/opt/perl-5.8.0/lib/5.8.0/sun4-solaris-multi -fno-strict-aliasing -I/usr/l
ocal/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -L/usr/local/lib/gcc-lib/sparc-sun-sol
aris2.8/2.95.2 -lgcc -O   -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -fPIC "-I/opt/perl-5.8.
0/lib/5.8.0/sun4-solaris-multi/CORE"  -DDBD_MYSQL dbdimp.c
gcc: -lgcc: linker input file unused since linking not done
/opt/perl-5.8.0/bin/perl -p -e "s/~DRIVER~/mysql/g" < /opt/perl-5.8.0/lib/site_perl/5.8.0/sun4
-solaris-multi/auto/DBI/Driver.xst > mysql.xsi
/opt/perl-5.8.0/bin/perl /opt/perl-5.8.0/lib/5.8.0/ExtUtils/xsubpp  -typemap /opt/perl-5.8.0/l
ib/5.8.0/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 281
Warning: duplicate function definition 'rows' detected in mysql.xs, line 407
(Continue reading)

Permalink | Reply | 0 comments |
headers
ben.eisel | 5 Aug 2003 06:58

DBD::MYSQL make test failure

hello,

gcc 2.95.2 compiled perl 5.8.0.
gcc 2.95.2 compiled mysql-3.23.36.
added CCFLAGS -L<location of libgcc.a> -lgcc   as per KNOWN PROBLEMS

still mass failure on make test.

if there is a solution to this,  please let me know.

thanks,

- ben eisel

bash-2.02# make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
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 -B/usr/ccs/bin/ -c  -I/opt/perl-5.8.0/lib/site_perl/5.8.0/sun4-solaris-multi/auto/DBI -I/u
sr/local/mysql-3.23.36/include/mysql -I../dbd -I/opt/perl-5.8.0/lib/site_perl/5.8.0/sun4-solar
is-multi/auto/DBI -I/opt/perl-5.8.0/lib/5.8.0/sun4-solaris-multi -fno-strict-aliasing
-I/usr/l ocal/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -L/usr/local/lib/gcc-lib/sparc-sun-sol
aris2.8/2.95.2 -lgcc -O   -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -fPIC "-I/opt/perl-5.8.
0/lib/5.8.0/sun4-solaris-multi/CORE"  -DDBD_MYSQL dbdimp.c
gcc: -lgcc: linker input file unused since linking not done /opt/perl-5.8.0/bin/perl -p -e
"s/~DRIVER~/mysql/g" < /opt/perl-5.8.0/lib/site_perl/5.8.0/sun4
-solaris-multi/auto/DBI/Driver.xst > mysql.xsi /opt/perl-5.8.0/bin/perl
/opt/perl-5.8.0/lib/5.8.0/ExtUtils/xsubpp  -typemap /opt/perl-5.8.0/l
ib/5.8.0/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
(Continue reading)

Permalink | Reply | 0 comments |
headers
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)

Permalink | Reply | 17 comments |
headers
Thomas Whitney | 5 Aug 2003 16:08

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


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/mysql.so' for
module DBD::mysql:
/usr/local/src/DBD-mysql-2.9002/blib/arch/auto/DBD/mysql/mysql.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)
(Continue reading)

Permalink | Reply | 0 comments |
headers
Rudy Lippan | 5 Aug 2003 16:20

Re: DBD::mysql odd behavior

On Tue, 5 Aug 2003, Jochen Wiedmann wrote:

> Whether to like environment variables or not, is a matter of taste. My
> personal feeling is that it doesn't matter how the configuration occurs,
> but I strongly encourage that all configuration is left in one place,
> which is Makefile.PL, as it is now.
> 

Well it might be nice to be able to override the Makefile options at test 
time, but I don't see much need for that, but on the other hand DBD::Pg 
uses the DBI_DSN et al. at test time to set up the test env.

I am thinking the best route would be to add test* options to Pg and make 
the DBI_ env vars work in mysql. That way I don't have to remember as much 
 when bouncing between drivers :)

Thoughts?

> What you probably aren't aware is that there already is a possibility
> for automated installs, which is the mysql_config script. The main
> idea is to have a custom mysql_config script which is internally using
> the MySQL script with the same name to reply to --libs or --cflags,
> but also listens to --test-user and the like. See "perldoc DBD::mysql::Install"
> for details.
> 

The usage message gives better info about mysql_config --testuser then the 
INSTALL.pod which I guess needs updating so that it enumerates all of the 
flags which it might call mysql_info with -- Added to the TODO.
(Continue reading)

Permalink | Reply | 0 comments |
headers
Thomas Whitney | 5 Aug 2003 16:47

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

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 <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
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
Permalink | Reply | 16 comments |

Gmane