FAQ
install packages RMySQL fail.

System Fedora Core 6 x86_64

see down. It's bug or incomplete install MySQL?

Juan.

______________________________________________________________
PROMPT MySQL

$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
______________________________________________________________

PROMPT R INSTALLING RMySQL
install.packages()
tentando a URL
'http://www.insecta.ufv.br/CRAN/src/contrib/RMySQL_0.5-10.tar.gz'
Content type 'application/x-tar' length 142671 bytes
URL aberta
==================================================
downloaded 139Kb

* 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
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
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.

INSTRUCTIONS:

1. Define and export the 2 shell variables PKG_CPPFLAGS and
PKG_LIBS to include the directory for header files (*.h)
and libraries, for example (using Bourne shell syntax):

export PKG_CPPFLAGS="-I<MySQL-include-dir>"
export PKG_LIBS="-L<MySQL-lib-dir> -lmysqlclient"

Re-run the R INSTALL command:

R CMD INSTALL RMySQL_<version>.tar.gz

2. Alternatively, you may pass the configure arguments
--with-mysql-dir=<base-dir> (distribution directory)
or
--with-mysql-inc=<base-inc> (where MySQL header files reside)
--with-mysql-lib=<base-lib> (where MySQL libraries reside)
in the call to R INSTALL --configure-args='...'

R CMD INSTALL --configure-args='--with-mysql-dir=DIR'
RMySQL_<version>.tar.gz

ERROR: configuration failed for package 'RMySQL'
** Removing '/usr/lib64/R/library/RMySQL'

The downloaded packages are in
/tmp/Rtmpioa2vr/downloaded_packages
Warning message:
installation of package 'RMySQL' had non-zero exit status in:
install.packages()

Search Discussions

  • Seth Falcon at Oct 29, 2006 at 4:44 pm

    Juan Santiago Ramseyer <juan_sr@uol.com.br> writes:

    install packages RMySQL fail.

    System Fedora Core 6 x86_64

    see down. It's bug or incomplete install MySQL?
    You need to install the devel headers for MySQL. This should be
    available as an rpm for your system.

    + seth
  • Juan Santiago Ramseyer at Nov 2, 2006 at 1:45 am
    thank you,

    I make in R:
    install.packages(DBI)

    and fix ambient variables of linux:
    export PKG_CPPFALGS="-I/usr/include/mysql"
    export PKG_LIBS="-L/usr/lib64/mysql -lmysqlclient"

    after:
    install.packages(RMySQL)

    is successful.

    Juan.
    Em Dom, 2006-10-29 ?s 08:44 -0800, Seth Falcon escreveu:
    Juan Santiago Ramseyer <juan_sr@uol.com.br> writes:
    install packages RMySQL fail.

    System Fedora Core 6 x86_64

    see down. It's bug or incomplete install MySQL?
    You need to install the devel headers for MySQL. This should be
    available as an rpm for your system.

    + seth

    ______________________________________________
    R-devel at r-project.org mailing list
    https://stat.ethz.ch/mailman/listinfo/r-devel

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupr-devel @
categoriesr
postedOct 29, '06 at 3:58p
activeNov 2, '06 at 1:45a
posts3
users2
websiter-project.org
irc#r

People

Translate

site design / logo © 2022 Grokbase