DB Problem...

Jiberjaber · Post by **Jiberjaber** » Mon Jan 02, 2006 6:55 pm

OK, after a good afternoon of thrashing around, I have managed get 1.22.0 up and running.

1. When updating the database, the version number that goes in after -v should be the version number of the on you are upgrading from? (I didnt realise this till after I deleted the database thinking it was something else wrong! <--- newbie error I guess

)

2. Every now and again I keep getting the following message in the add new monitor window:

Code: Select all

Unknown column 'Coords' in 'field list'

Symptom of a new database install ? might not be present for those who have upgraded. ? This occurs after trying to save the field.

3. Add monitor window needs to be slightliy larger, the SAVE and CLOSE buttons in the SOURCE tab are below the edge of the window and are only visable when you re-size it. (occurs in Opera Linux but not Opera Win32!)

4. If you add a monitor, but only get so far as entering the name and preliminary details under the general tab, there is no way once you have saved the closed the add-monitor window of going back and adding other details. (This was something I noticed in the last version). Maybe have a default (I have placed the value as "Defaul Value" now instead of NULL) entry placed in the source tab for the remote host name etc..

So... currently no images on the system to play with but I think this may be linking in to the "coords" issue listed above..

Post by **cordel** » Mon Jan 02, 2006 8:00 pm

Jiberjaber wrote: 4. If you add a monitor, but only get so far as entering the name and preliminary details under the general tab, there is no way once you have saved the closed the add-monitor window of going back and adding other details. (This was something I noticed in the last version). Maybe have a default (I have placed the value as "Default Value" now instead of NULL) entry placed in the source tab for the remote host name etc..

I just checked 1.21.4 that I have installed here and I can go back in and edit any field. Of course the source shows as "0"

Regards,
Corey

Jiberjaber · Post by **Jiberjaber** » Mon Jan 02, 2006 10:51 pm

cordel wrote:
Jiberjaber wrote: 4. If you add a monitor, but only get so far as entering the name and preliminary details under the general tab, there is no way once you have saved the closed the add-monitor window of going back and adding other details. (This was something I noticed in the last version). Maybe have a default (I have placed the value as "Default Value" now instead of NULL) entry placed in the source tab for the remote host name etc..
I just checked 1.21.4 that I have installed here and I can go back in and edit any field. Of course the source shows as "0"

Regards,
Corey

Yep, I just noticed that clicking on the monitor number actualy opens up the add-monitor window, so no probs there... I am still experiencing the coords issue, which is showing itself in the messages log file now, I'll post the details up from the other machine.

Jiberjaber · Post by **Jiberjaber** » Mon Jan 02, 2006 11:27 pm

OK, if I add a monitor upon first starting, things are fine (in that I dont get the coords message). Any subsequent ones throw up the coords message.

Looks like something is upsetting the watchdog?

Nothing is getting picked up from the Axis video server nor the PCI capture card.

Nothing in the mysql log.

In a moment of madness so I could see the contents of the messages log, I deleted it, which means the reference I saw in there to the "coords" issue is gone

sorry.

Log as prommised:

Code: Select all

ZM Log 23:00

