Setting up your Aura Kingdom Server
Requirements
Server Files (Fix files included & english ready)
Windows 7/8/10
Navicat
Other Downloads
Please note: I will be using Virtual Box because it's free.
For VMWare users please try your best to follow along.
The Guide
1. Start up Virtual Box.
2. Click on 'New' and name your virtual machine whatever you
want. Set the 'Type' to 'Linux' and 'Version' to 'Other (x64)'. Configure the
memory size to your liking and once done click on 'Create'.
3. If you're an advanced user configure the options to your
liking otherwise leave everything as it is and click on 'Create' and then start
it. Although I recommend 2GB of ram.
4. When you start the virtual maachine for the first time it
will ask you for a host drive. Browse for your CentOS LiveCD minimal iso and
click 'Start'.
5. When it starts you'll see a screen asking you to press a
button for boot options. Press a button and get to this screen. Click on
'Install' and if everything is set properly you'll get to the screen on step 6
below.
6. It's now time to configure your OS. Please do that and
restart when prompted.
[CentOS] Setting up your Aura Kingdom Server
7. Configure the OS to your liking and restart if prompted.
8. Once landed on this boring black and white screen go type
Code:
ifconfig
to see if your eth0 is present - if not type
Code:
ifup eth0
to get an IP address.
9. Once you know the IP address go start SecureCRT and
connect to your server.
10. Now type the necessary commands to install PostGreSQL
and all needed assets:
Note: To paste in SecureCRT use Shift+ Insert. Also accept
all questions if asked.
To install PostGreSQL
1.
Code:
yum install
http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm2.
Code:
yum install postgresql93-server postgresql93-contrib
...now back to the steps
11. Open up WinSCP and connect to your server.
12. Navigate to etc/sysconfig and find i18n and open it.
13. Edit and replace
Code:
LANG="<your language>.UTF8"
with
Code:
LANG="<your language>.ISO88591"
, then restart your server. Type
Code:
reboot <time to wait>
to do so.
15. Go back to SecureCRT and type
Code:
service postgresql-9.3 initdb
and
Code:
service postgresql-9.3 start
afterwards.
16. Now navigate to var/lib/psql/9.3/data and find
pg_hba.conf and postgresql.conf and open them up.
In pga_hba.conf find and edit according to your needs:
Code:
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections
only
local all all peer
# IPv4 local connections:
host all all 0.0.0.0/0 md5
# IPv6 local connections:
host all all ::1/128 ident
Note: 0.0.0.0 means all IP's are accepted. To limit it set
it to your IP following with
Code:
/32
.
Now to postgresql.conf:
Remove the hash tag of
Code:
#listen_addresses
and edit it to:
Code:
listen_addresses='*'
like so:
Code:
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = '*'
# what IP address(es) to listen on;
...save them both and restart the PostGreSQL. Do so by
typing
Code:
service postgresql-9.3 restart
.
17. Now go back to SecureCRT and type
Code:
sudo
18. Back to Winscp, copy all the server files in a directory
in
Code:
/root
and make sure to give it a permission of 700. Right click on
the folder and write 700 in the octal textbox otherwise use the checkboxes to
do so.
19. Go back to SecureCRT and type
Code:
sudo -u postgres createuser --superuser <username>
to create a new PostGreSQL super user. It's not required as
you can use the default user "postgres". It's up to you.
20. Now type
Code:
su postgres
then
Code:
psql
when the 'bash' comes.
21. Create the necessary databases and give them a name of
your choice. To create a database type
Code:
create database <database name>;
. You must end a PostGreSQL command with a ';' otherwise
nothing will happen. To import a SQL first connect to the database by typing
\c <database>
then
\i '<path to file>';
.
It is strongly recommended to set a password for all the
users. Do so by typing
Code:
alter user <user> password '<password>';
23. Once done go to Navicat and open up the game- and login
server database.
In the game server database find the 'serverstatus' table
and edit the IP's to your server's. Do so as well with login server database's
'worlds' table.