macmule
commented
2 months ago Adding more details in case it helps, Dockerfile below:
# MySQL Version
ARG build_ver
# Base Details
FROM mysql:"${build_ver}"-debian
# build_type var
ARG build_type
# Delete list as contains expired key - https://github.com/apache/airflow/issues/36231#issuecomment-1856583460
RUN /bin/rm /etc/apt/sources.list.d/mysql.list
# Package installs
RUN /usr/bin/apt-get update && /usr/bin/apt-get install -y --no-install-recommends \
ca-certificates \
curl \
nano \
procps \
tzdata
# Timezone
# https://serverfault.com/a/826222
ENV TZ=Europe/London
# Papertrail (pull latest)
RUN RS_LATEST=$(/usr/bin/curl -Ls -o /dev/null -w %{url_effective} https://github.com/papertrail/remote_syslog2/releases/latest | /usr/bin/awk -F / '{$
/usr/bin/curl -SL https://github.com/papertrail/remote_syslog2/releases/download/v"${RS_LATEST}"/remote_syslog_linux_amd64.tar.gz -o /tmp/remote_s$
/bin/tar -xzf /tmp/remote_syslog_linux_amd64.tar.gz -C /tmp; \
/bin/mv /tmp/remote_syslog/remote_syslog /usr/local/bin; \
/bin/chmod +x /usr/local/bin/remote_syslog
# Papertrail config items
# from: https://github.com/papertrail/remote_syslog2/blob/master/README.md
COPY ./"${build_type}"/config/remote_syslog /etc/init.d/
RUN /bin/ln -s /etc/init.d/remote_syslog /etc/rc3.d/S30remote_syslog
# Config
COPY ./"${build_type}"/config/my.cnf /etc/mysql
COPY ./"${build_type}"/config/log_files.yml /etc/log_files.yml
COPY ./"${build_type}"/mysql/run.sh /usr/local/bin/
# Run
RUN /bin/mkdir -p /etc/mysql/mysql.conf.d/; \
/bin/chmod -R a+rx /etc/mysql/mysql.conf.d/; \
/bin/mkdir -p /var/log/mysql/; \
/bin/chmod -R a+rx /var/log/mysql; \
/bin/chmod +x /usr/local/bin/run.sh
# Housekeeping
RUN /usr/bin/apt-get clean; \
/bin/rm -rf /tmp/*; \
/bin/rm -rf /var/lib/apt/lists/*
# Environment variables
ENV TERM xterm
CMD ["/usr/local/bin/run.sh"]Where build_type and build_ver are arguments passed where building with Docker..
and my.cnf:
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
authentication-policy = mysql_native_password
ignore-db-dir = lost+found
log_error = /var/log/mysql/mysql_error.log
long_query_time = 10
max_allowed_packet = 1G
max_connections = 241
slow_query_log = on
slow_query_log_file = /var/log/mysql/mysql-slow.log
[mysqld_safe]
log_error = /var/log/mysql/mysql_error.log
tianon
yosifkit
Hi folks,
We've been running various flavours of mysql 5.7.x for a few years, and now one of the items we're hosting requires 8.0.34 (prior release was 5.7.39).
In attempting to upgrade the deployment, it seems that the
/usr/local/bin/docker-entrypoint.shruns once as root and then attempts to run as the usermysql.. this latter step fails.. and then we have no logging to advise why (despite passing--verboseto/usr/local/bin/docker-entrypoint.sh)..The
/usr/local/bin/docker-entrypoint.sh, is loaded within our images own entrypoint and per the below:Prior to upgrading, we're gracefully shutting down mysql 5.7 via mysqladmin.
I'm just a little stumped as no real helpful logs to advise what the issue is, so help appreciated!