[Release] Aura Kingdom Server Files

[Eperty123]

TriEdge I also think it has something to do with the ip as well since my lan is 10.0.0.X I search through the logs and db couldn't find anything yet.
Eperty123 yes, I did make a clean and new one on my vbox work fine.

What did you write to get the remote access working?

 

[NanayaQ]

What did you write to get the remote access working?

Just follow what Ness199X posted your pg_hba.conf (if your using CentOS) should be in var/lib/pgsql/9.X/data/pg_hba.conf

open up the pg_hba.conf and scroll all the way down and setup your remote access. For example:

 TYPE  DATABASE        USER            ADDRESS                 METHOD 
 [B]Host  all or dbname   all or user            Your LAN IP             trust or md5[/B]

Then just do a service postgresql-9.X restart on your terminal and you should be able to get remote access.

X = your version of postgresql

 

[Eperty123]

Just follow what Ness199X posted your pg_hba.conf (if your using CentOS) should be in var/lib/pgsql/9.X/data/pg_hba.conf

open up the pg_hba.conf and scroll all the way down and setup your remote access. For example:

 TYPE  DATABASE        USER            ADDRESS                 METHOD 
 [B]Host  all or dbname   all or user            Your LAN IP             trust or md5[/B]

Then just do a service postgresql-9.X restart on your terminal and you should be able to get remote access.

X = your version of postgresql

I still get connection refused by remote server in securecrt.

 

[TriEdge]

I just tested it. i changed my ip to 192.168.1.99 and everything working now. When i switch back to 192.168.0.136 then i cant connect to the channels.

 

[jojomihijo]

You must be registered to see links

I did not understand very well, but I think with the Centos, you can manage these files. Hence I'm downloading.

you need log out from baidu account, but keep baidu client open , after that you can free download everything

1. log out from baidu website
2. your baidu client ( BaiduYun) still login ( dont log out from baidu client)
3. click download, enjoy

 

[Evencelance]

I just tested it. i changed my ip to 192.168.1.99 and everything working now. When i switch back to 192.168.0.136 then i cant connect to the channels.

I don't understand , server files avaible to connect external ip or not ?
Or, connect is possible only with the VM?

 

[lcsound]

I need help for the config

 

[NanayaQ]

Well been doing some hexing and now I have a different warning message. I think I'm a bit close to getting it work or not.

 

[lcsound]

Guys... use bridge connection... work : )

 

[morbitangel]

Well been doing some hexing and now I have a different warning message. I think I'm a bit close to getting it work or not.

if you want to know what error msg the client is giving check error.log it might show it since it showed the 'cant connect to worldserver' error i had too

 

[Eperty123]

if you want to know what error msg the client is giving check error.log it might show it since it showed the 'cant connect to worldserver' error i had too

It's weird considering it uses the IPs provided in the databases.

 

[TerrorBlade]

I have tried to setup the server under a new installed centos. So i configured everything new, postgresql, database ips etc.
The Server is running now under another IP (192.168.1.31) not 192.168.1.99, and its working without errors. I can connect with Chinese Client and its playable.

 

[Eperty123]

I have tried to setup the server under a new installed centos. So i configured everything new, postgresql, database ips etc.
The Server is running now under another IP (192.168.1.31) not 192.168.1.99, and its working without errors. I can connect with Chinese Client and its playable.

Does the remote access feature work for you?

 

[TerrorBlade]

Does the remote access feature work for you?

If you mean that i can connect from host computer to the psql in vm, yes.

My pg_hba.conf:

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 0.0.0.0/0 md5
# 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

and my postgresql.conf:

listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
port = 5432 # (change requires restart)

 

[Eperty123]

If you mean that i can connect from host computer to the psql in vm, yes.

My pg_hba.conf:


and my postgresql.conf:

Thanks! My newly created CentOS shows "connection refused by remote system" whenever I try to ssh using SecureCRT. I'll try this out

 

