Can someone please quantify "lots" of events?bbunge wrote: If you run Zoneminder long enough with lots of events, you will have to tune the MySQL, or Mariadb, settings.
bb
1,000; 10,000; 100,000...
Can someone please quantify "lots" of events?bbunge wrote: If you run Zoneminder long enough with lots of events, you will have to tune the MySQL, or Mariadb, settings.
bb
with Ubuntu 16.04 Server Release ?
Wait for it. Am still working on upgrade procedures, which work sometimes, fighting for a warranty claim on my Maytag heat pump, and other "life" issues.caseyj wrote:Can someone do thiswith Ubuntu 16.04 Server Release ?
Sure. Thanks so much for your effort !Wait for it
Code: Select all
sudo mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql
Code: Select all
ERROR 1819 (HY000) at line 562: Your password does not satisfy the current policy requirements
Code: Select all
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------+-------+
| validate_password_dictionary_file | |
| validate_password_length | 8 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy | LOW |
| validate_password_special_char_count | 1 |
+--------------------------------------+-------+
6 rows in set (0.03 sec)
Code: Select all
kamera@dvr:~$ mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql
Enter password:
ERROR 1819 (HY000) at line 562: Your password does not satisfy the current policy requirements
Code: Select all
service apache2 reload
Code: Select all
Job for apache2.service failed because the control process exited with error code. See "systemctl status apache2.service" and "journalctl -xe" for details.
Code: Select all
systemctl status apache2.service
Code: Select all
root@dvr:/home/kamera# systemctl status apache2.service
● apache2.service - LSB: Apache2 web server
Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)
Drop-In: /lib/systemd/system/apache2.service.d
└─apache2-systemd.conf
Active: active (running) (Result: exit-code) since Tue 2016-05-24 19:43:11 EEST; 22min ago
Docs: man:systemd-sysv-generator(8)
Process: 567 ExecReload=/etc/init.d/apache2 reload (code=exited, status=1/FAILURE)
CGroup: /system.slice/apache2.service
├─27441 /usr/sbin/apache2 -k start
├─27444 /usr/sbin/apache2 -k start
├─27445 /usr/sbin/apache2 -k start
└─27446 /usr/sbin/apache2 -k start
May 24 20:05:02 dvr apache2[567]: * Reloading Apache httpd web server apache2
May 24 20:05:02 dvr apache2[567]: *
May 24 20:05:02 dvr apache2[567]: * The apache2 configtest failed. Not doing anything.
May 24 20:05:02 dvr apache2[567]: Output of config test was:
May 24 20:05:02 dvr apache2[567]: AH00526: Syntax error on line 11 of /etc/apache2/conf-enabled/zoneminder.conf:
May 24 20:05:02 dvr apache2[567]: Invalid command 'php_flag', perhaps misspelled or defined by a module not included in the server configuration
May 24 20:05:02 dvr apache2[567]: Action 'configtest' failed.
May 24 20:05:02 dvr apache2[567]: The Apache error log may have more information.
May 24 20:05:02 dvr systemd[1]: apache2.service: Control process exited, code=exited status=1
May 24 20:05:02 dvr systemd[1]: Reload failed for LSB: Apache2 web server.
Code: Select all
root@dvr:/home/kamera# cat /etc/apache2/conf-enabled/zoneminder.conf
# Remember to enable cgi mod (i.e. "a2enmod cgi").
ScriptAlias /zm/cgi-bin "/usr/lib/zoneminder/cgi-bin"
<Directory "/usr/lib/zoneminder/cgi-bin">
Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
AllowOverride All
Require all granted
</Directory>
Alias /zm /usr/share/zoneminder/www
<Directory /usr/share/zoneminder/www>
php_flag register_globals off
Options Indexes FollowSymLinks
<IfModule mod_dir.c>
DirectoryIndex index.php
</IfModule>
</Directory>