undefined symbol: mysql_real_escape_stromg

While I still have a little hair to pull out, someone please save me.

I've recently upgraded my Linux box to Perl 5.8 and I'm trying to
install the DBI::mysql module. CPAN failed miserably. So I'm trying to
do it by hand.

The make seemed to go ok (with some work), but maybe not. Make test
failed, though. Here is the bulk of the output from "perl Makefile.PL.
I had to pass several libraries to it since it complained that they
weren't there. I simply don't have libgz - could that be killing me?

---------------
cflags (guessed ) = -I/usr/local/include/mysql
libs (Users choice) = -L/usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/libgcc. a -L/usr/local/lib/mysql/libmysqlclient.a -L/usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/libgcc. a -lz -lgz
nocatchstderr (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'.

Note (probably harmless): No library found for -lgz
Using DBI 1.30 installed in /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
-------------

The subsequent make ran ok. Here is the beginning of the output from make test:

-------------
PERL_DL_NONLAZY=1 /usr/local/bin/perl5.8 "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.tt/00base...........install_driver(mysql) failed: Can't load '/root/.cpan/build/DBD-mysql-2.1018/blib/arch/auto/DBD/mysql /mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.1018/blib/arch/auto/DBD/mysql/ mysql.so: undefined symbol: mysql_real_escape_string 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
-------------

I've searched through the mailing list archives but can't find anything useful.
Can anyone help? Thanks in advance.

--pat--
--
Pat Traynor
pat@ssih.com


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

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

Re: undefined symbol: mysql_real_escape_stromg

Zitiere Pat Traynor :

> undefined symbol: mysql_real_escape_string at

Possible reasons include:

- You have an outdated version of MySQL.
- You haven't installed the package mysql-devel.
- You have compiled against a shared library,
which cannot be found for some reason. Try to
change the "libs" from
-L/usr/local/lib/mysql/libmysqlclient.a
to
-L/usr/local/lib/mysql -lmysqlclient
or
-L/usr/local/lib/mysql -lmysqlclient.a
or
/usr/local/lib/mysql/libmysqlclient


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

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

Re: undefined symbol: mysql_real_escape_stromg

Zitiere Pat Traynor :

> undefined symbol: mysql_real_escape_string at

Possible reasons include:

- You have an outdated version of MySQL.
- You haven't installed the package mysql-devel.
- You have compiled against a shared library,
which cannot be found for some reason. Try to
change the "libs" from
-L/usr/local/lib/mysql/libmysqlclient.a
to
-L/usr/local/lib/mysql -lmysqlclient
or
-L/usr/local/lib/mysql -lmysqlclient.a
or
/usr/local/lib/mysql/libmysqlclient


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

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

Re: undefined symbol: mysql_real_escape_stromg

On Fri, 6 Sep 2002, Jochen Wiedmann wrote:

> Zitiere Pat Traynor :
>
> > undefined symbol: mysql_real_escape_string at
>
> Possible reasons include:
>
> - You have an outdated version of MySQL.
> - You haven't installed the package mysql-devel.
> - You have compiled against a shared library,
> which cannot be found for some reason. Try to
> change the "libs" from
> -L/usr/local/lib/mysql/libmysqlclient.a
> to
> -L/usr/local/lib/mysql -lmysqlclient
> or
> -L/usr/local/lib/mysql -lmysqlclient.a
> or
> /usr/local/lib/mysql/libmysqlclient

Thanks for the tips - I really appreciate them. From that list, I've
narrowed the search down to mysql-devel not being installed.

Is there any way to do that without rpm? Although I do have rpm on my
Slackware machine, it complained that it wasn't a recent enough version
to do the install. When I tried to upgrade rpm to version 4, I got a
LONG list of failed dependencies.

--pat--
--
Pat Traynor
pat@ssih.com


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

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

Re: undefined symbol: mysql_real_escape_stromg

On Fri, 6 Sep 2002, Jochen Wiedmann wrote:

> Zitiere Pat Traynor :
>
> > undefined symbol: mysql_real_escape_string at
>
> Possible reasons include:
>
> - You have an outdated version of MySQL.
> - You haven't installed the package mysql-devel.
> - You have compiled against a shared library,
> which cannot be found for some reason. Try to
> change the "libs" from
> -L/usr/local/lib/mysql/libmysqlclient.a
> to
> -L/usr/local/lib/mysql -lmysqlclient
> or
> -L/usr/local/lib/mysql -lmysqlclient.a
> or
> /usr/local/lib/mysql/libmysqlclient

Thanks for the tips - I really appreciate them. From that list, I've
narrowed the search down to mysql-devel not being installed.

Is there any way to do that without rpm? Although I do have rpm on my
Slackware machine, it complained that it wasn't a recent enough version
to do the install. When I tried to upgrade rpm to version 4, I got a
LONG list of failed dependencies.

--pat--
--
Pat Traynor
pat@ssih.com


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

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

Re: undefined symbol: mysql_real_escape_stromg

Zitiere Pat Traynor :

> Thanks for the tips - I really appreciate them. From that list, I've
> narrowed the search down to mysql-devel not being installed.
>
> Is there any way to do that without rpm? Although I do have rpm on my
> Slackware machine, it complained that it wasn't a recent enough version
> to do the install. When I tried to upgrade rpm to version 4, I got a
> LONG list of failed dependencies.

Install the thing from the tar ball.

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

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

Re: undefined symbol: mysql_real_escape_stromg

Zitiere Pat Traynor :

> Thanks for the tips - I really appreciate them. From that list, I've
> narrowed the search down to mysql-devel not being installed.
>
> Is there any way to do that without rpm? Although I do have rpm on my
> Slackware machine, it complained that it wasn't a recent enough version
> to do the install. When I tried to upgrade rpm to version 4, I got a
> LONG list of failed dependencies.

Install the thing from the tar ball.

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

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