- Joined
- Dec 21, 2013
- Messages
- 392
- Reaction score
- 181
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!What did you write to get the remote access working?
TYPE DATABASE USER ADDRESS METHOD
[B]Host all or dbname all or user Your LAN IP trust or md5[/B]
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:
Then just do a service postgresql-9.X restart on your terminal and you should be able to get remote access.Code:TYPE DATABASE USER ADDRESS METHOD [B]Host all or dbname all or user Your LAN IP trust or md5[/B]
X = your version of postgresql
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.
I don't understand , server files avaible to connect external ip or not ?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.
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
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?
# 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
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)
If you mean that i can connect from host computer to the psql in vm, yes.
My pg_hba.conf:
and my postgresql.conf:
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
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,,
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