Page 1 of 1
Upgrading From 1.26.5 to 1.29 issue along the way.
Posted: Tue Apr 19, 2016 9:11 pm
by dtruesdale
I have gotten the upgrade up to 1.28.108 and was getting this error ERROR 1142 (42000) at line 20: INDEX command denied to user 'zmuser'@'localhost' for table 'Frames'.
Followed some instructions on changing this and now get this error ERROR 1114 (HY000) at line 20: The table 'Frames' is full. Do I need to do something to clear this out or is this something that I did?
Running on Ubuntu 14.04 LTS on an Odroid Xu3.
Re: Upgrading From 1.26.5 to 1.29 issue along the way.
Posted: Tue Apr 19, 2016 9:27 pm
by bbunge
Did you follow the upgrade instructions on the WIKI?
Re: Upgrading From 1.26.5 to 1.29 issue along the way.
Posted: Tue Apr 19, 2016 9:37 pm
by dtruesdale
Yes ran zmupdate.pl and that is where the first error came from then once I followed your instructions to fix the priv issue. I then ran mysql -hlocalhost -uroot -pd(My Password) zm < /usr/share/zoneminder/db/zm_update-1.28.108.sql which gave me the table full issue.
Re: Upgrading From 1.26.5 to 1.29 issue along the way.
Posted: Wed Apr 20, 2016 1:53 am
by bbunge
You need to run
mysql -uroot -p -e "grant all on zm.* to 'zmuser'@localhost identified by 'zmpass';"
then
/usr/bin/zmupdate.pl
There are some new tables created in the database upgrade and you have to give the zmuser permission to add them. Not too sure if you can fix your database. If you took a backup before doing the upgrade, restore the database to its 1.26.5 configuration, set permissions, again, and run the upgrade.
Make sure you used these:
https://wiki.zoneminder.com/Common_Issu ... PA_version
Re: Upgrading From 1.26.5 to 1.29 issue along the way.
Posted: Wed Apr 20, 2016 4:47 am
by dtruesdale
bbunge,
I got it working I only have an issue now when I try to view thru the webpage. I can not stream individual or montage. I can use the cycle and I get streaming video. The other 2 I get no box of streaming video. I basically dumped the db and created a new one. I have been adding back in my cameras. I can also stream the cameras using my phone and the app zmview. Any ideas here?
Re: Upgrading From 1.26.5 to 1.29 issue along the way.
Posted: Wed Apr 20, 2016 5:56 pm
by dtruesdale
This is confusing, I get stream in cycle view but not montage or individual camera views. I also get stream in an app like zmview. Any ideas?
Re: Upgrading From 1.26.5 to 1.29 issue along the way.
Posted: Thu Apr 21, 2016 12:55 am
by bbunge
Yup, the last step in the upgrade
Open Zoneminder. Click on Options - Paths
Change PATH_ZMS to /zm/cgi-bin/nph-zms
Make sure there is no trailing space after the entry.
Re: Upgrading From 1.26.5 to 1.29 issue along the way.
Posted: Thu Apr 21, 2016 2:57 pm
by dtruesdale
Actually I did that with the path. I get the stream in the cycle for all cameras. In Montage or individual view I get nothing. It also works with the app ZMview without issue.
Any time I open Montage or an individual camera I get this in the logs:
2016-04-21 10:56:18.306382 web_php 17064 ERR socket_sendto( /var/run/zm/zms-135141s.sock ) failed: No such file or directory /usr/share/zoneminder/www/includes/functions.php 2371
2016-04-21 10:56:18.284461 web_php 1384 ERR socket_sendto( /var/run/zm/zms-676645s.sock ) failed: No such file or directory /usr/share/zoneminder/www/includes/functions.php 2371