Installation error

[klop2031]

I followed the instructions to install zoneminder from: https://wiki.zoneminder.com/Debian_10_B ... om_ZM_Repo but I am greeted with the following error:

Code: Select all

sudo apt install zoneminder
Reading package lists... Done
Building dependency tree       
Reading state information... Done
zoneminder is already the newest version (1.34.22-buster1).
The following packages were automatically installed and are no longer required:
  libmemcachedutil2 libmicrodns0 libva-wayland2 proftpd-doc rpi-eeprom-images
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 86 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up zoneminder (1.34.22-buster1) ...
Detected db service is mariadb.service
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Creating zm db
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Error creating db.
dpkg: error processing package zoneminder (--configure):
 installed zoneminder package post-installation script subprocess returned error exit status 1
Errors were encountered while processing:
 zoneminder
E: Sub-process /usr/bin/dpkg returned an error code (1)

Is there anything I can do?

[klop2031]

Ok followed this: viewtopic.php?t=26618 and it worked. Is there a way for me to change the db password?

[bkjaya1952]

Ok followed this: viewtopic.php?t=26618 and it worked. Is there a way for me to change the db password?

To change root password of mysql8

mysql

ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpassword';

FLUSH PRIVILEGES ;

quit

Creating zm sql data base

mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql

( If you get an error "ERROR 1050 (42S01) at line 1034: Table 'Sessions' already exists" due to existence of zm database ,when creating zm sql database , you will have to drop the existing zm database as follows on the Ubuntu terminal

mysql

drop database zm;

quit ) Then try again to create zm sql data base

mysql

CREATE USER 'zmuser'@localhost IDENTIFIED BY 'zmpass';

(If CREATE does not work try with ALTER )

GRANT ALL PRIVILEGES ON zm.* TO 'zmuser'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES ;

quit


Please refer the following link for more details

https://bkjaya.wordpress.com/2020/05/26 ... cal-fossa/

[klop2031]

Thank you!