jc21 / docker-mariadb-aria Goto Github PK

View Code? Open in Web Editor NEW

29.0 6.0 10.0 20 KB

Docker extension of the mariadb image that forces aria storage engine

Dockerfile 23.19% Shell 76.81%

docker-mariadb-aria's Introduction

mariadb-ariadb

This is a simple extension of yobasystems/alpine-mariadb image that forces aria storage engine by default.

It supports the same configuration options as the source image.

Docker Secrets

This image supports the use of Docker secrets to import from file and keep sensitive usernames or passwords from being passed or preserved in plaintext.

You can set any environment variable from a file by appending __FILE (double-underscore FILE) to the environmental variable name.

version: '3.7'

secrets:
  # Secrets are single-line text files where the sole content is the secret
  # Paths in this example assume that secrets are kept in local folder called ".secrets"
  DB_ROOT_PWD:
    file: .secrets/db_root_pwd.txt
  MYSQL_PWD:
    file: .secrets/mysql_pwd.txt

services
  mariadb:
    image: jc21/mariadb-aria
    container_name: mariadb
    secrets:
      - DB_ROOT_PWD
      - MYSQL_PWD
    environment:
      # MYSQL_ROOT_PASSWORD: "npm"  # use secret instead
      MYSQL_ROOT_PASSWORD__FILE: /run/secrets/DB_ROOT_PWD
      MYSQL_DATABASE: "npm"
      MYSQL_USER: "npm"
      # MYSQL_PASSWORD: "npm"  # use secret instead
      MYSQL_PASSWORD__FILE: /run/secrets/MYSQL_PWD 
    volumes:
      - ./data/mysql:/var/lib/mysql

View on DockerHub

docker-mariadb-aria's People

Contributors

Stargazers

Watchers

Forkers

mblakleyiii rudders jdomotics alexezodoo directhits zxp drivestore bilbini wanimatrix yp-docker

docker-mariadb-aria's Issues

where is this standard cnf file to modify?

i would like to modify the cnf file
where is the location for it?

Incorrect definition of table mysql.column_stats: expected 'hist_type' 'histogram'

Hello there,

I am not sure if it has to do with the 262c780 commit but I've been seeing the following errors in the docker logs the past day:

2023-11-27 20:37:31 4 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').

2023-11-27 20:37:31 4 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).

Is this anything of note or can it be ignored?
The nginxproxymanager docker container that relies on the docker-mariadb-aria container is working normally as far as I can tell.

Docker tag 10.4 missing

Since I first started using Nginx-proxy-manager I was using docker image jc21/mariadb-aria:10.4 for the DB.

I just switched to :latest and now get the error:

[Global ] › ✖ error select * from migrations_lock - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'

I notice in the release notes it says if you get this error to stick with 10.4 but this tag (and therefore the image) is no longer listed on Docker hub. So its not possible to re-pull this image.

Fortunately, I didn't delete my local copy so can revert for now but not an ideal long term solution.

Is there any guidance available on how to migrate to a support version?

CVE-2021-27928 - remote code execution

https://nvd.nist.gov/vuln/detail/CVE-2021-27928

Can this docker image be updated to fix this vulnerability?

Automatic updates?

Hi,

I noticed that this docker image (last updated several months ago) is several versions behind the yobasystems image (last updated 11 days ago).

Is there any way updates can be automated? Or suggestions for how to use the yobasystems docker image and force aria?

Thanks,

Gabe

standard_init_linux.go:211

Hi!
New here, so please speak slowly... 😉

version: "3"
services:
  mariadb:
    image: "jc21/mariadb-aria"
    environment:
      - "MYSQL_ROOT_PASSWORD=**********************"
      - "TZ=Europe/Stockholm"
    volumes:
      - "/mnt/usbhdd/docker/mariadb:/var/lib/mysql"
      - "/mnt/usbhdd/docker/mariadb/mysql-bin:/var/lib/mysql/mysql-bin"
    ports:
      - 3306:3306
    restart: unless-stopped

I gott this error when running on my rpi swarm:

standard_init_linux.go:211: exec user process caused "exec format error",

What am i doing wrong? Thanks in advance.

