Help Owncloud error container big-bear-owncloud is unhealthy

m_F · September 29, 2024, 8:41am

I was able to install owncloud but as soon as I restart the server I get an error message container big-bear-owncloud is unhealthy. I first have to restart owncloud in Portainer then I get to the login page?

Rohman_Nur · February 5, 2025, 4:44am

wait for the answer of this problem @BigBearClub

Sylan · February 26, 2025, 8:45am

Hello,

I have exactly the same situation. I’m unable to install Owncloud, if though I followed the instructions to replace the CasaOS IP with my IP.

I have got a message that indicates that container is unhealthy.

dragonfire1119 · February 26, 2025, 5:43pm

I have this on my to-do list to look into.

Sylan · February 28, 2025, 8:21am

To give additional context :

I just tried to install from CasaOS AppStore OwnCloud package (big-bear)
I installed it without modifying IP addresses in the container parameters:

3à I have tried to look at the Container logs (via this useful script : bash -c “$(wget -qLO - https://raw.githubusercontent.com/bigbeartechworld/big-bear-scripts/master/get-docker-logs/run.sh)”
):

Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Removing custom folder...
Linking custom folder...
Removing config folder...
Linking config folder...
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 -> 
Creating volume folders...
Creating hook folders...
Waiting for MySQL...
services are ready!
Waiting for Redis...
services are ready!
Writing config file...
Fixing base perms...
Fixing data perms...
Fixing hook perms...
Installing server database...
Error while trying to create admin user: An exception occurred while executing 'CREATE TABLE `oc_appconfig` (`appid` VARCHAR(32) DEFAULT '' NOT NULL, `configkey` VARCHAR(64) DEFAULT '' NOT NULL, `configvalue` LONGTEXT DEFAULT NULL, INDEX appconfig_config_key_index (`configkey`), INDEX appconfig_appid_key (`appid`), PRIMARY KEY(`appid`, `configkey`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_bin` ENGINE = InnoDB':

SQLSTATE[HY000]: General error: 1005 Can't create table `big_bear_owncloud`.`oc_appconfig` (errno: 13 "Permission denied")
 ->

dragonfire1119 · March 4, 2025, 6:27am

This has been fixed:

github.com/bigbeartechworld/big-bear-casaos

✨ feat(owncloud): update database and redis configurations

bigbeartechworld:master ← bigbeartechworld:update-owncloud-db-and-redis-volumes

opened 06:25AM - 04 Mar 25 UTC

dragonfire1119

+10 -4

This pull request introduces several updates to the ownCloud application's datab…ase and Redis configurations: - Update the MySQL user from `root` to `bigbear` - Change the MySQL data volume path from `/DATA/AppData/$AppID/data/mysql` to `/DATA/AppData/$AppID/mysql` - Add the `MARIADB_AUTO_UPGRADE=1` environment variable to the database container - Update the Redis data volume path from `/DATA/AppData/$AppID/data/redis` to `/DATA/AppData/$AppID/redis` - Add `depends_on` for the database and Redis containers to the ownCloud container - Add a name to the `big_bear_owncloud_network` network These changes aim to improve the overall configuration and setup of the ownCloud application, ensuring better compatibility and maintainability. ## Summary by CodeRabbit - **Chores** - Improved service startup by ensuring that required components wait for dependencies to be ready. - Enabled automatic database upgrades with an enhanced health check that uses a dedicated user. - Streamlined storage configurations for database and cache services. - Standardized network settings for more consistent connectivity.