{"action":"opened","issue":{"url":"https://api.github.com/repos/itsabot/abot/issues/172","repository_url":"https://api.github.com/repos/itsabot/abot","labels_url":"https://api.github.com/repos/itsabot/abot/issues/172/labels{/name}","comments_url":"https://api.github.com/repos/itsabot/abot/issues/172/comments","events_url":"https://api.github.com/repos/itsabot/abot/issues/172/events","html_url":"https://github.com/itsabot/abot/issues/172","id":172291925,"number":172,"title":"Setup on postgres database on custom port","user":{"login":"Larpon","id":768942,"avatar_url":"https://avatars.githubusercontent.com/u/768942?v=3","gravatar_id":"","url":"https://api.github.com/users/Larpon","html_url":"https://github.com/Larpon","followers_url":"https://api.github.com/users/Larpon/followers","following_url":"https://api.github.com/users/Larpon/following{/other_user}","gists_url":"https://api.github.com/users/Larpon/gists{/gist_id}","starred_url":"https://api.github.com/users/Larpon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Larpon/subscriptions","organizations_url":"https://api.github.com/users/Larpon/orgs","repos_url":"https://api.github.com/users/Larpon/repos","events_url":"https://api.github.com/users/Larpon/events{/privacy}","received_events_url":"https://api.github.com/users/Larpon/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-08-20T21:34:34Z","updated_at":"2016-08-20T21:34:34Z","closed_at":null,"body":"I've tried several times in so many ways to install Abot - but the dbsetup.sh keeps me from testing anything. I have postgres 9.5.3 running passwordless - but on port 5433.\r\n\r\nthe dbsetup.sh script keep failing to parse what I give it:\r\n```\r\ntestProject$ cmd/dbsetup.sh postgres:@localhost:5433\r\n    [ok] checking for psql binary\r\n    [ok] checking postgres connection\r\n    [--] checking for database\r\n          database missing. creating it\r\n   [err] creating  database\r\n         could not create  database\r\n\r\n   [cmd] psql -w -h 'localhost' -p '5433' -U 'postgres' -v ON_ERROR_STOP=1 -c 'create database '\r\n\r\nERROR:  syntax error at end of input\r\nLINE 1: create database \r\n                        ^\r\n```\r\nMany errors like this - I ended up doing a search and replace in the setup script changing 5432 to 5433 everywhere - which got it installed - but running:\r\n```\r\ntestProject$ abot server\r\n2016/08/20 23:17:05 could not start server. could not connect to database: dial tcp 127.0.0.1:5432: getsockopt: connection refused\r\nexit status 1\r\n```\r\nI can see it's still trying to use port 5432? I've tried changing PORT it in abot.env with no luck"}}
{"actor":{"display_login":"Larpon"}}