Zombie Nextcloud: Running without database, how to properly resurrect it?

ℹ️ Support
1

Hello
I’ve accidentally deleted the MariaDB database folder linked to my Nextcloud installation. Surprisingly, Nextcloud is still functioning normally. My setup includes Docker containers for MariaDB, Nextcloud, and Redis. I haven’t restarted the system yet, which might be why everything still appears to work. Using redis-cli MONITOR, I’ve confirmed that there’s active communication between Nextcloud and Redis. While I can’t fully recreate the MariaDB database from Redis data, I can still access important information through the Nextcloud web interface, including:

Current files and folders
Recently deleted files in the trash
File version history
Contacts and calendars
User and system settings
Third-party app data

My priority now is to backup all accessible data before attempting any system restarts or database restoration. I understand that Redis is primarily used for caching and doesn’t replace the full functionality of MariaDB. I’m aware that I need to act quickly to preserve my data and restore the MariaDB database to ensure long-term stability of my Nextcloud installation. HELP NEEDED: I’m in urgent need of expert advice on how to proceed with data recovery and database restoration without losing my current Nextcloud functionality. Has anyone experienced a similar situation or can provide step-by-step guidance on the safest way to recover from this critical error? Any help or insights would be greatly appreciated as I’m dealing with potentially sensitive data and need to resolve this as soon as possible.
Thank you in advance for your support!

2

If the db service is still accessible (sounds like it; Nextcloud would generate an internal server error if your MariaDB instance wasn’t serving data), you can use the documented backup procedure:

https://docs.nextcloud.com/server/latest/admin_manual/maintenance/backup.html

Once you address your current emergency, this is a good time to review that chapter more fully and make sure you have a real backup strategy in place going forward.

3

Are you sure that mariadb is still accessible? I tried connecting to the container containing mariadb, with the user registered in the nextcloud config file. But there is no table available for this user (apart from the default one). However, the user does exist, with the nextcloud config password.
In short, before doing anything, I double check, in case the databases are stored in the ram, I don’t want to interrupt them.

Translated with DeepL.com (free version)

4

hello, finnaly i try :

sudo docker exec -u 33 Nextcloud php occ maintenance:mode --on
docker exec Nextcloud mariadb-dump --single-transaction -h NextcloudMariadb -u nextcloud -ppassword nextcloud > nextcloud-sqlbkp_`date +"%Y%m%d"`.bak
sudo docker exec -u 33 Nextcloud php occ maintenance:mode --off

The .bak file I recovered contains only this:

OCI runtime exec failed: exec failed: unable to start container process: exec: "mariadb-dump": executable file not found in $PATH: unknown

I’d like to remind you that I’ve already tried to connect directly to the mariadb via its container, and although the nextcloud account does exist, it’s empty.

5

No. I was going on what you said.

I tried connecting to the container containing mariadb, with the user registered in the nextcloud config file. But there is no table available for this user (apart from the default one). However, the user does exist, with the nextcloud config password.

Sounds like the database is gone / was reset. Which makes sense if the folder was removed (or if it was never in-use to start with…)

hello, finnaly i try :

The dump command needs to run from the db container.

I’d like to remind you that I’ve already tried to connect directly to the mariadb via its container, and although the nextcloud account does exist, it’s empty.

Then your database is gone (or not being used). You won’t be able to run a dump to back it up now (in any way that will be useful), since there’s nothing to backup. At least based on the information you’ve provided.

I understand that Redis is primarily used for caching and doesn’t replace the full functionality of MariaDB.

You will not be able to use Redis to restore your database.

However your files will still be stored within your nextcloud container’s data volume. Only the file index is stored in the database (and associated bits of information such as whether a file is shared with someone, etc.)

Unfortunately that won’t include anything stored in the database like contacts, calendars, etc.

Has anyone experienced a similar situation or can provide step-by-step guidance on the safest way to recover from this critical error? Any help or insights would be greatly appreciated as I’m dealing with potentially sensitive data and need to resolve this as soon as possible.

This would be a situation where you would use your backups to restore.

Have you never made backups of your database and files prior to this incident?

While I can’t fully recreate the MariaDB database from Redis data, I can still access important information through the Nextcloud web interface, including: […]

Are you sure your Nextcloud instance is actually using MariaDB? I ask because none of the things you listed should be accessible if your database is really offline or empty. The Web UI would just return an internal server error.

Perhaps you can check your nextcloud.log as well as post the output of trying to run ./occ config:list system from inside the Nextcloud container? If you’re lucky (in this case), your Nextcloud instance is really using sqlite3 or something instead.

