Zoneminer install fails on SQL login

Forum for questions and support relating to the 1.34.x releases only.
Post Reply
3dgraph
Posts: 1
Joined: Fri Feb 28, 2020 11:47 pm

Zoneminer install fails on SQL login

Post by 3dgraph »

I am running Ubuntu server 19.10
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 :oops: )
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 have no idea how to use sql. I only follow tultorials that I found searching when I ran into trouble
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
What should I do now.
bbunge
Posts: 2934
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: Zoneminer install fails on SQL login

Post by bbunge »

Read the instructions:
https://wiki.zoneminder.com/Ubuntu_Serv ... der_1.34.x
If you are using MySQL there is a section on additional steps that need to be done before running the Zoneminder install
Post Reply