Playback event don't work

and12345 · Post by **and12345** » Sun Apr 18, 2010 8:48 am

hi i've setup zoneminder on ubuntu 9.04 and it's work like a charm now, but there's still one problem... don't know why event playback isn't working.

mastertheknife · Post by **mastertheknife** » Sun Apr 18, 2010 8:56 am

Hi,

First, make sure you are using JPEG streaming mode and not MPEG because MPEG is buggy.
Your problem may be that your browser lacks java. I think what happens is ZM thinking your browser doesn't support JPEG streaming natively and tries to load Cambozola. Cambozola is a java applet for streaming JPEGs for browsers that don't support JPEG streaming natively, such as Internet Explorer.
For cambozola to work, You need to enable cambozola in the settings and also verify that cambozola.jar is present in ZM's root folder (where index.php is)
I also recommend upgrading cambozola to latest version (replace cambozola.jar):
http://www.charliemouse.com/code/cambozola/
Here is a patch i wrote to fix ZM's auto detection to support more browsers for JPEG streaming mode, this may be useful for you because it seems you are using Safari.
http://www.zoneminder.com/forums/viewtopic.php?t=15429
If you experience bugs, here you can find fixes to some of them:
http://www.zoneminder.com/wiki/index.ph ... 2_Bugfixes

mastertheknife.

and12345 · Post by **and12345** » Sun Apr 18, 2010 11:24 am

first of all thanks for the quick reply

yes i've using JPEG streaming mode, and i've been download and enabled cambozola on my ZM root folder.

when i view live streaming and montage, the camera is working (i tried using both firefox and safari) the problem is only occurs when i'm doing playback of events.

mastertheknife · Post by **mastertheknife** » Sun Apr 18, 2010 11:51 am

Maybe zms is crashing when trying to play an event.

Can you post some of your system log? (tail -n30 /var/log/messages for example)

and12345 · Post by **and12345** » Sun Apr 18, 2010 12:15 pm

this is the log message when i tried to playback an event

Apr 18 19:12:05 myhomeCCTV zma_m10[13724]: INF [Belakang-Tengah: 617000 - Processing at 24.39 fps]
Apr 18 19:12:14 myhomeCCTV zmc_dvideo6[13722]: INF [Belakang-Tengah: 619000 - Capturing at 24.39 fps]
Apr 18 19:12:14 myhomeCCTV zma_m9[13720]: INF [Kiri-Depan: 617000 - Processing at 25.00 fps]
Apr 18 19:12:15 myhomeCCTV zmc_dvideo0[13714]: INF [Kanan-Depan: 619000 - Capturing at 24.39 fps]
Apr 18 19:12:16 myhomeCCTV zms[10602]: INF [Debug Level = 0, Debug Log = <none>]
Apr 18 19:12:16 myhomeCCTV zms[10602]: INF [Authenticated user 'myhome']
Apr 18 19:12:17 myhomeCCTV zmc_dvideo7[13710]: INF [Entry-Hall: 620000 - Capturing at 24.39 fps]
Apr 18 19:12:24 myhomeCCTV zma_m6[13712]: INF [Entry-Hall: 618000 - Processing at 24.39 fps]
Apr 18 19:12:24 myhomeCCTV zmc_dvideo4[13718]: INF [Kiri-Depan: 619000 - Capturing at 24.39 fps]
Apr 18 19:12:31 myhomeCCTV zms[10603]: INF [Debug Level = 0, Debug Log = <none>]
Apr 18 19:12:31 myhomeCCTV zms[10604]: INF [Debug Level = 0, Debug Log = <none>]
Apr 18 19:12:31 myhomeCCTV zms[10603]: INF [Authenticated user 'myhome']
Apr 18 19:12:31 myhomeCCTV zms[10604]: INF [Authenticated user 'myhome']
Apr 18 19:12:41 myhomeCCTV zma_m11[13716]: INF [Kanan-Depan: 618000 - Processing at 24.39 fps]
Apr 18 19:12:46 myhomeCCTV zma_m10[13724]: INF [Belakang-Tengah: 618000 - Processing at 24.39 fps]

and12345 · Post by **and12345** » Sun Apr 18, 2010 5:40 pm

looks like there's a problem with the cambozola, when i tried to browse the zm server from Blackberry, Internet Explorer and Android phones, the streaming didn't work at all.