6
occ config:list 
{
    "system": {
        "loglevel": 3,
        "htaccess.RewriteBase": "\/",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "password": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "upgrade.disable-web": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "mysite.fr"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.4.1",
        "overwrite.cli.url": "http:\/\/mysite.fr",
        "overwriteprotocol": "https",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "forwarded-for-headers": [
            "HTTP_X_FORWARDED_FOR"
        ],
        "maintenance_window_start": 4,
        "default_phone_region": "optional",
        "maintenance": false,
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "opcache.memory_consumption": "256",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "ssl",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "app_install_overwrite": [
            "maps"
        ]
    },
    "apps": {
        "activity": {
            "enabled": "yes",
            "installed_version": "3.0.0",
            "notify_email_calendar": "0",
            "notify_email_calendar_event": "0",
            "notify_email_calendar_todo": "0",
            "notify_email_comments": "0",
            "notify_email_contacts": "0",
            "notify_email_file_changed": "0",
            "notify_email_group_settings": "0",
            "notify_email_public_links": "0",
            "notify_email_remote_share": "0",
            "notify_email_shared": "0",
            "notify_email_spreed": "0",
            "notify_email_systemtags": "0",
            "notify_notification_calendar": "0",
            "notify_notification_calendar_event": "0",
            "notify_notification_calendar_todo": "0",
            "notify_notification_comments": "0",
            "notify_notification_contacts": "0",
            "notify_notification_favorite": "0",
            "notify_notification_file_changed": "0",
            "notify_notification_file_favorite_changed": "0",
            "notify_notification_group_settings": "0",
            "notify_notification_personal_settings": "0",
            "notify_notification_public_links": "0",
            "notify_notification_remote_share": "0",
            "notify_notification_security": "1",
            "notify_notification_shared": "0",
            "notify_notification_spreed": "0",
            "notify_notification_systemtags": "0",
            "notify_setting_batchtime": "3600",
            "notify_setting_self": "0",
            "notify_setting_selfemail": "0",
            "types": "filesystem"
        },
        "app_api": {
            "enabled": "yes",
            "installed_version": "4.0.3",
            "types": ""
        },
        "assistant": {
            "enabled": "yes",
            "installed_version": "2.1.1",
            "types": ""
        },
        "backgroundjob": {
            "lastjob": "342650"
        },
        "bruteforcesettings": {
            "enabled": "yes",
            "installed_version": "3.0.0",
            "types": ""
        },
        "calendar": {
            "enabled": "yes",
            "installed_version": "5.0.8",
            "types": ""
        },
        "camerarawpreviews": {
            "enabled": "yes",
            "installed_version": "0.8.6",
            "types": "filesystem"
        },
        "certificate24": {
            "account": "{\"id\":\"744f37df-956b-4dc4-9a2f-fbac945484c9\",\"secret\":\"\/P7JyxHlwOZU+3ff41K14bCcvE58Nabr6Kex6MaHdXTJWfb1MvXtANpVVw97COJdSVlRY1lkUiYb\/BMc53eSXA==\"}",
            "enabled": "yes",
            "installed_version": "0.3.5",
            "types": "dav"
        },
        "circles": {
            "enabled": "yes",
            "installed_version": "30.0.0",
            "loopback_tmp_scheme": "http",
            "maintenance_run": "0",
            "maintenance_update": "{\"3\":1736701800,\"2\":1736703000,\"1\":1736703300}",
            "migration_22": "1",
            "migration_run": "0",
            "types": "filesystem,dav"
        },
        "cloud_federation_api": {
            "enabled": "yes",
            "installed_version": "1.13.0",
            "types": "filesystem"
        },
        "cloud_py_api": {
            "enabled": "yes",
            "installed_version": "0.2.0",
            "types": ""
        },
        "comments": {
            "enabled": "yes",
            "installed_version": "1.20.1",
            "types": "logging"
        },
        "contacts": {
            "enabled": "yes",
            "installed_version": "6.1.2",
            "types": "dav"
        },
        "contactsinteraction": {
            "enabled": "yes",
            "installed_version": "1.11.0",
            "types": "dav"
        },
        "core": {
            "backgroundjobs_mode": "cron",
            "emailTestSuccessful": "1",
            "files_metadata_installed": "1",
            "installedat": "1709609592.8643",
            "lastcron": 1736703301,
            "lastupdateResult": "[]",
            "lastupdatedat": 1736656577,
            "metadataGenerationDone": true,
            "moveavatarsdone": "yes",
            "previewsCleanedUp": "1",
            "public_files": "files_sharing\/public.php",
            "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php",
            "shareapi_allow_share_dialog_user_enumeration": "yes",
            "shareapi_restrict_user_enumeration_to_group": "yes",
            "vendor": "nextcloud",
            "files_metadata": {
                "photos-original_date_time": {
                    "value": null,
                    "type": "int",
                    "etag": "",
                    "indexed": true,
                    "editPermission": 0
                },
                "photos-size": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-exif": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-ifd0": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-gps": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-place": {
                    "value": null,
                    "type": "string",
                    "etag": "",
                    "indexed": true,
                    "editPermission": 0
                },
                "blurhash": {
                    "value": null,
                    "type": "string",
                    "etag": "115f2e1e10065e0371525959a661fe21",
                    "indexed": false,
                    "editPermission": 0
                }
            },
            "oc.integritycheck.checker": []
        },
        "dashboard": {
            "enabled": "yes",
            "installed_version": "7.10.0",
            "types": ""
        },
        "dav": {
            "buildCalendarReminderIndex": "yes",
            "buildCalendarSearchIndex": "yes",
            "builtSocialSearchIndex": "yes",
            "chunks_migrated": "1",
            "enabled": "yes",
            "installed_version": "1.31.1",
            "needs_system_address_book_sync": "no",
            "regeneratedBirthdayCalendarsForYearFix": "yes",
            "types": "filesystem"
        },
        "deck": {
            "enabled": "yes",
            "installed_version": "1.14.2",
            "types": "dav"
        },
        "external": {
            "enabled": "yes",
            "installed_version": "5.5.2",
            "jwt_token_privkey_es256": "***REMOVED SENSITIVE VALUE***",
            "jwt_token_pubkey_es256": "-----BEGIN PUBLIC KEY-----\nMFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAEjaDEmpbBxU6o+DYXsbrPZWz+BLXR\n2ZlGrYiU5slQdEyHf7XsHto0P1KctSRnszGCq0aG9xmI0YpqKrXLnSzkBQ==\n-----END PUBLIC KEY-----\n",
            "max_site": "4",
            "sites": "***REMOVED SENSITIVE VALUE***",
            "types": ""
        },
        "federatedfilesharing": {
            "enabled": "yes",
            "installed_version": "1.20.0",
            "types": ""
        },
        "federation": {
            "enabled": "yes",
            "installed_version": "1.20.0",
            "types": "authentication"
        },
        "files": {
            "enabled": "yes",
            "installed_version": "2.2.0",
            "mimetype_version": "30.0.0.14",
            "types": "filesystem"
        },
        "files_downloadlimit": {
            "enabled": "yes",
            "installed_version": "3.0.0",
            "types": ""
        },
        "files_external": {
            "enabled": "no",
            "installed_version": "1.22.0",
            "types": "filesystem"
        },
        "files_pdfviewer": {
            "enabled": "yes",
            "installed_version": "3.0.0",
            "types": ""
        },
        "files_reminders": {
            "enabled": "yes",
            "installed_version": "1.3.0",
            "types": ""
        },
        "files_sharing": {
            "enabled": "yes",
            "incoming_server2server_group_share_enabled": "yes",
            "installed_version": "1.22.0",
            "lookupServerEnabled": "yes",
            "outgoing_server2server_group_share_enabled": "yes",
            "types": "filesystem"
        },
        "files_trashbin": {
            "enabled": "yes",
            "installed_version": "1.20.1",
            "types": "filesystem,dav"
        },
        "files_versions": {
            "enabled": "yes",
            "installed_version": "1.23.0",
            "types": "filesystem,dav"
        },
        "firstrunwizard": {
            "enabled": "yes",
            "installed_version": "3.0.0",
            "types": "logging"
        },
        "groupfolders": {
            "cron_last_folder_index": 4,
            "enabled": "yes",
            "installed_version": "18.0.8",
            "types": "filesystem,dav"
        },
        "logreader": {
            "enabled": "yes",
            "installed_version": "3.0.0",
            "types": "logging"
        },
        "lookup_server_connector": {
            "enabled": "yes",
            "installed_version": "1.18.0",
            "types": "authentication"
        },
        "mail": {
            "enabled": "yes",
            "installed_version": "4.1.1",
            "types": ""
        },
        "maps": {
            "enabled": "yes",
            "installed_version": "1.5.0",
            "types": "filesystem"
        },
        "mediadc": {
            "enabled": "yes",
            "installed_version": "0.4.0",
            "types": ""
        },
        "nextcloud_announcements": {
            "enabled": "yes",
            "installed_version": "2.0.0",
            "pub_date": "Thu, 24 Oct 2019 00:00:00 +0200",
            "types": "logging"
        },
        "notes": {
            "enabled": "yes",
            "installed_version": "4.11.0",
            "types": ""
        },
        "notifications": {
            "enabled": "yes",
            "installed_version": "3.0.0",
            "setting_batchtime": "0",
            "sound_notification": "yes",
            "sound_talk": "yes",
            "types": "logging"
        },
        "oauth2": {
            "enabled": "yes",
            "installed_version": "1.18.1",
            "types": "authentication"
        },
        "ocsms": {
            "enabled": "no",
            "installed_version": "2.2.0",
            "types": ""
        },
        "password_policy": {
            "enabled": "yes",
            "installed_version": "2.0.0",
            "minLength": "8",
            "types": "authentication"
        },
        "photos": {
            "enabled": "yes",
            "installed_version": "3.0.2",
            "lastPlaceMappedUser": "admin",
            "lastPlaceMappingDone": "true",
            "types": "dav,authentication"
        },
        "privacy": {
            "enabled": "yes",
            "installed_version": "2.0.0",
            "types": ""
        },
        "provisioning_api": {
            "enabled": "yes",
            "installed_version": "1.20.0",
            "types": "prevent_group_restriction"
        },
        "recognize": {
            "clusterFaces.lastRun": "1729730078",
            "clusterFaces.status": "true",
            "concurrency.enabled": "false",
            "enabled": "yes",
            "faces.batchSize": "500",
            "faces.enabled": "true",
            "faces.lastFile": "1724030556",
            "faces.status": "true",
            "imagenet.batchSize": "100",
            "imagenet.enabled": "true",
            "imagenet.lastFile": "1732749927",
            "imagenet.status": "true",
            "installed_version": "8.2.0",
            "landmarks.batchSize": "100",
            "landmarks.enabled": "true",
            "landmarks.lastFile": "1729730724",
            "landmarks.status": "true",
            "movinet.batchSize": "20",
            "movinet.enabled": "true",
            "movinet.lastFile": "1732749964",
            "movinet.status": "true",
            "musicnn.batchSize": "100",
            "musicnn.enabled": "true",
            "musicnn.lastFile": "1731339918",
            "musicnn.status": "true",
            "nice_binary": "\/usr\/bin\/nice",
            "nice_value": "0",
            "node_binary": "\/var\/www\/html\/custom_apps\/recognize\/bin\/node",
            "tensorflow.cores": "0",
            "tensorflow.gpu": "false",
            "tensorflow.purejs": "false",
            "types": "filesystem,dav"
        },
        "recommendations": {
            "enabled": "yes",
            "installed_version": "3.0.0",
            "types": ""
        },
        "related_resources": {
            "enabled": "yes",
            "installed_version": "1.5.0",
            "types": ""
        },
        "richdocuments": {
            "disable_certificate_verification": "",
            "enabled": "yes",
            "installed_version": "8.5.3",
            "public_wopi_url": "https:\/\/collabora.mysite.fr",
            "types": "prevent_group_restriction",
            "wopi_allowlist": "",
            "wopi_url": "https:\/\/collabora.mysite.fr"
        },
        "richdocumentscode": {
            "enabled": "yes",
            "installed_version": "24.4.1002",
            "types": ""
        },
        "serverinfo": {
            "cached_count_filecache": "358214",
            "cached_count_storages": "24",
            "enabled": "yes",
            "installed_version": "2.0.0",
            "types": ""
        },
        "settings": {
            "enabled": "yes",
            "installed_version": "1.13.0",
            "types": ""
        },
        "sharebymail": {
            "enabled": "yes",
            "installed_version": "1.20.0",
            "types": "filesystem"
        },
        "spreed": {
            "allowed_groups": "[]",
            "enabled": "yes",
            "has_reference_id": "yes",
            "installed_version": "20.1.1",
            "project_access_invalidated": "1",
            "signaling_ticket_secret": "***REMOVED SENSITIVE VALUE***",
            "signaling_token_privkey_es256": "***REMOVED SENSITIVE VALUE***",
            "signaling_token_pubkey_es256": "***REMOVED SENSITIVE VALUE***",
            "sip_bridge_groups": "[]",
            "start_conversations": "[]",
            "types": "dav,prevent_group_restriction"
        },
        "support": {
            "SwitchUpdaterServerHasRun": "yes",
            "enabled": "yes",
            "installed_version": "2.0.0",
            "types": "session"
        },
        "survey_client": {
            "enabled": "yes",
            "installed_version": "2.0.0",
            "last_report": "{\"id\":\"ocih2nesmk8t\",\"items\":[[\"server\",\"version\",\"30.0.1.2\"],[\"server\",\"code\",\"other\"],[\"server\",\"enable_avatars\",\"yes\"],[\"server\",\"enable_previews\",\"yes\"],[\"server\",\"memcache.local\",\"\\\\OC\\\\Memcache\\\\APCu\"],[\"server\",\"memcache.distributed\",\"\\\\OC\\\\Memcache\\\\Redis\"],[\"server\",\"asset-pipeline.enabled\",\"no\"],[\"server\",\"filelocking.enabled\",\"yes\"],[\"server\",\"memcache.locking\",\"\\\\OC\\\\Memcache\\\\Redis\"],[\"server\",\"debug\",\"no\"],[\"server\",\"cron\",\"cron\"],[\"php\",\"version\",\"8.2.25\"],[\"php\",\"memory_limit\",536870912],[\"php\",\"max_execution_time\",0],[\"php\",\"upload_max_filesize\",536870912],[\"database\",\"type\",\"mysql\"],[\"database\",\"version\",\"11.4.4\"],[\"database\",\"size\",660062208],[\"apps\",\"activity\",\"3.0.0\"],[\"apps\",\"app_api\",\"4.0.0\"],[\"apps\",\"assistant\",\"2.1.1\"],[\"apps\",\"bruteforcesettings\",\"3.0.0\"],[\"apps\",\"calendar\",\"5.0.6\"],[\"apps\",\"camerarawpreviews\",\"0.8.6\"],[\"apps\",\"certificate24\",\"0.3.5\"],[\"apps\",\"circles\",\"30.0.0-dev\"],[\"apps\",\"cloud_federation_api\",\"1.13.0\"],[\"apps\",\"cloud_py_api\",\"0.2.0\"],[\"apps\",\"comments\",\"1.20.1\"],[\"apps\",\"contacts\",\"6.1.1\"],[\"apps\",\"contactsinteraction\",\"1.11.0\"],[\"apps\",\"dashboard\",\"7.10.0\"],[\"apps\",\"dav\",\"1.31.1\"],[\"apps\",\"deck\",\"1.14.2\"],[\"apps\",\"external\",\"5.5.2\"],[\"apps\",\"federatedfilesharing\",\"1.20.0\"],[\"apps\",\"federation\",\"1.20.0\"],[\"apps\",\"files\",\"2.2.0\"],[\"apps\",\"files_downloadlimit\",\"3.0.0\"],[\"apps\",\"files_external\",\"1.22.0\"],[\"apps\",\"files_pdfviewer\",\"3.0.0\"],[\"apps\",\"files_reminders\",\"1.3.0\"],[\"apps\",\"files_sharing\",\"1.22.0\"],[\"apps\",\"files_trashbin\",\"1.20.1\"],[\"apps\",\"files_versions\",\"1.23.0\"],[\"apps\",\"firstrunwizard\",\"3.0.0\"],[\"apps\",\"groupfolders\",\"18.0.8\"],[\"apps\",\"logreader\",\"3.0.0\"],[\"apps\",\"lookup_server_connector\",\"1.18.0\"],[\"apps\",\"mail\",\"4.0.9\"],[\"apps\",\"maps\",\"1.5.0\"],[\"apps\",\"mediadc\",\"0.4.0\"],[\"apps\",\"nextcloud_announcements\",\"2.0.0\"],[\"apps\",\"notes\",\"4.11.0\"],[\"apps\",\"notifications\",\"3.0.0\"],[\"apps\",\"oauth2\",\"1.18.1\"],[\"apps\",\"ocsms\",\"disabled\"],[\"apps\",\"password_policy\",\"2.0.0\"],[\"apps\",\"photos\",\"3.0.2\"],[\"apps\",\"privacy\",\"2.0.0\"],[\"apps\",\"provisioning_api\",\"1.20.0\"],[\"apps\",\"recognize\",\"8.2.0\"],[\"apps\",\"recommendations\",\"3.0.0\"],[\"apps\",\"related_resources\",\"1.5.0\"],[\"apps\",\"richdocuments\",\"8.5.3\"],[\"apps\",\"richdocumentscode\",\"24.4.1002\"],[\"apps\",\"serverinfo\",\"2.0.0\"],[\"apps\",\"settings\",\"1.13.0\"],[\"apps\",\"sharebymail\",\"1.20.0\"],[\"apps\",\"spreed\",\"20.1.0\"],[\"apps\",\"support\",\"2.0.0\"],[\"apps\",\"survey_client\",\"2.0.0\"],[\"apps\",\"systemtags\",\"1.20.0\"],[\"apps\",\"text\",\"4.1.0\"],[\"apps\",\"theming\",\"2.5.0\"],[\"apps\",\"twofactor_backupcodes\",\"1.19.0\"],[\"apps\",\"updatenotification\",\"1.20.0\"],[\"apps\",\"user_ldap\",\"disabled\"],[\"apps\",\"user_status\",\"1.10.0\"],[\"apps\",\"viewer\",\"3.0.0\"],[\"apps\",\"weather_status\",\"1.10.0\"],[\"apps\",\"webhook_listeners\",\"1.1.0-dev\"],[\"apps\",\"whiteboard\",\"1.0.4\"],[\"apps\",\"workflowengine\",\"2.12.0\"],[\"stats\",\"num_files\",351446],[\"stats\",\"num_users\",6],[\"stats\",\"num_storages\",25],[\"stats\",\"num_storages_local\",9],[\"stats\",\"num_storages_home\",6],[\"stats\",\"num_storages_other\",10],[\"stats\",\"num_comments\",397],[\"stats\",\"num_comment_markers\",0],[\"stats\",\"num_systemtags\",167],[\"stats\",\"num_systemtags_mappings\",4294],[\"files_sharing\",\"num_shares\",10],[\"files_sharing\",\"num_shares_user\",0],[\"files_sharing\",\"num_shares_groups\",1],[\"files_sharing\",\"num_shares_link\",5],[\"files_sharing\",\"num_shares_link_no_password\",5],[\"files_sharing\",\"num_fed_shares_sent\",0],[\"files_sharing\",\"num_fed_shares_received\",0],[\"files_sharing\",\"permissions_1_1\",1],[\"files_sharing\",\"permissions_2_1\",4],[\"files_sharing\",\"permissions_3_17\",5],[\"encryption\",\"enabled\",\"no\"],[\"encryption\",\"default_module\",\"no\"]]}",
            "last_sent": "1734568503",
            "types": ""
        },
        "systemtags": {
            "enabled": "yes",
            "installed_version": "1.20.0",
            "types": "logging"
        },
        "text": {
            "enabled": "yes",
            "installed_version": "4.1.0",
            "types": "dav"
        },
        "theming": {
            "enabled": "yes",
            "installed_version": "2.5.0",
            "types": "logging"
        },
        "twofactor_backupcodes": {
            "enabled": "yes",
            "installed_version": "1.19.0",
            "types": ""
        },
        "updatenotification": {
            "assistant": "2.2.0",
            "calendar": "5.0.8",
            "certificate24": "0.3.5",
            "contacts": "6.1.3",
            "core": "30.0.4.1",
            "deck": "1.14.2",
            "enabled": "yes",
            "external": "5.5.2",
            "groupfolders": "18.0.8",
            "installed_version": "1.20.0",
            "mail": "4.1.1",
            "recognize": "8.2.0",
            "richdocuments": "8.5.3",
            "richdocumentscode": "24.4.1103",
            "spreed": "20.1.1",
            "types": "",
            "update_check_errors": "0"
        },
        "user_ldap": {
            "background_sync_interval": "1800",
            "enabled": "no",
            "installed_version": "1.21.0",
            "s01_lastChange": "1729732201",
            "s01has_memberof_filter_support": "0",
            "s01home_folder_naming_rule": "",
            "s01last_jpegPhoto_lookup": "0",
            "s01ldap_admin_group": "",
            "s01ldap_agent_password": "***REMOVED SENSITIVE VALUE***",
            "s01ldap_attr_address": "",
            "s01ldap_attr_anniversarydate": "",
            "s01ldap_attr_biography": "",
            "s01ldap_attr_birthdate": "",
            "s01ldap_attr_fediverse": "",
            "s01ldap_attr_headline": "",
            "s01ldap_attr_organisation": "",
            "s01ldap_attr_phone": "",
            "s01ldap_attr_role": "",
            "s01ldap_attr_twitter": "",
            "s01ldap_attr_website": "",
            "s01ldap_attributes_for_group_search": "",
            "s01ldap_attributes_for_user_search": "",
            "s01ldap_background_host": "",
            "s01ldap_background_port": "",
            "s01ldap_backup_host": "",
            "s01ldap_backup_port": "",
            "s01ldap_base": "",
            "s01ldap_base_groups": "",
            "s01ldap_base_users": "",
            "s01ldap_cache_ttl": "600",
            "s01ldap_configuration_active": "0",
            "s01ldap_connection_timeout": "15",
            "s01ldap_default_ppolicy_dn": "",
            "s01ldap_display_name": "displayName",
            "s01ldap_dn": "",
            "s01ldap_dynamic_group_member_url": "",
            "s01ldap_email_attr": "",
            "s01ldap_experienced_admin": "0",
            "s01ldap_expert_username_attr": "",
            "s01ldap_expert_uuid_group_attr": "",
            "s01ldap_expert_uuid_user_attr": "",
            "s01ldap_ext_storage_home_attribute": "",
            "s01ldap_gid_number": "gidNumber",
            "s01ldap_group_display_name": "cn",
            "s01ldap_group_filter": "",
            "s01ldap_group_filter_mode": "0",
            "s01ldap_group_member_assoc_attribute": "",
            "s01ldap_groupfilter_groups": "",
            "s01ldap_groupfilter_objectclass": "",
            "s01ldap_host": "",
            "s01ldap_login_filter": "",
            "s01ldap_login_filter_mode": "0",
            "s01ldap_loginfilter_attributes": "",
            "s01ldap_loginfilter_email": "0",
            "s01ldap_loginfilter_username": "1",
            "s01ldap_mark_remnants_as_disabled": "0",
            "s01ldap_matching_rule_in_chain_state": "unknown",
            "s01ldap_nested_groups": "0",
            "s01ldap_override_main_server": "",
            "s01ldap_paging_size": "500",
            "s01ldap_port": "",
            "s01ldap_quota_attr": "",
            "s01ldap_quota_def": "",
            "s01ldap_tls": "0",
            "s01ldap_turn_off_cert_check": "0",
            "s01ldap_turn_on_pwd_change": "0",
            "s01ldap_user_avatar_rule": "default",
            "s01ldap_user_display_name_2": "",
            "s01ldap_user_filter_mode": "0",
            "s01ldap_userfilter_groups": "",
            "s01ldap_userfilter_objectclass": "",
            "s01ldap_userlist_filter": "",
            "s01use_memberof_to_detect_membership": "1",
            "types": "authentication"
        },
        "user_status": {
            "enabled": "yes",
            "installed_version": "1.10.0",
            "types": ""
        },
        "viewer": {
            "enabled": "yes",
            "installed_version": "3.0.0",
            "types": ""
        },
        "weather_status": {
            "enabled": "yes",
            "installed_version": "1.10.0",
            "types": ""
        },
        "webhook_listeners": {
            "enabled": "yes",
            "installed_version": "1.1.0-dev",
            "types": "filesystem"
        },
        "whiteboard": {
            "enabled": "yes",
            "installed_version": "1.0.4",
            "types": ""
        },
        "workflowengine": {
            "enabled": "yes",
            "installed_version": "2.12.0",
            "types": "filesystem"
        }
    }
}

