Versions Compared

Old Version 9

changes.mady.by.user Kirstin Seidel-Gebert

Saved on

compared with

New Version 10

changes.mady.by.user Kirstin Seidel-Gebert

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space WINSTALLATION and version 9

...

Div

To install the BRIDGE you can use the Docker image delivered by us but you can also create a BRIDGE Docker image of your own to fulfill special needs. You can do this from scratch, or you can use the delivered BRIDGE Docker image and change it according to your needs.

The BRIDGE Docker image is built in two steps:

  1. Creation of a Debian basic image containing an Oracle and an SQL Server instant client.
  2. Creation of the actual BRIDGE image on base of the Debian basic image.

Required Files to Create a BRIDGE Docker Image

If you want to create the BRIDGE Docker image you need the following files:

...

You can download a ZIP archive containing all files that are marked with In ZIP from our download page.

The Debian Basic Docker File Explained

In a first step, a Debian basic image is created that is used later on as a base for the actual BRIDGE image. Expand the code section below to see and copy & paste the Docker file.

...

CodeDescription
Preparations - Get an Oracle Instant Client
ARG INSTANTCLIENT_VERSION
ARG SQLSERVER_VERSION
Provide the actually used versions, e.g. INSTANTCLIENT_VERSION=19.6 and SQLSERVER_VERSION=17.5.2.1-1 with the call.
FROM oraclelinux:7-slim AS oracleclient
Download Oracle Linux image.
RUN curl -o /etc/yum.repos.d/public-yum-ol7.repo https://yum.oracle.com/public-yum-ol7.repo && \
    yum-config-manager --enable ol7_oracle_instantclient && \
    yum -y install oracle-instantclient$INSTANTCLIENT_VERSION-basiclite && \
    rm -rf /var/cache/yum
Install instant client to Oracle Linux image.

Creating the Debian Basic Image

FROM debian:buster-slim
Download Debian buster slim image.
ARG INSTANTCLIENT_VERSION
ARG SQLSERVER_VERSION
See further above.
ENV LANG=C.UTF-8
ENV TZ="Europe/Zurich"
Set language and timezone in the system environment.
ENV LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
ENV PATH=$PATH:$JAVA_HOME/bin:$ORACLE_HOME
Configure the Oracle Database client library.
RUN apt-get update -q \
    && apt-get install -qq sudo procps curl net-tools unzip vim mariadb-client gnupg apt-transport-https \
Install necessary packages.
    && curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - 
    && echo "deb https://packages.microsoft.com/debian/10/prod/ buster main" > /etc/apt/sources.list.d/msprod.list \
    && apt-get update -q \
    && ACCEPT_EULA=y apt-get install -qq msodbcsql17:amd64=$SQLSERVER_VERSION mssql-tools:amd64=$SQLSERVER_VERSION \
Install MS SQL Server.
    && rm -rf /var/lib/apt/lists/* \

    && groupadd -r bridge \
    && useradd -r --create-home -g bridge bridge \
As the BRIDGE should not be run as root, create a group bridge and a user bridge.
    && (cd /etc; ln -f -s /usr/share/zoneinfo/$TZ localtime)
Set timezone.
RUN mkdir /opt/oracle
COPY --chown=root:root --from=oracleclient /usr/lib/oracle/$INSTANTCLIENT_VERSION/client64/lib /opt/oracle
Copy instantclient from Oracle Linux image.
COPY --chown=bridge:bridge proxies.xml /opt/bridge_data/proxies/
Configure proxies.xml. Only needed if sudo package is installed.
COPY --chown=bridge:bridge server.cfg /opt/bridge_data/server.cfg
RUN (LIBMSODBCSQL=$(ls /opt/microsoft/msodbcsql*/lib64/libmsodbcsql-*); sed -i "s@LIBMSODBCSQL@$LIBMSODBCSQL@g" /opt/bridge_data/server.cfg
Configure MySQL and MS SQL Server client libraries.
ENV ORACLE_HOME=/opt/oracle
Set environment for Oracle home directory.

The BRIDGE Docker File Explained

In a second step, the actual BRIDGE image is created on base of the previously created Debian basic image. Expand the code section below to see and copy & paste the Docker file.

...