MySQL Fails to build, Is unhealthy

[jbwill36]

Fresh build, current version of Docker. Pull the git, change the HOST_IP as stated in the docs, docker compose --build will yield this everytime. I have since changed the docker network. Full Logfile attached.
unhealthy sql build docker opensips.txt

Network opensips-softswitch-ce_localnetwork Created 0.2s
✔ Container freeswitch Created 4.9s
✔ Container mysql Created 4.9s
✔ Container rtpproxy Created 10.0s
✔ Container opensips-cp Created 5.2s
✔ Container opensips Created 5.2s
Attaching to freeswitch, mysql, opensips, opensips-cp, rtpproxy
mysql | 2024-11-19 16:06:36+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
mysql | 2024-11-19 16:06:36+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql | 2024-11-19 16:06:36+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
mysql | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
mysql | 2024-11-19T16:06:36.648328Z 0 [System] [MY-015015] [Server] MySQL Server - start.
mysql | 2024-11-19T16:06:36.839692Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.1.0) starting as process 1
mysql | 2024-11-19T16:06:36.844401Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql | 2024-11-19T16:06:36.941564Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysql | 2024-11-19T16:06:37.033952Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
mysql | 2024-11-19T16:06:37.033976Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
mysql | 2024-11-19T16:06:37.036440Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql | 2024-11-19T16:06:37.050085Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
mysql | 2024-11-19T16:06:37.050157Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.1.0' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
freeswitch | ERROR: Failed to set SCHED_FIFO scheduler (Operation not permitted)
freeswitch | ERROR: Could not set nice level

---

freeswitch | 2024-11-19 16:06:38.461931 0.00% [CONSOLE] switch_loadable_module.c:1772 Successfully Loaded [mod_pgsql]
freeswitch | 2024-11-19 16:06:38.461952 0.00% [NOTICE] switch_loadable_module.c:500 Adding dsn prefix 'pgsql'
freeswitch | 2024-11-19 16:06:38.461962 0.00% [NOTICE] switch_loadable_module.c:500 Adding dsn prefix 'postgres'
freeswitch | 2024-11-19 16:06:38.461967 0.00% [NOTICE] switch_loadable_module.c:500 Adding dsn prefix 'postgresql'
freeswitch | 2024-11-19 16:06:38.462715 0.00% [INFO] switch_core_sqldb.c:3595 Opening DB
freeswitch | 2024-11-19 16:06:38.462742 0.00% [ERR] switch_core_sqldb.c:728 [db="core",type="core_db"] NATIVE SQL ERR [no such table: channels]
freeswitch | drop table channels
freeswitch | 2024-11-19 16:06:38.462787 0.00% [ERR] switch_core_sqldb.c:728 [db="core",type="core_db"] NATIVE SQL ERR [no such table: calls]
freeswitch | drop table calls
freeswitch | 2024-11-19 16:06:38.462798 0.00% [ERR] switch_core_sqldb.c:728 [db="core",type="core_db"] NATIVE SQL ERR [no such view: detailed_calls]
freeswitch | drop view detailed_calls
freeswitch | 2024-11-19 16:06:38.462807 0.00% [ERR] switch_core_sqldb.c:728 [db="core",type="core_db"] NATIVE SQL ERR [no such view: basic_calls]
freeswitch | drop view basic_calls
freeswitch | 2024-11-19 16:06:38.462816 0.00% [ERR] switch_core_sqldb.c:728 [db="core",type="core_db"] NATIVE SQL ERR [no such table: interfaces]
freeswitch | drop table interfaces
freeswitch | 2024-11-19 16:06:38.462825 0.00% [ERR] switch_core_sqldb.c:728 [db="core",type="core_db"] NATIVE SQL ERR [no such table: tasks]
freeswitch | drop table tasks
freeswitch | 2024-11-19 16:06:38.463072 0.00% [DEBUG] switch_core_sqldb.c:1494 SQL ERR [no such table: aliases]
freeswitch | [select hostname from aliases]
freeswitch | Auto Generating Table!
freeswitch | 2024-11-19 16:06:38.463088 0.00% [DEBUG] switch_core_sqldb.c:1501 Ignoring SQL ERR [no such table: aliases]
freeswitch | [DROP TABLE aliases]
freeswitch | 2024-11-19 16:06:38.463273 0.00% [DEBUG] switch_core_sqldb.c:1494 SQL ERR [no such table: complete]
freeswitch | [select hostname from complete]
freeswitch | Auto Generating Table!
freeswitch | 2024-11-19 16:06:38.463288 0.00% [DEBUG] switch_core_sqldb.c:1501 Ignoring SQL ERR [no such table: complete]
freeswitch | [DROP TABLE complete]
freeswitch | 2024-11-19 16:06:38.463387 0.00% [DEBUG] switch_core_sqldb.c:1494 SQL ERR [no such table: nat]
freeswitch | [select hostname from nat]
freeswitch | Auto Generating Table!
freeswitch | 2024-11-19 16:06:38.463401 0.00% [DEBUG] switch_core_sqldb.c:1501 Ignoring SQL ERR [no such table: nat]
freeswitch | [DROP TABLE nat]
freeswitch | 2024-11-19 16:06:38.463506 0.00% [DEBUG] switch_core_sqldb.c:1494 SQL ERR [no such table: registrations]
freeswitch | [delete from registrations where reg_user='']
freeswitch | Auto Generating Table!
freeswitch | 2024-11-19 16:06:38.463520 0.00% [DEBUG] switch_core_sqldb.c:1501 Ignoring SQL ERR [no such table: registrations]
freeswitch | [DROP TABLE registrations]
freeswitch | 2024-11-19 16:06:38.463632 0.00% [DEBUG] switch_core_sqldb.c:1494 SQL ERR [no such table: recovery]
freeswitch | [select hostname from recovery]
freeswitch | Auto Generating Table!
freeswitch | 2024-11-19 16:06:38.463645 0.00% [DEBUG] switch_core_sqldb.c:1501 Ignoring SQL ERR [no such table: recovery]
freeswitch | [DROP TABLE recovery]
freeswitch | 2024-11-19 16:06:38.467402 0.00% [INFO] switch_core_sqldb.c:1840 CORE Starting SQL thread.
freeswitch | 2024-11-19 16:06:40.496870 0.00% [CRIT] switch_loadable_module.c:1754 Error Loading module

