Most visitors online was 11410 , on 26 Apr 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!where is that terminal adduser??
please specify me the exact location sir.
thank you very much
adduser cabal
i already did.. but still appears... root@localhost.. how to change it?
to change the name just type:
example : hostname ragezone
i also receive new error... but it appears also the root@localhost
cd /
yum install unixODBC*
yum install openssl097a db4
cd /root
rpm -Uvh libmng-1.0.8-1.i386.rpm
[Tue Dec 30 2008 22:56:07.503961 3086632640]: open log file '/var/log/cabal/DBAgent_01.log'
[Tue Dec 30 2008 22:56:07.504512 3086632640]: LOG LEVEL: 3
[Tue Dec 30 2008 22:56:07.504683 3086632640]: MemPoolUnitSizeClass(2): 24576Bytes
[Tue Dec 30 2008 22:56:07.509594 3086632640]: Start DBAgent_01 Server
[Tue Dec 30 2008 22:56:07.512129 3086632640]: UseEcryptText (Off)
[Tue Dec 30 2008 22:56:07.514539 3086632640]: try listening 38181 port
[Tue Dec 30 2008 22:56:07.516625 3065650080]: CProcessLayer(0)::svc Start [3065650080]
[Tue Dec 30 2008 22:56:07.516870 3044670368]: CProcessLayer(0)::svc Start [3044670368]
[Tue Dec 30 2008 22:56:07.517534 3086629792]: CProcessLayer(0)::svc Start [3086629792]
[Tue Dec 30 2008 22:56:07.517869 3055160224]: CProcessLayer(0)::svc Start [3055160224]
[Tue Dec 30 2008 22:56:07.517869 3076139936]: CProcessLayer(0)::svc Start [3076139936]
[Tue Dec 30 2008 22:56:08.119330 3086632640]: accept success 8(192.168.1.5:32770)
[Tue Dec 30 2008 22:56:08.126537 3086632640]: 1.open user 8 [83AD180] (192.168.1.5)
[Tue Dec 30 2008 22:56:08.848602 3086632640]: accept success 10(192.168.1.5:32772)
[Tue Dec 30 2008 22:56:08.849207 3086632640]: 2.open user 10 [83B5848] (192.168.1.5)
[Tue Dec 30 2008 22:56:47.206544 3086629792]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Tue Dec 30 2008 22:56:47.206717 3086629792]: [##ERROR##] DB ERROR(CODE) : 20009
[Tue Dec 30 2008 22:56:47.206783 3086629792]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Dec 30 2008 22:56:47.206714 3076139936]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Tue Dec 30 2008 22:56:47.206857 3086629792]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Tue Dec 30 2008 22:56:47.207304 3086629792]: [##ERROR##] DB ERROR(STM_TEXT) :
[Tue Dec 30 2008 22:56:47.207370 3086629792]: [##ERROR##] Database Connect Fail (uid=XX;pwd=XXXXXXXX;dsn=CabalGame01;APP=DBAgent_01)
[Tue Dec 30 2008 22:56:47.207594 3086629792]: [##ERROR##] check 'pDB' fail
[Tue Dec 30 2008 22:56:47.207658 3086629792]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Tue Dec 30 2008 22:56:47.207726 3086629792]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(192.168.1.5)
[Tue Dec 30 2008 22:56:47.206942 3065650080]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Tue Dec 30 2008 22:56:47.207188 3076139936]: [##ERROR##] DB ERROR(CODE) : 20009
[Tue Dec 30 2008 22:56:47.208059 3065650080]: [##ERROR##] DB ERROR(CODE) : 20009
[Tue Dec 30 2008 22:56:47.208175 3076139936]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Dec 30 2008 22:56:47.208308 3065650080]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Dec 30 2008 22:56:47.208427 3076139936]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Tue Dec 30 2008 22:56:47.208527 3065650080]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Tue Dec 30 2008 22:56:47.208668 3076139936]: [##ERROR##] DB ERROR(STM_TEXT) :
[Tue Dec 30 2008 22:56:47.208764 3065650080]: [##ERROR##] DB ERROR(STM_TEXT) :
It shows root@ because you are logging into the server as root via putty. The cabal user is used by the server not you.i already did.. but still appears... root@localhost.. how to change it?
i also receive new error... but it appears also the root@localhost
Hi Chympy
I have problem with AgentDB_01
This is from my AgentDB log
Code:[Tue Dec 30 2008 22:56:07.503961 3086632640]: open log file '/var/log/cabal/DBAgent_01.log' [Tue Dec 30 2008 22:56:07.504512 3086632640]: LOG LEVEL: 3 [Tue Dec 30 2008 22:56:07.504683 3086632640]: MemPoolUnitSizeClass(2): 24576Bytes [Tue Dec 30 2008 22:56:07.509594 3086632640]: Start DBAgent_01 Server [Tue Dec 30 2008 22:56:07.512129 3086632640]: UseEcryptText (Off) [Tue Dec 30 2008 22:56:07.514539 3086632640]: try listening 38181 port [Tue Dec 30 2008 22:56:07.516625 3065650080]: CProcessLayer(0)::svc Start [3065650080] [Tue Dec 30 2008 22:56:07.516870 3044670368]: CProcessLayer(0)::svc Start [3044670368] [Tue Dec 30 2008 22:56:07.517534 3086629792]: CProcessLayer(0)::svc Start [3086629792] [Tue Dec 30 2008 22:56:07.517869 3055160224]: CProcessLayer(0)::svc Start [3055160224] [Tue Dec 30 2008 22:56:07.517869 3076139936]: CProcessLayer(0)::svc Start [3076139936] [Tue Dec 30 2008 22:56:08.119330 3086632640]: accept success 8(192.168.1.5:32770) [Tue Dec 30 2008 22:56:08.126537 3086632640]: 1.open user 8 [83AD180] (192.168.1.5) [Tue Dec 30 2008 22:56:08.848602 3086632640]: accept success 10(192.168.1.5:32772) [Tue Dec 30 2008 22:56:08.849207 3086632640]: 2.open user 10 [83B5848] (192.168.1.5) [Tue Dec 30 2008 22:56:47.206544 3086629792]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Tue Dec 30 2008 22:56:47.206717 3086629792]: [##ERROR##] DB ERROR(CODE) : 20009 [Tue Dec 30 2008 22:56:47.206783 3086629792]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Dec 30 2008 22:56:47.206714 3076139936]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Tue Dec 30 2008 22:56:47.206857 3086629792]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Dec 30 2008 22:56:47.207304 3086629792]: [##ERROR##] DB ERROR(STM_TEXT) : [Tue Dec 30 2008 22:56:47.207370 3086629792]: [##ERROR##] Database Connect Fail (uid=XX;pwd=XXXXXXXX;dsn=CabalGame01;APP=DBAgent_01) [Tue Dec 30 2008 22:56:47.207594 3086629792]: [##ERROR##] check 'pDB' fail [Tue Dec 30 2008 22:56:47.207658 3086629792]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Tue Dec 30 2008 22:56:47.207726 3086629792]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(192.168.1.5) [Tue Dec 30 2008 22:56:47.206942 3065650080]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Tue Dec 30 2008 22:56:47.207188 3076139936]: [##ERROR##] DB ERROR(CODE) : 20009 [Tue Dec 30 2008 22:56:47.208059 3065650080]: [##ERROR##] DB ERROR(CODE) : 20009 [Tue Dec 30 2008 22:56:47.208175 3076139936]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Dec 30 2008 22:56:47.208308 3065650080]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Dec 30 2008 22:56:47.208427 3076139936]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Dec 30 2008 22:56:47.208527 3065650080]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Dec 30 2008 22:56:47.208668 3076139936]: [##ERROR##] DB ERROR(STM_TEXT) : [Tue Dec 30 2008 22:56:47.208764 3065650080]: [##ERROR##] DB ERROR(STM_TEXT) :
my user and password in sql are RIGHTS !
Other log Files are OK without error, just this dbagent_01
Any ideas how to fix ??
sql 2k is fine, so can you ping the sql to centos? does it work? Next question, did you setup your odbc.ini?
yes i have <1 ping from windows to centos and centos to windows ..
any idea :S
i try with GM Tools 51a and 61a but i cant connect.. my firewall is OFF.. i dont know what the f**k is going on help pleaseeeeeeeeeee ((
I think the problem is in SQL 2000 ?
If the gm tools cannot connect to sql on the local machine then it is sql. If you load query analyser can you log into that? If so what is in the "SQL Server" box and do you enter a username/pass?