Zoneminder-notes: Difference between revisions
		
		
		
		
		
		Jump to navigation
		Jump to search
		
				
		
		
	
mNo edit summary  | 
				mNo edit summary  | 
				||
| Line 4: | Line 4: | ||
* [https://forums.zoneminder.com/viewtopic.php?t=4576_0Lt_DW1cggPr7dOBj|Zoneminder foum post on blob detection]  | * [https://forums.zoneminder.com/viewtopic.php?t=4576_0Lt_DW1cggPr7dOBj|Zoneminder foum post on blob detection]  | ||
* [https://wiki.zoneminder.com/How_to_get_ssmtp_working_with_Zoneminder|Zoneminder ssmtp configuration example]  | * [https://wiki.zoneminder.com/How_to_get_ssmtp_working_with_Zoneminder|Zoneminder ssmtp configuration example]  | ||
===== Rebuild database after Docker clobbers it =====  | |||
<pre>  | |||
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)  | |||
</pre>  | |||
Make damn sure that you lock down the docker version  | |||
<pre>  | |||
 apt-mark showhold  | |||
docker-ce  | |||
docker-ce-cli  | |||
docker-ce-rootless-extras  | |||
docker-scan-plugin  | |||
</pre>  | |||
[[Category:Zoneminder]]  | [[Category:Zoneminder]]  | ||
Revision as of 09:24, 14 February 2022
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