[CentOS] Setting up your Aura Kingdom Server

Why I can't login" I have inserted into account table username 'admin' pwd 'admin'
http://i.imgur.com/5lN1ptN.jpghttp://i.imgur.com/CM0Ldka.jpg


Does the password should be by encrypted by AK tool?:*::*:http://i.imgur.com/KHcVRdA.jpg

Quote:

---

Originally Posted by Pinzy Hay

Why I can't login" I have inserted into account table username 'admin' pwd 'admin'
http://i.imgur.com/5lN1ptN.jpghttp://i.imgur.com/CM0Ldka.jpg


Does the password should be by encrypted by AK tool?:*::*:http://i.imgur.com/KHcVRdA.jpg

---

You should try to put the md5 password instead of the uncrypted one in the table

Quote:

---

Originally Posted by ihaki

You should try to put the md5 password instead of the uncrypted one in the table

---

Yeah, I just put md5 pw into tb_user . Now I can login

- - - Updated - - -

Quote:

---

Originally Posted by 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




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

I'm using a VPS with CentOS 6.5

---

I also use a vps

Somebody tell me, it is a bug? (I can not find a specific answer on the Internet), reinstall Postgresql did not help. If I need to reinstall the CentOS I'll do it. Problem: su: user test1 does not exist.http://i.imgur.com/TOzABrY.jpg?1

Postgre user != linux user

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

Quote:

---

Originally Posted by Hycker

Postgre user != linux user

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

---

Thanks you:) you know what this is? "psql:/home/Server/SQL/FFMember.sql:1230: ERROR: function "get_point_info" already exists with same argument types" ( This END;$_$; on line 1230 ) ( ALTER FUNCTION public.get_point_info(character varying) OWNER TO test1;
on line 1233 ) 1 error in all db

Error says itself. Already exist

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

Quote:

---

Originally Posted by Hycker

Error says itself. Already exist

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

---

I understand that, but what can I do to fix this? (How do you fix this?)

Is there a way to find the status of the player? like if the player is current online.

Quote:

---

Originally Posted by SATANset

I understand that, but what can I do to fix this? (How do you fix this?)

---

drop all database then recreate / reimport sql files. be sure owner is postgre in sql files

Quote:

---

Originally Posted by Hycker

drop all database then recreate / reimport sql files. be sure owner is postgre in sql files

---

and if I have changed the database owner for test1? (test1 is a user postgres) Just Eperty123 uses alternate user, so I also want to:)

If you change to whatever username as owner you should have that user in postgre aswell

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

hello, how come I can't run the modified files with Hex. it says

./LoginServer: cannot execute binary file: Exec format error

./WorldServer: cannot execute binary file: Exec format error

./ZoneServer: cannot execute binary file: Exec format error

- - - Updated - - -

I am running these files on debian and modified the files in Windows Server with the included Hex Editor.

Quote:

---

Originally Posted by alfieo

hello, how come I can't run the modified files with Hex. it says

./LoginServer: cannot execute binary file: Exec format error

./WorldServer: cannot execute binary file: Exec format error

./ZoneServer: cannot execute binary file: Exec format error

- - - Updated - - -

I am running these files on debian and modified the files in Windows Server with the included Hex Editor.

---

in what linux and processor?

also use command:

Code:

---

file loginserver

---

and post result here

Quote:

---

Originally Posted by Hycker

If you change to whatever username as owner you should have that user in postgre aswell

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

---

I reinstalled Postgres and again created a database and a user test1(All 3 databases granted) (I don't understand why) I tried using the Postgres user (same error)
http://i.imgur.com/CNAHv7m.jpg?1
http://i.imgur.com/L2NwCIu.jpg?1