Connection to Oracle DB inside Shinyproxy


#1

Hi all,

I cannot connect to an Oracle db from inside Shinyproxy. I have done it successfully from inside the docker image, but when shinyproxy starts it fails…

Are there any known issues? Perhaps permissions or the Java Environment needs to be set in a different way?

Here are the details of my Dockerfile regarding the Oracle setup Options:

RUN sudo apt-get install libaio1 libaio-dev
ADD instantclient_12_2 /usr/local/lib/instantclient_12_2
COPY libsqora.so.12.1 /usr/local/lib/instantclient_12_2/libsqora.so.12.1
ADD odbc.ini /etc/odbc.ini
ADD odbcinst.ini /etc/odbcinst.ini
ADD tnsnames.ora /etc/oracle/tnsnames.ora
ENV ORACLE_HOME=/usr/local/lib/instantclient_12_2/
ENV LD_LIBRARY_PATH=/usr/local/lib/instantclient_12_2/
ENV LD_LIBRARY_PATH64=/usr/local/lib/instantclient_12_2/
ENV JAVA_HOME=/usr/lib/jvm/java-8-oracle


#2

Hi mimaque,

Do you get any error message when you run your app without shinyproxy? Try like this from bash line:

docker run -p 3838:3838 -it DOCKER_IMAGE_ID R -e “shiny::runApp(‘YOUR_APP_PATH’)”

In bash line you should be able to see all error messages that your app is reporting.

You can try to open your app in browser on 0.0.0.0:3838 (for ex. if no error occur and you have to click sth in your app).