Differences

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

--- computing:nextcloud [2024/07/13 04:12] – oemb1905
+++ computing:nextcloud [2026/10/14 15:15] (current) – oemb1905
@@ Line 138: / Line 138: @@
 To configure cron to refresh php every 5 minutes:
-  sudo crontab -e -u www-data
+  ''sudo crontab -e -u www-data''
   <MAILTO="email@email.com">
   <*/5  *  *  *  * php -f /var/www/html/cron.php > /dev/null 2>&1>
@@ 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:
+  'mail_smtpmode' => 'smtp',
+  'mail_sendmailmode' => 'smtp',
+  'mail_smtphost' => 'mail.example.com',
+  'mail_smtpport' => '465',
+  'mail_smtpauth' => 1,
+  'mail_smtptimeout' => 30,
+  'mail_from_address' => 'noreply',
+  'mail_smtpname' => 'noreply',
+  'mail_smtppassword' => 'hackmehard123!@',
+  'mail_smtpsecure' => 'ssl',
+=== 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
- --- //[[webmaster@haacksnetworking.org|oemb1905]] 2024/04/13 21:17//
+ --- //[[alerts@haacksnetworking.org|oemb1905]] 2026/09/27 14:50//

Haack's Wiki

User Tools

Site Tools

Differences

Page Tools