I am using "From container image" option in the openshift v4.9 GUI and using the below path to the image
registry.redhat.io/rhel8/mariadb-105:latest
and the pod fails to run

I don't see any error msgs in the pod logs.. the max I can see is this....(just info msgs)

=> sourcing 20-validate-variables.sh ...
You must either specify the following environment variables:
  MYSQL_USER (regex: '^[a-zA-Z0-9_]+$')
  MYSQL_PASSWORD (regex: '^[a-zA-Z0-9_~!@#$%^&*()-=<>,.?;:|]+$')
  MYSQL_DATABASE (regex: '^[a-zA-Z0-9_]+$')
Or the following environment variable:
  MYSQL_ROOT_PASSWORD (regex: '^[a-zA-Z0-9_~!@#$%^&*()-=<>,.?;:|]+$')
Or both.
Optional Settings:
  MYSQL_LOWER_CASE_TABLE_NAMES (default: 0)
  MYSQL_LOG_QUERIES_ENABLED (default: 0)
  MYSQL_MAX_CONNECTIONS (default: 151)
  MYSQL_FT_MIN_WORD_LEN (default: 4)
  MYSQL_FT_MAX_WORD_LEN (default: 20)
  MYSQL_AIO (default: 1)
  MYSQL_KEY_BUFFER_SIZE (default: 32M or 10% of available memory)
  MYSQL_MAX_ALLOWED_PACKET (default: 200M)
  MYSQL_TABLE_OPEN_CACHE (default: 400)
  MYSQL_SORT_BUFFER_SIZE (default: 256K)
  MYSQL_READ_BUFFER_SIZE (default: 8M or 5% of available memory)
  MYSQL_INNODB_BUFFER_POOL_SIZE (default: 32M or 50% of available memory)
  MYSQL_INNODB_LOG_FILE_SIZE (default: 8M or 15% of available memory)
  MYSQL_INNODB_LOG_BUFFER_SIZE (default: 8M or 15% of available memory)

For more information, see https://github.com/sclorg/mariadb-container

Pls note that I have provided the needed env vars as mentioned above... I tried both.. providing it via secret or via deloyment env var during creation of the pod but it still fails the same way

It would be great if the image had installed the galera packages even if it wasn't configured.
Then I wouldn't need to do something like this:

https://github.com/jcpowermac/mariadb-ha-poc/blob/b7df7f4ec06bac5127ae9bd46a3ea76a25f9a512/mariadb-galera-ephemeral-template.yml#L195-L204

The configuration can be handled using S2I (which is very cool btw).

From MariaDB Documentation the Anonymous Accounts should be removed when the database is used in production.

When this anonymous user is present, the '%' wildcard character doesn't include 'localhost' value.
This leads to the issue described in BZ#2080804

This problem is also described in this StackOverflow issue

There are two ways to fix the problem:

1. Add 'root'@'localhost' and '$MYSQL_USER'@'localhost' users in root-common/usr/share/container-scripts/mysql/common.sh

   • This solution should be used if we don't want to remove anonymous users from the database and we leave that up to the customers that use our container

2. Remove the anonymous user from the database (DELETE FROM mysql.user WHERE User=''; FLUSH PRIVILEGES;)

   • This could be an issue if any customer relies on having the anonymous users created and use them for some testing purposes
   • IMPORTANT -> If we decide to remove anonymous users, we need to remove them before creating our users, if anonymous users are not dropped before creating any other users, the '%' wildcard won't evaluate to 'localhost' and the bug described in linked Bugzilla won't be fixed.

MySQL and MariaDB use versions that consist of three numbers (e.g. 5.6.23). When two versions are different only in the last part, they are compatible, but when upgrading from e.g. 5.6 to 5.7, we need to consider upgrading as described in https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html. Currently, there is no check whether the data come from a different version (incompatible) so it can happen that users by mistake change the version of the image and they can see errors or even data corruption when not using the standard upgrading scenario described in the documentation.

The OpenShift 4 tests are failing on image stream test suite.

The proper imagestream tag should be used.

Running image stream test for stream test/../imagestreams/mariadb-rhel.json and template test/../examples/mariadb-ephemeral-template.json
Now using project "sclorg-test-7641" on server "https://api.core-serv-ocp.hosted.psi.rdu2.redhat.com:6443".

You can add applications to this project with the 'new-app' command. For example, try:

    oc new-app ruby~https://github.com/sclorg/ruby-ex.git

