Web interface won't load after update

Forum for questions and support relating to the 1.28.x releases only.
Jzjr
Posts: 8
Joined: Tue Oct 06, 2015 9:03 pm

Web interface won't load after update

Post by Jzjr »

Hello,

Zoneminder updated today and when I try to start zm I get:

Code: Select all

user@ubuntu:~$ sudo service zoneminder start
Starting ZoneMinder: DBD::mysql::st execute failed: Unknown column 'IsActive' in 'field list' at /usr/bin/zmpkg.pl line 333.
failure

I am new to Linux and use it as a home automation and security server. If anyone could help it would be greatly appreciated, I am expecting my new IP cameras in the next few days, I would really like this fixed before they arrive!

Thanks in advanced
Fred
Last edited by Jzjr on Sat Oct 17, 2015 11:05 am, edited 2 times in total.
bbunge
Posts: 2956
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: Problem starting service

Post by bbunge »

You need to manually update your database. If you are using Ubuntu there are upgrade instructions on the WIKI.
http://www.zoneminder.com/forums/viewto ... 32&t=23551
bb
Jzjr
Posts: 8
Joined: Tue Oct 06, 2015 9:03 pm

Re: Problem starting service

Post by Jzjr »

Thanks for your swift reply,

I have followed the instructions and have got to:

Open Zoneminder.
Click on Options - Paths
Change PATH_ZMS to /zm/cgi-bin/nph-zms


To do this I presume I have to access the UI at 'server-ip/zm' but I get an error. It appears there is no service at /zm.

As part of the update process I removed the symbolic link but there was no mention of re-creating this, does this need doing?

Thanks
Fred.


EDIT:
My fault I was trying to access https rather than http.

Now I get the error
Cannot write to content dirs('events','images'). Check that these exist and are owned by the web account user
I presume this is a simple permissions fix but I don't know which permissions or files need changing.

Thanks,
Fred.
Last edited by Jzjr on Fri Oct 16, 2015 9:11 pm, edited 1 time in total.
bbunge
Posts: 2956
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: Problem starting service

Post by bbunge »

Ubuntu version?
Jzjr
Posts: 8
Joined: Tue Oct 06, 2015 9:03 pm

Re: Problem starting service

Post by Jzjr »

Sorry,

I edited the above post as I made a stupid mistake :lol: :oops:

It is version 14.04.3
Jzjr
Posts: 8
Joined: Tue Oct 06, 2015 9:03 pm

Re: Problem starting service

Post by Jzjr »

Now I get the error
Cannot write to content dirs('events','images'). Check that these exist and are owned by the web account user
I presume this is a simple permissions fix but I don't know which permissions or files need changing.

Thanks,
Fred.[/quote]
bbunge
Posts: 2956
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: Problem starting service

Post by bbunge »

Read the upgrade instructions posted in the WIKI
Jzjr
Posts: 8
Joined: Tue Oct 06, 2015 9:03 pm

Re: Problem starting service

Post by Jzjr »

Hi,

I have gone back through the Wiki and followed every step regarding Ubuntu 14.04 and am still finding that loading up the web UI for Zoneminder presents me with:
Cannot write to content dirs('events','images'). Check that these exist and are owned by the web account user
I don't see any mention of these in the instructions.

Thanks,
Fred.
Jzjr
Posts: 8
Joined: Tue Oct 06, 2015 9:03 pm

Re: Web interface won't load after update

Post by Jzjr »

I have gone through the Wiki again today to see if I missed something and am still finding the issue. Where are the directories 'events' and 'images'? Would a simple chmod command fix this issue?
bbunge
Posts: 2956
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: Web interface won't load after update

Post by bbunge »

Might be best to start over with a fresh Ubuntu install...
Jzjr
Posts: 8
Joined: Tue Oct 06, 2015 9:03 pm

Re: Web interface won't load after update

Post by Jzjr »

Okay, I haven't set up any cameras yet as they are taking a while in the post so I will do that as I have nothing to lose.

Thanks,
Fred.
tyler_h
Posts: 20
Joined: Mon Feb 09, 2015 4:47 pm

Re: Web interface won't load after update

Post by tyler_h »

Im having similar issues after trying to upgrade. I cant seem to start the service. I've purged LAMP and Zoneminder, re-installed everything and can only show the two directories @ localhost/zm Going to localhost/zm/www shows an error of "could not open config file"

I tried..
> ln -s /etc/zm/apache.conf /etc/apache2/conf-enabled/zoneminder.conf
with no results. Any ideas?


server ZoneMinder-1.28.1 # service zoneminder status
DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/share/perl5/ZoneMinder/Config.pm line 99.
Can't execute: Table 'zm.Config' doesn't exist at /usr/share/perl5/ZoneMinder/Config.pm line 105.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 105.
Compilation failed in require at /usr/share/perl5/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder.pm line 33.
Compilation failed in require at /usr/bin/zmpkg.pl line 48.
BEGIN failed--compilation aborted at /usr/bin/zmpkg.pl line 48.
ZoneMinder is stopped
bbunge
Posts: 2956
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: Web interface won't load after update

Post by bbunge »

Did you follow the installation instructions in the WIKI?

bb
tyler_h
Posts: 20
Joined: Mon Feb 09, 2015 4:47 pm

Re: Web interface won't load after update

Post by tyler_h »

I did follow the new updated instructions on the WIKI. I get the same error when trying to update the database. I dont even know where to begin trouble shooting :/
PacoLM
Posts: 971
Joined: Wed Dec 02, 2009 9:55 pm
Location: Spain

Re: Web interface won't load after update

Post by PacoLM »

tyler_h wrote:Im having similar issues after trying to upgrade. I cant seem to start the service. I've purged LAMP and Zoneminder, re-installed everything and can only show the two directories @ localhost/zm Going to localhost/zm/www shows an error of "could not open config file"

I tried..
> ln -s /etc/zm/apache.conf /etc/apache2/conf-enabled/zoneminder.conf
with no results. Any ideas?


server ZoneMinder-1.28.1 # service zoneminder status
DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/share/perl5/ZoneMinder/Config.pm line 99.
Can't execute: Table 'zm.Config' doesn't exist at /usr/share/perl5/ZoneMinder/Config.pm line 105.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 105.
Compilation failed in require at /usr/share/perl5/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder.pm line 33.
Compilation failed in require at /usr/bin/zmpkg.pl line 48.
BEGIN failed--compilation aborted at /usr/bin/zmpkg.pl line 48.
ZoneMinder is stopped
What happens if you execute the same command as root?

sudo service zoneminder status

Regards,

PacoLM

After more than 15 years, no longer using ZM as surveillance system.
Now in the dark side, using a commercial system...
Locked