{"action":"created","issue":{"url":"https://api.github.com/repos/andryyy/mailcow/issues/682","repository_url":"https://api.github.com/repos/andryyy/mailcow","labels_url":"https://api.github.com/repos/andryyy/mailcow/issues/682/labels{/name}","comments_url":"https://api.github.com/repos/andryyy/mailcow/issues/682/comments","events_url":"https://api.github.com/repos/andryyy/mailcow/issues/682/events","html_url":"https://github.com/andryyy/mailcow/issues/682","id":195829113,"number":682,"title":"MySQL Setup","user":{"login":"BlaM","id":176011,"avatar_url":"https://avatars.githubusercontent.com/u/176011?v=3","gravatar_id":"","url":"https://api.github.com/users/BlaM","html_url":"https://github.com/BlaM","followers_url":"https://api.github.com/users/BlaM/followers","following_url":"https://api.github.com/users/BlaM/following{/other_user}","gists_url":"https://api.github.com/users/BlaM/gists{/gist_id}","starred_url":"https://api.github.com/users/BlaM/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BlaM/subscriptions","organizations_url":"https://api.github.com/users/BlaM/orgs","repos_url":"https://api.github.com/users/BlaM/repos","events_url":"https://api.github.com/users/BlaM/events{/privacy}","received_events_url":"https://api.github.com/users/BlaM/received_events","type":"User","site_admin":false},"labels":[{"id":121598329,"url":"https://api.github.com/repos/andryyy/mailcow/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2016-12-15T15:08:20Z","updated_at":"2016-12-18T20:06:33Z","closed_at":null,"body":"There are several improvements I'd love to see about the initial database setup.\r\n\r\nI have a dedicated MySQL server in my environment, so I want to use that for mailcow.\r\n\r\nHowever:\r\n\r\n* I don't have a \"root\" user that is allowed to log on to the server from outside. For security reasons administrative users are only allowed to log on directly from the database server (localhost connection). I have another user with elevated permissions, but that's not called \"root\".\r\n\r\n* I'm hesistant to give these powerful accounts to anyone but me (i.e. to an install script). I'd prefer to do the first few steps myself and create both the users and the databases manually and have the install script pick up from there.\r\n\r\nI've checked the installation source and everything seems fine, but still... there is that uneasy feeling I get...\r\n\r\nSo: Why not provide two or three more config settings?\r\n\r\n* my_rootuser (to override the \"root\" username - some user with both create and grant permission)\r\n* skip_database_creation\r\n* skip_database_user_creation\r\n\r\nMost other (web) software suites expect me to do the same: provide a fully configured database user and database."},"comment":{"url":"https://api.github.com/repos/andryyy/mailcow/issues/comments/267843107","html_url":"https://github.com/andryyy/mailcow/issues/682#issuecomment-267843107","issue_url":"https://api.github.com/repos/andryyy/mailcow/issues/682","id":267843107,"user":{"login":"Yamakasi","id":4869479,"avatar_url":"https://avatars.githubusercontent.com/u/4869479?v=3","gravatar_id":"","url":"https://api.github.com/users/Yamakasi","html_url":"https://github.com/Yamakasi","followers_url":"https://api.github.com/users/Yamakasi/followers","following_url":"https://api.github.com/users/Yamakasi/following{/other_user}","gists_url":"https://api.github.com/users/Yamakasi/gists{/gist_id}","starred_url":"https://api.github.com/users/Yamakasi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Yamakasi/subscriptions","organizations_url":"https://api.github.com/users/Yamakasi/orgs","repos_url":"https://api.github.com/users/Yamakasi/repos","events_url":"https://api.github.com/users/Yamakasi/events{/privacy}","received_events_url":"https://api.github.com/users/Yamakasi/received_events","type":"User","site_admin":false},"created_at":"2016-12-18T20:06:33Z","updated_at":"2016-12-18T20:06:33Z","body":"If you have a trusted network it doesn't need to be SSL anymore, it also saves a lot of load on SQL servers."}}
{"actor":{"display_login":"Yamakasi"}}