Can't create a monitor - SOLVED

[haake]

I have an installation of zoneminder from the zmrepo on CentOS 6.6

Everything seems to be running but I can't create a new monitor instance

The monitor dialog comes up when I select "add new monitor" from the Console but when I save it, there is nothing in the database table for monitors and there is nothing in the console when I refresh it. There is a directory "0" created in /var/lib/zoneminder/events and a link to it called "Monitor-2" but nothing else.

No errors in the DB log, no errors in the http errors log

SELinux policy is permissive

I get the messages below in the zm log. I clicked save in the monitor dialog just before the warnings at 16:11

Any ideas?

Bill Haake


2015-02-13 16:10:37.656600 zmpkg 23640 INF Command: start zmpkg.pl
2015-02-13 16:10:37.905920 zmdc 23649 INF Server starting at 15/02/13 16:10:37 zmdc.pl
2015-02-13 16:10:41.000920 zmdc 23649 INF 'zmfilter.pl' starting at 15/02/13 16:10:41, pid = 23672 zmdc.pl
2015-02-13 16:10:41.000930 zmdc 23672 INF 'zmfilter.pl' started at 15/02/13 16:10:41 zmdc.pl
2015-02-13 16:10:41.162980 zmdc 23649 INF 'zmaudit.pl -c' starting at 15/02/13 16:10:41, pid = 23675 zmdc.pl
2015-02-13 16:10:41.164760 zmdc 23675 INF 'zmaudit.pl -c' started at 15/02/13 16:10:41 zmdc.pl
2015-02-13 16:10:41.212900 zmfilter 23672 INF Scanning for events zmfilter.pl
2015-02-13 16:10:41.380430 zmdc 23649 INF 'zmwatch.pl' starting at 15/02/13 16:10:41, pid = 23678 zmdc.pl
2015-02-13 16:10:41.382590 zmdc 23678 INF 'zmwatch.pl' started at 15/02/13 16:10:41 zmdc.pl
2015-02-13 16:10:41.576400 zmwatch 23678 INF Watchdog starting zmwatch.pl
2015-02-13 16:10:41.589350 zmdc 23649 INF 'zmupdate.pl -c' starting at 15/02/13 16:10:41, pid = 23681 zmdc.pl
2015-02-13 16:10:41.589360 zmdc 23681 INF 'zmupdate.pl -c' started at 15/02/13 16:10:41 zmdc.pl
2015-02-13 16:10:41.638840 zmwatch 23678 INF Watchdog pausing for 30 seconds zmwatch.pl


2015-02-13 16:11:22.280117 web_php 23704 DBG LogOpts: level=DBG/DBG, screen=OFF, database=DBG, logfile=DBG->/var/log/zoneminder/zm_debug.log.23704, weblog=INF, syslog=INF /usr/share/zoneminder/www/includes/logger.php 168
2015-02-13 16:11:39.051340 zmdc 23649 WAR Can't find process with command of 'zmtrack.pl -m' zmdc.pl
2015-02-13 16:11:39.194970 zmdc 23649 WAR Can't find process with command of 'zma -m' zmdc.pl
2015-02-13 16:11:39.336880 zmdc 23649 WAR Can't find process with command of 'zmc -m' zmdc.pl
2015-02-13 16:11:39.478930 zmdc 23649 WAR Can't find process with command of 'zmtrack.pl -m' zmdc.pl
2015-02-13 16:11:39.620350 zmdc 23649 WAR Can't find process with command of 'zma -m' zmdc.pl
2015-02-13 16:11:39.804538 web_php 23707 DBG LogOpts: level=DBG/DBG, screen=OFF, database=DBG, logfile=DBG->/var/log/zoneminder/zm_debug.log.23707, weblog=INF, syslog=INF /usr/share/zoneminder/www/includes/logger.php 168
2015-02-13 16:11:41.766910 web_php 23705 DBG LogOpts: level=DBG/DBG, screen=OFF, database=DBG, logfile=DBG->/var/log/zoneminder/zm_debug.log.23705, weblog=INF, syslog=INF /usr/share/zoneminder/www/includes/logger.php 168
2015-02-13 16:12:42.055427 web_php 23700 DBG LogOpts: level=DBG/DBG, screen=OFF, database=DBG, logfile=DBG->/var/log/zoneminder/zm_debug.log.23700, weblog=INF, syslog=INF /usr/share/zoneminder/www/includes/logger.php 168
2015-02-13 16:13:42.294565 web_php 23703 DBG LogOpts: level=DBG/DBG, screen=OFF, database=DBG, logfile=DBG->/var/log/zoneminder/zm_debug.log.23703, weblog=INF, syslog=INF /usr/share/zoneminder/www/includes/logger.php 168

[haake]

Problem is solved. A more thorough search of the forum turned up the mysql configuration as the culprit. The sql_mode should be specified as follows:
sql_mode=NO_ENGINE_SUBSTITUTION

[knight-of-ni]

Can you provide a reference?
I've only seen that problem reported on versions of sql newer than what ship with CentOS 6.
What version of mysql are you running?

[haake]

Sure, it was this post http://www.zoneminder.com/forums/viewto ... 32&t=22813

I am running mysql from the mysql-community repo. I have two machines that had this issue, first my intended production machine is RHEL 6.6 with mysql 5.7.5-m15 I then set up a Centos 6.6 machine with a minimal set of packages and the mysql-community repo with mysql 5.6.23 just for testing. Both machines had the same problem until I updated the sql_mode variable. Both machines work now.

Bill

[knight-of-ni]

Interesting.
The user from other thread had to comment out that line, while you had to add it in. Very strange.

Anyway, I just put up zoneminder rpms in zmrepo for Fedora 21 (sql 5.6) and CentOS 7 (mariadb 5.5). I have not run into this issue with either of these distros, but at least I'll know where to look if I do.

[Watice]

Really can't thank you enough. I had previously spent days trying to pinpoint where the bug was. For the record, I am on an updated mysql on centos6 as previously suspected to be the case, & commenting OUT the line in the my.cnf file fixed it for me.