Page 1 of 1

sqlgrey throttling bug ?

Posted: 11 Dec 2015 09:15
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 |

Re: sqlgrey throttling bug ?

Posted: 11 Dec 2015 10:04
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

Re: sqlgrey throttling bug ?

Posted: 11 Dec 2015 11:04
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

Re: sqlgrey throttling bug ?

Posted: 19 Dec 2015 12:00
by shawniverson
I would like to understand this issue better, feel free to PM me.