[SOLVED]Connection beetwen server and database.
Ok so after 2 days of reading tutorials i started installing a cabal server.
So,i have a pc with 4gb ddr3 and an core 2 duo with 2800+
The resources are enoughf.
First a install on the pc win7 ultimate premium edition x64.
The i install ussing this tutorial http://forum.ragezone.com/f460/guide...repack-444970/ mssql2005 and made the exact stepts like in the tutorial without errors.
Second i download the centos and created an virtual machine with vmware 7.4.
I copied the filles of the server in root.I am ussing this version
http://forum.ragezone.com/f459/tdp-c...ack-v2-632493/
I runned cabal_install.sh without errors.Then i runned cabal_config.sh without error to.
I have an router with the external ip addres 193.41.248.91
Mi windows ip is 192.168.1.100 and mi Centos virtual machine is 192.168.1.104 (internet works on both machines)
When i runned the config and got asked of the addrese i selected the external one to make the server public(internet) and in the mssql i inserted 192.168.1.100 and the user cabal that i created after the tutorial and the password.
I started a test server and it runned ok.
But in the logs i get this
CashDBAgent.log
Code:
[Sun Apr 17 2011 16:19:04.143121 3086550720]: open log file '/var/log/cabal/CashDBAgent.log'
[Sun Apr 17 2011 16:19:04.143255 3086550720]: LOG LEVEL: 3
[Sun Apr 17 2011 16:19:04.143299 3086550720]: MemPoolUnitSizeClass(0): 14336Bytes
[Sun Apr 17 2011 16:19:04.144522 3086550720]: Start CashDBAgent Server
[Sun Apr 17 2011 16:19:04.145459 3086550720]: UseEcryptText (Off)
[Sun Apr 17 2011 16:19:04.148617 3086547872]: CProcessLayer(0)::svc Start [3086547872]
[Sun Apr 17 2011 16:19:04.148788 3076058016]: CProcessLayer(0)::svc Start [3076058016]
[Sun Apr 17 2011 16:19:04.148914 3065568160]: CProcessLayer(0)::svc Start [3065568160]
[Sun Apr 17 2011 16:19:04.149022 3055078304]: CProcessLayer(0)::svc Start [3055078304]
[Sun Apr 17 2011 16:19:04.149179 3044588448]: CProcessLayer(0)::svc Start [3044588448]
[Sun Apr 17 2011 16:19:04.149297 3034098592]: CProcessLayer(0)::svc Start [3034098592]
[Sun Apr 17 2011 16:19:04.149406 3023608736]: CProcessLayer(0)::svc Start [3023608736]
[Sun Apr 17 2011 16:19:04.149514 3013118880]: CProcessLayer(0)::svc Start [3013118880]
[Sun Apr 17 2011 16:19:04.149685 3086550720]: try listening 38190 port
[Sun Apr 17 2011 16:19:04.149853 3002629024]: CProcessLayer(0)::svc Start [3002629024]
[Sun Apr 17 2011 16:19:04.149940 2992139168]: CProcessLayer(0)::svc Start [2992139168]
[Sun Apr 17 2011 16:19:05.966487 3086550720]: accept success 8(127.0.0.1:33387)
[Sun Apr 17 2011 16:19:05.968311 3086550720]: 1.open user 8 [85CDC18] (127.0.0.1)
ChatNode_24.log
Code:
[Sun Apr 17 2011 16:19:05.366859 3086386880]: open log file '/var/log/cabal/ChatNode_24.log'
[Sun Apr 17 2011 16:19:05.367024 3086386880]: LOG LEVEL: 3
[Sun Apr 17 2011 16:19:05.367086 3086386880]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Apr 17 2011 16:19:05.368313 3086386880]: Start ChatNode_24 Server
[Sun Apr 17 2011 16:19:05.368431 3086386880]: main(): ChatServerId(250:24:1)
[Sun Apr 17 2011 16:19:05.368532 3086386880]: ReloadConfig(): ReloadConfig
[Sun Apr 17 2011 16:19:05.368559 3086386880]: LOG LEVEL: 3
[Sun Apr 17 2011 16:19:05.368605 3086386880]: SetSayChannelMgrLogSay(): LogSay: 0
[Sun Apr 17 2011 16:19:05.368632 3086386880]: ReloadConfig(): BroadCastOverServerNation: 0
[Sun Apr 17 2011 16:19:05.368658 3086386880]: ReloadConfig(): UseGuildCreateFee: 1
[Sun Apr 17 2011 16:19:05.368684 3086386880]: ReloadConfig(): CharLevelForGuildCreate: 40
[Sun Apr 17 2011 16:19:05.368709 3086386880]: ReloadConfig(): AllowGuildBoard: 0
[Sun Apr 17 2011 16:19:05.380277 3086113696]: CProcessLayer(0)::svc Start [3086113696]
[Sun Apr 17 2011 16:19:05.380480 3075623840]: CProcessLayer(0)::svc Start [3075623840]
[Sun Apr 17 2011 16:19:05.380591 3065133984]: CProcessLayer(0)::svc Start [3065133984]
[Sun Apr 17 2011 16:19:05.381095 3086386880]: try connect 127.0.0.1:38170, Sync
[Sun Apr 17 2011 16:19:05.382233 3086386880]: sock 5 ->LinkHandler Open
[Sun Apr 17 2011 16:19:05.382311 3086386880]: SendIPSConnect2Svr (250:24:01:00)
[Sun Apr 17 2011 16:19:05.382378 3086386880]: try connect 127.0.0.1:53424, Sync
[Sun Apr 17 2011 16:19:05.384440 3086386880]: sock 7 ->LinkHandler Open
[Sun Apr 17 2011 16:19:05.384492 3086386880]: SendIPSConnect2Svr (250:24:01:00)
[Sun Apr 17 2011 16:19:05.384555 3086386880]: try listening 38144 port
[Sun Apr 17 2011 16:19:05.386206 3054644128]: CProcessLayer(0)::svc Start [3054644128]
[Sun Apr 17 2011 16:19:05.386337 3044154272]: CProcessLayer(0)::svc Start [3044154272]
[Sun Apr 17 2011 16:19:05.386461 3033664416]: CProcessLayer(0)::svc Start [3033664416]
[Sun Apr 17 2011 16:19:05.386591 3023174560]: CProcessLayer(0)::svc Start [3023174560]
[Sun Apr 17 2011 16:19:05.386699 3012684704]: CProcessLayer(0)::svc Start [3012684704]
[Sun Apr 17 2011 16:19:05.969067 3086386880]: accept success 9(127.0.0.1:33388)
[Sun Apr 17 2011 16:19:05.969215 3086386880]: 1.open user 9 [81DA0F0] (127.0.0.1)
[Sun Apr 17 2011 16:19:15.870558 3054644128]: OnIPCConnect2Svr(): new WorldSvr linked(161, 24, 1)
DBAgent_24.log
Code:
[Sun Apr 17 2011 16:19:04.828173 3086526144]: open log file '/var/log/cabal/DBAgent_24.log'
[Sun Apr 17 2011 16:19:04.828306 3086526144]: LOG LEVEL: 3
[Sun Apr 17 2011 16:19:04.828351 3086526144]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Apr 17 2011 16:19:04.829591 3086526144]: Start DBAgent_24 Server
[Sun Apr 17 2011 16:19:04.830562 3086526144]: UseEcryptText (Off)
[Sun Apr 17 2011 16:19:04.831155 3086526144]: try listening 53424 port
[Sun Apr 17 2011 16:19:04.835510 3086523296]: CProcessLayer(0)::svc Start [3086523296]
[Sun Apr 17 2011 16:19:04.835669 3076033440]: CProcessLayer(0)::svc Start [3076033440]
[Sun Apr 17 2011 16:19:04.835791 3065543584]: CProcessLayer(0)::svc Start [3065543584]
[Sun Apr 17 2011 16:19:04.835909 3055053728]: CProcessLayer(0)::svc Start [3055053728]
[Sun Apr 17 2011 16:19:04.836068 3044563872]: CProcessLayer(0)::svc Start [3044563872]
[Sun Apr 17 2011 16:19:05.382616 3086526144]: accept success 8(127.0.0.1:33384)
[Sun Apr 17 2011 16:19:05.384005 3086526144]: 1.open user 8 [93C9430] (127.0.0.1)
[Sun Apr 17 2011 16:19:05.965619 3086526144]: accept success 10(127.0.0.1:33386)
[Sun Apr 17 2011 16:19:05.965804 3086526144]: 2.open user 10 [93D7B70] (127.0.0.1)
[Sun Apr 17 2011 16:19:15.882928 3076033440]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:19:15.882963 3076033440]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:19:15.882988 3076033440]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:19:15.883012 3076033440]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:19:15.883037 3076033440]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:19:15.883061 3076033440]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:19:15.883134 3076033440]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:19:15.883159 3076033440]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:19:15.883186 3076033440]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 16:19:15.890748 3065543584]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:19:15.890783 3065543584]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:19:15.890808 3065543584]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:19:15.890832 3065543584]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:19:15.890856 3065543584]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:19:15.890887 3065543584]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:19:15.890945 3065543584]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:19:15.890970 3065543584]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Sun Apr 17 2011 16:19:15.890996 3065543584]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Sun Apr 17 2011 16:19:15.897443 3055053728]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:19:15.897479 3055053728]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:19:15.897504 3055053728]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:19:15.897528 3055053728]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:19:15.897553 3055053728]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:19:15.897577 3055053728]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:19:15.897612 3055053728]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:19:15.897637 3055053728]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Sun Apr 17 2011 16:19:15.897663 3055053728]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Sun Apr 17 2011 16:20:05.981511 3076033440]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:20:05.981609 3076033440]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:20:05.981643 3076033440]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:20:05.981676 3076033440]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:20:05.981723 3076033440]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:20:05.981763 3076033440]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:20:05.981799 3076033440]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:20:05.981831 3076033440]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:20:05.981866 3076033440]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 16:21:05.981877 3044563872]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:21:05.981936 3044563872]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:21:05.981970 3044563872]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:21:05.982003 3044563872]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:21:05.982035 3044563872]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:21:05.982068 3044563872]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:21:05.982102 3044563872]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:21:05.982135 3044563872]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:21:05.982169 3044563872]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 16:22:05.981937 3044563872]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:22:05.982015 3044563872]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:22:05.982049 3044563872]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:22:05.982081 3044563872]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:22:05.982114 3044563872]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:22:05.982146 3044563872]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:22:05.982185 3044563872]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:22:05.982217 3044563872]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:22:05.982252 3044563872]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 16:23:05.977531 3044563872]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:23:05.977595 3044563872]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:23:05.977620 3044563872]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:23:05.977645 3044563872]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:23:05.977669 3044563872]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:23:05.977694 3044563872]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:23:05.977731 3044563872]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:23:05.977756 3044563872]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:23:05.977782 3044563872]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 16:24:05.979505 3044563872]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:24:05.979578 3044563872]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:24:05.979629 3044563872]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:24:05.979671 3044563872]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:24:05.979696 3044563872]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:24:05.979721 3044563872]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:24:05.979750 3044563872]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:24:05.979775 3044563872]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:24:05.979801 3044563872]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 16:25:05.977810 3044563872]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:25:05.977877 3044563872]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:25:05.977903 3044563872]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:25:05.977927 3044563872]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:25:05.977951 3044563872]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:25:05.977976 3044563872]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:25:05.978005 3044563872]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:25:05.978029 3044563872]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:25:05.978055 3044563872]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 16:26:05.975632 3044563872]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:26:05.975696 3044563872]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:26:05.975722 3044563872]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:26:05.975746 3044563872]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:26:05.975771 3044563872]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:26:05.975795 3044563872]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:26:05.975825 3044563872]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:26:05.975849 3044563872]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:26:05.975875 3044563872]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 16:27:05.981936 3086523296]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:27:05.982025 3086523296]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:27:05.982060 3086523296]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:27:05.982101 3086523296]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:27:05.982134 3086523296]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:27:05.982167 3086523296]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:27:05.982206 3086523296]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:27:05.982238 3086523296]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:27:05.982273 3086523296]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 16:28:05.979978 3076033440]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:28:05.980040 3076033440]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:28:05.980074 3076033440]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:28:05.980107 3076033440]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:28:05.980139 3076033440]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:28:05.980205 3076033440]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
[Sun Apr 17 2011 16:28:05.980241 3076033440]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 16:28:05.980273 3076033440]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 16:28:05.980308 3076033440]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
ps i changed the db pass in mypass for security reasons :D
GlobalDBAgent.log
Code:
[Sun Apr 17 2011 16:19:02.881049 3086198464]: open log file '/var/log/cabal/GlobalDBAgent.log'
[Sun Apr 17 2011 16:19:02.881172 3086198464]: LOG LEVEL: 3
[Sun Apr 17 2011 16:19:02.881217 3086198464]: MemPoolUnitSizeClass(0): 14336Bytes
[Sun Apr 17 2011 16:19:02.882463 3086198464]: Start GlobalDBAgent Server
[Sun Apr 17 2011 16:19:02.883551 3086198464]: UseEcryptText (Off)
[Sun Apr 17 2011 16:19:02.893807 3086195616]: CProcessLayer(0)::svc Start [3086195616]
[Sun Apr 17 2011 16:19:02.893997 3075705760]: CProcessLayer(0)::svc Start [3075705760]
[Sun Apr 17 2011 16:19:02.894120 3065215904]: CProcessLayer(0)::svc Start [3065215904]
[Sun Apr 17 2011 16:19:02.894611 3086198464]: try listening 38180 port
[Sun Apr 17 2011 16:19:02.894768 3054726048]: CProcessLayer(0)::svc Start [3054726048]
[Sun Apr 17 2011 16:19:02.894918 3044236192]: CProcessLayer(0)::svc Start [3044236192]
[Sun Apr 17 2011 16:19:02.895051 3033746336]: CProcessLayer(0)::svc Start [3033746336]
[Sun Apr 17 2011 16:19:02.895184 3023256480]: CProcessLayer(0)::svc Start [3023256480]
[Sun Apr 17 2011 16:19:02.895311 3012766624]: CProcessLayer(0)::svc Start [3012766624]
[Sun Apr 17 2011 16:19:02.895420 3002276768]: CProcessLayer(0)::svc Start [3002276768]
[Sun Apr 17 2011 16:19:02.895530 2991786912]: CProcessLayer(0)::svc Start [2991786912]
[Sun Apr 17 2011 16:19:03.683283 3086198464]: accept success 8(127.0.0.1:33382)
[Sun Apr 17 2011 16:19:03.684622 3086198464]: 1.open user 8 [8923C48] (127.0.0.1)
[Sun Apr 17 2011 16:19:08.380907 3086198464]: accept success 10(127.0.0.1:33390)
[Sun Apr 17 2011 16:19:08.381233 3086198464]: 2.open user 10 [8932388] (127.0.0.1)
GlobalMgrSvr.log
Code:
[Sun Apr 17 2011 16:19:03.585397 3085932224]: open log file '/var/log/cabal/GlobalMgrSvr.log'
[Sun Apr 17 2011 16:19:03.585550 3085932224]: LOG LEVEL: 3
[Sun Apr 17 2011 16:19:03.585597 3085932224]: MemPoolUnitSizeClass(0): 14336Bytes
[Sun Apr 17 2011 16:19:03.586968 3085932224]: Start GlobalMgrSvr Server
[Sun Apr 17 2011 16:19:03.588672 3085932224]: LoadServerAndChannelType(1)
[Sun Apr 17 2011 16:19:03.588753 3085932224]: channelType[1][1]: 0
[Sun Apr 17 2011 16:19:03.588781 3085932224]: maxUserName[1][1]: 100
[Sun Apr 17 2011 16:19:03.589563 3085932224]: channelType[2][1]: 1
[Sun Apr 17 2011 16:19:03.589592 3085932224]: maxUserName[2][1]: 100
[Sun Apr 17 2011 16:19:03.590348 3085932224]: channelType[3][1]: 8
[Sun Apr 17 2011 16:19:03.590376 3085932224]: maxUserName[3][1]: 100
[Sun Apr 17 2011 16:19:03.591135 3085932224]: channelType[4][10]: 16908368
[Sun Apr 17 2011 16:19:03.591200 3085932224]: maxUserName[4][10]: 100
[Sun Apr 17 2011 16:19:03.591866 3085932224]: channelType[5][1]: 0
[Sun Apr 17 2011 16:19:03.591895 3085932224]: maxUserName[5][1]: 100
[Sun Apr 17 2011 16:19:03.591970 3085932224]: channelType[5][10]: 16908368
[Sun Apr 17 2011 16:19:03.591997 3085932224]: maxUserName[5][10]: 100
[Sun Apr 17 2011 16:19:03.592694 3085932224]: channelType[6][1]: 0
[Sun Apr 17 2011 16:19:03.592723 3085932224]: maxUserName[6][1]: 100
[Sun Apr 17 2011 16:19:03.592764 3085932224]: channelType[6][4]: 8
[Sun Apr 17 2011 16:19:03.592791 3085932224]: maxUserName[6][4]: 100
[Sun Apr 17 2011 16:19:03.592853 3085932224]: channelType[6][10]: 16908368
[Sun Apr 17 2011 16:19:03.592881 3085932224]: maxUserName[6][10]: 100
[Sun Apr 17 2011 16:19:03.593572 3085932224]: channelType[7][1]: 1
[Sun Apr 17 2011 16:19:03.593600 3085932224]: maxUserName[7][1]: 100
[Sun Apr 17 2011 16:19:03.593641 3085932224]: channelType[7][4]: 8
[Sun Apr 17 2011 16:19:03.593668 3085932224]: maxUserName[7][4]: 100
[Sun Apr 17 2011 16:19:03.593735 3085932224]: channelType[7][10]: 16908368
[Sun Apr 17 2011 16:19:03.593762 3085932224]: maxUserName[7][10]: 100
[Sun Apr 17 2011 16:19:03.594460 3085932224]: channelType[8][1]: 1
[Sun Apr 17 2011 16:19:03.594488 3085932224]: maxUserName[8][1]: 100
[Sun Apr 17 2011 16:19:03.594529 3085932224]: channelType[8][4]: 4
[Sun Apr 17 2011 16:19:03.594556 3085932224]: maxUserName[8][4]: 100
[Sun Apr 17 2011 16:19:03.594585 3085932224]: channelType[8][5]: 12
[Sun Apr 17 2011 16:19:03.594613 3085932224]: maxUserName[8][5]: 100
[Sun Apr 17 2011 16:19:03.594665 3085932224]: channelType[8][10]: 16908368
[Sun Apr 17 2011 16:19:03.594700 3085932224]: maxUserName[8][10]: 100
[Sun Apr 17 2011 16:19:03.595402 3085932224]: channelType[9][1]: 1
[Sun Apr 17 2011 16:19:03.595430 3085932224]: maxUserName[9][1]: 100
[Sun Apr 17 2011 16:19:03.595459 3085932224]: channelType[9][2]: 4
[Sun Apr 17 2011 16:19:03.595487 3085932224]: maxUserName[9][2]: 100
[Sun Apr 17 2011 16:19:03.595521 3085932224]: channelType[9][4]: 8
[Sun Apr 17 2011 16:19:03.595548 3085932224]: maxUserName[9][4]: 100
[Sun Apr 17 2011 16:19:03.595606 3085932224]: channelType[9][10]: 16908368
[Sun Apr 17 2011 16:19:03.595633 3085932224]: maxUserName[9][10]: 100
[Sun Apr 17 2011 16:19:03.596326 3085932224]: channelType[10][1]: 0
[Sun Apr 17 2011 16:19:03.596354 3085932224]: maxUserName[10][1]: 100
[Sun Apr 17 2011 16:19:03.596383 3085932224]: channelType[10][2]: 4
[Sun Apr 17 2011 16:19:03.596410 3085932224]: maxUserName[10][2]: 100
[Sun Apr 17 2011 16:19:03.596446 3085932224]: channelType[10][4]: 5
[Sun Apr 17 2011 16:19:03.596473 3085932224]: maxUserName[10][4]: 100
[Sun Apr 17 2011 16:19:03.596502 3085932224]: channelType[10][5]: 12
[Sun Apr 17 2011 16:19:03.596529 3085932224]: maxUserName[10][5]: 100
[Sun Apr 17 2011 16:19:03.596581 3085932224]: channelType[10][10]: 16908368
[Sun Apr 17 2011 16:19:03.596608 3085932224]: maxUserName[10][10]: 100
[Sun Apr 17 2011 16:19:03.609584 3085932224]: channelType[11][1]: 0
[Sun Apr 17 2011 16:19:03.609616 3085932224]: maxUserName[11][1]: 100
[Sun Apr 17 2011 16:19:03.610363 3085932224]: channelType[12][1]: 8
[Sun Apr 17 2011 16:19:03.610391 3085932224]: maxUserName[12][1]: 100
[Sun Apr 17 2011 16:19:03.614239 3085932224]: channelType[18][1]: 0
[Sun Apr 17 2011 16:19:03.614269 3085932224]: maxUserName[18][1]: 100
[Sun Apr 17 2011 16:19:03.614299 3085932224]: channelType[18][2]: 1
[Sun Apr 17 2011 16:19:03.614326 3085932224]: maxUserName[18][2]: 100
[Sun Apr 17 2011 16:19:03.615049 3085932224]: channelType[19][1]: 0
[Sun Apr 17 2011 16:19:03.615077 3085932224]: maxUserName[19][1]: 100
[Sun Apr 17 2011 16:19:03.615106 3085932224]: channelType[19][2]: 1
[Sun Apr 17 2011 16:19:03.615133 3085932224]: maxUserName[19][2]: 100
[Sun Apr 17 2011 16:19:03.615867 3085932224]: channelType[20][1]: 0
[Sun Apr 17 2011 16:19:03.615895 3085932224]: maxUserName[20][1]: 100
[Sun Apr 17 2011 16:19:03.615924 3085932224]: channelType[20][2]: 1
[Sun Apr 17 2011 16:19:03.615951 3085932224]: maxUserName[20][2]: 100
[Sun Apr 17 2011 16:19:03.618475 3085932224]: channelType[24][1]: 1
[Sun Apr 17 2011 16:19:03.618503 3085932224]: maxUserName[24][1]: 100
[Sun Apr 17 2011 16:19:03.682934 3085932224]: try connect 127.0.0.1:38180, Sync
[Sun Apr 17 2011 16:19:03.685438 3085932224]: sock 7 ->LinkHandler Open
[Sun Apr 17 2011 16:19:03.685521 3085932224]: SendIPSConnect2Svr (246:128:00:00)
[Sun Apr 17 2011 16:19:03.685571 3085932224]: try listening 38170 port
[Sun Apr 17 2011 16:19:03.686835 3085462432]: CProcessLayer(0)::svc Start [3085462432]
[Sun Apr 17 2011 16:19:05.381360 3085932224]: accept success 10(127.0.0.1:33383)
[Sun Apr 17 2011 16:19:05.381576 3085932224]: 1.open user 10 [92EBB70] (127.0.0.1)
[Sun Apr 17 2011 16:19:05.384997 3085462432]: new chatnode session (24:01)
[Sun Apr 17 2011 16:19:05.964542 3085932224]: accept success 11(127.0.0.1:33385)
[Sun Apr 17 2011 16:19:05.964668 3085932224]: 2.open user 11 [92F1FC0] (127.0.0.1)
[Sun Apr 17 2011 16:19:05.969527 3085462432]: new chat server session (250:24:01)
[Sun Apr 17 2011 16:19:08.379899 3085932224]: accept success 12(127.0.0.1:33389)
[Sun Apr 17 2011 16:19:08.380083 3085932224]: 3.open user 12 [92F8558] (127.0.0.1)
[Sun Apr 17 2011 16:19:08.381851 3085462432]: new server session (128:01)
[Sun Apr 17 2011 16:19:15.881329 3085462432]: new server session (24:01)
LoginSvr_01.log
Code:
[Sun Apr 17 2011 16:19:07.525794 3086890688]: open log file '/var/log/cabal/LoginSvr_01.log'
[Sun Apr 17 2011 16:19:07.525954 3086890688]: LOG LEVEL: 3
[Sun Apr 17 2011 16:19:07.525999 3086890688]: MemPoolUnitSizeClass(0): 14336Bytes
[Sun Apr 17 2011 16:19:07.527193 3086890688]: Start LoginSvr_01 Server
[Sun Apr 17 2011 16:19:07.527288 3086890688]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Sun Apr 17 2011 16:19:07.527330 3086890688]: TestChannelGroupIdxStartPoint=50
[Sun Apr 17 2011 16:19:07.527411 3086890688]: affiliatedCorpIP=121.170.135.;
[Sun Apr 17 2011 16:19:07.527438 3086890688]: AdminIP=121.170.135.;
[Sun Apr 17 2011 16:19:07.527481 3086890688]: client_version=22
[Sun Apr 17 2011 16:19:07.527506 3086890688]: IgnoreClientVersion(1)
[Sun Apr 17 2011 16:19:07.527602 3086890688]: UseAntiOnlineGameAddictionSystem(1)
[Sun Apr 17 2011 16:19:07.527636 3086890688]: AdultAge(18)
[Sun Apr 17 2011 16:19:07.527662 3086890688]: DefaultAgeAdult(1)
[Sun Apr 17 2011 16:19:07.527705 3086890688]: UsePSS(0)
[Sun Apr 17 2011 16:19:07.527730 3086890688]: CachedPSS(0)
[Sun Apr 17 2011 16:19:07.527756 3086890688]: PssCacheDurationMin(1440)
[Sun Apr 17 2011 16:19:07.527782 3086890688]: CutIfPssUserNotFound(0)
[Sun Apr 17 2011 16:19:07.527808 3086890688]: PssLogLevel(0)
[Sun Apr 17 2011 16:19:07.527833 3086890688]: InstantPlayTimeClearIntervalMin(300)
[Sun Apr 17 2011 16:19:07.527859 3086890688]: IDC(1)
[Sun Apr 17 2011 16:19:07.527889 3086890688]: SharedPssPersonId(0)
[Sun Apr 17 2011 16:19:07.527915 3086890688]: NormalClientMagicKey(1168110)
[Sun Apr 17 2011 16:19:07.527941 3086890688]: UseImageAuth(0)
[Sun Apr 17 2011 16:19:07.527966 3086890688]: ImageAuthDataPath(./ImageAuth/)
[Sun Apr 17 2011 16:19:07.527992 3086890688]: ImageAuthMaxTryCount(5)
[Sun Apr 17 2011 16:19:07.528017 3086890688]: ImageAuthWaitTime(120000)
[Sun Apr 17 2011 16:19:07.528043 3086890688]: BlockIfImageAuthFail(0)
[Sun Apr 17 2011 16:19:07.528068 3086890688]: UseServerListManualOrder(0)
[Sun Apr 17 2011 16:19:07.528092 3086890688]: 00:00 => 0
[Sun Apr 17 2011 16:19:07.528117 3086890688]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Sun Apr 17 2011 16:19:07.528150 3086890688]: ImageAuthDataMgr Init Begin
[Sun Apr 17 2011 16:19:08.378154 3086890688]: ImageAuthDataMgr Init End(Count:1995)
[Sun Apr 17 2011 16:19:08.379699 3086890688]: try connect 127.0.0.1:38170, Sync
[Sun Apr 17 2011 16:19:08.380594 3086890688]: sock 7 ->LinkHandler Open
[Sun Apr 17 2011 16:19:08.380682 3086890688]: SendIPSConnect2Svr (195:128:01:00)
[Sun Apr 17 2011 16:19:08.380740 3086890688]: try connect 127.0.0.1:38180, Sync
[Sun Apr 17 2011 16:19:08.381371 3086890688]: sock 9 ->LinkHandler Open
[Sun Apr 17 2011 16:19:08.381472 3086890688]: SendIPSConnect2Svr (195:128:01:00)
[Sun Apr 17 2011 16:19:08.381557 3086890688]: try listening 38101 port
[Sun Apr 17 2011 16:19:08.593825 3078589344]: CProcessLayer(0)::svc Start [3078589344]
[Sun Apr 17 2011 16:19:08.594004 3078589344]: ServerState changed(0 -> 0)
WorldSvr_24_01.log
Code:
[Sun Apr 17 2011 16:19:05.958991 3086968512]: open log file '/var/log/cabal/WorldSvr_24_01.log'
[Sun Apr 17 2011 16:19:05.959137 3086968512]: LOG LEVEL: 3
[Sun Apr 17 2011 16:19:05.959261 3086968512]: MemPoolUnitSizeClass(5): 16384Bytes
[Sun Apr 17 2011 16:19:05.960409 3086968512]: Start WorldSvr_24_01 Server
[Sun Apr 17 2011 16:19:05.960556 3086968512]: CheckSkillCoolTimeHack (Off)
[Sun Apr 17 2011 16:19:05.960583 3086968512]: CheckShopHack (Off)
[Sun Apr 17 2011 16:19:05.960609 3086968512]: CheckWarpHack (Off)
[Sun Apr 17 2011 16:19:05.960634 3086968512]: CheckWareHouseHack (Off)
[Sun Apr 17 2011 16:19:05.960660 3086968512]: UseCheckDistanceSkillHack (Off)
[Sun Apr 17 2011 16:19:05.960686 3086968512]: MaxTimeHackingCount(2)
[Sun Apr 17 2011 16:19:05.960712 3086968512]: MaxDistanceHackingCount(2)
[Sun Apr 17 2011 16:19:05.960737 3086968512]: UseNonClientCheck (Off)
[Sun Apr 17 2011 16:19:05.960763 3086968512]: NonClientDisAdvantageRate (90)
[Sun Apr 17 2011 16:19:05.960789 3086968512]: useDropDiscount (On)
[Sun Apr 17 2011 16:19:05.960840 3086968512]: UseBlessingBeadCheck (Off)
[Sun Apr 17 2011 16:19:05.960867 3086968512]: AllowTradeChannel (Off)
[Sun Apr 17 2011 16:19:05.960893 3086968512]: UseCheckMissionIdx(Off)
[Sun Apr 17 2011 16:19:05.960919 3086968512]: UseCheckDeadStatActive(Off)
[Sun Apr 17 2011 16:19:05.960952 3086968512]: reload ActiveDeadStatCount(30)
[Sun Apr 17 2011 16:19:05.960978 3086968512]: UseHackcheckByTimeScope (Off)
[Sun Apr 17 2011 16:19:05.961004 3086968512]: CheckSkillTimeHackScope(60000)
[Sun Apr 17 2011 16:19:05.961029 3086968512]: UseMobsChaseModify (On)
[Sun Apr 17 2011 16:19:05.961055 3086968512]: UseAlzDbHackCheck (Off)
[Sun Apr 17 2011 16:19:05.961081 3086968512]: UseCutIfAlzDbHacked (Off)
[Sun Apr 17 2011 16:19:05.961107 3086968512]: useCheckUserAttack (Off)
[Sun Apr 17 2011 16:19:05.961132 3086968512]: UseHackUserDBSave (On)
[Sun Apr 17 2011 16:19:05.961158 3086968512]: UseAdminUser (On)
[Sun Apr 17 2011 16:19:05.961243 3086968512]: UseAntiOnlineGameAddictionSystem(1)
[Sun Apr 17 2011 16:19:05.961275 3086968512]: InstantPlayTimeClearIntervalMin(300)
[Sun Apr 17 2011 16:19:05.961302 3086968512]: InstantPlayTimeDbUpdateIntervalMin(5)
[Sun Apr 17 2011 16:19:05.961328 3086968512]: InstantPlayTimeNotifyIntervalMin(1)
[Sun Apr 17 2011 16:19:05.961355 3086968512]: AdvantageBoundaryTime(10800, 18000)
[Sun Apr 17 2011 16:19:05.961381 3086968512]: InstantPlayTimeDebugMultiple(1)
[Sun Apr 17 2011 16:19:05.961407 3086968512]: UseCheckBelongItem (Off)
[Sun Apr 17 2011 16:19:05.961433 3086968512]: UseCheckDMZArea (Off)
[Sun Apr 17 2011 16:19:05.961467 3086968512]: AllowCashShop(1)
[Sun Apr 17 2011 16:19:05.961493 3086968512]: AllowNetcafePoint(0)
[Sun Apr 17 2011 16:19:05.961519 3086968512]: RestrictOddCircleUseCountInDungeon (On)
[Sun Apr 17 2011 16:19:05.961547 3086968512]: UseAdditionalMissionDungeonInstanceInPremiumCH (Off)
[Sun Apr 17 2011 16:19:05.961572 3086968512]: UseAdditionalMissionDungeonInstanceInPremiumUser (Off)
[Sun Apr 17 2011 16:19:05.961596 3086968512]: AdditionalMissionDungeonInstanceCount (0)
[Sun Apr 17 2011 16:19:05.961621 3086968512]: UsePvpBetting (Off)
[Sun Apr 17 2011 16:19:05.961647 3086968512]: PShopOpenLimitCount (0)
[Sun Apr 17 2011 16:19:05.961672 3086968512]: UseTradeChannelRestriction (Off)
[Sun Apr 17 2011 16:19:05.961698 3086968512]: UseArtOfDefensePenalty (On)
[Sun Apr 17 2011 16:19:05.961724 3086968512]: IgnorePartyInviteDistance (Off)
[Sun Apr 17 2011 16:19:05.961749 3086968512]: UseWorldDrop (On)
[Sun Apr 17 2011 16:19:05.961775 3086968512]: UseInventoryHackCheck (Off)
[Sun Apr 17 2011 16:19:05.961801 3086968512]: UseRandomValueWriteLog (Off)
[Sun Apr 17 2011 16:19:05.961840 3086968512]: UseMinLevDiffValueForExpCalc (On)
[Sun Apr 17 2011 16:19:05.961866 3086968512]: UsePartyMinExpForInvalidPartyMember (On)
[Sun Apr 17 2011 16:19:05.961892 3086968512]: UseIgnoreOtherBlessBuff (Off)
[Sun Apr 17 2011 16:19:05.961916 3086968512]: Extended Alz Mode
[Sun Apr 17 2011 16:19:05.961964 3086968512]: GameGuard enabled version
[Sun Apr 17 2011 16:19:05.961989 3086968512]: GameGuard turned off
[Sun Apr 17 2011 16:19:05.962056 3086968512]: APEX enabled version
[Sun Apr 17 2011 16:19:05.962083 3086968512]: APEX turned off
[Sun Apr 17 2011 16:19:05.962106 3086968512]: XTrap disabled version
[Sun Apr 17 2011 16:19:05.962132 3086968512]: WaitUntilChannelTypeSet(Off)
[Sun Apr 17 2011 16:19:05.962158 3086968512]: UseBootUpGmsChannelType(On)
[Sun Apr 17 2011 16:19:05.963435 3086968512]: Local ip = 193.41.248.91 (from ini)
[Sun Apr 17 2011 16:19:05.963519 3086968512]: MaxAttackHackTime (300000)
[Sun Apr 17 2011 16:19:05.963546 3086968512]: SpeedHackCheckTime (10000)
[Sun Apr 17 2011 16:19:05.964281 3086968512]: try connect 127.0.0.1:38170, Sync
[Sun Apr 17 2011 16:19:05.965282 3086968512]: sock 5 ->LinkHandler Open
[Sun Apr 17 2011 16:19:05.965384 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Sun Apr 17 2011 16:19:05.965442 3086968512]: try connect 127.0.0.1:53424, Sync
[Sun Apr 17 2011 16:19:05.966162 3086968512]: sock 7 ->LinkHandler Open
[Sun Apr 17 2011 16:19:05.966215 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Sun Apr 17 2011 16:19:05.966274 3086968512]: try connect 127.0.0.1:38190, Sync
[Sun Apr 17 2011 16:19:05.968745 3086968512]: sock 8 ->LinkHandler Open
[Sun Apr 17 2011 16:19:05.968821 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Sun Apr 17 2011 16:19:05.968887 3086968512]: try connect 127.0.0.1:38144, Sync
[Sun Apr 17 2011 16:19:05.969665 3086968512]: sock 9 ->LinkHandler Open
[Sun Apr 17 2011 16:19:05.969719 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Sun Apr 17 2011 16:19:06.024570 20675488]: CProcessLayer(0)::svc Start [20675488]
[Sun Apr 17 2011 16:19:06.066584 3086968512]: GuildCreateFee: 10000000
[Sun Apr 17 2011 16:19:10.033313 69843872]: CProcessLayer(1)::svc Start [69843872]
[Sun Apr 17 2011 16:19:10.033428 34782112]: CProcessLayer(2)::svc Start [34782112]
[Sun Apr 17 2011 16:19:10.301457 45271968]: CProcessLayer(3)::svc Start [45271968]
[Sun Apr 17 2011 16:19:10.477236 55761824]: CProcessLayer(4)::svc Start [55761824]
[Sun Apr 17 2011 16:19:10.477349 80333728]: CProcessLayer(5)::svc Start [80333728]
[Sun Apr 17 2011 16:19:10.720163 90823584]: CProcessLayer(6)::svc Start [90823584]
[Sun Apr 17 2011 16:19:10.720255 101313440]: CProcessLayer(7)::svc Start [101313440]
[Sun Apr 17 2011 16:19:10.981510 111803296]: CProcessLayer(8)::svc Start [111803296]
[Sun Apr 17 2011 16:19:10.981597 122293152]: CProcessLayer(9)::svc Start [122293152]
[Sun Apr 17 2011 16:19:11.231095 132783008]: CProcessLayer(10)::svc Start [132783008]
[Sun Apr 17 2011 16:19:11.231191 2970987424]: CProcessLayer(13)::svc Start [2970987424]
[Sun Apr 17 2011 16:19:11.506017 2955107232]: CProcessLayer(14)::svc Start [2955107232]
[Sun Apr 17 2011 16:19:11.506113 2934590368]: CProcessLayer(19)::svc Start [2934590368]
[Sun Apr 17 2011 16:19:11.742113 2919611296]: CProcessLayer(23)::svc Start [2919611296]
[Sun Apr 17 2011 16:19:11.742195 2904460192]: CProcessLayer(24)::svc Start [2904460192]
[Sun Apr 17 2011 16:19:11.949950 2889272224]: CProcessLayer(25)::svc Start [2889272224]
[Sun Apr 17 2011 16:19:11.950070 2874268576]: CProcessLayer(26)::svc Start [2874268576]
[Sun Apr 17 2011 16:19:12.183243 2858167200]: CProcessLayer(27)::svc Start [2858167200]
[Sun Apr 17 2011 16:19:12.183337 2843179936]: CProcessLayer(28)::svc Start [2843179936]
[Sun Apr 17 2011 16:19:12.406226 2828102560]: CProcessLayer(29)::svc Start [2828102560]
[Sun Apr 17 2011 16:19:12.406310 2812857248]: CProcessLayer(30)::svc Start [2812857248]
[Sun Apr 17 2011 16:19:12.462991 3086968512]: try listening 38111 port
[Sun Apr 17 2011 16:19:15.881771 20675488]: ChannelType changed(0 -> 1)
PS the internet setting are corect.I connected to the linux with winsc from the windows with the ip 192.168.1.104 and from another pc with the external ip of server 193.41.248.91 and it works.
So why doesent the srv connect to the database?
PS how do i install the web page so the players can create they accounts? i tried this but i couldnt manage to do it.http://forum.ragezone.com/f459/cabal...v3-1-a-644514/
I did the quieries but the page and setup the config.php but the page doesent load.I am ussing xampp on windows as a webserver.
http://193.41.248.91/
Thanks in advance for the tutorials and for the future help.
Regards
PS firewall is off on windows(dont need it aniway with and router) and the ports of cabal and ssh ar forwarded.(all)
Re: Connection beetwen server and database.
[Sun Apr 17 2011 16:28:05.979978 3076033440]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Sun Apr 17 2011 16:28:05.980040 3076033440]: [##ERROR##] DB ERROR(CODE) : 4060
[Sun Apr 17 2011 16:28:05.980074 3076033440]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 16:28:05.980107 3076033440]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 16:28:05.980139 3076033440]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 16:28:05.980205 3076033440]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=mypass;dsn=CabalGame;APP=DBAgent_24)
Did you Restore the
GAMEDB.bak in Database?
Re: Connection beetwen server and database.
yes i did all the steps in the tutorial on the psd from that post succesfull
Re: Connection beetwen server and database.
First of all remove linked server http://forum.ragezone.com/f460/remov...server-576629/ then take a look here http://forum.ragezone.com/f460/conne...lution-736658/ and for database:
From Surface Area Configuration then choose Surface Area Configuration for Services and Connections after that go to Remote Connections check Local and remote connections then check Using both TCP/IP and named pipes after that click apply and it will require restart service,go to Service Stop service and Start Again then Apply ,OK ,NOW YOU REMOTE CONNECTION IS ENABLED ,now setup again your server using the user sa and password for it.
Re: Connection beetwen server and database.
I think Something's wrong with you're MSSQL
Can you Delete the GameDB then Make A new One Then Restore it Again :-)
then set the permissions to grant youre desired Login...
Re: Connection beetwen server and database.
ok.I have to leave the home now for a couple of hours but whne i come home i will do the steps from your fisrt link and then post again.
Thnaks
---------- Post added at 04:00 PM ---------- Previous post was at 02:12 PM ----------
After i make the queries to remove the linked server do y have to remove the user cabal and the serverlink from the database?
PS: is the sa account like root for linux, in mssql database?
Re: Connection beetwen server and database.
Yes you have to remove the linked server.
Yes "sa" means server administration for SQL
Re: Connection beetwen server and database.
i dont have stored procedures folder in the databse :O
Re: Connection beetwen server and database.
ofcourse you have
here:(note this is in sql 2005)
http://img703.imageshack.us/img703/1461/procg.jpg
Re: Connection beetwen server and database.
i did the part with the database editing but i dont understand where to do the rest.
Code:
From Surface Area Configuration then choose Surface Area Configuration for Services and Connections after that go to Remote Connections check Local and remote connections then check Using both TCP/IP and named pipes after that click apply and it will require restart service,go to Service Stop service and Start Again then Apply ,OK ,NOW YOU REMOTE CONNECTION IS ENABLED ,now setup again your server using the user sa and password for it.
Re: Connection beetwen server and database.
Setup again your server then see if in log DBAGENT is written at the end DATABASE CONNECT SUCCES,something like that.
Re: Connection beetwen server and database.
Quote:
Originally Posted by
Popa Andrei
i did the part with the database editing but i dont understand where to do the rest.
Code:
From Surface Area Configuration then choose Surface Area Configuration for Services and Connections after that go to Remote Connections check Local and remote connections then check Using both TCP/IP and named pipes after that click apply and it will require restart service,go to Service Stop service and Start Again then Apply ,OK ,NOW YOU REMOTE CONNECTION IS ENABLED ,now setup again your server using the user sa and password for it.
here
http://img847.imageshack.us/img847/3126/remotes.jpg
Re: Connection beetwen server and database.
Then click Apply,then will require an restart service,so go to Service press Stop then Start then Apply and OK and the remote connections has been activated.
Re: Connection beetwen server and database.
Quote:
Originally Posted by
Amaymon
Then click Apply,then will require an restart service,so go to Service press Stop then Start then Apply and OK and the remote connections has been activated.
Please stop spamming.You are really annoying
Re: Connection beetwen server and database.
that is allready done.
Still no connection.I will reinstall the database without the remoteserver tri it fresh the will announce here.
---------- Post added at 06:55 PM ---------- Previous post was at 06:33 PM ----------
I did an restore to the database and made like you sed.Now in the log i have this
DBAgent_06.log
Code:
[Sun Apr 17 2011 21:57:28.744969 3086603968]: open log file '/var/log/cabal/DBAgent_06.log'
[Sun Apr 17 2011 21:57:28.745102 3086603968]: LOG LEVEL: 3
[Sun Apr 17 2011 21:57:28.745146 3086603968]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Apr 17 2011 21:57:28.746402 3086603968]: Start DBAgent_06 Server
[Sun Apr 17 2011 21:57:28.747350 3086603968]: UseEcryptText (Off)
[Sun Apr 17 2011 21:57:28.757776 3086601120]: CProcessLayer(0)::svc Start [3086601120]
[Sun Apr 17 2011 21:57:28.757941 3076111264]: CProcessLayer(0)::svc Start [3076111264]
[Sun Apr 17 2011 21:57:28.758072 3065621408]: CProcessLayer(0)::svc Start [3065621408]
[Sun Apr 17 2011 21:57:28.758181 3055131552]: CProcessLayer(0)::svc Start [3055131552]
[Sun Apr 17 2011 21:57:28.758336 3086603968]: try listening 38186 port
[Sun Apr 17 2011 21:57:28.758498 3044641696]: CProcessLayer(0)::svc Start [3044641696]
[Sun Apr 17 2011 21:57:29.309523 3086603968]: accept success 8(127.0.0.1:32959)
[Sun Apr 17 2011 21:57:29.310875 3086603968]: 1.open user 8 [8AB6408] (127.0.0.1)
[Sun Apr 17 2011 21:57:29.860454 3086603968]: accept success 10(127.0.0.1:32961)
[Sun Apr 17 2011 21:57:29.860599 3086603968]: 2.open user 10 [8AC4B48] (127.0.0.1)
[Sun Apr 17 2011 21:57:31.083156 3086603968]: accept success 11(127.0.0.1:32965)
[Sun Apr 17 2011 21:57:31.083487 3086603968]: 3.open user 11 [8AD0D58] (127.0.0.1)
[Sun Apr 17 2011 21:57:45.811849 3076111264]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Login failed for user 'sa'.
[Sun Apr 17 2011 21:57:45.811891 3076111264]: [##ERROR##] DB ERROR(CODE) : 18456
[Sun Apr 17 2011 21:57:45.811916 3076111264]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 21:57:45.811941 3076111264]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 21:57:45.811965 3076111264]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 21:57:45.811989 3076111264]: [##ERROR##] Database Connect Fail (uid=sa;pwd=mypass;dsn=CabalGame;APP=DBAgent_06)
[Sun Apr 17 2011 21:57:45.812082 3076111264]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 21:57:45.812107 3076111264]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Sun Apr 17 2011 21:57:45.812133 3076111264]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Sun Apr 17 2011 21:57:45.818996 3065621408]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Login failed for user 'sa'.
[Sun Apr 17 2011 21:57:45.819029 3065621408]: [##ERROR##] DB ERROR(CODE) : 18456
[Sun Apr 17 2011 21:57:45.819064 3065621408]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 21:57:45.819088 3065621408]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 21:57:45.819112 3065621408]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 21:57:45.819137 3065621408]: [##ERROR##] Database Connect Fail (uid=sa;pwd=mypass;dsn=CabalGame;APP=DBAgent_06)
[Sun Apr 17 2011 21:57:45.819162 3065621408]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 21:57:45.819186 3065621408]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Sun Apr 17 2011 21:57:45.819212 3065621408]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Sun Apr 17 2011 21:57:45.819275 3086601120]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Login failed for user 'sa'.
[Sun Apr 17 2011 21:57:45.819301 3086601120]: [##ERROR##] DB ERROR(CODE) : 18456
[Sun Apr 17 2011 21:57:45.819326 3086601120]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 21:57:45.819350 3086601120]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 21:57:45.819374 3086601120]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 21:57:45.819398 3086601120]: [##ERROR##] Database Connect Fail (uid=sa;pwd=mypass;dsn=CabalGame;APP=DBAgent_06)
[Sun Apr 17 2011 21:57:45.819440 3086601120]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 21:57:45.819464 3086601120]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 21:57:45.819490 3086601120]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 21:57:47.478537 3044641696]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Login failed for user 'sa'.
[Sun Apr 17 2011 21:57:47.478608 3044641696]: [##ERROR##] DB ERROR(CODE) : 18456
[Sun Apr 17 2011 21:57:47.478634 3044641696]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 21:57:47.478659 3044641696]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 21:57:47.478683 3044641696]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 21:57:47.478707 3044641696]: [##ERROR##] Database Connect Fail (uid=sa;pwd=mypass;dsn=CabalGame;APP=DBAgent_06)
[Sun Apr 17 2011 21:57:47.478745 3044641696]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 21:57:47.478770 3044641696]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Apr 17 2011 21:57:47.478797 3044641696]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Sun Apr 17 2011 21:57:47.493854 3065621408]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Login failed for user 'sa'.
[Sun Apr 17 2011 21:57:47.493899 3065621408]: [##ERROR##] DB ERROR(CODE) : 18456
[Sun Apr 17 2011 21:57:47.493924 3065621408]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 21:57:47.493948 3065621408]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 21:57:47.493972 3065621408]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 21:57:47.493997 3065621408]: [##ERROR##] Database Connect Fail (uid=sa;pwd=mypass;dsn=CabalGame;APP=DBAgent_06)
[Sun Apr 17 2011 21:57:47.494023 3065621408]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 21:57:47.494047 3065621408]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Sun Apr 17 2011 21:57:47.494073 3065621408]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Sun Apr 17 2011 21:57:47.494141 3076111264]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Login failed for user 'sa'.
[Sun Apr 17 2011 21:57:47.494167 3076111264]: [##ERROR##] DB ERROR(CODE) : 18456
[Sun Apr 17 2011 21:57:47.494191 3076111264]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Apr 17 2011 21:57:47.494215 3076111264]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Sun Apr 17 2011 21:57:47.494249 3076111264]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Apr 17 2011 21:57:47.494273 3076111264]: [##ERROR##] Database Connect Fail (uid=sa;pwd=mypass;dsn=CabalGame;APP=DBAgent_06)
[Sun Apr 17 2011 21:57:47.494299 3076111264]: [##ERROR##] check 'pDB' fail
[Sun Apr 17 2011 21:57:47.494329 3076111264]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Sun Apr 17 2011 21:57:47.494356 3076111264]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
in the cabal_config.sh i used for the srv ip 193.41.248.91
for mssql i ussed 192.168.1.100 (the widows internal ip)
userd: sa
pass: mypass
PS: is there a port that i need to forward pehaps for mssql?