Differences

This shows you the differences between two versions of the page.

--- computing:nextcloud [2025/10/25 18:56] – oemb1905
+++ computing:nextcloud [2026/10/14 15:15] (current) – oemb1905
@@ Line 212: / Line 212: @@
   sudo nano /var/www/html/.user.ini
   max_excution_time = 240 (for all of them)
+For Nextcloud 35.0.1, they started suggesting db optimizations, so create ''nano /etc/mysql/mariadb.conf.d/99-nextcloud.cnf'' and drop in something like:
+<code bash>
+[mysqld]
+slow_query_log = ON
+slow_query_log_file = /var/log/mysql/mariadb-slow.log
+long_query_time = 1
+log_queries_not_using_indexes = ON
+min_examined_row_limit = 1000
+log_slow_verbosity = query_plan,explain
+tmp_table_size = 128M
+max_heap_table_size = 128M
+sort_buffer_size = 2M
+table_definition_cache = 2000
+table_open_cache = 32586
+table_open_cache_instances = 8
+open_files_limit = 32768
+innodb_log_file_size = 256M
+innodb_buffer_pool_size = 4G
+innodb_log_file_size = 256M
+innodb_flush_log_at_trx_commit = 1
+innodb_flush_method = O_DIRECT
+</code>
-If you get the missing indexes error on an upgrade, use:
+If you get the missing indexes error on an upgrade, and/or after optimizing your db, run:
   sudo -u www-data php occ db:add-missing-indices
@@ Line 298: / Line 324: @@
   sudo -u www-data php occ maintenance:repair --include-expensive
+  sudo -u www-data php occ maintenance:repair #for version 33
 On recent versions, you cannot set up smtp on the gui. Use the following adjust as needed:
@@ Line 312: / Line 339: @@
   'mail_smtpsecure' => 'ssl',
- --- //[[alerts@haacksnetworking.org|oemb1905]] 2025/03/24 22:22//
+=== Version 33 Notes ===
+The new ''server_id'' parameter in ''config.php'' glitches so enter twice as follows:
+  'server_id' => 'unique-string',
+  'serverid' => 'unique-string',
+Yes, the code was bad so passing without the underscore tricks the interpreter into finding the correct JSON afterall. Another bug is that the db --include-expensive flag failed as per this bug report:
+  * [[https://github.com/nextcloud/server/issues/58594|File Sharing]]
+There's a solution to revert, but for met that does not work. So, I just enabled File sharing on the instance, then upgraded, then disabled File Sharing again.
+  sudo -u www-data php occ app:enable files_sharing
+  sudo -u www-data php occ app:disable files_sharing
+After that, there were no MIME errors remaining in the Administration Settings after the 33 upgrade. To disable the external apps error if you are not using it:
+  sudo -u www-data php occ app:disable app_api
+ --- //[[alerts@haacksnetworking.org|oemb1905]] 2026/09/27 14:50//

Haack's Wiki

User Tools

Site Tools

Differences

Page Tools