{"action":"created","issue":{"url":"https://api.github.com/repos/3-Round-Stones/callimachus/issues/242","labels_url":"https://api.github.com/repos/3-Round-Stones/callimachus/issues/242/labels{/name}","comments_url":"https://api.github.com/repos/3-Round-Stones/callimachus/issues/242/comments","events_url":"https://api.github.com/repos/3-Round-Stones/callimachus/issues/242/events","html_url":"https://github.com/3-Round-Stones/callimachus/issues/242","id":121519733,"number":242,"title":"Localhost credential authority is sent as 127.0.0.1","user":{"login":"edwardsph","id":9445771,"avatar_url":"https://avatars.githubusercontent.com/u/9445771?v=3","gravatar_id":"","url":"https://api.github.com/users/edwardsph","html_url":"https://github.com/edwardsph","followers_url":"https://api.github.com/users/edwardsph/followers","following_url":"https://api.github.com/users/edwardsph/following{/other_user}","gists_url":"https://api.github.com/users/edwardsph/gists{/gist_id}","starred_url":"https://api.github.com/users/edwardsph/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edwardsph/subscriptions","organizations_url":"https://api.github.com/users/edwardsph/orgs","repos_url":"https://api.github.com/users/edwardsph/repos","events_url":"https://api.github.com/users/edwardsph/events{/privacy}","received_events_url":"https://api.github.com/users/edwardsph/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-10T16:04:08Z","updated_at":"2015-12-10T16:46:34Z","closed_at":"2015-12-10T16:28:39Z","body":"A credential set up with the authority localhost:3306 is failing to connect to the database with the message:\r\nCould not connect: Access denied for user 'xxxxxx'@'127.0.0.1' (using password: YES)\r\nThe database does not have a user account for 'xxxxxx'@'127.0.0.1' only for 'xxxxxx'@'localhost'.\r\n\r\nThe workaround is to add the additional user to the database but why is localhost being replaced with 127.0.0.1 when the database does not appear to treat them as the same thing."},"comment":{"url":"https://api.github.com/repos/3-Round-Stones/callimachus/issues/comments/163683782","html_url":"https://github.com/3-Round-Stones/callimachus/issues/242#issuecomment-163683782","issue_url":"https://api.github.com/repos/3-Round-Stones/callimachus/issues/242","id":163683782,"user":{"login":"prototypo","id":824236,"avatar_url":"https://avatars.githubusercontent.com/u/824236?v=3","gravatar_id":"","url":"https://api.github.com/users/prototypo","html_url":"https://github.com/prototypo","followers_url":"https://api.github.com/users/prototypo/followers","following_url":"https://api.github.com/users/prototypo/following{/other_user}","gists_url":"https://api.github.com/users/prototypo/gists{/gist_id}","starred_url":"https://api.github.com/users/prototypo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/prototypo/subscriptions","organizations_url":"https://api.github.com/users/prototypo/orgs","repos_url":"https://api.github.com/users/prototypo/repos","events_url":"https://api.github.com/users/prototypo/events{/privacy}","received_events_url":"https://api.github.com/users/prototypo/received_events","type":"User","site_admin":false},"created_at":"2015-12-10T16:46:34Z","updated_at":"2015-12-10T16:46:34Z","body":"We will work around this by granting database user permissions on 127.0.0.1 as well as localhost.\n\n\nRegards,\nDave\n-- \nDavid Wood\nhttp://about.me/david_wood \n\nOn December 10, 2015 at 11:28:43, James Leigh (notifications@github.com) wrote:\n\nCallimachus' SQL Datasource uses the host in the jdbc URL to lookup the username and password from the credentials. This 127.0.0.1 string, I believe, comes from either the driver's interpretation of the jdbc URL or the network socket interface (and the system's name resolution). Either way, there is nothing Callimachus can do about it.\n\n—\nReply to this email directly or view it on GitHub.\n\n"}}