I dont get why I get this

[Kreain]

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

[MentaL]

[Sarmalutza]

me give this error but i can't resolve :cry: ... i try to make server again :cry:

[Kreain]

ima wait for help

[Sarmalutza]

look to the forum i post 5 thread

[Kreain]

hmm
I edited my odbc to be KRAZEY instead of FreeTDS and it still says FreeTDS

[unixODBC][FreeTDS][SQL Server]

dw prolly says that anyway

[Kreain]

Maybe because im using MSSQL 2005 ?

[Sarmalutza]

no
Im using sql 2000

[Kreain]

im try reinstall SQL on 2000

[Kreain]

bump

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

[Kreain]

[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

[Kreain]

my configs

http://www.sendspace.com/file/o6x526

[Kreain]

bump

[ramispo]

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

[chumpywumpy]

@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...

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

[chumpywumpy]

@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...

[NetLib]
UseEncryptPacket=0 <- Change this to 0

[WorldSvr]
IPAddress=192.168.127.128 <- This should be the lan ip of the centos machine

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

@ramispo - Start a topic and post log file errors and configs like Kreain did and i will take a look. It is easier not to have 2 topics on one ;)

EDIT: Sorry for th double post. Not sure what happened :/

[Kreain]

[jonathan3137]

To fix the first error, the db error, try to do this(I think):
Go to enterprise manager, and delete all cabal users from: ACCOUNT, cabal_managerdb, CabalCash, Event, Gamedb.
then go to security, logins, double click on cabal user u set before, database access, and select all the database I said before.
and for the 2nd error about the port, retry about 3 times to restart ur server, if doesnt work open ports 30000-40000 in ur router and disable firewall

[Kreain]

dun get it Oo

[Kreain]

bump

[Kreain]

helps mehs ?

[chumpywumpy]

I'll take another look when i get in from work. Looking at the ipconfig your odbc.ini is ok it is the server configs and possibly the sql login at fault.

D you use sql 2000 or 2005? I think i saw you say it was 2000 on another post but i want to be sure.

[Kreain]

2005 xD

[chumpywumpy]

I figured it would be easier if i made a little guide out of this to help others:

http://forum.ragezone.com/showthread.php?t=431889

What IP does your "ifconfig" show in the Centos machine? I still need to do some testing with internal and external access myself but i think yours will be an easier one to set up looking at the info above. Try checking the guide above and playing with your IPs in the configs a bit but i think you are pretty much there (your odbc.ini is fine by the look of it).

I willupdate again tomorrow after some testing ;)

[Kreain]

hmm did your guide yet nothing, same error D:
I also checked my configs, :(. check the ones i posted up there plx D: