R help - Apr 2005 - libz library missing while installing RMySQL

Hello
Trying to install the MySQL package, I get the following error. The help 
archive contains something on this issue but did not help. I work on linux 
suse 9.3

Configuration error:
   Could not locate the library "libz" required by MySQL.

The library libz however is not on any mirrors I checked.
------------------------------------------------
Sebastian Leuzinger
web   http://pages.unibas.ch/botschoen/leuzinger

On Wed, 2005-04-27 at 09:43 +0200, Sebastian Leuzinger
wrote:
> Hello
> Trying to install the MySQL package, I get the following error. The help 
> archive contains something on this issue but did not help. I work on linux 
> suse 9.3
> 
> Configuration error:
>    Could not locate the library "libz" required by MySQL.
> 
> The library libz however is not on any mirrors I checked.
Sebastian, You made some R core people very happy: they have tried very
hard to explain that there is a difference between a *library* and a
*package*, and that this difference really matters. This seems to be the
first case on R-News when this distinction really seems to matter: you
need a library.  I don't know about SuSE (or with some other really
weird capitalization), but in my system libz belongs to package zlib
that you must install, and in my system you'd probably need zlib-devel
as well (this is FC3). So they are system level libraries that come with
SuSe instead of R packages.

cheers, jari oksanen
-- 
Jari Oksanen <jarioksa at sun3.oulu.fi>

Hello, Sebastian.

  It looks like you are also missing MySQL API installed.
  It consists of several C headers and libraries with definitions of
  functions, working with mysql server daemon.

  In your case rackage installation process needs to compile some C sources, and
  a compiler must know where to take function definitions from.

--
Best regards
Wladimir Eremeev                                     mailto:wl at eimb.ru

=========================================================================Research
Scientist, PhD                           Leninsky Prospect 33,
Space Monitoring & Ecoinformation Systems Sector, Moscow, Russia, 119071,
Institute of Ecology,                             Phone: (095) 135-9972;
Russian Academy of Sciences                       Fax: (095) 135-9972

Thanks for the advice!
For those interested in what the final solution was to installing RMySQL (R 
2.1.0, Linux SuSE 9.3):
The following packages were not installed:
php4-mysql
php5-mysql
php5-mysqli
mysql-devel
at least one of them was obviously missing....




On Thursday 28 April 2005 10:37, you wrote:
> Sebastian,
>
> I'm really not an expert with database systems, and I don't have
SuSE
> (but Fedora), so I may be unable to help you. However, I just had a look
> at the issue, and I could install RMySQL in R 2.1.0 in Fedora. Here some
> points that I noticed:
>
> - You need package R package DBI which must be installed first.
> - You also need devel packages of mysql.
>
> I don't know how SuSE handles packaging libraries, and I don't know
what
> you have already. However, I needed these mysql pieces to install
> RMySQL:
>
> mysql-devel-3.23.58-16.FC3.1
> mysql-server-3.23.58-16.FC3.1
> mysql-3.23.58-16.FC3.1
>
> These in turn seem to need perl libraries:
>
> perl-DBD-MySQL-2.9003-5
> perl-DBI-1.40-5
>
> It seems that in some systems the piece that is called mysql in FC may
> be called mysql-client.
>
> I don't know how things are done in SuSE and what you have there, but I
> hope you find some useful information. However, since it installs
> smoothly in my FC, I can't reproduce your problems. Perhaps INSTALL and
> README files in RMySQL/inst directory of the source will tell you
> something more useful.
>
> best wishes, jari oksanen
-- 
------------------------------------------------
Sebastian Leuzinger
Institute of Botany, University of Basel
Sch伱伓nbeinstr. 6 CH-4056 Basel
ph    0041 (0) 61 2673511
fax   0041 (0) 61 2673504
email Sebastian.Leuzinger at unibas.ch 
web   http://pages.unibas.ch/botschoen/leuzinger