[HELP] DBAgent_24 Log Error , FreeTDS ?

Quote:

---

Wed Jul 30 2008 14:31:10.974031 3086640832]: open log file '/var/log/cabal/DBAgent_24.log'
[Wed Jul 30 2008 14:31:10.974523 3086640832]: LOG LEVEL: 3
[Wed Jul 30 2008 14:31:10.974579 3086640832]: MemPoolUnitSizeClass(2): 24576Bytes
[Wed Jul 30 2008 14:31:10.976977 3086640832]: Start DBAgent_24 Server
[Wed Jul 30 2008 14:31:10.978544 3086640832]: UseEcryptText (Off)
[Wed Jul 30 2008 14:31:10.995561 3086637984]: CProcessLayer(0)::svc Start [3086637984]
[Wed Jul 30 2008 14:31:10.996014 3076148128]: CProcessLayer(0)::svc Start [3076148128]
[Wed Jul 30 2008 14:31:10.996849 3065658272]: CProcessLayer(0)::svc Start [3065658272]
[Wed Jul 30 2008 14:31:10.997097 3055168416]: CProcessLayer(0)::svc Start [3055168416]
[Wed Jul 30 2008 14:31:10.998235 3086640832]: try listening 38181 port
[Wed Jul 30 2008 14:31:10.998531 3044678560]: CProcessLayer(0)::svc Start [3044678560]
[Wed Jul 30 2008 14:31:12.174298 3086640832]: accept success 8(10.0.0.3:33217)
[Wed Jul 30 2008 14:31:12.175359 3086640832]: 1.open user 8 [8BDCFF8] (10.0.0.3)
[Wed Jul 30 2008 14:31:14.058738 3086640832]: accept success 10(10.0.0.3:33221)
[Wed Jul 30 2008 14:31:14.058925 3086640832]: 2.open user 10 [8BEB738] (10.0.0.3)
[Wed Jul 30 2008 14:31:42.020976 3044678560]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Wed Jul 30 2008 14:31:42.021178 3044678560]: [##ERROR##] DB ERROR(CODE) : 0
[Wed Jul 30 2008 14:31:42.021222 3044678560]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:31:42.021263 3044678560]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Wed Jul 30 2008 14:31:42.021304 3044678560]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:31:42.021344 3044678560]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:31:42.023140 3044678560]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:31:42.023186 3044678560]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Wed Jul 30 2008 14:31:42.023231 3044678560]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(10.0.0.3)
[Wed Jul 30 2008 14:31:52.036956 3086637984]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Wed Jul 30 2008 14:31:52.037037 3086637984]: [##ERROR##] DB ERROR(CODE) : 0
[Wed Jul 30 2008 14:31:52.037081 3086637984]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:31:52.037160 3086637984]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Wed Jul 30 2008 14:31:52.037203 3086637984]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:31:52.037245 3086637984]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:31:52.037289 3086637984]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:31:52.037329 3086637984]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Wed Jul 30 2008 14:31:52.037374 3086637984]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(10.0.0.3)
[Wed Jul 30 2008 14:31:52.037586 3055168416]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Wed Jul 30 2008 14:31:52.037633 3055168416]: [##ERROR##] DB ERROR(CODE) : 0
[Wed Jul 30 2008 14:31:52.037673 3055168416]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:31:52.037714 3055168416]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Wed Jul 30 2008 14:31:52.037755 3055168416]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:31:52.037796 3055168416]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:31:52.037856 3055168416]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:31:52.037897 3055168416]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:31:52.037941 3055168416]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:32:24.144317 3086637984]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Wed Jul 30 2008 14:32:24.144402 3086637984]: [##ERROR##] DB ERROR(CODE) : 0
[Wed Jul 30 2008 14:32:24.144446 3086637984]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:32:24.144488 3086637984]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Wed Jul 30 2008 14:32:24.144530 3086637984]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:32:24.144571 3086637984]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:32:24.144614 3086637984]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:32:24.144655 3086637984]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:32:24.144714 3086637984]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:33:24.127266 3076148128]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Wed Jul 30 2008 14:33:24.127600 3076148128]: [##ERROR##] DB ERROR(CODE) : 0
[Wed Jul 30 2008 14:33:24.127646 3076148128]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:33:24.127687 3076148128]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Wed Jul 30 2008 14:33:24.127728 3076148128]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:33:24.127770 3076148128]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:33:24.128255 3076148128]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:33:24.128296 3076148128]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:33:24.128341 3076148128]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:34:24.125737 3086637984]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[Wed Jul 30 2008 14:34:24.125822 3086637984]: [##ERROR##] DB ERROR(CODE) : 0
[Wed Jul 30 2008 14:34:24.125866 3086637984]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:34:24.125908 3086637984]: [##ERROR##] DB ERROR(SQLSTATE) : 08001
[Wed Jul 30 2008 14:34:24.125950 3086637984]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:34:24.126491 3086637984]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:34:24.126536 3086637984]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:34:24.126744 3086637984]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:34:24.126898 3086637984]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:35:14.093890 3076148128]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 30 2008 14:35:14.094029 3076148128]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 30 2008 14:35:14.094088 3076148128]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:35:14.094673 3076148128]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 30 2008 14:35:14.094883 3076148128]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:35:14.094950 3076148128]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:35:14.095021 3076148128]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:35:14.095105 3076148128]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:35:14.095999 3076148128]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:36:14.085984 3055168416]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 30 2008 14:36:14.086129 3055168416]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 30 2008 14:36:14.086188 3055168416]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:36:14.086243 3055168416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 30 2008 14:36:14.086297 3055168416]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:36:14.086352 3055168416]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:36:14.086408 3055168416]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:36:14.086462 3055168416]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:36:14.086520 3055168416]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:37:14.093984 3076148128]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 30 2008 14:37:14.094121 3076148128]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 30 2008 14:37:14.094181 3076148128]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:37:14.094251 3076148128]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 30 2008 14:37:14.094325 3076148128]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:37:14.094388 3076148128]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:37:14.094450 3076148128]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:37:14.094503 3076148128]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:37:14.094560 3076148128]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:38:14.084351 3055168416]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 30 2008 14:38:14.084524 3055168416]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 30 2008 14:38:14.084586 3055168416]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:38:14.084642 3055168416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 30 2008 14:38:14.084696 3055168416]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:38:14.084751 3055168416]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:38:14.084844 3055168416]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:38:14.084899 3055168416]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:38:14.084957 3055168416]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:39:14.077771 3055168416]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 30 2008 14:39:14.077989 3055168416]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 30 2008 14:39:14.078049 3055168416]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:39:14.078115 3055168416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 30 2008 14:39:14.078185 3055168416]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:39:14.078249 3055168416]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:39:14.078306 3055168416]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:39:14.078360 3055168416]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:39:14.078429 3055168416]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:40:14.097261 3044678560]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 30 2008 14:40:14.097418 3044678560]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 30 2008 14:40:14.097493 3044678560]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:40:14.098064 3044678560]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 30 2008 14:40:14.098280 3044678560]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:40:14.098350 3044678560]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:40:14.098448 3044678560]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:40:14.099021 3044678560]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:40:14.101421 3044678560]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:41:14.094195 3086637984]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 30 2008 14:41:14.094601 3086637984]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 30 2008 14:41:14.094691 3086637984]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:41:14.095191 3086637984]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 30 2008 14:41:14.095245 3086637984]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:41:14.095548 3086637984]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:41:14.095604 3086637984]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:41:14.095657 3086637984]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:41:14.096138 3086637984]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)
[Wed Jul 30 2008 14:42:14.089291 3044678560]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Jul 30 2008 14:42:14.089442 3044678560]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Jul 30 2008 14:42:14.089525 3044678560]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jul 30 2008 14:42:14.089586 3044678560]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Jul 30 2008 14:42:14.089652 3044678560]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Jul 30 2008 14:42:14.089706 3044678560]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Wed Jul 30 2008 14:42:14.089762 3044678560]: [##ERROR##] check 'pDB' fail
[Wed Jul 30 2008 14:42:14.089814 3044678560]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Jul 30 2008 14:42:14.089871 3044678560]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(10.0.0.3)

