{"action":"created","issue":{"url":"https://api.github.com/repos/Mashape/kong/issues/1436","repository_url":"https://api.github.com/repos/Mashape/kong","labels_url":"https://api.github.com/repos/Mashape/kong/issues/1436/labels{/name}","comments_url":"https://api.github.com/repos/Mashape/kong/issues/1436/comments","events_url":"https://api.github.com/repos/Mashape/kong/issues/1436/events","html_url":"https://github.com/Mashape/kong/issues/1436","id":167180336,"number":1436,"title":"Error when running `kong start` command with Postgresql","user":{"login":"WendySanarwanto","id":18456618,"avatar_url":"https://avatars1.githubusercontent.com/u/18456618?v=3","gravatar_id":"","url":"https://api.github.com/users/WendySanarwanto","html_url":"https://github.com/WendySanarwanto","followers_url":"https://api.github.com/users/WendySanarwanto/followers","following_url":"https://api.github.com/users/WendySanarwanto/following{/other_user}","gists_url":"https://api.github.com/users/WendySanarwanto/gists{/gist_id}","starred_url":"https://api.github.com/users/WendySanarwanto/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WendySanarwanto/subscriptions","organizations_url":"https://api.github.com/users/WendySanarwanto/orgs","repos_url":"https://api.github.com/users/WendySanarwanto/repos","events_url":"https://api.github.com/users/WendySanarwanto/events{/privacy}","received_events_url":"https://api.github.com/users/WendySanarwanto/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":16,"created_at":"2016-07-23T11:28:09Z","updated_at":"2017-05-19T17:01:15Z","closed_at":"2016-07-24T01:17:04Z","body":"### Summary\n\nWhen following the kong's installation instructions on this [link](https://getkong.org/install/ubuntu/) and configured `kong` to use `Postgresql` database, running `kong start` command was failing as shown in this following screenshot:\n\n![image](https://cloud.githubusercontent.com/assets/18456618/17077658/2bfd1704-510a-11e6-8e8d-c6371dd2f5f1.png)\n### Steps To Reproduce\n1. Ensure that we have a machine or cloud instance which runs Ubuntu OS version 14.04 LTS.\n2. Ensure that we have installed Postgresql (version 9.3) on the Ubuntu machine, had given password on the `postgres` account and had created `kong` database on it.  The content of `/etc/postgresql/9.3/main/pg_hba.conf` is configured as follow:\n   ![image](https://cloud.githubusercontent.com/assets/18456618/17077668/b268ac4a-510a-11e6-9e54-105ee0ab50b7.png)\n3. Follow installation's instructions on this [link](https://getkong.org/install/ubuntu/).\n4. Configure kong's config file (`/etc/kong/kong.yml`) as in the following screenshot:\n   ![image](https://cloud.githubusercontent.com/assets/18456618/17077675/f4848946-510a-11e6-9f0f-31678dab44d2.png)\n5. Run `kong start` command. Confirm that it is failing and show `[ERR] ERROR: function to_regclass(unknown) does not exist (8) [ERR] Could not start Kong` messages.\n### Additional Details & Logs\n- Kong version: 0.8.3\n- Kong configuration: No registered APIs & Plugins have been installed.\n- Kong error logs (`<KONG_PREFIX>/logs/error.log`):\n\n`[INFO] kong 0.8.3\n[INFO] Using configuration: /etc/kong/kong.yml\n[INFO] Setting working directory to /usr/local/kong\n[INFO] database...........postgres host=127.0.0.1 database=kong user=postgres password=test123 port=5432\n[INFO] Leaving cluster..\n[ERR] ERROR: function to_regclass(unknown) does not exist (8)\n[ERR] Could not start Kong`\n- Operating System: Ubuntu 14.04 LTS\n"},"comment":{"url":"https://api.github.com/repos/Mashape/kong/issues/comments/302757348","html_url":"https://github.com/Mashape/kong/issues/1436#issuecomment-302757348","issue_url":"https://api.github.com/repos/Mashape/kong/issues/1436","id":302757348,"user":{"login":"john-paul-keenan","id":5402354,"avatar_url":"https://avatars3.githubusercontent.com/u/5402354?v=3","gravatar_id":"","url":"https://api.github.com/users/john-paul-keenan","html_url":"https://github.com/john-paul-keenan","followers_url":"https://api.github.com/users/john-paul-keenan/followers","following_url":"https://api.github.com/users/john-paul-keenan/following{/other_user}","gists_url":"https://api.github.com/users/john-paul-keenan/gists{/gist_id}","starred_url":"https://api.github.com/users/john-paul-keenan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/john-paul-keenan/subscriptions","organizations_url":"https://api.github.com/users/john-paul-keenan/orgs","repos_url":"https://api.github.com/users/john-paul-keenan/repos","events_url":"https://api.github.com/users/john-paul-keenan/events{/privacy}","received_events_url":"https://api.github.com/users/john-paul-keenan/received_events","type":"User","site_admin":false},"created_at":"2017-05-19T17:01:14Z","updated_at":"2017-05-19T17:01:14Z","body":"@MMIHOLDINGS , Can you confirm Postgres is running when you get the 'Error: /usr/local/share/lua/5.1/kong/cmd/start.lua:21: [postgres error] could not get current migrations: [postgres error] connection refused` error? \r\n\r\nIf you confirm it is up and running and continue to get the error, can you try connecting to Postgres manually with `psql`"}}
{"actor":{"display_login":"john-paul-keenan"}}