Can't build mysql container

[derikb]

I'm new to podman, and I'm having an awful time getting a mysql container to run. I managed to get my php-fpm and nginx containers working and serving files, but mysql keeps erroring out . I've pared back everything to the barest bones and still get the same error.

I'm on Ubuntu 22 and am using podman compose to set stuff up. My compose.yml file is down to:

services:
  mysql:
    image: docker.io/mysql:8
    environment:
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_DATABASE=libanswers
      - MYSQL_USER=user
      - MYSQL_PASSWORD=pass

I run podman-compose up and I get:

podman-compose version: 1.0.6
['podman', '--version', '']
using podman version: 4.6.2
** excluding:  set()
['podman', 'ps', '--filter', 'label=io.podman.compose.project=libanswers', '-a', '--format', '{{ index .Labels "io.podman.compose.config-hash"}}']
['podman', 'network', 'exists', 'libanswers_default']
podman create --name=libanswers_mysql_1 --label io.podman.compose.config-hash=77c390f66cdbd849a6f1ad4bfb7040bb868238ebc48226f74d02b6234dc717bc --label io.podman.compose.project=libanswers --label io.podman.compose.version=1.0.6 --label PODMAN_SYSTEMD_UNIT=podman-compose@libanswers.service --label com.docker.compose.project=libanswers --label com.docker.compose.project.working_dir=/home/springy/springshare/LibAnswers --label com.docker.compose.project.config_files=docker-compose.yml --label com.docker.compose.container-number=1 --label com.docker.compose.service=mysql -e MYSQL_ROOT_PASSWORD=root -e MYSQL_DATABASE=libanswers -e MYSQL_USER=user -e MYSQL_PASSWORD=pass --net libanswers_default --network-alias mysql docker.io/mysql:8
c85e5cf3af9aae12cca03ecb09a39c85d73f4fc606ce3de70126978f42095179
exit code: 0
podman start -a libanswers_mysql_1
[mysql] | 2024-01-09 18:30:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
[mysql] | 2024-01-09 18:30:42+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
[mysql] | 2024-01-09 18:30:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
[mysql] | 2024-01-09 18:30:43+00:00 [Note] [Entrypoint]: Initializing database files
mysqld: Can't create directory '/var/lib/mysql/' (OS errno 17 - File exists)
2024-01-09T18:30:43.030844Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2024-01-09T18:30:43.031949Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.2.0) initializing of server in progress as process 75
2024-01-09T18:30:43.031982Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/usr/share/mysql-8.2/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2024-01-09T18:30:43.032658Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2024-01-09T18:30:43.032683Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-01-09T18:30:43.032791Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0)  MySQL Community Server - GPL.
2024-01-09T18:30:43.032990Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
exit code: 1

I always get that error about /var/lib/mysql/ already existing, which makes no sense to me. I assume that is a path inside the container so I don't get how it would be an issue.

I ended up making a new user on my computer and this all worked once... but then... somehow it stopped working again.

It does seem a little weird to me that Entrypoint script for MySQL Server 8.2.0-1.el8 started. shows up twice in the output...

[rhatdan]

This is a podman-compose question, which is a different project then podman.

[derikb]

No, it's def podman (or I guess it could be the container). I also get the same results with a straight up podman command:

$ podman run --name libanswers_mysql_1 -e MYSQL_ROOT_PASSWORD=root -e MYSQL_DATABASE=libanswers -e MYSQL_USER=user -e MYSQL_PASSWORD=pass docker.io/mysql:8

2024-01-16 14:08:18+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
2024-01-16 14:08:18+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-01-16 14:08:18+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
2024-01-16 14:08:19+00:00 [Note] [Entrypoint]: Initializing database files
mysqld: Can't create directory '/var/lib/mysql/' (OS errno 17 - File exists)
2024-01-16T14:08:19.091740Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2024-01-16T14:08:19.092892Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.2.0) initializing of server in progress as process 75
2024-01-16T14:08:19.092926Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/usr/share/mysql-8.2/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2024-01-16T14:08:19.093538Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2024-01-16T14:08:19.093556Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-01-16T14:08:19.093638Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0)  MySQL Community Server - GPL.
2024-01-16T14:08:19.093779Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.

[derikb]

Same error if I run it with the docker.io/ubuntu/mysql image.

[sahuJay]

any solution ?

[derikb]

So for me ... I was running everything from a terminal in VSCode and for some reason that was doing something different than running in just a normal terminal. I'm still not sure what but I don't use VSCode for any pod man commands anymore

[sahuJay]

inside the same folder i did just below steap and work it from me
rm -rf logs
mkdir logs
chmod 777 logs