[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)

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

that error means that your cabal server cannot connect to MSSQL also check Linked Servers.

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.

no me 2000

Something is stopping the game server connecting to the db. Can centos ping windows as john_d suggests?