[CentOS] Setting up your Aura Kingdom Server

[Clotgooble]

@Hulu Thanks you!!! :D

[kclaire07]

can anybody reupload the server files? dead links.

[Hulu]

I've updated the link again.

[Peter Vandijk]

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

[MaxZeus]

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

Try to check if the database is listening in the correct ip/port, a simple netstat -an should answer that for you :)

[Hulu]

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 = '*'

[MaxZeus]

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 = '*'

Could be, yes, hence why the test I had suggested. :D

[Peter Vandijk]

Try to check if the database is listening in the correct ip/port, a simple netstat -an should answer that for you :)

Result was this.

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 = '*'

That was done correctly as per instructions but double checked and is correct

[Hycker]

on centos 6.* -> service iptables stop
on centos 7.* -> systemctl firewalld (or firewall idr) stop
then try connect to postgre

[Peter Vandijk]

on centos 6.* -> service iptables stop
on centos 7.* -> systemctl firewalld (or firewall idr) stop
then try connect to postgre

I now get the error

" FATAL: no pg_hba.conf entry for host "192.168.0.101" user postgres database template1

for referance

# 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

[Hycker]

change

# IPv4 local connections:
host all all 192.168.0.108/32 ident

to

# IPv4 local connections:
host all all 0.0.0.0/0 md5

in pg_hba.conf then restart your postgresql

[danvalic]

What's wrong?

World log:
5354,2016/03/14 02:09:14,TCP connection: 2**.22.**.124::5560 Connection refused 5355,2016/03/14 02:09:14,SOCKET 19: closed.
5356,2016/03/14 02:09:14,TCP connection: 2**.22.**.124:5560 Connection refused 5357,2016/03/14 02:09:14,SOCKET 19: closed.

+ how to patch world, login servers to my wan ip?

[Pinzy Hay]

then
\i '<path to file>';


Can you tell me which file i should input in postgresql? Thanks

[Ryfon]

change

# IPv4 local connections:
host all all 192.168.0.108/32 ident

to

# IPv4 local connections:
host all all 0.0.0.0/0 md5

in pg_hba.conf then restart your postgresql

should use: "host all all samenet md5" instead simplifies things a lot on a local lan.

[overatedae86]

cannot seem to connect to server through SecureCRT even though I put in the correct IP