EasyWay Guide for Storage Areas on Ubuntu 16.04 not working

Forum for questions and support relating to the 1.31.x releases only.
Post Reply
ndoggac
Posts: 4
Joined: Sun Apr 06, 2014 11:47 pm

EasyWay Guide for Storage Areas on Ubuntu 16.04 not working

Post by ndoggac » Wed Dec 20, 2017 8:38 pm

Followed the Ubuntu 16.04 easy way guide step by step twice through to try and install the StorageAreas version of ZM on a brand new 16.04 LXC container, fully updated.

The command "apt-get install zoneminder" errors out at the end with a dpkg error, and attempting another apt upgrade shows 1 package not fully installed or removed. Tried continuing with the guide...

The following command:

Code: Select all

mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql
Resulted in the following error:

Code: Select all

Enter password:
ERROR 1064 (42000) at line 277: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--Table structure for table `Groups_Monitors`
DROP TABLE IF EXISTS `Groups_Mon' at line 1
Any help would be appreciated. I have the main version of ZM running in a different LXC container with no issues.

bbunge
Posts: 2704
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: EasyWay Guide for Storage Areas on Ubuntu 16.04 not working

Post by bbunge » Wed Dec 20, 2017 8:43 pm

Those instructions were written for 1.30.4. The version you are using is still in testing so might not work. Sorry. Also do not support installing to a container.

User avatar
iconnor
Posts: 1345
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: EasyWay Guide for Storage Areas on Ubuntu 16.04 not working

Post by iconnor » Thu Dec 21, 2017 12:47 pm

The instructions should work for 1.31.* as well.

I had a missing semi colon. Please try the latest packages.

ndoggac
Posts: 4
Joined: Sun Apr 06, 2014 11:47 pm

Re: EasyWay Guide for Storage Areas on Ubuntu 16.04 not working

Post by ndoggac » Thu Dec 21, 2017 9:35 pm

Code: Select all

IGNORE: Thanks, it worked this time around.  Zoneminder StorageSpaces installed correctly from PPA, and the SQL import worked.  
Since its release (Ubuntu 16.04 LTS) I've been using an LXC container on Proxmox host OS and everything has worked great. From the ZM perspective, it shouldn't look or behave any different than an Ubuntu server on bare metal.

Edit: Sorry, I accidentally used the stable ppa instead of the storage spaces ppa. The error still remains. Line 277, zoneminder does not complete installation. This time I didn't proceed to the SQL import step.

bbunge
Posts: 2704
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: EasyWay Guide for Storage Areas on Ubuntu 16.04 not working

Post by bbunge » Thu Dec 21, 2017 11:25 pm

Ah, there is no SQL import step in the basic install. Zoneminder will install the database automatically in this version of the install. I do discuss exporting and importing databases if you switch from MySQL to Mariadb but you should not have to do that if you are doing a fresh install of Zonemnder.

Just to be sure you are using the right instructions...

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

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests