Nextcloud - few Security & setup warnings

  • After installing NC 18, I have this warnings


    The "Strict-Transport-Security" HTTP header is not set to at least "15552000" seconds. For enhanced security, it is recommended to enable HSTS as described in the [url='https://docs.nextcloud.com/server/18/go.php?to=admin-security']security tips ↗[/url].



    • The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.

      • Missing index "calendarobject_calid_index" in table "oc_calendarobjects_props".
      • Missing index "schedulobj_principuri_index" in table "oc_schedulingobjects".
    • 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.

      • mounts.storage_id
      • mounts.root_id
      • mounts.mount_id


    I try occ db:convert-filecache-bigint and receive this




    An unhandled exception has been thrown:


    Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: could not find driver in /sharedfolders/appdata/nextcloud/config/www/nextcloud/lib/private/DB/Connection.php:68



    Any ideas, please?

    = Fujitsu PRIMERGY TX1310 M3 • 2 x HDD 3.5" 4TB Western Digital Red • Windows Server 2019 • Hyper-V • OMV 5.x =

  • how did you run the occ command

    cd /srv-dev-disk-by-name-data/appdata/nextcloud/config/www/nextcloud


    sudo -u MYUSER php occ db:add-missing-indices

    = Fujitsu PRIMERGY TX1310 M3 • 2 x HDD 3.5" 4TB Western Digital Red • Windows Server 2019 • Hyper-V • OMV 5.x =

  • try

    Yes. :) Thank you!


    For other n))bs like me


    docker exec -it nextcloud bash
    sudo -u abc php /config/www/nextcloud/occ maintenance:mode --off
    cd /config/www/nextcloud
    sudo -u abc php occ db:add-missing-indices
    sudo -u abc php occ db:convert-filecache-bigint

    = Fujitsu PRIMERGY TX1310 M3 • 2 x HDD 3.5" 4TB Western Digital Red • Windows Server 2019 • Hyper-V • OMV 5.x =

    Einmal editiert, zuletzt von gett ()

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!