Installation bibliothèque R RMySQL

J'aurais besoin d'une librairie CRAN RMySQL mais elle dépend apparemment de librairies systèmes qui ne sont pas installés sur le cluster. Serait-il possible d'installer cette librairie R et ses dépendances ?

Merci

Jacques

* installing *source* package ‘RMySQL’ ...
** package ‘RMySQL’ successfully unpacked and MD5 sums checked
Using PKG_CFLAGS=
Using PKG_LIBS=-lmysqlclient

------------------------- ANTICONF ERROR ---------------------------

Configuration failed because no mysql client library was found. Try installing:
 * deb: libmariadbclient-dev | libmariadb-client-lgpl-dev (Debian, Ubuntu)
 * rpm: mariadb-connector-c-devel | mariadb-devel | mysql-devel (Fedora, CentOS, RHEL)
 * csw: mysql56_dev (Solaris)
 * brew: mariadb-connector-c (OSX)
If you already have a mysql client library installed, verify that either

mariadb_config or mysql_config is on your PATH. If these are unavailable
you can also set INCLUDE_DIR and LIB_DIR manually via:

R CMD INSTALL --configure-vars='INCLUDE_DIR=... LIB_DIR=...'

--------------------------------------------------------------------

ERROR: configuration failed for package ‘RMySQL’

* removing ‘/shared/mfs/data/home/jvanhelden/R/x86_64-conda_cos6-linux-gnu-library/3.5/RMySQL’

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

Bonjour @jvanhelden,

Tu as aussi besoin d'une base de données mysql ou juste le client ?

A priori je pense que cette librairie s'appuie sur un simple client mySQL

Using PKG_LIBS=-lmysqlclient

[...]
If you already have a mysql client library installed, verify that either

mariadb_config or mysql_config is on your PATH. If these are unavailable
you can also set INCLUDE_DIR and LIB_DIR manually via:

R CMD INSTALL --configure-vars='INCLUDE_DIR=... LIB_DIR=...'

Ah, peut-être existe-t-il déjà un module client mysql sur le cluster, que je devrais charger avant de lancer R ? Mais comment le lancer pour qu'il soit dispo sur le serveur RStudio ?

MR en cours :
https://gitlab.cluster.france-bioinformatique.fr/taskforce-nncr/ansible/merge_requests/383

@jvanhelden
Nous venons d'installer le client mysql sur le serveur rstudio.
Tiens-nous au courant