ItzLoganDuh

try to connect try to connect try to connect try to connect SSL socket accpeted onconnect onconnected Client Hello called GetDisconnectErrText: -31 try to connect Any idea what this means?

I set the Ip's to the default local host of 127.0.0.1 and everything works when I change to my public ip the gate server cant seem to connect. Any tips or ideas? It cant seem to listen to the game server? idk what that means just says gameserver cant listen

IDK what any of that has to do with it. I got my servers to connect to one another and now I cant get my client to connect are there any guides on that?

I had it set to my public ip but none of the servers would connect to one another so I changed it to local ip to try and they still dont talk to each other. I had it working was logged in and everything with everything at default settings so idk. I was following this tutorial.

I can get the gate server to work but the the group server wont work, but then when I get the group server to work the gate server wont connect. Currently GateServer 1.38 (by: Sheep Squad) client Constructor server Constructor Try to open LisenSocket [ Port: 1971 ip: 192.168.1.254] File:l:\top server\topsrcs\srvsrcs\gateserver\src\togameserver.cpp Line:22 desc:ToGameServer listen failed Gate server config [Main] Name = GateServer Version = 700 [GroupServer] IP = 192.168.1.254 Port = 1975 EnablePing = 180 [ToClient] IP = 0.0.0.0 Port = 1970 CommEncrypt = 1 EnablePing = 60 MaxConnection = 1000 WpeProtection = 1 WpeVersion = 0x8D9A DDoSProtection = 1 CheckSpan = 2 CheckWaring = 20 CheckError = 40 [ToGameServer] IP = 192.168.1.254 Port = 1971 EnablePing = 180 [ShowRange] ShowMin = 500 ShowMax = 800 IsUse = 1 [Chaos] Map = PKmap IsActive = 1 Group server config // The Pirate King online game server group GroupServer configuration file [Main] Name = GroupServerAndor1 Listen_Port = 1975 Listen_IP = 192.168.1.254 KeepAlive = 900 Version = 103 [AccountServer] AcctEnable = 1 Password = GroupServerAndor1 IP = 192.168.1.254 Port = 1978 [Database] IP = localhost\SQLEXPRESS DB = GameDB Login = pko_game Password = EZCpyYOZVocDE5Dc2KURBQ== // SQL Pass: Y87dc#$98 MaxVal = 4294967295 //2000000000 //maybe will make a difference [character] MaxCharacterNum = 3 MaxValue = 30 MaxPerson = 3000 [friend] MaxInvitedNum = 5 InvitedTime = 30 MaxFriendNum = 50 FriendGroupNum = 10 [team] MaxInvitedNum = 5 InvitedTime = 30 MaxPersonNum = 5 [chat] MaxChatNumPerPlayer = 30 maxPlayerPerChat = 50 WorldInterval = 60 TradeInterval = 300 ToYouInterval = 2 WorldFee = 1000 WorldFeeInterval = 1000 SpeakerInterval = 500 [birth] Argent City = garner Shaitan City = garner //CHANGE to magicsea later Icicle Castle = garner //CHANGE to darkblue later [account] equal = 0 Game server config [ID] name = GameServer00 equment = system [Gate] gate = 192.168.1.254, 1971 [Map] map = garner map = teampk map = lonetower map = abandonedcity map = abandonedcity2 map = abandonedcity3 //map = darkswamp map = pkmap map = ctf map = egtown //map = dyisland map = 07xmas2 map = jialebi map = bountypk [DB] db_name = GameDB db_ip = DESKTOP-7AF568B\SQLEXPRESS db_usr = pko_game db_pass = EZCpyYOZVocDE5Dc2KURBQ== // SQL pass: Y87dc#$98 [Socket] keep_alive = 120 [BaseID] BaseID = 0x50000000 [Entity] max_ply = 850 max_cha = 25000 // 15000 max_item = 30000 max_tnpc = 300 [Guild] guild_num = 30 // max in guild guild_try_num = 30 // allowed to register [Item] item_show_time = 60 item_prot_time = 15 [Interval] say_interval = 1 weather_interval = 900 // every 15 minutes instead of 2 [LOG] log_cha = 0 log_cal = 0 log_ai = 0 log_mission = 0 [Debug] supercmd = 1 gmcmd = 0,1,2,3,4,5,6 [Res] res_dir = ./resource log_dir = LOG\\GameServer00 [Large map switch] db_mapmask = 1 [Corsairs] stall_offline = 1 stall_empty_dc = 1 // disconnect on empty stall stall_interval = 120 igs_instant = 1 chaos_map = garner22 chaos_blind = 1 // blinds "chaos_map" in cfg persist_state = 48,49,147,83 I got it to load and loaded in with everything at defaults, but then when I changed the ip address to my public ip so my friends could join everything went downhill. Do I not just set all the ip addresses to my public ip? I forwarded the ports. Any help would be greatly appreciated

Teamviewer updated. Could you help me get sql 2014 working and running >.<

Yes. what do you need me to do?

Now it is just instantly popping up the same message. Main database handler create failed, AccountServer hang! Press any key to continue . . .

I'm fairly certain it's .\SQLEXPRESS. Or does that make it the \gotto_000 as the server?

I tried this and it didnt work. I am trying to make it a hamachi server for dev purposes. I really appreciate any and all assistance given.

Cfg //AccountServer Configuration [net] listen_port = 1656 listen_ip = 25.96.167.106 //(YOUR IP HERE) 监听IP地址，用于接受GroupServer的连入 [db] dbserver = 127.0.0.1 // IP Address Of Server Database db = AccountServer // Database Name userid = pko_game // SQL Security Login passwd = FBS+u/JjHzoC3edhg2rmvA== // Password = [bill] enable_bill = 0 enable_passport= 0 // 是否启用billing系统的passport enable_kickuser = 0 //bill_server1 = 127.0.0.1:7243 // //bill_server2 = 127.0.0.1:7243 // [tom] enable_tom = 0 // [gs] GroupServerAndor = GroupServerAndor // 注册的GroupServer账号（格式为：“账号名” = “密码”） GroupServerAndor1 = GroupServerAndor1 // 注册的GroupServer账号（格式为：“账号名” = “密码”） GroupServerAndor2 = GroupServerAndor2 // 注册的GroupServer账号（格式为：“账号名” = “密码”） GroupServerAndor5 = GroupServerAndor5 // 注册的GroupServer账号（格式为：“账号名” = “密码”） GroupServerAndor6 = GroupServerAndor6 // 注册的GroupServer账号（格式为：“账号名” = “密码”） enable_ping = 1 // 与GroupServer是否启用 "Keep Alive" The database server name is SLMOYER\SQLEXPRESS I made the userid in cfg the user to log into the sql and gave it owner permissions. I tried running as admin and it still reads out the same error. I will go try to google translate some of this stuff too then if it translates fine.

Hello my name is Logan and I have been playing ToP for years and so I finally decided to hop on the server dev side of the game. I had a server running at one point on my laptop but I seemed to have uninstalled my sql stuff so I recently installed sql 2012 and am using the clean sql12 database files from the megaupload archive. I am getting the error "Main database handler create failed, AccountServer hang!" and I am a total noob with most of these programs. I tried searching the error and there where only two other posts talking about it, and one was in Russian which I do not speak sadly. If anyone wouldnt mind giving me a point in the right direction I would greatly appreciate it!