{"action":"created","issue":{"url":"https://api.github.com/repos/sqall01/alertR/issues/15","repository_url":"https://api.github.com/repos/sqall01/alertR","labels_url":"https://api.github.com/repos/sqall01/alertR/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/sqall01/alertR/issues/15/comments","events_url":"https://api.github.com/repos/sqall01/alertR/issues/15/events","html_url":"https://github.com/sqall01/alertR/issues/15","id":159226610,"number":15,"title":"v.4 Setup Questions","user":{"login":"rlefever","id":1399985,"avatar_url":"https://avatars.githubusercontent.com/u/1399985?v=3","gravatar_id":"","url":"https://api.github.com/users/rlefever","html_url":"https://github.com/rlefever","followers_url":"https://api.github.com/users/rlefever/followers","following_url":"https://api.github.com/users/rlefever/following{/other_user}","gists_url":"https://api.github.com/users/rlefever/gists{/gist_id}","starred_url":"https://api.github.com/users/rlefever/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rlefever/subscriptions","organizations_url":"https://api.github.com/users/rlefever/orgs","repos_url":"https://api.github.com/users/rlefever/repos","events_url":"https://api.github.com/users/rlefever/events{/privacy}","received_events_url":"https://api.github.com/users/rlefever/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-06-08T17:29:57Z","updated_at":"2016-06-10T06:26:08Z","closed_at":null,"body":"I have successfully (I think) setup the server and found a few things curious.\r\n1. The database alertr is created but has no tables. Do I need to manually create the SQL scripts to create the tables? Looks like the Manager Client DB does the same.\r\n2. Is it possible to access the 'alertR server' at this point or does more need to be installed? \r\n3. Is the Phone App just using the phone's browser to access a web page? I don't see an app to install on the phone.\r\n\r\nLast be not least, I would be glad to share my documentation/notes about my attempt to install with you to assist in getting the examples and docs updated. Love to help."},"comment":{"url":"https://api.github.com/repos/sqall01/alertR/issues/comments/225103420","html_url":"https://github.com/sqall01/alertR/issues/15#issuecomment-225103420","issue_url":"https://api.github.com/repos/sqall01/alertR/issues/15","id":225103420,"user":{"login":"sqall01","id":5772069,"avatar_url":"https://avatars.githubusercontent.com/u/5772069?v=3","gravatar_id":"","url":"https://api.github.com/users/sqall01","html_url":"https://github.com/sqall01","followers_url":"https://api.github.com/users/sqall01/followers","following_url":"https://api.github.com/users/sqall01/following{/other_user}","gists_url":"https://api.github.com/users/sqall01/gists{/gist_id}","starred_url":"https://api.github.com/users/sqall01/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sqall01/subscriptions","organizations_url":"https://api.github.com/users/sqall01/orgs","repos_url":"https://api.github.com/users/sqall01/repos","events_url":"https://api.github.com/users/sqall01/events{/privacy}","received_events_url":"https://api.github.com/users/sqall01/received_events","type":"User","site_admin":false},"created_at":"2016-06-10T06:26:08Z","updated_at":"2016-06-10T06:26:08Z","body":"This error is from the mysql log file correct? This is really strange, because the alertR server not use ALTER TABLE. The only SQL commands it uses are CREATE, SELECT, UPDATE, INSERT and DELETE.\r\n\r\nAre you sure you have given the user you are using for the alertR server the correct permissions? To be able to use the alertR server with MySQL, you have to do the following manually before:\r\n\r\nmysql> create database alertr;\r\nmysql> CREATE USER 'alertr'@'localhost' IDENTIFIED BY '<SECRET>';\r\nmysql> GRANT ALL ON alertr.* TO 'alertr'@'localhost';\r\n\r\nThis creates the database \"alertr\" and the user \"alertr\" that has full access to the database. The credentials have to be configured in the alertR server configuration file.\r\n\r\nAre there any error messages in the alertR log file?"}}
{"actor":{"display_login":"sqall01"}}