I wanted to enable 4-byte character support for Nextcloud, because I got a warning about it. In this topic, this website was recommended. And I tried to follow the steps.
The problem is with the final step. When I run:
$ docker exec --user www-data nextcloud php occ maintenance:repair
I get an error:
unable to find user www-data: no matching entries in passwd file
What could be the problem?
This are my specs. I run the latest Nextcloud (17.01) Docker.
I run Nextcloud on OMV on a RockPro64 (4GB RAM).
OMV version 4.1.27-1 (Arrakis)
Kernel: Linux 4.4.190-1233-rockchip-ayufan
Processor: ARMv8 Processor rev 2 (v8l)
These are the steps I followed:
(I am running as root, so the $'s should be #'s).
$ docker exec -it nextclouddb bash
retrieving the mysql version
# mysql -V
mysql Ver 15.1 Distrib 10.1.43-MariaDB, for debian-linux-gnueabihf (armv7l) using readline 5.2
I had to install nano inside the container
$ apt update
$ apt upgrade
$ apt install nano
$ nano /etc/mysql/mariadb.conf.d/50-server.cnf
i added the following lines beneath [mysqld]
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=1
This command gave an error:
$ service mysqld restart
mysqld: unrecognized service
So I just restarted the docker and went ‘in’ it again.
mysql -u root -p
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| nextcloud |
| performance_schema |
+--------------------+
MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
+---------------------------------------+-------+-------------+
| NAME | SPACE | FILE_FORMAT |
+---------------------------------------+-------+-------------+
| nextcloud/oc_accounts | 33 | Antelope |
| nextcloud/oc_activity | 74 | Antelope |
| nextcloud/oc_activity_mq | 76 | Antelope |
| nextcloud/oc_addressbookchanges | 90 | Antelope |
| nextcloud/oc_addressbooks | 79 | Antelope |
| nextcloud/oc_appconfig | 7 | Antelope |
| nextcloud/oc_authtoken | 56 | Antelope |
| nextcloud/oc_bruteforce_attempts | 36 | Antelope |
| nextcloud/oc_calendar_invitations | 98 | Antelope |
| nextcloud/oc_calendar_reminders | 111 | Antelope |
| nextcloud/oc_calendar_resources | 96 | Antelope |
| nextcloud/oc_calendar_resources_md | 108 | Antelope |
| nextcloud/oc_calendar_rooms | 97 | Antelope |
| nextcloud/oc_calendar_rooms_md | 109 | Antelope |
| nextcloud/oc_calendarchanges | 99 | Antelope |
| nextcloud/oc_calendarobjects | 100 | Antelope |
| nextcloud/oc_calendarobjects_props | 101 | Antelope |
| nextcloud/oc_calendars | 83 | Antelope |
| nextcloud/oc_calendarsubscriptions | 107 | Antelope |
| nextcloud/oc_cards | 103 | Antelope |
| nextcloud/oc_cards_properties | 87 | Antelope |
| nextcloud/oc_collres_accesscache | 64 | Antelope |
| nextcloud/oc_collres_collections | 59 | Antelope |
| nextcloud/oc_collres_resources | 60 | Antelope |
| nextcloud/oc_comments | 37 | Antelope |
| nextcloud/oc_comments_read_markers | 29 | Antelope |
| nextcloud/oc_credentials | 30 | Antelope |
| nextcloud/oc_dav_cal_proxy | 110 | Antelope |
| nextcloud/oc_dav_shares | 94 | Antelope |
| nextcloud/oc_directlink | 95 | Antelope |
| nextcloud/oc_external_applicable | 121 | Antelope |
| nextcloud/oc_external_config | 122 | Antelope |
| nextcloud/oc_external_mounts | 120 | Antelope |
| nextcloud/oc_external_options | 123 | Antelope |
| nextcloud/oc_federated_reshares | 66 | Antelope |
| nextcloud/oc_file_locks | 38 | Antelope |
| nextcloud/oc_filecache | 11 | Antelope |
| nextcloud/oc_filecache_extended | 65 | Antelope |
| nextcloud/oc_files_trash | 112 | Antelope |
| nextcloud/oc_flow_checks | 67 | Antelope |
| nextcloud/oc_flow_operations | 68 | Antelope |
| nextcloud/oc_group_admin | 13 | Antelope |
| nextcloud/oc_group_user | 12 | Antelope |
| nextcloud/oc_groups | 14 | Antelope |
| nextcloud/oc_jobs | 39 | Antelope |
| nextcloud/oc_login_flow_v2 | 62 | Antelope |
| nextcloud/oc_migrations | 4 | Antelope |
| nextcloud/oc_mimetypes | 10 | Antelope |
| nextcloud/oc_mounts | 40 | Antelope |
| nextcloud/oc_notifications | 118 | Antelope |
| nextcloud/oc_notifications_pushtokens | 119 | Antelope |
| nextcloud/oc_oauth2_access_tokens | 78 | Antelope |
| nextcloud/oc_oauth2_clients | 77 | Antelope |
| nextcloud/oc_preferences | 15 | Antelope |
| nextcloud/oc_privacy_admins | 113 | Antelope |
| nextcloud/oc_properties | 42 | Antelope |
| nextcloud/oc_schedulingobjects | 86 | Antelope |
| nextcloud/oc_share | 58 | Antelope |
| nextcloud/oc_share_external | 114 | Antelope |
| nextcloud/oc_storages | 8 | Antelope |
| nextcloud/oc_systemtag | 44 | Antelope |
| nextcloud/oc_systemtag_group | 45 | Antelope |
| nextcloud/oc_systemtag_object_mapping | 46 | Antelope |
| nextcloud/oc_text_documents | 115 | Antelope |
| nextcloud/oc_text_sessions | 116 | Antelope |
| nextcloud/oc_text_steps | 117 | Antelope |
| nextcloud/oc_trusted_servers | 69 | Antelope |
| nextcloud/oc_twofactor_backupcodes | 73 | Antelope |
| nextcloud/oc_twofactor_providers | 52 | Antelope |
| nextcloud/oc_users | 49 | Antelope |
| nextcloud/oc_vcategory | 47 | Antelope |
| nextcloud/oc_vcategory_to_object | 48 | Antelope |
| nextcloud/oc_whats_new | 53 | Antelope |
+---------------------------------------+-------+-------------+
MariaDB [(none)]> USE INFORMATION_SCHEMA;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [INFORMATION_SCHEMA]> SELECT CONCAT("ALTER TABLE ", TABLE_SCHEMA,".", TABLE_NAME, " ROW_FORMAT=DYNAMIC;") AS MySQLCMD FROM TABLES WHERE TABLE_SCHEMA = "nextcloud";
+-----------------------------------------------------------------------+
| MySQLCMD |
+-----------------------------------------------------------------------+
| ALTER TABLE nextcloud.oc_accounts ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_activity ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_activity_mq ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_addressbookchanges ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_addressbooks ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_appconfig ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_authtoken ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_bruteforce_attempts ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendar_invitations ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendar_reminders ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendar_resources ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendar_resources_md ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendar_rooms ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendar_rooms_md ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendarchanges ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendarobjects ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendarobjects_props ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendars ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_calendarsubscriptions ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_cards ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_cards_properties ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_collres_accesscache ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_collres_collections ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_collres_resources ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_comments ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_comments_read_markers ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_credentials ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_dav_cal_proxy ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_dav_shares ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_directlink ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_external_applicable ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_external_config ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_external_mounts ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_external_options ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_federated_reshares ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_file_locks ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_filecache ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_filecache_extended ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_files_trash ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_flow_checks ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_flow_operations ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_group_admin ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_group_user ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_groups ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_jobs ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_login_flow_v2 ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_migrations ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_mimetypes ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_mounts ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_notifications ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_notifications_pushtokens ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_oauth2_access_tokens ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_oauth2_clients ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_preferences ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_privacy_admins ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_properties ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_schedulingobjects ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_share ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_share_external ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_storages ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_systemtag ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_systemtag_group ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_systemtag_object_mapping ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_text_documents ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_text_sessions ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_text_steps ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_trusted_servers ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_twofactor_backupcodes ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_twofactor_providers ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_users ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_vcategory ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_vcategory_to_object ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud.oc_whats_new ROW_FORMAT=DYNAMIC; |
+-----------------------------------------------------------------------+
**73 rows in set (0.03 sec)**
I copied the output to a text editor and edited it to this:
ALTER TABLE nextcloud.oc_accounts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_activity ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_activity_mq ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_addressbookchanges ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_addressbooks ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_appconfig ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_authtoken ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_bruteforce_attempts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendar_invitations ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendar_reminders ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendar_resources ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendar_resources_md ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendar_rooms ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendar_rooms_md ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendarchanges ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendarobjects ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendarobjects_props ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendars ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_calendarsubscriptions ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_cards ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_cards_properties ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_collres_accesscache ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_collres_collections ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_collres_resources ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_comments ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_comments_read_markers ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_credentials ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_dav_cal_proxy ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_dav_shares ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_directlink ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_external_applicable ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_external_config ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_external_mounts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_external_options ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_federated_reshares ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_file_locks ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_filecache ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_filecache_extended ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_files_trash ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_flow_checks ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_flow_operations ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_group_admin ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_group_user ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_groups ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_jobs ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_login_flow_v2 ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_migrations ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_mimetypes ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_mounts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_notifications ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_notifications_pushtokens ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_oauth2_access_tokens ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_oauth2_clients ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_preferences ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_privacy_admins ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_properties ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_schedulingobjects ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_share ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_share_external ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_storages ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_systemtag ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_systemtag_group ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_systemtag_object_mapping ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_text_documents ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_text_sessions ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_text_steps ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_trusted_servers ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_twofactor_backupcodes ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_twofactor_providers ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_users ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_vcategory ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_vcategory_to_object ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud.oc_whats_new ROW_FORMAT=DYNAMIC;
This is what happened, one error occures with this one:
MariaDB [INFORMATION_SCHEMA]> ALTER TABLE nextcloud.oc_file_locks ROW_FORMAT=DYNAMIC;
ERROR 1062 (23000): Duplicate entry 'files/[long random string]' for key 'lock_key_index'
MariaDB [INFORMATION_SCHEMA]> ALTER TABLE nextcloud.oc_filecache ROW_FORMAT=DYNAMIC;
**Query OK, 0 rows affected (17.15 sec) **
**Records: 0 Duplicates: 0 Warnings: 0**
All the others followed this pattern:
MariaDB [INFORMATION_SCHEMA]> ALTER TABLE nextcloud.oc_accounts ROW_FORMAT=DYNAMIC;
**Query OK, 0 rows affected (0.76 sec)**
**Records: 0 Duplicates: 0 Warnings: 0**
You can see that there is a problem with the ‘nextcloud/oc_file_locks’ one. That one is still ‘Antelope’.
MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
+---------------------------------------+-------+-------------+
| NAME | SPACE | FILE_FORMAT |
+---------------------------------------+-------+-------------+
| nextcloud/oc_accounts | 124 | Barracuda |
| nextcloud/oc_activity | 125 | Barracuda |
| nextcloud/oc_activity_mq | 126 | Barracuda |
| nextcloud/oc_addressbookchanges | 127 | Barracuda |
| nextcloud/oc_addressbooks | 128 | Barracuda |
| nextcloud/oc_appconfig | 129 | Barracuda |
| nextcloud/oc_authtoken | 130 | Barracuda |
| nextcloud/oc_bruteforce_attempts | 131 | Barracuda |
| nextcloud/oc_calendar_invitations | 132 | Barracuda |
| nextcloud/oc_calendar_reminders | 133 | Barracuda |
| nextcloud/oc_calendar_resources | 134 | Barracuda |
| nextcloud/oc_calendar_resources_md | 135 | Barracuda |
| nextcloud/oc_calendar_rooms | 136 | Barracuda |
| nextcloud/oc_calendar_rooms_md | 137 | Barracuda |
| nextcloud/oc_calendarchanges | 138 | Barracuda |
| nextcloud/oc_calendarobjects | 139 | Barracuda |
| nextcloud/oc_calendarobjects_props | 140 | Barracuda |
| nextcloud/oc_calendars | 141 | Barracuda |
| nextcloud/oc_calendarsubscriptions | 142 | Barracuda |
| nextcloud/oc_cards | 143 | Barracuda |
| nextcloud/oc_cards_properties | 144 | Barracuda |
| nextcloud/oc_collres_accesscache | 145 | Barracuda |
| nextcloud/oc_collres_collections | 146 | Barracuda |
| nextcloud/oc_collres_resources | 147 | Barracuda |
| nextcloud/oc_comments | 148 | Barracuda |
| nextcloud/oc_comments_read_markers | 149 | Barracuda |
| nextcloud/oc_credentials | 150 | Barracuda |
| nextcloud/oc_dav_cal_proxy | 151 | Barracuda |
| nextcloud/oc_dav_shares | 152 | Barracuda |
| nextcloud/oc_directlink | 153 | Barracuda |
| nextcloud/oc_external_applicable | 154 | Barracuda |
| nextcloud/oc_external_config | 155 | Barracuda |
| nextcloud/oc_external_mounts | 156 | Barracuda |
| nextcloud/oc_external_options | 157 | Barracuda |
| nextcloud/oc_federated_reshares | 158 | Barracuda |
| nextcloud/oc_file_locks | 38 | Antelope |
| nextcloud/oc_filecache | 160 | Barracuda |
| nextcloud/oc_filecache_extended | 161 | Barracuda |
| nextcloud/oc_files_trash | 162 | Barracuda |
| nextcloud/oc_flow_checks | 163 | Barracuda |
| nextcloud/oc_flow_operations | 164 | Barracuda |
| nextcloud/oc_group_admin | 165 | Barracuda |
| nextcloud/oc_group_user | 166 | Barracuda |
| nextcloud/oc_groups | 167 | Barracuda |
| nextcloud/oc_jobs | 168 | Barracuda |
| nextcloud/oc_login_flow_v2 | 169 | Barracuda |
| nextcloud/oc_migrations | 170 | Barracuda |
| nextcloud/oc_mimetypes | 171 | Barracuda |
| nextcloud/oc_mounts | 172 | Barracuda |
| nextcloud/oc_notifications | 173 | Barracuda |
| nextcloud/oc_notifications_pushtokens | 174 | Barracuda |
| nextcloud/oc_oauth2_access_tokens | 175 | Barracuda |
| nextcloud/oc_oauth2_clients | 176 | Barracuda |
| nextcloud/oc_preferences | 177 | Barracuda |
| nextcloud/oc_privacy_admins | 178 | Barracuda |
| nextcloud/oc_properties | 179 | Barracuda |
| nextcloud/oc_schedulingobjects | 180 | Barracuda |
| nextcloud/oc_share | 181 | Barracuda |
| nextcloud/oc_share_external | 182 | Barracuda |
| nextcloud/oc_storages | 183 | Barracuda |
| nextcloud/oc_systemtag | 184 | Barracuda |
| nextcloud/oc_systemtag_group | 185 | Barracuda |
| nextcloud/oc_systemtag_object_mapping | 186 | Barracuda |
| nextcloud/oc_text_documents | 187 | Barracuda |
| nextcloud/oc_text_sessions | 188 | Barracuda |
| nextcloud/oc_text_steps | 189 | Barracuda |
| nextcloud/oc_trusted_servers | 190 | Barracuda |
| nextcloud/oc_twofactor_backupcodes | 191 | Barracuda |
| nextcloud/oc_twofactor_providers | 192 | Barracuda |
| nextcloud/oc_users | 193 | Barracuda |
| nextcloud/oc_vcategory | 194 | Barracuda |
| nextcloud/oc_vcategory_to_object | 195 | Barracuda |
| nextcloud/oc_whats_new | 196 | Barracuda |
+---------------------------------------+-------+-------------+
73 rows in set (0.00 sec)
Then I ran this:
MariaDB [(none)]> ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
Query OK, 1 row affected (0.00 sec)
Then I exited the container and ran
$ nano /sharedfolders/AppData/Nextcloud/www/nextcloud/config/config.php
I added this line at the end of the array:
'mysql.utf8mb4' => true,
Almost there! But then, as said, the repair command failed.
So there seem to be two issues.
One issue with the oc_file_locks table not converting.
And another issue with the repair command not running.
Any ideas? Hope someone can help or tell me where I can find it.
All the best,