Page 1 of 1

Clean install 1.32 after 1.30.4 on ubuntu 18.04.1

Posted: Mon Oct 01, 2018 2:44 pm
by Sigge
I was thinking of apt-get purge on both the .deb installed ZoneMinder and also on MySQL. Trying to start clean.
What will I miss that I will have to do manually? Zoneminder configuration in Apache? Do I need to remove that?

I used this procedure to install 1.30.4 on ubuntu 18.04.1 server:

https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way

Thanks,

Re: Clean install 1.32 after 1.30.4 on ubuntu 18.04.1

Posted: Mon Oct 01, 2018 2:49 pm
by bbunge
You should be OK if you add the zoneminder-master PPA.
then
apt update
service zoneinder stop
apt upgrade

You can also remove the "sql_mode = NO_ENGINE_SUBSTITUTION" from the my.cnf

If you are at all concerned about loosing settings take a dump (backup) of the zm database.

Re: Clean install 1.32 after 1.30.4 on ubuntu 18.04.1

Posted: Mon Oct 01, 2018 8:54 pm
by Sigge
Well, I just reinstalled the server to start fresh about 2 months ago. Then the motherboard got fried by lightning. Now it is up again but a new version of Zoneminder is out. Just thought I reinstall fresh since I have not done anything but install 1.30.4. Also want to give Maria db a new try. That will involve reinstalling Mysql anyway.

Re: Clean install 1.32 after 1.30.4 on ubuntu 18.04.1

Posted: Tue Oct 02, 2018 5:10 pm
by Sigge
If it helps anybody, this is what i did:

systemctl stop zoneminder.service
sudo apt-get purge zoneminder

This will tell you what is left to remove manually.

sudo mysqladmin --defaults-file=/etc/mysql/debian.cnf -f drop zm
sudo rm -rf /var/cache/zoneminder/*
systemctl disable var-cache-zoneminder-events.mount
systemctl disable var-cache-zoneminder-images.mount

sudo apt-get remove --purge mysql*
sudo apt-get purge mysql*
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-get remove dbconfig-mysql

sudo apt-get update
sudo apt-get upgrade
sudo apt-get dist-upgrade
sudo reboot

sudo apt-get install mariadb-server mariadb-client
nano zm-install (according to wiki.....)
chmod 755 zm-install
sudo su
./zm-install
exit
sudo mysql_secure_installation
sudo reboot


Seems to be working fine!

Re: Clean install 1.32 after 1.30.4 on ubuntu 18.04.1

Posted: Tue Oct 02, 2018 5:33 pm
by Sigge
Sorry, actually not working after reboot.

Webpage gives me: Unable to connect to ZM db.SQLSTATE[HY000] [2002] No such file or directory

sudo mysql -u root
[sudo] password for xyzs:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

Re: Clean install 1.32 after 1.30.4 on ubuntu 18.04.1

Posted: Tue Oct 02, 2018 8:26 pm
by Sigge
... and I am back up. Method used: Cut and past from random webpage.

Anyone know what I just did?

sudo apt-get install apparmor-utils
sudo aa-disable /usr/sbin/mysqld