NextCloud

Notes

<VirtualHost *:80>
   ServerName cloud.nextcloud.com
   Redirect permanent / https://cloud.nextcloud.com/
</VirtualHost>

chown -R http:http ./web/nextclould
chmod -R 0770 nextcloud
chown -R http:http /volume1/nextcloud
chmod -R 0770 /volume1/nextcloud

/usr/local/etc/apache24/conf/httpd.conf

<VirtualHost *:443>
  ServerName cloud.nextcloud.com
    <IfModule mod_headers.c>
      Header always set Strict-Transport-Security "max-age=15552000; includeSubDomains"
    </IfModule>
 </VirtualHost>

opcache.enable=1
opcache.enable_cli=1
opcache.interned_strings_buffer=8
opcache.max_accelerated_files=10000
opcache.memory_consumption=128
opcache.save_comments=1
opcache.revalidate_freq=1

/usr/local/mariadb10/bin# ./mysql -u root -p

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| NextCloud          |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+

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

MariaDB [NextCloud]> select * from oc_bruteforce_attempts;

...

MariaDB [NextCloud]>  DELETE FROM oc_bruteforce_attempts WHERE ip = 'aaa.bbb.ccc.ddd';

OR 

MariaDB [NextCloud]>  DELETE FROM oc_bruteforce_attempts WHERE action = 'login'; 

https://dev.mysql.com/doc/mysql-getting-started/en/#mysql-getting-started-basic-ops