---

mysql | 2024-11-19T16:06:41.332978Z 8 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
mysql | 2024-11-19T16:06:46.436417Z 9 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
mysql | 2024-11-19T16:06:51.549599Z 10 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
mysql | 2024-11-19T16:06:56.669500Z 11 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
mysql | 2024-11-19T16:07:06.765447Z 12 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
mysql | 2024-11-19T16:07:16.868938Z 13 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
mysql | 2024-11-19T16:07:26.956240Z 14 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
mysql | 2024-11-19T16:07:37.037768Z 15 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
Gracefully stopping... (press Ctrl+C again to force)
dependency failed to start: container mysql is unhealthy

[dariusstefan]

Hello!
Can you please give me the logs for mysql container?
Run:
docker compose down
docker compose up --build -d
docker logs mysql

Thanks,
Darius

[codedrei01]

Hello!

Having the same issue. Here is the logs for from the commands above

`> docker compose down

docker compose up --build -d
[+] Building 4.3s (17/17) FINISHED docker:desktop-linux
=> [mysql internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 308B 0.0s
=> [mysql internal] load metadata for docker.io/library/mysql:latest 1.8s
=> [mysql auth] library/mysql:pull token for registry-1.docker.io 0.0s
=> [mysql internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [mysql 1/2] FROM docker.io/library/mysql:latest@sha256:0255b469f0135a0236d672d60e3154ae2f4538b146744966d96440318cc822c6 0.0s
=> CACHED [mysql 2/2] RUN echo "https://yum.opensips.org/3.6/nightly/el/9/x86_64/$(curl -s -L https://yum.opensips.org/3.6/nightly/el/9/x86_64 | grep -oE "opensips-mysql-dbschema[^r]*.rpm" | tai 0.0s
=> [mysql] exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:3f7061cc40f075dc2597f67c2f456789e49923131183e95df2b9bc335e548daf 0.0s
=> => naming to docker.io/library/opensips-softswitch-ce-mysql 0.0s
=> [mysql] resolving provenance for metadata file 0.0s
=> [opensips-cp internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 69B 0.0s
=> [opensips-cp internal] load metadata for docker.io/opensips/opensips-cp:latest 1.6s
=> [opensips-cp auth] opensips/opensips-cp:pull token for registry-1.docker.io 0.0s
=> [opensips-cp internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [opensips-cp internal] load build context 0.0s
=> => transferring context: 37B 0.0s
=> [opensips-cp 1/1] FROM docker.io/opensips/opensips-cp:latest@sha256:8a0e9572b7aa60dde6cc2426cff8935afe191ffb95f0fd225f7318b6d77b986b 0.0s
=> CACHED [opensips-cp 2/1] COPY modules.inc.php /var/www/html/opensips-cp/config/ 0.0s
=> [opensips-cp] exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:cc933bfd2d46eb4bb4a869a941eeef996a7a3cf5353b719292981cc732fa95a9 0.0s
=> => naming to docker.io/library/opensips-softswitch-ce-opensips-cp 0.0s
=> [opensips-cp] resolving provenance for metadata file 0.0s
[+] Running 6/6
✔ Network opensips-softswitch-ce_localnetwork Created0.1s
✔ Container freeswitchStarted0.9s
✔ Container rtpproxyStarted6.2s
✘ Container mysqlError61.5s
✔ Container opensips-cpCreated0.1s
✔ Container opensipsCreated0.1s
dependency failed to start: container mysql is unhealthy
docker logs mysql
2024-12-04 16:43:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
2024-12-04 16:43:13+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-12-04 16:43:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-12-04T16:43:13.810537Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-12-04T16:43:14.058253Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.1.0) starting as process 1
2024-12-04T16:43:14.066353Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-04T16:43:14.441445Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-04T16:43:14.839229Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-12-04T16:43:14.839322Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-12-04T16:43:14.845543Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-12-04T16:43:14.909313Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-12-04T16:43:14.909473Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.1.0' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
`

