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

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/)

Screenshot from 2020-01-23 10-17-45
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

Comments

Popular posts from this blog

How to install ivms4200-linux docker image on Ubuntu 19.10 (eoan)

how to use bkjaya1952/smath-studio (a docker repository of SMath Studio-0.99.7030) on Ubuntu 19.10 (eoan)

A Solution to the installation problem of ZONEMINDER,v1.33.14.ON UBUNTU 19.10 (Eoan Ermine) using Mriadb instead of mysql-server-8.0