Junior Spellweaver
- Joined
- Aug 6, 2015
- Messages
- 105
- Reaction score
- 0
can we set this up in other linux distro like debian?
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!probably yes. in ubuntu 14.04 runs fine
After following everything on the first post and reading most pages within this thread
im stuck with navicat not connecting to the database
a, ip is pingable
b, winscp / secureCRT - connect without an issue at all
I've changed the ips for postgresql multiple times and just cannot connect i currently have it now set to accept all ips and it still will not connect to the database
any help would be great
I think your issue is with the listening IP for postgres...
- Open /var/lib/pgsql/{your-version}/data/postgresql.conf
- Look for line listen_addresses, uncomment it and set it to *, or replace it with listen_addresses = '*'
Try to check if the database is listening in the correct ip/port, a simple netstat -an should answer that for you
tcp 0 0 :::5432 :::* LIST
I think your issue is with the listening IP for postgres...
- Open /var/lib/pgsql/{your-version}/data/postgresql.conf
- Look for line listen_addresses, uncomment it and set it to *, or replace it with listen_addresses = '*'
on centos 6.* -> service iptables stop
on centos 7.* -> systemctl firewalld (or firewall idr) stop
then try connect to postgre
" FATAL: no pg_hba.conf entry for host "192.168.0.101" user postgres database template1
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 192.168.0.108/32 ident
# IPv6 local connections:
host all all ::1/128 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres peer
#host replication postgres 127.0.0.1/32 ident
#host replication postgres ::1/128 ident
changetoCode:# IPv4 local connections: host all all 192.168.0.108/32 ident
Code:# IPv4 local connections: host all all 0.0.0.0/0 md5
in pg_hba.conf then restart your postgresql