but when I go to settings>system, I get this error message

settings>system 
{
  "reqId": "olf5yYhPstEUs85FLFGj",
  "level": 3,
  "time": "2025-01-12T17:15:21+00:00",
  "remoteAddr": "37.169.112.42",
  "user": "vaneck",
  "app": "index",
  "method": "GET",
  "url": "/settings/admin/serverinfo",
  "message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'zincloud'",
  "userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0",
  "version": "30.0.4.1",
  "exception": {
    "Exception": "OC\\DB\\Exceptions\\DbalException",
    "Message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'zincloud'",
    "Code": 1049,
    "Trace": [
      {
        "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
        "line": 53,
        "function": "wrap",
        "class": "OC\\DB\\Exceptions\\DbalException",
        "type": "::",
        "args": [
          {
            "__class__": "Doctrine\\DBAL\\Exception\\ConnectionException"
          }
        ]
      },
      {
        "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
        "line": 79,
        "function": "executeQuery",
        "class": "OC\\DB\\ConnectionAdapter",
        "type": "->",
        "args": [
          "SHOW TABLE STATUS FROM `zincloud`"
        ]
      },
      {
        "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
        "line": 33,
        "function": "databaseSize",
        "class": "OCA\\ServerInfo\\DatabaseStatistics",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/serverinfo/lib/Settings/AdminSettings.php",
        "line": 73,
        "function": "getDatabaseStatistics",
        "class": "OCA\\ServerInfo\\DatabaseStatistics",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
        "line": 117,
        "function": "getForm",
        "class": "OCA\\ServerInfo\\Settings\\AdminSettings",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
        "line": 74,
        "function": "formatSettings",
        "class": "OCA\\Settings\\Controller\\AdminSettingsController",
        "type": "->",
        "args": [
          [
            [
              {
                "__class__": "OCA\\ServerInfo\\Settings\\AdminSettings"
              }
            ]
          ]
        ]
      },
      {
        "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
        "line": 142,
        "function": "getSettings",
        "class": "OCA\\Settings\\Controller\\AdminSettingsController",
        "type": "->",
        "args": [
          "serverinfo"
        ]
      },
      {
        "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
        "line": 58,
        "function": "getIndexResponse",
        "class": "OCA\\Settings\\Controller\\AdminSettingsController",
        "type": "->",
        "args": [
          "admin",
          "serverinfo"
        ]
      },
      {
        "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 208,
        "function": "index",
        "class": "OCA\\Settings\\Controller\\AdminSettingsController",
        "type": "->",
        "args": [
          "serverinfo"
        ]
      },
      {
        "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 114,
        "function": "executeController",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->",
        "args": [
          {
            "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
          },
          "index"
        ]
      },
      {
        "file": "/var/www/html/lib/private/AppFramework/App.php",
        "line": 161,
        "function": "dispatch",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->",
        "args": [
          {
            "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
          },
          "index"
        ]
      },
      {
        "file": "/var/www/html/lib/private/Route/Router.php",
        "line": 302,
        "function": "main",
        "class": "OC\\AppFramework\\App",
        "type": "::",
        "args": [
          "OCA\\Settings\\Controller\\AdminSettingsController",
          "index",
          {
            "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
          },
          {
            "section": "serverinfo",
            "_route": "settings.adminsettings.index"
          }
        ]
      },
      {
        "file": "/var/www/html/lib/base.php",
        "line": 1003,
        "function": "match",
        "class": "OC\\Route\\Router",
        "type": "->",
        "args": [
          "/settings/admin/serverinfo"
        ]
      },
      {
        "file": "/var/www/html/index.php",
        "line": 24,
        "function": "handleRequest",
        "class": "OC",
        "type": "::",
        "args": []
      }
    ],
    "File": "/var/www/html/lib/private/DB/Exceptions/DbalException.php",
    "Line": 54,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Exception\\ConnectionException",
      "Message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'zincloud'",
      "Code": 1049,
      "Trace": [
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1939,
          "function": "convert",
          "class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
          "type": "->",
          "args": [
            {
              "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            },
            {
              "__class__": "Doctrine\\DBAL\\Query"
            }
          ]
        },
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1881,
          "function": "handleDriverException",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            {
              "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            },
            {
              "__class__": "Doctrine\\DBAL\\Query"
            }
          ]
        },
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1106,
          "function": "convertExceptionDuringQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            {
              "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            },
            "SHOW TABLE STATUS FROM `zincloud`",
            [],
            []
          ]
        },
        {
          "file": "/var/www/html/lib/private/DB/Connection.php",
          "line": 415,
          "function": "executeQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            "SHOW TABLE STATUS FROM `zincloud`",
            [],
            [],
            null
          ]
        },
        {
          "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
          "line": 50,
          "function": "executeQuery",
          "class": "OC\\DB\\Connection",
          "type": "->",
          "args": [
            "SHOW TABLE STATUS FROM `zincloud`",
            [],
            []
          ]
        },
        {
          "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
          "line": 79,
          "function": "executeQuery",
          "class": "OC\\DB\\ConnectionAdapter",
          "type": "->",
          "args": [
            "SHOW TABLE STATUS FROM `zincloud`"
          ]
        },
        {
          "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
          "line": 33,
          "function": "databaseSize",
          "class": "OCA\\ServerInfo\\DatabaseStatistics",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/serverinfo/lib/Settings/AdminSettings.php",
          "line": 73,
          "function": "getDatabaseStatistics",
          "class": "OCA\\ServerInfo\\DatabaseStatistics",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
          "line": 117,
          "function": "getForm",
          "class": "OCA\\ServerInfo\\Settings\\AdminSettings",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
          "line": 74,
          "function": "formatSettings",
          "class": "OCA\\Settings\\Controller\\AdminSettingsController",
          "type": "->",
          "args": [
            [
              [
                {
                  "__class__": "OCA\\ServerInfo\\Settings\\AdminSettings"
                }
              ]
            ]
          ]
        },
        {
          "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
          "line": 142,
          "function": "getSettings",
          "class": "OCA\\Settings\\Controller\\AdminSettingsController",
          "type": "->",
          "args": [
            "serverinfo"
          ]
        },
        {
          "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
          "line": 58,
          "function": "getIndexResponse",
          "class": "OCA\\Settings\\Controller\\AdminSettingsController",
          "type": "->",
          "args": [
            "admin",
            "serverinfo"
          ]
        },
        {
          "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 208,
          "function": "index",
          "class": "OCA\\Settings\\Controller\\AdminSettingsController",
          "type": "->",
          "args": [
            "serverinfo"
          ]
        },
        {
          "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 114,
          "function": "executeController",
          "class": "OC\\AppFramework\\Http\\Dispatcher",
          "type": "->",
          "args": [
            {
              "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
            },
            "index"
          ]
        },
        {
          "file": "/var/www/html/lib/private/AppFramework/App.php",
          "line": 161,
          "function": "dispatch",
          "class": "OC\\AppFramework\\Http\\Dispatcher",
          "type": "->",
          "args": [
            {
              "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
            },
            "index"
          ]
        },
        {
          "file": "/var/www/html/lib/private/Route/Router.php",
          "line": 302,
          "function": "main",
          "class": "OC\\AppFramework\\App",
          "type": "::",
          "args": [
            "OCA\\Settings\\Controller\\AdminSettingsController",
            "index",
            {
              "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
            },
            {
              "section": "serverinfo",
              "_route": "settings.adminsettings.index"
            }
          ]
        },
        {
          "file": "/var/www/html/lib/base.php",
          "line": 1003,
          "function": "match",
          "class": "OC\\Route\\Router",
          "type": "->",
          "args": [
            "/settings/admin/serverinfo"
          ]
        },
        {
          "file": "/var/www/html/index.php",
          "line": 24,
          "function": "handleRequest",
          "class": "OC",
          "type": "::",
          "args": []
        }
      ],
      "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
      "Line": 101,
      "Previous": {
        "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
        "Message": "SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'zincloud'",
        "Code": 1049,
        "Trace": [
          {
            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
            "line": 76,
            "function": "new",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
            "type": "::",
            "args": [
              {
                "__class__": "PDOException",
                "errorInfo": [
                  "42000",
                  1049,
                  "Unknown database 'zincloud'"
                ]
              }
            ]
          },
          {
            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1101,
            "function": "query",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
            "type": "->",
            "args": [
              "SHOW TABLE STATUS FROM `zincloud`"
            ]
          },
          {
            "file": "/var/www/html/lib/private/DB/Connection.php",
            "line": 415,
            "function": "executeQuery",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "args": [
              "SHOW TABLE STATUS FROM `zincloud`",
              [],
              [],
              null
            ]
          },
          {
            "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
            "line": 50,
            "function": "executeQuery",
            "class": "OC\\DB\\Connection",
            "type": "->",
            "args": [
              "SHOW TABLE STATUS FROM `zincloud`",
              [],
              []
            ]
          },
          {
            "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
            "line": 79,
            "function": "executeQuery",
            "class": "OC\\DB\\ConnectionAdapter",
            "type": "->",
            "args": [
              "SHOW TABLE STATUS FROM `zincloud`"
            ]
          },
          {
            "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
            "line": 33,
            "function": "databaseSize",
            "class": "OCA\\ServerInfo\\DatabaseStatistics",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/serverinfo/lib/Settings/AdminSettings.php",
            "line": 73,
            "function": "getDatabaseStatistics",
            "class": "OCA\\ServerInfo\\DatabaseStatistics",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
            "line": 117,
            "function": "getForm",
            "class": "OCA\\ServerInfo\\Settings\\AdminSettings",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
            "line": 74,
            "function": "formatSettings",
            "class": "OCA\\Settings\\Controller\\AdminSettingsController",
            "type": "->",
            "args": [
              [
                [
                  {
                    "__class__": "OCA\\ServerInfo\\Settings\\AdminSettings"
                  }
                ]
              ]
            ]
          },
          {
            "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
            "line": 142,
            "function": "getSettings",
            "class": "OCA\\Settings\\Controller\\AdminSettingsController",
            "type": "->",
            "args": [
              "serverinfo"
            ]
          },
          {
            "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
            "line": 58,
            "function": "getIndexResponse",
            "class": "OCA\\Settings\\Controller\\AdminSettingsController",
            "type": "->",
            "args": [
              "admin",
              "serverinfo"
            ]
          },
          {
            "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
            "line": 208,
            "function": "index",
            "class": "OCA\\Settings\\Controller\\AdminSettingsController",
            "type": "->",
            "args": [
              "serverinfo"
            ]
          },
          {
            "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
            "line": 114,
            "function": "executeController",
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "type": "->",
            "args": [
              {
                "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
              },
              "index"
            ]
          },
          {
            "file": "/var/www/html/lib/private/AppFramework/App.php",
            "line": 161,
            "function": "dispatch",
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "type": "->",
            "args": [
              {
                "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
              },
              "index"
            ]
          },
          {
            "file": "/var/www/html/lib/private/Route/Router.php",
            "line": 302,
            "function": "main",
            "class": "OC\\AppFramework\\App",
            "type": "::",
            "args": [
              "OCA\\Settings\\Controller\\AdminSettingsController",
              "index",
              {
                "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
              },
              {
                "section": "serverinfo",
                "_route": "settings.adminsettings.index"
              }
            ]
          },
          {
            "file": "/var/www/html/lib/base.php",
            "line": 1003,
            "function": "match",
            "class": "OC\\Route\\Router",
            "type": "->",
            "args": [
              "/settings/admin/serverinfo"
            ]
          },
          {
            "file": "/var/www/html/index.php",
            "line": 24,
            "function": "handleRequest",
            "class": "OC",
            "type": "::",
            "args": []
          }
        ],
        "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
        "Line": 28,
        "Previous": {
          "Exception": "PDOException",
          "Message": "SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'zincloud'",
          "Code": "42000",
          "Trace": [
            {
              "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
              "line": 71,
              "function": "query",
              "class": "PDO",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `zincloud`"
              ]
            },
            {
              "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1101,
              "function": "query",
              "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `zincloud`"
              ]
            },
            {
              "file": "/var/www/html/lib/private/DB/Connection.php",
              "line": 415,
              "function": "executeQuery",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `zincloud`",
                [],
                [],
                null
              ]
            },
            {
              "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
              "line": 50,
              "function": "executeQuery",
              "class": "OC\\DB\\Connection",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `zincloud`",
                [],
                []
              ]
            },
            {
              "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
              "line": 79,
              "function": "executeQuery",
              "class": "OC\\DB\\ConnectionAdapter",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `zincloud`"
              ]
            },
            {
              "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
              "line": 33,
              "function": "databaseSize",
              "class": "OCA\\ServerInfo\\DatabaseStatistics",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/html/apps/serverinfo/lib/Settings/AdminSettings.php",
              "line": 73,
              "function": "getDatabaseStatistics",
              "class": "OCA\\ServerInfo\\DatabaseStatistics",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
              "line": 117,
              "function": "getForm",
              "class": "OCA\\ServerInfo\\Settings\\AdminSettings",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
              "line": 74,
              "function": "formatSettings",
              "class": "OCA\\Settings\\Controller\\AdminSettingsController",
              "type": "->",
              "args": [
                [
                  [
                    {
                      "__class__": "OCA\\ServerInfo\\Settings\\AdminSettings"
                    }
                  ]
                ]
              ]
            },
            {
              "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
              "line": 142,
              "function": "getSettings",
              "class": "OCA\\Settings\\Controller\\AdminSettingsController",
              "type": "->",
              "args": [
                "serverinfo"
              ]
            },
            {
              "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
              "line": 58,
              "function": "getIndexResponse",
              "class": "OCA\\Settings\\Controller\\AdminSettingsController",
              "type": "->",
              "args": [
                "admin",
                "serverinfo"
              ]
            },
            {
              "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
              "line": 208,
              "function": "index",
              "class": "OCA\\Settings\\Controller\\AdminSettingsController",
              "type": "->",
              "args": [
                "serverinfo"
              ]
            },
            {
              "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
              "line": 114,
              "function": "executeController",
              "class": "OC\\AppFramework\\Http\\Dispatcher",
              "type": "->",
              "args": [
                {
                  "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
                },
                "index"
              ]
            },
            {
              "file": "/var/www/html/lib/private/AppFramework/App.php",
              "line": 161,
              "function": "dispatch",
              "class": "OC\\AppFramework\\Http\\Dispatcher",
              "type": "->",
              "args": [
                {
                  "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
                },
                "index"
              ]
            },
            {
              "file": "/var/www/html/lib/private/Route/Router.php",
              "line": 302,
              "function": "main",
              "class": "OC\\AppFramework\\App",
              "type": "::",
              "args": [
                "OCA\\Settings\\Controller\\AdminSettingsController",
                "index",
                {
                  "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
                },
                {
                  "section": "serverinfo",
                  "_route": "settings.adminsettings.index"
                }
              ]
            },
            {
              "file": "/var/www/html/lib/base.php",
              "line": 1003,
              "function": "match",
              "class": "OC\\Route\\Router",
              "type": "->",
              "args": [
                "/settings/admin/serverinfo"
              ]
            },
            {
              "file": "/var/www/html/index.php",
              "line": 24,
              "function": "handleRequest",
              "class": "OC",
              "type": "::",
              "args": []
            }
          ],
          "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
          "Line": 71
        }
      }
    },
    "message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'zincloud'",
    "exception": [],
    "CustomMessage": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'zincloud'"
  },
  "id": "6783f8b943e4a"
}

