[CentOS] Setting up your Aura Kingdom Server

[ihaki]

I'm not good at all with Linux, but i'm wondering if this is working on Ubuntu 12.04

[Hycker]

Its works fine

Tapatalkkal küldve az én LG-D802 eszközömről

[SATANset]

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

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

I have no data.sql in the server folder, please help

[ruksoda4ever]

I found the "System Error" in login screen. And check GatewayServer.log files i see the Error code here

312,2006/03/24 23:29:41,EVAL(1.000122 secs): {Network I/O}
313,2006/03/24 23:29:41,EVAL(1.000178 secs): {Main Loop}
314,2006/03/24 23:29:42,[NE_G_ServerAccountLogin.cc:15],CNE_G_ServerAccountLogin TEST 0x977ab20
315,2006/03/24 23:29:42,[DATABASE][ERROR] EXEC: {SELECT account_login('TEST','098f6bcd4621d373cade4e832627b4f6','27.145.194.152');}
-RETURNS: ERROR: function account_login(unknown, unknown, unknown) does not exist
LINE 1: SELECT account_login('TEST','098f6bcd4621d373cade4e832627b4f...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
316,2006/03/24 23:29:42,[PGAccountDBO.cc:77],[FATAL] Load AccountLogin failed. ERROR: function account_login(unknown, unknown, unknown) does not exist
LINE 1: SELECT account_login('TEST','098f6bcd4621d373cade4e832627b4f...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
317,2006/03/24 23:29:43,EVAL(1.000120 secs): {Network I/O}
318,2006/03/24 23:29:43,EVAL(1.000162 secs): {Main Loop}
319,2006/03/24 23:29:44,EVAL(1.000677 secs): {Network I/O}
320,2006/03/24 23:29:44,EVAL(1.000736 secs): {Main Loop}
321,2006/03/24 23:29:45,EVAL(1.000114 secs): {Network I/O}
322,2006/03/24 23:29:45,EVAL(1.000176 secs): {Main Loop}

Should i change this owner to postgres? or How i should do?
Thank you.

- - - Updated - - -

I have no data.sql in the server folder, please help

You'll be use this command. But you should go into database first.

example
<databasename> = FFAccount

\c <databasename>;
then you coming in FFAccount already. You can run that command.
\i /home/folder1/FFAccount.sql;
It will be restored into your databasename (FFAccount)
hope you understand.
sorry my bad english.

[SATANset]

I found the "System Error" in login screen. And check GatewayServer.log files i see the Error code here




Should i change this owner to postgres? or How i should do?
Thank you.

- - - Updated - - -



You'll be use this command. But you should go into database first.

example
<databasename> = FFAccount

\c <databasename>;
then you coming in FFAccount already. You can run that command.
\i /home/folder1/FFAccount.sql;
It will be restored into your databasename (FFAccount)
hope you understand.
sorry my bad english.

I love you:)

[ihaki]

I found the "System Error" in login screen. And check GatewayServer.log files i see the Error code here




Should i change this owner to postgres? or How i should do?
Thank you.

- - - Updated - - -



You'll be use this command. But you should go into database first.

example
<databasename> = FFAccount

\c <databasename>;
then you coming in FFAccount already. You can run that command.
\i /home/folder1/FFAccount.sql;
It will be restored into your databasename (FFAccount)
hope you understand.
sorry my bad english.

Did you change every username and password in the sql files ?


Btw, i can't use the \i command, saying i have no permission to do it, with postgres user.
I have given permission to all the files (the 700 rights thing)

List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
haki | Superuser, Create role, Create DB | {}
postgres | Superuser, Create role, Create DB, Replication | {}

[ForestG]

How to edit the game title? or the window name?

[WireShark]

I have no data.sql in the server folder, please help

Its just an example on my setup you can take a look on your Server files you have to restore the files from SQL folder these are the following:
1. FFAccount.sql,
2. FFDB1.sql,
3. FFMember.sql,
4. Itemmall.sql,
5. Itemmall_combine_only.sql

kindly check the new repack that Eperty uploaded.

Goodluck

[SATANset]

Its just an example on my setup you can take a look on your Server files you have to restore the files from SQL folder these are the following:
1. FFAccount.sql,
2. FFDB1.sql,
3. FFMember.sql,
4. Itemmall.sql,
5. Itemmall_combine_only.sql

kindly check the new repack that Eperty uploaded.

Goodluck

I have found in FFAccount.sql string -> ( dblink_string := 'host=test user=Eperty123 password=cN2WpGInYCFXp dbname=FFAccount'; )
what to write in the line the host, user and password? (password looks like encrypted):)

ihaki use Ctrl+H in Notapad++, WinSCP on Windows or in Notepad on centOS ;)

[Hycker]

Jesus....

Tapatalkkal küldve az én LG-D802 eszközömről

[SATANset]

Jesus....

Tapatalkkal küldve az én LG-D802 eszközömről

what happened?:)

[ihaki]

I have found in FFAccount.sql string -> ( dblink_string := 'host=test user=Eperty123 password=cN2WpGInYCFXp dbname=FFAccount'; )
what to write in the line the host, user and password? (password looks like encrypted):)

ihaki use Ctrl+H in Notapad++, WinSCP on Windows or in Notepad on centOS ;)

You have to write your username and password, the postgres one

I didn't understand what you said about Ctrl+H in notepad++. I could do that if i know what to search and in which file

[SATANset]

You have to write your username and password, the postgres one

I didn't understand what you said about Ctrl+H in notepad++. I could do that if i know what to search and in which file

I read it "Did you change every username and password in the sql files ?" and thought that you are trying to change each name manually, I thought that you are doing it manually, and you find it difficult:)

"You have to write your username and password, the postgres one" Eperty123 has a strong password)
Thanks you

- - - Updated - - -

Guys help, "su: user test1 does not exist"

[Hycker]

postgre user != linux user.
srsly... im 100% sure im getting BLAME again but why you try to set up a game under linux without ZERO / NULL linux knowledge and/or without reading?
in hungary we learned reading "skill" at first class of school when we was seven years old....

and yea im sure with be better if i write something usefull but what? READ READ READ.... EP's tutorial is kinda simple. if someone cannot follow it and cannot understand those basic things.... ah nevermind

[ihaki]

I'm trying to learn here @Hycker :)
I've been reading it over and over, searching on the internet for some solutions. Found some, but i'm still not an expert. I'll be happy to be able to set up this server. You need challenges in your life don't we ? That's why i'm trying this.

I'm also here to help people if i can. We are stronger united right ? Even tho i'm not good at linux, i can help other people with something i experienced already.



I've got my thing working, the permission thing by granting rights with chown

sudo chown postgres /home/haki/

This granted all access to the folder /home/haki/ for the user postgres

I'm using a VPS with CentOS 6.5