RH9 multi-thread perl unresolved symbol problem?

--=-zWsNTtzgt80hnC/mCOjP
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

I have upgraded to DBI-1.40 and DBD-MySQL-2.9 and am now receiving the
following error after compiling with the below compile options.


Can't load
'/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto /DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/mysql.so: undefined symbol: net_buffer_length at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.

Any assistance would be most appreciated.

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

gcc -c
-I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/aut o/DBI
-I'/usr/include' -I'/usr/include/mysql' -D_REENTRANT -D_GNU_SOURCE
-DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm -O2 -g -pipe -march=i386 -mcpu=i686
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -fPIC
"-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" dbdimp.c
gcc -c
-I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/aut o/DBI
-I'/usr/include' -I'/usr/include/mysql' -D_REENTRANT -D_GNU_SOURCE
-DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm -O2 -g -pipe -march=i386 -mcpu=i686
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -fPIC
"-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" mysql.c


--=-zWsNTtzgt80hnC/mCOjP--

Re: RH9 multi-thread perl unresolved symbol problem?

Matthew A. R. Sherian wrote:

> I have upgraded to DBI-1.40 and DBD-MySQL-2.9 and am now receiving the
> following error after compiling with the below compile options.
>
>
> Can't load
> '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto /DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/mysql.so: undefined symbol: net_buffer_length at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.

Most probably the linker is unable to locate the dynamic libraries. Try a
google search for "net_buffer_length DBD mysql", it will emit a lot of
results and associated hints.


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: RH9 multi-thread perl unresolved symbol problem?

Matthew A. R. Sherian wrote:

> I have upgraded to DBI-1.40 and DBD-MySQL-2.9 and am now receiving the
> following error after compiling with the below compile options.
>
>
> Can't load
> '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto /DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/mysql.so: undefined symbol: net_buffer_length at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.

Most probably the linker is unable to locate the dynamic libraries. Try a
google search for "net_buffer_length DBD mysql", it will emit a lot of
results and associated hints.


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: RH9 multi-thread perl unresolved symbol problem?

--=-f2JXrXbNWEPV/EK36NQp
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Thanks for the hint, I had done a much more specific search earlier that
didn't return any results.

On Mon, 2004-01-26 at 16:04, Jochen Wiedmann wrote:

> Matthew A. R. Sherian wrote:
>
> > I have upgraded to DBI-1.40 and DBD-MySQL-2.9 and am now receiving the
> > following error after compiling with the below compile options.
> >
> >
> > Can't load
> > '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto /DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/mysql.so: undefined symbol: net_buffer_length at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
>
> Most probably the linker is unable to locate the dynamic libraries. Try a
> google search for "net_buffer_length DBD mysql", it will emit a lot of
> results and associated hints.
>
>
> Jochen
>

--=-f2JXrXbNWEPV/EK36NQp--

Re: RH9 multi-thread perl unresolved symbol problem?

--=-f2JXrXbNWEPV/EK36NQp
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Thanks for the hint, I had done a much more specific search earlier that
didn't return any results.

On Mon, 2004-01-26 at 16:04, Jochen Wiedmann wrote:

> Matthew A. R. Sherian wrote:
>
> > I have upgraded to DBI-1.40 and DBD-MySQL-2.9 and am now receiving the
> > following error after compiling with the below compile options.
> >
> >
> > Can't load
> > '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto /DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/mysql.so: undefined symbol: net_buffer_length at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
>
> Most probably the linker is unable to locate the dynamic libraries. Try a
> google search for "net_buffer_length DBD mysql", it will emit a lot of
> results and associated hints.
>
>
> Jochen
>

--=-f2JXrXbNWEPV/EK36NQp--

Re: RH9 multi-thread perl unresolved symbol problem?

--=-amoFEUSgDLRdfAB/U+AE
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Well I ended up not finding my solution via google. I ended up figuring
it out though. It seems that --libs doesn't actually pass the arguments
to the Makefile.

LDDFLAGS=-L/usr/local/lib was all that was set in the Makefile. I
modified that to contain all of the options that were passed on the
command line, and I built perfectly.

However I still have this problem:

Can't call method "rows" without a package or object reference at....

where at is

$dbh = DBI->connect("DBI:mysql:database=$db;host=$host","$user", "$pw",
{'RaiseError' => 1}) or die "Unable to connect:$DBI::errstr\n";


$query = "SELECT
longdescs.bug_id bug_id,longdescs.thetext thetext,
bugs.short_desc short_desc
FROM bugs, longdescs
where
bugs.bug_id = longdescs.bug_id
and bugs.target_milestone = '$target'
order by longdescs.bug_id;";

$sth = $dbh->prepare( $query ) or die "SQL Failure: On prepare
of\n\t$DBI::errstr\n";
$sth = $sth->execute() or die "SQL Failure: On execute
of\n\t$DBI::errstr\n";
$return = $sth->rows;



On Mon, 2004-01-26 at 16:11, Matthew A. R. Sherian wrote:

