HOW TO INSTALL ZONEMINDER, v1.34.0. ON UBUNTU 19.10 (eoan), with mysql 8

 

Today, Mr. Isaac Connor has published the  first successful Zoneminder-master-eoan  package for Ubuntu 19.10. in his website .
To avoid errors when installing Zoneminder , MySQL-server is installed first.
Installation of MySQL-server

On the Ubuntu terminal

sudo su

apt install mysql-server

rm /etc/mysql/my.cnf

cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/my.cnf

sed -i "15i default_authentication_plugin= mysql_native_password" /etc/mysql/my.cnf

/etc/init.d/mysql start

mysql 

CREATE USER 'admin'@'localhost' IDENTIFIED WITH mysql_native_password BY '';

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

FLUSH PRIVILEGES ;

quit

mysqladmin -uroot -p reload

Installation of Zoneminder
To install Zoneminder Please refer Connor’s web site Open the terminal and run following commands.

mysql

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

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

FLUSH PRIVILEGES ;

quit

mysqladmin -uroot -p reload

sudo add-apt-repository ppa:iconnor/zoneminder-master 

sudo apt-get update 

sudo apt install zoneminder

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

mysqladmin -uroot -p reload

chmod 740 /etc/zm/zm.conf

chown root:www-data /etc/zm/zm.conf

adduser www-data video

a2enmod cgi

a2enconf zoneminder

a2enmod rewrite

chown -R www-data:www-data /usr/share/zoneminder/

systemctl enable zoneminder

service zoneminder start

service apache2 reload

Open zoneminder web console (http://localhost/zm/)

Figure :- Montage of 2 cameras after adding USB Cam & IP Cam

You can see the USB camera  and a Hikvision IP camera are  working in the above figure

Note:- If you fail and get an error ( ERROR 1396 (HY000)) ,when creating mysql user with “CREATE USER” , that means there is already a user. In that case please replace it with  “ALTER USER” .

If you get “MySQL: “Access denied for user ‘debian-sys-maint’@’localhost’”” when updating zoneminder , you can correct it by making following changes.

On the Ubuntu terminal

sudo gedit /etc/mysql/debian.cnf

Then you can see the automatically generated debian password for mysql

as follows in the opened “debian.cnf” file

( In your case , you may  get a different password)

---

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = s4bSHUP05s1J32G5
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = s4bSHUP05s1J32G5
socket = /var/run/mysqld/mysqld.sock

---

Now you will have to grant permissions to ‘debian-sys-maint’@’localhost’” as follows

ALTER USER 'debian-sys-maint'@localhost IDENTIFIED WITH mysql_native_password BY 's4abSHUP05s1J32G5';

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' WITH GRANT OPTION;

quit

sudo /etc/init.d/mysql restart