{"action":"created","issue":{"url":"https://api.github.com/repos/sipcapture/homer-api/issues/112","repository_url":"https://api.github.com/repos/sipcapture/homer-api","labels_url":"https://api.github.com/repos/sipcapture/homer-api/issues/112/labels{/name}","comments_url":"https://api.github.com/repos/sipcapture/homer-api/issues/112/comments","events_url":"https://api.github.com/repos/sipcapture/homer-api/issues/112/events","html_url":"https://github.com/sipcapture/homer-api/issues/112","id":176890653,"number":112,"title":"login fails on PostgreSQL","user":{"login":"dpocock","id":1236687,"avatar_url":"https://avatars.githubusercontent.com/u/1236687?v=3","gravatar_id":"","url":"https://api.github.com/users/dpocock","html_url":"https://github.com/dpocock","followers_url":"https://api.github.com/users/dpocock/followers","following_url":"https://api.github.com/users/dpocock/following{/other_user}","gists_url":"https://api.github.com/users/dpocock/gists{/gist_id}","starred_url":"https://api.github.com/users/dpocock/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dpocock/subscriptions","organizations_url":"https://api.github.com/users/dpocock/orgs","repos_url":"https://api.github.com/users/dpocock/repos","events_url":"https://api.github.com/users/dpocock/events{/privacy}","received_events_url":"https://api.github.com/users/dpocock/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-09-14T12:10:53Z","updated_at":"2016-09-15T09:59:47Z","closed_at":null,"body":"\r\n\r\nThe Apache ```error.log``` contains the following:\r\n\r\n```\r\nFail to execute query: [SELECT * FROM user WHERE username='admin' AND password = PASSWORD('test123');]\r\nERROR:  column \"username\" does not exist\r\n```\r\n\r\nThis query appears to work though, notice it uses quotes around ```user``` and it uses ```md5``` instead of ```password```\r\n\r\n```\r\nSELECT * FROM \"user\" WHERE username='admin' AND password = md5('test123');\r\n```\r\n\r\nThis was observed in 5.0.5"},"comment":{"url":"https://api.github.com/repos/sipcapture/homer-api/issues/comments/247287083","html_url":"https://github.com/sipcapture/homer-api/issues/112#issuecomment-247287083","issue_url":"https://api.github.com/repos/sipcapture/homer-api/issues/112","id":247287083,"user":{"login":"adubovikov","id":4513061,"avatar_url":"https://avatars.githubusercontent.com/u/4513061?v=3","gravatar_id":"","url":"https://api.github.com/users/adubovikov","html_url":"https://github.com/adubovikov","followers_url":"https://api.github.com/users/adubovikov/followers","following_url":"https://api.github.com/users/adubovikov/following{/other_user}","gists_url":"https://api.github.com/users/adubovikov/gists{/gist_id}","starred_url":"https://api.github.com/users/adubovikov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adubovikov/subscriptions","organizations_url":"https://api.github.com/users/adubovikov/orgs","repos_url":"https://api.github.com/users/adubovikov/repos","events_url":"https://api.github.com/users/adubovikov/events{/privacy}","received_events_url":"https://api.github.com/users/adubovikov/received_events","type":"User","site_admin":false},"created_at":"2016-09-15T09:59:47Z","updated_at":"2016-09-15T09:59:47Z","body":"can we close the ticket ?"}}
{"actor":{"display_login":"adubovikov"}}