[root@FC4 ~]# more /tmp/zm*.log
::::::::::::::
/tmp/zmaudit.log
::::::::::::::
::::::::::::::
/tmp/zmdc.log
::::::::::::::
01/02/2006 22:56:55.637450 zmdc[3204].INF [Server starting at 06/01/02 22:56:55]
01/02/2006 22:56:58.889920 zmdc[3228].INF ['zmfilter.pl' started at 06/01/02 22:56:58]
01/02/2006 22:56:58.892012 zmdc[3204].INF ['zmfilter.pl' starting at 06/01/02 22:56:58, pid = 3228]
01/02/2006 22:56:59.473833 zmdc[3234].INF ['zmaudit.pl -d 900 -y' started at 06/01/02 22:56:59]
01/02/2006 22:56:59.479515 zmdc[3204].INF ['zmaudit.pl -d 900 -y' starting at 06/01/02 22:56:59, pid = 3234]
01/02/2006 22:56:59.911636 zmdc[3204].INF ['zmwatch.pl' starting at 06/01/02 22:56:59, pid = 3240]
01/02/2006 22:56:59.913015 zmdc[3240].INF ['zmwatch.pl' started at 06/01/02 22:56:59]
01/02/2006 22:57:00.335649 zmdc[3204].INF ['zmupdate.pl -c' starting at 06/01/02 22:57:00, pid = 3245]
01/02/2006 22:57:00.336887 zmdc[3245].INF ['zmupdate.pl -c' started at 06/01/02 22:57:00]
::::::::::::::
/tmp/zmfilter.log
::::::::::::::
01/02/2006 22:56:59.233963 zmfilter[3228].INF [Scanning for events]
::::::::::::::
/tmp/zmpkg.log
::::::::::::::
01/02/2006 22:56:55.110445 zmpkg[3185].INF [Command: start]
::::::::::::::
/tmp/zmupdate.log
::::::::::::::
Update agent starting at 06/01/02 22:57:00
::::::::::::::
/tmp/zmwatch.log
::::::::::::::
01/02/2006 22:57:00.101103 zmwatch[3240].INF [Watchdog starting]
01/02/2006 22:57:00.101854 zmwatch[3240].INF [Watchdog pausing for 30 seconds]
01/02/2006 23:01:10.204005 zmwatch[3240].ERR [Can't get shared memory id '%x', %d: No such file or directory]
[root@FC4 ~]# more /tmp/zm*.log
::::::::::::::
/tmp/zmaudit.log
::::::::::::::
::::::::::::::
/tmp/zmdc.log
::::::::::::::
01/02/2006 22:56:55.637450 zmdc[3204].INF [Server starting at 06/01/02 22:56:55]
01/02/2006 22:56:58.889920 zmdc[3228].INF ['zmfilter.pl' started at 06/01/02 22:56:58]
01/02/2006 22:56:58.892012 zmdc[3204].INF ['zmfilter.pl' starting at 06/01/02 22:56:58, pid = 3228]
01/02/2006 22:56:59.473833 zmdc[3234].INF ['zmaudit.pl -d 900 -y' started at 06/01/02 22:56:59]
01/02/2006 22:56:59.479515 zmdc[3204].INF ['zmaudit.pl -d 900 -y' starting at 06/01/02 22:56:59, pid = 3234]
01/02/2006 22:56:59.911636 zmdc[3204].INF ['zmwatch.pl' starting at 06/01/02 22:56:59, pid = 3240]
01/02/2006 22:56:59.913015 zmdc[3240].INF ['zmwatch.pl' started at 06/01/02 22:56:59]
01/02/2006 22:57:00.335649 zmdc[3204].INF ['zmupdate.pl -c' starting at 06/01/02 22:57:00, pid = 3245]
01/02/2006 22:57:00.336887 zmdc[3245].INF ['zmupdate.pl -c' started at 06/01/02 22:57:00]
::::::::::::::
/tmp/zmfilter.log
::::::::::::::
01/02/2006 22:56:59.233963 zmfilter[3228].INF [Scanning for events]
::::::::::::::
/tmp/zmpkg.log
::::::::::::::
01/02/2006 22:56:55.110445 zmpkg[3185].INF [Command: start]
::::::::::::::
/tmp/zmupdate.log
::::::::::::::
Update agent starting at 06/01/02 22:57:00
::::::::::::::
/tmp/zmwatch.log
::::::::::::::
01/02/2006 22:57:00.101103 zmwatch[3240].INF [Watchdog starting]
01/02/2006 22:57:00.101854 zmwatch[3240].INF [Watchdog pausing for 30 seconds]
01/02/2006 23:01:10.204005 zmwatch[3240].ERR [Can't get shared memory id '%x', %d: No such file or directory]
01/02/2006 23:01:20.208235 zmwatch[3240].ERR [Can't get shared memory id '%x', %d: No such file or directory]
01/02/2006 23:01:30.212680 zmwatch[3240].ERR [Can't get shared memory id '%x', %d: No such file or directory]

[root@FC4 ~]# tail /var/log/messages
Jan  2 22:57:00 FC4 zmdc[3245]: INF ['zmupdate.pl -c' started at 06/01/02 22:57:00 ]
Jan  2 22:57:00 FC4 su(pam_unix)[3242]: session closed for user apache
Jan  2 22:59:56 FC4 ntpd[2259]: kernel time sync enabled 0001
Jan  2 23:00:01 FC4 crond(pam_unix)[3285]: session opened for user root by (uid=0)
Jan  2 23:00:01 FC4 crond(pam_unix)[3287]: session opened for user root by (uid=0)
Jan  2 23:00:01 FC4 crond(pam_unix)[3285]: session closed for user root
Jan  2 23:00:01 FC4 crond(pam_unix)[3287]: session closed for user root
Jan  2 23:01:01 FC4 crond(pam_unix)[3301]: session opened for user root by (uid=0)
Jan  2 23:01:01 FC4 crond(pam_unix)[3301]: session closed for user root
Jan  2 23:01:10 FC4 zmwatch[3240]: ERR [Can't get shared memory id '%x', %d: No such file or directory ]
[root@FC4 ~]#

Code: Select all

[root@FC4 html]# zmu -q -d /dev/video0 -v
Video Capabilities
  Name: BT848A video (Euresys Picolo)
  Type: 171
    Can capture
    Can tune
    Overlay onto frame buffer
    Can clip
    Scalable
  Video Channels: 3
  Audio Channels: 0
  Maximum Width: 924
  Maximum Height: 576
  Minimum Width: 48
  Minimum Height: 32
Window Attributes
  X Offset: 0
  Y Offset: 0
  Width: 384
  Height: 288
Picture Attributes
  Palette: 4 - 24bit RGB
  Colour Depth: 24
  Brightness: 32768
  Hue: 32768
  Colour :32768
  Contrast: 32768
  Whiteness: 0
Channel 0 Attributes
  Name: Composite0
  Channel: 0
  Flags: 2
    Channel has audio
  Type: 2 - Camera
  Format: 0 - PAL
Channel 1 Attributes
  Name: Composite1
  Channel: 1
  Flags: 2
    Channel has audio
  Type: 2 - Camera
  Format: 0 - PAL
Channel 2 Attributes
  Name: S-Video
  Channel: 2
  Flags: 2
    Channel has audio
  Type: 2 - Camera
  Format: 0 - PAL

Jiberjaber · Post by **Jiberjaber** » Mon Jan 02, 2006 11:45 pm

Knew if I waited long enough...... sorry for the long post

Code: Select all

Jan  2 23:10:10 FC4 zmwatch[3240]: ERR [Can't get shared memory id '%x', %d: No such file or directory ]
Jan  2 23:10:50 FC4 last message repeated 5 times
Jan  2 23:12:00 FC4 last message repeated 14 times
Jan  2 23:13:10 FC4 last message repeated 14 times
Jan  2 23:14:20 FC4 last message repeated 14 times
Jan  2 23:15:00 FC4 last message repeated 9 times
Jan  2 23:15:01 FC4 crond(pam_unix)[3520]: session opened for user root by (uid=0)
Jan  2 23:15:02 FC4 crond(pam_unix)[3520]: session closed for user root
Jan  2 23:15:10 FC4 zmwatch[3240]: ERR [Can't get shared memory id '%x', %d: No such file or directory ]
Jan  2 23:15:50 FC4 last message repeated 8 times
Jan  2 23:16:20 FC4 last message repeated 7 times
Jan  2 23:16:20 FC4 zmdc[3204]: WAR [Can't find process with command of 'zmc -d /dev/video0' ]
Jan  2 23:16:21 FC4 zmdc[3545]: INF ['zmc -d /dev/video0' started at 06/01/02 23:16:21 ]
Jan  2 23:16:21 FC4 zmdc[3204]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:16:21, pid = 3545 ]
Jan  2 23:16:21 FC4 zmc_dvideo0[3545]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:16:21 FC4 zmc_dvideo0[3545]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:16:21 FC4 zmdc[3204]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:16:21 FC4 zmdc[3204]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:16:21 FC4 zmdc[3204]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:16:21, pid = 3550 ]
Jan  2 23:16:21 FC4 zmdc[3550]: INF ['zmc -d /dev/video0' started at 06/01/02 23:16:21 ]
Jan  2 23:16:21 FC4 zmc_dvideo0[3550]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:16:21 FC4 zmc_dvideo0[3550]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:16:21 FC4 zmdc[3204]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:16:21 FC4 zmdc[3204]: WAR [Can't find process with command of 'zma -m 20' ]
Jan  2 23:16:26 FC4 zmdc[3204]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:16:26 FC4 zmdc[3567]: INF ['zmc -d /dev/video0' started at 06/01/02 23:16:26 ]
Jan  2 23:16:26 FC4 zmc_dvideo0[3567]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:16:26 FC4 zmdc[3204]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:16:26, pid = 3567 ]
Jan  2 23:16:26 FC4 zmc_dvideo0[3567]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:16:26 FC4 zmdc[3204]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:16:29 FC4 zms[3576]: ERR [Shared memory not initialised by capture daemon]
Jan  2 23:16:30 FC4 zmwatch[3240]: ERR [Can't get shared memory id '%x', %d: No such file or directory ]
Jan  2 23:16:30 FC4 zmwatch[3240]: ERR [Shared memory size conflict in shared_data, expected 56, got 0]
Jan  2 23:16:32 FC4 zmu[3580]: ERR [Shared memory not initialised by capture daemon]
Jan  2 23:16:36 FC4 zmdc[3204]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:16:36 FC4 zmdc[3586]: INF ['zmc -d /dev/video0' started at 06/01/02 23:16:36 ]
Jan  2 23:16:36 FC4 zmdc[3204]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:16:36, pid = 3586 ]
Jan  2 23:16:36 FC4 zmc_dvideo0[3586]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:16:36 FC4 zmc_dvideo0[3586]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:16:36 FC4 zmdc[3204]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:16:40 FC4 zmwatch[3240]: ERR [Can't get shared memory id '%x', %d: No such file or directory ]
Jan  2 23:16:50 FC4 zmwatch[3240]: ERR [Can't get shared memory id '%x', %d: No such file or directory ]
Jan  2 23:16:56 FC4 zmdc[3204]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:16:56 FC4 zmdc[3631]: INF ['zmc -d /dev/video0' started at 06/01/02 23:16:56 ]
Jan  2 23:16:56 FC4 zmdc[3204]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:16:56, pid = 3631 ]
Jan  2 23:16:56 FC4 zmc_dvideo0[3631]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:16:56 FC4 zmc_dvideo0[3631]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:16:56 FC4 zmdc[3204]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:17:00 FC4 zmwatch[3240]: ERR [Can't get shared memory id '%x', %d: No such file or directory ]
Jan  2 23:17:30 FC4 last message repeated 3 times
Jan  2 23:17:36 FC4 zmdc[3204]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:17:36 FC4 zmdc[3640]: INF ['zmc -d /dev/video0' started at 06/01/02 23:17:36 ]
Jan  2 23:17:36 FC4 zmdc[3204]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:17:36, pid = 3640 ]
Jan  2 23:17:36 FC4 zmc_dvideo0[3640]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:17:36 FC4 zmc_dvideo0[3640]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:17:36 FC4 zmdc[3204]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:17:40 FC4 zmwatch[3240]: ERR [Can't get shared memory id '%x', %d: No such file or directory ]
Jan  2 23:17:50 FC4 zmwatch[3240]: ERR [Can't get shared memory id '%x', %d: No such file or directory ]
Jan  2 23:17:57 FC4 zmpkg[3651]: INF [Command: restart ]
Jan  2 23:17:58 FC4 zmdc[3204]: INF ['zmwatch.pl ' stopping at 06/01/02 23:17:58 ]
Jan  2 23:17:58 FC4 zmdc[3204]: INF ['zmwatch.pl ' died, signal 14 ]
Jan  2 23:17:58 FC4 zmdc[3204]: INF ['zmupdate.pl -c' stopping at 06/01/02 23:17:58 ]
Jan  2 23:17:58 FC4 zmdc[3204]: INF ['zmupdate.pl -c' died, signal 14 ]
Jan  2 23:17:58 FC4 zmdc[3204]: INF ['zmaudit.pl -d 900 -y' stopping at 06/01/02 23:17:58 ]
Jan  2 23:17:58 FC4 zmdc[3204]: INF ['zmaudit.pl -d 900 -y' died, signal 14 ]
Jan  2 23:17:58 FC4 zmdc[3204]: INF ['zmfilter.pl ' stopping at 06/01/02 23:17:58 ]
Jan  2 23:17:58 FC4 zmdc[3204]: INF ['zmfilter.pl ' died, signal 14 ]
Jan  2 23:18:08 FC4 zmdc[3204]: INF [Server shutdown at 06/01/02 23:18:08 ]
Jan  2 23:18:08 FC4 zmdc[3693]: INF [Server starting at 06/01/02 23:18:08 ]
Jan  2 23:18:12 FC4 zmdc[3716]: INF ['zmc -m 19' started at 06/01/02 23:18:12 ]
Jan  2 23:18:12 FC4 zmc_m19[3716]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:12 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:18:12, pid = 3716 ]
Jan  2 23:18:12 FC4 zmc_m19[3716]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:12 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:18:12 FC4 zmdc[3693]: INF [Starting pending process, zmc -m 19 ]
Jan  2 23:18:12 FC4 zmdc[3718]: INF ['zmc -m 19' started at 06/01/02 23:18:12 ]
Jan  2 23:18:12 FC4 zmc_m19[3718]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:12 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:18:12, pid = 3718 ]
Jan  2 23:18:12 FC4 zmc_m19[3718]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:12 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:18:12 FC4 zmdc[3722]: INF ['zmc -d /dev/video0' started at 06/01/02 23:18:12 ]
Jan  2 23:18:12 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:18:12, pid = 3722 ]
Jan  2 23:18:12 FC4 zmc_dvideo0[3722]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:12 FC4 zmc_dvideo0[3722]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:12 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:18:12 FC4 zmdc[3693]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:18:12 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:18:12, pid = 3724 ]
Jan  2 23:18:12 FC4 zmdc[3724]: INF ['zmc -d /dev/video0' started at 06/01/02 23:18:12 ]
Jan  2 23:18:12 FC4 zmc_dvideo0[3724]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:12 FC4 zmc_dvideo0[3724]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:12 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:18:12 FC4 zmdc[3728]: INF ['zmfilter.pl' started at 06/01/02 23:18:12 ]
Jan  2 23:18:12 FC4 zmdc[3693]: INF ['zmfilter.pl' starting at 06/01/02 23:18:12, pid = 3728 ]
Jan  2 23:18:13 FC4 zmfilter[3728]: INF [Scanning for events ]
Jan  2 23:18:13 FC4 zmdc[3733]: INF ['zmaudit.pl -d 900 -y' started at 06/01/02 23:18:13 ]
Jan  2 23:18:13 FC4 zmdc[3693]: INF ['zmaudit.pl -d 900 -y' starting at 06/01/02 23:18:13, pid = 3733 ]
Jan  2 23:18:13 FC4 zmdc[3738]: INF ['zmwatch.pl' started at 06/01/02 23:18:13 ]
Jan  2 23:18:13 FC4 zmdc[3693]: INF ['zmwatch.pl' starting at 06/01/02 23:18:13, pid = 3738 ]
Jan  2 23:18:14 FC4 zmwatch[3738]: INF [Watchdog starting ]
Jan  2 23:18:14 FC4 zmwatch[3738]: INF [Watchdog pausing for 30 seconds ]
Jan  2 23:18:14 FC4 zmdc[3742]: INF ['zmupdate.pl -c' started at 06/01/02 23:18:14 ]
Jan  2 23:18:14 FC4 zmdc[3693]: INF ['zmupdate.pl -c' starting at 06/01/02 23:18:14, pid = 3742 ]
Jan  2 23:18:17 FC4 zmdc[3693]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:18:17 FC4 zmdc[3760]: INF ['zmc -d /dev/video0' started at 06/01/02 23:18:17 ]
Jan  2 23:18:17 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:18:17, pid = 3760 ]
Jan  2 23:18:17 FC4 zmdc[3693]: INF [Starting pending process, zmc -m 19 ]
Jan  2 23:18:17 FC4 zmdc[3761]: INF ['zmc -m 19' started at 06/01/02 23:18:17 ]
Jan  2 23:18:17 FC4 zmc_m19[3761]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:17 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:18:17, pid = 3761 ]
Jan  2 23:18:17 FC4 zmc_dvideo0[3760]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:17 FC4 zmc_dvideo0[3760]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:17 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:18:17 FC4 zmc_m19[3761]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:17 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:18:27 FC4 zmdc[3693]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:18:27 FC4 zmdc[3779]: INF ['zmc -d /dev/video0' started at 06/01/02 23:18:27 ]
Jan  2 23:18:27 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:18:27, pid = 3779 ]
Jan  2 23:18:27 FC4 zmdc[3693]: INF [Starting pending process, zmc -m 19 ]
Jan  2 23:18:27 FC4 zmdc[3780]: INF ['zmc -m 19' started at 06/01/02 23:18:27 ]
Jan  2 23:18:27 FC4 zmc_m19[3780]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:27 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:18:27, pid = 3780 ]
Jan  2 23:18:27 FC4 zmc_dvideo0[3779]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:27 FC4 zmc_dvideo0[3779]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:27 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:18:27 FC4 zmc_m19[3780]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:27 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:18:29 FC4 zmdc[3788]: INF ['zmc -d /dev/video0' started at 06/01/02 23:18:29 ]
Jan  2 23:18:29 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:18:29, pid = 3788 ]
Jan  2 23:18:29 FC4 zmc_dvideo0[3788]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:29 FC4 zmc_dvideo0[3788]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:29 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:18:29 FC4 zmdc[3793]: INF ['zma -m 20' started at 06/01/02 23:18:29 ]
Jan  2 23:18:29 FC4 zmdc[3693]: INF ['zma -m 20' starting at 06/01/02 23:18:29, pid = 3793 ]
Jan  2 23:18:29 FC4 zma_m20[3793]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:29 FC4 zma_m20[3793]: WAR [Waiting for capture daemon]
Jan  2 23:18:30 FC4 zmdc[3693]: INF ['zma -m 20' died ]
Jan  2 23:18:30 FC4 zmdc[3693]: INF [Starting pending process, zma -m 20 ]
Jan  2 23:18:30 FC4 zmdc[3798]: INF ['zma -m 20' started at 06/01/02 23:18:30 ]
Jan  2 23:18:30 FC4 zma_m20[3798]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:30 FC4 zmdc[3693]: INF ['zma -m 20' starting at 06/01/02 23:18:30, pid = 3798 ]
Jan  2 23:18:30 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:46 FC4 last message repeated 16 times
Jan  2 23:18:47 FC4 zmdc[3693]: INF [Starting pending process, zmc -m 19 ]
Jan  2 23:18:47 FC4 zmdc[3840]: INF ['zmc -m 19' started at 06/01/02 23:18:47 ]
Jan  2 23:18:47 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:18:47, pid = 3840 ]
Jan  2 23:18:47 FC4 zmc_m19[3840]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:47 FC4 zmc_m19[3840]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:47 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:18:47 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:49 FC4 last message repeated 2 times
Jan  2 23:18:49 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:18:49, pid = 3847 ]
Jan  2 23:18:49 FC4 zmdc[3847]: INF ['zmc -m 19' started at 06/01/02 23:18:49 ]
Jan  2 23:18:49 FC4 zmc_m19[3847]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:49 FC4 zmc_m19[3847]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:18:49 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:18:50 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:50 FC4 zmdc[3852]: INF ['zma -m 19' started at 06/01/02 23:18:50 ]
Jan  2 23:18:50 FC4 zmdc[3693]: INF ['zma -m 19' starting at 06/01/02 23:18:50, pid = 3852 ]
Jan  2 23:18:50 FC4 zma_m19[3852]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:50 FC4 zma_m19[3852]: WAR [Waiting for capture daemon]
Jan  2 23:18:50 FC4 zmdc[3693]: INF ['zma -m 19' died ]
Jan  2 23:18:50 FC4 zmdc[3693]: INF [Starting pending process, zma -m 19 ]
Jan  2 23:18:50 FC4 zmdc[3857]: INF ['zma -m 19' started at 06/01/02 23:18:50 ]
Jan  2 23:18:50 FC4 zma_m19[3857]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:18:50 FC4 zmdc[3693]: INF ['zma -m 19' starting at 06/01/02 23:18:50, pid = 3857 ]
Jan  2 23:18:50 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:18:51 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:51 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:18:52 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:52 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:18:53 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:53 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:18:54 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:54 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:18:55 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:55 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:18:56 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:56 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:18:57 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:57 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:18:58 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:58 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:18:59 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:18:59 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:00 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:00 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:01 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:01 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:02 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:02 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:03 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:03 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:04 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:04 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:05 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:05 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:06 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:06 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:07 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:07 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:08 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:08 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:09 FC4 zmdc[3693]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:19:09 FC4 zmdc[3892]: INF ['zmc -d /dev/video0' started at 06/01/02 23:19:09 ]
Jan  2 23:19:09 FC4 zmc_dvideo0[3892]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:19:09 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:19:09, pid = 3892 ]
Jan  2 23:19:09 FC4 zmc_dvideo0[3892]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:19:09 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:19:09 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:09 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:10 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:10 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:11 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:11 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:12 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:12 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:13 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:13 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:14 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:14 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:15 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:15 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:16 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:16 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:17 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:17 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:18 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:18 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:19 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:19 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:20 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:20 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:21 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:21 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:22 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:22 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:23 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:23 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:24 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:24 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:25 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:19:25, pid = 3901 ]
Jan  2 23:19:25 FC4 zmdc[3901]: INF ['zmc -d /dev/video0' started at 06/01/02 23:19:25 ]
Jan  2 23:19:25 FC4 zmc_dvideo0[3901]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:19:25 FC4 zmc_dvideo0[3901]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:19:25 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:19:25 FC4 zma_m20[3798]: WAR [Waiting for capture daemon]
Jan  2 23:19:25 FC4 zmdc[3693]: INF ['zma -m 20' stopping at 06/01/02 23:19:25 ]
Jan  2 23:19:25 FC4 zmdc[3693]: INF ['zma -m 20' died, signal 14 ]
Jan  2 23:19:25 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:29 FC4 last message repeated 4 times
Jan  2 23:19:30 FC4 zmdc[3925]: INF ['zmc -m 19' started at 06/01/02 23:19:30 ]
Jan  2 23:19:30 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:19:30, pid = 3925 ]
Jan  2 23:19:30 FC4 zmc_m19[3925]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:19:30 FC4 zmc_m19[3925]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:19:30 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:19:30 FC4 zma_m19[3857]: WAR [Waiting for capture daemon]
Jan  2 23:19:30 FC4 zmdc[3693]: INF ['zma -m 19' stopping at 06/01/02 23:19:30 ]
Jan  2 23:19:30 FC4 zmdc[3693]: INF ['zma -m 19' died, signal 14 ]
Jan  2 23:20:01 FC4 crond(pam_unix)[3950]: session opened for user root by (uid=0)
Jan  2 23:20:01 FC4 crond(pam_unix)[3949]: session opened for user root by (uid=0)
Jan  2 23:20:01 FC4 crond(pam_unix)[3950]: session closed for user root
Jan  2 23:20:01 FC4 crond(pam_unix)[3949]: session closed for user root
Jan  2 23:20:22 FC4 zmu[3960]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:20:25 FC4 zmu[3962]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:20:26 FC4 zmu[3964]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:22:05 FC4 zmdc[3693]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:22:05 FC4 zmdc[3981]: INF ['zmc -d /dev/video0' started at 06/01/02 23:22:05 ]
Jan  2 23:22:05 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:22:05, pid = 3981 ]
Jan  2 23:22:05 FC4 zmc_dvideo0[3981]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:22:05 FC4 zmc_dvideo0[3981]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:22:05 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:22:10 FC4 zmdc[3693]: INF [Starting pending process, zmc -m 19 ]
Jan  2 23:22:10 FC4 zmdc[3984]: INF ['zmc -m 19' started at 06/01/02 23:22:10 ]
Jan  2 23:22:10 FC4 zmc_m19[3984]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:22:10 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:22:10, pid = 3984 ]
Jan  2 23:22:10 FC4 zmc_m19[3984]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:22:10 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:25:01 FC4 crond(pam_unix)[4026]: session opened for user root by (uid=0)
Jan  2 23:25:03 FC4 crond(pam_unix)[4026]: session closed for user root
Jan  2 23:27:25 FC4 zmdc[3693]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:27:25 FC4 zmdc[4076]: INF ['zmc -d /dev/video0' started at 06/01/02 23:27:25 ]
Jan  2 23:27:25 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:27:25, pid = 4076 ]
Jan  2 23:27:25 FC4 zmc_dvideo0[4076]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:27:25 FC4 zmc_dvideo0[4076]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:27:25 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:27:30 FC4 zmdc[3693]: INF [Starting pending process, zmc -m 19 ]
Jan  2 23:27:30 FC4 zmdc[4078]: INF ['zmc -m 19' started at 06/01/02 23:27:30 ]
Jan  2 23:27:30 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:27:30, pid = 4078 ]
Jan  2 23:27:30 FC4 zmc_m19[4078]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:27:30 FC4 zmc_m19[4078]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:27:30 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:30:01 FC4 crond(pam_unix)[4117]: session opened for user root by (uid=0)
Jan  2 23:30:01 FC4 crond(pam_unix)[4119]: session opened for user root by (uid=0)
Jan  2 23:30:01 FC4 crond(pam_unix)[4117]: session closed for user root
Jan  2 23:30:01 FC4 crond(pam_unix)[4119]: session closed for user root
Jan  2 23:35:01 FC4 crond(pam_unix)[4178]: session opened for user root by (uid=0)
Jan  2 23:35:02 FC4 crond(pam_unix)[4178]: session closed for user root
Jan  2 23:37:25 FC4 zmdc[3693]: INF [Starting pending process, zmc -d /dev/video0 ]
Jan  2 23:37:25 FC4 zmdc[4199]: INF ['zmc -d /dev/video0' started at 06/01/02 23:37:25 ]
Jan  2 23:37:25 FC4 zmdc[3693]: INF ['zmc -d /dev/video0' starting at 06/01/02 23:37:25, pid = 4199 ]
Jan  2 23:37:25 FC4 zmc_dvideo0[4199]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:37:25 FC4 zmc_dvideo0[4199]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:37:25 FC4 zmdc[3693]: ERR ['zmc -d /dev/video0' crashed, exit status 30 ]
Jan  2 23:37:30 FC4 zmdc[3693]: INF [Starting pending process, zmc -m 19 ]
Jan  2 23:37:30 FC4 zmdc[4201]: INF ['zmc -m 19' started at 06/01/02 23:37:30 ]
Jan  2 23:37:30 FC4 zmdc[3693]: INF ['zmc -m 19' starting at 06/01/02 23:37:30, pid = 4201 ]
Jan  2 23:37:30 FC4 zmc_m19[4201]: INF [Debug Level = 0, Debug Log = <none>]
Jan  2 23:37:30 FC4 zmc_m19[4201]: ERR [Can't run query: Unknown column 'Coords' in 'field list']
Jan  2 23:37:30 FC4 zmdc[3693]: ERR ['zmc -m 19' crashed, exit status 30 ]
Jan  2 23:40:01 FC4 crond(pam_unix)[4237]: session opened for user root by (uid=0)
Jan  2 23:40:01 FC4 crond(pam_unix)[4239]: session opened for user root by (uid=0)
Jan  2 23:40:01 FC4 crond(pam_unix)[4239]: session closed for user root
Jan  2 23:40:01 FC4 crond(pam_unix)[4237]: session closed for user root

Post by **zoneminder** » Mon Jan 02, 2006 11:57 pm

I assume you have done this as a new install. There appears to be a problem with the zm_create.sql.in file and the Coords field in the Zones table is called Coordinates instead. I have updated the tar file but if you want to amend it just do

Code: Select all

mysql zm (or whatever your db is called)
> alter table Zones change column Coordinates Coords tinytext NOT NULL;
> quit

Phil

Jiberjaber · Post by **Jiberjaber** » Tue Jan 03, 2006 7:22 am

Bingo...!

Up and running now

Thanks Phil et al..

Did you update the other issues with the current build? (LIST/XLIST etc?) - (just for the benifit of others?)

Post by **zoneminder** » Tue Jan 03, 2006 9:59 am

Nope, I'll do that now before anyone notices!

Phil

ZoneMinder Forums

DB Problem...

DB Problem...

Re: DB Problem...

Re: DB Problem...