{"action":"created","issue":{"url":"https://api.github.com/repos/radremedy/radremedy/issues/172","labels_url":"https://api.github.com/repos/radremedy/radremedy/issues/172/labels{/name}","comments_url":"https://api.github.com/repos/radremedy/radremedy/issues/172/comments","events_url":"https://api.github.com/repos/radremedy/radremedy/issues/172/events","html_url":"https://github.com/radremedy/radremedy/pull/172","id":58316278,"number":172,"title":"Deployment fixes for WebFaction","user":{"login":"radioprotector","id":8010294,"avatar_url":"https://avatars.githubusercontent.com/u/8010294?v=3","gravatar_id":"","url":"https://api.github.com/users/radioprotector","html_url":"https://github.com/radioprotector","followers_url":"https://api.github.com/users/radioprotector/followers","following_url":"https://api.github.com/users/radioprotector/following{/other_user}","gists_url":"https://api.github.com/users/radioprotector/gists{/gist_id}","starred_url":"https://api.github.com/users/radioprotector/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/radioprotector/subscriptions","organizations_url":"https://api.github.com/users/radioprotector/orgs","repos_url":"https://api.github.com/users/radioprotector/repos","events_url":"https://api.github.com/users/radioprotector/events{/privacy}","received_events_url":"https://api.github.com/users/radioprotector/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/radremedy/radremedy/labels/needs%20review","name":"needs review","color":"eb6420"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-20T06:44:46Z","updated_at":"2015-02-21T02:59:24Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/radremedy/radremedy/pulls/172","html_url":"https://github.com/radremedy/radremedy/pull/172","diff_url":"https://github.com/radremedy/radremedy/pull/172.diff","patch_url":"https://github.com/radremedy/radremedy/pull/172.patch"},"body":"Closes #168.\r\n\r\nThe errors I encountered ended up being due to some changes that happened to flask-admin. I added some explicit endpoints for the ModelViews and that started working.\r\n\r\nAfter that, I ran into issues in the Review admin view because the date_created column, used to sort, wasn't properly-qualified, got confused with the date_created value on the associated resource, and MySQL didn't like that. I updated this view to explicitly reference the review's column.\r\n\r\nAfter that, I also encountered some issues trying to get the CSV import working. Since we didn't have an explicit flask-admin version defined, the server was expecting one thing and my development environment was expecting another. I updated the view to use the latest version and added some explicit version numbers to keep this from happening in the future.\r\n\r\nI also ran into some problems trying to get emails sent out - part of it was due to the need for an EHLO before attempting to connect, and part of it was just due to some security that Gmail likes to apply for anomalous logins. To help test emails, I also added a new config option to allow people to customize the base URL to something other than http://radremedy.org.\r\n\r\nI also updated the MySQL connection string used in accordance with SQLAlchemy's recommendations for MySQL-Python. I also turned on logging, and so there's actually a rolling python.log now available in $HOME for full stack traces.\r\n\r\nI figured we could also go ahead and delete the EBS stuff."},"comment":{"url":"https://api.github.com/repos/radremedy/radremedy/issues/comments/75352570","html_url":"https://github.com/radremedy/radremedy/pull/172#issuecomment-75352570","issue_url":"https://api.github.com/repos/radremedy/radremedy/issues/172","id":75352570,"user":{"login":"AllieDeford","id":6627658,"avatar_url":"https://avatars.githubusercontent.com/u/6627658?v=3","gravatar_id":"","url":"https://api.github.com/users/AllieDeford","html_url":"https://github.com/AllieDeford","followers_url":"https://api.github.com/users/AllieDeford/followers","following_url":"https://api.github.com/users/AllieDeford/following{/other_user}","gists_url":"https://api.github.com/users/AllieDeford/gists{/gist_id}","starred_url":"https://api.github.com/users/AllieDeford/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AllieDeford/subscriptions","organizations_url":"https://api.github.com/users/AllieDeford/orgs","repos_url":"https://api.github.com/users/AllieDeford/repos","events_url":"https://api.github.com/users/AllieDeford/events{/privacy}","received_events_url":"https://api.github.com/users/AllieDeford/received_events","type":"User","site_admin":false},"created_at":"2015-02-21T02:59:24Z","updated_at":"2015-02-21T02:59:24Z","body":"Looks pretty good to me. My only note was that in the config file we're storing the database details in variables referencing RDS (e.g. RDS_USERNAME) which is the Amazon database solution. Should we change them since we're not using Amazon anymore? \r\n\r\nAlso, could you post a link to the deployed site? "}}