and here is my docker compose

services:
  nextcloud:
    container_name: mysiteNextcloud
    image: nextcloud:latest
    restart: always
    volumes:
      - /home/vaneck/macloud/nextcloud:/var/www/html:z
      - /home/vaneck/macloud/apps:/var/www/html/custom_apps:z
      - /home/vaneck/macloud/config:/var/www/html/config:z
      - /mnt/data/nextcloud:/var/www/html/data:z

      # NOTE: The `volumes` config of the `cron` and `app` containers must match
    environment:
      - VIRTUAL_HOST=mysite.fr
      - LETSENCRYPT_HOST=mysite.fr
      - MYSQL_HOST=NextcloudMariadb
      - REDIS_HOST=redis
      - MYSQL_PASSWORD=password
      - MYSQL_DATABASE=nextcloud
      - MYSQL_USER=nextcloud
    networks:
      - nextCloud
      - bridgeHttps

  cron:
    container_name: mysiteCron
    image: nextcloud:latest
    restart: always
    volumes:
      - /home/vaneck/macloud/nextcloud:/var/www/html:z
      - /home/vaneck/macloud/apps:/var/www/html/custom_apps:z
      - /home/vaneck/macloud/config:/var/www/html/config:z
      - /mnt/data/nextcloud:/var/www/html/data:z
    entrypoint: /cron.sh
    networks:
      - nextCloud

