I did however ran into an issue. After I added a second custom filter, the "choose filter" page keeps giving a "502 Bad Gateway" error. (https://IP/zm/index.php?view=filter&Id=) When I remove the second custom filter, the error disappears. Also, the individual filters are shown properly and seem to be working (https://IP/zm/index.php?view=filter&Id=4).
Looking at the entries in the db did not really give me a clue (see below).
Does anyone have a suggestion what may be wrong or how to resolve this?
Thanks, Jasper
Code: Select all
dbadmin@localhost [zm]> SELECT * FROM filters;
+----+----------------------+--------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------------+-----------+------------+-----------+---------+--------------+-----------+-------------+-------------+----------------+------------+----------+------------+----------+------------+-----------------+------------+------------+----------+
| Id | Name | UserId | Query_json | AutoArchive | AutoUnarchive | AutoVideo | AutoUpload | AutoEmail | EmailTo | EmailSubject | EmailBody | AutoMessage | AutoExecute | AutoExecuteCmd | AutoDelete | AutoMove | AutoMoveTo | AutoCopy | AutoCopyTo | UpdateDiskSpace | Background | Concurrent | LockRows |
+----+----------------------+--------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------------+-----------+------------+-----------+---------+--------------+-----------+-------------+-------------+----------------+------------+----------+------------+----------+------------+-----------------+------------+------------+----------+
| 1 | PurgeWhenFull | 1 | {"sort_field":"Id","terms":[{"val":0,"attr":"Archived","op":"="},{"cnj":"and","val":95,"attr":"DiskPercent","op":">="},{"cnj":"and","obr":"0","attr":"EndDateTime","op":"IS NOT","val":"NULL","cbr":"0"}],"limit":100,"sort_asc":1} | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 | | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 2 | Update DiskSpace | 1 | {"terms":[{"attr":"DiskSpace","op":"IS","val":"NULL"},{"cnj":"and","obr":"0","attr":"EndDateTime","op":"IS NOT","val":"NULL","cbr":"0"}]} | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 | | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
| 4 | PurgeCam1After3Days | 1 | {"terms":[{"obr":"0","attr":"Archived","op":"=","val":"0","cbr":"0"},{"cnj":"and","obr":"0","attr":"EndDate","op":"<","val":"-3 days","cbr":"0"},{"cnj":"and","obr":"0","attr":"MonitorId","op":"=","val":"1","cbr":"0"}],"sort_field":"StartDateTime","sort_asc":"1","limit":"10"} | 0 | 0 | 0 | 0 | 0 | | | | 0 | 0 | | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 6 | PurgeAllAfter14Days | 1 | {"terms":[{"attr":"Archived","op":"=","val":"0"},{"cnj":"and","attr":"EndDate","op":"=","val":"-14 days"}],"sort_field":"StartDateTime","sort_asc":"1","limit":"100"} | 0 | 0 | 0 | 0 | 0 | | | |