to build a new example application in Python. Or use kubectl to deploy a simple Kubernetes application:

    kubectl create deployment hello-node --image=gcr.io/hello-minikube-zero-install/hello-node

secret/6340056-core-services-apps-ci-pull-secret created
imagestream.image.openshift.io/mariadb created
secret/mariadb created
service/mariadb created
deploymentconfig.apps.openshift.io/mariadb created
Waiting for mariadb pod becoming ready .......................................... FAIL
NAME              TYPE        CLUSTER-IP      EXTERNAL-IP   PORT(S)    AGE
service/mariadb   ClusterIP   172.30.182.74   <none>        3306/TCP   68s

NAME                                         REVISION   DESIRED   CURRENT   TRIGGERED BY
deploymentconfig.apps.openshift.io/mariadb   0          1         0         config,image(mariadb:10.5)

NAME                                     IMAGE REPOSITORY                                                            TAGS                                          UPDATED
imagestream.image.openshift.io/mariadb   image-registry.openshift-image-registry.svc:5000/sclorg-test-7641/mariadb   10.3,10.3-el7,10.3-el8,10.5-el7 + 2 more...   2 minutes ago
In project sclorg-test-7641 on server https://api.core-serv-ocp.hosted.psi.rdu2.redhat.com:6443

svc/mariadb - 172.30.182.74:3306
  dc/mariadb deploys istag/mariadb:10.5 
    deployment #1 waiting on image or update

1 warning identified, use 'oc status --suggest' to see details.
Build config bc/ does not exist for some reason.
Import probably failed.
OpenShift tests for rhscl/mariadb-105-rhel7:1 failed.
make: *** [test-openshift-4] Error 1

Container scripts generate /etc/my.cnf.d/base.cnf from /usr/share/container-scripts/mysql/pre-init/my-base.cnf.template, which includes:

plugin-dir = ${MYSQL_PREFIX}/lib64/mysql/plugin

However, plugins are installed by the package in /usr/lib64/mariadb/plugin, so plugins cannot be found by MariaDB. I believe this should be changed to:

plugin-dir = ${MYSQL_PREFIX}/lib64/mariadb/plugin

i make
oc new-app mariadb:10.3~https://github.com/sclorg/mariadb-container.git --name mariadb103 --context-dir=examples/extend-image --env MYSQL_OPERATIONS_USER=opuser --env MYSQL_OPERATIONS_PASSWORD=oppass --env MYSQL_DATABASE=opdb --env MYSQL_USER=user --env MYSQL_PASSWORD=pass --strategy=source

and get error 'must specify a user that is numeric and within the range of allowed users'
How i make fix this problem.

For OKD 4 we are needing to pull current images from the Fedora Container Registry but there are none available. Is it possible to have the maintainers of sclorg/mariadb-container push the Fedora containers to the Fedora registry? The current image naming convention "mariadb-103-centos7" could be "php-73-fedora29" as it uses the f29 s2i-base image.

okd-project/okd#167

We should cover docker alone and OpenShift.

When we share container sources over FTP, permissions don't need to be kept. Then it can happen that image will be build but not working, because scripts in /usr/bin need to be executable.

Hi!

Using centos/mariadb-102-centos7 I cannot input utf8-characters in the cli:

> oc rsh mariadb-....
sh-4.2$ export LC_ALL=en_US.UTF-8
sh-4.2$ mysql -u root --default-character-set=utf8
MariaDB [(none)]>

In that prompt I now cannot enter any non-latin1-character, not directly (with keyboard) and not by copy-paste.

Facing this error while composing: ERROR 1133 (28000) at line 1: Can't find any matching row in the user table

