FreeTDS

Page 1 of 3 123 LastLast
Results 1 to 25 of 54
  1. #1
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    FreeTDS

    Ok i gotz a question:
    I installed everything fine.
    than i gotz 1 error about the unixODBC.
    He cant find libtdsodbc.so.0 at usr/lib.
    i saw on this forum i had to install FreeTDS.
    So i installed freeTDS.
    But he still cant find libtdsodbc.so.0 at usr/lib.
    i checked usr/lib but there isnt a libtdsodbc.so.0
    So my question is: What do i have to do now :)
    Right now i cant get in my winscp idk why 5 mins ago i could get in.
    so i cant upload any log files :(
    or i can find the log files somewhere else than i can.

    EDIT: gotz another error like 1 hour ago i could ping my windows to centos and centos to windows but now none off them pings.

    EDIT: i can ping again to both off them but still i have no idea have to install FreeTDS

    EDIT: Logfile ADDED

    Greetz iSpooky

    Code:
    [Sun Sep 19 2010 23:16:47.733949 4160161488]: open log file  '/var/log/cabal/DBAgent_24.log'
    [Sun Sep 19 2010 23:16:47.734051 4160161488]: LOG LEVEL: 3
    [Sun Sep 19 2010 23:16:47.734071 4160161488]: MemPoolUnitSizeClass(2): 24576Bytes
    [Sun Sep 19 2010 23:16:47.734501 4160161488]: Start DBAgent_24 Server
    [Sun Sep 19 2010 23:16:47.734929 4160161488]: UseEcryptText (Off)
    [Sun Sep 19 2010 23:16:47.739974 4160161488]: try listening 53424 port
    [Sun Sep 19 2010 23:16:47.740144 4160158608]: CProcessLayer(0)::svc Start [4160158608]
    [Sun Sep 19 2010 23:16:47.740203 4149668752]: CProcessLayer(0)::svc Start [4149668752]
    [Sun Sep 19 2010 23:16:47.740260 4139178896]: CProcessLayer(0)::svc Start [4139178896]
    [Sun Sep 19 2010 23:16:47.740312 4128689040]: CProcessLayer(0)::svc Start [4128689040]
    [Sun Sep 19 2010 23:16:47.740391 4118199184]: CProcessLayer(0)::svc Start [4118199184]
    [Sun Sep 19 2010 23:16:48.436845 4160161488]: accept success 8(127.0.0.1:60453)
    [Sun Sep 19 2010 23:16:48.437837 4160161488]: 1.open user 8 [9864F90] (127.0.0.1)
    [Sun Sep 19 2010 23:16:49.002529 4160161488]: accept success 10(127.0.0.1:60455)
    [Sun Sep 19 2010 23:16:49.002643 4160161488]: 2.open user 10 [98736B0] (127.0.0.1)
    [Sun Sep 19 2010 23:18:26.189595 4149668752]: [##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
    [Sun Sep 19 2010 23:18:26.189877 4139178896]: [##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
    [Sun Sep 19 2010 23:18:28.640041 4139178896]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:18:28.640347 4139178896]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:18:28.640362 4139178896]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:18:28.640374 4139178896]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:18:28.640386 4139178896]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:18:28.220457 4128689040]: [##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
    [Sun Sep 19 2010 23:18:28.641692 4128689040]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:18:28.641720 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:18:28.641731 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:18:28.641743 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:18:28.641754 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=*******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:18:28.228112 4118199184]: [##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
    [Sun Sep 19 2010 23:18:28.641788 4118199184]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:18:28.641802 4118199184]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:18:28.641813 4118199184]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:18:28.641824 4118199184]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:18:28.641835 4118199184]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:18:28.641860 4118199184]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:18:28.641872 4118199184]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:18:28.642193 4149668752]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:18:28.642208 4149668752]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:18:28.642219 4149668752]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:18:28.642231 4149668752]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:18:28.642242 4149668752]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:18:28.854290 4128689040]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:18:28.909400 4128689040]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
    [Sun Sep 19 2010 23:18:28.854379 4139178896]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:18:28.909889 4139178896]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
    [Sun Sep 19 2010 23:18:28.910303 4149668752]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:18:28.910319 4149668752]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:18:28.642141 4118199184]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:18:28.909860 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:18:28.910333 4149668752]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:18:29.179489 4139178896]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:19:54.661768 4139178896]: [##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
    [Sun Sep 19 2010 23:19:56.827729 4139178896]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:19:56.827811 4139178896]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:19:56.827824 4139178896]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:19:56.827836 4139178896]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:19:56.827848 4139178896]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:19:57.130918 4139178896]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:19:57.131022 4139178896]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:19:57.416981 4139178896]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:20:36.079163 4128689040]: [##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
    [Sun Sep 19 2010 23:20:37.350095 4128689040]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:20:37.350200 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:20:37.350214 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:20:37.350225 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:20:37.350241 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:20:37.847682 4128689040]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:20:37.847749 4128689040]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:20:38.445839 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:21:01.982482 4128689040]: [##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
    [Sun Sep 19 2010 23:21:02.289089 4128689040]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:21:02.289164 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:21:02.289177 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:21:02.289188 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:21:02.289203 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:21:02.289258 4128689040]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:21:02.289273 4128689040]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:21:02.437166 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:21:49.027011 4128689040]: [##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
    [Sun Sep 19 2010 23:21:49.031670 4128689040]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:21:49.031706 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:21:49.031719 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:21:49.031731 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:21:49.031742 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:21:49.031763 4128689040]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:21:49.031776 4128689040]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:21:49.031793 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:22:49.017061 4128689040]: [##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
    [Sun Sep 19 2010 23:22:49.017115 4128689040]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:22:49.017128 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:22:49.017140 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:22:49.017151 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:22:49.017163 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:22:49.017176 4128689040]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:22:49.017188 4128689040]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:22:49.017202 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:23:49.110950 4160158608]: [##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
    [Sun Sep 19 2010 23:23:49.111076 4160158608]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:23:49.111090 4160158608]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:23:49.111101 4160158608]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:23:49.111113 4160158608]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:23:49.111124 4160158608]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:23:49.111139 4160158608]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:23:49.111150 4160158608]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:23:49.111164 4160158608]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:24:49.085185 4118199184]: [##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
    [Sun Sep 19 2010 23:24:49.086550 4118199184]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:24:49.086572 4118199184]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:24:49.086584 4118199184]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:24:49.086596 4118199184]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:24:49.086607 4118199184]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:24:49.086622 4118199184]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:24:49.086634 4118199184]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:24:49.086648 4118199184]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    [Sun Sep 19 2010 23:25:49.049567 4149668752]: [##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
    [Sun Sep 19 2010 23:25:49.049652 4149668752]: [##ERROR##] DB ERROR(CODE)     : 0
    [Sun Sep 19 2010 23:25:49.049837 4149668752]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Sun Sep 19 2010 23:25:49.049852 4149668752]: [##ERROR##] DB ERROR(SQLSTATE) : 01000
    [Sun Sep 19 2010 23:25:49.049864 4149668752]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Sun Sep 19 2010 23:25:49.049875 4149668752]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24)
    [Sun Sep 19 2010 23:25:49.049889 4149668752]: [##ERROR##] check 'pDB' fail
    [Sun Sep 19 2010 23:25:49.049900 4149668752]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
    [Sun Sep 19 2010 23:25:49.049914 4149668752]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
    Last edited by iSpooky; 19-09-10 at 11:21 PM.


  2. #2
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    *Buuuuuuuuump*

  3. #3
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,517Posts

    Re: FreeTDS

    1. Please don't double-post.
    2. Please don't bump your own threads.
    3. Always use Google before posting here. The answer to your problem can be found there.

  4. #4
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    1. sorry
    2. sorry
    3. i use google already for like 40 billion time without any succes they all say the same stuff and it dont work.

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

    Re: FreeTDS

    Are you using centos 4 or 5? Does the file exist?

    If using centos 4 the following commands should cure it:

    rpm -Uvh /root/unixODBC-2.2.11-1.RHEL4.1.i386.rpm
    rpm -Uvh /root/unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
    rpm -Uvh /root/unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm

    For centos 5 use:

    yum install unixODBC
    yum install unixODBC-devel
    yum install unixODBC-kde

    I suspect you are trying to install the wrong version of the libs by selecting the wrong mode when installing. If in doubt use the centos 5 method above and it should install the correct version.

    As for bumping the general rule at RZ is 2 weeks but if it has left the 1st page and has not been answered then i would let that go. If it's on the first page and has not yet been answered it means i haven't been here yet since it was posted ;)

  6. #6
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    The file doesnt exist
    im useing centos 5
    and when i use those commands i get the message that they are already installed and the lastest version for all 3 off them.
    And sorry about bumping my thread :(

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

    Re: FreeTDS

    Weird, that is where mine are. Run a search on the files and then edit /etc/odbcinst.ini to correct the paths to the files.

  8. #8
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    Oki i found that file
    and chanced it to the right directory but now i get the error
    [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libtdsodbc.so.0' : /usr/lib64/libtdsodbc.so.0: wrong ELF class: ELFCLASS64

    if you need whole my log tell me :)

    i hope you can help me
    Thanks in advance :)

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

    Re: FreeTDS

    Ah this explains it. I take it you are running 64-bit Centos? I have never tested this and it looks like parts of my repack are not compatible with 64-bit, though i'm sure i have seen posts where people have done this. At a guess i would say you will need to find the 64-bit versions of the following:

    rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
    rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
    rpm -Uvh unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
    rpm -Uvh freetds-unixodbc-0.64RC3-1.i386.rpm

    Go to Index of /centos.org (or another local Centos mirror) and into the folder for the centos 5.x version you have. Go into os/SRPMS/ and grab the files, then use:

    rpm -Uvh <rpm name>

    I will have to test this and modify cabal_install.sh to support 64-bit. I'm grabbing the ISO now.

  10. #10
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    Hmm i was seeking for:
    unixODBC-2.2.11-1.RHEL4.1.i386.rpm
    unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
    unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
    freetds-unixodbc-0.64RC3-1.i386.rpm
    at the link you gaved me
    But those files arent there

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

    Re: FreeTDS

    The names will be slightly diferent as they won't have RHEL4.i386 at the end.

    Hang on for a bit as i will be testing with Centos 5.5 x64 in a few minutes.

  12. #12
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    Tell me if you have any succes :)

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

    Re: FreeTDS

    My last answer was stupid, of course the 64-bit installer YUMs the right files. I don't even know why i suggested that but i'm definitely rusty after my little vacation :/

    The server is compiled against 32-bit odbc and it doesn't like the 64-bit version at all. I have been trying to force-compile a 32-bit version on an x64 centos and it isn't working out. I have a few more things to try but the easiest fix is probably to use a 32-bit centos install until i figure it out as my install scripts are definitely going to need changing for 64-bit support.

    You can get away with just centos CD1 when installing 32-bit. When installing and it asks about packages to install select "customize now" and un-tick everything in every section except the "base" package (that says it is good for routers). After the centos installation run cabal_install normally, say you are NOT upgrading a server and NOT installing on centos 4 and it will download everything it needs. That will get you working for now as i don't think this is going to be an easy problem to solve.

  14. #14
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    Ok so i just have to install a centos 32 bit? i can do that on the 64 bit so it overwrite or do i have to make another VM ?

    Greets iSpooky

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

    Re: FreeTDS

    I would make another VM, or boot the centos CD and overwrite that way. 32-bit will work fine on a 64-bit machine/windows as i have Win7 x64 and all but 1 of my VMs are 32-bit.

  16. #16
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    Ok i installed the 32 bit the error is gone but i gained a new error
    Code:
    [Tue Sep 28 2010 15:47:48.751606 3086825168]: open log file  '/var/log/cabal/DBAgent_24.log'
    [Tue Sep 28 2010 15:47:48.751719 3086825168]: LOG LEVEL: 3
    [Tue Sep 28 2010 15:47:48.751745 3086825168]: MemPoolUnitSizeClass(2): 24576Bytes
    [Tue Sep 28 2010 15:47:48.752323 3086825168]: Start DBAgent_24 Server
    [Tue Sep 28 2010 15:47:48.752743 3086825168]: UseEcryptText (Off)
    [Tue Sep 28 2010 15:47:48.753154 3086825168]: try listening 53424 port
    [Tue Sep 28 2010 15:47:48.865961 3086822288]: CProcessLayer(0)::svc Start [3086822288]
    [Tue Sep 28 2010 15:47:48.866044 3076332432]: CProcessLayer(0)::svc Start [3076332432]
    [Tue Sep 28 2010 15:47:48.866121 3065842576]: CProcessLayer(0)::svc Start [3065842576]
    [Tue Sep 28 2010 15:47:48.866191 3055352720]: CProcessLayer(0)::svc Start [3055352720]
    [Tue Sep 28 2010 15:47:48.866257 3044862864]: CProcessLayer(0)::svc Start [3044862864]
    [Tue Sep 28 2010 15:47:48.876270 3086825168]: accept success 8(127.0.0.1:44268)
    [Tue Sep 28 2010 15:47:48.902139 3086825168]: 1.open user 8 [935EF80] (127.0.0.1)
    [Tue Sep 28 2010 15:47:48.953137 3086825168]: accept success 10(127.0.0.1:44270)
    [Tue Sep 28 2010 15:47:48.953220 3086825168]: 2.open user 10 [936D678] (127.0.0.1)
    [Tue Sep 28 2010 15:48:38.120554 3044862864]: Database Connect success!
    [Tue Sep 28 2010 15:48:38.121552 3086822288]: Database Connect success!
    [Tue Sep 28 2010 15:48:38.127108 3055352720]: Database Connect success!
    [Tue Sep 28 2010 15:50:12.453646 3086822288]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Read from SQL server failed.
    [Tue Sep 28 2010 15:50:12.453898 3086822288]: [##ERROR##] DB ERROR(CODE)     : 20004
    [Tue Sep 28 2010 15:50:12.453916 3086822288]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 15:50:12.453931 3086822288]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Sep 28 2010 15:50:12.453945 3086822288]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Sep 28 2010 15:50:12.473889 3086822288]: Database Connect success!
    [Tue Sep 28 2010 15:50:12.473940 3086822288]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Sep 28 2010 15:50:12.473990 3086822288]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Sep 28 2010 15:50:48.961373 3055352720]: [##ERROR##] DB ERROR(MSG)      : 
    [Tue Sep 28 2010 15:50:48.962056 3055352720]: [##ERROR##] DB ERROR(CODE)     : 0
    [Tue Sep 28 2010 15:50:48.962073 3055352720]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 15:50:48.962088 3055352720]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
    [Tue Sep 28 2010 15:50:48.962102 3055352720]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Sep 28 2010 15:50:48.979277 3055352720]: Database Connect success!
    [Tue Sep 28 2010 15:50:48.979327 3055352720]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Sep 28 2010 15:50:48.979349 3055352720]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Sep 28 2010 15:52:48.960052 3044862864]: [##ERROR##] DB ERROR(MSG)      : 
    [Tue Sep 28 2010 15:52:48.960744 3044862864]: [##ERROR##] DB ERROR(CODE)     : 0
    [Tue Sep 28 2010 15:52:48.960762 3044862864]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 15:52:48.960777 3044862864]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
    [Tue Sep 28 2010 15:52:48.960792 3044862864]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Sep 28 2010 15:52:48.976603 3044862864]: Database Connect success!
    [Tue Sep 28 2010 15:52:48.976730 3044862864]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Sep 28 2010 15:52:48.976753 3044862864]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Sep 28 2010 15:53:49.007049 3076332432]: Database Connect success!
    [Tue Sep 28 2010 15:55:48.978381 3065842576]: Database Connect success!

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

    Re: FreeTDS

    Ah, that one you can ignore. At this stage you have empty databases and no war results for the server to read which is why there is an error. There is plenty of "Database Connect success!" which means it is now getting through.

    All you need to do is run a TG channel once and that error will go away.

  18. #18
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    i get this error now
    DBagent_24
    Code:
    [Tue Sep 28 2010 16:36:48.309046 3086747344]: open log file  '/var/log/cabal/DBAgent_24.log'
    [Tue Sep 28 2010 16:36:48.309251 3086747344]: LOG LEVEL: 3
    [Tue Sep 28 2010 16:36:48.309278 3086747344]: MemPoolUnitSizeClass(2): 24576Bytes
    [Tue Sep 28 2010 16:36:48.309971 3086747344]: Start DBAgent_24 Server
    [Tue Sep 28 2010 16:36:48.310538 3086747344]: UseEcryptText (Off)
    [Tue Sep 28 2010 16:36:48.416511 3086744464]: CProcessLayer(0)::svc Start [3086744464]
    [Tue Sep 28 2010 16:36:48.416600 3076254608]: CProcessLayer(0)::svc Start [3076254608]
    [Tue Sep 28 2010 16:36:48.422271 3086747344]: try listening 53424 port
    [Tue Sep 28 2010 16:36:48.422709 3065764752]: CProcessLayer(0)::svc Start [3065764752]
    [Tue Sep 28 2010 16:36:48.422767 3055274896]: CProcessLayer(0)::svc Start [3055274896]
    [Tue Sep 28 2010 16:36:48.422888 3044785040]: CProcessLayer(0)::svc Start [3044785040]
    [Tue Sep 28 2010 16:36:48.745387 3086747344]: accept success 8(127.0.0.1:36187)
    [Tue Sep 28 2010 16:36:48.746077 3086747344]: 1.open user 8 [927FF78] (127.0.0.1)
    [Tue Sep 28 2010 16:36:49.055267 3086747344]: accept success 10(127.0.0.1:36189)
    [Tue Sep 28 2010 16:36:49.055753 3086747344]: 2.open user 10 [928E6A0] (127.0.0.1)
    [Tue Sep 28 2010 16:37:37.669832 3044785040]: Database Connect success!
    [Tue Sep 28 2010 16:37:37.699774 3076254608]: Database Connect success!
    [Tue Sep 28 2010 16:37:37.706141 3086744464]: Database Connect success!
    [Tue Sep 28 2010 16:37:46.315274 3086744464]: sock 10=> sendBuf is growed (size:32768). len(657), 17000, 131072
    [Tue Sep 28 2010 16:40:09.281235 3076254608]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Read from SQL server failed.
    [Tue Sep 28 2010 16:40:09.281402 3076254608]: [##ERROR##] DB ERROR(CODE)     : 20004
    [Tue Sep 28 2010 16:40:09.281420 3076254608]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:40:09.281434 3076254608]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Sep 28 2010 16:40:09.281448 3076254608]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Sep 28 2010 16:40:12.800529 3076254608]: Database Connect success!
    [Tue Sep 28 2010 16:40:12.800570 3076254608]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Sep 28 2010 16:40:12.800614 3076254608]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Sep 28 2010 16:40:49.105257 3065764752]: Database Connect success!
    [Tue Sep 28 2010 16:46:49.098881 3055274896]: Database Connect success!
    [Tue Sep 28 2010 16:48:08.945958 3055274896]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Read from SQL server failed.
    [Tue Sep 28 2010 16:48:08.946046 3055274896]: [##ERROR##] DB ERROR(CODE)     : 20004
    [Tue Sep 28 2010 16:48:08.946062 3055274896]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:48:08.946076 3055274896]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Sep 28 2010 16:48:08.946089 3055274896]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Sep 28 2010 16:48:11.972408 3055274896]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
    [Tue Sep 28 2010 16:48:11.973054 3055274896]: [##ERROR##] DB ERROR(CODE)     : 20009
    [Tue Sep 28 2010 16:48:11.973070 3055274896]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:48:11.973084 3055274896]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Sep 28 2010 16:48:11.973097 3055274896]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Tue Sep 28 2010 16:48:11.973111 3055274896]: [##ERROR##] Database Connect Fail (uid=sa;pwd=*****;dsn=CabalGame;APP=DBAgent_24)
    [Tue Sep 28 2010 16:48:11.973127 3055274896]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Sep 28 2010 16:48:11.973295 3055274896]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Sep 28 2010 16:48:49.056743 3086744464]: [##ERROR##] DB ERROR(MSG)      : 
    [Tue Sep 28 2010 16:48:49.057146 3086744464]: [##ERROR##] DB ERROR(CODE)     : 0
    [Tue Sep 28 2010 16:48:49.057162 3086744464]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:48:49.057208 3086744464]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
    [Tue Sep 28 2010 16:48:49.057223 3086744464]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Sep 28 2010 16:48:52.071146 3086744464]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
    [Tue Sep 28 2010 16:48:52.071388 3086744464]: [##ERROR##] DB ERROR(CODE)     : 20009
    [Tue Sep 28 2010 16:48:52.071403 3086744464]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:48:52.071417 3086744464]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Sep 28 2010 16:48:52.071431 3086744464]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Tue Sep 28 2010 16:48:52.071445 3086744464]: [##ERROR##] Database Connect Fail (uid=sa;pwd=*****;dsn=CabalGame;APP=DBAgent_24)
    [Tue Sep 28 2010 16:48:52.071460 3086744464]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Sep 28 2010 16:48:52.071477 3086744464]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    Last edited by iSpooky; 29-09-10 at 10:34 PM.

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

    Re: FreeTDS

    Post a full set of logs and that will tell me why. Usually it's a mis-configuration somewhere but the first place to check is the loginsvr log to see if it has your connection attempts listed. From there it is usually down to the gamesevrer IP set in cabal_config not matching internal.txt or port forwarding problems.

  20. #20
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    this the only error i get right now.
    DBagent_24
    Code:
    [Tue Sep 28 2010 16:36:48.309046 3086747344]: open log file  '/var/log/cabal/DBAgent_24.log'
    [Tue Sep 28 2010 16:36:48.309251 3086747344]: LOG LEVEL: 3
    [Tue Sep 28 2010 16:36:48.309278 3086747344]: MemPoolUnitSizeClass(2): 24576Bytes
    [Tue Sep 28 2010 16:36:48.309971 3086747344]: Start DBAgent_24 Server
    [Tue Sep 28 2010 16:36:48.310538 3086747344]: UseEcryptText (Off)
    [Tue Sep 28 2010 16:36:48.416511 3086744464]: CProcessLayer(0)::svc Start [3086744464]
    [Tue Sep 28 2010 16:36:48.416600 3076254608]: CProcessLayer(0)::svc Start [3076254608]
    [Tue Sep 28 2010 16:36:48.422271 3086747344]: try listening 53424 port
    [Tue Sep 28 2010 16:36:48.422709 3065764752]: CProcessLayer(0)::svc Start [3065764752]
    [Tue Sep 28 2010 16:36:48.422767 3055274896]: CProcessLayer(0)::svc Start [3055274896]
    [Tue Sep 28 2010 16:36:48.422888 3044785040]: CProcessLayer(0)::svc Start [3044785040]
    [Tue Sep 28 2010 16:36:48.745387 3086747344]: accept success 8(127.0.0.1:36187)
    [Tue Sep 28 2010 16:36:48.746077 3086747344]: 1.open user 8 [927FF78] (127.0.0.1)
    [Tue Sep 28 2010 16:36:49.055267 3086747344]: accept success 10(127.0.0.1:36189)
    [Tue Sep 28 2010 16:36:49.055753 3086747344]: 2.open user 10 [928E6A0] (127.0.0.1)
    [Tue Sep 28 2010 16:37:37.669832 3044785040]: Database Connect success!
    [Tue Sep 28 2010 16:37:37.699774 3076254608]: Database Connect success!
    [Tue Sep 28 2010 16:37:37.706141 3086744464]: Database Connect success!
    [Tue Sep 28 2010 16:37:46.315274 3086744464]: sock 10=> sendBuf is growed (size:32768). len(657), 17000, 131072
    [Tue Sep 28 2010 16:40:09.281235 3076254608]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Read from SQL server failed.
    [Tue Sep 28 2010 16:40:09.281402 3076254608]: [##ERROR##] DB ERROR(CODE)     : 20004
    [Tue Sep 28 2010 16:40:09.281420 3076254608]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:40:09.281434 3076254608]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Sep 28 2010 16:40:09.281448 3076254608]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Sep 28 2010 16:40:12.800529 3076254608]: Database Connect success!
    [Tue Sep 28 2010 16:40:12.800570 3076254608]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Sep 28 2010 16:40:12.800614 3076254608]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Sep 28 2010 16:40:49.105257 3065764752]: Database Connect success!
    [Tue Sep 28 2010 16:46:49.098881 3055274896]: Database Connect success!
    [Tue Sep 28 2010 16:48:08.945958 3055274896]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Read from SQL server failed.
    [Tue Sep 28 2010 16:48:08.946046 3055274896]: [##ERROR##] DB ERROR(CODE)     : 20004
    [Tue Sep 28 2010 16:48:08.946062 3055274896]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:48:08.946076 3055274896]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Sep 28 2010 16:48:08.946089 3055274896]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Sep 28 2010 16:48:11.972408 3055274896]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
    [Tue Sep 28 2010 16:48:11.973054 3055274896]: [##ERROR##] DB ERROR(CODE)     : 20009
    [Tue Sep 28 2010 16:48:11.973070 3055274896]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:48:11.973084 3055274896]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Sep 28 2010 16:48:11.973097 3055274896]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Tue Sep 28 2010 16:48:11.973111 3055274896]: [##ERROR##] Database Connect Fail (uid=sa;pwd=*****;dsn=CabalGame;APP=DBAgent_24)
    [Tue Sep 28 2010 16:48:11.973127 3055274896]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Sep 28 2010 16:48:11.973295 3055274896]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    [Tue Sep 28 2010 16:48:49.056743 3086744464]: [##ERROR##] DB ERROR(MSG)      : 
    [Tue Sep 28 2010 16:48:49.057146 3086744464]: [##ERROR##] DB ERROR(CODE)     : 0
    [Tue Sep 28 2010 16:48:49.057162 3086744464]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:48:49.057208 3086744464]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
    [Tue Sep 28 2010 16:48:49.057223 3086744464]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
    [Tue Sep 28 2010 16:48:52.071146 3086744464]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
    [Tue Sep 28 2010 16:48:52.071388 3086744464]: [##ERROR##] DB ERROR(CODE)     : 20009
    [Tue Sep 28 2010 16:48:52.071403 3086744464]: [##ERROR##] DB ERROR(VAR_INFO) : 
    [Tue Sep 28 2010 16:48:52.071417 3086744464]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
    [Tue Sep 28 2010 16:48:52.071431 3086744464]: [##ERROR##] DB ERROR(STM_TEXT) : 
    [Tue Sep 28 2010 16:48:52.071445 3086744464]: [##ERROR##] Database Connect Fail (uid=sa;pwd=*****;dsn=CabalGame;APP=DBAgent_24)
    [Tue Sep 28 2010 16:48:52.071460 3086744464]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
    [Tue Sep 28 2010 16:48:52.071477 3086744464]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
    Last edited by iSpooky; 29-09-10 at 10:35 PM.

  21. #21
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    After some research i still didnt find a solution

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

    Re: FreeTDS

    That error will happen as you have no nationwar results yet. There is some "database connect success!" though which means it is now connecting ok.

    Where is it failing now, is it getting past the user/pass screen? Does the loginsvr log show your connection attempts?

  23. #23
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    nope i cant get past the user/pass screen

    This is my loginsvr_01

    Code:
    [Tue Sep 28 2010 16:36:49.464343 3086698992]: open log file  '/var/log/cabal/LoginSvr_01.log'
    [Tue Sep 28 2010 16:36:49.464480 3086698992]: LOG LEVEL: 3
    [Tue Sep 28 2010 16:36:49.464567 3086698992]: MemPoolUnitSizeClass(0): 14336Bytes
    [Tue Sep 28 2010 16:36:49.465861 3086698992]: Start LoginSvr_01 Server
    [Tue Sep 28 2010 16:36:49.466002 3086698992]: SITE_CHN, GAMEGUARD_V25, APEX_V10
    [Tue Sep 28 2010 16:36:49.466030 3086698992]: TestChannelGroupIdxStartPoint=50
    [Tue Sep 28 2010 16:36:49.466092 3086698992]: affiliatedCorpIP=121.170.135.;
    [Tue Sep 28 2010 16:36:49.466158 3086698992]: AdminIP=121.170.135.;
    [Tue Sep 28 2010 16:36:49.466184 3086698992]: client_version=22
    [Tue Sep 28 2010 16:36:49.466200 3086698992]: IgnoreClientVersion(1)
    [Tue Sep 28 2010 16:36:49.466220 3086698992]: UseAntiOnlineGameAddictionSystem(1)
    [Tue Sep 28 2010 16:36:49.466235 3086698992]: AdultAge(18)
    [Tue Sep 28 2010 16:36:49.466250 3086698992]: DefaultAgeAdult(1)
    [Tue Sep 28 2010 16:36:49.466266 3086698992]: UsePSS(0)
    [Tue Sep 28 2010 16:36:49.466300 3086698992]: CachedPSS(0)
    [Tue Sep 28 2010 16:36:49.466314 3086698992]: PssCacheDurationMin(1440)
    [Tue Sep 28 2010 16:36:49.466330 3086698992]: CutIfPssUserNotFound(0)
    [Tue Sep 28 2010 16:36:49.466345 3086698992]: PssLogLevel(0)
    [Tue Sep 28 2010 16:36:49.466359 3086698992]: InstantPlayTimeClearIntervalMin(300)
    [Tue Sep 28 2010 16:36:49.466374 3086698992]: IDC(1)
    [Tue Sep 28 2010 16:36:49.466388 3086698992]: SharedPssPersonId(0)
    [Tue Sep 28 2010 16:36:49.466404 3086698992]: NormalClientMagicKey(1168110)
    [Tue Sep 28 2010 16:36:49.466420 3086698992]: UseImageAuth(0)
    [Tue Sep 28 2010 16:36:49.466494 3086698992]: ImageAuthDataPath(./ImageAuth/)
    [Tue Sep 28 2010 16:36:49.466510 3086698992]: ImageAuthMaxTryCount(5)
    [Tue Sep 28 2010 16:36:49.466525 3086698992]: ImageAuthWaitTime(120000)
    [Tue Sep 28 2010 16:36:49.466540 3086698992]: BlockIfImageAuthFail(0)
    [Tue Sep 28 2010 16:36:49.466607 3086698992]: UseServerListManualOrder(0)
    [Tue Sep 28 2010 16:36:49.466623 3086698992]: 00:00 => 0
    [Tue Sep 28 2010 16:36:49.466636 3086698992]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
    [Tue Sep 28 2010 16:36:49.466651 3086698992]: ImageAuthDataMgr Init Begin
    [Tue Sep 28 2010 16:37:50.572204 3086698992]: ImageAuthDataMgr Init End(Count:1995)
    [Tue Sep 28 2010 16:37:50.696448 3078396816]: CProcessLayer(0)::svc Start [3078396816]
    [Tue Sep 28 2010 16:37:50.713396 3086698992]: try connect 127.0.0.1:38170, Sync
    [Tue Sep 28 2010 16:37:50.822197 3086698992]: sock 7 ->LinkHandler Open
    [Tue Sep 28 2010 16:37:50.822296 3086698992]: SendIPSConnect2Svr (195:128:01:00)
    [Tue Sep 28 2010 16:37:50.822372 3086698992]: try connect 127.0.0.1:38180, Sync
    [Tue Sep 28 2010 16:37:50.822504 3086698992]: sock 9 ->LinkHandler Open
    [Tue Sep 28 2010 16:37:50.822532 3086698992]: SendIPSConnect2Svr (195:128:01:00)
    [Tue Sep 28 2010 16:37:50.822573 3086698992]: try listening 38101 port
    [Tue Sep 28 2010 16:37:50.823531 3078396816]: ServerState changed(0 -> 0)
    [Sun Oct  3 2010 14:17:53.530173 3086039536]: open log file  '/var/log/cabal/LoginSvr_01.log'
    [Sun Oct  3 2010 14:17:53.685817 3086039536]: LOG LEVEL: 3
    [Sun Oct  3 2010 14:17:53.686502 3086039536]: MemPoolUnitSizeClass(0): 14336Bytes
    [Sun Oct  3 2010 14:17:53.689730 3086039536]: Start LoginSvr_01 Server
    [Sun Oct  3 2010 14:17:53.689799 3086039536]: SITE_CHN, GAMEGUARD_V25, APEX_V10
    [Sun Oct  3 2010 14:17:53.689824 3086039536]: TestChannelGroupIdxStartPoint=50
    [Sun Oct  3 2010 14:17:53.689884 3086039536]: affiliatedCorpIP=121.170.135.;
    [Sun Oct  3 2010 14:17:53.689904 3086039536]: AdminIP=121.170.135.;
    [Sun Oct  3 2010 14:17:53.689943 3086039536]: client_version=22
    [Sun Oct  3 2010 14:17:53.689961 3086039536]: IgnoreClientVersion(1)
    [Sun Oct  3 2010 14:17:53.689982 3086039536]: UseAntiOnlineGameAddictionSystem(1)
    [Sun Oct  3 2010 14:17:53.690000 3086039536]: AdultAge(18)
    [Sun Oct  3 2010 14:17:53.690498 3086039536]: DefaultAgeAdult(1)
    [Sun Oct  3 2010 14:17:53.690514 3086039536]: UsePSS(0)
    [Sun Oct  3 2010 14:17:53.690567 3086039536]: CachedPSS(0)
    [Sun Oct  3 2010 14:17:53.690584 3086039536]: PssCacheDurationMin(1440)
    [Sun Oct  3 2010 14:17:53.716631 3086039536]: CutIfPssUserNotFound(0)
    [Sun Oct  3 2010 14:17:53.716672 3086039536]: PssLogLevel(0)
    [Sun Oct  3 2010 14:17:53.716691 3086039536]: InstantPlayTimeClearIntervalMin(300)
    [Sun Oct  3 2010 14:17:53.716707 3086039536]: IDC(1)
    [Sun Oct  3 2010 14:17:53.716723 3086039536]: SharedPssPersonId(0)
    [Sun Oct  3 2010 14:17:53.716739 3086039536]: NormalClientMagicKey(1168110)
    [Sun Oct  3 2010 14:17:53.716755 3086039536]: UseImageAuth(0)
    [Sun Oct  3 2010 14:17:53.716772 3086039536]: ImageAuthDataPath(./ImageAuth/)
    [Sun Oct  3 2010 14:17:53.716788 3086039536]: ImageAuthMaxTryCount(5)
    [Sun Oct  3 2010 14:17:53.716804 3086039536]: ImageAuthWaitTime(120000)
    [Sun Oct  3 2010 14:17:53.716819 3086039536]: BlockIfImageAuthFail(0)
    [Sun Oct  3 2010 14:17:53.716855 3086039536]: UseServerListManualOrder(0)
    [Sun Oct  3 2010 14:17:53.716869 3086039536]: 00:00 => 0
    [Sun Oct  3 2010 14:17:53.716883 3086039536]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
    [Sun Oct  3 2010 14:17:53.716900 3086039536]: ImageAuthDataMgr Init Begin
    [Sun Oct  3 2010 14:19:23.841888 3086039536]: ImageAuthDataMgr Init End(Count:1995)
    [Sun Oct  3 2010 14:19:24.136270 3086039536]: try connect 127.0.0.1:38170, Sync
    [Sun Oct  3 2010 14:19:24.141636 3077737360]: CProcessLayer(0)::svc Start [3077737360]
    [Sun Oct  3 2010 14:19:24.305791 3086039536]: sock 7 ->LinkHandler Open
    [Sun Oct  3 2010 14:19:24.305871 3086039536]: SendIPSConnect2Svr (195:128:01:00)
    [Sun Oct  3 2010 14:19:24.305941 3086039536]: try connect 127.0.0.1:38180, Sync
    [Sun Oct  3 2010 14:19:24.306897 3086039536]: sock 9 ->LinkHandler Open
    [Sun Oct  3 2010 14:19:24.306927 3086039536]: SendIPSConnect2Svr (195:128:01:00)
    [Sun Oct  3 2010 14:19:24.306972 3086039536]: try listening 38101 port
    [Sun Oct  3 2010 14:19:24.369913 3077737360]: ServerState changed(0 -> 0)

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

    Re: FreeTDS

    The loginsvr is coming up ok so it must be networking somewhere.

    If you have a router make sure your WAN IP (What Is My IP Address - Shows Your IP Address) is in your internal.txt (unless testing locally) and that you have forwarded ports on your router. VMWare networking should be set to "Bridged".

    If you don't have a router (i.e. your main windows IP doesn't start 192.x or 10.x) then VMWare should be set to "NAT" and the port forwarding done on the vmware NAT interface.

    Try running cabal_config and using the local ip for the gameserver and the same in internal.txt. With a local config port forwarding and router issues don't affect it. You might have one of the router types that won't let people inside the LAN log in using the WAN IP address but a local setup shoud always work if configured correctly.

  25. #25
    Member iSpooky is offline
    MemberRank
    Sep 2010 Join Date
    71Posts

    Re: FreeTDS

    Ok i think i found the problem at vmware it was at custom not at bridged but if i put it on bridged centos cant ping to windows and windows cant ping to centos

    Edit: ok i found out too that my ports werent open yet opened them but still they both cant ping eachother :(
    Last edited by iSpooky; 03-10-10 at 07:50 PM.



Page 1 of 3 123 LastLast

Advertisement