{"action":"created","issue":{"url":"https://api.github.com/repos/mitro-co/emailer/issues/1","labels_url":"https://api.github.com/repos/mitro-co/emailer/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/mitro-co/emailer/issues/1/comments","events_url":"https://api.github.com/repos/mitro-co/emailer/issues/1/events","html_url":"https://github.com/mitro-co/emailer/issues/1","id":63605210,"number":1,"title":"cannot connect to postgresql database","user":{"login":"shea256","id":994646,"avatar_url":"https://avatars.githubusercontent.com/u/994646?v=3","gravatar_id":"","url":"https://api.github.com/users/shea256","html_url":"https://github.com/shea256","followers_url":"https://api.github.com/users/shea256/followers","following_url":"https://api.github.com/users/shea256/following{/other_user}","gists_url":"https://api.github.com/users/shea256/gists{/gist_id}","starred_url":"https://api.github.com/users/shea256/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shea256/subscriptions","organizations_url":"https://api.github.com/users/shea256/orgs","repos_url":"https://api.github.com/users/shea256/repos","events_url":"https://api.github.com/users/shea256/events{/privacy}","received_events_url":"https://api.github.com/users/shea256/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-03-23T02:23:33Z","updated_at":"2015-08-06T12:26:40Z","closed_at":null,"body":"Hi when I started up the emailer for the first time I got this:\r\n\r\n```\r\n(mitromailer)mitro-mailer-$ python emailer.py\r\nINFO:root:Starting up email queue\r\nCRITICAL:root:(OperationalError) could not connect to server: Connection refused\r\n\tIs the server running on host \"localhost\" (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 5432?\r\n```\r\n\r\nAfter messing around with it for a bit, I realized that I had to start up postgresql and then create a database and a user and then the appropriate tables.\r\n\r\nI've never used postgresql or sqlalchemy before, so I've just been going off of what I could google. I gather there's a simple way to create the db, user, tables, etc. just from the file `email_queue_model.py`. If so, could you please advise what that is?\r\n\r\nAlso, I would like to suggest including instructions for this part in the setup guide."},"comment":{"url":"https://api.github.com/repos/mitro-co/emailer/issues/comments/128348621","html_url":"https://github.com/mitro-co/emailer/issues/1#issuecomment-128348621","issue_url":"https://api.github.com/repos/mitro-co/emailer/issues/1","id":128348621,"user":{"login":"servomac","id":8616889,"avatar_url":"https://avatars.githubusercontent.com/u/8616889?v=3","gravatar_id":"","url":"https://api.github.com/users/servomac","html_url":"https://github.com/servomac","followers_url":"https://api.github.com/users/servomac/followers","following_url":"https://api.github.com/users/servomac/following{/other_user}","gists_url":"https://api.github.com/users/servomac/gists{/gist_id}","starred_url":"https://api.github.com/users/servomac/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/servomac/subscriptions","organizations_url":"https://api.github.com/users/servomac/orgs","repos_url":"https://api.github.com/users/servomac/repos","events_url":"https://api.github.com/users/servomac/events{/privacy}","received_events_url":"https://api.github.com/users/servomac/received_events","type":"User","site_admin":false},"created_at":"2015-08-06T12:26:40Z","updated_at":"2015-08-06T12:26:40Z","body":"It is possible to connect to a postgres server using a real password, not a null one?"}}