On Nov 1, 2006, at 3:04 PM, P. B. Pynsent wrote:
> I wonder if anybody has successfully got the RMySQL installation
> working?
>
> I have followed the instructions (both approaches) given on the build
> failure CRAN site but still get a configuration error.
>
> WARNING: ignoring environment value of R_HOME
> * Installing *source* package 'RMySQL' ...
> creating cache ./config.cache
> checking how to run the C preprocessor...
> The downloaded packages are in
> /private/tmp/RtmpNiFrHt/downloaded_packages
> /lib/cpp
> checking for compress in -lz... no
> checking for getopt_long in -lc... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql.h... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... no
>
> Configuration error:
> Could not locate the library "libz" required by MySQL.
>
> INSTRUCTIONS:
>
> The "libz" library is required by the MySQL client library
> in order to compress/uncompress connections between clients
> and the MySQL engine.
>
> Make sure you have "libz" installed properly and/or included
> in your $LD_LIBRARY_PATH. Perhaps it is not in any of the
> standard directories (e.g., /usr/lib/, /usr/local/lib)?
>
> Aborting the installation of RMySQL.
>
> ** Removing '/Users/paul/Library/R/library/RMySQL'
> ** Restoring previous '/Users/paul/Library/R/library/RMySQL'
> ERROR: configuration failed for package 'RMySQL'
>
>> R.version
> _
> platform powerpc-apple-darwin8.7.0
> arch powerpc
> os darwin8.7.0
> system powerpc, darwin8.7.0
> status
> major 2
> minor 4.0
> year 2006
> month 10
> day 03
> svn rev 39566
> language R
> version.string R version 2.4.0 (2006-10-03)
>
> Mac OS 10.4.8 4 x 2.5GHz G5
>
> A similar error message is produced on my MacBook Pro running R 2.4.0.
>
> zlib is in /usr/lib. I should be grateful for any suggestions.
>
> Many thanks,
>
> Paul
>
>
> P. B. Pynsent,
> Research & Teaching Centre,
> Royal Orthopaedic Hospital,
> Northfield,
> Birmingham, B31 2AP,
> U. K.
>
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac@stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>
Hi, Paul,
I'm also struggling to get RMySQL up and running over here. My
installation:
> R.version
_
platform i386-apple-darwin8.6.1
arch i386
os darwin8.6.1
system i386, darwin8.6.1
status
major 2
minor 3.1
year 2006
month 06
day 01
svn rev 38247
language R
version.string Version 2.3.1 (2006-06-01)
I have luckily receive a message from Jeff Ryan pointing to the key
of the problem: to get a MySQL distribution including headers and the
client library. He speaks about a "developer distribution", but I am
not able to find such a thing for Mac/Intel (neither for Mac/PPC!) I
am currently trying the source distribution trying to build it here,
but I'm facing a number of problems so far.
As for the compression libraries, I've installed the XTools package
included with the installation DVD bundled with our last MacBooks.
By downloading mysql-5.0.27.tar.gz, exploding it and exporting the
concerned variables as following, I get the messages included below...
export PKG_CPPFLAGS="-I/users/rrodriguez/Desktop/mysql-5.0.27/include"
export PKG_LIBS="-L/users/rrodriguez/Desktop/mysql-5.0.27/lib -
lmysqlclient"
R CMD INSTALL RMySQL_0.5-9.tar.gz
ricardo-rodriguezs-computer:/Users/rrodriguez/Desktop root# R CMD
INSTALL RMySQL_0.5-9.tar.gz
* Installing *source* package 'RMySQL' ...
creating cache ./config.cache
checking how to run the C preprocessor... cc -E
checking for compress in -lz... yes
checking for getopt_long in -lc... yes
checking for mysql_init in -lmysqlclient... no
checking for mysql.h... no
updating cache ./config.cache
creating ./config.status
creating src/Makevars
** libs
** arch - i386
gcc-4.0 -arch i386 -I/Library/Frameworks/R.framework/Resources/
include -I/Library/Frameworks/R.framework/Resources/include/i386 -I/
users/rrodriguez/Desktop/mysql-5.0.27/include -msse3 -
D__NO_MATH_INLINES -fPIC -fno-common -g -O2 -std=gnu99 -
march=pentium-m -mtune=prescott -c RS-DBI.c -o RS-DBI.o
gcc-4.0 -arch i386 -I/Library/Frameworks/R.framework/Resources/
include -I/Library/Frameworks/R.framework/Resources/include/i386 -I/
users/rrodriguez/Desktop/mysql-5.0.27/include -msse3 -
D__NO_MATH_INLINES -fPIC -fno-common -g -O2 -std=gnu99 -
march=pentium-m -mtune=prescott -c RS-MySQL.c -o RS-MySQL.o
gcc-4.0 -arch i386 -flat_namespace -bundle -undefined suppress -L/usr/
local/lib -o RMySQL.so RS-DBI.o RS-MySQL.o -L/users/rrodriguez/
Desktop/mysql-5.0.27/lib -lmysqlclient -lz -L/Library/Frameworks/
R.framework/Resources/lib/i386 -lR
/usr/bin/ld: warning -L: directory name (/users/rrodriguez/Desktop/
mysql-5.0.27/lib) does not exist
/usr/bin/ld: can't locate file for: -lmysqlclient
collect2: ld returned 1 exit status
make: *** [RMySQL.so] Error 1
chmod: /Library/Frameworks/R.framework/Versions/2.3/Resources/library/
RMySQL/libs/i386/*: No such file or directory
ERROR: compilation failed for package 'RMySQL'
** Removing '/Library/Frameworks/R.framework/Versions/2.3/Resources/
library/RMySQL'
ricardo-rodriguezs-computer:/Users/rrodriguez/Desktop root#
In fact there is no /iib folder where the compilation process is
calling for it. I am guessing I must first build MySQL, then install
it, then build RMySQL, but I am afraid that my programer skills are
too poor to solve this issue!
Currently I'm running MySQL max 5.0.27 for Mac/Intel in this box. By
pointing PKG_CPPFLAGS and PKG_LIBS to this directory I get a much,
much longer error log!
Any input will be welcome! Thanks,
--
Ricardo Rodríguez
Your EPEC ICT Team
[[alternative HTML version deleted]]
_______________________________________________
R-SIG-Mac mailing list
R-SIG-Mac@stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