networks:
  nextCloud:
    external: true
  bridgeHttps:
    external: true
7

Your configuration (Compose) suggests your Nextcloud database is called nextcloud and located on the host NextcloudMariadb.

The error references a database called zincloud:

1049 Unknown database 'zincloud'

If you run occ config:list system --private | grep db, what are the values of dbhost and dbname?

I would expect the following based on your Compose file:

  "dbhost": "NextcloudMariadb"
  "dbname": "nextcloud"

But your log output implies this:

  "dbhost": "???"
  "dbname": "zincloud"

Where is your NextcloudMariadb contained defined in your stack? And where is redis container defined your stack? I don’t see either in your Compose file.

Are you sure you aren’t looking at two different Nextcloud instances or something?

8

in fact, sorry, I do have two nextclouds installed, I showed the wrong one, although both have the same problem (I have two accounts on the same database).

good setting system 
{
  "reqId": "UIYEDeia2xLoq0DobRvo",
  "level": 3,
  "time": "2025-01-13T01:43:37+00:00",
  "remoteAddr": "37.171.232.174",
  "user": "vaneck",
  "app": "index",
  "method": "GET",
  "url": "/settings/admin/serverinfo",
  "message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'nextcloud'",
  "userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0",
  "version": "30.0.4.1",
  "exception": {
    "Exception": "OC\\DB\\Exceptions\\DbalException",
    "Message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'nextcloud'",
    "Code": 1049,
    "Trace": [
      {
        "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
        "line": 53,
        "function": "wrap",
        "class": "OC\\DB\\Exceptions\\DbalException",
        "type": "::",
        "args": [
          {
            "__class__": "Doctrine\\DBAL\\Exception\\ConnectionException"
          }
        ]
      },
      {
        "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
        "line": 79,
        "function": "executeQuery",
        "class": "OC\\DB\\ConnectionAdapter",
        "type": "->",
        "args": [
          "SHOW TABLE STATUS FROM `nextcloud`"
        ]
      },
      {
        "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
        "line": 33,
        "function": "databaseSize",
        "class": "OCA\\ServerInfo\\DatabaseStatistics",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/serverinfo/lib/Settings/AdminSettings.php",
        "line": 73,
        "function": "getDatabaseStatistics",
        "class": "OCA\\ServerInfo\\DatabaseStatistics",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
        "line": 117,
        "function": "getForm",
        "class": "OCA\\ServerInfo\\Settings\\AdminSettings",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
        "line": 74,
        "function": "formatSettings",
        "class": "OCA\\Settings\\Controller\\AdminSettingsController",
        "type": "->",
        "args": [
          [
            [
              {
                "__class__": "OCA\\ServerInfo\\Settings\\AdminSettings"
              }
            ]
          ]
        ]
      },
      {
        "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
        "line": 142,
        "function": "getSettings",
        "class": "OCA\\Settings\\Controller\\AdminSettingsController",
        "type": "->",
        "args": [
          "serverinfo"
        ]
      },
      {
        "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
        "line": 58,
        "function": "getIndexResponse",
        "class": "OCA\\Settings\\Controller\\AdminSettingsController",
        "type": "->",
        "args": [
          "admin",
          "serverinfo"
        ]
      },
      {
        "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 208,
        "function": "index",
        "class": "OCA\\Settings\\Controller\\AdminSettingsController",
        "type": "->",
        "args": [
          "serverinfo"
        ]
      },
      {
        "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 114,
        "function": "executeController",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->",
        "args": [
          {
            "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
          },
          "index"
        ]
      },
      {
        "file": "/var/www/html/lib/private/AppFramework/App.php",
        "line": 161,
        "function": "dispatch",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->",
        "args": [
          {
            "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
          },
          "index"
        ]
      },
      {
        "file": "/var/www/html/lib/private/Route/Router.php",
        "line": 302,
        "function": "main",
        "class": "OC\\AppFramework\\App",
        "type": "::",
        "args": [
          "OCA\\Settings\\Controller\\AdminSettingsController",
          "index",
          {
            "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
          },
          {
            "section": "serverinfo",
            "_route": "settings.adminsettings.index"
          }
        ]
      },
      {
        "file": "/var/www/html/lib/base.php",
        "line": 1003,
        "function": "match",
        "class": "OC\\Route\\Router",
        "type": "->",
        "args": [
          "/settings/admin/serverinfo"
        ]
      },
      {
        "file": "/var/www/html/index.php",
        "line": 24,
        "function": "handleRequest",
        "class": "OC",
        "type": "::",
        "args": []
      }
    ],
    "File": "/var/www/html/lib/private/DB/Exceptions/DbalException.php",
    "Line": 54,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Exception\\ConnectionException",
      "Message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'nextcloud'",
      "Code": 1049,
      "Trace": [
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1939,
          "function": "convert",
          "class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
          "type": "->",
          "args": [
            {
              "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            },
            {
              "__class__": "Doctrine\\DBAL\\Query"
            }
          ]
        },
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1881,
          "function": "handleDriverException",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            {
              "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            },
            {
              "__class__": "Doctrine\\DBAL\\Query"
            }
          ]
        },
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1106,
          "function": "convertExceptionDuringQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            {
              "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            },
            "SHOW TABLE STATUS FROM `nextcloud`",
            [],
            []
          ]
        },
        {
          "file": "/var/www/html/lib/private/DB/Connection.php",
          "line": 415,
          "function": "executeQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            "SHOW TABLE STATUS FROM `nextcloud`",
            [],
            [],
            null
          ]
        },
        {
          "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
          "line": 50,
          "function": "executeQuery",
          "class": "OC\\DB\\Connection",
          "type": "->",
          "args": [
            "SHOW TABLE STATUS FROM `nextcloud`",
            [],
            []
          ]
        },
        {
          "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
          "line": 79,
          "function": "executeQuery",
          "class": "OC\\DB\\ConnectionAdapter",
          "type": "->",
          "args": [
            "SHOW TABLE STATUS FROM `nextcloud`"
          ]
        },
        {
          "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
          "line": 33,
          "function": "databaseSize",
          "class": "OCA\\ServerInfo\\DatabaseStatistics",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/serverinfo/lib/Settings/AdminSettings.php",
          "line": 73,
          "function": "getDatabaseStatistics",
          "class": "OCA\\ServerInfo\\DatabaseStatistics",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
          "line": 117,
          "function": "getForm",
          "class": "OCA\\ServerInfo\\Settings\\AdminSettings",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
          "line": 74,
          "function": "formatSettings",
          "class": "OCA\\Settings\\Controller\\AdminSettingsController",
          "type": "->",
          "args": [
            [
              [
                {
                  "__class__": "OCA\\ServerInfo\\Settings\\AdminSettings"
                }
              ]
            ]
          ]
        },
        {
          "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
          "line": 142,
          "function": "getSettings",
          "class": "OCA\\Settings\\Controller\\AdminSettingsController",
          "type": "->",
          "args": [
            "serverinfo"
          ]
        },
        {
          "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
          "line": 58,
          "function": "getIndexResponse",
          "class": "OCA\\Settings\\Controller\\AdminSettingsController",
          "type": "->",
          "args": [
            "admin",
            "serverinfo"
          ]
        },
        {
          "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 208,
          "function": "index",
          "class": "OCA\\Settings\\Controller\\AdminSettingsController",
          "type": "->",
          "args": [
            "serverinfo"
          ]
        },
        {
          "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 114,
          "function": "executeController",
          "class": "OC\\AppFramework\\Http\\Dispatcher",
          "type": "->",
          "args": [
            {
              "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
            },
            "index"
          ]
        },
        {
          "file": "/var/www/html/lib/private/AppFramework/App.php",
          "line": 161,
          "function": "dispatch",
          "class": "OC\\AppFramework\\Http\\Dispatcher",
          "type": "->",
          "args": [
            {
              "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
            },
            "index"
          ]
        },
        {
          "file": "/var/www/html/lib/private/Route/Router.php",
          "line": 302,
          "function": "main",
          "class": "OC\\AppFramework\\App",
          "type": "::",
          "args": [
            "OCA\\Settings\\Controller\\AdminSettingsController",
            "index",
            {
              "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
            },
            {
              "section": "serverinfo",
              "_route": "settings.adminsettings.index"
            }
          ]
        },
        {
          "file": "/var/www/html/lib/base.php",
          "line": 1003,
          "function": "match",
          "class": "OC\\Route\\Router",
          "type": "->",
          "args": [
            "/settings/admin/serverinfo"
          ]
        },
        {
          "file": "/var/www/html/index.php",
          "line": 24,
          "function": "handleRequest",
          "class": "OC",
          "type": "::",
          "args": []
        }
      ],
      "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
      "Line": 101,
      "Previous": {
        "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
        "Message": "SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'nextcloud'",
        "Code": 1049,
        "Trace": [
          {
            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
            "line": 76,
            "function": "new",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
            "type": "::",
            "args": [
              {
                "__class__": "PDOException",
                "errorInfo": [
                  "42000",
                  1049,
                  "Unknown database 'nextcloud'"
                ]
              }
            ]
          },
          {
            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1101,
            "function": "query",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
            "type": "->",
            "args": [
              "SHOW TABLE STATUS FROM `nextcloud`"
            ]
          },
          {
            "file": "/var/www/html/lib/private/DB/Connection.php",
            "line": 415,
            "function": "executeQuery",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "args": [
              "SHOW TABLE STATUS FROM `nextcloud`",
              [],
              [],
              null
            ]
          },
          {
            "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
            "line": 50,
            "function": "executeQuery",
            "class": "OC\\DB\\Connection",
            "type": "->",
            "args": [
              "SHOW TABLE STATUS FROM `nextcloud`",
              [],
              []
            ]
          },
          {
            "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
            "line": 79,
            "function": "executeQuery",
            "class": "OC\\DB\\ConnectionAdapter",
            "type": "->",
            "args": [
              "SHOW TABLE STATUS FROM `nextcloud`"
            ]
          },
          {
            "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
            "line": 33,
            "function": "databaseSize",
            "class": "OCA\\ServerInfo\\DatabaseStatistics",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/serverinfo/lib/Settings/AdminSettings.php",
            "line": 73,
            "function": "getDatabaseStatistics",
            "class": "OCA\\ServerInfo\\DatabaseStatistics",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
            "line": 117,
            "function": "getForm",
            "class": "OCA\\ServerInfo\\Settings\\AdminSettings",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
            "line": 74,
            "function": "formatSettings",
            "class": "OCA\\Settings\\Controller\\AdminSettingsController",
            "type": "->",
            "args": [
              [
                [
                  {
                    "__class__": "OCA\\ServerInfo\\Settings\\AdminSettings"
                  }
                ]
              ]
            ]
          },
          {
            "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
            "line": 142,
            "function": "getSettings",
            "class": "OCA\\Settings\\Controller\\AdminSettingsController",
            "type": "->",
            "args": [
              "serverinfo"
            ]
          },
          {
            "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
            "line": 58,
            "function": "getIndexResponse",
            "class": "OCA\\Settings\\Controller\\AdminSettingsController",
            "type": "->",
            "args": [
              "admin",
              "serverinfo"
            ]
          },
          {
            "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
            "line": 208,
            "function": "index",
            "class": "OCA\\Settings\\Controller\\AdminSettingsController",
            "type": "->",
            "args": [
              "serverinfo"
            ]
          },
          {
            "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
            "line": 114,
            "function": "executeController",
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "type": "->",
            "args": [
              {
                "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
              },
              "index"
            ]
          },
          {
            "file": "/var/www/html/lib/private/AppFramework/App.php",
            "line": 161,
            "function": "dispatch",
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "type": "->",
            "args": [
              {
                "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
              },
              "index"
            ]
          },
          {
            "file": "/var/www/html/lib/private/Route/Router.php",
            "line": 302,
            "function": "main",
            "class": "OC\\AppFramework\\App",
            "type": "::",
            "args": [
              "OCA\\Settings\\Controller\\AdminSettingsController",
              "index",
              {
                "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
              },
              {
                "section": "serverinfo",
                "_route": "settings.adminsettings.index"
              }
            ]
          },
          {
            "file": "/var/www/html/lib/base.php",
            "line": 1003,
            "function": "match",
            "class": "OC\\Route\\Router",
            "type": "->",
            "args": [
              "/settings/admin/serverinfo"
            ]
          },
          {
            "file": "/var/www/html/index.php",
            "line": 24,
            "function": "handleRequest",
            "class": "OC",
            "type": "::",
            "args": []
          }
        ],
        "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
        "Line": 28,
        "Previous": {
          "Exception": "PDOException",
          "Message": "SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'nextcloud'",
          "Code": "42000",
          "Trace": [
            {
              "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
              "line": 71,
              "function": "query",
              "class": "PDO",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `nextcloud`"
              ]
            },
            {
              "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1101,
              "function": "query",
              "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `nextcloud`"
              ]
            },
            {
              "file": "/var/www/html/lib/private/DB/Connection.php",
              "line": 415,
              "function": "executeQuery",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `nextcloud`",
                [],
                [],
                null
              ]
            },
            {
              "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
              "line": 50,
              "function": "executeQuery",
              "class": "OC\\DB\\Connection",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `nextcloud`",
                [],
                []
              ]
            },
            {
              "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
              "line": 79,
              "function": "executeQuery",
              "class": "OC\\DB\\ConnectionAdapter",
              "type": "->",
              "args": [
                "SHOW TABLE STATUS FROM `nextcloud`"
              ]
            },
            {
              "file": "/var/www/html/apps/serverinfo/lib/DatabaseStatistics.php",
              "line": 33,
              "function": "databaseSize",
              "class": "OCA\\ServerInfo\\DatabaseStatistics",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/html/apps/serverinfo/lib/Settings/AdminSettings.php",
              "line": 73,
              "function": "getDatabaseStatistics",
              "class": "OCA\\ServerInfo\\DatabaseStatistics",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
              "line": 117,
              "function": "getForm",
              "class": "OCA\\ServerInfo\\Settings\\AdminSettings",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
              "line": 74,
              "function": "formatSettings",
              "class": "OCA\\Settings\\Controller\\AdminSettingsController",
              "type": "->",
              "args": [
                [
                  [
                    {
                      "__class__": "OCA\\ServerInfo\\Settings\\AdminSettings"
                    }
                  ]
                ]
              ]
            },
            {
              "file": "/var/www/html/apps/settings/lib/Controller/CommonSettingsTrait.php",
              "line": 142,
              "function": "getSettings",
              "class": "OCA\\Settings\\Controller\\AdminSettingsController",
              "type": "->",
              "args": [
                "serverinfo"
              ]
            },
            {
              "file": "/var/www/html/apps/settings/lib/Controller/AdminSettingsController.php",
              "line": 58,
              "function": "getIndexResponse",
              "class": "OCA\\Settings\\Controller\\AdminSettingsController",
              "type": "->",
              "args": [
                "admin",
                "serverinfo"
              ]
            },
            {
              "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
              "line": 208,
              "function": "index",
              "class": "OCA\\Settings\\Controller\\AdminSettingsController",
              "type": "->",
              "args": [
                "serverinfo"
              ]
            },
            {
              "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
              "line": 114,
              "function": "executeController",
              "class": "OC\\AppFramework\\Http\\Dispatcher",
              "type": "->",
              "args": [
                {
                  "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
                },
                "index"
              ]
            },
            {
              "file": "/var/www/html/lib/private/AppFramework/App.php",
              "line": 161,
              "function": "dispatch",
              "class": "OC\\AppFramework\\Http\\Dispatcher",
              "type": "->",
              "args": [
                {
                  "__class__": "OCA\\Settings\\Controller\\AdminSettingsController"
                },
                "index"
              ]
            },
            {
              "file": "/var/www/html/lib/private/Route/Router.php",
              "line": 302,
              "function": "main",
              "class": "OC\\AppFramework\\App",
              "type": "::",
              "args": [
                "OCA\\Settings\\Controller\\AdminSettingsController",
                "index",
                {
                  "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
                },
                {
                  "section": "serverinfo",
                  "_route": "settings.adminsettings.index"
                }
              ]
            },
            {
              "file": "/var/www/html/lib/base.php",
              "line": 1003,
              "function": "match",
              "class": "OC\\Route\\Router",
              "type": "->",
              "args": [
                "/settings/admin/serverinfo"
              ]
            },
            {
              "file": "/var/www/html/index.php",
              "line": 24,
              "function": "handleRequest",
              "class": "OC",
              "type": "::",
              "args": []
            }
          ],
          "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
          "Line": 71
        }
      }
    },
    "message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'nextcloud'",
    "exception": [],
    "CustomMessage": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'nextcloud'"
  },
  "id": "67846fcfbf5c7"
}