I'm just wondering if there's something i miss on installing cambozola, coz i've download it and put it in the same directory with my zm root directory - setting up the file permission for 775, and i've checked out the cgi-bin directory (make sure it's where it should be and the file permission)

mastertheknife · Post by **mastertheknife** » Sun Apr 18, 2010 6:03 pm

Try downloading the cambozola file, does it let you download it, or give you an error such 403 forbidden?
If your ZM's path is http://your-address/index.php, cambozola should be http://your-address/cambozola.jar
It does not need to be in cgi-bin folder.

If you suspect the problem is cambozola, you can set in options CAN_STREAM to "yes", this disables ZM's auto detection and tells ZM to use native jpeg streaming for all browsers, even for IE.

and12345 · Post by **and12345** » Sat May 01, 2010 6:22 am

yes, i've tried to download combozola from my ip and it can downloaded....

i've verify that cambozola is running - when i tried to montage view on IE, it ask me whether i should trust the java applet from charliemouse.
the problem is :
- i still can't get event preview from any browser (in IE it's even worse - i can't view the liveview from 1 camera)
- the blackberry and android browser still can't get live view (it just preview the first frame - you have to refresh it for the view) either (but the live view works on iPhone's Safari)

eronquillo · Post by **eronquillo** » Mon Dec 13, 2010 12:24 am

I'm having a problem playing back the events as well. I get the following in my syslog. Any help is greatly appreciated!

[Sun Dec 12 19:22:10 2010] [error] [client 172.29.0.194] socket_sendto( /tmp/zms-898886s.sock ) failed: No such file or directory, referer: http://192.168.3.20/zm/index.php?view=e ... 1=6&page=1
[Sun Dec 12 19:22:10 2010] [error] [client 172.29.0.194] array (\n 0 => \n array (\n 'file' => '/usr/share/zoneminder/www/ajax/stream.php',\n 'line' => 55,\n 'function' => 'ajaxError',\n 'args' => \n array (\n 0 => 'socket_sendto( /tmp/zms-898886s.sock ) failed: No such file or directory',\n ),\n ),\n 1 => \n array (\n 'file' => '/usr/share/zoneminder/www/index.php',\n 'line' => 120,\n 'args' => \n array (\n 0 => '/usr/share/zoneminder/www/ajax/stream.php',\n ),\n 'function' => 'require_once',\n ),\n), referer: http://192.168.3.20/zm/index.php?view=e ... 1=6&page=1
[Sun Dec 12 19:22:10 2010] [error] [client 172.29.0.194] SQL-ERROR(4A08A8): select Events.Id as Id, MonitorId, Name, Cause, StartTime, date_format( StartTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, EndTime, Width, Height, Length, Frames, AlarmFrames, TotScore, AvgScore, MaxScore, Archived, Videoed, Uploaded, Emailed, Messaged, Executed, Notes, min(Frames.FrameId) as MinFrameId, max(Frames.FrameId) as MaxFrameId, min(Frames.Delta) as MinFrameDelta, max(Frames.Delta) as MaxFrameDelta from Events left join Frames on Events.Id = Frames.EventId where Events.Id = undefined group by Frames.EventId limit 1, referer: http://192.168.3.20/zm/index.php?view=e ... 1=6&page=1
[Sun Dec 12 19:22:10 2010] [error] [client 172.29.0.194] SQL-ERROR(4A08A8): Unknown column 'undefined' in 'where clause', referer: http://192.168.3.20/zm/index.php?view=e ... 1=6&page=1

henke · Post by **henke** » Sat Jan 15, 2011 9:10 pm

I am seeing that SQL error as well after upgrading from 1.22.3.

select Events.Id as Id, MonitorId, Name, Cause, StartTime, date_format( StartTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, EndTime, Width, Height, Length, Frames, AlarmFrames, TotScore, AvgScore, MaxScore, Archived, Videoed, Uploaded, Emailed, Messaged, Executed, Notes, min(Frames.FrameId) as MinFrameId, max(Frames.FrameId) as MaxFrameId, min(Frames.Delta) as MinFrameDelta, max(Frames.Delta) as MaxFrameDelta from Events left join Frames on Events.Id = Frames.EventId where Events.Id = undefined group by Frames.EventId limit 1

[Sat Jan 15 23:11:46 2011] [error] [client 212.16.106.53] SQL-ERROR(36BD54): Unknown column 'undefined' in 'where clause',

Did you find a solution for it?

update: ok, happens only in google chrome. firefox works well.