{"action":"created","issue":{"url":"https://api.github.com/repos/Mashape/kong/issues/1672","repository_url":"https://api.github.com/repos/Mashape/kong","labels_url":"https://api.github.com/repos/Mashape/kong/issues/1672/labels{/name}","comments_url":"https://api.github.com/repos/Mashape/kong/issues/1672/comments","events_url":"https://api.github.com/repos/Mashape/kong/issues/1672/events","html_url":"https://github.com/Mashape/kong/issues/1672","id":178636153,"number":1672,"title":"Kong 0.9.2 startup failure on Ubuntu","user":{"login":"latesh","id":41848,"avatar_url":"https://avatars.githubusercontent.com/u/41848?v=3","gravatar_id":"","url":"https://api.github.com/users/latesh","html_url":"https://github.com/latesh","followers_url":"https://api.github.com/users/latesh/followers","following_url":"https://api.github.com/users/latesh/following{/other_user}","gists_url":"https://api.github.com/users/latesh/gists{/gist_id}","starred_url":"https://api.github.com/users/latesh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/latesh/subscriptions","organizations_url":"https://api.github.com/users/latesh/orgs","repos_url":"https://api.github.com/users/latesh/repos","events_url":"https://api.github.com/users/latesh/events{/privacy}","received_events_url":"https://api.github.com/users/latesh/received_events","type":"User","site_admin":false},"labels":[{"id":206318891,"url":"https://api.github.com/repos/Mashape/kong/labels/area/DAO","name":"area/DAO","color":"d4c5f9","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-09-22T15:06:24Z","updated_at":"2016-12-22T18:39:15Z","closed_at":"2016-09-22T21:37:10Z","body":"Hello,\n\nI followed [this guide](https://getkong.org/install/ubuntu/) to install Kong 0.9.2 on Ubuntu 14.04 along with Postgres 9.5.4. It fails to start and throws the following error:\n\n```\nubuntu@ip-172-31-14-202:~$ kong start -vv\n2016/09/22 14:51:36 [verbose] no config file found at /etc/kong.conf\n2016/09/22 14:51:36 [verbose] reading config file at /etc/kong/kong.conf\n2016/09/22 14:51:36 [debug] admin_listen = \"0.0.0.0:8001\"\n2016/09/22 14:51:36 [debug] anonymous_reports = true\n2016/09/22 14:51:36 [debug] cassandra_consistency = \"ONE\"\n2016/09/22 14:51:36 [debug] cassandra_contact_points = {\"127.0.0.1\"}\n2016/09/22 14:51:36 [debug] cassandra_data_centers = {\"dc1:2\",\"dc2:3\"}\n2016/09/22 14:51:36 [debug] cassandra_keyspace = \"kong\"\n2016/09/22 14:51:36 [debug] cassandra_port = 9042\n2016/09/22 14:51:36 [debug] cassandra_repl_factor = 1\n2016/09/22 14:51:36 [debug] cassandra_repl_strategy = \"SimpleStrategy\"\n2016/09/22 14:51:36 [debug] cassandra_ssl = false\n2016/09/22 14:51:36 [debug] cassandra_ssl_verify = false\n2016/09/22 14:51:36 [debug] cassandra_timeout = 5000\n2016/09/22 14:51:36 [debug] cassandra_username = \"kong\"\n2016/09/22 14:51:36 [debug] cluster_listen = \"0.0.0.0:7946\"\n2016/09/22 14:51:36 [debug] cluster_listen_rpc = \"127.0.0.1:7373\"\n2016/09/22 14:51:36 [debug] cluster_profile = \"wan\"\n2016/09/22 14:51:36 [debug] cluster_ttl_on_failure = 3600\n2016/09/22 14:51:36 [debug] custom_plugins = {}\n2016/09/22 14:51:36 [debug] database = \"postgres\"\n2016/09/22 14:51:36 [debug] dnsmasq = true\n2016/09/22 14:51:36 [debug] dnsmasq_port = 8053\n2016/09/22 14:51:36 [debug] log_level = \"notice\"\n2016/09/22 14:51:36 [debug] lua_code_cache = \"on\"\n2016/09/22 14:51:36 [debug] lua_package_cpath = \"\"\n2016/09/22 14:51:36 [debug] lua_package_path = \"?/init.lua;./kong/?.lua\"\n2016/09/22 14:51:36 [debug] lua_ssl_verify_depth = 1\n2016/09/22 14:51:36 [debug] mem_cache_size = \"128m\"\n2016/09/22 14:51:36 [debug] nginx_daemon = \"on\"\n2016/09/22 14:51:36 [debug] nginx_optimizations = true\n2016/09/22 14:51:36 [debug] nginx_worker_processes = \"auto\"\n2016/09/22 14:51:36 [debug] pg_database = \"kong\"\n2016/09/22 14:51:36 [debug] pg_host = \"127.0.0.1\"\n2016/09/22 14:51:36 [debug] pg_password = \"******\"\n2016/09/22 14:51:36 [debug] pg_port = 5432\n2016/09/22 14:51:36 [debug] pg_ssl = false\n2016/09/22 14:51:36 [debug] pg_ssl_verify = false\n2016/09/22 14:51:36 [debug] pg_user = \"kong\"\n2016/09/22 14:51:36 [debug] prefix = \"/usr/local/kong/\"\n2016/09/22 14:51:36 [debug] proxy_listen = \"0.0.0.0:8000\"\n2016/09/22 14:51:36 [debug] proxy_listen_ssl = \"0.0.0.0:8443\"\n2016/09/22 14:51:36 [debug] serf_path = \"serf\"\n2016/09/22 14:51:36 [debug] ssl = true\n2016/09/22 14:51:36 [verbose] prefix in use: /usr/local/kong\n2016/09/22 14:51:36 [verbose] preparing nginx prefix directory at /usr/local/kong\n2016/09/22 14:51:36 [verbose] saving serf identifier to /usr/local/kong/serf/serf.id\n2016/09/22 14:51:36 [debug] searching for OpenResty 'resty' executable\n2016/09/22 14:51:36 [debug] /usr/local/openresty/bin/resty -V: 'nginx version: openresty/1.9.15.1'\n2016/09/22 14:51:36 [debug] found OpenResty 'resty' executable at /usr/local/openresty/bin/resty\n2016/09/22 14:51:36 [verbose] saving serf shell script handler to /usr/local/kong/serf/serf_event.sh\n2016/09/22 14:51:36 [verbose] SSL enabled, no custom certificate set: using default certificate\n2016/09/22 14:51:36 [verbose] default SSL certificate found at /usr/local/kong/ssl/kong-default.crt\n2016/09/22 14:51:36 [warn] ulimit is currently set to \"1024\". For better performance set it to at least \"4096\" using \"ulimit -n\"\n2016/09/22 14:51:36 [verbose] running datastore migrations\n2016/09/22 14:51:36 [verbose] could not start Kong, stopping services\n2016/09/22 14:51:36 [verbose] leaving serf cluster\n2016/09/22 14:51:37 [verbose] stopping dnsmasq at /usr/local/kong/pids/dnsmasq.pid\n2016/09/22 14:51:37 [debug] sending signal to pid at: /usr/local/kong/pids/dnsmasq.pid\n2016/09/22 14:51:37 [debug] no pid file at: /usr/local/kong/pids/dnsmasq.pid\n2016/09/22 14:51:37 [verbose] stopped services\nError:\n/usr/local/share/lua/5.1/kong/cmd/start.lua:41: /usr/local/share/lua/5.1/kong/cmd/start.lua:22: [postgres error] ERROR: function to_regclass(unknown) does not exist (8)\nstack traceback:\n        [C]: in function 'error'\n        /usr/local/share/lua/5.1/kong/cmd/start.lua:41: in function 'cmd_exec'\n        /usr/local/share/lua/5.1/kong/cmd/init.lua:81: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:81>\n        [C]: in function 'xpcall'\n        /usr/local/share/lua/5.1/kong/cmd/init.lua:81: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:42>\n        /usr/local/bin/kong:13: in function 'file_gen'\n        init_worker_by_lua:38: in function <init_worker_by_lua:36>\n        [C]: in function 'pcall'\n        init_worker_by_lua:45: in function <init_worker_by_lua:43>\nubuntu@ip-172-31-14-202:~$\n```\n### Steps To Reproduce\n\n```\n$ sudo apt-get update\n$ sudo apt-get install netcat openssl libpcre3 dnsmasq procps perl\n$ sudo dpkg -i kong-0.9.2.*.deb\n```\n\nInstall Postgres\n\n```\n$ sudo sh -c 'echo \"deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main\" > /etc/apt/sources.list.d/pgdg.list'\n$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -\n$ sudo apt-get update\n$ sudo apt-get upgrade\n$ sudo apt-get install postgresql\n```\n\nConfigured /etc/kong/kong.conf file with Postgres credentials, rest everything set to default values.\n### Additional Details\n\n```\n$ kong version\n0.9.2\n$ psql -V\npsql (PostgreSQL) 9.5.4\n$ lsb_release -a\nNo LSB modules are available.\nDistributor ID: Ubuntu\nDescription:    Ubuntu 14.04.4 LTS\nRelease:        14.04\nCodename:       trusty\n```\n"},"comment":{"url":"https://api.github.com/repos/Mashape/kong/issues/comments/268862693","html_url":"https://github.com/Mashape/kong/issues/1672#issuecomment-268862693","issue_url":"https://api.github.com/repos/Mashape/kong/issues/1672","id":268862693,"user":{"login":"shivarajnaidu","id":12374494,"avatar_url":"https://avatars.githubusercontent.com/u/12374494?v=3","gravatar_id":"","url":"https://api.github.com/users/shivarajnaidu","html_url":"https://github.com/shivarajnaidu","followers_url":"https://api.github.com/users/shivarajnaidu/followers","following_url":"https://api.github.com/users/shivarajnaidu/following{/other_user}","gists_url":"https://api.github.com/users/shivarajnaidu/gists{/gist_id}","starred_url":"https://api.github.com/users/shivarajnaidu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shivarajnaidu/subscriptions","organizations_url":"https://api.github.com/users/shivarajnaidu/orgs","repos_url":"https://api.github.com/users/shivarajnaidu/repos","events_url":"https://api.github.com/users/shivarajnaidu/events{/privacy}","received_events_url":"https://api.github.com/users/shivarajnaidu/received_events","type":"User","site_admin":false},"created_at":"2016-12-22T18:39:15Z","updated_at":"2016-12-22T18:39:15Z","body":"I too facing same problem.. please let us know proper reason and solution for this issue ... Thanks in advance :)"}}
{"actor":{"display_login":"shivarajnaidu"}}