Block a user
webdb (v1)
Published 2024-08-15 14:03:09 +00:00 by administrator
Installation
docker pull gitea.hessj.de/administrator/webdb:v1sha256:5938232c6cc8ac16b0ff24267c300603b55f589303e6665cf9b98d098bc398b2Image Layers
| ADD file:2726e2d5d9aaf4024ea489d9049884aa06c0c95d6111037ba29987ba029ddc44 in / |
| CMD ["/bin/bash"] |
| RUN /bin/sh -c set -eux; groupadd --system --gid 999 mysql; useradd --system --uid 999 --gid 999 --home-dir /var/lib/mysql --no-create-home mysql # buildkit |
| ENV GOSU_VERSION=1.16 |
| RUN /bin/sh -c set -eux; arch="$(uname -m)"; case "$arch" in aarch64) gosuArch='arm64' ;; x86_64) gosuArch='amd64' ;; *) echo >&2 "error: unsupported architecture: '$arch'"; exit 1 ;; esac; curl -fL -o /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$gosuArch.asc"; curl -fL -o /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$gosuArch"; export GNUPGHOME="$(mktemp -d)"; gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4; gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu; rm -rf "$GNUPGHOME" /usr/local/bin/gosu.asc; chmod +x /usr/local/bin/gosu; gosu --version; gosu nobody true # buildkit |
| RUN /bin/sh -c set -eux; yum install -y --setopt=skip_missing_names_on_install=False oracle-epel-release-el7; yum install -y --setopt=skip_missing_names_on_install=False bzip2 gzip openssl xz zstd ; yum clean all # buildkit |
| RUN /bin/sh -c set -eux; key='859BE8D7C586F538430B19C2467B942D3A79BD29'; export GNUPGHOME="$(mktemp -d)"; gpg --batch --keyserver keyserver.ubuntu.com --recv-keys "$key"; gpg --batch --export --armor "$key" > /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql; rm -rf "$GNUPGHOME" # buildkit |
| ENV MYSQL_MAJOR=5.7 |
| ENV MYSQL_VERSION=5.7.44-1.el7 |
| RUN /bin/sh -c set -eu; . /etc/os-release; { echo '[mysql5.7-server-minimal]'; echo 'name=MySQL 5.7 Server Minimal'; echo 'enabled=1'; echo "baseurl=https://repo.mysql.com/yum/mysql-5.7-community/docker/el/${VERSION_ID%%[.-]*}/\$basearch/"; echo 'gpgcheck=1'; echo 'gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql'; echo 'module_hotfixes=true'; } | tee /etc/yum.repos.d/mysql-community-minimal.repo # buildkit |
| RUN /bin/sh -c set -eux; yum install -y --setopt=skip_missing_names_on_install=False "mysql-community-server-minimal-$MYSQL_VERSION"; yum clean all; grep -F 'socket=/var/lib/mysql/mysql.sock' /etc/my.cnf; sed -i 's!^socket=.*!socket=/var/run/mysqld/mysqld.sock!' /etc/my.cnf; grep -F 'socket=/var/run/mysqld/mysqld.sock' /etc/my.cnf; { echo '[client]'; echo 'socket=/var/run/mysqld/mysqld.sock'; } >> /etc/my.cnf; ! grep -F '!includedir' /etc/my.cnf; { echo; echo '!includedir /etc/mysql/conf.d/'; } >> /etc/my.cnf; mkdir -p /etc/mysql/conf.d; { echo '!includedir /etc/mysql/mysql.conf.d/'; } >> /etc/my.cnf; mkdir -p /etc/mysql/mysql.conf.d; find /etc/my.cnf /etc/mysql/ -name '*.cnf' -print0 | xargs -0 grep -lZE '^(bind-address|log)' | xargs -rt -0 sed -Ei 's/^(bind-address|log)/#&/'; mkdir -p /var/lib/mysql /var/run/mysqld; chown mysql:mysql /var/lib/mysql /var/run/mysqld; chmod 1777 /var/lib/mysql /var/run/mysqld; mkdir /docker-entrypoint-initdb.d; mysqld --version; mysql --version # buildkit |
| RUN /bin/sh -c set -eu; . /etc/os-release; { echo '[mysql-tools-community]'; echo 'name=MySQL Tools Community'; echo "baseurl=https://repo.mysql.com/yum/mysql-tools-community/el/${VERSION_ID%%[.-]*}/\$basearch/"; echo 'enabled=1'; echo 'gpgcheck=1'; echo 'gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql'; echo 'module_hotfixes=true'; } | tee /etc/yum.repos.d/mysql-community-tools.repo # buildkit |
| ENV MYSQL_SHELL_VERSION=8.0.35-1.el7 |
| RUN /bin/sh -c set -eux; yum install -y --setopt=skip_missing_names_on_install=False "mysql-shell-$MYSQL_SHELL_VERSION"; yum clean all; mysqlsh --version # buildkit |
| VOLUME [/var/lib/mysql] |
| COPY docker-entrypoint.sh /usr/local/bin/ # buildkit |
| RUN /bin/sh -c ln -s usr/local/bin/docker-entrypoint.sh /entrypoint.sh # backwards compat # buildkit |
| ENTRYPOINT ["docker-entrypoint.sh"] |
| EXPOSE map[3306/tcp:{} 33060/tcp:{}] |
| CMD ["mysqld"] |
| RUN /bin/sh -c yum install cronie -y # buildkit |
| RUN /bin/sh -c echo "0 0 * * * /scripts/dbBackup.sh" >> /etc/cron.d/backup-cron-job # buildkit |
| RUN /bin/sh -c chmod 0644 /etc/cron.d/backup-cron-job # buildkit |
| RUN /bin/sh -c mkdir /scripts # buildkit |
| COPY dbBackup.sh /scripts/dbBackup.sh # buildkit |
| RUN /bin/sh -c chmod 0777 /scripts -R # buildkit |
| RUN /bin/sh -c crontab /etc/cron.d/backup-cron-job # buildkit |
| ENV TZ=Europe/Berlin |
| RUN /bin/sh -c ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone # buildkit |
| CMD ["/bin/sh" "-c" "crond && mysqld"] |