Nextcloud 15 - Configurer le support des emojis
Environnement
- Conteneur LXC Proxmox
- Ubuntu 18.04
- MariaDB 10.1
- Nextcloud 15
Configuration
Trouver le fichier de configuration de MariaDB :
grep -r "\[mysqld\]" /etc/
MariaDB étant en version 10.1, ajouter les paramètres suivants au fichier /etc/mysql/mariadb.conf.d/50-server.cnf :
cp -p /etc/mysql/mariadb.conf.d/50-server.cnf /etc/mysql/mariadb.conf.d/50-server.cnf.bak
nano /etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld]
innodb_file_per_table=1
innodb_large_prefix=true
innodb_file_format=barracuda
Redémarrer MariaDB :
systemctl restart mariadb.service
Ouvrir MariaDB et vérifier si le format de fichier a été modifié vers Barracuda :
mariadb -u root -p
SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
+------------------------------------------+-------+------------- +
| NAME | SPACE | FILE_FORMAT |
+------------------------------------------+-------+------------- +
| nextcloud_db/oc_accounts | 140 | Antelope |
| nextcloud_db/oc_activity | 141 | Antelope |
| nextcloud_db/oc_activity_mq | 142 | Antelope |
| nextcloud_db/oc_addressbookchanges | 143 | Antelope |
| nextcloud_db/oc_addressbooks | 144 | Antelope |
| nextcloud_db/oc_appconfig | 145 | Antelope |
| nextcloud_db/oc_authtoken | 146 | Antelope |
| nextcloud_db/oc_bruteforce_attempts | 147 | Antelope |
| nextcloud_db/oc_calendar_invitations | 153 | Antelope |
| nextcloud_db/oc_calendar_resources | 154 | Antelope |
| nextcloud_db/oc_calendar_rooms | 155 | Antelope |
| nextcloud_db/oc_calendarchanges | 148 | Antelope |
| nextcloud_db/oc_calendarobjects | 149 | Antelope |
| nextcloud_db/oc_calendarobjects_props | 150 | Antelope |
| nextcloud_db/oc_calendars | 151 | Antelope |
| nextcloud_db/oc_calendarsubscriptions | 152 | Antelope |
| nextcloud_db/oc_cards | 156 | Antelope |
| nextcloud_db/oc_cards_properties | 157 | Antelope |
| nextcloud_db/oc_comments | 158 | Antelope |
| nextcloud_db/oc_comments_read_markers | 159 | Antelope |
| nextcloud_db/oc_credentials | 160 | Antelope |
| nextcloud_db/oc_dav_shares | 161 | Antelope |
| nextcloud_db/oc_directlink | 162 | Antelope |
| nextcloud_db/oc_federated_reshares | 163 | Antelope |
| nextcloud_db/oc_file_locks | 166 | Antelope |
| nextcloud_db/oc_filecache | 164 | Antelope |
| nextcloud_db/oc_files_trash | 165 | Antelope |
| nextcloud_db/oc_flow_checks | 167 | Antelope |
| nextcloud_db/oc_flow_operations | 168 | Antelope |
| nextcloud_db/oc_group_admin | 170 | Antelope |
| nextcloud_db/oc_group_user | 171 | Antelope |
| nextcloud_db/oc_groups | 169 | Antelope |
| nextcloud_db/oc_jobs | 172 | Antelope |
| nextcloud_db/oc_migrations | 173 | Antelope |
| nextcloud_db/oc_mimetypes | 174 | Antelope |
| nextcloud_db/oc_mounts | 175 | Antelope |
| nextcloud_db/oc_news_feeds | 205 | Antelope |
| nextcloud_db/oc_news_folders | 204 | Antelope |
| nextcloud_db/oc_news_items | 206 | Antelope |
| nextcloud_db/oc_notes_meta | 176 | Antelope |
| nextcloud_db/oc_notifications | 177 | Antelope |
| nextcloud_db/oc_notifications_pushtokens | 178 | Antelope |
| nextcloud_db/oc_oauth2_access_tokens | 179 | Antelope |
| nextcloud_db/oc_oauth2_clients | 180 | Antelope |
| nextcloud_db/oc_preferences | 181 | Antelope |
| nextcloud_db/oc_privatedata | 182 | Antelope |
| nextcloud_db/oc_properties | 183 | Antelope |
| nextcloud_db/oc_schedulingobjects | 184 | Antelope |
| nextcloud_db/oc_share | 185 | Antelope |
| nextcloud_db/oc_share_external | 186 | Antelope |
| nextcloud_db/oc_spreedme_tps | 187 | Antelope |
| nextcloud_db/oc_storages | 188 | Antelope |
| nextcloud_db/oc_systemtag | 189 | Antelope |
| nextcloud_db/oc_systemtag_group | 190 | Antelope |
| nextcloud_db/oc_systemtag_object_mapping | 191 | Antelope |
| nextcloud_db/oc_talk_guests | 192 | Antelope |
| nextcloud_db/oc_talk_participants | 193 | Antelope |
| nextcloud_db/oc_talk_rooms | 194 | Antelope |
| nextcloud_db/oc_talk_signaling | 195 | Antelope |
| nextcloud_db/oc_trusted_servers | 196 | Antelope |
| nextcloud_db/oc_twofactor_backupcodes | 197 | Antelope |
| nextcloud_db/oc_twofactor_providers | 198 | Antelope |
| nextcloud_db/oc_twofactor_totp_secrets | 199 | Antelope |
| nextcloud_db/oc_users | 200 | Antelope |
| nextcloud_db/oc_vcategory | 201 | Antelope |
| nextcloud_db/oc_vcategory_to_object | 202 | Antelope |
| nextcloud_db/oc_whats_new | 203 | Antelope |
+------------------------------------------+-------+------------- +
67 rows in set (0.01 sec)
Le format étant toujours Antelope, il faut migrer le système de fichier manuellement :
USE INFORMATION_SCHEMA;
Générer les commandes à appliquer pour modifier chaque table :
SELECT CONCAT("ALTER TABLE ", TABLE_SCHEMA,".", TABLE_NAME, " ROW_FORMAT=DYNAMIC;") AS MySQLCMD FROM TABLES WHERE TABLE_SCHEMA = "nextcloud_db";
+------------------------------------------------------------------------------+
| MySQLCMD |
+------------------------------------------------------------------------------+
| ALTER TABLE nextcloud_db.oc_accounts ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_activity ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_activity_mq ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_addressbookchanges ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_addressbooks ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_appconfig ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_authtoken ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_bruteforce_attempts ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_calendar_invitations ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_calendar_resources ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_calendar_rooms ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_calendarchanges ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_calendarobjects ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_calendarobjects_props ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_calendars ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_calendarsubscriptions ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_cards ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_cards_properties ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_comments ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_comments_read_markers ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_credentials ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_dav_shares ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_directlink ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_federated_reshares ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_file_locks ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_filecache ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_files_trash ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_flow_checks ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_flow_operations ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_group_admin ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_group_user ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_groups ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_jobs ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_migrations ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_mimetypes ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_mounts ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_news_feeds ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_news_folders ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_news_items ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_notes_meta ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_notifications ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_notifications_pushtokens ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_oauth2_access_tokens ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_oauth2_clients ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_preferences ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_privatedata ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_properties ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_schedulingobjects ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_share ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_share_external ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_spreedme_tps ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_storages ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_systemtag ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_systemtag_group ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_systemtag_object_mapping ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_talk_guests ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_talk_participants ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_talk_rooms ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_talk_signaling ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_trusted_servers ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_twofactor_backupcodes ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_twofactor_providers ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_twofactor_totp_secrets ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_users ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_vcategory ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_vcategory_to_object ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_whats_new ROW_FORMAT=DYNAMIC; |
+------------------------------------------------------------------------------+
Exécuter les commandes :
ALTER TABLE nextcloud_db.oc_accounts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_activity ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_activity_mq ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_addressbookchanges ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_addressbooks ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_appconfig ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_authtoken ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_bruteforce_attempts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendar_invitations ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendar_resources ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendar_rooms ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendarchanges ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendarobjects ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendarobjects_props ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendars ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendarsubscriptions ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_cards ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_cards_properties ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_comments ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_comments_read_markers ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_credentials ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_dav_shares ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_directlink ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_federated_reshares ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_file_locks ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_filecache ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_files_trash ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_flow_checks ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_flow_operations ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_group_admin ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_group_user ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_groups ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_jobs ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_migrations ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_mimetypes ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_mounts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_news_feeds ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_news_folders ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_news_items ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_notes_meta ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_notifications ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_notifications_pushtokens ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_oauth2_access_tokens ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_oauth2_clients ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_preferences ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_privatedata ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_properties ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_schedulingobjects ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_share ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_share_external ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_spreedme_tps ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_storages ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_systemtag ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_systemtag_group ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_systemtag_object_mapping ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_talk_guests ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_talk_participants ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_talk_rooms ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_talk_signaling ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_trusted_servers ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_twofactor_backupcodes ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_twofactor_providers ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_twofactor_totp_secrets ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_users ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_vcategory ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_vcategory_to_object ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_whats_new ROW_FORMAT=DYNAMIC;
Redémarrer MariaDB :
systemctl restart mariadb.service
Ouvrir MariaDB et modifier les caracter set et collation :
mariadb -u root -p
ALTER DATABASE nextcloud_db CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
Vérifier que le format de fichier a été modifié vers Barracuda :
SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
+------------------------------------------+-------+-------------+
| NAME | SPACE | FILE_FORMAT |
+------------------------------------------+-------+-------------+
| nextcloud_db/oc_accounts | 207 | Barracuda |
| nextcloud_db/oc_activity | 208 | Barracuda |
| nextcloud_db/oc_activity_mq | 209 | Barracuda |
| nextcloud_db/oc_addressbookchanges | 210 | Barracuda |
| nextcloud_db/oc_addressbooks | 211 | Barracuda |
| nextcloud_db/oc_appconfig | 212 | Barracuda |
| nextcloud_db/oc_authtoken | 213 | Barracuda |
| nextcloud_db/oc_bruteforce_attempts | 214 | Barracuda |
| nextcloud_db/oc_calendar_invitations | 215 | Barracuda |
| nextcloud_db/oc_calendar_resources | 216 | Barracuda |
| nextcloud_db/oc_calendar_rooms | 217 | Barracuda |
| nextcloud_db/oc_calendarchanges | 218 | Barracuda |
| nextcloud_db/oc_calendarobjects | 219 | Barracuda |
| nextcloud_db/oc_calendarobjects_props | 220 | Barracuda |
| nextcloud_db/oc_calendars | 221 | Barracuda |
| nextcloud_db/oc_calendarsubscriptions | 222 | Barracuda |
| nextcloud_db/oc_cards | 223 | Barracuda |
| nextcloud_db/oc_cards_properties | 224 | Barracuda |
| nextcloud_db/oc_comments | 225 | Barracuda |
| nextcloud_db/oc_comments_read_markers | 226 | Barracuda |
| nextcloud_db/oc_credentials | 227 | Barracuda |
| nextcloud_db/oc_dav_shares | 228 | Barracuda |
| nextcloud_db/oc_directlink | 229 | Barracuda |
| nextcloud_db/oc_federated_reshares | 230 | Barracuda |
| nextcloud_db/oc_file_locks | 231 | Barracuda |
| nextcloud_db/oc_filecache | 232 | Barracuda |
| nextcloud_db/oc_files_trash | 233 | Barracuda |
| nextcloud_db/oc_flow_checks | 234 | Barracuda |
| nextcloud_db/oc_flow_operations | 235 | Barracuda |
| nextcloud_db/oc_group_admin | 236 | Barracuda |
| nextcloud_db/oc_group_user | 237 | Barracuda |
| nextcloud_db/oc_groups | 238 | Barracuda |
| nextcloud_db/oc_jobs | 239 | Barracuda |
| nextcloud_db/oc_migrations | 240 | Barracuda |
| nextcloud_db/oc_mimetypes | 241 | Barracuda |
| nextcloud_db/oc_mounts | 242 | Barracuda |
| nextcloud_db/oc_news_feeds | 243 | Barracuda |
| nextcloud_db/oc_news_folders | 244 | Barracuda |
| nextcloud_db/oc_news_items | 245 | Barracuda |
| nextcloud_db/oc_notes_meta | 246 | Barracuda |
| nextcloud_db/oc_notifications | 247 | Barracuda |
| nextcloud_db/oc_notifications_pushtokens | 248 | Barracuda |
| nextcloud_db/oc_oauth2_access_tokens | 249 | Barracuda |
| nextcloud_db/oc_oauth2_clients | 250 | Barracuda |
| nextcloud_db/oc_preferences | 251 | Barracuda |
| nextcloud_db/oc_privatedata | 252 | Barracuda |
| nextcloud_db/oc_properties | 253 | Barracuda |
| nextcloud_db/oc_schedulingobjects | 254 | Barracuda |
| nextcloud_db/oc_share | 255 | Barracuda |
| nextcloud_db/oc_share_external | 256 | Barracuda |
| nextcloud_db/oc_spreedme_tps | 257 | Barracuda |
| nextcloud_db/oc_storages | 258 | Barracuda |
| nextcloud_db/oc_systemtag | 259 | Barracuda |
| nextcloud_db/oc_systemtag_group | 260 | Barracuda |
| nextcloud_db/oc_systemtag_object_mapping | 261 | Barracuda |
| nextcloud_db/oc_talk_guests | 262 | Barracuda |
| nextcloud_db/oc_talk_participants | 263 | Barracuda |
| nextcloud_db/oc_talk_rooms | 264 | Barracuda |
| nextcloud_db/oc_talk_signaling | 265 | Barracuda |
| nextcloud_db/oc_trusted_servers | 266 | Barracuda |
| nextcloud_db/oc_twofactor_backupcodes | 267 | Barracuda |
| nextcloud_db/oc_twofactor_providers | 268 | Barracuda |
| nextcloud_db/oc_twofactor_totp_secrets | 269 | Barracuda |
| nextcloud_db/oc_users | 270 | Barracuda |
| nextcloud_db/oc_vcategory | 271 | Barracuda |
| nextcloud_db/oc_vcategory_to_object | 272 | Barracuda |
| nextcloud_db/oc_whats_new | 273 | Barracuda |
+------------------------------------------+-------+-------------+
67 rows in set (0.00 sec)
Appliquer les commandes suivantes pour terminer la conversion :
cd /var/www/html/nextcloud/
sudo -u www-data php occ config:system:set mysql.utf8mb4 --type boolean --value="true"
System config value mysql.utf8mb4 set to boolean true
sudo -u www-data php occ maintenance:repair
- Change row format for oc_notes_meta ...
- Change collation for oc_notes_meta ...
- Change row format for oc_notifications ...
- Change collation for oc_notifications ...
- Change row format for oc_notifications_pushtokens ...
- Change collation for oc_notifications_pushtokens ...
- Change row format for oc_oauth2_access_tokens ...
- Change collation for oc_oauth2_access_tokens ...
- Change row format for oc_oauth2_clients ...
- Change collation for oc_oauth2_clients ...
- Change row format for oc_preferences ...
- Change collation for oc_preferences ...
- Change row format for oc_privatedata ...
- Change collation for oc_privatedata ...
- Change row format for oc_properties ...
- Change collation for oc_properties ...
- Change row format for oc_schedulingobjects ...
- Change collation for oc_schedulingobjects ...
- Change row format for oc_share ...
- Change collation for oc_share ...
- Change row format for oc_share_external ...
- Change collation for oc_share_external ...
- Change row format for oc_spreedme_tps ...
- Change collation for oc_spreedme_tps ...
- Change row format for oc_storages ...
- Change collation for oc_storages ...
- Change row format for oc_systemtag ...
- Change collation for oc_systemtag ...
- Change row format for oc_systemtag_group ...
- Change collation for oc_systemtag_group ...
- Change row format for oc_systemtag_object_mapping ...
- Change collation for oc_systemtag_object_mapping ...
- Change row format for oc_talk_guests ...
- Change collation for oc_talk_guests ...
- Change row format for oc_talk_participants ...
- Change collation for oc_talk_participants ...
- Change row format for oc_talk_rooms ...
- Change collation for oc_talk_rooms ...
- Change row format for oc_talk_signaling ...
- Change collation for oc_talk_signaling ...
- Change row format for oc_trusted_servers ...
- Change collation for oc_trusted_servers ...
- Change row format for oc_twofactor_backupcodes ...
- Change collation for oc_twofactor_backupcodes ...
- Change row format for oc_twofactor_providers ...
- Change collation for oc_twofactor_providers ...
- Change row format for oc_twofactor_totp_secrets ...
- Change collation for oc_twofactor_totp_secrets ...
- Change row format for oc_users ...
- Change collation for oc_users ...
- Change row format for oc_vcategory ...
- Change collation for oc_vcategory ...
- Change row format for oc_vcategory_to_object ...
- Change collation for oc_vcategory_to_object ...
- Change row format for oc_whats_new ...
- Change collation for oc_whats_new ...
- Change row format for oc_federated_reshares ...
- Change collation for oc_federated_reshares ...
- Repair mime types
- Clean tags and favorites
- 0 tags of deleted users have been removed.
- 0 tags for delete files have been removed.
- 0 tag entries for deleted tags have been removed.
- 0 tags with no entries have been removed.
- Repair invalid shares
- Remove shares of a users root folder
- Move .step file of updater to backup location
- Fix potential broken mount points
- No mounts updated
- Repair invalid paths in file cache
- Add log rotate job
- Clear frontend caches
- Image cache cleared
- SCSS cache cleared
- JS cache cleared
- Clear every generated avatar on major updates
- Add preview background cleanup job
- Queue a one-time job to cleanup old backups of the updater
- Repair pending cron jobs
- No need to repair pending cron jobs.
- Extract the vcard uid and store it in the db
- Fix component of birthday calendars
- 2 birthday calendars updated.
- Fix broken values of calendar objects
0 [>---------------------------]
- Registering building of calendar search index as background job
- Repair step already executed
- Registering background jobs to update cache for webcal calendars
- Added 0 background jobs to update webcal calendars
- Remove activity entries of private events
- Removed 0 activity entries
- Fix the share type of guest shares when migrating from ownCloud
- Copy the share password into the dedicated column
- Migrate binary status into separate boolean fields
- Update OAuth token expiration times
- Add background job to check for backup codes
Sources
https://docs.nextcloud.com/server/15/admin_manual/configuration_database/mysql_4byte_support.html