mysql-container    | ---> 01:02:48     Waiting for MySQL to start ...
mysql-container    | 180524  1:02:48 [Note] /opt/rh/rh-mariadb100/root/usr/libexec/mysqld (mysqld 10.0.28-MariaDB) starting as process 29 ...
mysql-container    | 180524  1:02:48 [Note] InnoDB: Using mutexes to ref count buffer pool pages
mysql-container    | 180524  1:02:48 [Note] InnoDB: The InnoDB memory heap is disabled
mysql-container    | 180524  1:02:48 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql-container    | 180524  1:02:48 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql-container    | 180524  1:02:48 [Note] InnoDB: Compressed tables use zlib 1.2.7
mysql-container    | 180524  1:02:48 [Note] InnoDB: Using Linux native AIO
mysql-container    | 180524  1:02:48 [Note] InnoDB: Using CPU crc32 instructions
mysql-container    | 180524  1:02:48 [Note] InnoDB: Initializing buffer pool, size = 32.0M
mysql-container    | 180524  1:02:48 [Note] InnoDB: Completed initialization of buffer pool
mysql-container    | 180524  1:02:48 [Note] InnoDB: Highest supported file format is Barracuda.
mysql-container    | 180524  1:02:48 [Note] InnoDB: 128 rollback segment(s) are active.
mysql-container    | 180524  1:02:48 [Note] InnoDB: Waiting for purge to start
mysql-container    | 180524  1:02:48 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 3795701817
mysql-container    | 180524  1:02:48 [Note] Plugin 'FEEDBACK' is disabled.
mysql-container    | 180524  1:02:48 [Warning] 'user' entry 'root@8678a873616c' ignored in --skip-name-resolve mode.
mysql-container    | 180524  1:02:48 [Warning] 'user' entry '@8678a873616c' ignored in --skip-name-resolve mode.
mysql-container    | 180524  1:02:48 [Warning] 'proxies_priv' entry '@% root@8678a873616c' ignored in --skip-name-resolve mode.
mysql-container    | 180524  1:02:48 [Note] /opt/rh/rh-mariadb100/root/usr/libexec/mysqld: ready for connections.
mysql-container    | Version: '10.0.28-MariaDB'  socket: '/tmp/mysql.sock'  port: 0  MariaDB Server
mysql-container    | ---> 01:02:49     MySQL started successfully
mysql-container    | => sourcing 50-passwd-change.sh ...
mysql-container    | ---> 01:02:49     Setting passwords ...
mysql-container    | ERROR 1133 (28000) at line 1: Can't find any matching row in the user table
mysql-container exited with code 1

This is my environment config:

        environment:
          - MYSQL_DATABASE=my_db
          - MYSQL_USER=my_user
          - MYSQL_PASSWORD=my_user

I'm wondering why this script is attempting to setup the password, without making sure the user already exists: root-common/usr/share/container-scripts/mysql/init/50-passwd-change.sh#L8 Maybe creating the user prior to setting password makes sense.
It worths to mention that following environment configuration works fine:

        environment:
          - MYSQL_ROOT_PASSWORD=whatever

https://github.com/sclorg/mariadb-container/tree/master/10.3

There is only Dockerfile.rhel8 and Dockerfile.fedora.
Is it intended?

I am upgrading an existing Django application that uses centos/mariadb to centos/mariadb-100-centos7.

I don't see error when firing up the new DB container but the application reports it can't find it's migrations, which looks like missing data.

Both containers mount the actual data under /var/lib/mysql. The data lives in a separate volume.

this issue is created for the testing purpose no action required

This is for testing of automation workflow. No further action is required.

Mariadb 10.3 has a Dockerfile.tmp in the directory:
https://github.com/sclorg/mariadb-container/blob/master/10.3/Dockerfile.tmp

What is it used for?

We've been seeing increasing numbers of mariadb (and mysql) containers being killed due to oom (the host node still has plenty of free memory).

Testing seems to indicate it may be related to the dynamic memory configuration.

Build centos-mariadb-101-centos7-latest is broken for CentOS base image.

Step failing in Dockerfile, line 59

COPY 10.1/root-common /

and the following line 60 and 61 will also fail due to broken (relative path references).

