I followed the directions here
https://zoneminder.readthedocs.io/en/la ... 4-bionic 1
found out the ppa doesn’t work with my version (eoan)
After many hours and searching, apt purge sql zoneminer, apt install sql, zoneminer, still kept failing, sql side)(this was zoneminer 1.32.3)
but found a workaround
someone led me to this ppa
sudo add-apt-repository ppa:iconnor/zon ... 34/ubuntu/
(didnt think about adding the ppa

This updated Zoneminer to 1.34.5
Some problems fixed after this. All but the SQL side.
I have changed the root pass on SQL and can login using
mysql -uroot -p
But after installing Zoneminer from the .deb package this happens
Code: Select all
Setting up zoneminder (1.34.5-eoan1) ...
Detected db service is mysql.service
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Creating zm db
ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
Error creating db.
dpkg: error processing package zoneminder (--install):
installed zoneminder package post-installation script subprocess returned error exit status 1
Processing triggers for man-db (2.8.7-3) ...
Errors were encountered while processing:
zoneminder
I can tell that this is on SQL side. The user debian-sys-maint'@'localhost is not installed. I could add it but what password is Zoneminer using?
If it's zmpass, I have tried and sql wont accept that password.
Code: Select all
mysql> CREATE USER 'debian-sys-maint'@'localhost' IDENTIFIED BY 'zmpass';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements