[SOLVED] Hi, impossible to add new monitor/cam MySQL 5.6.22

Forum for questions and support relating to the 1.28.x releases only.
Locked
christophe_y2k
Posts: 102
Joined: Mon Oct 12, 2009 8:47 am
Location: EUROPE-FRANCE-MANDELIEU

[SOLVED] Hi, impossible to add new monitor/cam MySQL 5.6.22

Post by christophe_y2k »

Same as reported here: http://www.zoneminder.com/forums/viewto ... 32&t=22813
but the add of sql_mode = ... do not help me.
in: /etc/mysql/my.cnf
---
[mysqld]
...
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
...
---
Hi, when i "add a new monitor" with setup for classic http mjpeg ipcam
The monitor do not appear in the list.
and when i stop and restart zm, debug log say:

23:31:26.120610 zmaudit 15706 INF Filesystem monitor '0' does not exist in database
23:31:26.121430 zmaudit 15706 INF deleting
23:31:26.122520 zmaudit 15706 INF Filesystem monitor link 'BEWAN-iCam200G-CUISINE' does not point to valid monitor directory

Seem to be not inserted in the db, and after a restart, zm remove the directory of camera

ZoneMinder V1.28.1 (idem with 1.28.0) compiled from source under Gentoo (x64 SystemD)
MySQL Server version: 5.6.22
php-5.5.21 (with pdo)

My config worked with previous version of zm 1.27.99 (and older sql version)

Any idea ?
Last edited by christophe_y2k on Fri Feb 20, 2015 9:28 pm, edited 1 time in total.
User avatar
knight-of-ni
Posts: 2404
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: Hi, impossible to add new monitor/camera (MySQL 5.6.22)

Post by knight-of-ni »

Hi christophe_y2k,
If you take a look at a particular post in the thread your referenced:
http://www.zoneminder.com/forums/viewto ... 710#p86710

He actually disabled the sql_mode line rather than enabled it.
It also turned out he had modified the wrong my.cnf file.

You might want to verify those two things on your system if you have not already.
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
christophe_y2k
Posts: 102
Joined: Mon Oct 12, 2009 8:47 am
Location: EUROPE-FRANCE-MANDELIEU

Re: [SOLVED] Hi, impossible to add new monitor/cam MySQL 5.6

Post by christophe_y2k »

Tanks for you help knnniggett !
effectively there is in :

# nano -w /usr/my.cnf
<--->
[mysqld]
...
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
...
<--->

sql_mode must be disabled
Locked