Security & setup warnings

1

Do I have to do something myself or will this be corrected with an update?

There are some warnings regarding your setup.

** Your installation has no default phone region set. This is required to validate phone numbers in the profile settings without a country code. To allow numbers without a country code, please add “default_phone_region” with the respective ISO 3166-1 code :arrow_upper_right: of the region to your config file.*
** The database is missing some primary keys. Due to the fact that adding primary keys on big tables could take some time they were not added automatically. By running “occ db:add-missing-primary-keys” those missing primary keys could be added manually while the instance keeps running.*

    • Missing primary key on table “oc_federated_reshares”.*
    • Missing primary key on table “oc_systemtag_object_mapping”.*
    • Missing primary key on table “oc_comments_read_markers”.*
    • Missing primary key on table “oc_collres_resources”.*
    • Missing primary key on table “oc_collres_accesscache”.*
    • Missing primary key on table “oc_filecache_extended”.*
      ** Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running ‘occ db:convert-filecache-bigint’ those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this.*
    • federated_reshares.share_id*
    • share_external.id*
    • share_external.parent*
2

  1. Region code is unfortunately expected at the moment until Nextcloud moves it to UI from config.php or you need to edit it yourself.

  2. Indeces are a manual step while upgrading from old versions. Run this command using SSH:

snap run nextcloud.occ db:add-missing-primary-keys
1 Like
3

Hi Boris,

Where is the file ?
Thanks

4

Looks like it is possible to set it using this command:

snap run nextcloud.occ config:system:set default_phone_region --value="GB"

With two letter code (Alpha 2) from here: List of ISO 3166 country codes - Wikipedia

1 Like
5

Thanks Boris

There remains this problem

What is your advice ?

Regards.
Pierre

6

:+1: thank you Boris for this good solution

7

Some columns in the database are missing a conversion to big int.

try this:

snap run nextcloud.occ db:convert-filecache-bigint