PTZ Control problem v1.23.0

[mcleandl]

Hello,

Zoneminder 1.23.0 running on Fedora Core 7 i686

Santa was good this year and was able to upgrade Zoneminder system to AMD's new Phenom Quad core to manage system load. Good time to move forward to Fedora 7 and latest ZM. Everything went well until trying to control PTZ camera's and receive the following error messages.

/tmp/zmcontrol.log:
01/06/08 14:25:26.652210 zmcontrol[32532].DBG [--panspeed=29 --autostop --command=moveConLeft --id=2]
01/06/08 14:25:26.654571 zmcontrol[32532].INF [Starting control server 2/zmcontrol-pelco-d.pl]
01/06/08 14:25:26.656858 zmcontrol[32535].INF [Control server 2/zmcontrol-pelco-d.pl starting at 08/01/06 14:25:26]
01/06/08 14:25:36.660338 zmcontrol[32532].FAT [Can't connect: No such file or directory]

/var/log/messages:
Jan 6 14:25:26 localhost zmcontrol[32532]: INF [Starting control server 2/zmcontrol-pelco-d.pl]
Jan 6 14:25:26 localhost zmcontrol[32535]: INF [Control server 2/zmcontrol-pelco-d.pl starting at 08/01/06 14:25:26]
Jan 6 14:25:26 localhost Can't locate ZoneMinder::Control::zmcontrol-pelco-d.pl in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8. at /usr/lib/perl5/vendor_perl/5.8.8/Module/Load.pm line 21.
Jan 6 14:25:36 localhost zmcontrol[32532]: FAT [Can't connect: No such file or directory]

I understand that camera control has changed since last release.

Any idea's

[zoneminder]

That sounds like you have a script name in the Protocol field of the Controls table for some reason. It should be 'PelcoD'. However another thread earlier today identified a problem where the field in the gui actually tries to update the old Command field and not the new Protocol one. So either update the db yourself with mysql or similar or wait a couple of days for 1.23.1 which will have the fix in.

[mcleandl]

Output from db:

mysql> select Id, Name, Type, Protocol from Controls;
+----+-------------------+--------+---------------------------+
| Id | Name | Type | Protocol |
+----+-------------------+--------+---------------------------+
| 1 | PELCO-D | Local | zmcontrol-pelco-d.pl |
| 2 | PELCO-P | Local | zmcontrol-pelco-p.pl |
| 3 | Sony VISCA | Local | zmcontrol-visca.pl |
| 4 | Axis API v2 | Remote | zmcontrol-axis-v2.pl |
| 5 | Panasonic IP | Remote | zmcontrol-panasonic-ip.pl |
| 6 | Neu-Fusion NCS370 | Remote | zmcontrol-ncs370.pl |
+----+-------------------+--------+---------------------------+
6 rows in set (0.00 sec)

I believe this is correct.

Is there any additional informaton I could collect.

[zoneminder]

This is somewhat odd as the migration script to 1.23.0 cntains the following lines

Code: Select all

alter table Controls add column Protocol varchar(32) after Command;
update Controls set Protocol = "PelcoD" where Command like "%zmcontrol-pelco-d.pl";
update Controls set Protocol = "PelcoP" where Command like "%zmcontrol-pelco-p.pl";
update Controls set Protocol = "Visca" where Command like "%zmcontrol-visca.pl";
update Controls set Protocol = "PanasonicIP" where Command like "%zmcontrol-panasonic-ip.pl";
update Controls set Protocol = "AxisV2" where Command like "%zmcontrol-axis-v2.pl";
update Controls set Protocol = "Ncs370" where Command like "%zmcontrol-ncs370.pl";
update Controls set Protocol = "VclTP" where Command like "%zmcontrol-vcltp.pl";
alter table Controls drop column Command;

You have the Protocol field so the first bit was done but then the other parts don't seem to have been applied.

Ack, I can see why! Because the DB creation script still has the old names in. I will fix that asap. For you just running the 'update' lines above should fix it.

[mcleandl]

Thanks for the tips. Being somewhat sql challenged it took a while to correct the syntax.

I think your right that the zm_create.sql script is broke on new installs.

Commands used to fix db:
update Controls set Protocol = "PelcoD" where Protocol = "zmcontrol-pelco-d.pl";
update Controls set Protocol = "PelcoP" where Protocol = "zmcontrol-pelco-p.pl";
update Controls set Protocol = "Visca" where Protocol = "zmcontrol-visca.pl";
update Controls set Protocol = "AxisV2" where Protocol = "zmcontrol-axis-v2.pl";
update Controls set Protocol = "PanasonicIP" where Protocol = "zmcontrol-panasonic-ip.pl";
update Controls set Protocol = "Ncs370" where Protocol = "zmcontrol-ncs370.pl";

Field for "VclTP" did not exits.

Camera control for PelcoD works.

Thanks