Could you explain what an R package is? Is is the statistical analysis package or does it have something to do with ISDN?
I'm not familiar with the "R CMD INSTALL" command, but it might be looking for the mysql socket rather than the mysql command itself. Or it might be examining the /etc/my.cnf file.
Most likely, the R CMD INSTALL command untars the tarball, runs the configure program and then make && make install.
If that is the case, use the:
--with-mysql-dir=MYSQL_DIR specifies an existing MySQL base dir
--with-mysql-inc=MYSQL_INC specifies an existing MySQL include dir
--with-mysql-lib=MYSQL_LIB specifies an existing MySQL lib dir
options.
From the configure.in file:
Code:
dnl 2. We check for mysql.h and -lmysqlclient in system directories, and if
dnl found, we use these (provide the user does not explicitly request
dnl another version, see below). Notice that the MySQL source distribution
dnl installs by default to /usr/local/lib/mysql and /usr/local/include/mysql
dnl
dnl 3. Alternatively, if the user specifies explicitly a particular MySQL
dnl installation we use that version. This can be requested through
dnl --with-mysql-dir=DIR
dnl --with-mysql-inc=<include-DIR>
dnl or --with-mysql-lib=<library-DIR>
dnl
dnl (these are equivent to setting and exporting MYSQL_{DIR,INC,LIB})
dnl In the first case, DIR is assumed to include the lib and include
dnl subdirectories; individual locations of these two may be
dnl specified independently through <include-inc> and <library-dir>,
dnl respectively. If we found these, we exit.
dnl
dnl 4. We check for the GNU implementation of getopt_long and set the
dnl C preprocessor macro HAVE_GETOPT_LONG accordingly. On windows
dnl (including MinGW) should be false.
dnl
dnl Global variables: The following variables may be set and exported
dnl prior to running configure:
dnl PKG_CPPFLAGS, PKG_LIBS, MYSQL_DIR, MYSQL_INC, MYSQL_LIB
You could first enter:
Code:
MYSQL_LIB=/usr/lib/mysql ( or /usr/lib64/mysql depending on your architecture )
MYSQL_DIR=/usr/bin ( I think it should be the directory where the mysql* commands are located )
export MYSQL_LIB MYSQL_DIR
And then give your "R CMD INSTALL" command another whirl.
I don't know about MYSQL_INC, That one sounds like it would be from the mysql source.