{"action":"created","issue":{"url":"https://api.github.com/repos/E-F-A/v3/issues/229","labels_url":"https://api.github.com/repos/E-F-A/v3/issues/229/labels{/name}","comments_url":"https://api.github.com/repos/E-F-A/v3/issues/229/comments","events_url":"https://api.github.com/repos/E-F-A/v3/issues/229/events","html_url":"https://github.com/E-F-A/v3/issues/229","id":125756423,"number":229,"title":"SQLGrey connect_src_throttle = 0 not honored","user":{"login":"shawniverson","id":6255179,"avatar_url":"https://avatars.githubusercontent.com/u/6255179?v=3","gravatar_id":"","url":"https://api.github.com/users/shawniverson","html_url":"https://github.com/shawniverson","followers_url":"https://api.github.com/users/shawniverson/followers","following_url":"https://api.github.com/users/shawniverson/following{/other_user}","gists_url":"https://api.github.com/users/shawniverson/gists{/gist_id}","starred_url":"https://api.github.com/users/shawniverson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shawniverson/subscriptions","organizations_url":"https://api.github.com/users/shawniverson/orgs","repos_url":"https://api.github.com/users/shawniverson/repos","events_url":"https://api.github.com/users/shawniverson/events{/privacy}","received_events_url":"https://api.github.com/users/shawniverson/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/E-F-A/v3/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/E-F-A/v3/labels/wontfix","name":"wontfix","color":"ffffff"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/E-F-A/v3/milestones/12","html_url":"https://github.com/E-F-A/v3/milestones/3.0.0.9","labels_url":"https://api.github.com/repos/E-F-A/v3/milestones/12/labels","id":1134770,"number":12,"title":"3.0.0.9","description":"","creator":{"login":"shawniverson","id":6255179,"avatar_url":"https://avatars.githubusercontent.com/u/6255179?v=3","gravatar_id":"","url":"https://api.github.com/users/shawniverson","html_url":"https://github.com/shawniverson","followers_url":"https://api.github.com/users/shawniverson/followers","following_url":"https://api.github.com/users/shawniverson/following{/other_user}","gists_url":"https://api.github.com/users/shawniverson/gists{/gist_id}","starred_url":"https://api.github.com/users/shawniverson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shawniverson/subscriptions","organizations_url":"https://api.github.com/users/shawniverson/orgs","repos_url":"https://api.github.com/users/shawniverson/repos","events_url":"https://api.github.com/users/shawniverson/events{/privacy}","received_events_url":"https://api.github.com/users/shawniverson/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":25,"state":"open","created_at":"2015-05-26T21:16:28Z","updated_at":"2016-01-13T02:17:37Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2016-01-09T12:31:20Z","updated_at":"2016-01-13T02:17:37Z","closed_at":"2016-01-13T02:17:37Z","body":"When someone connect at first time sqlgrey refuse connection and then add a\r\nrecord in connect table like this\r\nuser@domain.com<mailto:user@domain.com>       198.34.65\r\nNext time the server try to send sqlgrey allow connection because there is\r\nthe record in connect table\r\nBut, if the user doesn't reconnect the record remain for some time\r\nIf another try to connect from the same server we have a new record like\r\nthis\r\nuser2@otherdomain.com<mailto:user2@otherdomain.com>        198.34.65\r\n\r\nSqlgrey has a feature connect_src_throttle that count active ip column and\r\nat now we have 2 column with 198.34.65\r\nSo if we have in config connect_src_throttle = 2 sqlgrey doesn't accept\r\nmore connect from 198.34.65\r\n\r\nBy default connect_src_throttle is disabled, in docs it says that if none\r\nspecified or connect_src_throttle = 0 means disabled\r\nBut it is not true because connect_src_throttle = 0 doesn't act as disable,\r\nit act to reject at first duplication of ip\r\n\r\nIt solves making in config\r\n#connect_src_throttle = 0\r\nOr\r\nconnect_src_throttle = 9999"},"comment":{"url":"https://api.github.com/repos/E-F-A/v3/issues/comments/171133649","html_url":"https://github.com/E-F-A/v3/issues/229#issuecomment-171133649","issue_url":"https://api.github.com/repos/E-F-A/v3/issues/229","id":171133649,"user":{"login":"shawniverson","id":6255179,"avatar_url":"https://avatars.githubusercontent.com/u/6255179?v=3","gravatar_id":"","url":"https://api.github.com/users/shawniverson","html_url":"https://github.com/shawniverson","followers_url":"https://api.github.com/users/shawniverson/followers","following_url":"https://api.github.com/users/shawniverson/following{/other_user}","gists_url":"https://api.github.com/users/shawniverson/gists{/gist_id}","starred_url":"https://api.github.com/users/shawniverson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shawniverson/subscriptions","organizations_url":"https://api.github.com/users/shawniverson/orgs","repos_url":"https://api.github.com/users/shawniverson/repos","events_url":"https://api.github.com/users/shawniverson/events{/privacy}","received_events_url":"https://api.github.com/users/shawniverson/received_events","type":"User","site_admin":false},"created_at":"2016-01-13T02:17:37Z","updated_at":"2016-01-13T02:17:37Z","body":"Default in EFA is 5.  Leaving setting alone unless someone thinks this should be reopened and can justify the need for all users."}}