---

Some Info :
Centos IP : 10.0.0.3
tryed to to eth0:0 Routh also.
Windows IP : As Written in my local area connection 10.0.0.1
in the SQL > Links > gameserver >
DRIVER={SQL Server};SERVER=(LOCAL);UID=cabal;PWD=cabal;
Insted of localhost i have (LOCAL) ( only way for the link to work )
if it has anything to do with it.
Inside ODBC.ini at /root/etc/odbc.ini i have 10.0.0.1 Which is my Windows IP.
Inside Gen_Config i tryed Putting 127.0.0.1 , 10.0.0.1 , 10.0.0.138 ( Default Gateway of windows Local Area Connection ) , 10.0.0.3
and still getting this error.
All /root/etc/cabal has Centos IP

All other Logs doesnt seem to have any Errors.
only DBAgent_24.


I'm Sure i did everything Mahi did in his Movie Guide.
I'm Sure installed freetds
I'm Sure i searched for all the messages and didnt get a solution
I'm Sure my cabal user and password is right and works for all Databases.

Someone has another solution?
i'm not behind Router and i use SQL 2000



Thanks for the helpers and sorry for my horrible english.

Quote:

---

Originally Posted by RafiGinat

DRIVER={SQL Server};SERVER=(LOCAL);UID=cabal;PWD=cabal;
Insted of localhost i have (LOCAL) ( only way for the link to work )
if it has anything to do with it.
Inside ODBC.ini at /root/etc/odbc.ini i have 10.0.0.1 Which is my Windows IP.
Inside Gen_Config i tryed Putting 127.0.0.1 , 10.0.0.1 , 10.0.0.138 ( Default Gateway of windows Local Area Connection ) , 10.0.0.3
and still getting this error.
All /root/etc/cabal has Centos IP

All other Logs doesnt seem to have any Errors.
only DBAgent_24.


I'm Sure i did everything Mahi did in his Movie Guide.
I'm Sure installed freetds
I'm Sure i searched for all the messages and didnt get a solution
I'm Sure my cabal user and password is right and works for all Databases.