> Thanks for the hint, I had done a much more specific search earlier that
> didn't return any results.
>
> On Mon, 2004-01-26 at 16:04, Jochen Wiedmann wrote:
>
> > Matthew A. R. Sherian wrote:
> >
> > > I have upgraded to DBI-1.40 and DBD-MySQL-2.9 and am now receiving the
> > > following error after compiling with the below compile options.
> > >
> > >
> > > Can't load
> > > '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto /DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/mysql.so: undefined symbol: net_buffer_length at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
> >
> > Most probably the linker is unable to locate the dynamic libraries. Try a
> > google search for "net_buffer_length DBD mysql", it will emit a lot of
> > results and associated hints.
> >
> >
> > Jochen
> >

--=-amoFEUSgDLRdfAB/U+AE--

Re: RH9 multi-thread perl unresolved symbol problem?

--=-amoFEUSgDLRdfAB/U+AE
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Well I ended up not finding my solution via google. I ended up figuring
it out though. It seems that --libs doesn't actually pass the arguments
to the Makefile.

LDDFLAGS=-L/usr/local/lib was all that was set in the Makefile. I
modified that to contain all of the options that were passed on the
command line, and I built perfectly.

However I still have this problem:

Can't call method "rows" without a package or object reference at....

where at is

$dbh = DBI->connect("DBI:mysql:database=$db;host=$host","$user", "$pw",
{'RaiseError' => 1}) or die "Unable to connect:$DBI::errstr\n";


$query = "SELECT
longdescs.bug_id bug_id,longdescs.thetext thetext,
bugs.short_desc short_desc
FROM bugs, longdescs
where
bugs.bug_id = longdescs.bug_id
and bugs.target_milestone = '$target'
order by longdescs.bug_id;";

$sth = $dbh->prepare( $query ) or die "SQL Failure: On prepare
of\n\t$DBI::errstr\n";
$sth = $sth->execute() or die "SQL Failure: On execute
of\n\t$DBI::errstr\n";
$return = $sth->rows;



On Mon, 2004-01-26 at 16:11, Matthew A. R. Sherian wrote:

> Thanks for the hint, I had done a much more specific search earlier that
> didn't return any results.
>
> On Mon, 2004-01-26 at 16:04, Jochen Wiedmann wrote:
>
> > Matthew A. R. Sherian wrote:
> >
> > > I have upgraded to DBI-1.40 and DBD-MySQL-2.9 and am now receiving the
> > > following error after compiling with the below compile options.
> > >
> > >
> > > Can't load
> > > '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto /DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/mysql.so: undefined symbol: net_buffer_length at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
> >
> > Most probably the linker is unable to locate the dynamic libraries. Try a
> > google search for "net_buffer_length DBD mysql", it will emit a lot of
> > results and associated hints.
> >
> >
> > Jochen
> >

--=-amoFEUSgDLRdfAB/U+AE--

Re: RH9 multi-thread perl unresolved symbol problem?

On Tue, 27 Jan 2004, Matthew A. R. Sherian wrote:

> Date: Tue, 27 Jan 2004 19:26:08 -0500
> $sth = $dbh->prepare( $query ) or die "SQL Failure: On prepare
> of\n\t$DBI::errstr\n";
> $sth = $sth->execute() or die "SQL Failure: On execute

$sth->execute();
not
$sth = $sth->execute();


Rubdy



--
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: RH9 multi-thread perl unresolved symbol problem?

On Tue, 27 Jan 2004, Matthew A. R. Sherian wrote:

> Date: Tue, 27 Jan 2004 19:26:08 -0500
> $sth = $dbh->prepare( $query ) or die "SQL Failure: On prepare
> of\n\t$DBI::errstr\n";
> $sth = $sth->execute() or die "SQL Failure: On execute

$sth->execute();
not
$sth = $sth->execute();


Rubdy



--
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: RH9 multi-thread perl unresolved symbol problem?

--=-kmFPYnACDbkrUwm2WKli
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Thank You,

I was looking at that code, and I didn't even notice that. BAH!!!

On Tue, 2004-01-27 at 23:16, Rudy Lippan wrote:

> On Tue, 27 Jan 2004, Matthew A. R. Sherian wrote:
>
> > Date: Tue, 27 Jan 2004 19:26:08 -0500
> > $sth = $dbh->prepare( $query ) or die "SQL Failure: On prepare
> > of\n\t$DBI::errstr\n";
> > $sth = $sth->execute() or die "SQL Failure: On execute
>
> $sth->execute();
> not
> $sth = $sth->execute();
>
>
> Rubdy
>
>

--=-kmFPYnACDbkrUwm2WKli--

Re: RH9 multi-thread perl unresolved symbol problem?

--=-kmFPYnACDbkrUwm2WKli
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Thank You,

I was looking at that code, and I didn't even notice that. BAH!!!

On Tue, 2004-01-27 at 23:16, Rudy Lippan wrote:

> On Tue, 27 Jan 2004, Matthew A. R. Sherian wrote:
>
> > Date: Tue, 27 Jan 2004 19:26:08 -0500
> > $sth = $dbh->prepare( $query ) or die "SQL Failure: On prepare
> > of\n\t$DBI::errstr\n";
> > $sth = $sth->execute() or die "SQL Failure: On execute
>
> $sth->execute();
> not
> $sth = $sth->execute();
>
>
> Rubdy
>
>

--=-kmFPYnACDbkrUwm2WKli--