[Full build logs] (https://registry.centos.org/pipeline-logs/MmU1ODM1NzA0M2/build_logs.txt)

Are there any plans to have an officially supported MariaDB 10.4 image for OpenShift like you have for 10.1, 10.2?

This issue is created for testing purpose. No action required.

On OpenShift Online Service Catalog, the link to README.md points to a symlink instead the actual README.md file. It's the same link destination pointed by the "View Documentation" hyperlink.

The link is: https://github.com/sclorg/mariadb-container/blob/master/10.1/README.md

The actual file can be found in: https://github.com/sclorg/mariadb-container/blob/master/10.1/root/usr/share/container-scripts/mysql/README.md

The same goes to mysql-container.

I am trying to create a mariadb Pod that will have a db and tables pre-created.
In order to achive that, I am using a Dockerfile as below

FROM registry.redhat.io/rhel8/mariadb-105

# needed for intialization
ENV MYSQL_ROOT_PASSWORD=root
ENV MYSQL_DATABASE=qod

COPY 1_createdb.sql /tmp/
COPY 2_authors.sql /tmp/
COPY 3_genres.sql /tmp/
COPY 4_quotes_sm.sql /tmp/

COPY run.sh /usr/share/container-scripts/mysql/init/

CMD ["run-mysqld"]

My github repo is:
https://github.com/dpkshetty/qod-db/tree/v2

Inspite of MYSQL_ROOT_PASSWORD defined in the Dockerfile, the Pod fails to run and errors out with the below msg...

=> sourcing 20-validate-variables.sh ...
You must either specify the following environment variables:
  MYSQL_USER (regex: '^[a-zA-Z0-9_]+$')
  MYSQL_PASSWORD (regex: '^[a-zA-Z0-9_~!@#$%^&*()-=<>,.?;:|]+$')
  MYSQL_DATABASE (regex: '^[a-zA-Z0-9_]+$')
Or the following environment variable:
  MYSQL_ROOT_PASSWORD (regex: '^[a-zA-Z0-9_~!@#$%^&*()-=<>,.?;:|]+$')
Or both.
Optional Settings:
  MYSQL_LOWER_CASE_TABLE_NAMES (default: 0)
  MYSQL_LOG_QUERIES_ENABLED (default: 0)
  MYSQL_MAX_CONNECTIONS (default: 151)
  MYSQL_FT_MIN_WORD_LEN (default: 4)
  MYSQL_FT_MAX_WORD_LEN (default: 20)
  MYSQL_AIO (default: 1)
  MYSQL_KEY_BUFFER_SIZE (default: 32M or 10% of available memory)
  MYSQL_MAX_ALLOWED_PACKET (default: 200M)
  MYSQL_TABLE_OPEN_CACHE (default: 400)
  MYSQL_SORT_BUFFER_SIZE (default: 256K)
  MYSQL_READ_BUFFER_SIZE (default: 8M or 5% of available memory)
  MYSQL_INNODB_BUFFER_POOL_SIZE (default: 32M or 50% of available memory)
  MYSQL_INNODB_LOG_FILE_SIZE (default: 8M or 15% of available memory)
  MYSQL_INNODB_LOG_BUFFER_SIZE (default: 8M or 15% of available memory)

For more information, see https://github.com/sclorg/mariadb-container

This issue serves as reminder that we can remove change done in #21 once it is fixed in RPMs, which is tracked in https://bugzilla.redhat.com/show_bug.cgi?id=1406391

I'm getting a 404 when following the link in the 10.3 README. Looks like its not actually being uploaded to DockerHub? Is this intentional? We'd like to use the 10.3 image without having to build it and push it to our own registry.

This is for testing of automation workflow. No further action is required.

We are trying to create a persistence container running the following command:

docker run --name persistence -e MYSQL_USER=user -e MYSQL_PASSWORD=pass -e MYSQL_DATABASE=db -e MYSQL_DEFAULTS_FILE=/persistence/conf/mariadb.cnf -v /home/persistence:/persistence/conf -p 3306:3306 centos/mariadb-102-centos7

We expect to see that our mariadb configuration is loaded from /persistence/conf/mariadb.cnf file, but it is not. We only see the default configuration values in the database.

Are we missing something from the command above?

The following Maria DB Templates have an incorrectly configured liveness/readiness probe:

• https://github.com/sclorg/mariadb-container/blob/master/examples/mariadb-ephemeral-template.json
• https://github.com/sclorg/mariadb-container/blob/master/examples/mariadb-persistent-template.json

When the probes are executed the following warning is logged in the pod:

2021-05-03 20:19:23 29 [Warning] Access denied for user 'userHFP'@'localhost' (using password: YES)
2021-05-03 20:19:27 30 [Warning] Access denied for user 'userHFP'@'localhost' (using password: YES)
2021-05-03 20:19:33 31 [Warning] Access denied for user 'userHFP'@'localhost' (using password: YES)

The probe should be two commands seperated by ; or &&:

"command": [
	"/bin/sh",
	"-i",
	"-c",
	"MYSQL_PWD=\"$MYSQL_PASSWORD\" && mysqladmin -u $MYSQL_USER ping"
]

Executing the command manually generates the following for the current probe:

sh-4.4$ MYSQL_PWD=\"$MYSQL_PASSWORD\" mysqladmin -u $MYSQL_USER ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'dbuser'@'localhost' (using password: YES)'

With the correction:

sh-4.4$ MYSQL_PWD=\"$MYSQL_PASSWORD\" && mysqladmin -u $MYSQL_USER ping
mysqld is alive

Is there a way to set --character-set-server and --collation-server without modifying the default my.cnf file?