[NanayaQ]

@morbitangel I can connect to world server, but I can't connect to Zone server that what its telling me in the error.log I think (since Czone probly means zone server). That was as far as I gotten last night.
client side error.log

Spoiler

2015/08/28 22:15:52 [Desc]Node[11001] LoadEvent<¸ê®Æ­«½Æ>!! ID=901 
2015/08/28 22:15:53 [Desc]Node[404] LoadEvent<¸ê®Æ­«½Æ>!! ID=632 
2015/08/28 22:15:53 [Desc]Node[404] LoadEvent<¸ê®Æ­«½Æ>!! ID=1632 
2015/08/28 22:15:53 [Desc]Node[6] LoadPatrol<¸ê®Æ­«½Æ>!! ID=181 
2015/08/28 22:15:54 [Desc]Option Apply 
2015/08/28 22:15:55 [Desc]Init 3D System Success. 
2015/08/28 22:15:56 [Desc]Load Scene begin... 
2015/08/28 22:15:56 [Desc]Load CZone: S099 
2015/08/28 22:15:56 [Desc]Memory Percent : 49 
2015/08/28 22:15:56 [Desc]Memory Total : 16352.000 MB 
2015/08/28 22:15:56 [Desc]Memory Available : 8458.860 MB 
2015/08/28 22:15:56 [Desc]Virtual Memory Available : 3726.484 MB 
2015/08/28 22:15:56 [Desc]Process PeakWorkingSetSize : 259.512 MB 
2015/08/28 22:15:56 [Desc]Process PagefileUsage : 311.836 MB 
2015/08/28 22:15:56 [Desc]Allocated/Active/Mapped: 189.886 MB/206.144 MB/217.088 MB 
2015/08/28 22:15:56 [Desc]Load FSM Begin... 
2015/08/28 22:15:56 [Desc]Load FSM LayerBlock Allocated Size: 36920396 bytes 
2015/08/28 22:15:57 [Desc]Load FSM GrassList... 
2015/08/28 22:15:58 [Desc]Load FSM Object... 
2015/08/28 22:15:58 [Desc]Load FSM End... 
2015/08/28 22:15:58 [Desc]Load Terrain Object Begin... 
2015/08/28 22:15:58 [Desc]Scene Object Total: 5289 
2015/08/28 22:15:58 [Desc]BuildQuadTreeRoot End... Time=[0.003531] 
2015/08/28 22:15:58 [Desc]Map[S099] Cannot found object [R0013] 
2015/08/28 22:15:59 [Desc]Map[S099] Cannot found object [(null)] 
2015/08/28 22:15:59 [Desc]Load Terrain Object End... Time=[0.959214] 
2015/08/28 22:15:59 [Desc]Load Scene end... 
2015/08/28 22:15:59 [Desc]Load SMP begin... 
2015/08/28 22:15:59 [Desc]Load SMP end... 
2015/08/28 22:15:59 [Desc]Load PGP begin... 
2015/08/28 22:15:59 [Desc]Load PGP end... 
2015/08/28 22:16:00 [Desc][LOGIN] 
2015/08/28 22:16:14 [Desc][SELECT WORLD SERVER] 
2015/08/28 22:16:24 [Desc]Free CZone begin... 
2015/08/28 22:16:24 [Desc]Free CZone end... 
2015/08/28 22:16:24 [Desc]DESTORY APP

edit: I going to check the Zone server file see if it have some IP so far I know gatewayserver, login server, and worldserver have it atm. Also I think some server are running under 192.168.1.X maybe...

Edit2: Also an odd thing happen when I was changing the IP on loginserver file it made Ch1 and Ch2 have those blue dot meaning its online after clicking them it loads then show that message in the picture I posted. Not the common autoclose way.

 

[TerrorBlade]

Found GM Commands.
Set privilege for your Char in the database FFDB1, table "player_characters" to 5.
I have also added to the table "gm_tool_accounts" in the FFAccount database the account i created before privilege set to 5.

