Repository navigation
Expand file tree
/
Copy pathDockerfile
More file actions
86 lines (76 loc) · 3.42 KB
/
Copy pathDockerfile
File metadata and controls
86 lines (76 loc) · 3.42 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
FROM eclipse-temurin:21-jre-noble
LABEL maintainer="Chris Wells <chris@cevanwells.com>"
RUN apt-get update \
&& apt-get install -y --no-install-recommends unzip \
fontconfig \
fonts-dejavu-core \
gettext-base \
&& rm -rf /var/lib/apt/lists/*
ENV SQLWB_LIB_DIR=/usr/local/lib
WORKDIR $SQLWB_LIB_DIR
# Install PostgreSQL JDBC driver
ARG POSTGRESQL_JDBC_VERSION=42.7.14
ARG POSTGRESQL_JDBC_SHA256=73914527305a40cce504b0d3d90b23caf565136912d607ae8ae7c5895512332c
RUN curl -fsSL \
"https://repo.maven.apache.org/maven2/org/postgresql/postgresql/${POSTGRESQL_JDBC_VERSION}/postgresql-${POSTGRESQL_JDBC_VERSION}.jar" \
-o jdbc-postgresql.jar \
&& echo "${POSTGRESQL_JDBC_SHA256} jdbc-postgresql.jar" | sha256sum -c -
# Install MariaDB (mysql) JDBC driver
ARG MARIADB_JDBC_VERSION=3.5.10
ARG MARIADB_JDBC_SHA256=919b8c1c771d9ee3465811462f242c9543ab401e140c64988ddbf1d8abcb18b2
RUN curl -fsSL \
"https://repo.maven.apache.org/maven2/org/mariadb/jdbc/mariadb-java-client/${MARIADB_JDBC_VERSION}/mariadb-java-client-${MARIADB_JDBC_VERSION}.jar" \
-o jdbc-mariadb.jar \
&& echo "${MARIADB_JDBC_SHA256} jdbc-mariadb.jar" | sha256sum -c -
# Install MSSQL JDBC driver
ARG MSSQL_JDBC_VERSION=13.6.1.jre11
ARG MSSQL_JDBC_SHA256=4f470d23dfdf187ece2d1f9feb33d9dbd2230051b9c9676456727692a1b97d5e
RUN curl -fsSL \
"https://repo.maven.apache.org/maven2/com/microsoft/sqlserver/mssql-jdbc/${MSSQL_JDBC_VERSION}/mssql-jdbc-${MSSQL_JDBC_VERSION}.jar" \
-o jdbc-mssql.jar \
&& echo "${MSSQL_JDBC_SHA256} jdbc-mssql.jar" | sha256sum -c -
ENV SQLWB_BIN_DIR=/usr/local/bin \
SQLWB_SHARE_DIR=/usr/local/share/sqlworkbench \
SQLWB_VERSION=Build133-with-optional-libs
WORKDIR $SQLWB_SHARE_DIR
ARG SQLWB_SHA256=66b9d76293dd484cab77e7caf9ffb7469da8c2f38b7f835252b9ad0a1a61789d
RUN curl -fsSL "https://www.sql-workbench.eu/archive/Workbench-$SQLWB_VERSION.zip" -o sqlworkbench-$SQLWB_VERSION.zip \
&& echo "${SQLWB_SHA256} sqlworkbench-$SQLWB_VERSION.zip" | sha256sum -c - \
&& unzip -q sqlworkbench-$SQLWB_VERSION.zip \
&& chmod +x sqlwbconsole.sh \
&& ln -s `readlink -f sqlwbconsole.sh` $SQLWB_BIN_DIR/ \
&& rm -f sqlworkbench-$SQLWB_VERSION.zip
ENV SQLWB_APP_DIR=/app \
SQLWB_CONFIG_DIR=/app/config \
SQLWB_EXPORT_DIR=/app/exports \
SQLWB_LOG_DIR=/app/log \
SQLWB_SCRIPT_DIR=/app/sql
WORKDIR $SQLWB_APP_DIR
RUN mkdir -p config exports log sql \
&& addgroup --system appworker \
&& adduser --system \
--disabled-password \
--no-create-home \
--gecos "" \
--home "$SQLWB_APP_DIR" \
--ingroup appworker \
appworker \
&& chown appworker:appworker -R $SQLWB_APP_DIR
WORKDIR $SQLWB_SHARE_DIR
COPY config/* ./config/
COPY sql/* ./sql/
ONBUILD ARG SQLWB_INSTALL_EXTRA_PACKAGES
ONBUILD USER root
ONBUILD RUN test -n "$SQLWB_INSTALL_EXTRA_PACKAGES" \
&& apt-get update \
&& apt-get install -y --no-install-recommends $SQLWB_INSTALL_EXTRA_PACKAGES \
&& rm -rf /var/lib/apt/lists/*
ONBUILD USER appworker
ONBUILD COPY --chown=appworker config/* $SQLWB_APP_DIR/config/
ONBUILD COPY --chown=appworker sql/* $SQLWB_APP_DIR/sql/
WORKDIR /usr/local/bin
COPY bin/* ./
RUN chmod +x docker-entrypoint.sh docker-cmd.sh
USER appworker
ENTRYPOINT ["/usr/local/bin/docker-entrypoint.sh"]
CMD []