Self-hosting posinstall.sh script stopping because of drop_account
- /e/ version: n/a
- Device model(s): n/a
Summary
When a user tries to install a new self-hosted /e/ Cloud, installation stops abruptly while installing "drop_account" Nextcloud app.
The problem
Steps to reproduce
Please see https://community.e.foundation/t/mariadb-issue-access-denied-for-user-root-localhost/24500/14?u=smu44 for the long story.
In short, user is trying to install a self-hosted /e/ Cloud following instructions.
What is the current behavior?
postinstall.sh script stops abruptly while installing Nextcloud "drop_account" app.
Please see script output below.
As mandatory SQL commands didn't run, user can't restart the script, example output :
root@tst1:/mnt/repo-base# /mnt/repo-base/scripts/postinstall.sh
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for ‘nc_OsAF’@’%’
Tried the "auto-delete-account" branch (https://gitlab.e.foundation/e/infra/ecloud-selfhosting/-/blob/auto-delete-account/scripts/postinstall.sh), same behavior.
What is the expected correct behavior?
The postinstall.sh should run smoothly and end with "Please reboot the server now
".
Technical informations
**Relevant logs **
Script output :
Cloning into 'volumes/nextcloud/custom_apps/drop_account'...
remote: Enumerating objects: 84, done.
remote: Counting objects: 100% (84/84), done.
remote: Compressing objects: 100% (54/54), done.
remote: Total 447 (delta 25), reused 82 (delta 23), pack-reused 363
Receiving objects: 100% (447/447), 276.03 KiB | 3.17 MiB/s, done.
Resolving deltas: 100% (190/190), done.
Nextcloud is in maintenance mode - no apps have been loaded
App "Array" cannot be installed because it is not compatible with this version of the server.
Relevant screenshots
n/a
Solutions
Workaround
I can confirm that the postinstall.sh script is working fine when commenting out lines # 34 & 35 (clone from framagit & enable drop_account app).
Possible fixes
As my personal /e/ Cloud was installed ok on 30/04/2020, I propose to use tag 0.2.1 of drop_account which was available at this time.
So I suggest to modify line # 34 of postinstall.sh (from "auto-delete-account" branch) as follow :
< git clone --single-branch https://framagit.org/framasoft/nextcloud/drop_account.git volumes/nextcloud/custom_apps/drop_account
> git clone --single-branch https://framagit.org/framasoft/nextcloud/drop_account.git --branch 0.2.1 volumes/nextcloud/custom_apps/drop_account
Then commit the change to "master" so new users won't fall in same problem.
Alternatively, a complete rework of /e/ Cloud with up-to-date Nextcloud may work fine ;)