How to delete zmfilter creating tons of email queue

Forum for questions and support relating to the 1.34.x releases only.
Post Reply
vskatusa
Posts: 33
Joined: Sat Jan 02, 2016 4:02 pm

How to delete zmfilter creating tons of email queue

Post by vskatusa »

I am getting errors in emails being sent.
Zmfilter_3.log is enclosed https://pastebin.com/qCmRbhtq

Email worked before. used setup guide https://wiki.zoneminder.com/How_to_get_ ... Zoneminder

I have setup a filter as follows https://pasteboard.co/J8D2m3r.png.

When I run the above filter and hit the "list matches" button get the following screen https://pasteboard.co/J8D2Xvf.png

Would appreciate any tips to troubleshoot
Last edited by vskatusa on Sat May 16, 2020 12:04 pm, edited 1 time in total.
vskatusa
Posts: 33
Joined: Sat Jan 02, 2016 4:02 pm

Re: Email send Error log

Post by vskatusa »

I checked the errors in /var/log/mail.err

May 16 07:42:14 zmpc sSMTP[2211]: Authorization failed (454 4.7.0 Too many login attempts, please try again later. i41sm4524009qte.15 - gsmtp)
May 16 07:42:15 zmpc sSMTP[2212]: Authorization failed (454 4.7.0 Too many login attempts, please try again later. g26sm4174026qtk.76 - gsmtp)
May 16 07:42:15 zmpc sSMTP[2213]: Authorization failed (454 4.7.0 Too many login attempts, please try again later. h188sm3672485qke.82 - gsmtp)
May 16 07:42:16 zmpc sSMTP[2214]: Authorization failed (454 4.7.0 Too many login attempts, please try again later. 206sm3753308qki.48 - gsmtp)
May 16 07:42:17 zmpc sSMTP[2215]: Authorization failed (454 4.7.0 Too many login attempts, please try again later. x1sm3549012qkl.66 - gsmtp)
May 16 07:42:18 zmpc sSMTP[2216]: Authorization failed (454 4.7.0 Too many login attempts, please try again later. d13sm4223399qtr.52 - gsmtp)

I think it is trying to send tons of email based on my filter condition (my guess). Is there a way to remove the pending email queue?
vskatusa
Posts: 33
Joined: Sat Jan 02, 2016 4:02 pm

Re: Email send Error log

Post by vskatusa »

OMG the zmfilter is keeping on sending emails... How do I stop? Please help! Just want to delete the email Queue

2020-05-16 07:59:56 zma_m3 1344 INF Back: 9200 - Analysing at 14.29 fps zm_monitor.cpp 1297
2020-05-16 07:59:56 zmfilter_3 1179 INF Sending notification email 'Movement Basement | eventId=5165 | AlarmFrames=196| TotalScore=1307 ' zmfilter.pl
2020-05-16 07:59:56 zmfilter_3 1179 INF Creating notification email zmfilter.pl
2020-05-16 07:59:56 zmfilter_3 1179 ERR Unable to send email: error closing /usr/lib/sendmail: (exit 256) zmfilter.pl
2020-05-16 07:59:55 zmfilter_3 1179 INF Sending notification email 'Movement Basement | eventId=5164 | AlarmFrames=72| TotalScore=1004 ' zmfilter.pl
2020-05-16 07:59:55 zmc_m2 1122 INF Front: images:6300 - Capturing at 10.00 fps, capturing bandwidth 369481bytes/sec zm_monitor.cpp 2539
2020-05-16 07:59:55 zmc_m4 1138 INF Basement: images:18900 - Capturing at 25.00 fps, capturing bandwidth 510089bytes/sec zm_monitor.cpp 2539
2020-05-16 07:59:55 zmfilter_3 1179 INF Creating notification email zmfilter.pl
2020-05-16 07:59:54 zmfilter_3 1179 ERR Unable to send email: error closing /usr/lib/sendmail: (exit 256) zmfilter.pl
2020-05-16 07:59:53 zmfilter_3 1179 INF Sending notification email 'Movement Basement | eventId=5163 | AlarmFrames=150| TotalScore=2226 ' zmfilter.pl
2020-05-16 07:59:53 zmfilter_3 1179 INF Creating notification email zmfilter.pl
2020-05-16 07:59:53 zmfilter_3 1179 ERR Unable to send email: error closing /usr/lib/sendmail: (exit 256) zmfilter.pl
2020-05-16 07:59:53 zma_m4 1338 INF Basement: 17200 - Analysing at 25.00 fps zm_monitor.cpp 1297
2020-05-16 07:59:52 zmc_m5 1146 INF Garage-Inside: images:10000 - Capturing at 16.67 fps, capturing bandwidth 499731bytes/sec zm_monitor.cpp 2539
2020-05-16 07:59:52 zmfilter_3 1179 INF Sending notification email 'Movement Basement | eventId=5162 | AlarmFrames=101| TotalScore=1303 ' zmfilter.pl
2020-05-16 07:59:51 zmfilter_3 1179 INF Creating notification email zmfilter.pl

I have unchecked OPT_EMAIL and just want to delete the Queue. Off course this is of my ignorance
vskatusa
Posts: 33
Joined: Sat Jan 02, 2016 4:02 pm

Re: How to delete zmfilter creating tons of email queue

Post by vskatusa »

Soved! For the benefit of others, I deleted all entries in the following tables:
  • Events_Day
  • Events_Hour
  • Events_Week
  • Events_Month
  • Logs
User avatar
burger
Posts: 390
Joined: Mon May 11, 2020 4:32 pm

Re: How to delete zmfilter creating tons of email queue

Post by burger »

When testing emails and filters, make sure to limit results to 1.

Also once a specific event is sent, it is flagged in the db, and will not send again.

https://wiki.zoneminder.com/SMS_Notifications
fastest way to test streams:
ffmpeg -i rtsp://<user>:<pass>@<ipaddress>:554/path ./output.mp4 (if terminal only)
ffplay rtsp://<user>:<pass>@<ipaddress>:554/path (gui)
find paths on ispydb or in zm hcl

If you are new to security software, read:
https://wiki.zoneminder.com/Dummies_Guide
vskatusa
Posts: 33
Joined: Sat Jan 02, 2016 4:02 pm

[Solved] How to delete zmfilter creating tons of email queue

Post by vskatusa »

Marked as solved
Post Reply