1.24.1, 8.0.4.2, latest ffmpeg, all from svn, missing fields

[coke]

So I took the plunge, uninstalled from source my previous ffmpeg and zoneminder installations, went through the process of getting fresh versions from SVN, etc., had --enable-mmap and I thought everything was working once it started, but it won't get past starting.

Did a fresh stop, deleted logs, started again, here's the heads.

zmwatch.log

Code: Select all

 head -10 zmwatch.log
05/21/2009 14:19:07.447539 zmwatch[8315].INF [Watchdog starting]
05/21/2009 14:19:07.447925 zmwatch[8315].INF [Watchdog pausing for 30 seconds]
05/21/2009 14:19:37.516697 zmwatch[8315].ERR [Can't get shared memory id '7a6d0001', 1: No such file or directory]
05/21/2009 14:19:37.516931 zmwatch[8315].ERR [Can't get shared memory id '7a6d0001', 1: No such file or directory]
05/21/2009 14:19:37.517076 zmwatch[8315].ERR [Can't get shared memory id '7a6d0002', 2: No such file or directory]
05/21/2009 14:19:37.517167 zmwatch[8315].ERR [Can't get shared memory id '7a6d0002', 2: No such file or directory]
05/21/2009 14:19:37.517306 zmwatch[8315].ERR [Can't get shared memory id '7a6d0003', 3: No such file or directory]
05/21/2009 14:19:37.517395 zmwatch[8315].ERR [Can't get shared memory id '7a6d0003', 3: No such file or directory]
05/21/2009 14:19:37.517532 zmwatch[8315].ERR [Can't get shared memory id '7a6d0004', 4: No such file or directory]
05/21/2009 14:19:37.517622 zmwatch[8315].ERR [Can't get shared memory id '7a6d0004', 4: No such file or directory]

zmdc.log

Code: Select all

head -10 zmdc.log
05/21/2009 14:19:01.601451 zmdc[8228].INF [Server starting at 09/05/21 14:19:01]
05/21/2009 14:19:05.130926 zmdc[8228].INF ['zmc -m 1' starting at 09/05/21 14:19:05, pid = 8251]
05/21/2009 14:19:05.134843 zmdc[8228].ERR ['zmc -m 1' exited abnormally, exit status 30]
05/21/2009 14:19:05.135130 zmdc[8228].INF [Starting pending process, zmc -m 1]
05/21/2009 14:19:05.149488 zmdc[8228].INF ['zmc -m 1' starting at 09/05/21 14:19:05, pid = 8253]
05/21/2009 14:19:05.177826 zmdc[8228].ERR ['zmc -m 1' exited abnormally, exit status 30]
05/21/2009 14:19:05.231263 zmdc[8228].INF ['zma -m 1' starting at 09/05/21 14:19:05, pid = 8254]
05/21/2009 14:19:05.259272 zmdc[8228].ERR ['zma -m 1' exited abnormally, exit status 30]
05/21/2009 14:19:05.259451 zmdc[8228].INF [Starting pending process, zma -m 1]
05/21/2009 14:19:05.262086 zmdc[8228].INF ['zma -m 1' starting at 09/05/21 14:19:05, pid = 8256]

One of the debug logs, there's several with essentially the same information.

Code: Select all

cat zm_debug.log.08488
05/21/09 14:21:42.037199 zma_m16[8488].INF-zm_debug.c/292 [New Debug Level = 4, New Debug Log = /tmp/zm_debug.log.08488]
05/21/09 14:21:42.037507 zma_m16[8488].ERR-zm_monitor.cpp/2253 [Can't run query: Unknown column 'Protocol' in 'field list']

Grepping the debug logs shows they all contain the unknown column Protocol.

Where did I go wrong, and how can I fix it?

Checked the setup on the cameras, it switched from my previous Axis presets to RTSP's, tried to reset one from a preset and got this:

Code: Select all

grep DB408B *
error.log:[Thu May 21 14:28:32 2009] [error] [client 127.0.0.1] SQL-ERROR(DB408B): select Type, Device, Channel, Format, Protocol, Method, Host, Port, Path, SubPath, Width, Height, Palette, MaxFPS, Controllable, ControlId, ControlDevice, ControlAddress, DefaultRate, DefaultScale from MonitorPresets where Id = '13', referer: http://127.0.0.1/index.php?view=monitorpreset&mid=1
error.log:[Thu May 21 14:28:32 2009] [error] [client 127.0.0.1] SQL-ERROR(DB408B): Unknown column 'Protocol' in 'field list', referer: http://127.0.0.1/index.php?view=monitorpreset&mid=1

[curtishall]

Just a guess......but did you trash the old database and import the new 1.24.? database? The column error is bothersome

So I took the plunge, uninstalled from source my previous ffmpeg and zoneminder installations, went through the process of getting fresh versions from SVN, etc., had --enable-mmap and I thought everything was working once it started, but it won't get past starting.

Did a fresh stop, deleted logs, started again, here's the heads.

zmwatch.log

Code: Select all

 head -10 zmwatch.log
05/21/2009 14:19:07.447539 zmwatch[8315].INF [Watchdog starting]
05/21/2009 14:19:07.447925 zmwatch[8315].INF [Watchdog pausing for 30 seconds]
05/21/2009 14:19:37.516697 zmwatch[8315].ERR [Can't get shared memory id '7a6d0001', 1: No such file or directory]
05/21/2009 14:19:37.516931 zmwatch[8315].ERR [Can't get shared memory id '7a6d0001', 1: No such file or directory]
05/21/2009 14:19:37.517076 zmwatch[8315].ERR [Can't get shared memory id '7a6d0002', 2: No such file or directory]
05/21/2009 14:19:37.517167 zmwatch[8315].ERR [Can't get shared memory id '7a6d0002', 2: No such file or directory]
05/21/2009 14:19:37.517306 zmwatch[8315].ERR [Can't get shared memory id '7a6d0003', 3: No such file or directory]
05/21/2009 14:19:37.517395 zmwatch[8315].ERR [Can't get shared memory id '7a6d0003', 3: No such file or directory]
05/21/2009 14:19:37.517532 zmwatch[8315].ERR [Can't get shared memory id '7a6d0004', 4: No such file or directory]
05/21/2009 14:19:37.517622 zmwatch[8315].ERR [Can't get shared memory id '7a6d0004', 4: No such file or directory]

zmdc.log

Code: Select all

head -10 zmdc.log
05/21/2009 14:19:01.601451 zmdc[8228].INF [Server starting at 09/05/21 14:19:01]
05/21/2009 14:19:05.130926 zmdc[8228].INF ['zmc -m 1' starting at 09/05/21 14:19:05, pid = 8251]
05/21/2009 14:19:05.134843 zmdc[8228].ERR ['zmc -m 1' exited abnormally, exit status 30]
05/21/2009 14:19:05.135130 zmdc[8228].INF [Starting pending process, zmc -m 1]
05/21/2009 14:19:05.149488 zmdc[8228].INF ['zmc -m 1' starting at 09/05/21 14:19:05, pid = 8253]
05/21/2009 14:19:05.177826 zmdc[8228].ERR ['zmc -m 1' exited abnormally, exit status 30]
05/21/2009 14:19:05.231263 zmdc[8228].INF ['zma -m 1' starting at 09/05/21 14:19:05, pid = 8254]
05/21/2009 14:19:05.259272 zmdc[8228].ERR ['zma -m 1' exited abnormally, exit status 30]
05/21/2009 14:19:05.259451 zmdc[8228].INF [Starting pending process, zma -m 1]
05/21/2009 14:19:05.262086 zmdc[8228].INF ['zma -m 1' starting at 09/05/21 14:19:05, pid = 8256]

One of the debug logs, there's several with essentially the same information.

Code: Select all

cat zm_debug.log.08488
05/21/09 14:21:42.037199 zma_m16[8488].INF-zm_debug.c/292 [New Debug Level = 4, New Debug Log = /tmp/zm_debug.log.08488]
05/21/09 14:21:42.037507 zma_m16[8488].ERR-zm_monitor.cpp/2253 [Can't run query: Unknown column 'Protocol' in 'field list']

Grepping the debug logs shows they all contain the unknown column Protocol.

Where did I go wrong, and how can I fix it?

Checked the setup on the cameras, it switched from my previous Axis presets to RTSP's, tried to reset one from a preset and got this:

Code: Select all

grep DB408B *
error.log:[Thu May 21 14:28:32 2009] [error] [client 127.0.0.1] SQL-ERROR(DB408B): select Type, Device, Channel, Format, Protocol, Method, Host, Port, Path, SubPath, Width, Height, Palette, MaxFPS, Controllable, ControlId, ControlDevice, ControlAddress, DefaultRate, DefaultScale from MonitorPresets where Id = '13', referer: http://127.0.0.1/index.php?view=monitorpreset&mid=1
error.log:[Thu May 21 14:28:32 2009] [error] [client 127.0.0.1] SQL-ERROR(DB408B): Unknown column 'Protocol' in 'field list', referer: http://127.0.0.1/index.php?view=monitorpreset&mid=1

[coke]

No, I was kinda hoping it'd update the database tables for me, so I wouldn't lose all my camera configurations. Is there an easy way to trash/recreate them without losing configurations? I can reconfigure them all if I have to, just doesn't feel right.

[timcraig]

Did you run zmupdate.pl on your database to upgrade it to the 1.24x structure?


If you haven't already, backup your database and call

Code: Select all

zmupdate.pl -version=<from version> [--user=<database user> --pass=<database password>] 

Use a database username & password with write and alter permissions to your ZM database.



If you did call zmupdate.pl already, I say give it another try on a backup of your database before the ZM upgrade.

[coke]

That seems to have done the trick. I hadn't called it already, missed that step. Had to do some jiggling around, as I'd started to manually update the tables based on another 1.24.1 machine with the intent of re-inserting the data, but your route was just a tad easier.

Now I just need to get it to show me pictures again.