Projet

Général

Profil

Anomalie #4165

valise.april.org – Avertissement de configuration sur l'absence de support de l'unicode 4 octets pour la base de données

Ajouté par Christian P. Momon il y a environ 4 ans. Mis à jour il y a environ 4 ans.

Statut:
Fermé
Priorité:
Normale
Assigné à:
Catégorie:
-
Version cible:
Début:
09/01/2020
Echéance:
% réalisé:

0%

Temps estimé:
Difficulté:
2 Facile

Description

Avec le compte admin, dans la page « Paramètres > Administration > Vue d'ensemble », on peut lire :

MySQL est utilisée comme base de données mais ne supporte pas les caractères codés sur 4 octets.
Pour pouvoir manipuler les caractères sur 4 octets (comme les émoticônes) sans problème dans les
noms de fichiers ou les commentaires par exemple, il est recommandé d'activer le support 4 octets dans MySQL.
Pour plus de détails, lisez la page de documentation à ce sujet

Historique

#1

Mis à jour par Christian P. Momon il y a environ 4 ans

  • Tracker changé de Demande à Anomalie
#2

Mis à jour par François Poulain il y a environ 4 ans

Attention en général ça ne fonctionne pas « as is ».

Extrait d'un CR d'install :

https://docs.nextcloud.com/server/15/admin_manual/configuration_database/mysql_4byte_support.html

MariaDB [(none)]> ALTER DATABASE nextcloud_db CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
Query OK, 1 row affected (0.03 sec)

bling@web:~/www/nextcloud$ php occ config:system:set mysql.utf8mb4 --type boolean --value="true" 
System config value mysql.utf8mb4 set to boolean true
bling@web:~/www/nextcloud$ php occ maintenance:repair
 - Repair MySQL collation
     - Change row format for oc_accounts ...
     - Change collation for oc_accounts ...
     - Change row format for oc_activity ...
     - Change collation for oc_activity ...
     - Change row format for oc_activity_mq ...
     - Change collation for oc_activity_mq ...
     - Change row format for oc_addressbookchanges ...
     - Change collation for oc_addressbookchanges ...
     - Change row format for oc_addressbooks ...
     - Change collation for oc_addressbooks ...
...

Forcément ça plante. J'ai eu une erreur résolue par ça : https://help.nextcloud.com/t/solved-syntax-error-or-access-violation-1071-specified-key-was-too-long-max-key-length-is-767-bytes/34740

MariaDB [(none)]> use nextcloud_db;
Database changed

MariaDB [nextcloud_db]> set global innodb_large_prefix=on;
Query OK, 0 rows affected (0.00 sec)

MariaDB [nextcloud_db]> set global innodb_file_format=Barracuda;
Query OK, 0 rows affected (0.00 sec)

php occ maintenance:repair
...

php occ maintenance:mode --off

#3

Mis à jour par Quentin Gibeaux il y a environ 4 ans

  • Version cible changé de Janvier 2020 à Février 2020
#4

Mis à jour par Quentin Gibeaux il y a environ 4 ans

  • Version cible changé de Février 2020 à Mars 2020
#5

Mis à jour par François Poulain il y a environ 4 ans

  • Statut changé de Nouveau à Résolu
  • Assigné à mis à François Poulain

Fait.

