Upgrading From 1.26.5 to 1.29 issue along the way.

[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.

[bbunge]

Did you follow the upgrade instructions on the WIKI?

[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.

[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

[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?

[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?

[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.

[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