koalatiapp / hosting Goto Github PK

Hi when installing the hosted version on local machine (docker) everything starts fine except the koala_database container keeps starting and exiting again giving this log:

2023-03-26 18:44:04+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started. 2023-03-26 18:44:06+00:00 [Note] (Entrypointl: Switching to dedicated user 'mysql' 2023-03-26 18:44:07+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.18 started. "/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2023-03-26718:44:07.5945322 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2023-03-26718:44:07.601158Z 0 [System] [MY-010116] [Server] /us/sbin/mysqld (mysqld 8.0.32) starting as process 1 2023-03-26T18:44:07.719277Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-03-26T18:44:08.105726Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2023-03-26718:44:08.354601Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2023-03-26718:44:08.354808Z 0 (ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2023-03-26718:44:08.354840Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-03-26718:44:08.355587Z 0 [System] [MY-010910] [Server] /us/sbin/mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL. 2023-03-26 18:46:37+00:00 [Note] [Entrypointl: Entrypoint script for MySOL Server 8.0.32-1.18 started. 2023-03-26 18:46:37+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2023-03-26 18:46:37+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started. "/var/lib/mysql/mysql.sock' -> /var/run/mysqld/mysqld.sock' 2023-03-26718:46:38.085327Z 0 [Warning] [MY-011068] [Server] The syntax --skip-host-cache' is deprecated and will be removed in a future release. Please Use SET GLOBAL host_cache_size=0 instead. 2023-03-26718:46:38.212328Z 0 [System] [MY-010116] [Server] /us/sbin/mysqld (mysqld 8.0.32) starting as process 1 2023-03-26T18:46:38.436085Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-03-26718:46:38.540144Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2023-03-26718:46:38.994439Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2023-03-26718:46:38.994753Z 0 (ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2023-03-26T18:46:38.994776Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-03-2618:46:38.995476Z 0 [System] [MY-010910] [Server\ /us/sbin/mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.

Is this a know issue and is this been resolved before?

Assets versioning in Koalati is handled via a version number stored in the KOALATI_RELEASE_VERSION environment variable.

At the moment, this version is not defined in the base images nor in the .env template of this template, which causes the default dev value to be used at all times.

So when an update is made, users must clear their browser cache to get the new assets. This can be problematic for scripts and styles.

This could likely be fixed by either defining an environment variable directly in the base image published to Docker Hub (in the workflow of koalatiapp/app.

Some characters seem to cause issues when they are present in the secrets.

This has been noticed with the ! in a Redis password, which broke an installation until the password was changed and the Redis container rebuilt.