Newbie Guide For DBAgent eRrOR

Results 1 to 14 of 14
  1. #1
    Alpha Member christoper is offline
    MemberRank
    Aug 2007 Join Date
    PhP DecoderLocation
    1,560Posts

    Newbie Guide For DBAgent eRrOR

    Code:
    [Mon Oct 20 2008 16:26:48.801974 3055332256]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0' : /usr/lib/libtdsodbc.so.0: cannot open shared object file: No such file or directory
    [Mon Oct 20 2008 16:26:48.803196 3065822112]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0' : /usr/lib/libtdsodbc.so.0: cannot open shared object file: No such file or directory
    [Mon Oct 20 2008 16:26:48.809455 3065822112]: [##ERROR##] DB ERROR(CODE)     : 0
    [Mon Oct 20 2008 16:26:48.809923 3065822112]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Mon Oct 20 2008 16:26:48.809951 3065822112]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Mon Oct 20 2008 16:26:48.809976 3065822112]: [##ERROR##] DB ERROR(STM_TEXT) :
    [Mon Oct 20 2008 16:26:48.810177 3065822112]: [##ERROR##] Database Connect Fail (uid=cabalusser;pwd=tcabal;dsn=CabalGame24;APP=DBAgent_24)
    [Mon Oct 20 2008 16:26:48.810279 3065822112]: [##ERROR##] check 'pDB' fail
    [Mon Oct 20 2008 16:26:48.810308 3065822112]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
    [Mon Oct 20 2008 16:26:48.810337 3065822112]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
    [Mon Oct 20 2008 16:26:48.810955 3055332256]: [##ERROR##] DB ERROR(CODE)     : 0
    [Mon Oct 20 2008 16:26:48.810985 3055332256]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Mon Oct 20 2008 16:26:48.803269 3044842400]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0' : /usr/lib/libtdsodbc.so.0: cannot open shared object file: No such file or directory
    [Mon Oct 20 2008 16:26:48.811208 3044842400]: [##ERROR##] DB ERROR(CODE)     : 0
    [Mon Oct 20 2008 16:26:48.811235 3044842400]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Mon Oct 20 2008 16:26:48.811260 3044842400]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Mon Oct 20 2008 16:26:48.811285 3044842400]: [##ERROR##] DB ERROR(STM_TEXT) :
    [Mon Oct 20 2008 16:26:48.812002 3044842400]: [##ERROR##] Database Connect Fail (uid=cabalusser;pwd=tcabal;dsn=CabalGame24;APP=DBAgent_24)
    [Mon Oct 20 2008 16:26:48.812207 3055332256]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Mon Oct 20 2008 16:26:48.812236 3055332256]: [##ERROR##] DB ERROR(STM_TEXT) :
    [Mon Oct 20 2008 16:26:48.812262 3055332256]: [##ERROR##] Database Connect Fail (uid=cabalusser;pwd=tcabal;dsn=CabalGame24;APP=DBAgent_24)
    [Mon Oct 20 2008 16:26:48.812296 3055332256]: [##ERROR##] check 'pDB' fail
    [Mon Oct 20 2008 16:26:48.812322 3055332256]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Mon Oct 20 2008 16:26:48.812351 3055332256]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Mon Oct 20 2008 16:26:48.812411 3044842400]: [##ERROR##] check 'pDB' fail
    [Mon Oct 20 2008 16:26:48.812915 3044842400]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
    [Mon Oct 20 2008 16:26:48.812945 3044842400]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
    how to fix this ?

    Simple :

    Make Sure You Open the Port in windows firewall or you add it 1433

    and Open Your putty

    and install this :

    Code:
     type : " cd /root "
    
    then : " ls "
    
    then : rpm -Uvh dstat-0.6.3-1.rh9.rf.noarch.rpm
    
    then : rpm -Uvh ncftp-3.1.9-1.i386.rpm
    
    then : rpm -Uvh freetds-unixodbc-0.64RC3-1.i386.rpm
    after install ds again.

    Code:
    then type "ls"
    
    then type "cd /"
    
    then type "yum install openssl* db4
    For Those Newbie If you got like this here is the resolve for you

    thanks for chumpywumpy & cypher


  2. #2
    Account Upgraded | Title Enabled! dordort is offline
    MemberRank
    Nov 2004 Join Date
    IsraelLocation
    635Posts

    Re: Newbie Guide For DBAgent eRrOR

    Nice guide but i must say that im working with a router and i didnt open the port 1433, it is closed. and i checked my DBAgent log file and all the database is "Database Connect success!". It is only important to open the ports between 30000 to 40000 For the CentOS LAN IP.

    Dor. =]

  3. #3
    Account Upgraded | Title Enabled! clever is offline
    MemberRank
    Oct 2007 Join Date
    EXE FileLocation
    574Posts

    Re: Newbie Guide For DBAgent eRrOR

    i think DB error have a different solution, that is depend on what are you doing

  4. #4
    Account Upgraded | Title Enabled! Advocate is offline
    MemberRank
    Jun 2006 Join Date
    Perfect World - Yaoshous the AwakeningLocation
    1,453Posts

    Re: Newbie Guide For DBAgent eRrOR

    k can connect thx but any idea on this?

    [Tue Nov 4 2008 02:58:28.776640 3086224288]: [##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
    [Tue Nov 4 2008 02:58:28.776690 3086224288]: [##ERROR##] DB ERROR(CODE) : 32000
    [Tue Nov 4 2008 02:58:28.776712 3086224288]: [##ERROR##] DB ERROR(VAR_INFO) : Column: 0<UNKNOWN>, datatype in operator <</>>: INT
    [Tue Nov 4 2008 02:58:28.776733 3086224288]: [##ERROR##] DB ERROR(SQLSTATE) :
    [Tue Nov 4 2008 02:58:28.776754 3086224288]: [##ERROR##] DB ERROR(STM_TEXT) : SELECT KINDIDX, SERIALBGN, SERIALEND FROM CABAL_ITEMSERIAL_TABLE WHERE GROUPIDX = ?
    [Tue Nov 4 2008 02:58:28.828017 3044264864]: Database Connect success!
    [Tue Nov 4 2008 02:58:28.828592 3044264864]: [##ERROR##] DB ERROR(MSG) :
    [Tue Nov 4 2008 02:58:28.828620 3044264864]: [##ERROR##] DB ERROR(CODE) : 0
    [Tue Nov 4 2008 02:58:28.828641 3044264864]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Tue Nov 4 2008 02:58:28.828661 3044264864]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
    [Tue Nov 4 2008 02:58:28.828681 3044264864]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Nov 4 2008 02:58:28.862061 3086224288]: Database Connect success!
    [Tue Nov 4 2008 02:58:28.863112 3086224288]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:132)
    [Tue Nov 4 2008 02:58:28.863153 3086224288]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(84:0:132) Addr(127.0.0.1)
    [Tue Nov 4 2008 02:58:28.873523 3044264864]: Database Connect success!
    [Tue Nov 4 2008 02:58:28.873580 3044264864]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Nov 4 2008 02:58:28.873608 3044264864]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Nov 4 2008 02:58:28.957194 3086227136]: 4.close user 12 [8D2CF98] (127.0.0.1)
    [Tue Nov 4 2008 02:58:33.129045 3044264864]: [##ERROR##] DB ERROR(MSG) :
    [Tue Nov 4 2008 02:58:33.129078 3044264864]: [##ERROR##] DB ERROR(CODE) : 0
    [Tue Nov 4 2008 02:58:33.129100 3044264864]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Tue Nov 4 2008 02:58:33.129120 3044264864]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
    [Tue Nov 4 2008 02:58:33.129140 3044264864]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Nov 4 2008 02:58:33.137039 3044264864]: Database Connect success!
    [Tue Nov 4 2008 02:58:33.137080 3044264864]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Nov 4 2008 02:58:33.137131 3044264864]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Nov 4 2008 02:58:33.163041 3075734432]: Database Connect success!
    [Tue Nov 4 2008 02:58:33.185792 3086224288]: [##ERROR##] DB ERROR(MSG) :
    [Tue Nov 4 2008 02:58:33.185829 3086224288]: [##ERROR##] DB ERROR(CODE) : 0
    [Tue Nov 4 2008 02:58:33.185851 3086224288]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Tue Nov 4 2008 02:58:33.185871 3086224288]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
    [Tue Nov 4 2008 02:58:33.185892 3086224288]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Nov 4 2008 02:58:33.192940 3086224288]: Database Connect success!
    [Tue Nov 4 2008 02:58:33.192982 3086224288]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Nov 4 2008 02:58:33.193009 3086224288]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Nov 4 2008 02:58:33.196381 3044264864]: [##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
    [Tue Nov 4 2008 02:58:33.196424 3044264864]: [##ERROR##] DB ERROR(CODE) : 32000
    [Tue Nov 4 2008 02:58:33.196445 3044264864]: [##ERROR##] DB ERROR(VAR_INFO) : Column: 0<UNKNOWN>, datatype in operator <</>>: INT
    [Tue Nov 4 2008 02:58:33.196467 3044264864]: [##ERROR##] DB ERROR(SQLSTATE) :
    [Tue Nov 4 2008 02:58:33.196487 3044264864]: [##ERROR##] DB ERROR(STM_TEXT) : SELECT KINDIDX, SERIALBGN, SERIALEND FROM CABAL_ITEMSERIAL_TABLE WHERE GROUPIDX = ?
    [Tue Nov 4 2008 02:58:33.203793 3044264864]: Database Connect success!
    [Tue Nov 4 2008 02:58:33.203853 3044264864]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:132)
    [Tue Nov 4 2008 02:58:33.203881 3044264864]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(84:0:132) Addr(127.0.0.1)
    [Tue Nov 4 2008 02:58:33.233758 3086227136]: 3.close user 10 [8D14B50] (127.0.0.1)
    [Tue Nov 4 2008 02:58:33.304318 3086227136]: 2.close user 11 [8D20D60] (127.0.0.1)

  5. #5
    Alpha Member christoper is offline
    MemberRank
    Aug 2007 Join Date
    PhP DecoderLocation
    1,560Posts

    Re: Newbie Guide For DBAgent eRrOR

    what did u do? reinstall ur sql and download the db by cham

  6. #6
    Account Upgraded | Title Enabled! xbLazE is offline
    MemberRank
    Jul 2008 Join Date
    SingaporeLocation
    1,278Posts

    Re: Newbie Guide For DBAgent eRrOR

    Nice guideeee !

  7. #7
    Account Upgraded | Title Enabled! Advocate is offline
    MemberRank
    Jun 2006 Join Date
    Perfect World - Yaoshous the AwakeningLocation
    1,453Posts

    Re: Newbie Guide For DBAgent eRrOR

    got everything working fine now just dumb error with communication was all

  8. #8
    Imperium Knight phiber is offline
    MemberRank
    Oct 2008 Join Date
    elitekingdoms.comLocation
    264Posts

    Re: Newbie Guide For DBAgent eRrOR

    you dont need this two:

    then : rpm -Uvh dstat-0.6.3-1.rh9.rf.noarch.rpm
    then : rpm -Uvh ncftp-3.1.9-1.i386.rpm


    the first its a tool to view your system resources usage.
    the second one its a tool to upload to some ftp. :p

  9. #9
    Alpha Member christoper is offline
    MemberRank
    Aug 2007 Join Date
    PhP DecoderLocation
    1,560Posts

    Re: Newbie Guide For DBAgent eRrOR

    then : rpm -Uvh dstat-0.6.3-1.rh9.rf.noarch.rpm
    then : rpm -Uvh ncftp-3.1.9-1.i386.rpm
    Sometimes others centos cant search this if like to me if you install the root.

    the missing is openssl* db4 i cant install it so i do first install them because they not already installed to me.

    but others centos mybe same prob just take advantage.

  10. #10
    Member carlos666 is offline
    MemberRank
    Apr 2005 Join Date
    Santa Cruz de lLocation
    99Posts

    Re: Newbie Guide For DBAgent eRrOR

    [root@localhost /]# yum install openssl* db4
    Setting up Install Process
    Parsing package install arguments
    Package openssl-perl - 0.9.8e-7.el5.i386 is already installed.
    Package openssl097a - 0.9.7a-9.el5_2.1.i386 is already installed.
    Package openssl-devel - 0.9.8e-7.el5.i386 is already installed.
    Package openssl - 0.9.8e-7.el5.i686 is already installed.
    Package db4 - 4.3.29-9.fc6.i386 is already installed.
    Nothing to do


    still continue getting this
    [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
    [Mon Jun 1 2009 17:52:00.008695 3085900688]: [##ERROR##] DB ERROR(CODE) : 20009
    [Mon Jun 1 2009 17:52:00.009084 3085900688]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Mon Jun 1 2009 17:52:00.009182 3085900688]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Mon Jun 1 2009 17:52:00.009263 3085900688]: [##ERROR##] DB ERROR(STM_TEXT) :
    [Mon Jun 1 2009 17:52:00.009679 3085900688]: [##ERROR##] Database Connect Fail (uid=admin;pwd=perereca;dsn=CabalAccount;APP=GlobalDBAgent)
    [Mon Jun 1 2009 17:52:00.036580 3085900688]: [##ERROR##] check 'pDB' fail
    [Mon Jun 1 2009 17:52:00.050237 3085900688]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:96)
    [Mon Jun 1 2009 17:52:00.053553 3085900688]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(60:0:96) Addr(192.168.0.100)

  11. #11
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: Newbie Guide For DBAgent eRrOR

    Look at his error, then look at yours. They are completely different and yours is because the server cannot connect to the database. Check the windows firewall is off and that centos can ping windows. If using sql 2005 express make sure you have installed exactly like the guides as a default install will not work as the configuration is wrong.

  12. #12
    Member carlos666 is offline
    MemberRank
    Apr 2005 Join Date
    Santa Cruz de lLocation
    99Posts

    Re: Newbie Guide For DBAgent eRrOR

    i'm using mssql 2000, can be it my problem?

  13. #13
    The Cat in the Hat cypher is offline
    MemberRank
    Oct 2005 Join Date
    IrelandLocation
    5,073Posts

    Re: Newbie Guide For DBAgent eRrOR

    nope. many people use mssql 2k, well i do use 2k too ^^

  14. #14
    Member carlos666 is offline
    MemberRank
    Apr 2005 Join Date
    Santa Cruz de lLocation
    99Posts

    Re: Newbie Guide For DBAgent eRrOR

    what is x-trap?? can it be a problem for connect?



Advertisement