Zoneminder-notes

From I Will Fear No Evil
Revision as of 10:24, 14 February 2022 by Chubbard (talk | contribs)
Jump to navigation Jump to search

Zoneminder configuration information specific to the alarm filtering can be found in the following areas..

Rebuild database after Docker clobbers it
Copy database from /opt/Zoneminder/mysql /opt/mysql

mysqldump -u zmuser -pzmpass zm  >> /tmp/dump.sql

mysql_install_db --user=mysql --datadir=/opt/mysql --basedir=/usr ----auth-root-authentication-method=socket

login to database:
use mysql;
create USER 'zmuser'@'localhost' IDENTIFIED BY 'zmpass';
grant all privileges on zm.* to 'zmuser'@'localhost';
flush privileges;
create database zm;

sudo mysql -u root -S /var/run/mysqld/mysqld.sock zm < /tmp/dump.sql
stop database
copt database back into //opt/Zoneminder/mysql
chown back to correct usierid (will not match mysql)

Make damn sure that you lock down the docker version

 apt-mark showhold
docker-ce
docker-ce-cli
docker-ce-rootless-extras
docker-scan-plugin