Page 1 of 2
Web interface won't load after update
Posted: Fri Oct 16, 2015 8:31 pm
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
Re: Problem starting service
Posted: Fri Oct 16, 2015 8:34 pm
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
Re: Problem starting service
Posted: Fri Oct 16, 2015 8:59 pm
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.
Re: Problem starting service
Posted: Fri Oct 16, 2015 9:09 pm
by bbunge
Ubuntu version?
Re: Problem starting service
Posted: Fri Oct 16, 2015 9:11 pm
by Jzjr
Sorry,
I edited the above post as I made a stupid mistake
It is version 14.04.3
Re: Problem starting service
Posted: Fri Oct 16, 2015 9:42 pm
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]
Re: Problem starting service
Posted: Fri Oct 16, 2015 9:52 pm
by bbunge
Read the upgrade instructions posted in the WIKI
Re: Problem starting service
Posted: Fri Oct 16, 2015 10:06 pm
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.
Re: Web interface won't load after update
Posted: Sat Oct 17, 2015 12:30 pm
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?
Re: Web interface won't load after update
Posted: Sat Oct 17, 2015 1:53 pm
by bbunge
Might be best to start over with a fresh Ubuntu install...
Re: Web interface won't load after update
Posted: Sat Oct 17, 2015 2:19 pm
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.
Re: Web interface won't load after update
Posted: Sun Oct 18, 2015 8:11 pm
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
Re: Web interface won't load after update
Posted: Sun Oct 18, 2015 8:55 pm
by bbunge
Did you follow the installation instructions in the WIKI?
bb
Re: Web interface won't load after update
Posted: Mon Oct 19, 2015 12:11 am
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 :/
Re: Web interface won't load after update
Posted: Mon Oct 19, 2015 8:27 am
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