I have lost the docker-compose of mariadb and redis, but from memory I was inspired by this tutorial
And this is my config

config 
<?php
$CONFIG = array (
  'loglevel' => 3,
  'htaccess.RewriteBase' => '/',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'apps_paths' => 
  array (
    0 => 
    array (
      'path' => '/var/www/html/apps',
      'url' => '/apps',
      'writable' => false,
    ),
    1 => 
    array (
      'path' => '/var/www/html/custom_apps',
      'url' => '/custom_apps',
      'writable' => true,
    ),
  ),
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => 'redis',
    'password' => '',
    'port' => 6379,
  ),
  'upgrade.disable-web' => true,
  'instanceid' => 'ocih2nesmk8t',
  'passwordsalt' => 'somehash',
  'secret' => 'mystere',
  'trusted_domains' => 
  array (
    0 => 'website.fr',
  ),
  'datadirectory' => '/var/www/html/data',
  'dbtype' => 'mysql',
  'version' => '30.0.4.1',
  'overwrite.cli.url' => 'http://website.fr',
  'overwriteprotocol' => 'https',
  'dbname' => 'nextcloud',
  'dbhost' => 'NextcloudMariadb',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => 'password',
  'installed' => true,
  'forwarded-for-headers' => 
  array (
    0 => 'HTTP_X_FORWARDED_FOR',
  ),
  'maintenance_window_start' => 4,
  'default_phone_region' => 'optional',
  'maintenance' => false,
  'trusted_proxies' => 
  array (
    0 => '172.20.0.11',
  ),
  'opcache.memory_consumption' => '256',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_from_address' => 'vaneck',
  'mail_domain' => 'website.fr',
  'mail_smtpport' => '465',
  'mail_smtpauth' => 1,
  'mail_smtpname' => 'vaneck@website.fr',
  'mail_smtppassword' => 'password',
  'mail_smtpsecure' => 'ssl',
  'mail_smtphost' => 'mail.llony.me',
  'app_install_overwrite' => 
  array (
    0 => 'maps',
  ),
);
9

Finally, I restarted the mariadb container, and everything planted. So I guess the whole database was stored in the ram.

services:
  nextcloud:
    container_name: Nextcloud
    image: nextcloud:latest
    restart: always
    volumes:
      - /home/vaneck/macloud/apps:/var/www/html/custom_apps:z
      - /home/vaneck/macloud/newConfig:/var/www/html/config:z
      - /mnt/data/nextcloud:/var/www/html/data:z

Now, I’m trying to relaunch a docker compose, but I can’t do it. In fact, I can’t manage to use the var/www/html/data folder again to automatically recreate all the new users.

10

This is not gona happen.

Install a new container, configure your system (users, etc), import your /var/www/html/data volume and run occ files:scan --all.

Also, this time, configure regular backups too.

11

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.