Someone has another solution?
i'm not behind Router and i use SQL 2000



Thanks for the helpers and sorry for my horrible english.

---

Are you sure you have the right database username and password? Check your sql security against your .ini files

Quote:

---

Originally Posted by juris

Are you sure you have the right database username and password? Check your sql security against your .ini files

---

already checked
and yes.

reinstall freetds-unixODBC and don't use the gen-config.sh script.

Quote:

---

Originally Posted by juris

reinstall freetds-unixODBC and don't use the gen-config.sh script.

---

how can i re-install freetds , and how i "dont use" gen_config script?
i need to setup default ip? and which ip is it?
thanks!

Have you watched everything from Mahi's video? watch carefully.
after that come back here.

Quote:

---

Originally Posted by juris

Have you watched everything from Mahi's video? watch carefully.
after that come back here.

---

Mahi's Video's Never showed how to Re-Install freetds.
Correct me and Prove me if i'm wrong.

yeah I know but it shows how to install. Ok, my purpose is to let you learn so that you can troubleshoot things on your own.

Open up a terminal window in your CentOS then issue this command
go to the directory where you dump your freetds-uniodbc rpm. In this case from Mahi's video its /root then do this :

rpm -ivh freetds-unixodbc-0.64RC3-1.i386.rpm --force

after that edit your odbc.ini in /etc then copy the edited odbc.ini to /usr/loca/etc just in case in reads your odbc config in that directory

Lastly, read some or google some linux commands

Quote:

---

Originally Posted by juris

yeah I know but it shows how to install. Ok, my purpose is to let you learn so that you can troubleshoot things on your own.

Open up a terminal window in your CentOS then issue this command
go to the directory where you dump your freetds-uniodbc rpm. In this case from Mahi's video its /root then do this :

rpm -ivh freetds-unixodbc-0.64RC3-1.i386.rpm --force

after that edit your odbc.ini in /etc then copy the edited odbc.ini to /usr/loca/etc just in case in reads your odbc config in that directory

Lastly, read some or google some linux commands

---

I tryed to figure my self whats the command to "Re-Install" but couldnt figure what it is.


I did what you just told me to do but it aint worked.
i Re-Installed FreeTDS and put the ODBC.ini Configured aswell in usr/local/etc and in my /etc aswell
and edited all ip's in /etc/cabal to Centos IP


Anything Ealse to suggest?
Apreciate your help!

ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.

This is your clue. work from there. obviously your odbc cannot connect to your windos mssql. Please check everything from Windows side. Is the sql server running? check the service. Open up your sql server check if added a security user as a systems administrator with all the priviledges in your ACCOUNT database.

Are you using the default

[DSN]
DBId=cabal
DBPwd=cabal

in all your ini files? then check if you put that DBid and DBPwd in your sql security

Quote:

---

Originally Posted by RafiGinat

in the SQL > Links > gameserver >
DRIVER={SQL Server};SERVER=(LOCAL);UID=cabal;PWD=cabal;

---

Every guide that lists the linked server settings has the correct connection string, and that isn't it. You are editing things you shouldn't.

DRIVER={SQL Server};SERVER=(LOCAL);UID=;PWD=;

NO username and NO password, this is taken care of by the configs.

Quote:

---

Originally Posted by chumpywumpy

Every guide that lists the linked server settings has the correct connection string, and that isn't it. You are editing things you shouldn't.

DRIVER={SQL Server};SERVER=(LOCAL);UID=;PWD=;

NO username and NO password, this is taken care of by the configs.

---

Thanks , but it still the same error.

Quote:

---

Originally Posted by juris

ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.

This is your clue. work from there. obviously your odbc cannot connect to your windos mssql. Please check everything from Windows side. Is the sql server running? check the service. Open up your sql server check if added a security user as a systems administrator with all the priviledges in your ACCOUNT database.

Are you using the default

[DSN]
DBId=cabal
DBPwd=cabal

in all your ini files? then check if you put that DBid and DBPwd in your sql security

---

Yes , yes yes yes yes yes yes and yes.
everything alright.


But still remaining Error

The 2009 errocode means connection refused so it is definitely a wrong ip, wrong username or bad dsn.

odbc.ini must have a [CabalGame24] section and all ip's in it must be the windows one.

I suspect this is a permissions problem at the database end. Have you tried using your sa user and pass instead of cabal/cabal?

Quote:

---

Originally Posted by chumpywumpy

The 2009 errocode means connection refused so it is definitely a wrong ip, wrong username or bad dsn.

odbc.ini must have a [CabalGame24] section and all ip's in it must be the windows one.

I suspect this is a permissions problem at the database end. Have you tried using your sa user and pass instead of cabal/cabal?

---

yes , failed too.


inside network connections i have
IP adress: 10.0.0.1
Mask 255.255.0
Gateway : 10.0.0.138

what i have in ODBC.ini = 10.0.0.1

i dont have any other Vmware or connections in Networks in windows.

Any others who solved this problem?
just tryed everything i know and everything this guys know and nothing :/
someone has a new breakthrough?