turingears/sql-clients

By turingears

Updated 9 months ago

Imagen para utilizar diversos gestores de bases de datos

Image
Databases & Storage
0

176

Docker image with the following components
  • sqlplus
  • sqlcmd
  • bcp
  • mysql-client
  • psql
  • java 11
  • maven

Dockerfile

FROM centos:8
WORKDIR /app
RUN sed -i -e "s|mirrorlist=|#mirrorlist=|g" /etc/yum.repos.d/CentOS-* && \
    sed -i -e "s|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g" /etc/yum.repos.d/CentOS-*
RUN yum install -y \
    java-11-openjdk \
    java-11-openjdk-devel \
    python3 \
    curl \
    ncurses \
    postgresql \
    mysql \
    unixODBC-devel \
    openssl \
    libnsl \
    dos2unix \
    zip \
    unzip \
    libaio && \
    yum clean all && \
    rm -rf /var/cache/yum
RUN yum install -y python38 \
    && alternatives --install /usr/bin/unversioned-python python /usr/bin/python3.8 1 \
    && alternatives --set python /usr/bin/python3.8
ADD https://download.oracle.com/otn_software/linux/instantclient/2340000/oracle-instantclient-basic-23.4.0.24.05-1.el8.x86_64.rpm basic.rpm
ADD https://download.oracle.com/otn_software/linux/instantclient/2340000/oracle-instantclient-sqlplus-23.4.0.24.05-1.el8.x86_64.rpm sqlplus.rpm
ADD https://download.oracle.com/otn_software/linux/instantclient/2340000/oracle-instantclient-tools-23.4.0.24.05-1.el8.x86_64.rpm tools.rpm
ADD https://packages.microsoft.com/rhel/9/prod/Packages/m/mssql-tools18-18.1.1.1-1.x86_64.rpm mssql.rpm
ADD https://packages.microsoft.com/rhel/9/prod/Packages/m/msodbcsql18-18.3.2.1-1.x86_64.rpm msodbcsql18.rpm
ADD https://dlcdn.apache.org/maven/maven-3/3.9.8/binaries/apache-maven-3.9.8-bin.tar.gz apache-maven-3.9.8-bin.tar.gz
ARG ACCEPT_EULA=y
RUN rpm -i *.rpm && \
    tar xf apache-maven-3.9.8-bin.tar.gz -C /opt && \
    ln -s /opt/apache-maven-3.9.8 /opt/maven && \
    rm -rf *
ENV ORACLE_HOME /usr/lib/oracle/23.4/client64
ENV LD_LIBRARY_PATH $ORACLE_HOME/lib
ENV PATH $ORACLE_HOME/bin:$PATH
ENV PATH $PATH:/opt/mssql-tools/bin
ENV JAVA_HOME /usr/lib/jvm/jre-openjdk
ENV M2_HOME /opt/maven
ENV MAVEN_HOME /opt/maven
ENV PATH /opt/maven/bin:${PATH}
RUN ln -s /opt/mssql-tools18/bin/sqlcmd /usr/local/bin/sqlcmd
RUN ln -s /opt/mssql-tools18/bin/bcp /usr/local/bin/bcp
ADD https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip ./awscliv2.zip
ADD https://dl.google.com/dl/cloudsdk/release/google-cloud-sdk.tar.gz ./google-cloud-sdk.tar.gz
RUN unzip -qq awscliv2.zip && \
    tar zxf google-cloud-sdk.tar.gz && \
    mv /app/google-cloud-sdk /google-cloud-sdk
RUN /app/aws/install -i /usr/local/aws-cli -b /usr/local/bin && \
    /google-cloud-sdk/install.sh --usage-reporting=false --path-update=false --quiet && \
    rpm --import https://packages.microsoft.com/keys/microsoft.asc && \
    echo -e "[azure-cli] \nname=Azure CLI \nbaseurl=https://packages.microsoft.com/yumrepos/azure-cli \nenabled=1 \ngpgcheck=1 \ngpgkey=https://packages.microsoft.com/keys/microsoft.asc" | tee /etc/yum.repos.d/azure-cli.repo && \
    yum install -y azure-cli && \
    rm -rf /root/tools/google-cloud-sdk/.install/.backup && \
    yum clean all && \
    rm -rf /var/cache/yum && \
    rm -rf /app/* && \
    rm -rf /tmp/*
ENV PATH $PATH:/google-cloud-sdk/bin

Docker Pull Command

docker pull turingears/sql-clients