sqlgrey throttling bug ?

Report bugs and workarounds
Post Reply
nicola.piazzi
Posts: 389
Joined: 23 Apr 2015 09:45

sqlgrey throttling bug ?

Post by nicola.piazzi »

In my file sqlgrey.conf i put connect_src_throttle = 0 because i think that this feature can be too invasive
in ordet that I use classc method i suppose that host throttling is be referred to classc.

Now i found that some senders are Always refused, and in maillog file i found :
sqlgrey: grey: throttling: 82.57.200(82.57.200.102), email@domain.it -> etc etc

I make a query with count&gruupby in the connect table and i found only 12 elements from 82.57.200 but src throttle is disabled i dont know why it happens

It will be useful to put connect_src_throttle = 0 at 999 ?


2 | 195.140.185 |
| 2 | 198.2.190 |
| 2 | 205.201.128 |
| 2 | 212.48.25 |
| 3 | 93.95.217 |
| 4 | 46.44.253 |
| 8 | 81.88.54 |
| 12 | 82.57.200 |
| 39 | 63.240.154 |
nicola.piazzi
Posts: 389
Joined: 23 Apr 2015 09:45

Re: sqlgrey throttling bug ?

Post by nicola.piazzi »

Using connect_src_throttle = 999 it work well because it doesnt reach 999 entries
so the problem is that 0 doesnt disable this feature but consider 0 the throttling number
nicola.piazzi
Posts: 389
Joined: 23 Apr 2015 09:45

Re: sqlgrey throttling bug ?

Post by nicola.piazzi »

connect_src_throttle = 0 - seems to not disable this feature
grep throttling /var/log/maillog | wc
27073 297803 3647294
(5 minutes wait)
grep throttling /var/log/maillog | wc
27076 297836 3647711
(5 minutes wait)
grep throttling /var/log/maillog | wc
27095 298045 3650317

connect_src_throttle = 999 - seems to solve problem (because I don’t have 999 entry at now)
grep throttling /var/log/maillog | wc
27095 298045 3650317
(5 minutes wait)
grep throttling /var/log/maillog | wc
27095 298045 3650317
(5 minutes wait)
grep throttling /var/log/maillog | wc
27095 298045 3650317

#connect_src_throttle = 0 - with # seems to take the default that is disabled
grep throttling /var/log/maillog | wc
27095 298045 3650317
(5 minutes wait)
grep throttling /var/log/maillog | wc
27095 298045 3650317
(30 minutes wait)
grep throttling /var/log/maillog | wc
27095 298045 3650317


So you must put a huge number that not will be reached or put a # to use default that is disable feature

#connect_src_throttle = 0 seems to solve , it take the default that is feature disabled
This bug is dangerous
User avatar
shawniverson
Posts: 3783
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: sqlgrey throttling bug ?

Post by shawniverson »

I would like to understand this issue better, feel free to PM me.
Post Reply