V.1,4,
0,change_weather <number>,0,,
1,take_expbonus,0,,
2,clone_monster <number> <number> <number>,0,,
3,restore,0,,
4,set_rb <number> <number> <number>,0,,
5,ls_rb,0,,
6,rm_rb <number>,0,,
7,status,0,,
8,clone_item <number>,0,,
9,clone_reward_item <number> <number>,0,,
10,clone_items <number> <number>,0,,
11,clone_item_to <number> <number>,0,,
12,clone_quest_item <number> <number> <number> <number>,0,,
13,say <rest_input>,0,,
14,whisper <word> <rest_input>,0,,
15,kill <number>,0,,
17,gain_exp <number>,0,,
18,gain_gold <number> ,0,,
19,goto <number> <number>,0,,
20,users,0,,
21,allusers,0,,
22,transfer <number>,0,,
23,listarea,0,,
24,weak <number>,0,,
25,setra <number> <number>,0,,
26,transport_area <number> <number>,0,,
27,transport_node <number>,0,,
28,drop_item <number> <number>,0,,
29,drop_quest_item <number> <number> <number>,0,,
30,list_durability <number>,0,,
31,date,0,,
32,shop <word> <number> <number>,0,,
33,shop <word> <number>,0,,
34,create_family,0,,
35,effect_life <number> <number> <number> <number> <number>,0,,
36,effect_loc <number> <number> <number> <number> <number>,0,,
37,repairshop,0,,
38,invincible <number>,0,,
39,vanish <number>,0,,
40,town,0,,
41,transport_to_character <word>,0,,
42,get_user_info <word>,0,,
43,get_shortcuts,0,,
44,update_shortcut <number> <number> <number>,0,,
45,save_shortcut,0,,
46,display_sum_node_users <number>,0,,
47,display_sum_world_users <number>,0,,
48,get_spellmaster <number>,0,,
49,debug <number>,0,,
50,list_state,0,,
51,shut_down <number>,0,,
52,kick <word>,0,,
53,slayer <number>,0,,
54,announce <rest_input>,0,,
55,storage <number> <number>,0,,
56,querychar <word>,0,,
57,look <number>,0,,
58,listenchant <word>,0,,
59,version,0,,
60,transport_and_deduct <number> <number>,0,,
61,clone_quest_item_silently <number> <number> <number>,0,,
62,query_npc <number>,0,,
63,party <rest_input>,0,,
64,guild <rest_input>,0,,
65,trade <rest_input>,0,,
66,chat <rest_input>,0,,
67,system <rest_input>,0,,
68,channel_limit <number> <number>,0,,
69,flush_dba_data,0,,
70,banchar <number> <number>,0,,
71,identify_shop,0,,
72,disband_family,0,,
73,select_family_leader <word>,0,,
74,listfms <number>,0,,
75,run <number>,0,,
76,exchange item service,0,,
77,drop_items <number> <number>,0,,
78,allworld_cmd <rest_input> ,0,,
79,query_npc_involve <number>,0,,
80,channel_limit_name <word> <number>,0,,
81,banchar_name <word> <number>,0,,
82,quest <rest_input>,0,,
83,reset_attribute,0,,
84,reset_skill,0,,
85,reset_attribute_gold <number>,0,,
86,reset_skill_gold <number>,0,,
87,get_spell <number>,0,,
88,inlay_shop <number>,0,,
89,broadcast_system_message <number> <number> <number> <rest_input>,0,,
90,echo <rest_input>,0,,
91,clone_monster_locate <number> <number> <number> <number>,0,,
92,clone_monster_around <number> <number> <number> <number>,0,,
93,npc_use_channel <number> <number> <number> <rest_input>,0,,
94,npc_use_spell <number> <number>,0,,
95,self_use_effect <number> <number>,0,,
97,change_class <number>,0,,
98,adjust_spell_anitime <number> <number>,0,,
99,escape,0,,
100,set_level <number>,0,,
101,set_monster_damage <number> <number> <number> <number> <number> <number> <number>,0,,
102,set_monster_movement <number> <number> <number> <number>,0,,
103,show_monster <number>,0,,
104,set_monster_sight <number> <number>,0,,
105,test_character_attack <number> <number>,0,,
106,test_monster_attack <number> <number>,0,,
107,set_level_grow <number> <number> <number> <number> <number> <number> <number> <number> <number>,0,,
108,query_level_grow,0,,
109,query_equipment,0,,
110,set_item <number> <word> <number>,0,,
111,save_monster <number>,0,,
112,get_effect_data <number>,0,,
113,set_effect_data <number> <word> <word> <number> <number> <number> <number> <word> <word> <number> <number> <number> <number>,0,,
114,set_effect_command <number> <word> <rest_input>,0,,
115,get_spell_data <number>,0,,
116,set_reborn_monster <number> <word> <word> <number> <number> <number> <word> <word> <number> <number> <number>,0,,
117,get_all_template_monsters,0,,
118,save_item <number>,0,,
119,monster_goto <number> <number> <number>,0,,
120,around_kill_all <number>,0,,
121,around_kill <number> <number>,0,,
122,query_test_attack_monster,0,,
124,listpms <number>,0,,
125,echobyid <number>,0,,
126,change_hair_color <number>,0,,
127,change_hair <number>,0,,
128,reload_effect,0,,
129,reload_template_monster,0,,
130,summon_pet <number>,0,,
131,gain_skill_point <number>,0,,
132,node <rest_input>,0,,
133,system_area <word> <rest_input>,0,,
134,fatality_damage <number>,0,,
135,restore_all,0,,
136,clear_near_items,0,,
137,get_server_id,0,,
138,test_durability <number> <number> <number>,0,,
139,test_spell_attack <number> <number> <number>,0,,
140,test_drop_treasure <number> <number>,0,,
141,test_pk <number> <number>,0,,
142,surprise_box <number>,0,,
143,setextbornmonster <number> <number>,0,,
144,set_family_level <number>,0,,
145,family_level_up,0,,
146,set_family_emblem <number> <number>,0,,
147,select_family_emblem,0,,
148,open_exploit_rank,0,,
151,setstallspace <number> ,0,,
152,setstallsignboard <number> ,0,,
153,give_exploit <number>,0,,
154,repairallequipment,0,,
155,ping,0,,
156,trace <number> <word>,0,,
157,drill_item <number> <number>,0,,
158,fubag <number>,0,,
159,aw_put_treasure <number> <number>,0,,
161,setfms <number> <number> <number>,0,,
162,clone_quest_treasure <number> <number> <number> <number> <number> <number>,0,,
163,set_bag_time <number> <number>,0,,
164,gain_crystal <number>,0,,
165,gain_family_exp <number>,0,,
166,set_prestige_level <number> <number>,0,,
167,gain_prestige_exp <number> <number>,0,,
168,cast_spell <number> <number>,0,,
169,set_sys_var <word> <number>,0,,
170,add_appellation <number>,0,,
171,set_present_appellation <number>,0,,
172,add_elf <number>,0,,
173,elf_work <number> <number> <number> <number> <number>,0,,
174,remove_elf <number>,0,,
175,elf_skill <number> <number> <number>,0,,
176,set_elf_level <number> <number>,0,,
177,set_elf_mood <number> <number>,0,,
178,use_item_to <word> <number> <number> <number> <rest_input>,0,,
179,set_spell_card <number> <number>,0,,
180,gain_elf_exp <number> <number>,0,,
181,gain_elf_familiar <number> <number>,0,,
182,show_debug_message <number>,0,,
183,set_log_level <word> <number>,0,,
184,set_assert <word> <number>,0,,
185,set_spell_card_attr <number> <number> <number> <number>,0,,
186,set_elf_action <number> <number>,0,,
187,inside <number>,0,,
188,auction_sell <number> <number>,0,,
189,friend_together,0,,
190,reload_itemmall_db,0,,
191,set_node_exp <number> <number>,0,,
192,set_node_gold <number> <number>,0,,
193,set_node_drop <number> <number>,0,,
194,show_hate <number>,0,,
195,clone_item <number> <number>,0,,
196,clone_item <number> <number> <number>,0,,
197,return_item <number> <word>,0,,
198,call_elf <number>,0,,
199,return_gold <number> <number>,0,,
200,battlefield <number>,0,,
201,gain_aa_point <number>,0,,
202,gain_aa_exp <number>,0,,
203,set_aa_rate <number>,0,,
204,reset_aa,0,,
206,around_kill_all_player <number>,0,,
205,clone_npc <number>,0,,
207,captcha_id <number> <number>,0,,
208,captcha_name <word> <number>,0,,
209,change_grow_type <number>,0,,
211,clear_bag_item,0,,
213,set_statue <number> <number> <number> <number>,0,,
214,bf_ch_num <number> <number> <number>,0,,
215,bf_open <number> <number>,0,,
216,gain_love_coin <number>,0,,
217,reset_st,0,,
218,gain_st_point <number>,0,,
219,gain_farm_interaction_point <number> <number>,0,,
220,visit_family_instance <word>,0,,
221,gain_building_exp <number> <number>,0,,
222,remove_enchant <number> <number>,0,,
223,gain_family_treasury <number>,0,,
224,gain_building_durability <number> <number>,0,,
225,achievement_item <number>,0,,
226,create_town <number>,0,,
227,set_territory_open <number> <number>,0,,
228,clone_item <number> <number> <number> <number>,0,,
229,screenmsg <number> <rest_input>,0,,
230,set_blocklogin <number> <number>,0,,
231,set_useblocklogin <number>,0,,
232,visit_player_room_id <number>,0,,
233,visit_player_room <word>,0,,
234,gain_family_leader_point <number>,0,,
235,gain_family_cp <number>,0,,
236,set_territory_status <number> <number>,0,,
237,caplv <number>,0,,
244,set_gm_map_open <number> <number>,0,,
245,send_reward_item <number> <number> <number> <number> <number>,0,,
269,tpnpc <number>,0,,
273,change_gender <number>,0,,
294,gain_coins <number> <number>,0,,
295,npc_talk <number>,0,,
296,blackout <number> <number>,0,,
299,gain_eudemon_level <number>,0,,
300,effect_map <number> <number>,0,,
302,gem_powerup <number> <number> <number>,0,,
800,set_hair_id <number>,0,,
801,set_face_id <number>,0,,
802,set_hair_color <number>,0,,
803,set_skin_color <number>,0,,
804,set_eyes_color <number>,0,,
805,set_helmet_color <number>,0,,
806,set_clothes_color <number>,0,,
807,set_cloak_color <number>,0,,
808,update_closet <number>,0,,
809,set_spell_level <number> <number>,0,,
810,add_class <number>,0,,
811,remove_class <number>,0,,
812,set_class_level <number>,0,,
813,get_license <number>,0,,
814,remove_all_license,0,,
815,set_all_spell_level <number>,0,,
816,set_node_np <number> <number>,0,,
817,remove_family_emblem <number>,0,,
901,get_farm,0,,
902,set_farm_level <number>,0,,
905,get_farm_event <number>,0,,
906,clear_cool_down_time,0,,
907,set_farm_visitable <number>,0,,
908,gain_soul_ability <number> <number>,0,,
909,shop <word> <number> <number> <number>,0,,
910,enter_my_farm,0,,
911,put_treasure <number> <number>,0,,
912,add_lottery_plus <number>,0,,
913,reload_elf_lottery_db,0,,
914,set_farm_interact_time <number>,0,,
915,farm_interact_open <number>,0,,
916,clear_lover_disband,0,,
917,super_clear_bag_item,0,,
918,making_item <word> <number>,0,,
919,making_item <word> <number> <number>,0,,
920,add_hate <number> <number> <number>,0,,
921,achievement_screen_message <number> <number>,0,,
922,set_transfiguration <number>,0,,
923,gain_sp <number>,0,,
924,get_lover_point <number>,0,,
925,set_lover_level <number>,0,,
926,expand_elf_bank,0,,
927,add_attr_value <word> <number>,0,,
928,reset_daily_mission,0,,
929,transfer_name <word>,0,,
952,change_weapon_type <number> <number>,0,,
953,weapon_strengthen <number> <number> <number> <number>,0,,
954,gain_fragment <number>,0,,
955,clear_advenchants,0,,