[dariusstefan]

Hello!

Maybe you can delete the volume for mysql data, then try again.
Run:
docker compose down
docker volume rm opensips-softswitch-ce_db
docker compose up --build -d

Can you please provide the logs for the opensips container too?
docker logs opensips

Thank you!

[codedrei01]

Hello!

Here is the logs after following the steps above.

docker compose down
docker compose up --build -d
[+] Building 4.3s (17/17) FINISHED docker:desktop-linux
=> [mysql internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 308B 0.0s
=> [mysql internal] load metadata for docker.io/library/mysql:latest 1.8s
=> [mysql auth] library/mysql:pull token for registry-1.docker.io 0.0s
=> [mysql internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [mysql 1/2] FROM docker.io/library/mysql:latest@sha256:0255b469f0135a0236d672d60e3154ae2f4538b146744966d96440318cc822c6 0.0s
=> CACHED [mysql 2/2] RUN echo "https://yum.opensips.org/3.6/nightly/el/9/x86_64/$(curl -s -L https://yum.opensips.org/3.6/nightly/el/9/x86_64 | grep -oE "opensips-mysql-dbschema[^r].rpm" | tai 0.0s
=> [mysql] exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:3f7061cc40f075dc2597f67c2f456789e49923131183e95df2b9bc335e548daf 0.0s
=> => naming to docker.io/library/opensips-softswitch-ce-mysql 0.0s
=> [mysql] resolving provenance for metadata file 0.0s
=> [opensips-cp internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 69B 0.0s
=> [opensips-cp internal] load metadata for docker.io/opensips/opensips-cp:latest 1.6s
=> [opensips-cp auth] opensips/opensips-cp:pull token for registry-1.docker.io 0.0s
=> [opensips-cp internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [opensips-cp internal] load build context 0.0s
=> => transferring context: 37B 0.0s
=> [opensips-cp 1/1] FROM docker.io/opensips/opensips-cp:latest@sha256:8a0e9572b7aa60dde6cc2426cff8935afe191ffb95f0fd225f7318b6d77b986b 0.0s
=> CACHED [opensips-cp 2/1] COPY modules.inc.php /var/www/html/opensips-cp/config/ 0.0s
=> [opensips-cp] exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:cc933bfd2d46eb4bb4a869a941eeef996a7a3cf5353b719292981cc732fa95a9 0.0s
=> => naming to docker.io/library/opensips-softswitch-ce-opensips-cp 0.0s
=> [opensips-cp] resolving provenance for metadata file 0.0s
[+] Running 6/6
✔ Network opensips-softswitch-ce_localnetwork Created0.1s
✔ Container freeswitchStarted0.9s
✔ Container rtpproxyStarted6.2s
✘ Container mysqlError61.5s
✔ Container opensips-cpCreated0.1s
✔ Container opensipsCreated0.1s
dependency failed to start: container mysql is unhealthy
docker logs mysql
2024-12-04 16:43:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
2024-12-04 16:43:13+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-12-04 16:43:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-12-04T16:43:13.810537Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-12-04T16:43:14.058253Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.1.0) starting as process 1
2024-12-04T16:43:14.066353Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-04T16:43:14.441445Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-04T16:43:14.839229Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-12-04T16:43:14.839322Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-12-04T16:43:14.845543Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-12-04T16:43:14.909313Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-12-04T16:43:14.909473Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.1.0' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
docker compose down
docker compose up --build -d
[+] Building 5.1s (17/17) FINISHED docker:desktop-linux
=> [mysql internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 308B 0.0s
=> [mysql internal] load metadata for docker.io/library/mysql:latest 2.2s
=> [mysql auth] library/mysql:pull token for registry-1.docker.io 0.0s
=> [mysql internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [mysql 1/2] FROM docker.io/library/mysql:latest@sha256:0255b469f0135a0236d672d60e3154ae2f4538b146744966d96440318cc822c6 0.0s
=> CACHED [mysql 2/2] RUN echo "https://yum.opensips.org/3.6/nightly/el/9/x86_64/$(curl -s -L https://yum.opensips.org/3.6/nightly/el/9/x86_64 | grep -oE "opensips-mysql-dbschema[^r].rpm" | tai 0.0s
=> [mysql] exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:3f7061cc40f075dc2597f67c2f456789e49923131183e95df2b9bc335e548daf 0.0s
=> => naming to docker.io/library/opensips-softswitch-ce-mysql 0.0s
=> [mysql] resolving provenance for metadata file 0.0s
=> [opensips-cp internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 69B 0.0s
=> [opensips-cp internal] load metadata for docker.io/opensips/opensips-cp:latest 1.9s
=> [opensips-cp auth] opensips/opensips-cp:pull token for registry-1.docker.io 0.0s
=> [opensips-cp internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [opensips-cp internal] load build context 0.0s
=> => transferring context: 37B 0.0s
=> [opensips-cp 1/1] FROM docker.io/opensips/opensips-cp:latest@sha256:8a0e9572b7aa60dde6cc2426cff8935afe191ffb95f0fd225f7318b6d77b986b 0.0s
=> CACHED [opensips-cp 2/1] COPY modules.inc.php /var/www/html/opensips-cp/config/ 0.0s
=> [opensips-cp] exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:cc933bfd2d46eb4bb4a869a941eeef996a7a3cf5353b719292981cc732fa95a9 0.0s
=> => naming to docker.io/library/opensips-softswitch-ce-opensips-cp 0.0s
=> [opensips-cp] resolving provenance for metadata file 0.0s
[+] Running 6/6
✔ Network opensips-softswitch-ce_localnetwork Created0.1s
✔ Container freeswitchStarted1.5s
✘ Container mysqlError62.5s
✔ Container rtpproxyStarted7.0s
✔ Container opensips-cpCreated0.1s
✔ Container opensipsCreated0.1s
dependency failed to start: container mysql is unhealthy
docker compose down
docker volume rm opensips-softswitch-ce_db
opensips-softswitch-ce_db
docker compose up --build -d
[+] Building 4.9s (17/17) FINISHED docker:desktop-linux
=> [mysql internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 308B 0.0s
=> [mysql internal] load metadata for docker.io/library/mysql:latest 2.2s
=> [mysql auth] library/mysql:pull token for registry-1.docker.io 0.0s
=> [mysql internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [mysql 1/2] FROM docker.io/library/mysql:latest@sha256:0255b469f0135a0236d672d60e3154ae2f4538b146744966d96440318cc822c6 0.0s
=> CACHED [mysql 2/2] RUN echo "https://yum.opensips.org/3.6/nightly/el/9/x86_64/$(curl -s -L https://yum.opensips.org/3.6/nightly/el/9/x86_64 | grep -oE "opensips-mysql-dbschema[^r]*.rpm" | tai 0.0s
=> [mysql] exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:3f7061cc40f075dc2597f67c2f456789e49923131183e95df2b9bc335e548daf 0.0s
=> => naming to docker.io/library/opensips-softswitch-ce-mysql 0.0s
=> [mysql] resolving provenance for metadata file 0.0s
=> [opensips-cp internal] load build definition from Dockerfile 0.0s
=> => transferring dockerfile: 69B 0.0s
=> [opensips-cp internal] load metadata for docker.io/opensips/opensips-cp:latest 1.9s
=> [opensips-cp auth] opensips/opensips-cp:pull token for registry-1.docker.io 0.0s
=> [opensips-cp internal] load .dockerignore 0.0s
=> => transferring context: 2B 0.0s
=> [opensips-cp internal] load build context 0.0s
=> => transferring context: 37B 0.0s
=> [opensips-cp 1/1] FROM docker.io/opensips/opensips-cp:latest@sha256:8a0e9572b7aa60dde6cc2426cff8935afe191ffb95f0fd225f7318b6d77b986b 0.0s
=> CACHED [opensips-cp 2/1] COPY modules.inc.php /var/www/html/opensips-cp/config/ 0.0s
=> [opensips-cp] exporting to image 0.0s
=> => exporting layers 0.0s
=> => writing image sha256:cc933bfd2d46eb4bb4a869a941eeef996a7a3cf5353b719292981cc732fa95a9 0.0s
=> => naming to docker.io/library/opensips-softswitch-ce-opensips-cp 0.0s
=> [opensips-cp] resolving provenance for metadata file 0.0s
[+] Running 7/7
✔ Network opensips-softswitch-ce_localnetwork Created0.1s
✔ Volume "opensips-softswitch-ce_db"Created0.0s
✘ Container mysqlError11.5s
✔ Container rtpproxyStarted6.3s
✔ Container freeswitchStarted1.1s
✔ Container opensips-cpCreated0.1s
✔ Container opensipsCreated0.1s
dependency failed to start: container mysql exited (126)
docker logs mysql
2024-12-05 14:50:05+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
2024-12-05 14:50:06+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-12-05 14:50:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.1.0-1.el9 started.
2024-12-05 14:50:06+00:00 [Note] [Entrypoint]: Initializing database files
2024-12-05T14:50:06.700789Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2024-12-05T14:50:06.702997Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.1.0) initializing of server in progress as process 80
2024-12-05T14:50:06.719459Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-05T14:50:07.115336Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-05T14:50:08.393145Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2024-12-05T14:50:11.058586Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
2024-12-05 14:50:11+00:00 [Note] [Entrypoint]: Database files initialized
2024-12-05 14:50:11+00:00 [Note] [Entrypoint]: Starting temporary server
2024-12-05T14:50:11.164068Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-12-05T14:50:11.379681Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.1.0) starting as process 131
2024-12-05T14:50:11.398857Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-12-05T14:50:11.799168Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-12-05T14:50:12.196202Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-12-05T14:50:12.196272Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-12-05T14:50:12.199726Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-12-05T14:50:12.239366Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-12-05T14:50:12.239644Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.1.0' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
2024-12-05 14:50:12+00:00 [Note] [Entrypoint]: Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2024-12-05 14:50:15+00:00 [Note] [Entrypoint]: Creating database opensips
2024-12-05 14:50:15+00:00 [Note] [Entrypoint]: Creating user opensips
2024-12-05 14:50:15+00:00 [Note] [Entrypoint]: Giving user opensips access to schema opensips
2024-12-05 14:50:15+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/00_config_db.sh
/usr/local/bin/docker-entrypoint.sh: /docker-entrypoint-initdb.d/00_config_db.sh: /bin/bash^M: bad interpreter: No such file or directory
docker logs opensips

[dariusstefan]

Hello!
Did you edit the 00_config_db.sh file on Windows?
If so, ensure the file ends only with '\n', instead of '\r\n'. You can run:
sed -i -e 's/\r$//' 00_config_db.sh
Also, check if this file has execute permissions:
chmod +x 00_config_db.sh