You log into the docker image, start R and connect to the DB. If this does not work try connecting to the DB via socket directly from the computer that hosts the DB using something like mysql -u root -pXXX -S /var/lib/mysql/mysql.sock (again set the proper path and password). Then you can start R from within the docker image and connect to the DB using con = RMariaDB::dbConnect( RMariaDB::MariaDB(), dbname = '.', username = '.', password = '.',unix.socket='/mysql.sock'). Just mount the docker image with docker run -v /var/lib/mysql/mysql.sock:/mysql.sock -it YourDockerImage bash (you need to set the proper path to your socket and use your docker image name of course). Without mysql client, you can test the connection using the R command listed above. My docker image is based on CentOS 7 and I use MariaDB, so installing the mysql client was done with RUN yum install -y MariaDB-client from the Dockerfile. Although for debugging, I found it easier to install the client also in my docker image. RUN R -e 'remotes::install_local('/')'ĬMD Ĭon = dbConnect(RMariaDB::MariaDB(), dbname = 'training_dash_db', user = 'root', password = '', host = '127.0.0.1')Īs far as I know, it is not required for R to work properly, that mysql client is installed. RUN R -e 'remotes::install_cran('roxygen2')' RUN R -e 'remotes::install_cran('RMariaDB')' RUN R -e 'remotes::install_cran('leaflet')' RUN R -e 'remotes::install_cran('shinyWidgets')' RUN R -e 'remotes::install_cran('tsibble')'

RUN R -e 'remotes::install_cran('tibbletime')' RUN R -e 'remotes::install_cran('plotly')' RUN R -e 'remotes::install_cran('purrr')' RUN R -e 'remotes::install_cran('dplyr')' RUN R -e 'remotes::install_cran('lubridate')' RUN R -e 'remotes::install_cran('shinydashboardPlus')' RUN R -e 'remotes::install_cran('shinydashboard')' RUN R -e 'remotes::install_cran('htmltools')' RUN R -e 'remotes::install_cran('attempt')' RUN R -e 'remotes::install_cran('processx')' RUN R -e 'remotes::install_github('Thinkr-open/golem')' RUN R -e 'remotes::install_cran('shiny')' RUN R -e 'remotes::install_github('r-lib/remotes', ref = '97bbf81')' The app itself runs ok on the port, but is not reactive because it cannot connect to the mysql databse.ĭockerfile looks like this: FROM colinfay/r-db:3.6.1 The shiny app is packaged in K2dashboard_*.tar.gz. The newest docker file I’ve used was based on r-db.

Docker phpmyadmin not accessible