Hello!
So I have had NGINX Reverse Proxy Manager working flawlessly for weeks/months. However, recently the admin page has been not working and my container has been unhealthy. Upon looking at the logs, it seems that the Database is no longer accessible. The hosts thankfully continue to run. Upon looking at the Database container, it seems to no longer be getting any IP and is looping with the following message;


[i] pre-init.d - processing /scripts/pre-init.d/01_secret-init.sh

[i] mysqld already present, skipping creation

[i] MySQL directory already present, skipping creation

2021-07-09 12:36:57 0 [Note] /usr/bin/mysqld (mysqld 10.4.15-MariaDB) starting as process 1 ...

Cannot find checkpoint record at LSN (1,0x2cdf8c)

2021-07-09 12:36:57 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files

2021-07-09 12:36:57 0 [ERROR] Plugin 'Aria' init function returned error.

2021-07-09 12:36:57 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2021-07-09 12:36:57 0 [Note] Plugin 'InnoDB' is disabled.

2021-07-09 12:36:57 0 [Note] Plugin 'FEEDBACK' is disabled.

2021-07-09 12:36:57 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded

2021-07-09 12:36:57 0 [ERROR] Failed to initialize plugins.

It is looping over and over. I have not "touched" the container and this issue has suddenly started. Any ideas?
Thank you

Unprivileged container fail to start in podman.

When running an unprivileged mariadb-aria container in podman with the "--user" flag, it will fail to start (access privileges for the respective folders set up correctly):

[i] pre-init.d - processing /scripts/pre-init.d/01_secret-init.sh
[i] mysqld not found, creating....
mkdir: can't create directory '/run/mysqld': Permission denied
chown: /run/mysqld: No such file or directory
[i] MySQL data directory not found, creating initial DBs
chown: /var/lib/mysql/aria_log_control: Operation not permitted
chown: /var/lib/mysql/aria_log.00000001: Operation not permitted
chown: /var/lib/mysql: Operation not permitted
chown: /var/lib/mysql: Operation not permitted
chown: /var/lib/mysql: Operation not permitted
[i] Creating database: npm
[i] with character set: 'utf8' and collation: 'utf8_general_ci'
[i] Creating user: USER with password PA$$WORD
2021-11-21 15:29:58 0 [Note] /usr/bin/mysqld (mysqld 10.4.15-MariaDB) starting as process 33 ...
/usr/bin/mysqld: One can only use the --user switch if running as root
2021-11-21 15:29:58 0 [Note] Plugin 'InnoDB' is disabled.
2021-11-21 15:29:58 0 [Note] Plugin 'FEEDBACK' is disabled.
ERROR: 1049  Unknown database 'mysql'
2021-11-21 15:29:58 0 [ERROR] Aborting
/scripts/run.sh: ignoring or entrypoint initdb empty /docker-entrypoint-initdb.d/*


MySQL init process done. Ready for start up.

exec /usr/bin/mysqld --user=mysql --console --skip-name-resolve --skip-networking=0
2021-11-21 15:29:58 0 [Note] /usr/bin/mysqld (mysqld 10.4.15-MariaDB) starting as process 1 ...
/usr/bin/mysqld: One can only use the --user switch if running as root
2021-11-21 15:29:58 0 [Note] Plugin 'InnoDB' is disabled.
2021-11-21 15:29:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-21 15:29:58 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-11-21 15:29:58 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2021-11-21 15:29:58 0 [Note] Server socket created on IP: '::'.
2021-11-21 15:29:58 0 [ERROR] Can't start server : Bind on unix socket: No such file or directory
2021-11-21 15:29:58 0 [ERROR] Do you already have another mysqld server running on socket: /run/mysqld/mysqld.sock ?
2021-11-21 15:29:58 0 [ERROR] Aborting

My best guess:
The --user parameter is not checked as in the "standard" mariadb repository:
https://github.com/MariaDB/mariadb-docker/blob/ef12d140f19ace81b65f2b9aba9bf02b51ae888e/docker-entrypoint.sh#L68-L74

Expectation:
Unprivileged startup as experienced with the standard mariadb image.

User password not correctly set from secret

I've set up a secret for the user password on my docker-compose.yml, but it is not reflected on MySQL. Checked the content for /run/secrets/mariadb_usr_pwd both on the mariadb container and app container, and both matches my definition and each other. I tried to log-in to MySQL with that user and password from inside the mariadb container and got access denied. Where else may I check?