hiya people .
ok i know this one has been asked many times before but and a big but no one has made a proper answer to those that have asked for help.
i have installed the sql 2000 enterprise edition it is fully patched up to sp4
computer is fully patched as well.
i am running vmware workstaion 4.1
i have installed the sql,vmware and centos.
the ip addresses are all set correctly.
the dbs are all installed on sql correctly the ownwership id and password are installed correctly.
i can use the obdc utility to connect to the sql server on pipes and tcp ports 1433 inabled and no dbs in hidden status.
the virt server on vmware is installed correctly and works with no probs, centos is running with no probs.
the server files have been installed correctly and all ip addresses installed.
all ini files have been configured correctly
all dbs run and connect to sql except dbagent_24 this shows the error every one else has been asking about it says that it cant connect to sql db id and pass is unavailable .???
this cannot be true as .
loginsvr and world svr connect with no errors on logs at all they connect to sql with no errors.
i have created 3 accounts i can view logs live as i try and login all 3 accounts register in world server and login logs and get auth to connect no errors given in logs trying to login.
client shows message please try later.
my question is this that i hace spent over a week trying to resolve
how do worldsvr and loginsvr connect but dbagent cannot , how can i resolve the question of dbagent error ip and pass on sql unavailable or dont exist ??.
please no flaming on this about use serch or its already been answered as no one has replied to the many who have asked with a working replie.
regards to all
@ chummpy thanks for the replie here is my ini
[NetLib]
Port=38181
SendMaxBufSize=65536
SendMaxBufSizeUserHandler=131072
SendMaxBufSizeLinkHandler=1048576
ProcessDataLimit=10000
MaxUserNum=2048
WatchsNoPackLimit=100000
SystemLogTTimeOut=100
ReactorTimeOut=-1
LogLevel=4
MemPoolUnitSizeClass=2
[DBAgent]
ServerIdx=1
DBProcessTNum=5
DSN=CabalGame24
[DSN]
DBId=cabal
DBPwd=cabal
DBAppName=DBAgent
my odbc ini is the same as yours. in fact im using the files downloaded from you and the only alterations i done was via gen_config2.sh.
as you now see my ini is at the same settings as you only now i get a server missmatch ( 24,1)
putting ini back to the default gives this.
[Tue Sep 9 2008 21:01:44.630562 3076189088]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Tue Sep 9 2008 21:01:44.630662 3076189088]: [##ERROR##] DB ERROR(CODE) : 20009
[Tue Sep 9 2008 21:01:44.630960 3076189088]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Sep 9 2008 21:01:44.630983 3076189088]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Tue Sep 9 2008 21:01:44.631005 3076189088]: [##ERROR##] DB ERROR(STM_TEXT) :
[Tue Sep 9 2008 21:01:44.631029 3076189088]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=cabal;dsn=CabalGame24;APP=DBAgent_24)
[Tue Sep 9 2008 21:01:44.631055 3076189088]: [##ERROR##] check 'pDB' fail
[Tue Sep 9 2008 21:01:44.631076 3076189088]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Tue Sep 9 2008 21:01:44.631100 3076189088]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Tue Sep 9 2008 21:01:44.631572 3076189088]: process command: 600
it is the only log that shows an error.
the other 2 connect to the sql with the id and pass connect with no problems or errors showing.
Reply With Quote