# sudo -u www-data php -f /var/www/valise-new.april.org/occ config:system:set mysql.utf8mb4 --type boolean --value="true" 
System config value mysql.utf8mb4 set to boolean true
# sudo -u www-data php -f /var/www/valise-new.april.org/occ maintenance:repair
 - Repair MySQL collation
     - Change row format for oc_group_admin ...
     - Change collation for oc_group_admin ...
     - Change row format for oc_systemtag ...
     - Change collation for oc_systemtag ...
     - Change row format for oc_talk_participants ...
     - Change collation for oc_talk_participants ...
     - Change row format for oc_migrations ...
     - Change collation for oc_migrations ...
     - Change row format for oc_calendar_rooms ...
     - Change collation for oc_calendar_rooms ...
     - Change row format for oc_oauth2_clients ...
     - Change collation for oc_oauth2_clients ...
     - Change row format for oc_comments_read_markers ...
     - Change collation for oc_comments_read_markers ...
     - Change row format for oc_flow_operations_scope ...
     - Change collation for oc_flow_operations_scope ...
     - Change row format for oc_authtoken ...
     - Change collation for oc_authtoken ...
     - Change row format for oc_login_flow_v2 ...
     - Change collation for oc_login_flow_v2 ...
     - Change row format for oc_preferences ...
     - Change collation for oc_preferences ...
     - Change row format for oc_calendarobjects ...
     - Change collation for oc_calendarobjects ...
     - Change row format for oc_text_steps ...
     - Change collation for oc_text_steps ...
     - Change row format for oc_collres_accesscache ...
     - Change collation for oc_collres_accesscache ...
     - Change row format for oc_groups ...
     - Change collation for oc_groups ...
     - Change row format for oc_calendar_invitations ...
     - Change collation for oc_calendar_invitations ...
     - Change row format for oc_comments ...
     - Change collation for oc_comments ...
     - Change row format for oc_talk_signaling ...
     - Change collation for oc_talk_signaling ...
     - Change row format for oc_directlink ...
     - Change collation for oc_directlink ...
     - Change row format for oc_dav_cal_proxy ...
     - Change collation for oc_dav_cal_proxy ...
     - Change row format for oc_trusted_servers ...
     - Change collation for oc_trusted_servers ...
     - Change row format for oc_systemtag_group ...
     - Change collation for oc_systemtag_group ...
     - Change row format for oc_cards_properties ...
     - Change collation for oc_cards_properties ...
     - Change row format for oc_accounts ...
     - Change collation for oc_accounts ...
     - Change row format for oc_systemtag_object_mapping ...
     - Change collation for oc_systemtag_object_mapping ...
     - Change row format for oc_appconfig ...
     - Change collation for oc_appconfig ...
     - Change row format for oc_vcategory ...
     - Change collation for oc_vcategory ...
     - Change row format for oc_calendar_resources ...
     - Change collation for oc_calendar_resources ...
     - Change row format for oc_file_locks ...
     - Change collation for oc_file_locks ...
     - Change row format for oc_mimetypes ...
     - Change collation for oc_mimetypes ...
     - Change row format for oc_activity_mq ...
     - Change collation for oc_activity_mq ...
     - Change row format for oc_oauth2_access_tokens ...
     - Change collation for oc_oauth2_access_tokens ...
     - Change row format for oc_cards ...
     - Change collation for oc_cards ...
     - Change row format for oc_text_documents ...
     - Change collation for oc_text_documents ...
     - Change row format for oc_mounts ...
     - Change collation for oc_mounts ...
     - Change row format for oc_user_transfer_owner ...
     - Change collation for oc_user_transfer_owner ...
     - Change row format for oc_schedulingobjects ...
     - Change collation for oc_schedulingobjects ...
     - Change row format for oc_calendar_rooms_md ...
     - Change collation for oc_calendar_rooms_md ...
     - Change row format for oc_twofactor_backupcodes ...
     - Change collation for oc_twofactor_backupcodes ...
     - Change row format for oc_filecache_extended ...
     - Change collation for oc_filecache_extended ...
     - Change row format for oc_calendarchanges ...
     - Change collation for oc_calendarchanges ...
     - Change row format for oc_activity ...
     - Change collation for oc_activity ...
     - Change row format for oc_whats_new ...
     - Change collation for oc_whats_new ...
     - Change row format for oc_jobs ...
     - Change collation for oc_jobs ...
     - Change row format for oc_share ...
     - Change collation for oc_share ...
     - Change row format for oc_collres_collections ...
     - Change collation for oc_collres_collections ...
     - Change row format for oc_calendar_reminders ...
     - Change collation for oc_calendar_reminders ...
     - Change row format for oc_talk_guests ...
     - Change collation for oc_talk_guests ...
     - Change row format for oc_notifications ...
     - Change collation for oc_notifications ...
     - Change row format for oc_talk_rooms ...
     - Change collation for oc_talk_rooms ...
     - Change row format for oc_twofactor_providers ...
     - Change collation for oc_twofactor_providers ...
     - Change row format for oc_addressbookchanges ...
     - Change collation for oc_addressbookchanges ...
     - Change row format for oc_share_external ...
     - Change collation for oc_share_external ...
     - Change row format for oc_flow_operations ...
     - Change collation for oc_flow_operations ...
     - Change row format for oc_credentials ...
     - Change collation for oc_credentials ...
     - Change row format for oc_flow_checks ...
     - Change collation for oc_flow_checks ...
     - Change row format for oc_privacy_admins ...
     - Change collation for oc_privacy_admins ...
     - Change row format for oc_calendars ...
     - Change collation for oc_calendars ...
     - Change row format for oc_calendarsubscriptions ...
     - Change collation for oc_calendarsubscriptions ...
     - Change row format for oc_direct_edit ...
     - Change collation for oc_direct_edit ...
     - Change row format for oc_files_trash ...
     - Change collation for oc_files_trash ...
     - Change row format for oc_talk_commands ...
     - Change collation for oc_talk_commands ...
     - Change row format for oc_group_user ...
     - Change collation for oc_group_user ...
     - Change row format for oc_users ...
     - Change collation for oc_users ...
     - Change row format for oc_addressbooks ...
     - Change collation for oc_addressbooks ...
     - Change row format for oc_text_sessions ...
     - Change collation for oc_text_sessions ...
     - Change row format for oc_storages ...
     - Change collation for oc_storages ...
     - Change row format for oc_vcategory_to_object ...
     - Change collation for oc_vcategory_to_object ...
     - Change row format for oc_collres_resources ...
     - Change collation for oc_collres_resources ...
     - Change row format for oc_calendarobjects_props ...
     - Change collation for oc_calendarobjects_props ...
     - Change row format for oc_calendar_resources_md ...
     - Change collation for oc_calendar_resources_md ...
     - Change row format for oc_properties ...
     - Change collation for oc_properties ...
     - Change row format for oc_dav_shares ...
     - Change collation for oc_dav_shares ...
     - Change row format for oc_notifications_pushtokens ...
     - Change collation for oc_notifications_pushtokens ...
     - Change row format for oc_bruteforce_attempts ...
     - Change collation for oc_bruteforce_attempts ...
     - Change row format for oc_filecache ...
     - Change collation for oc_filecache ...
     - 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
 - Move .step file of updater to backup location
 - Fix potential broken mount points
     - No mounts updated
 - 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
 - Cleanup invalid photocache files for carddav
 - Add background job to cleanup login flow v2 tokens
 - Remove potentially over exposing share links
     - No need to remove link shares.
 - Clear access cache of projects
 - Switches from deprecated "production" to "stable" update channel
 - Sets the enterprise logo
     - Repair step already executed
 - Reset generated avatar flag
 - Update name of the stored view
 - Fix component of birthday calendars
     - 4 birthday calendars updated.
 - Regenerating birthday calendars to use new icons and fix old birthday events without year
     - Repair step already executed
 - 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
 - Registering building of calendar reminder index as background job
     - Repair step already executed
 - Clean up orphan event and contact data
     - 0 events without a calendar have been cleaned up
     - 0 properties without an events have been cleaned up
     - 0 changes without a calendar have been cleaned up
     - 0 cached events without a calendar subscription have been cleaned up
     - 0 changes without a calendar subscription have been cleaned up
     - 0 contacts without an addressbook have been cleaned up
     - 0 properties without a contact have been cleaned up
     - 0 changes without an addressbook have been cleaned up
 - 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
 - Set existing shares as accepted
 - Update OAuth token expiration times
 - Create help command
 - Invalidate access cache for projects conversation provider
     - Invalidation not required
 - Add background job to check for backup codes
 - Populating added database structures for workflows
#6

Mis à jour par Christian P. Momon il y a environ 4 ans

Bravo \o/

#7

Mis à jour par Quentin Gibeaux il y a environ 4 ans

  • Statut changé de Résolu à Fermé

Formats disponibles : Atom PDF