-
Notifications
You must be signed in to change notification settings - Fork 5k
Description
hi
for install kong on centos7.2-x86-64 i first install "postgresql94-server" and "postgresql94-contrib" package and then run this command :
/usr/pgsql-9.4/bin/postgresql94-setup initdb
and then start postgresql service.
after that i create linux user by name "kong" with "kong" password.
after that i login to postgresql :
su - postgres
and then run :
$psql
and then run this command for create user and database :
CREATE USER kong; CREATE DATABASE kong OWNER kong;
then exit of postgresql and login to linux user kong :
su - kong
for start kong i run this command :
$ kong start
but display this error :
$ kong start
ulimit is currently set to "1024". For better performance set it to at least "4096" using "ulimit -n"
Error: /usr/local/share/lua/5.1/kong/cmd/start.lua:18: [postgres error] FATAL: Ident authentication failed for user "kong"
Run with --v (verbose) or --vv (debug) for more details
for more info :
$ kong start --vv
2016/12/12 23:21:27 [verbose] Kong: 0.9.5
2016/12/12 23:21:27 [debug] ngx_lua: 10006
2016/12/12 23:21:27 [debug] nginx: 1011002
2016/12/12 23:21:27 [debug] Lua: LuaJIT 2.1.0-beta2
2016/12/12 23:21:27 [debug] PRNG seed: 568211172181
2016/12/12 23:21:27 [verbose] reading config file at /etc/kong.conf
2016/12/12 23:21:27 [debug] admin_listen = "0.0.0.0:8001"
2016/12/12 23:21:27 [debug] anonymous_reports = true
2016/12/12 23:21:27 [debug] cassandra_consistency = "ONE"
2016/12/12 23:21:27 [debug] cassandra_contact_points = {"127.0.0.1"}
2016/12/12 23:21:27 [debug] cassandra_data_centers = {"dc1:2","dc2:3"}
2016/12/12 23:21:27 [debug] cassandra_keyspace = "kong"
2016/12/12 23:21:27 [debug] cassandra_port = 9042
2016/12/12 23:21:27 [debug] cassandra_repl_factor = 1
2016/12/12 23:21:27 [debug] cassandra_repl_strategy = "SimpleStrategy"
2016/12/12 23:21:27 [debug] cassandra_ssl = false
2016/12/12 23:21:27 [debug] cassandra_ssl_verify = false
2016/12/12 23:21:27 [debug] cassandra_timeout = 5000
2016/12/12 23:21:27 [debug] cassandra_username = "kong"
2016/12/12 23:21:27 [debug] cluster_listen = "0.0.0.0:7946"
2016/12/12 23:21:27 [debug] cluster_listen_rpc = "127.0.0.1:7373"
2016/12/12 23:21:27 [debug] cluster_profile = "wan"
2016/12/12 23:21:27 [debug] cluster_ttl_on_failure = 3600
2016/12/12 23:21:27 [debug] custom_plugins = {}
2016/12/12 23:21:27 [debug] database = "postgres"
2016/12/12 23:21:27 [debug] dnsmasq = true
2016/12/12 23:21:27 [debug] dnsmasq_port = 8053
2016/12/12 23:21:27 [debug] log_level = "notice"
2016/12/12 23:21:27 [debug] lua_code_cache = "on"
2016/12/12 23:21:27 [debug] lua_package_cpath = ""
2016/12/12 23:21:27 [debug] lua_package_path = "?/init.lua;./kong/?.lua"
2016/12/12 23:21:27 [debug] lua_ssl_verify_depth = 1
2016/12/12 23:21:27 [debug] mem_cache_size = "128m"
2016/12/12 23:21:27 [debug] nginx_daemon = "on"
2016/12/12 23:21:27 [debug] nginx_optimizations = true
2016/12/12 23:21:27 [debug] nginx_worker_processes = "auto"
2016/12/12 23:21:27 [debug] pg_database = "kong"
2016/12/12 23:21:27 [debug] pg_host = "127.0.0.1"
2016/12/12 23:21:27 [debug] pg_password = "******"
2016/12/12 23:21:27 [debug] pg_port = 5432
2016/12/12 23:21:27 [debug] pg_ssl = false
2016/12/12 23:21:27 [debug] pg_ssl_verify = false
2016/12/12 23:21:27 [debug] pg_user = "kong"
2016/12/12 23:21:27 [debug] prefix = "/usr/local/kong/"
2016/12/12 23:21:27 [debug] proxy_listen = "0.0.0.0:8000"
2016/12/12 23:21:27 [debug] proxy_listen_ssl = "0.0.0.0:8443"
2016/12/12 23:21:27 [debug] serf_path = "serf"
2016/12/12 23:21:27 [debug] ssl = true
2016/12/12 23:21:27 [verbose] prefix in use: /usr/local/kong
2016/12/12 23:21:27 [verbose] preparing nginx prefix directory at /usr/local/kong
2016/12/12 23:21:27 [verbose] saving serf identifier to /usr/local/kong/serf/serf.id
2016/12/12 23:21:27 [debug] searching for OpenResty 'resty' executable
2016/12/12 23:21:27 [debug] /usr/local/openresty/bin/resty -V: 'nginx version: openresty/1.11.2.1'
2016/12/12 23:21:27 [debug] found OpenResty 'resty' executable at /usr/local/openresty/bin/resty
2016/12/12 23:21:27 [verbose] saving serf shell script handler to /usr/local/kong/serf/serf_event.sh
2016/12/12 23:21:27 [verbose] SSL enabled, no custom certificate set: using default certificate
2016/12/12 23:21:27 [verbose] default SSL certificate found at /usr/local/kong/ssl/kong-default.crt
2016/12/12 23:21:27 [warn] ulimit is currently set to "1024". For better performance set it to at least "4096" using "ulimit -n"
2016/12/12 23:21:27 [verbose] running datastore migrations
2016/12/12 23:21:27 [verbose] could not start Kong, stopping services
2016/12/12 23:21:27 [verbose] leaving serf cluster
2016/12/12 23:21:27 [verbose] stopping dnsmasq at /usr/local/kong/pids/dnsmasq.pid
2016/12/12 23:21:27 [debug] sending signal to pid at: /usr/local/kong/pids/dnsmasq.pid
2016/12/12 23:21:27 [debug] no pid file at: /usr/local/kong/pids/dnsmasq.pid
2016/12/12 23:21:27 [verbose] stopped services
Error:
/usr/local/share/lua/5.1/kong/cmd/start.lua:37: /usr/local/share/lua/5.1/kong/cmd/start.lua:18: [postgres error] FATAL: Ident authentication failed for user "kong"
stack traceback:
[C]: in function 'error'
/usr/local/share/lua/5.1/kong/cmd/start.lua:37: in function 'cmd_exec'
/usr/local/share/lua/5.1/kong/cmd/init.lua:89: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:89>
[C]: in function 'xpcall'
/usr/local/share/lua/5.1/kong/cmd/init.lua:89: in function </usr/local/share/lua/5.1/kong/cmd/init.lua:45>
/usr/local/bin/kong:15: in function 'file_gen'
init_worker_by_lua:38: in function <init_worker_by_lua:36>
[C]: in function 'pcall'
init_worker_by_lua:45: in function <init_worker_by_lua:43>
$ kong version
0.9.5
$ uname -r
3.10.0-327.el7.x86_64
how can i fix this error?
tnx
Activity
thibaultcha commentedon Dec 12, 2016
Did you properly configure your PostgreSQL server authentication in
pg_hba.conf
?See http://stackoverflow.com/a/2942678/1437192
thibaultcha commentedon Dec 12, 2016
Hint: Kong will connect to your PostgreSQL server via an IPv4 connection. Therefore,
might be a suitable setting, maybe?
hos7ein commentedon Dec 13, 2016
@thibaultcha
tnx man
my problem is Solved.i doing this config :
Install postgresql94 :
Install repo :
install kong :
Configure your database :
edit belowe prameters :
database = postgres # Determines which of PostgreSQL or Cassandra
# this node will use as its datastore.
# Accepted values are
postgres
and#
cassandra
.pg_host = 127.0.0.1 # The PostgreSQL host to connect to.
pg_port = 5432 # The port to connect to.
pg_user = kong # The username to authenticate if required.
pg_password = kong # The password to authenticate if required.
pg_database = kong # The database name to connect to.
pg_ssl = off # Toggles client-server TLS connections
# between Kong and PostgreSQL.
pg_ssl_verify = off # Toggles server certificate verification if
#
pg_ssl
is enabled.# See the
lua_ssl_trusted_certificate
# setting to specify a certificate authority.
edit belowe prametrs :
TYPE DATABASE USER ADDRESS METHOD
"local" is for Unix domain socket connections only
local all all md5
IPv4 local connections:
host all all 127.0.0.1/32 md5
IPv6 local connections:
host all all ::1/128 md5
edit belowe line :
listen_addresses = '*'
For start kong run this command :
test :