Where are log files to see if my client is actually communicating with the server?

Results 1 to 17 of 17
  1. 09-02-13 #1
    LordAres
    Member LordAres is offline
    MemberRank
    Dec 2012 Join Date
    57Posts

    Where are log files to see if my client is actually communicating with the server?

    Where are the cabal ep8 log files so I can see if my client is actually talking to my server? Centos can ping my MSSQL perfectly. My PC can ping my centos perfectly. I had the service cabal config state players to connect on 192.168.1.11 which is my CentOS ip (because I only wanna connect atm no one else) and i changed the Internal.txt to 192.168.1.11

    So where are the log files?
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    Where are log files to see if my client is actually communicating with the server?
  3. 09-02-13 #2
    toast2250
    RaGEZONER toast2250 is offline
    MemberRank
    Sep 2009 Join Date
    CabalLocation
    638Posts

    Re: Where are log files to see if my client is actually communicating with the server

    /var/log/cabal
    Reply With Quote Reply With Quote
  4. 09-02-13 #3
    LordAres
    Member LordAres is offline
    MemberRank
    Dec 2012 Join Date
    57Posts

    Re: Where are log files to see if my client is actually communicating with the server

    Found the problem

    [Sat Feb 9 2013 11:49:32.772905 3086629360]: try connect 127.0.0.1:38170, Sync
    [Sat Feb 9 2013 11:49:32.774549 3086629360]: sock -1 ->LinkHandler close
    [Sat Feb 9 2013 11:49:32.774773 3086629360]: [##ERROR##] connect 127.0.0.1:38170 fail
    [Sat Feb 9 2013 11:49:32.774828 3086629360]: [##ERROR##] Link(): link open fail(Automatic), Exit
    [Sat Feb 9 2013 11:49:32.774968 3086629360]: [##ERROR##] active fail
    [Sat Feb 9 2013 11:49:32.785978 3078327184]: CProcessLayer(0)::svc Start [3078327184]
    [Sat Feb 9 2013 11:49:32.786272 3078327184]: CProcessLayer(0)::svc Terminated [3078327184]
    [Sat Feb 9 2013 11:49:32.993654 3086629360]: waiting for the client version
    [Sat Feb 9 2013 11:49:32.994654 3086629360]: waiting for the image key
    [Sat Feb 9 2013 11:49:32.995336 3086629360]: try listening 38101 port

    I port forwarded 38101 - 38200 TCP/UDP using my centos ip 192.168.1.11 Can anyone help me get these ports open?
    Reply With Quote Reply With Quote
  5. 09-02-13 #4
    toast2250
    RaGEZONER toast2250 is offline
    MemberRank
    Sep 2009 Join Date
    CabalLocation
    638Posts

    Re: Where are log files to see if my client is actually communicating with the server

    Disable firewall.
    Reply With Quote Reply With Quote
  6. 10-02-13 #5
    LordAres
    Member LordAres is offline
    MemberRank
    Dec 2012 Join Date
    57Posts

    Re: Where are log files to see if my client is actually communicating with the server

    centOS firewall is disabled
    Reply With Quote Reply With Quote
  7. 10-02-13 #6
    cadena
    Account Upgraded | Title Enabled! cadena is offline
    MemberRank
    Sep 2010 Join Date
    432Posts

    Re: Where are log files to see if my client is actually communicating with the server

    you are looking at the wrong log, look the one of the binary whit port 38170
    Reply With Quote Reply With Quote
  8. 10-02-13 #7
    LordAres
    Member LordAres is offline
    MemberRank
    Dec 2012 Join Date
    57Posts

    Re: Where are log files to see if my client is actually communicating with the server

    Quote Originally Posted by cadena View Post
    you are looking at the wrong log, look the one of the binary whit port 38170
    Whats that mean? Binary?
    Reply With Quote Reply With Quote
  9. 10-02-13 #8
    JemCanoy
    Account Upgraded | Title Enabled! JemCanoy is offline
    MemberRank
    Nov 2012 Join Date
    CabalLocation
    282Posts

    Re: Where are log files?

    try to look for DBAgent log.....

    Sent from my Phone using Tapatalk 2
    Reply With Quote Reply With Quote
  10. 10-02-13 #9
    LordAres
    Member LordAres is offline
    MemberRank
    Dec 2012 Join Date
    57Posts

    Re: Where are log files to see if my client is actually communicating with the server

    Heres my DB agent log. Well like a quarter of it.

    Code:
    [Sat Feb  9 2013 11:42:44.334527 3086464720]: open log file  '/var/log/cabal/DBAgent_01.log'
[Sat Feb  9 2013 11:42:44.336492 3086464720]: LOG LEVEL: 3
[Sat Feb  9 2013 11:42:44.336778 3086464720]: MemPoolUnitSizeClass(3): 28672Bytes
[Sat Feb  9 2013 11:42:44.337221 3086464720]: Seed: 1767709525
[Sat Feb  9 2013 11:42:44.338373 3086464720]: Start DBAgent_01 Server
[Sat Feb  9 2013 11:42:44.374392 3086464720]: UseEcryptText (Off)
[Sat Feb  9 2013 11:42:44.375244 3086464720]: UseQueryTimeOutSec (0)
[Sat Feb  9 2013 11:42:44.375979 3086464720]: CacheUserDataKeepMin (60)
[Sat Feb  9 2013 11:42:44.377709 3086461840]: CProcessLayer(0)::svc Start [3086461840]
[Sat Feb  9 2013 11:42:44.378489 3075971984]: CProcessLayer(0)::svc Start [3075971984]
[Sat Feb  9 2013 11:42:44.379330 3086464720]: ServerType(233): 5 Threads
[Sat Feb  9 2013 11:42:44.380289 3065482128]: CProcessLayer(0)::svc Start [3065482128]
[Sat Feb  9 2013 11:42:44.380709 3054992272]: CProcessLayer(0)::svc Start [3054992272]
[Sat Feb  9 2013 11:42:44.381138 3044502416]: CProcessLayer(0)::svc Start [3044502416]
[Sat Feb  9 2013 11:44:52.482269 3086464720]: SIGTERM
[Sat Feb  9 2013 11:44:52.640580 3075971984]: CProcessLayer(0)::svc Terminated [3075971984]
[Sat Feb  9 2013 11:44:52.640737 3065482128]: [##ERROR##] getq fail (108)
[Sat Feb  9 2013 11:44:52.640778 3065482128]: CProcessLayer(0)::svc Terminated [3065482128]
[Sat Feb  9 2013 11:44:52.640847 3086461840]: [##ERROR##] getq fail (108)
[Sat Feb  9 2013 11:44:52.640885 3086461840]: CProcessLayer(0)::svc Terminated [3086461840]
[Sat Feb  9 2013 11:44:52.640951 3054992272]: [##ERROR##] getq fail (108)
[Sat Feb  9 2013 11:44:52.640990 3054992272]: CProcessLayer(0)::svc Terminated [3054992272]
[Sat Feb  9 2013 11:44:52.641059 3044502416]: [##ERROR##] getq fail (108)
[Sat Feb  9 2013 11:44:52.641098 3044502416]: CProcessLayer(0)::svc Terminated [3044502416]
[Sat Feb  9 2013 11:45:06.953186 3086477008]: open log file  '/var/log/cabal/DBAgent_01.log'
[Sat Feb  9 2013 11:45:06.954051 3086477008]: LOG LEVEL: 3
[Sat Feb  9 2013 11:45:06.954449 3086477008]: MemPoolUnitSizeClass(3): 28672Bytes
[Sat Feb  9 2013 11:45:06.955459 3086477008]: Seed: 34972035
[Sat Feb  9 2013 11:45:06.957009 3086477008]: Start DBAgent_01 Server
[Sat Feb  9 2013 11:45:06.959083 3086477008]: UseEcryptText (Off)
[Sat Feb  9 2013 11:45:06.959997 3086477008]: UseQueryTimeOutSec (0)
[Sat Feb  9 2013 11:45:06.960389 3086477008]: CacheUserDataKeepMin (60)
[Sat Feb  9 2013 11:45:06.963018 3086477008]: ServerType(233): 5 Threads
[Sat Feb  9 2013 11:45:07.000821 3075984272]: CProcessLayer(0)::svc Start [3075984272]
[Sat Feb  9 2013 11:45:07.002867 3086474128]: CProcessLayer(0)::svc Start [3086474128]
[Sat Feb  9 2013 11:45:07.005623 3044514704]: CProcessLayer(0)::svc Start [3044514704]
[Sat Feb  9 2013 11:45:07.006210 3055004560]: CProcessLayer(0)::svc Start [3055004560]
[Sat Feb  9 2013 11:45:07.006423 3065494416]: CProcessLayer(0)::svc Start [3065494416]
[Sat Feb  9 2013 11:48:16.193199 3086477008]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 11:48:16.193310 3086477008]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 11:48:16.193380 3086477008]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 11:48:16.193426 3086477008]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 11:48:16.193461 3086477008]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 11:48:16.193496 3086477008]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 11:48:16.193693 3086477008]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 11:48:16.193730 3086477008]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Sat Feb  9 2013 11:48:16.193838 3086477008]: try listening 38181 port
[Sat Feb  9 2013 11:49:43.905626 3086477008]: success accept 9(127.0.0.1:33153)
[Sat Feb  9 2013 11:49:43.907138 3086477008]: 1.open user 9 [B4C18DC0] (127.0.0.1)
[Sat Feb  9 2013 11:49:43.914927 3086477008]: 1.close user 9 [B4C18DC0] (127.0.0.1)
[Sat Feb  9 2013 11:51:25.332335 3065494416]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 11:51:25.332580 3065494416]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 11:51:25.332672 3065494416]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 11:51:25.332756 3065494416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 11:51:25.332825 3065494416]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 11:51:25.332890 3065494416]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 11:51:25.333061 3065494416]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 11:51:25.333098 3065494416]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)
[Sat Feb  9 2013 11:54:34.374571 3065494416]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 11:54:34.374680 3065494416]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 11:54:34.374732 3065494416]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 11:54:34.374778 3065494416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 11:54:34.374814 3065494416]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 11:54:34.374864 3065494416]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 11:54:34.374907 3065494416]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 11:54:34.374946 3065494416]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Sat Feb  9 2013 11:57:43.609009 3065494416]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 11:57:43.609152 3065494416]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 11:57:43.609204 3065494416]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 11:57:43.609273 3065494416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 11:57:43.609354 3065494416]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 11:57:43.609389 3065494416]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 11:57:43.609431 3065494416]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 11:57:43.609466 3065494416]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)
[Sat Feb  9 2013 12:00:52.756637 3065494416]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 12:00:52.756799 3065494416]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 12:00:52.756961 3065494416]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 12:00:52.757057 3065494416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 12:00:52.757136 3065494416]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 12:00:52.757209 3065494416]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 12:00:52.757287 3065494416]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 12:00:52.757354 3065494416]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Sat Feb  9 2013 12:04:01.773896 3065494416]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 12:04:01.773998 3065494416]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 12:04:01.774047 3065494416]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 12:04:01.774095 3065494416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 12:04:01.774130 3065494416]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 12:04:01.774165 3065494416]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 12:04:01.774201 3065494416]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 12:04:01.774236 3065494416]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)
[Sat Feb  9 2013 12:07:10.824792 3065494416]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 12:07:10.824892 3065494416]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 12:07:10.824941 3065494416]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 12:07:10.824987 3065494416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 12:07:10.825022 3065494416]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 12:07:10.825057 3065494416]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 12:07:10.825094 3065494416]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 12:07:10.825128 3065494416]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Sat Feb  9 2013 12:10:19.897909 3065494416]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 12:10:19.898110 3065494416]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 12:10:19.898161 3065494416]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 12:10:19.898265 3065494416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 12:10:19.898301 3065494416]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 12:10:19.898336 3065494416]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 12:10:19.898378 3065494416]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 12:10:19.898412 3065494416]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)
[Sat Feb  9 2013 12:13:28.921578 3065494416]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 12:13:28.921681 3065494416]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 12:13:28.921731 3065494416]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 12:13:28.921778 3065494416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 12:13:28.921813 3065494416]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 12:13:28.921848 3065494416]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 12:13:28.921885 3065494416]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 12:13:28.921920 3065494416]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Sat Feb  9 2013 12:15:12.229038 3086477008]: SIGTERM
3086477008: work_pending_i: Interrupted system call
[Sat Feb  9 2013 17:18:15.582216 3086051024]: open log file  '/var/log/cabal/DBAgent_01.log'
[Sat Feb  9 2013 17:18:15.585185 3086051024]: LOG LEVEL: 3
[Sat Feb  9 2013 17:18:15.585434 3086051024]: MemPoolUnitSizeClass(3): 28672Bytes
[Sat Feb  9 2013 17:18:15.585993 3086051024]: Seed: 1776107327
[Sat Feb  9 2013 17:18:15.587173 3086051024]: Start DBAgent_01 Server
[Sat Feb  9 2013 17:18:15.590825 3086051024]: UseEcryptText (Off)
[Sat Feb  9 2013 17:18:15.592825 3086051024]: UseQueryTimeOutSec (0)
[Sat Feb  9 2013 17:18:15.618825 3086051024]: CacheUserDataKeepMin (60)
[Sat Feb  9 2013 17:18:15.626825 3086048144]: CProcessLayer(0)::svc Start [3086048144]
[Sat Feb  9 2013 17:18:15.628152 3086051024]: ServerType(233): 5 Threads
[Sat Feb  9 2013 17:18:15.629484 3075558288]: CProcessLayer(0)::svc Start [3075558288]
[Sat Feb  9 2013 17:18:15.629952 3065068432]: CProcessLayer(0)::svc Start [3065068432]
[Sat Feb  9 2013 17:18:15.630607 3054578576]: CProcessLayer(0)::svc Start [3054578576]
[Sat Feb  9 2013 17:18:15.633103 3044088720]: CProcessLayer(0)::svc Start [3044088720]
[Sat Feb  9 2013 17:18:18.702845 3086051024]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 17:18:18.702881 3086051024]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 17:18:18.702940 3086051024]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 17:18:18.702989 3086051024]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 17:18:18.703044 3086051024]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 17:18:18.703092 3086051024]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 17:18:18.703304 3086051024]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 17:18:18.703356 3086051024]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Sat Feb  9 2013 17:18:18.703585 3086051024]: try listening 38181 port
[Sat Feb  9 2013 17:18:28.625962 3086048144]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 17:18:28.627311 3086048144]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 17:18:28.627935 3086048144]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 17:18:28.628046 3086048144]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 17:18:28.628095 3086048144]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 17:18:28.628143 3086048144]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 17:18:28.628331 3086048144]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 17:18:28.628379 3086048144]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)
[Sat Feb  9 2013 17:18:31.638276 3086048144]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 17:18:31.638483 3086048144]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 17:18:31.640244 3086048144]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 17:18:31.640319 3086048144]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 17:18:31.640366 3086048144]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 17:18:31.640424 3086048144]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 17:18:31.640485 3086048144]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 17:18:31.640539 3086048144]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Sat Feb  9 2013 17:18:38.644564 3086048144]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 17:18:38.644687 3086048144]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 17:18:38.644739 3086048144]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 17:18:38.644795 3086048144]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 17:18:38.644843 3086048144]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 17:18:38.644975 3086048144]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 17:18:38.645030 3086048144]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 17:18:38.645093 3086048144]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)
[Sat Feb  9 2013 17:18:41.369025 3086051024]: success accept 9(127.0.0.1:37781)
[Sat Feb  9 2013 17:18:41.375096 3086051024]: 1.open user 9 [B4C13380] (127.0.0.1)
[Sat Feb  9 2013 17:18:41.375537 3086051024]: 1.close user 9 [B4C13380] (127.0.0.1)
[Sat Feb  9 2013 17:18:41.657697 3086048144]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 17:18:41.657879 3086048144]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 17:18:41.658020 3086048144]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 17:18:41.658352 3086048144]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 17:18:41.658454 3086048144]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 17:18:41.658547 3086048144]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 17:18:41.658635 3086048144]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 17:18:41.658721 3086048144]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Sat Feb  9 2013 17:18:48.688173 3086048144]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 17:18:48.688173 3086048144]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 17:18:48.688173 3086048144]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 17:18:48.688173 3086048144]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 17:18:48.688190 3086048144]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 17:18:48.688225 3086048144]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 17:18:48.688266 3086048144]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 17:18:48.688301 3086048144]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)
[Sat Feb  9 2013 17:18:51.713849 3086048144]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 17:18:51.713937 3086048144]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 17:18:51.713988 3086048144]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 17:18:51.714035 3086048144]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 17:18:51.714070 3086048144]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 17:18:51.714105 3086048144]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 17:18:51.714147 3086048144]: [##ERROR##] check 'pDB' fail
[Sat Feb  9 2013 17:18:51.714182 3086048144]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Sat Feb  9 2013 17:18:58.608530 3086048144]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Feb  9 2013 17:18:58.608628 3086048144]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Feb  9 2013 17:18:58.608678 3086048144]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Feb  9 2013 17:18:58.608748 3086048144]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Feb  9 2013 17:18:58.608784 3086048144]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Feb  9 2013 17:18:58.608819 3086048144]: [##ERROR##] Database Connect Fail ((null))
[Sat Feb  9 2013 17:18:58.608866 3086048144]: [##ERROR##] check 'pDB' fail
    Its mainly saying

    Code:
    [Sat Feb  9 2013 17:18:18.702845 3086051024]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
    but I notice

    Code:
    [Sat Feb  9 2013 11:48:16.193838 3086477008]: try listening 38181 port
[Sat Feb  9 2013 11:49:43.905626 3086477008]: success accept 9(127.0.0.1:33153)
    Idk if that means its connected successfully to my MSSQL or?

    I have restored the databases correctly and everything

    databases-proof.png

    When i made the gameserver i had to use

    Code:
    DRIVER={SQL Server};SERVER=COMPUTER\sqlexpress;UID=;PWD=;
    Last edited by LordAres; 10-02-13 at 04:50 AM.
    Reply With Quote Reply With Quote
  11. 10-02-13 #10
    JemCanoy
    Account Upgraded | Title Enabled! JemCanoy is offline
    MemberRank
    Nov 2012 Join Date
    CabalLocation
    282Posts

    Re: Where are the log files?

    thats the problem....ur centos cant connect to ur db.....did u enabled Name Pipes and TCP/IP?

    Sent from my Phone using Tapatalk 2
    Reply With Quote Reply With Quote
  12. 10-02-13 #11
    LordAres
    Member LordAres is offline
    MemberRank
    Dec 2012 Join Date
    57Posts

    Re: Where are log files to see if my client is actually communicating with the server

    How do i enable those things? Because it doesnt sound fimiliar so im going to go with... NO lol
    Reply With Quote Reply With Quote
  13. 10-02-13 #12
    JemCanoy
    Account Upgraded | Title Enabled! JemCanoy is offline
    MemberRank
    Nov 2012 Join Date
    CabalLocation
    282Posts
    Quote Originally Posted by LordAres View Post
    How do i enable those things? Because it doesnt sound fimiliar so im going to go with... NO lol
    LoL...here http://forum.ragezone.com/showthread.php?t=906945

    Sent from my Phone using Tapatalk 2
    Reply With Quote Reply With Quote
  14. 10-02-13 #13
    LordAres
    Member LordAres is offline
    MemberRank
    Dec 2012 Join Date
    57Posts

    Re: Where are log files to see if my client is actually communicating with the server

    Okay so heres a few things jem. I really help you being so helpful and replying so fast. I love it actually.

    Heres weird thing number one. No start stop services. Just a weird error


    now in extornias guide it says:


    And heres what mine looks like:


    but in client protocals 10 i have these and i enabled them but since i have no start stop i had to restart


    But what do i do about the no start stop and no named pipes in the one extornia has
    Last edited by LordAres; 10-02-13 at 06:05 AM.
    Reply With Quote Reply With Quote
  15. 10-02-13 #14
    JemCanoy
    Account Upgraded | Title Enabled! JemCanoy is offline
    MemberRank
    Nov 2012 Join Date
    CabalLocation
    282Posts
    mybe u open the wrong configuration manager

    Sent from my Phone using Tapatalk 2
    Reply With Quote Reply With Quote
  16. 10-02-13 #15
    gtocurintcha
    Apprentice gtocurintcha is offline
    MemberRank
    Jan 2013 Join Date
    10Posts

    Re: Where are log files to see if my client is actually communicating with the server

    disable Windows firewall
    Reply With Quote Reply With Quote
  17. 10-02-13 #16
    LordAres
    Member LordAres is offline
    MemberRank
    Dec 2012 Join Date
    57Posts

    Re: Where are log files to see if my client is actually communicating with the server

    Quote Originally Posted by gtocurintcha View Post
    disable Windows firewall
    Not to be rude but if you read the post it states that I did that earlier. Thanks tho.
    Reply With Quote Reply With Quote
  18. 10-02-13 #17
    LordAres
    Member LordAres is offline
    MemberRank
    Dec 2012 Join Date
    57Posts

    Re: Where are log files to see if my client is actually communicating with the server

    Okay so the fix is to completly uninstall MSSQL 2008 R2 and delete all the MSSQL folders then restart and reinstall.
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement