{"action":"closed","issue":{"url":"https://api.github.com/repos/Coral-erm/Coral/issues/175","repository_url":"https://api.github.com/repos/Coral-erm/Coral","labels_url":"https://api.github.com/repos/Coral-erm/Coral/issues/175/labels{/name}","comments_url":"https://api.github.com/repos/Coral-erm/Coral/issues/175/comments","events_url":"https://api.github.com/repos/Coral-erm/Coral/issues/175/events","html_url":"https://github.com/Coral-erm/Coral/issues/175","id":209926548,"number":175,"title":"CORAL fails after installation with separate DB host","user":{"login":"jamesrf","id":160497,"avatar_url":"https://avatars3.githubusercontent.com/u/160497?v=3","gravatar_id":"","url":"https://api.github.com/users/jamesrf","html_url":"https://github.com/jamesrf","followers_url":"https://api.github.com/users/jamesrf/followers","following_url":"https://api.github.com/users/jamesrf/following{/other_user}","gists_url":"https://api.github.com/users/jamesrf/gists{/gist_id}","starred_url":"https://api.github.com/users/jamesrf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jamesrf/subscriptions","organizations_url":"https://api.github.com/users/jamesrf/orgs","repos_url":"https://api.github.com/users/jamesrf/repos","events_url":"https://api.github.com/users/jamesrf/events{/privacy}","received_events_url":"https://api.github.com/users/jamesrf/received_events","type":"User","site_admin":false},"labels":[{"id":338834592,"url":"https://api.github.com/repos/Coral-erm/Coral/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/Coral-erm/Coral/milestones/2","html_url":"https://github.com/Coral-erm/Coral/milestone/2","labels_url":"https://api.github.com/repos/Coral-erm/Coral/milestones/2/labels","id":2345989,"number":2,"title":"Version 2.0.0","description":"Final 2.0.0 release","creator":{"login":"jeffnm","id":651304,"avatar_url":"https://avatars3.githubusercontent.com/u/651304?v=3","gravatar_id":"","url":"https://api.github.com/users/jeffnm","html_url":"https://github.com/jeffnm","followers_url":"https://api.github.com/users/jeffnm/followers","following_url":"https://api.github.com/users/jeffnm/following{/other_user}","gists_url":"https://api.github.com/users/jeffnm/gists{/gist_id}","starred_url":"https://api.github.com/users/jeffnm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jeffnm/subscriptions","organizations_url":"https://api.github.com/users/jeffnm/orgs","repos_url":"https://api.github.com/users/jeffnm/repos","events_url":"https://api.github.com/users/jeffnm/events{/privacy}","received_events_url":"https://api.github.com/users/jeffnm/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":11,"state":"open","created_at":"2017-02-24T15:09:10Z","updated_at":"2017-04-20T21:41:32Z","due_on":null,"closed_at":null},"comments":18,"created_at":"2017-02-24T00:31:00Z","updated_at":"2017-04-20T21:41:32Z","closed_at":"2017-04-20T21:41:32Z","body":"I am running the installer with my DB on a separate host (let's call it \"dbhost\").  I entered this value where it said \"Host\".  I can get through the installer successfully and get the main menu screen.\r\n\r\nWhen I select a module I get this:\r\n'Access denied for user 'coral_user'@webserver' (using password: YES) in '.... etc\r\n\r\nWhen I peek at the MySQL users table, I see that it has created a user coral_user@dbhost and granted permissions to that.  \r\n\r\nI could not find a way to separately specify the db host from the web host.  It might be good to offer that option.  Or, the installer could use '%' as a host, although that may not be ideal as far as principle of least priviledge, so maybe have a note/advice/guide about securing your installation.\r\n\r\n\r\n"}}
{"actor":{"display_login":"jeffnm"}}