Testet gain_exp, gain_gold and users and they working!
To use the commands type in Chat ingame with "/" before without quotes.

 

[slander]

someone managed to restore the database
I'm trying to install the server on ubuntu

 

[lcsound]

Any help?
The IP configuration is correct :hmpf:

Spoiler

2015/08/29 15:49:55 [Desc]Load CZone: S099 
2015/08/29 15:49:55 [Desc]Memory Percent : 70 
2015/08/29 15:49:55 [Desc]Memory Total : 6137.000 MB 
2015/08/29 15:49:55 [Desc]Memory Available : 1829.676 MB 
2015/08/29 15:49:56 [Desc]Virtual Memory Available : 3772.804 MB 
2015/08/29 15:49:56 [Desc]Process PeakWorkingSetSize : 225.452 MB 
2015/08/29 15:49:56 [Desc]Process PagefileUsage : 260.008 MB 
2015/08/29 15:49:56 [Desc]Allocated/Active/Mapped: 189.897 MB/206.144 MB/217.088 MB 
2015/08/29 15:49:56 [Desc]Load FSM Begin... 
2015/08/29 15:49:56 [Desc]Load FSM LayerBlock Allocated Size: 36920396 bytes 
2015/08/29 15:49:58 [Desc]Load FSM GrassList... 
2015/08/29 15:49:58 [Desc]Load FSM Object... 
2015/08/29 15:49:59 [Desc]Load FSM End... 
2015/08/29 15:49:59 [Desc]Load Terrain Object Begin... 
2015/08/29 15:49:59 [Desc]Scene Object Total: 5289 
2015/08/29 15:49:59 [Desc]BuildQuadTreeRoot End... Time=[0.005043] 
2015/08/29 15:49:59 [Desc]Map[S099] Cannot found object [R0013] 
2015/08/29 15:50:01 [Desc]Map[S099] Cannot found object [(null)] 
2015/08/29 15:50:01 [Desc]Load Terrain Object End... Time=[1.870501] 
2015/08/29 15:50:01 [Desc]Load Scene end... 
2015/08/29 15:50:01 [Desc]Load SMP begin... 
2015/08/29 15:50:02 [Desc]Load SMP end... 
2015/08/29 15:50:02 [Desc]Load PGP begin... 
2015/08/29 15:50:02 [Desc]Load PGP end... 
2015/08/29 15:50:03 [Desc][LOGIN] 
2015/08/29 15:50:09 [Desc][SELECT WORLD SERVER] 
2015/08/29 15:50:12 [Desc]Cannot Connect to WorldSever
 
2015/08/29 15:50:16 [Desc]Cannot Connect to WorldSever
 
2015/08/29 15:50:20 [Desc]Cannot Connect to WorldSever
 
2015/08/29 15:50:29 [Desc]Cannot Connect to WorldSever
 
2015/08/29 15:50:44 [Desc]Free CZone begin... 
2015/08/29 15:50:44 [Desc]Free CZone end... 
2015/08/29 15:50:45 [Desc]DESTORY APP

 

[lastfun]

see serverside log