[CentOS] Setting up your Aura Kingdom Server

[NetTrodon]

Anyone managed to get the server to work online with other people access the server?
Offline i managed to be able to play the game, but when i tried to get my friend onto my server he is unable to login.
His error is this :
Attachment 154161
I port forward 6543,5567,5568,10021,10022 and even tried 5432 and 80 but he is still getting this error..
Anyone know how to fix this?

Sadly, port forwarding will not be posible without a reliable IP Address patch. Some binaries are bounding to a specific IP address instead of 0.0.0.0 (any address).

On database you are saving the "external/public" IP Address (i.e. 208.34.56.7), when executable starts, it tries to bound to that IP, sadly, your real "private" IP (i.e. 192.168.1.X) is not same.

You can try to assign the server computer to DMZ on router/modem. Likely router/modem will assign the public IP Address (i. e. 208.34.56.7) to computer in DMZ, making port forwarding unnecessary.

[evestu]

Sadly, port forwarding will not be posible without a reliable IP Address patch. Some binaries are bounding to a specific IP address instead of 0.0.0.0 (any address).

On database you are saving the "external/public" IP Address (i.e. 208.34.56.7), when executable starts, it tries to bound to that IP, sadly, your real "private" IP (i.e. 192.168.1.X) is not same.

You can try to assign the server computer to DMZ on router/modem. Likely router/modem will assign the public IP Address (i. e. 208.34.56.7) to computer in DMZ, making port forwarding unnecessary.

Page 14 i released a patcher for wan Play follow the instructions it works, i have connected from home, work, and my bros place.

[editorzone]

Help Me Please
I'm Not \i Command
Sorry My Bad English

[WireShark]

Help Me Please
I'm Not \i Command
Sorry My Bad English

This is the correct command \i '[full path andfile name with extension]';

Example in my case: \i '/home/folder1/data.sql';

[editorzone]

This is the correct command \i '[full path andfile name with extension]';

Example in my case: \i '/home/folder1/data.sql';

I'm Not Connecting Database By Navicat

[kamito]

Fix Failes .Where ?

[geraldlimz]

Page 14 i released a patcher for wan Play follow the instructions it works, i have connected from home, work, and my bros place.

Evestu i did follow your instructions @ page 14, and used AK WAN Updater to patched both my worldserver and they are both like 109mb+, and before that i also use the AK IP updater to patch Loginserver,missionserver,Worldserver and zoneserver to my gateway address.
But my friend is still unable to login as it says system error. And i am sure he can sort of access my server as he is not stuck at the Logging in... message.
Any idea why is this happening?

[WireShark]

I'm Not Connecting Database By Navicat

Did you read all on first post? please don't skip anything.

Eperty123 Said

Edit as of october 28:
I've included fixes for any database errors/in-game bugs that may have happened to you and at this case I had to use PostgreSQL's sql structure so you'll have to find "Eperty123" in all the database sql's and edit them to your databases' username. Enjoy!

@kamito
Fix Failes .Where ? On the first page

Please read carefully and follow the Instructions so you can make the server work.

[kamito]

2,2015/10/30 02:18:22,Server is rolling on TCP 0.0.0.0:18624. ??

- - - Updated - - -

What to do with Fix Failes ?

- - - Updated - - -

SQL error.
There are clean?

- - - Updated - - -

What is a fully running server?

- - - Updated - - -

Can anyone make the fix files in my ip?
And what to do with files fix?

[Eperty123]

2,2015/10/30 02:18:22,Server is rolling on TCP 0.0.0.0:18624. ??

- - - Updated - - -

What to do with Fix Failes ?

- - - Updated - - -

SQL error.
There are clean?

- - - Updated - - -

What is a fully running server?

- - - Updated - - -

Can anyone make the fix files in my ip?
And what to do with files fix?

It's not hard to follow a tutorial. All what you have to do is written in the archieve and read me.txt.

These fix files allow you to use any IP and kinda fix the 1 hour crash bug.

[editorzone]

Delete

[NetTrodon]

Thanks @evestu and @YesOfCourse by the hex codes for date patching in MissionServer.

Here there is a shell script for patching MissionServer 1-hour crash bug directly on server

#!/bin/sh

SOURCE="${BASH_SOURCE[0]}"
while [ -h "$SOURCE" ]; do # resolve $SOURCE until the file is no longer a symlink
  DIR="$( cd -P "$( dirname "$SOURCE" )" && pwd )"
  SOURCE="$(readlink "$SOURCE")"
  [[ $SOURCE != /* ]] && SOURCE="$DIR/$SOURCE" # if $SOURCE was a relative symlink, we need to resolve it relative to the path where the symlink file was located
done
DIR="$( cd -P "$( dirname "$SOURCE" )" && pwd )"

NOW=$(date "+%m%d.%H%M")
BINFILE="$DIR/date_patch.bin.$NOW.tmp"
MISSIONFILE="$DIR/MissionServer"


# hex code e1 51 33 01 = 0x13351e1 = 20140513
#          31 4a 40 01 = 0x1404a31 = 20990513
printf '\x31\x4a\x40\x01' > "$BINFILE"


dd if="$BINFILE" of="$MISSIONFILE" bs=1 count=4 seek=2025213 conv=notrunc

rm -f "$BINFILE"

[Eperty123]

Bump!

I have added a FAQ section in my first post to avoid seeing the same questions being asked every time. Also @evestu, @YesOfCourse and @NetTrodon your helpful tuts were added in the FAQ. Thank you guys! :)

[editorzone]

Help Me !
I'm Not Login to server

[NetTrodon]

Help Me !
I'm Not Login to server

Check your connect.ini file, login server is pointing to 127.0.0.1, that is wrong in case you were following tutorial.

- - - Updated - - -
@Eperty123
These iptables rules allow to play without disabling/stopping CentOS firewall/iptables, just drop in "/etc/sysconfig/iptables". These lines must be before reject rules.

-A INPUT -m state --state NEW -m tcp -p tcp --dport 6543 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5567 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5568 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 10021 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 10022 -j ACCEPT

"/etc/sysconfig/iptables" file should look like next before saving

# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT

-A INPUT -m state --state NEW -m tcp -p tcp --dport 6543 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5567 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5568 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 10021 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 10022 -j ACCEPT

-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT

After saving "/etc/sysconfig/iptables" is necesary to reload rules with

[root@localhost ~]# service iptables reload