Susux 0 Report post Posted October 16, 2016 Hello, Does anyone know why error came up when attach a database.. I try search in google this problem..they are said maybe should "run as adminitrator" but i already try still same error show up.. The databases pko i'm using from Yudha Quote Share this post Link to post Share on other sites
Shako 97 Report post Posted October 16, 2016 @Susux try to post the error message Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 15 minutes ago, Shako said: @Susux try to post the error message here.. Quote Share this post Link to post Share on other sites
Shako 97 Report post Posted October 16, 2016 @Susux click the hyperlink in the message column for details Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 7 minutes ago, Shako said: @Susux click the hyperlink in the message column for details HERE Quote Share this post Link to post Share on other sites
Totoka 152 Report post Posted October 16, 2016 (edited) Try to change both file locations, seems like you are attaching over an old database which use same name or storage file. look at "D:\Top Develpme..." [button] probably same for your log file edit-- if that does not work, try to find your old database files, and delete them, or move these to another folder Edited October 16, 2016 by Totoka 1 Quote Discord: andresc Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 (edited) 37 minutes ago, Totoka said: Try to change both file locations, seems like you are attaching over an old database which use same name or storage file. look at "D:\Top Develpme..." [button] probably same for your log file edit-- if that does not work, try to find your old database files, and delete them, or move these to another folder Thanks now work perfect.. Edited October 16, 2016 by Susux Quote Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 (edited) what the problem with this..i'm so sorry new with SQL 2008 AccountServer work fine! //AccountServer Configuration [net] listen_port = 1656 listen_ip = 127.0.0.1 //(YOUR IP HERE) ¼àÌýIPµØÖ·£¬ÓÃÓÚ½ÓÊÜGroupServerµÄÁ¬Èë [db] dbserver = (local) // IP Address Of Server Database db = AccountServer // Database Name userid = // SQL Security Login passwd = // 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" GateServer work fine! //GateServer Configuration [Main] Name = GroupServerAndor1 // ±¾GateServerµÇ¼µ½GroupServerÉϵÄΨһÃû×Ö Version =136 // ±¾GateServerÑéÖ¤¿Í»§¶ËµÄ°æ±¾ºÅ£¬Èç1.01°æ£½£½101 [GroupServer] IP = 127.0.0.1 // IP Address Of GroupServer Port = 1975 // Á¬½ÓµÄGroupServerÕìÌýGateServerÁ¬½ÓµÄÕìÌýTCP¶Ë¿Ú EnablePing = 1800 // GateServerµ½GroupServerµÄSocketÁ¬½ÓµÄKeepAliveÖµ [ToClient] IP = 127.0.0.1 // GateServer›ü?ÍV?ÚÐÕcÉËó°ÚÃÇ»›ü?IP»ª³u Port = 1973 // GateServerÕìÌýÓÎÏ·¿Í»§¶ËÁ¬½ÓµÄÕìÌýTCP¶Ë¿Ú CommEncrypt = 1 // µ½¿Í»§¶ËµÄSocketÁ¬½ÓÊÇ·ñ´ò¿ª¼ÓÃÜͨÐÅ EnablePing = 60 // GateServerµ½ÓÎÏ·¿Í»§¶ËµÄSocketÁ¬½ÓµÄKeepAliveÖµ MaxConection =1000 // The largest initial connection [ToGameServer] IP = 127.0.0.1 // IP Address Of GameServer Port = 1971 // GateServerÕìÌýGameServerÁ¬½ÓµÄÕìÌýTCP¶Ë¿Ú EnablePing = 180 // GateServerµ½GameServerµÄSocketÁ¬½ÓµÄKeepAliveÖµ [ShowRange] ShowMin = 500 // СÓÚµÈÓÚShowMinʱÏÔʾÕý³£ ShowMax = 800 // ´óÓÚShowMin²¢ÇÒСÓÚµÈÓÚShowMaxÏÔʾ·±Ã¦£¬´óÓÚShowMaxÏÔʾÂú IsUse=0 // ÊÇ·ñÆôÓøººÉ״̬ÏÔʾ¹¦ÄÜ£¬1ʹÓã¬0²»Ê¹Óà GroupServer doesn't work.. //GroupServer Configuration [Main] Name =GroupServerAndor1 // ±¾GroupServerµÇ¼AccountServerµÄΨһÃû³Æ Listen_Port =1975 // The TCP Port Gateserver will connect to GroupServer Listen_IP =127.0.0.1 // The IP GateServer will connect to GroupServer KeepAlive =1800 // Èç¹ûSocketºÜ¾ÃûÓÐÊý¾Ý´«Ê䣬GroupServerÈÏΪSocket´¦Óڻ״̬µÄʱ¼ä£¬³¬¹ý´Ëʱ¼äûÓÐÊý¾Ý¼´ÈÏΪSocketÒÑËÀ Version =103 // ¿ØÖÆÁ¬½ÓGateServer°æ±¾µÄ°æ±¾ºÅ£¬Ö»Óа汾ºÅÊôÓÚ´ËÊý×ÖµÄGateServer.exe²ÅÄÜÁ¬½Ó±¾GroupServer [AccountServer] AcctEnable =1 // 0: close the connection // 1: Open the connection Password =GroupServerAndor1 // AccountServer Password IP =127.0.0.1 // The IP GroupServer will connect to AccountServer Port =1656 // The TCP Port GroupServer will connect to AccountServer [Database] IP =127.0.0.1 // IP Address Of Server Database DB =GameDB // Database Name Login = // SQL Security Login Password = // SQL Password = MaxVal =2000000000 // Ò»¸öÊôÐÔ³£Á¿£¬ÊôÐÔ´óÓڴ˲»¿ÉÄÜÖµ»á±»×èÖ¹½øÈëÓÎÏ·µØͼ£¬ÉèΪ´Ë¹Ì¶¨Öµ [½ÇÉ«] // Character System MaxCharactPerAcc =3 // Max Number of Characters that can be created per account ChaImgLogoMaxValue =30 // ¸öÐÔ»¯Í¼±êµÄ×î´óÖµ£¬ÊÓÓÎÏ·°æ±¾¶ø¶¨£¬´ËÖµÊÇ·þÎñÆ÷¼ì²éÍæ¼ÒÔÚÉèÖÃʱºòµÄ·¶Î§¼ì²éÖµ MaxLognCount =1000 // Max Number of Logins [ºÃÓÑ] // Friend System MaxInvtation =5 // Max Possible Characters Invitation At Same Time InvitTimeOut =30 // Invitation Time Out (In Seconds) MaxFriendPerChar =50 // Max Number of Friends a Character Can Have EveryCharFrndListGroup =10 // (Max value = 10) [×é¶Ó] // Party System MaxInvtation =5 // Max Possible Characters Invitation At Same Time InvitTimeOut =30 // Invitation Time Out (In Seconds) PlayersInsdParty =5 // Max Players Inside A Party [ÁÄÌì] // Chat System MaxMsngPerPlayer =30 // Max Number of Messenger a Player can Join (Max value = 30) MaxPlayerPerMsng =30 // Max Number of players Inside a Messenger (Max value = 100) WrldChanSayInter =20 // World Channel Say Interval (In Seconds) TrdeChanSayInter =20 // Trade Channel Say Interval (In Seconds) WhprChanSayInter =2 // Whisper Channel Say Interval (In Seconds) [³öÉúµØ] // Birthplace Argent City =garner // Argent City Shaitan City =magicsea // Shaitan City Icicle Castle =darkblue // Icicle Castle Edited October 16, 2016 by Susux Quote Share this post Link to post Share on other sites
Shako 97 Report post Posted October 16, 2016 Make sure that the "IP" for accountserver is the same as the one for groupserver. and that you attached GameDB also. Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 show me which part... Quote Share this post Link to post Share on other sites
Shako 97 Report post Posted October 16, 2016 2 hours ago, Susux said: [Database] IP =127.0.0.1 // IP Address Of Server Database DB =GameDB // Database Name Login = // SQL Security Login Password = // SQL Password = MaxVal =2000000000 // Ò»¸öÊôÐÔ³£Á¿£¬ÊôÐÔ´óÓڴ˲»¿ÉÄÜÖµ»á±»×èÖ¹½øÈëÓÎÏ·µØͼ£¬ÉèΪ´Ë¹Ì¶¨Öµ 2 hours ago, Susux said: [db] dbserver = (local) // IP Address Of Server Database db = AccountServer // Database Name userid = // SQL Security Login passwd = // Password = You have one for (local) and one for 127.0.0.1 Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 which one should i use?? local or 127.0.0.1 Quote Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 23 minutes ago, Shako said: You have one for (local) and one for 127.0.0.1 groupserver work now..thanks.. GameServer should i do it same? //GameServer Configuration [ID] name = GameServer00 // GameServer Name equment = System [Gate] gate = 127.0.0.1,1971 // IP, Port (IP Address Of GameServer) [Map] map = garner map = jialebi map = prisonisland [DB] // Database db_ip = (local) // IP Address Of Server Database db_usr = // SQL Security Login db_pass = // SQL Password = Y87dc#$98 [Socket] keep_alive = 1200000000000000000 [BaseID] // ·þÎñÆ÷Ϊ½ÇÉ«·ÖÅäIDµÄ»ùÊý, ÿ¸öµØͼserver¶¼²»Í¬ BaseID = 0x500000000 [Entity] // Impact of memory occupation max_ply = 500 // The number of players max_cha = 15000 // The number of monsters max_item = 30000 // The number of itens max_tnpc = 300 // The number of NPC dialogue [Guild] guild_num = 80 // Max people inside a Guild guild_try_num = 80 // Max people on Guild apply list [Item] item_show_time = 60 // Time for item to desapear (In Seconds) item_prot_time = 30 // Time for item to be looted for another person (In Seconds) [Interval] say_interval = 3 // In Seconds [LOG] log_cha = 0 log_cal = 0 log_ai = 0 log_mission = 0 log_dir = log\\log db_mapmask = 1 [Debug] // µ÷ÊÔÓÃ, ·ÇGMÖ¸Áî supercmd = 1 [Res] res_dir = resource Quote Share this post Link to post Share on other sites
Shako 97 Report post Posted October 16, 2016 @Susux yes, same configuration as groupserver. Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 1 minute ago, Shako said: @Susux yes, same configuration as groupserver. doesn't work... Quote Share this post Link to post Share on other sites
Shako 97 Report post Posted October 16, 2016 4 minutes ago, Susux said: doesn't work... do you have teamviewer? Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 yeah i have Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted October 16, 2016 Enable pipes /ip connections.or use .\SQLEXPRESS On dbserver Quote Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 (edited) 31 minutes ago, Vasil said: Enable pipes /ip connections.or use .\SQLEXPRESS On dbserver will u help me on tv.. Edited October 16, 2016 by Susux Quote Share this post Link to post Share on other sites
Susux 0 Report post Posted October 16, 2016 that why im not use stupid SQL 2008 complicated... Quote Share this post Link to post Share on other sites