Since the official Zoneminder eoan has Dependency wait on lgw01-amd64-051 , We will have to install Zoneminder disco on Ubuntu 19.10. There is a problem in the present PHP release which make errors with the “caching_sha2_password” introduced in the Mysql 8 by default . Please refer the following link https://www.php.net/manual/en/mysqli.requirements.php Therefore , we will have to use “mysql_native_password” method in Mysql 8. First of all we will have to install mysql-server-8 on Ubuntu 19.10 and enable mysql_native_password The installation of mysql-server-8.0 can be done using the synaptic package manager . Figure:-1 Installed mysql-server-8 shown in synaptic package manager Then open the Ubuntu terminal sudo su rm /etc/mysql/my.cnf cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/my.cnf Then you will have to enter the following line below [mysqld] ( line no 15 ) in my.cnf file default_authentication_plugin= mysql_native_password On the Ubuntu terminal sudo su sed -i "15i default_authentication_plugin= mysql_native_password" /etc/mysql/my.cnf systemctl restart mysql Then enter the following commands on the terminal to set root password for mysql server mysql CREATE USER 'admin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your password'; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES ; quit systemctl restart mysql Then install Zoneminder The Zoneminder disco deb file is downloaded from https://launchpad.net/~iconnor/+archive/ubuntu/zoneminder-master/+build/18492553/+files/zoneminder_1.33.16~20191229135312-disco_amd64.deb GDebi Package Installer can be used to install the Zoneminder disco deb file Before installing Zoneminder disco deb file to overcome dependency issues we will have to download libmysqlclient20and install first using the GDebi Package Installer. Then install Zoneminder disco deb file that we have downloaded . Creating user and zmpass Open the Ubuntu terminal and enter following 5 commands sudo su mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql 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 It was observed that there are missing *.ini files in /etc/php/7.3/mods-available/ which will make problems in getting zoneminder Console. Therefore the necessary files have to be copied from /usr/share/php7.3-mysql/mysql sudo cp /usr/share/php7.3-mysql/mysql/*.ini /etc/php/7.3/mods-available/ sudo service apache2 reload Figure:- 2 & 3 files in foler /usr/share/php7.3-mysql/mysql/ and /usr/share/php7.3-mysql/mysql/ after coping ini files 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 Figure:-4 Zoneminder Console , after adding an Usb camera
(Note :- In order to have clean mysql-server-8.0 install , it is better to completely delete exiting mysql as follows sudo apt remove --purge mysql-server mysql-client mysql-common sudo apt autoremove sudo apt autoclean sudo rm -rf /etc/mysql )
0 Comments
Leave a Reply. |
AuthorRetired Director of Irrigation ,Sri Lanka Categories
All
Archives
March 2020
|