[unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
SERVER RUNING !
GlobalDBAgent.log
[Wed Jul 1 2009 19:00:18.030117 3086866112]: open log file '/var/log/cabal/GlobalDBAgent.log'
[Wed Jul 1 2009 19:00:18.030213 3086866112]: LOG LEVEL: 3
[Wed Jul 1 2009 19:00:18.030241 3086866112]: MemPoolUnitSizeClass(0): 14336Bytes
[Wed Jul 1 2009 19:00:18.031408 3086866112]: Start GlobalDBAgent Server
[Wed Jul 1 2009 19:00:18.032279 3086866112]: UseEcryptText (Off)
[Wed Jul 1 2009 19:00:18.041134 3086863264]: CProcessLayer(0)::svc Start [3086863264]
[Wed Jul 1 2009 19:00:18.041227 3076373408]: CProcessLayer(0)::svc Start [3076373408]
[Wed Jul 1 2009 19:00:18.041909 3065883552]: CProcessLayer(0)::svc Start [3065883552]
[Wed Jul 1 2009 19:00:18.042024 3055393696]: CProcessLayer(0)::svc Start [3055393696]
[Wed Jul 1 2009 19:00:18.042286 3086866112]: try listening 38180 port
[Wed Jul 1 2009 19:00:18.043271 3044903840]: CProcessLayer(0)::svc Start [3044903840]
[Wed Jul 1 2009 19:00:18.043999 3034413984]: CProcessLayer(0)::svc Start [3034413984]
[Wed Jul 1 2009 19:00:18.044051 3023924128]: CProcessLayer(0)::svc Start [3023924128]
[Wed Jul 1 2009 19:00:18.044104 3013434272]: CProcessLayer(0)::svc Start [3013434272]
[Wed Jul 1 2009 19:00:18.044159 3002944416]: CProcessLayer(0)::svc Start [3002944416]
[Wed Jul 1 2009 19:00:18.044217 2992454560]: CProcessLayer(0)::svc Start [2992454560]
[Wed Jul 1 2009 19:00:18.589954 3086866112]: accept success 8(127.0.0.1:32769)
[Wed Jul 1 2009 19:00:18.591078 3086866112]: 1.open user 8 [A037C48] (127.0.0.1)
[Wed Jul 1 2009 19:08:34.339504 3086948032]: open log file '/var/log/cabal/GlobalDBAgent.log'
[Wed Jul 1 2009 19:08:34.345740 3086948032]: LOG LEVEL: 3
[Wed Jul 1 2009 19:08:34.346816 3086948032]: MemPoolUnitSizeClass(0): 14336Bytes
[Wed Jul 1 2009 19:08:34.350017 3086948032]: Start GlobalDBAgent Server
[Wed Jul 1 2009 19:08:34.351116 3086948032]: UseEcryptText (Off)
[Wed Jul 1 2009 19:08:34.352642 3086945184]: CProcessLayer(0)::svc Start [3086945184]
[Wed Jul 1 2009 19:08:34.353546 3076455328]: CProcessLayer(0)::svc Start [3076455328]
[Wed Jul 1 2009 19:08:34.353600 3065965472]: CProcessLayer(0)::svc Start [3065965472]
[Wed Jul 1 2009 19:08:34.354583 3086948032]: try listening 38180 port
[Wed Jul 1 2009 19:08:34.355645 3055475616]: CProcessLayer(0)::svc Start [3055475616]
[Wed Jul 1 2009 19:08:34.356972 3044985760]: CProcessLayer(0)::svc Start [3044985760]
[Wed Jul 1 2009 19:08:34.356978 3034495904]: CProcessLayer(0)::svc Start [3034495904]
[Wed Jul 1 2009 19:08:34.356979 3024006048]: CProcessLayer(0)::svc Start [3024006048]
[Wed Jul 1 2009 19:08:34.356979 3013516192]: CProcessLayer(0)::svc Start [3013516192]
[Wed Jul 1 2009 19:08:34.356979 3003026336]: CProcessLayer(0)::svc Start [3003026336]
[Wed Jul 1 2009 19:08:34.357313 2992536480]: CProcessLayer(0)::svc Start [2992536480]
[Wed Jul 1 2009 19:08:35.031503 3086948032]: accept success 8(127.0.0.1:32768)
[Wed Jul 1 2009 19:08:35.033963 3086948032]: 1.open user 8 [8527C48] (127.0.0.1)
[Wed Jul 1 2009 19:12:12.030733 3086501568]: open log file '/var/log/cabal/GlobalDBAgent.log'
[Wed Jul 1 2009 19:12:12.040660 3086501568]: LOG LEVEL: 3
[Wed Jul 1 2009 19:12:12.040857 3086501568]: MemPoolUnitSizeClass(0): 14336Bytes
[Wed Jul 1 2009 19:12:12.043720 3086501568]: Start GlobalDBAgent Server
[Wed Jul 1 2009 19:12:12.044869 3086501568]: UseEcryptText (Off)
[Wed Jul 1 2009 19:12:12.046468 3086498720]: CProcessLayer(0)::svc Start [3086498720]
[Wed Jul 1 2009 19:12:12.046995 3076008864]: CProcessLayer(0)::svc Start [3076008864]
[Wed Jul 1 2009 19:12:12.047431 3065519008]: CProcessLayer(0)::svc Start [3065519008]
[Wed Jul 1 2009 19:12:12.048399 3086501568]: try listening 38180 port
[Wed Jul 1 2009 19:12:12.050395 3055029152]: CProcessLayer(0)::svc Start [3055029152]
[Wed Jul 1 2009 19:12:12.050453 3044539296]: CProcessLayer(0)::svc Start [3044539296]
[Wed Jul 1 2009 19:12:12.050507 3034049440]: CProcessLayer(0)::svc Start [3034049440]
[Wed Jul 1 2009 19:12:12.050863 3023559584]: CProcessLayer(0)::svc Start [3023559584]
[Wed Jul 1 2009 19:12:12.050916 3013069728]: CProcessLayer(0)::svc Start [3013069728]
[Wed Jul 1 2009 19:12:12.051485 3002579872]: CProcessLayer(0)::svc Start [3002579872]
[Wed Jul 1 2009 19:12:12.051855 2992090016]: CProcessLayer(0)::svc Start [2992090016]
[Wed Jul 1 2009 19:12:12.559891 3086501568]: accept success 8(127.0.0.1:32768)
[Wed Jul 1 2009 19:12:12.565319 3086501568]: 1.open user 8 [8DF4C48] (127.0.0.1)
[Wed Jul 1 2009 19:12:26.723449 3086501568]: accept success 10(127.0.0.1:32779)
[Wed Jul 1 2009 19:12:26.723543 3086501568]: 2.open user 10 [8E03370] (127.0.0.1)
[Wed Jul 1 2009 19:12:38.558696 3086498720]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 1 2009 19:12:38.565489 3086498720]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 1 2009 19:12:38.565527 3086498720]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 1 2009 19:12:38.565546 3086498720]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 1 2009 19:12:38.565563 3086498720]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 1 2009 19:12:38.565581 3086498720]: [##ERROR##] Database Connect Fail (uid=sa;pwd=vladiks123;dsn=CabalAccount;APP=GlobalDBAgent)
[Wed Jul 1 2009 19:12:38.565622 3086498720]: [##ERROR##] check 'pDB' fail
[Wed Jul 1 2009 19:12:38.565640 3086498720]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:96)
[Wed Jul 1 2009 19:12:38.565660 3086498720]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(60:0:96) Addr(127.0.0.1)
DBAgent_24.log
[Wed Jul 1 2009 19:00:19.561806 3086681792]: open log file '/var/log/cabal/DBAgent_24.log'
[Wed Jul 1 2009 19:00:19.561893 3086681792]: LOG LEVEL: 3
[Wed Jul 1 2009 19:00:19.561919 3086681792]: MemPoolUnitSizeClass(2): 24576Bytes
[Wed Jul 1 2009 19:00:19.563060 3086681792]: Start DBAgent_24 Server
[Wed Jul 1 2009 19:00:19.563898 3086681792]: UseEcryptText (Off)
[Wed Jul 1 2009 19:00:19.564999 3086681792]: try listening 38181 port
[Wed Jul 1 2009 19:00:19.572940 3086678944]: CProcessLayer(0)::svc Start [3086678944]
[Wed Jul 1 2009 19:00:19.573712 3076189088]: CProcessLayer(0)::svc Start [3076189088]
[Wed Jul 1 2009 19:00:19.573777 3065699232]: CProcessLayer(0)::svc Start [3065699232]
[Wed Jul 1 2009 19:00:19.573835 3055209376]: CProcessLayer(0)::svc Start [3055209376]
[Wed Jul 1 2009 19:00:19.573900 3044719520]: CProcessLayer(0)::svc Start [3044719520]
[Wed Jul 1 2009 19:00:20.134900 3086681792]: accept success 8(127.0.0.1:32771)
[Wed Jul 1 2009 19:00:20.135888 3086681792]: 1.open user 8 [98A3430] (127.0.0.1)
[Wed Jul 1 2009 19:00:20.785695 3086681792]: accept success 10(127.0.0.1:32773)
[Wed Jul 1 2009 19:00:20.786373 3086681792]: 2.open user 10 [98B1B70] (127.0.0.1)
[Wed Jul 1 2009 19:08:35.966831 3086923456]: open log file '/var/log/cabal/DBAgent_24.log'
[Wed Jul 1 2009 19:08:35.968446 3086923456]: LOG LEVEL: 3
[Wed Jul 1 2009 19:08:35.968596 3086923456]: MemPoolUnitSizeClass(2): 24576Bytes
[Wed Jul 1 2009 19:08:35.969694 3086923456]: Start DBAgent_24 Server
[Wed Jul 1 2009 19:08:35.970664 3086923456]: UseEcryptText (Off)
[Wed Jul 1 2009 19:08:35.971653 3086920608]: CProcessLayer(0)::svc Start [3086920608]
[Wed Jul 1 2009 19:08:35.971731 3076430752]: CProcessLayer(0)::svc Start [3076430752]
[Wed Jul 1 2009 19:08:35.971793 3065940896]: CProcessLayer(0)::svc Start [3065940896]
[Wed Jul 1 2009 19:08:35.972282 3055451040]: CProcessLayer(0)::svc Start [3055451040]
[Wed Jul 1 2009 19:08:35.972593 3086923456]: try listening 38181 port
[Wed Jul 1 2009 19:08:35.972794 3044961184]: CProcessLayer(0)::svc Start [3044961184]
[Wed Jul 1 2009 19:08:36.583106 3086923456]: accept success 8(127.0.0.1:32770)
[Wed Jul 1 2009 19:08:36.592155 3086923456]: 1.open user 8 [8368418] (127.0.0.1)
[Wed Jul 1 2009 19:08:37.172561 3086923456]: accept success 10(127.0.0.1:32772)
[Wed Jul 1 2009 19:08:37.173152 3086923456]: 2.open user 10 [8376B58] (127.0.0.1)
[Wed Jul 1 2009 19:12:13.490502 3086362304]: open log file '/var/log/cabal/DBAgent_24.log'
[Wed Jul 1 2009 19:12:13.491350 3086362304]: LOG LEVEL: 3
[Wed Jul 1 2009 19:12:13.491483 3086362304]: MemPoolUnitSizeClass(2): 24576Bytes
[Wed Jul 1 2009 19:12:13.492572 3086362304]: Start DBAgent_24 Server
[Wed Jul 1 2009 19:12:13.493493 3086362304]: UseEcryptText (Off)
[Wed Jul 1 2009 19:12:13.494241 3086362304]: try listening 38181 port
[Wed Jul 1 2009 19:12:13.494593 3086359456]: CProcessLayer(0)::svc Start [3086359456]
[Wed Jul 1 2009 19:12:13.494668 3075869600]: CProcessLayer(0)::svc Start [3075869600]
[Wed Jul 1 2009 19:12:13.495191 3065379744]: CProcessLayer(0)::svc Start [3065379744]
[Wed Jul 1 2009 19:12:13.495242 3054889888]: CProcessLayer(0)::svc Start [3054889888]
[Wed Jul 1 2009 19:12:13.495503 3044400032]: CProcessLayer(0)::svc Start [3044400032]
[Wed Jul 1 2009 19:12:14.064462 3086362304]: accept success 8(127.0.0.1:32770)
[Wed Jul 1 2009 19:12:14.073501 3086362304]: 1.open user 8 [92F1430] (127.0.0.1)
[Wed Jul 1 2009 19:12:14.710274 3086362304]: accept success 10(127.0.0.1:32772)
[Wed Jul 1 2009 19:12:14.710354 3086362304]: 2.open user 10 [92FFB70] (127.0.0.1)
[Wed Jul 1 2009 19:12:24.502686 3044400032]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 1 2009 19:12:24.502837 3044400032]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 1 2009 19:12:24.502856 3044400032]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 1 2009 19:12:24.502874 3044400032]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 1 2009 19:12:24.502891 3044400032]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 1 2009 19:12:24.502908 3044400032]: [##ERROR##] Database Connect Fail (uid=sa;pwd=vladiks123;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 1 2009 19:12:24.503000 3044400032]: [##ERROR##] check 'pDB' fail
[Wed Jul 1 2009 19:12:24.503020 3044400032]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Wed Jul 1 2009 19:12:24.503040 3044400032]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Wed Jul 1 2009 19:12:24.503572 3086359456]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 1 2009 19:12:24.503592 3086359456]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 1 2009 19:12:24.503832 3054889888]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 1 2009 19:12:24.503852 3054889888]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 1 2009 19:12:24.503869 3054889888]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 1 2009 19:12:24.503886 3054889888]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 1 2009 19:12:24.503903 3054889888]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 1 2009 19:12:24.503920 3054889888]: [##ERROR##] Database Connect Fail (uid=sa;pwd=vladiks123;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 1 2009 19:12:24.504817 3054889888]: [##ERROR##] check 'pDB' fail
[Wed Jul 1 2009 19:12:24.504838 3054889888]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 1 2009 19:12:24.504858 3054889888]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Wed Jul 1 2009 19:12:24.504892 3086359456]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 1 2009 19:12:24.504911 3086359456]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 1 2009 19:12:24.504928 3086359456]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 1 2009 19:12:24.504945 3086359456]: [##ERROR##] Database Connect Fail (uid=sa;pwd=vladiks123;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 1 2009 19:12:24.504963 3086359456]: [##ERROR##] check 'pDB' fail
[Wed Jul 1 2009 19:12:24.504980 3086359456]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Wed Jul 1 2009 19:12:24.504998 3086359456]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Wed Jul 1 2009 19:13:14.729002 3075869600]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 1 2009 19:13:14.729055 3075869600]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 1 2009 19:13:14.729075 3075869600]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 1 2009 19:13:14.729092 3075869600]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 1 2009 19:13:14.729109 3075869600]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 1 2009 19:13:14.729662 3075869600]: [##ERROR##] Database Connect Fail (uid=sa;pwd=vladiks123;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 1 2009 19:13:14.729682 3075869600]: [##ERROR##] check 'pDB' fail
[Wed Jul 1 2009 19:13:14.729699 3075869600]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 1 2009 19:13:14.729720 3075869600]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Wed Jul 1 2009 19:14:14.728796 3054889888]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 1 2009 19:14:14.728854 3054889888]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 1 2009 19:14:14.728873 3054889888]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 1 2009 19:14:14.728890 3054889888]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 1 2009 19:14:14.730319 3054889888]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 1 2009 19:14:14.730343 3054889888]: [##ERROR##] Database Connect Fail (uid=sa;pwd=vladiks123;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 1 2009 19:14:14.730763 3054889888]: [##ERROR##] check 'pDB' fail
[Wed Jul 1 2009 19:14:14.730780 3054889888]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 1 2009 19:14:14.730800 3054889888]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Wed Jul 1 2009 19:15:14.735884 3065379744]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 1 2009 19:15:14.735940 3065379744]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 1 2009 19:15:14.736638 3065379744]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 1 2009 19:15:14.737806 3065379744]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 1 2009 19:15:14.737824 3065379744]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 1 2009 19:15:14.737841 3065379744]: [##ERROR##] Database Connect Fail (uid=sa;pwd=vladiks123;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 1 2009 19:15:14.737860 3065379744]: [##ERROR##] check 'pDB' fail
[Wed Jul 1 2009 19:15:14.737877 3065379744]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 1 2009 19:15:14.737912 3065379744]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Wed Jul 1 2009 19:16:14.727129 3065379744]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 1 2009 19:16:14.727186 3065379744]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 1 2009 19:16:14.727205 3065379744]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 1 2009 19:16:14.727222 3065379744]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 1 2009 19:16:14.727240 3065379744]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 1 2009 19:16:14.727511 3065379744]: [##ERROR##] Database Connect Fail (uid=sa;pwd=vladiks123;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 1 2009 19:16:14.727531 3065379744]: [##ERROR##] check 'pDB' fail
[Wed Jul 1 2009 19:16:14.727548 3065379744]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 1 2009 19:16:14.727568 3065379744]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
Re: [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
1. check firewall ( turn it off to check )
2. check mssql if it is open for connection.
3. on random cases your freedts/odbc settings.
4. or your connection from the linux to the mssql is not existent. run > ping IP_OF_MSSQL_SERVER
Re: [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
that error means that your cabal server cannot connect to MSSQL also check Linked Servers.
Re: [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
Also if you use mssql 2005 express remember that a default install will not work as it installs as a named instance and leaves remote connections disabled. Check my sig for guides on how to install express edtions.
Re: [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
Re: [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
Something is stopping the game server connecting to the db. Can centos ping windows as john_d suggests?