{"action":"created","issue":{"url":"https://api.github.com/repos/codeling/bfstop/issues/109","repository_url":"https://api.github.com/repos/codeling/bfstop","labels_url":"https://api.github.com/repos/codeling/bfstop/issues/109/labels{/name}","comments_url":"https://api.github.com/repos/codeling/bfstop/issues/109/comments","events_url":"https://api.github.com/repos/codeling/bfstop/issues/109/events","html_url":"https://github.com/codeling/bfstop/issues/109","id":112304488,"number":109,"title":"Not logging to database","user":{"login":"AlphaCharlie-AU","id":15209058,"avatar_url":"https://avatars.githubusercontent.com/u/15209058?v=3","gravatar_id":"","url":"https://api.github.com/users/AlphaCharlie-AU","html_url":"https://github.com/AlphaCharlie-AU","followers_url":"https://api.github.com/users/AlphaCharlie-AU/followers","following_url":"https://api.github.com/users/AlphaCharlie-AU/following{/other_user}","gists_url":"https://api.github.com/users/AlphaCharlie-AU/gists{/gist_id}","starred_url":"https://api.github.com/users/AlphaCharlie-AU/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AlphaCharlie-AU/subscriptions","organizations_url":"https://api.github.com/users/AlphaCharlie-AU/orgs","repos_url":"https://api.github.com/users/AlphaCharlie-AU/repos","events_url":"https://api.github.com/users/AlphaCharlie-AU/events{/privacy}","received_events_url":"https://api.github.com/users/AlphaCharlie-AU/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/codeling/bfstop/labels/non-reproducible","name":"non-reproducible","color":"fef2c0"},{"url":"https://api.github.com/repos/codeling/bfstop/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-10-20T07:31:00Z","updated_at":"2016-03-15T08:15:06Z","closed_at":null,"body":"Hi. I have found a number of these messages in the plg_system_bfstop.log.php file:\r\n\r\n--- paste ---\r\n2015-03-19T00:58:28+00:00 DEBUG Failed login attempt from IP address 146.0.78.8\r\n2015-03-19T00:58:28+00:00 ERROR Brute Force Stop: Database error (#2006) occured: MySQL server has gone away SQL=INSERT INTO `bfstop_failedlogin` (`ipaddress`,`logtime`,`error`,`username`,`origin`) VALUES ('146.0.78.8','2015-03-18 17:58:28','Username and password do not match or you do not have an account yet.','admin','1')\r\n2015-03-19T00:58:28+00:00 ERROR Brute Force Stop: Database error (#2006) occured: MySQL server has gone away SQL=SELECT COUNT(*) FROM failedlogin t WHERE t.logtime between DATE_SUB('2015-03-18 17:58:28', INTERVAL 1440 MINUTE) AND '2015-03-18 17:58:28' AND ipaddress = '146.0.78.8' AND handled = 0\r\n2015-03-19T00:58:28+00:00 DEBUG Failed logins: 0; allowed: 5\r\n2015-03-19T00:58:28+00:00 ERROR Brute Force Stop: Database error (#2006) occured: MySQL server has gone away SQL=SELECT COUNT(*) FROM bfstop_failedlogin t WHERE t.logtime between DATE_SUB('2015-03-18 17:58:28', INTERVAL 1440 MINUTE) AND '2015-03-18 17:58:28'\r\n2015-03-19T00:58:28+00:00 INFO Sent email to <removed>, subject: Failed login attempt at http://<removed>/; successful\r\n2015-03-19T00:58:28+00:00 ERROR Brute Force Stop: Database error (#2006) occured: MySQL server has gone away SQL=SELECT COUNT(*) FROM bfstop_failedlogin t WHERE t.logtime between DATE_SUB('2015-03-18 17:58:28', INTERVAL 1440 MINUTE) AND '2015-03-18 17:58:28' AND ipaddress = '146.0.78.8' AND handled = 0\r\n--- snip ---\r\n\r\nThe file itself is huge, but there are zero records in the bfstop_failedlogin table."},"comment":{"url":"https://api.github.com/repos/codeling/bfstop/issues/comments/196711211","html_url":"https://github.com/codeling/bfstop/issues/109#issuecomment-196711211","issue_url":"https://api.github.com/repos/codeling/bfstop/issues/109","id":196711211,"user":{"login":"codeling","id":1629217,"avatar_url":"https://avatars.githubusercontent.com/u/1629217?v=3","gravatar_id":"","url":"https://api.github.com/users/codeling","html_url":"https://github.com/codeling","followers_url":"https://api.github.com/users/codeling/followers","following_url":"https://api.github.com/users/codeling/following{/other_user}","gists_url":"https://api.github.com/users/codeling/gists{/gist_id}","starred_url":"https://api.github.com/users/codeling/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codeling/subscriptions","organizations_url":"https://api.github.com/users/codeling/orgs","repos_url":"https://api.github.com/users/codeling/repos","events_url":"https://api.github.com/users/codeling/events{/privacy}","received_events_url":"https://api.github.com/users/codeling/received_events","type":"User","site_admin":false},"created_at":"2016-03-15T08:15:06Z","updated_at":"2016-03-15T08:15:06Z","body":"Have you checked your database server log file?\r\nHave you configured the feature to delete old entries?\r\nWithout additional information I cannot help you and will have to close the issue."}}