System dependencies on fedora for RMariaDB

[jonkeane]

I've run a few builds on r-hub (with rhub::check_for_cran()) and it seems that RMariaDB is failing to install on Fedora Linux, R-devel, clang, gfortran. It looks like a system dependency (mariadb-connector-c-devel or mariadb-devel or mysql-devel) isn't being installed.

I'm seeing the following in my build log:

* installing *source* package ‘RMariaDB’ ...
** package ‘RMariaDB’ successfully unpacked and MD5 sums checked
** using staged installation
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, libssl-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 ‘RMariaDB’
* removing ‘/home/docker/R/RMariaDB’

I suspect this might be resolved with this PR to sysreqdb: https://github.com/r-hub/sysreqsdb/pull/72

Example log: https://builder.r-hub.io/status/original/dittodb_0.1.0.tar.gz-ee37b7bb08b644c6b0d5401185a4e36d

[ankane]

Seeing this with RMySQL on Fedora as well.

1096#> --------------------------[ ERROR MESSAGE ]----------------------------
1097#> :1:10: fatal error: 'mysql.h' file not found
1098#> #include
1099#> ^~~~~~~~~
1100#> 1 error generated.
1101#> -----------------------------------------------------------------------
1102#> ERROR: configuration failed for package ‘RMySQL’

Ref: https://builder.r-hub.io/status/dbx_0.2.6.tar.gz-df9e5964b01a4ee09f55c6f88962729e

[gaborcsardi]

This issue is about the previous R-hub system, it does not apply to the new system, so I am closing it now. Please see https://r-hub.github.io/rhub/ for the new system, R-hub v2.