On Mon, 14 Mar 2005, Ko,Younhee wrote:
Hi, I have some problem to install RMySQL package. Could you help me?
Please tell us your OS, R version, etc.
I set up the path.
You set a couple of variables, but no path. (These at most supplement the include and library paths.)
[EMAIL PROTECTED] library]# export PKG_CPPFLAGS="-I/var/lib/mysql" [EMAIL PROTECTED] library]# export PKG_LIBS="-L/var/lib/mysql - lmysqlclient"
Looks like your MySQL files are not where you claim they: I would not expect them to be there (headers are not normally in a 'lib' directory), but where they are depends on whether this is an installation from the sources (not likely if it uses /var/lib), RPM etc. E.g. FC3 has
checking for mysql_init in -lmysqlclient... yes
mysqlclient found in -L/usr/lib/mysql
checking for /usr/local/include/mysql/mysql.h... no
checking for /usr/include/mysql/mysql.h... yesNote to David James as maintainer: should not finding these be an error, or at least give a very loud warning from configure?
[EMAIL PROTECTED] library]# R CMD INSTALL /home/younko/RMySQL_0.5- 5.tar.gz
I got this bunch of error message.
Please help me.
* 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 gcc -I/usr/local/lib/R/include -I/var/lib/mysql - I/usr/local/include -fPIC -g -O2 -c RS-DBI.c -o RS-DBI.o gcc -I/usr/local/lib/R/include -I/var/lib/mysql - I/usr/local/include -fPIC -g -O2 -c RS-MySQL.c -o RS- MySQL.o In file included from RS-MySQL.c:22: RS-MySQL.h:40:19: mysql.h: No such file or directory RS-MySQL.h:41:27: mysql_version.h: No such file or directory RS-MySQL.h:42:23: mysql_com.h: No such file or directory
That's sufficient info.
-- Brian D. Ripley, [EMAIL PROTECTED] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
