BoxError Database error

[Supaiku]

I'm gettin gthis error on repeat:

2025-01-22T13:47:11.689Z box:server ==========================================
2025-01-22T13:47:11.690Z box:server            Cloudron 8.2.3  
2025-01-22T13:47:11.690Z box:server ==========================================
2025-01-22T13:47:11.690Z box:platform initialize: start platform
2025-01-22T13:47:11.721Z box:tasks stopAllTasks: stopping all tasks
2025-01-22T13:47:11.722Z box:shell tasks /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all
2025-01-22T13:47:11.752Z box:shell All tasks stopped

2025-01-22T13:47:11.765Z Error: Error starting server: {"name":"BoxError","reason":"Database Error","details":{},"message":"ER_NO_SUCH_TABLE: Table 'box.locks' doesn't exist","nestedError":{"code":"ER_NO_SUCH_TABLE","errno":1146,"sqlMessage":"Table 'box.locks' doesn't exist","sqlState":"42S02","index":0,"sql":"DELETE FROM locks"},"code":"ER_NO_SUCH_TABLE","sqlMessage":"Table 'box.locks' doesn't exist"}
2025-01-22T13:47:11.765Z     at main (/home/yellowtent/box/box.js:58:41)
2025-01-22T13:47:11.765Z     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

[Supaiku]

which database would this be?

[Supaiku]

Tried to restor the box.mqysl database in mysql via the instructions here:
https://docs.cloudron.io/troubleshooting/

Now running into more issues:

there was this error while trying to import that database:

ERROR 1046 (3D000) at line 22: No database selected

And currently having this issue with starting box:

2025-01-22T14:15:44.936Z box:server ==========================================
2025-01-22T14:15:44.937Z box:server            Cloudron 8.2.3  
2025-01-22T14:15:44.937Z box:server ==========================================
2025-01-22T14:15:44.937Z box:platform initialize: start platform
2025-01-22T14:15:44.968Z box:tasks stopAllTasks: stopping all tasks
2025-01-22T14:15:44.968Z box:shell tasks /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all
2025-01-22T14:15:45.003Z box:shell All tasks stopped

2025-01-22T14:15:45.023Z Error: Error starting server: {"name":"BoxError","reason":"Database Error","details":{},"message":"ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client","nestedError":{"code":"ER_NOT_SUPPORTED_AUTH_MODE","errno":1251,"sqlMessage":"Client does not support authentication protocol requested by server; consider upgrading MySQL client","sqlState":"08004","fatal":true},"code":"ER_NOT_SUPPORTED_AUTH_MODE","sqlMessage":"Client does not support authentication protocol requested by server; consider upgrading MySQL client"}
2025-01-22T14:15:45.023Z     at main (/home/yellowtent/box/box.js:58:41)
2025-01-22T14:15:45.023Z     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

[joseph]

It seems migration did not run? Can you try running /home/yellowtent/box/setup/start.sh ?

[Supaiku]

well that did something weird...

it had me setup a new box but somehow the apps are still running in the background...

Maybe I lost the backup I had tried to recover somehow?

When does the migration run? what is that a part of?

I had recently upgraded Cloudron...

I want to get my old admin settings back but the recovery instructions seem to be failing...

[nebulon]

If you were shown the initial setup screen again, looks like the db migration really went wrong during the update. Ideally if possible a fresh restore from backups would be best to get to a known state. Is that possible?

[joseph]

@Supaiku said in BoxError Database error:

well that did something weird...

do you have the output? it won't set up a new box unless the database is empty.

[Supaiku]

@joseph the dashboard had me reconfigure the domain, and then the box was empty - no apps or settings - meanwhile everything was running in the background.

I've tried recovering the last database dump, and also from backups, but the error I was getting was interrupting it.

I needed to add the database name into the mysql dump file manually, but now i'm getting:

2025-01-23T13:50:49.964Z box:server            Cloudron 8.2.3  
2025-01-23T13:50:49.964Z box:server ==========================================
2025-01-23T13:50:49.964Z box:platform initialize: start platform
2025-01-23T13:50:49.994Z box:tasks stopAllTasks: stopping all tasks
2025-01-23T13:50:49.994Z box:shell tasks /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all
2025-01-23T13:50:50.039Z box:shell All tasks stopped

2025-01-23T13:50:50.050Z Error: Error starting server: {"name":"BoxError","reason":"Database Error","details":{},"message":"ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client","nestedError":{"code":"ER_NOT_SUPPORTED_AUTH_MODE","errno":1251,"sqlMessage":"Client does not support authentication protocol requested by server; consider upgrading MySQL client","sqlState":"08004","fatal":true},"code":"ER_NOT_SUPPORTED_AUTH_MODE","sqlMessage":"Client does not support authentication protocol requested by server; consider upgrading MySQL client"}
2025-01-23T13:50:50.050Z     at main (/home/yellowtent/box/box.js:58:41)
2025-01-23T13:50:50.050Z     at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

[Supaiku]

Ok, it seemed running the /home/yellowtent/box/setup/start.sh to trigger the migration after restoring the database (because of the ERROR 1046 (3D000) at line 22: No database selected i needed to add these two lines to the dump file:

CREATE DATABASE box;
USE box;

Then it was able to backup the database and run the migration.