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

[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 ?

[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.

[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