I dont get why I get this
Code:
[Sun Jul 13 2008 21:36:24.308814 3054812064]: [##ERROR##] getq fail (108)
[Sun Jul 13 2008 21:36:24.308855 3054812064]: CProcessLayer(0)::svc Terminated [ 3054812064]
[Sun Jul 13 2008 21:36:27.919632 3086563904]: accept success 12(192.168.127.128: 33013)
[Sun Jul 13 2008 21:36:27.922167 3086563904]: 3.open user 12 [8C46AD0] (192.168. 127.128)
[Sun Jul 13 2008 21:36:27.960093 3086563904]: 3.close user 12 [8C46AD0] (192.168 .127.128)
[Sun Jul 13 2008 21:36:33.052509 3086563904]: accept success 12(192.168.127.128: 33017)
[Sun Jul 13 2008 21:36:33.058454 3086563904]: 3.open user 12 [8C46CA8] (192.168. 127.128)
[Sun Jul 13 2008 21:37:03.190318 3086563904]: 3.close user 12 [8C46CA8] (192.168 .127.128)
[Sun Jul 13 2008 21:37:44.590266 3086560160]: [##ERROR##] DB ERROR(MSG) : [ unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Jul 13 2008 21:37:44.596613 3086560160]: [##ERROR##] DB ERROR(CODE) : 2 0009
[Sun Jul 13 2008 21:37:44.597088 3086560160]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Jul 13 2008 21:37:44.597123 3086560160]: [##ERROR##] DB ERROR(SQLSTATE) : 0 8S01
[Sun Jul 13 2008 21:37:44.597595 3086560160]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Jul 13 2008 21:37:44.597722 3086560160]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Sun Jul 13 2008 21:37:44.598151 3086560160]: [##ERROR##] check 'pDB' fail
[Sun Jul 13 2008 21:37:44.598189 3086560160]: [##ERROR##] 'OnIPCIWarGetLastNatio nRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Jul 13 2008 21:37:44.598434 3086560160]: [##ERROR##] UsrMap Fail : MainCmd( 600) Ret(8C:0:140) Addr(192.168.127.128)
[Sun Jul 13 2008 21:40:53.685006 3055090592]: [##ERROR##] DB ERROR(MSG) : [ unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Jul 13 2008 21:40:53.685747 3055090592]: [##ERROR##] DB ERROR(CODE) : 2 0009
[Sun Jul 13 2008 21:40:53.686417 3055090592]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Jul 13 2008 21:40:53.686453 3055090592]: [##ERROR##] DB ERROR(SQLSTATE) : 0 8S01
[Sun Jul 13 2008 21:40:53.686487 3055090592]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Jul 13 2008 21:40:53.686723 3055090592]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Sun Jul 13 2008 21:40:53.686772 3055090592]: [##ERROR##] check 'pDB' fail
[Sun Jul 13 2008 21:40:53.686805 3055090592]: [##ERROR##] 'OnIPCIWarGetLastNatio nRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Jul 13 2008 21:40:53.686843 3055090592]: [##ERROR##] UsrMap Fail : MainCmd( 600) Ret(8C:0:140) Addr(192.168.127.128)
[Sun Jul 13 2008 21:41:25.634899 3086871104]: open log file '/var/log/cabal/DBA gent_24.log'
[Sun Jul 13 2008 21:41:25.635116 3086871104]: LOG LEVEL: 3
[Sun Jul 13 2008 21:41:25.635175 3086871104]: MemPoolUnitSizeClass(2): 24576Byte s
[Sun Jul 13 2008 21:41:25.636906 3086871104]: Start DBAgent_24 Server
[Sun Jul 13 2008 21:41:25.638055 3086871104]: UseEcryptText (Off)
[Sun Jul 13 2008 21:41:25.639662 3086871104]: try listening 38181 port
[Sun Jul 13 2008 21:41:25.648012 3086867360]: CProcessLayer(0)::svc Start [30868 67360]
[Sun Jul 13 2008 21:41:25.648326 3076377504]: CProcessLayer(0)::svc Start [30763 77504]
[Sun Jul 13 2008 21:41:25.648459 3065887648]: CProcessLayer(0)::svc Start [30658 87648]
[Sun Jul 13 2008 21:41:25.648632 3055397792]: CProcessLayer(0)::svc Start [30553 97792]
[Sun Jul 13 2008 21:41:25.653481 3086871104]: [##ERROR##] listen 38181 port fail (Address already in use)
[Sun Jul 13 2008 21:41:25.654288 3086871104]: [##ERROR##] active fail
[Sun Jul 13 2008 21:41:25.648843 3044907936]: CProcessLayer(0)::svc Start [30449 07936]
[Sun Jul 13 2008 21:41:25.654711 3044907936]: CProcessLayer(0)::svc Terminated [ 3044907936]
[Sun Jul 13 2008 21:41:25.655780 3086867360]: [##ERROR##] getq fail (108)
[Sun Jul 13 2008 21:41:25.656141 3086867360]: CProcessLayer(0)::svc Terminated [ 3086867360]
[Sun Jul 13 2008 21:41:25.656278 3076377504]: [##ERROR##] getq fail (108)
[Sun Jul 13 2008 21:41:25.656319 3076377504]: CProcessLayer(0)::svc Terminated [ 3076377504]
[Sun Jul 13 2008 21:41:25.656399 3065887648]: [##ERROR##] getq fail (108)
[Sun Jul 13 2008 21:41:25.656437 3065887648]: CProcessLayer(0)::svc Terminated [ 3065887648]
[Sun Jul 13 2008 21:41:25.656514 3055397792]: [##ERROR##] getq fail (108)
[Sun Jul 13 2008 21:41:25.656560 3055397792]: CProcessLayer(0)::svc Terminated [ 3055397792]
[Sun Jul 13 2008 21:41:26.804259 3086563904]: accept success 12(192.168.127.128: 33038)
[Sun Jul 13 2008 21:41:26.805101 3086563904]: 3.open user 12 [8C46E80] (192.168. 127.128)
[Sun Jul 13 2008 21:41:26.816215 3086563904]: 3.close user 12 [8C46E80] (192.168 .127.128)
[Sun Jul 13 2008 21:41:28.502962 3086563904]: accept success 12(192.168.127.128: 33042)
[Sun Jul 13 2008 21:41:28.507912 3086563904]: 3.open user 12 [8C47058] (192.168. 127.128)
[Sun Jul 13 2008 21:41:43.504834 3086563904]: 3.close user 12 [8C47058] (192.168 .127.128)
[Sun Jul 13 2008 21:44:02.736584 3055090592]: [##ERROR##] DB ERROR(MSG) : [ unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Jul 13 2008 21:44:02.737977 3055090592]: [##ERROR##] DB ERROR(CODE) : 2 0009
[Sun Jul 13 2008 21:44:02.738022 3055090592]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Jul 13 2008 21:44:02.738057 3055090592]: [##ERROR##] DB ERROR(SQLSTATE) : 0 8S01
[Sun Jul 13 2008 21:44:02.738525 3055090592]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Jul 13 2008 21:44:02.738568 3055090592]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Sun Jul 13 2008 21:44:02.738615 3055090592]: [##ERROR##] check 'pDB' fail
[Sun Jul 13 2008 21:44:02.738972 3055090592]: [##ERROR##] 'OnIPCIWarGetLastNatio nRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Jul 13 2008 21:44:02.739013 3055090592]: [##ERROR##] UsrMap Fail : MainCmd( 600) Ret(8C:0:140) Addr(192.168.127.128)
[Sun Jul 13 2008 21:44:59.436046 3086621248]: open log file '/var/log/cabal/DBA gent_24.log'
[Sun Jul 13 2008 21:44:59.436244 3086621248]: LOG LEVEL: 3
[Sun Jul 13 2008 21:44:59.436303 3086621248]: MemPoolUnitSizeClass(2): 24576Byte s
[Sun Jul 13 2008 21:44:59.440108 3086621248]: Start DBAgent_24 Server
[Sun Jul 13 2008 21:44:59.445836 3086621248]: UseEcryptText (Off)
[Sun Jul 13 2008 21:44:59.446795 3086621248]: try listening 38181 port
[Sun Jul 13 2008 21:44:59.446993 3086621248]: [##ERROR##] listen 38181 port fail (Address already in use)
[Sun Jul 13 2008 21:44:59.447199 3086621248]: [##ERROR##] active fail
[Sun Jul 13 2008 21:44:59.451500 3086617504]: CProcessLayer(0)::svc Start [30866 17504]
[Sun Jul 13 2008 21:44:59.451703 3086617504]: CProcessLayer(0)::svc Terminated [ 3086617504]
[Sun Jul 13 2008 21:44:59.452003 3076127648]: CProcessLayer(0)::svc Start [30761 27648]
[Sun Jul 13 2008 21:44:59.452053 3076127648]: CProcessLayer(0)::svc Terminated [ 3076127648]
[Sun Jul 13 2008 21:44:59.452176 3065637792]: CProcessLayer(0)::svc Start [30656 37792]
[Sun Jul 13 2008 21:44:59.452226 3065637792]: CProcessLayer(0)::svc Terminated [ 3065637792]
[Sun Jul 13 2008 21:44:59.452351 3055147936]: CProcessLayer(0)::svc Start [30551 47936]
[Sun Jul 13 2008 21:44:59.452399 3055147936]: CProcessLayer(0)::svc Terminated [ 3055147936]
[Sun Jul 13 2008 21:44:59.452888 3044658080]: CProcessLayer(0)::svc Start [30446 58080]
[Sun Jul 13 2008 21:44:59.452943 3044658080]: CProcessLayer(0)::svc Terminated [ 3044658080]
[Sun Jul 13 2008 21:45:00.645493 3086563904]: accept success 12(192.168.127.128: 33058)
[Sun Jul 13 2008 21:45:00.646205 3086563904]: 3.open user 12 [8C34A18] (192.168. 127.128)
[Sun Jul 13 2008 21:45:01.653042 3086563904]: 3.close user 12 [8C34A18] (192.168 .127.128)
[Sun Jul 13 2008 21:45:02.746698 3086563904]: accept success 12(192.168.127.128: 33062)
[Sun Jul 13 2008 21:45:02.747090 3086563904]: 3.open user 12 [8C34BF0] (192.168. 127.128)
[Sun Jul 13 2008 21:45:14.965943 3086563904]: 3.close user 12 [8C34BF0] (192.168 .127.128)
[Sun Jul 13 2008 21:47:11.741239 3065580448]: [##ERROR##] DB ERROR(MSG) : [ unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Jul 13 2008 21:47:11.764389 3065580448]: [##ERROR##] DB ERROR(CODE) : 2 0009
[Sun Jul 13 2008 21:47:11.764797 3065580448]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Jul 13 2008 21:47:11.764832 3065580448]: [##ERROR##] DB ERROR(SQLSTATE) : 0 8S01
[Sun Jul 13 2008 21:47:11.764866 3065580448]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Jul 13 2008 21:47:11.764905 3065580448]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Sun Jul 13 2008 21:47:11.765338 3065580448]: [##ERROR##] check 'pDB' fail
[Sun Jul 13 2008 21:47:11.765379 3065580448]: [##ERROR##] 'OnIPCIWarGetLastNatio nRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Jul 13 2008 21:47:11.765763 3065580448]: [##ERROR##] UsrMap Fail : MainCmd( 600) Ret(8C:0:140) Addr(192.168.127.128)
[Sun Jul 13 2008 21:50:20.836831 3044600736]: [##ERROR##] DB ERROR(MSG) : [ unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sun Jul 13 2008 21:50:20.837984 3044600736]: [##ERROR##] DB ERROR(CODE) : 2 0009
[Sun Jul 13 2008 21:50:20.838029 3044600736]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Jul 13 2008 21:50:20.838065 3044600736]: [##ERROR##] DB ERROR(SQLSTATE) : 0 8S01
[Sun Jul 13 2008 21:50:20.838098 3044600736]: [##ERROR##] DB ERROR(STM_TEXT) :
[Sun Jul 13 2008 21:50:20.840501 3044600736]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Sun Jul 13 2008 21:50:20.841028 3044600736]: [##ERROR##] check 'pDB' fail
[Sun Jul 13 2008 21:50:20.841106 3044600736]: [##ERROR##] 'OnIPCIWarGetLastNatio nRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sun Jul 13 2008 21:50:20.844560 3044600736]: [##ERROR##] UsrMap Fail : MainCmd( 600) Ret(8C:0:140) Addr(192.168.127.128)
[Sun Jul 13 2008 21:51:56.946255 3086805568]: open log file '/var/log/cabal/DBA gent_24.log'
[Sun Jul 13 2008 21:51:56.946549 3086805568]: LOG LEVEL: 3
[Sun Jul 13 2008 21:51:56.946623 3086805568]: MemPoolUnitSizeClass(2): 24576Byte s
[Sun Jul 13 2008 21:51:56.948278 3086805568]: Start DBAgent_24 Server
[Sun Jul 13 2008 21:51:56.974905 3086805568]: UseEcryptText (Off)
[Sun Jul 13 2008 21:51:56.995678 3086805568]: try listening 38181 port
[Sun Jul 13 2008 21:51:56.996105 3086805568]: [##ERROR##] listen 38181 port fail (Address already in use)
[Sun Jul 13 2008 21:51:56.997852 3086805568]: [##ERROR##] active fail
[Sun Jul 13 2008 21:51:56.998739 3086801824]: CProcessLayer(0)::svc Start [30868 01824]
[Sun Jul 13 2008 21:51:56.999716 3086801824]: CProcessLayer(0)::svc Terminated [ 3086801824]
[Sun Jul 13 2008 21:51:57.006061 3076311968]: CProcessLayer(0)::svc Start [30763 11968]
[Sun Jul 13 2008 21:51:57.008705 3076311968]: CProcessLayer(0)::svc Terminated [ 3076311968]
[Sun Jul 13 2008 21:51:57.009057 3065822112]: CProcessLayer(0)::svc Start [30658 22112]
[Sun Jul 13 2008 21:51:57.009682 3065822112]: CProcessLayer(0)::svc Terminated [ 3065822112]
[Sun Jul 13 2008 21:51:57.009982 3055332256]: CProcessLayer(0)::svc Start [30553 32256]
[Sun Jul 13 2008 21:51:57.010076 3055332256]: CProcessLayer(0)::svc Terminated [ 3055332256]
[Sun Jul 13 2008 21:51:57.017912 3044842400]: CProcessLayer(0)::svc Start [30448 42400]
[Sun Jul 13 2008 21:51:57.018677 3044842400]: CProcessLayer(0)::svc Terminated [ 3044842400]
[Sun Jul 13 2008 21:51:58.033362 3086563904]: accept success 12(192.168.127.128: 33089)
[Sun Jul 13 2008 21:51:58.034556 3086563904]: 3.open user 12 [8C47C20] (192.168. 127.128)
[Sun Jul 13 2008 21:51:58.039045 3086563904]: 3.close user 12 [8C47C20] (192.168 .127.128)
[Sun Jul 13 2008 21:51:59.395524 3086563904]: accept success 12(192.168.127.128: 33093)
[Sun Jul 13 2008 21:51:59.396586 3086563904]: 3.open user 12 [8C34868] (192.168. 127.128)
[Sun Jul 13 2008 21:52:11.952788 3086563904]: 3.close user 12 [8C34868] (192.168 .127.128)
any errors ?
Re: I dont get why I get this
me give this error but i can't resolve :cry: ... i try to make server again :cry:
Re: I dont get why I get this
Re: I dont get why I get this
look to the forum i post 5 thread
Re: I dont get why I get this
hmm
I edited my odbc to be KRAZEY instead of FreeTDS and it still says FreeTDS
Code:
[unixODBC][FreeTDS][SQL Server]
dw prolly says that anyway
Re: I dont get why I get this
Maybe because im using MSSQL 2005 ?
Re: I dont get why I get this
Re: I dont get why I get this
im try reinstall SQL on 2000
Re: I dont get why I get this
Re: I dont get why I get this
The same answer as the other topics, your SQL connection info is wrong and the server cannot connect to the db. Posting the same errors over and over is not going to help, you need to fix your config so either post the whole thing or stop posting the error as neither of you seem to be getting the idea from the half dozen people who have told you how to fix it.
Re: I dont get why I get this
Code:
[CabalGame24]
Driver = FreeTDS
Address = 77.102.117.247
Port = 1433
Database = GameDB
TDS_Version = 8.0
[CabalAccount]
Driver = FreeTDS
Address = 77.102.117.247
Port = 1433
Database = ACCOUNT
TDS_Version = 8.0
[CabalCash]
Driver = FreeTDS
Address = 77.102.117.247
Port = 1433
Database = Cabalcash
TDS_Version = 8.0
I seem to be putting right info
if theres any other files that need windows ip tell me
Re: I dont get why I get this
Re: I dont get why I get this
Re: I dont get why I get this
Quote:
Originally Posted by
chumpywumpy
The same answer as the other topics, your SQL connection info is wrong and the server cannot connect to the db. Posting the same errors over and over is not going to help, you need to fix your config so either post the whole thing or stop posting the error as neither of you seem to be getting the idea from the half dozen people who have told you how to fix it.
ihave same problem sir, can you tall me hoa to fix it? i m trying to figure it out but still im so unlucky thats why for now i think i need ur help sir
Re: I dont get why I get this
@Kreain - In your odbc.ini all 3 ip addresses should be the lan ip of the machine mssql is installed on. Do "ipconfig" from the command prompt on that machine and look for an address starting with 10.xx.xx.xx or 192.xx.xx.xx or post the addresses you see if you are not sure.
In /etc/cabal/ go through each .ini file and change every ip address you can find to 127.0.0.1.
Now edit WorldSvr_24_01.ini in these places...
Code:
[NetLib]
UseEncryptPacket=0 <- Change this to 0
[WorldSvr]
IPAddress=192.168.127.128 <- This should be the lan ip of the centos machine
@ramispo - Start a topic and post configs like Kreain did, and any errors that show up in your logs. It is easier to deal with it on a seperate topic ;)
[ChatNode]
AddrForServer=127.0.0.1
AddrForClient=192.168.127.128 <- This should be the lan ip of the centos
To find the lan ip of the centos machine type "ifconfig" from a terminal and if you can't tell which one it is post what you see.
This will only make it work on the lan by the way, making it work from outside is much harder.
