[HELP] DBAgent_24 Log Error , FreeTDS ?

RafiGinat

RafiGinat

Junior Spellweaver
10 Happy Years
Joined
Apr 25, 2005
Messages
161
Reaction score
3
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)
Click to expand...



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.
 
Sort by date Sort by votes
RafiGinat said:
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.
Click to expand...

Are you sure you have the right database username and password? Check your sql security against your .ini files
 
Upvote 0
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
 
Upvote 0
juris said:
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
Click to expand...


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!
 
Upvote 0
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
 
Upvote 0
RafiGinat said:
in the SQL > Links > gameserver >
DRIVER={SQL Server};SERVER=(LOCAL);UID=cabal;PWD=cabal;
Click to expand...

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.
 
Upvote 0
chumpywumpy said:
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.
Click to expand...

Thanks , but it still the same error.



juris said:
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
Click to expand...

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


But still remaining Error
 
Upvote 0
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?
 
Upvote 0
chumpywumpy said:
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?
Click to expand...

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.
 
Upvote 0
Any others who solved this problem?
just tryed everything i know and everything this guys know and nothing :/
someone has a new breakthrough?
 
Upvote 0
There is no "breakthrough" to be had, there is nothing wrong with the server it is your config somewhere. Nobody can just point and tell you what to do without first doing exactly whay you should be, checking each part of the configuration until you find one that is wrong. We don't know what your config should be so all we can do is point you at things to check.

From the centos machine terminal type "telnet 10.0.0.1 1433", if the screen goes blank then mssql is listening fine and your config (likely user/pass or db permissions) is wrong. If it says connection timed out then either yu have a firewall in the way, screwed networking setup or you are very mistaken about what your ip addresses are.

We can't point you any closer to a solution than you already are. Troubleshooting network connectivity issues is the easiest problem you will face running the server and it is something you need to learn how to do as nobody else can point and go "change that" without pretty much sitting in front of the computer and doing it for you after checking your entire config.
 
Upvote 0
chumpywumpy said:
There is no "breakthrough" to be had, there is nothing wrong with the server it is your config somewhere. Nobody can just point and tell you what to do without first doing exactly whay you should be, checking each part of the configuration until you find one that is wrong. We don't know what your config should be so all we can do is point you at things to check.

From the centos machine terminal type "telnet 10.0.0.1 1433", if the screen goes blank then mssql is listening fine and your config (likely user/pass or db permissions) is wrong. If it says connection timed out then either yu have a firewall in the way, screwed networking setup or you are very mistaken about what your ip addresses are.

We can't point you any closer to a solution than you already are. Troubleshooting network connectivity issues is the easiest problem you will face running the server and it is something you need to learn how to do as nobody else can point and go "change that" without pretty much sitting in front of the computer and doing it for you after checking your entire config.
Click to expand...

Seemed like you pointed the problem.
when i did "telnet 10.0.0.1 1433" in Terminal of centos i get Connection refused.

which means thats the problem right?

can u explain me how to fix it?
i'v tryed like milion combinations but without any success.
i do want to do things my own and try fix my self , most of the times i do.


i Bridged connection at Vmware
no other Connection of vmware in "My Network Connections"
only Local Area Connection
IP adress :10.0.0.1
Subnet mask : 255.0.0.0
Gaterway : 10.0.0.138
No Firewall Enabled

from that info , how do i configure everything so centos will have permission?
thanks!
 
Upvote 0
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is the top forum for MMO, MMORPG, and mobile game development. We provide binaries, source codes, and tutorials for your favorite games, making it the go-to resource for developers and fans. You can also find and share private servers, fostering a vibrant gamer community.

Forum Statistics

Members online
974
Guests online
2,759
Total visitors
3,733
Totals may include hidden visitors.

RaGEZONE Partners

    nongamstopbets.com UK sites not on GamStop Casino Deps NZ
Back