[R] RMySQL install

[Michaell Taylor]

I am having some trouble getting RMySQL installed.  Thought there might be 
some ideas out there.  The problem:

MySQL 3.23.47 is installed (server,devel, client, benchmarks,shared) and 
seems to be working.  R 1.4.0 is working.

>On first install attempt I get :
>
>checking for mysql_init in -lmysqlclient... no
>checking for /usr/local/include/mysql/mysql.h... no
>checking for /usr/include/mysql/mysql.h... yes
>
>Configuration error:
>  could not find the MySQL installation include and/or library
>  directories.  Manually specify the location of the MySQL
>  libraries and the header files and re-run R CMD INSTALL.

following the instructions, I:
 export MYSQL_DIR="/usr"
then,
R CMD INSTALL RMySQL_0.4-3.tar.gz

Seems to have solved the problem, no errors, help files built, etc.  BUT...

> library(RMySQL)
Error in dyn.load(x, as.logical(local), as.logical(now)) :
        unable to load shared library 
"/usr/local/lib/R/library/RMySQL/libs/RMySQL.so":
  /usr/local/lib/R/library/RMySQL/libs/RMySQL.so: undefined symbol: 
mysql_field_count
Error in library(RMySQL) : .First.lib failed

repeated the process on a similar (but apparently not the same) box - no 
problems, didn't even have to specify the mysql home directory as a shell 
variable.  

Tried rebuilding R and MySQL - didn't help.  Otherwise R and MySQL seem to be 
working.

Has anyone seen this problem before?  Thanks in advance.
=========================================
Michaell Taylor, PhD
Senior Economist, Reis, New York, USA
Professor, NTNU, Norway
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._