My guides + databases + server files repack -V2!

Page 48 of 49 FirstFirst ... 3840414243444546474849 LastLast
Results 706 to 720 of 729
  1. 23-11-08 #706
    Josh
    Ex Post Whore Josh is offline
    MemberRank
    Dec 2004 Join Date
    8,333Posts

    re: [old] My guides + databases

    Don't put anything there, or use Y not y.

    My problem is that everything seems to work fine, but when I try and connect with my client it doesn't connect at all. I type a random user/pass, the bar loads entirely and says the server is not found or whatever.

    Using CentOS 4.7 as a dedicated and Windows 2003 as the DB server, both seperate servers in the data center.

    Also, it IS running, according to top,
    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    22837 cabal 14 -1 428m 200m 2356 R 7.0 4.9 0:49.71 WorldSvr_24_01
  2. 23-11-08 #707
    Cath22
    Go go go! Cath22 is offline
    MemberRank
    Aug 2008 Join Date
    Cabal-ArenaLocation
    713Posts

    re: [old] My guides + databases

    its just a glitch
    simply

    type in after that service cabal start
  3. 23-11-08 #708
    chumpywumpy
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    re: [old] My guides + databases

    Quote Originally Posted by neutonsp View Post
    Hello;
    I have a doubt!

    When orders start the services, does not appear [OK], appears only as shown below, where you are with the [OK] is and where your tutorial is missing the [OK] is the man.
    not even showing [OK] services are running?






    Thank
    Don't actuallt ype "y". The script is a bit basic with input and expects you to either press Enter to accept the default or enter something else. As you entered something it thinks you mean no. This has been fixed for 2.5.

    Quote Originally Posted by Josh View Post
    Don't put anything there, or use Y not y.

    My problem is that everything seems to work fine, but when I try and connect with my client it doesn't connect at all. I type a random user/pass, the bar loads entirely and says the server is not found or whatever.

    Using CentOS 4.7 as a dedicated and Windows 2003 as the DB server, both seperate servers in the data center.

    Also, it IS running, according to top,
    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    22837 cabal 14 -1 428m 200m 2356 R 7.0 4.9 0:49.71 WorldSvr_24_01
    If it isn't accepting or refusing the username/pass it sounds like you are not even getting past the login server (the log file will tel you if it saw you or not). Make sure that internal.txt has the right IP, you are using the batch file to launch cabal and the centos firewall is off.
  4. 23-11-08 #709
    Josh
    Ex Post Whore Josh is offline
    MemberRank
    Dec 2004 Join Date
    8,333Posts

    re: [old] My guides + databases

    I have the correct IP in internal, it's not even verifiying the username and password.Where is the cabal log stored? My firewall is off.
  5. 23-11-08 #710
    chumpywumpy
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    re: [old] My guides + databases

    The logs are in /var/log/cabal in the centos machine.

    Can you ping centos from windows and are you using a router with your wan ip in internal.txt? Some routers won't let lan people connect to the wan ip so try getting a friend to connect (assuming you have forwarded ports) or try setting the server and internal.txt to use the lan ip and see if that works.
  6. 23-11-08 #711
    mav3r1cksandy
    Valued Member mav3r1cksandy is offline
    MemberRank
    Aug 2006 Join Date
    Inside the ServLocation
    124Posts

    re: [old] My guides + databases

    Quote Originally Posted by Pffi View Post
    I now finally could bring my server to run, but tbh iam stuck at account registration... I read about 18 sites of this thread and a guy had the similar problem like me... if I right click cabal_tool_registeraccount, and execute it, I can't change anything, so I tried to execute the script in database "account" directly.

    If I execute the following:
    Code:
    USE [ACCOUNT]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[cabal_tool_registerAccount]
@id = myid,
@password = mypassword
SELECT'Return Value'= @return_value
GO
    I get this error:

    Code:
    Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
    Code:
    Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.
    And no Iam not using 64 bit os and I did the md5 thingy... so any solution for this? Btw, if I try to connect to my server (the cmd prompt says svr's running) and type in any ID or PW the connection bar loads through and says unable to connect ... shouldn't it say account does not exist or similar?

    Thanks advance, im stuck :(

    U forgot to Copy the xp_md5.dll to c:\windows\system32 folder i guess...

    To avoid the same error i suggest u make a fresh set of databases and restore them. copy the xp_md5.dll to windows directly and RUN THIS ONLY 1nce COS IT DIDNT WORK THE SECOND TIME FOR ME ( IF THIS DIDNT WORK CHANGE THE FOLDER PATH TO THE FOLDER WHERE U HAVE UR DATABASES and XP_MD5.DLL)

    IN MASTER EXECUTE THIS:--
    EXEC SP_ADDEXTENDEDPROC 'xp_md5','d:\cabal\xp_md5.dll'
    Note that d:\... is where ur xp_md5.dll is located and remember run it only once from 1 drive :p cos i tried to run twice it didnt woek :p
  7. 23-11-08 #712
    Josh
    Ex Post Whore Josh is offline
    MemberRank
    Dec 2004 Join Date
    8,333Posts
    Quote Originally Posted by chumpywumpy View Post
    The logs are in /var/log/cabal in the centos machine.

    Can you ping centos from windows and are you using a router with your wan ip in internal.txt? Some routers won't let lan people connect to the wan ip so try getting a friend to connect (assuming you have forwarded ports) or try setting the server and internal.txt to use the lan ip and see if that works.
    I'm using it on a dedicated server with softlayer. There is no router OR firewall, both can ping both using a private and WAN IP.
    WorldSvr_24_01.log:
    Code:
    [Sun Nov 23 2008 07:12:21.947132 3086948032]: open log file  '/var/log/cabal/WorldSvr_24_01.log'
[Sun Nov 23 2008 07:12:21.947213 3086948032]: LOG LEVEL: 3
[Sun Nov 23 2008 07:12:21.947239 3086948032]: MemPoolUnitSizeClass(5): 16384Bytes
[Sun Nov 23 2008 07:12:21.947525 3086948032]: Start WorldSvr_24_01 Server
[Sun Nov 23 2008 07:12:21.947557 3086948032]: CheckSkillCoolTimeHack (On)
[Sun Nov 23 2008 07:12:21.947576 3086948032]: CheckShopHack (On)
[Sun Nov 23 2008 07:12:21.947596 3086948032]: CheckWarpHack (On)
[Sun Nov 23 2008 07:12:21.947615 3086948032]: CheckWareHouseHack (On)
[Sun Nov 23 2008 07:12:21.947634 3086948032]: UseCheckDistanceSkillHack (On)
[Sun Nov 23 2008 07:12:21.947652 3086948032]: MaxTimeHackingCount(2)
[Sun Nov 23 2008 07:12:21.947670 3086948032]: MaxDistanceHackingCount(2)
[Sun Nov 23 2008 07:12:21.947692 3086948032]: UseNonClientCheck (Off)
[Sun Nov 23 2008 07:12:21.947711 3086948032]: NonClientDisAdvantageRate (90)
[Sun Nov 23 2008 07:12:21.947729 3086948032]: useDropDiscount (On)
[Sun Nov 23 2008 07:12:21.947747 3086948032]: UseBlessingBeadCheck (On)
[Sun Nov 23 2008 07:12:21.947766 3086948032]: AllowTradeChannel (Off)
[Sun Nov 23 2008 07:12:21.947785 3086948032]: UseCheckMissionIdx(On)
[Sun Nov 23 2008 07:12:21.947803 3086948032]: UseCheckDeadStatActive(On)
[Sun Nov 23 2008 07:12:21.947821 3086948032]: reload ActiveDeadStatCount(30)
[Sun Nov 23 2008 07:12:21.947839 3086948032]: UseHackcheckByTimeScope (On)
[Sun Nov 23 2008 07:12:21.947858 3086948032]: CheckSkillTimeHackScope(60000)
[Sun Nov 23 2008 07:12:21.947876 3086948032]: UseMobsChaseModify (On)
[Sun Nov 23 2008 07:12:21.947895 3086948032]: UseAlzDbHackCheck (Off)
[Sun Nov 23 2008 07:12:21.947913 3086948032]: UseCutIfAlzDbHacked (Off)
[Sun Nov 23 2008 07:12:21.947931 3086948032]: useCheckUserAttack (On)
[Sun Nov 23 2008 07:12:21.947949 3086948032]: UseHackUserDBSave (On)
[Sun Nov 23 2008 07:12:21.947967 3086948032]: UseAdminUser (Off)
[Sun Nov 23 2008 07:12:21.947991 3086948032]: UseAntiOnlineGameAddictionSystem(1)
[Sun Nov 23 2008 07:12:21.948011 3086948032]: InstantPlayTimeClearIntervalMin(300)
[Sun Nov 23 2008 07:12:21.948029 3086948032]: InstantPlayTimeDbUpdateIntervalMin(5)
[Sun Nov 23 2008 07:12:21.948048 3086948032]: InstantPlayTimeNotifyIntervalMin(1)
[Sun Nov 23 2008 07:12:21.948067 3086948032]: AdvantageBoundaryTime(10800, 18000)
[Sun Nov 23 2008 07:12:21.948086 3086948032]: InstantPlayTimeDebugMultiple(1)
[Sun Nov 23 2008 07:12:21.948104 3086948032]: UseCheckBelongItem (Off)
[Sun Nov 23 2008 07:12:21.948123 3086948032]: UseCheckDMZArea (On)
[Sun Nov 23 2008 07:12:21.948141 3086948032]: AllowCashShop(0)
[Sun Nov 23 2008 07:12:21.948159 3086948032]: AllowNetcafePoint(0)
[Sun Nov 23 2008 07:12:21.948178 3086948032]: RestrictOddCircleUseCountInDungeon (On)
[Sun Nov 23 2008 07:12:21.948199 3086948032]: UseAdditionalMissionDungeonInstanceInPremiumCH (On)
[Sun Nov 23 2008 07:12:21.948215 3086948032]: UseAdditionalMissionDungeonInstanceInPremiumUser (On)
[Sun Nov 23 2008 07:12:21.948232 3086948032]: AdditionalMissionDungeonInstanceCount (0)
[Sun Nov 23 2008 07:12:21.948250 3086948032]: UsePvpBetting (Off)
[Sun Nov 23 2008 07:12:21.948268 3086948032]: PShopOpenLimitCount (0)
[Sun Nov 23 2008 07:12:21.948286 3086948032]: UseTradeChannelRestriction (Off)
[Sun Nov 23 2008 07:12:21.948304 3086948032]: UseArtOfDefensePenalty (On)
[Sun Nov 23 2008 07:12:21.948322 3086948032]: IgnorePartyInviteDistance (Off)
[Sun Nov 23 2008 07:12:21.948341 3086948032]: UseWorldDrop (Off)
[Sun Nov 23 2008 07:12:21.948359 3086948032]: UseInventoryHackCheck (On)
[Sun Nov 23 2008 07:12:21.948378 3086948032]: UseRandomValueWriteLog (Off)
[Sun Nov 23 2008 07:12:21.948396 3086948032]: UseMinLevDiffValueForExpCalc (On)
[Sun Nov 23 2008 07:12:21.948414 3086948032]: UsePartyMinExpForInvalidPartyMember (On)
[Sun Nov 23 2008 07:12:21.948432 3086948032]: UseIgnoreOtherBlessBuff (Off)
[Sun Nov 23 2008 07:12:21.948449 3086948032]: Extended Alz Mode
[Sun Nov 23 2008 07:12:21.948467 3086948032]: GameGuard enabled version
[Sun Nov 23 2008 07:12:21.948486 3086948032]: GameGuard turned off
[Sun Nov 23 2008 07:12:21.948512 3086948032]: APEX enabled version
[Sun Nov 23 2008 07:12:21.948529 3086948032]: APEX turned off
[Sun Nov 23 2008 07:12:21.948545 3086948032]: XTrap disabled version
[Sun Nov 23 2008 07:12:21.948562 3086948032]: WaitUntilChannelTypeSet(Off)
[Sun Nov 23 2008 07:12:21.948580 3086948032]: UseBootUpGmsChannelType(On)
[Sun Nov 23 2008 07:12:21.948987 3086948032]: Local ip = 75.126.142.67 (from ini)
[Sun Nov 23 2008 07:12:21.949016 3086948032]: MaxAttackHackTime (300000)
[Sun Nov 23 2008 07:12:21.949035 3086948032]: SpeedHackCheckTime (10000)
[Sun Nov 23 2008 07:12:21.949349 3086948032]: try connect 127.0.0.1:38170, Sync
[Sun Nov 23 2008 07:12:21.949644 3086948032]: sock 5 ->LinkHandler Open
[Sun Nov 23 2008 07:12:21.949683 3086948032]: SendIPSConnect2Svr (161:24:01:00)
[Sun Nov 23 2008 07:12:21.949732 3086948032]: try connect 127.0.0.1:38181, Sync
[Sun Nov 23 2008 07:12:21.950029 3086948032]: sock 7 ->LinkHandler Open
[Sun Nov 23 2008 07:12:21.950059 3086948032]: SendIPSConnect2Svr (161:24:01:00)
[Sun Nov 23 2008 07:12:21.950101 3086948032]: try connect 127.0.0.1:38190, Sync
[Sun Nov 23 2008 07:12:21.950671 26667936]: CProcessLayer(0)::svc Start [26667936]
[Sun Nov 23 2008 07:12:21.950800 3086948032]: sock 8 ->LinkHandler Open
[Sun Nov 23 2008 07:12:21.950833 3086948032]: SendIPSConnect2Svr (161:24:01:00)
[Sun Nov 23 2008 07:12:21.950876 3086948032]: try connect 127.0.0.1:38121, Sync
[Sun Nov 23 2008 07:12:21.950949 3086948032]: sock 9 ->LinkHandler Open
[Sun Nov 23 2008 07:12:21.950977 3086948032]: SendIPSConnect2Svr (161:24:01:00)
[Sun Nov 23 2008 07:12:21.970039 3086948032]: GuildCreateFee: 10000000
[Sun Nov 23 2008 07:12:23.087520 101514144]: CProcessLayer(1)::svc Start [101514144]
[Sun Nov 23 2008 07:12:23.134491 37157792]: CProcessLayer(2)::svc Start [37157792]
[Sun Nov 23 2008 07:12:23.185487 118746016]: CProcessLayer(3)::svc Start [118746016]
[Sun Nov 23 2008 07:12:23.232483 47647648]: CProcessLayer(4)::svc Start [47647648]
[Sun Nov 23 2008 07:12:23.279476 88624032]: CProcessLayer(5)::svc Start [88624032]
[Sun Nov 23 2008 07:12:23.326505 58137504]: CProcessLayer(6)::svc Start [58137504]
[Sun Nov 23 2008 07:12:23.375059 68627360]: CProcessLayer(7)::svc Start [68627360]
[Sun Nov 23 2008 07:12:23.426477 129235872]: CProcessLayer(8)::svc Start [129235872]
[Sun Nov 23 2008 07:12:23.473462 2987113376]: CProcessLayer(9)::svc Start [2987113376]
[Sun Nov 23 2008 07:12:23.516456 2967661472]: CProcessLayer(10)::svc Start [2967661472]
[Sun Nov 23 2008 07:12:23.563448 2948361120]: CProcessLayer(13)::svc Start [2948361120]
[Sun Nov 23 2008 07:12:23.614444 2932480928]: CProcessLayer(14)::svc Start [2932480928]
[Sun Nov 23 2008 07:12:23.661438 2911964064]: CProcessLayer(19)::svc Start [2911964064]
[Sun Nov 23 2008 07:12:23.692443 2896984992]: CProcessLayer(23)::svc Start [2896984992]
[Sun Nov 23 2008 07:12:23.727433 2881833888]: CProcessLayer(24)::svc Start [2881833888]
[Sun Nov 23 2008 07:12:23.762431 2866645920]: CProcessLayer(25)::svc Start [2866645920]
[Sun Nov 23 2008 07:12:23.793429 2851642272]: CProcessLayer(26)::svc Start [2851642272]
[Sun Nov 23 2008 07:12:23.836444 2835540896]: CProcessLayer(27)::svc Start [2835540896]
[Sun Nov 23 2008 07:12:23.871482 2820553632]: CProcessLayer(28)::svc Start [2820553632]
[Sun Nov 23 2008 07:12:23.902416 2805476256]: CProcessLayer(29)::svc Start [2805476256]
[Sun Nov 23 2008 07:12:23.945411 2790230944]: CProcessLayer(30)::svc Start [2790230944]
[Sun Nov 23 2008 07:12:23.966109 3086948032]: try listening 38111 port
[Sun Nov 23 2008 07:12:24.934639 26667936]: ChannelType changed(0 -> 1)
    GlobalDBaAgent.log:
    Code:
    [Sun Nov 23 2008 07:12:19.402067 3086415552]: open log file  '/var/log/cabal/GlobalDBAgent.log'
[Sun Nov 23 2008 07:12:19.402147 3086415552]: LOG LEVEL: 3
[Sun Nov 23 2008 07:12:19.402170 3086415552]: MemPoolUnitSizeClass(0): 14336Bytes
[Sun Nov 23 2008 07:12:19.402725 3086415552]: Start GlobalDBAgent Server
[Sun Nov 23 2008 07:12:19.403058 3086415552]: UseEcryptText (Off)
[Sun Nov 23 2008 07:12:19.403948 3033963424]: CProcessLayer(0)::svc Start [3033963424]
[Sun Nov 23 2008 07:12:19.404057 3044453280]: CProcessLayer(0)::svc Start [3044453280]
[Sun Nov 23 2008 07:12:19.404105 3054943136]: CProcessLayer(0)::svc Start [3054943136]
[Sun Nov 23 2008 07:12:19.404173 3065432992]: CProcessLayer(0)::svc Start [3065432992]
[Sun Nov 23 2008 07:12:19.404219 3075922848]: CProcessLayer(0)::svc Start [3075922848]
[Sun Nov 23 2008 07:12:19.404266 3086412704]: CProcessLayer(0)::svc Start [3086412704]
[Sun Nov 23 2008 07:12:19.404653 3086415552]: try listening 38180 port
[Sun Nov 23 2008 07:12:19.404763 3023473568]: CProcessLayer(0)::svc Start [3023473568]
[Sun Nov 23 2008 07:12:19.404864 3012983712]: CProcessLayer(0)::svc Start [3012983712]
[Sun Nov 23 2008 07:12:19.404877 3002493856]: CProcessLayer(0)::svc Start [3002493856]
[Sun Nov 23 2008 07:12:19.404928 2992004000]: CProcessLayer(0)::svc Start [2992004000]
[Sun Nov 23 2008 07:12:19.991859 3086415552]: accept success 8(127.0.0.1:35956)
[Sun Nov 23 2008 07:12:19.992311 3086415552]: 1.open user 8 [82E9C48] (127.0.0.1)
[Sun Nov 23 2008 07:12:22.551647 3086415552]: accept success 10(127.0.0.1:35964)
[Sun Nov 23 2008 07:12:22.551796 3086415552]: 2.open user 10 [82F2348] (127.0.0.1)
    Need anymore logs? Everything looks fine..

    My login log just showed this:

    [Sun Nov 23 2008 07:12:22.552572 3078486944]: CProcessLayer(0)::svc Start [3078486944]
    [Sun Nov 23 2008 07:12:22.552640 3078486944]: ServerState changed(0 -> 0)
    [Sun Nov 23 2008 07:19:32.993683 3086788288]: accept success 11(xxx:54832)
    [Sun Nov 23 2008 07:19:32.993819 3086788288]: 1.open user 11 [9532908] (xxx)
    [Sun Nov 23 2008 07:19:33.565030 3078486944]: AuthRequest: UserID(josh), Addr(xxx)
    [Sun Nov 23 2008 07:20:04.830289 3086788288]: 1.close user 11 [9532908] (xxx)


    edit:
    Gave both servers a reboot, and login works fine. Now making a character doesn't...

    DBAgent_24.log:
    [Sun Nov 23 2008 07:38:50.347478 3086382784]: open log file '/var/log/cabal/DBAgent_24.log'
    [Sun Nov 23 2008 07:38:50.347556 3086382784]: LOG LEVEL: 3
    [Sun Nov 23 2008 07:38:50.347579 3086382784]: MemPoolUnitSizeClass(2): 24576Bytes
    [Sun Nov 23 2008 07:38:50.348139 3086382784]: Start DBAgent_24 Server
    [Sun Nov 23 2008 07:38:50.348467 3086382784]: UseEcryptText (Off)
    [Sun Nov 23 2008 07:38:50.348714 3086382784]: try listening 38181 port
    [Sun Nov 23 2008 07:38:50.348861 3086379936]: CProcessLayer(0)::svc Start [3086379936]
    [Sun Nov 23 2008 07:38:50.348929 3075890080]: CProcessLayer(0)::svc Start [3075890080]
    [Sun Nov 23 2008 07:38:50.348976 3065400224]: CProcessLayer(0)::svc Start [3065400224]
    [Sun Nov 23 2008 07:38:50.349020 3054910368]: CProcessLayer(0)::svc Start [3054910368]
    [Sun Nov 23 2008 07:38:50.349080 3044420512]: CProcessLayer(0)::svc Start [3044420512]
    [Sun Nov 23 2008 07:38:50.857208 3086382784]: accept success 8(127.0.0.1:36463)
    [Sun Nov 23 2008 07:38:50.857577 3086382784]: 1.open user 8 [9EE7468] (127.0.0.1)
    [Sun Nov 23 2008 07:38:51.371484 3086382784]: accept success 10(127.0.0.1:36465)
    [Sun Nov 23 2008 07:38:51.371578 3086382784]: 2.open user 10 [9EF5BA8] (127.0.0.1)
    [Sun Nov 23 2008 07:38:54.426372 3065400224]: Database Connect success!
    [Sun Nov 23 2008 07:38:54.452068 3054910368]: Database Connect success!
    [Sun Nov 23 2008 07:38:54.523105 3044420512]: Database Connect success!
    [Sun Nov 23 2008 07:39:51.386864 3086379936]: Database Connect success!
    [Sun Nov 23 2008 07:41:51.378669 3075890080]: Database Connect success!
    [Sun Nov 23 2008 07:41:54.104170 3086379936]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 24)
    [Sun Nov 23 2008 07:41:54.104220 3086379936]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find server 'GAMESERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
    [Sun Nov 23 2008 07:41:54.104238 3086379936]: [##ERROR##] DB ERROR(CODE) : 7202
    [Sun Nov 23 2008 07:41:54.104255 3086379936]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Sun Nov 23 2008 07:41:54.104270 3086379936]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
    [Sun Nov 23 2008 07:41:54.104287 3086379936]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ? , ? , ? , ? )}
    [Sun Nov 23 2008 07:41:54.114956 3086379936]: Database Connect success!
    [Sun Nov 23 2008 07:42:02.068834 3086379936]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 24)
    [Sun Nov 23 2008 07:42:02.068883 3086379936]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find server 'GAMESERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
    [Sun Nov 23 2008 07:42:02.068901 3086379936]: [##ERROR##] DB ERROR(CODE) : 7202
    [Sun Nov 23 2008 07:42:02.068918 3086379936]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Sun Nov 23 2008 07:42:02.068934 3086379936]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
    [Sun Nov 23 2008 07:42:02.068950 3086379936]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ? , ? , ? , ? )}
    [Sun Nov 23 2008 07:42:02.070640 3086379936]: Database Connect success!

    edit:
    Fixed this now, but I still can't make a character..
    Last edited by cypher; 23-11-08 at 03:45 PM. Reason: fixed dbl post.
  8. 23-11-08 #713
    Cath22
    Go go go! Cath22 is offline
    MemberRank
    Aug 2008 Join Date
    Cabal-ArenaLocation
    713Posts

    re: [old] My guides + databases

    Quote Originally Posted by Josh View Post
    My login log just showed this:

    [Sun Nov 23 2008 07:12:22.552572 3078486944]: CProcessLayer(0)::svc Start [3078486944]
    [Sun Nov 23 2008 07:12:22.552640 3078486944]: ServerState changed(0 -> 0)
    [Sun Nov 23 2008 07:19:32.993683 3086788288]: accept success 11(xxx:54832)
    [Sun Nov 23 2008 07:19:32.993819 3086788288]: 1.open user 11 [9532908] (xxx)
    [Sun Nov 23 2008 07:19:33.565030 3078486944]: AuthRequest: UserID(josh), Addr(xxx)
    [Sun Nov 23 2008 07:20:04.830289 3086788288]: 1.close user 11 [9532908] (xxx)


    edit:
    Gave both servers a reboot, and login works fine. Now making a character doesn't...

    DBAgent_24.log:
    [Sun Nov 23 2008 07:38:50.347478 3086382784]: open log file '/var/log/cabal/DBAgent_24.log'
    [Sun Nov 23 2008 07:38:50.347556 3086382784]: LOG LEVEL: 3
    [Sun Nov 23 2008 07:38:50.347579 3086382784]: MemPoolUnitSizeClass(2): 24576Bytes
    [Sun Nov 23 2008 07:38:50.348139 3086382784]: Start DBAgent_24 Server
    [Sun Nov 23 2008 07:38:50.348467 3086382784]: UseEcryptText (Off)
    [Sun Nov 23 2008 07:38:50.348714 3086382784]: try listening 38181 port
    [Sun Nov 23 2008 07:38:50.348861 3086379936]: CProcessLayer(0)::svc Start [3086379936]
    [Sun Nov 23 2008 07:38:50.348929 3075890080]: CProcessLayer(0)::svc Start [3075890080]
    [Sun Nov 23 2008 07:38:50.348976 3065400224]: CProcessLayer(0)::svc Start [3065400224]
    [Sun Nov 23 2008 07:38:50.349020 3054910368]: CProcessLayer(0)::svc Start [3054910368]
    [Sun Nov 23 2008 07:38:50.349080 3044420512]: CProcessLayer(0)::svc Start [3044420512]
    [Sun Nov 23 2008 07:38:50.857208 3086382784]: accept success 8(127.0.0.1:36463)
    [Sun Nov 23 2008 07:38:50.857577 3086382784]: 1.open user 8 [9EE7468] (127.0.0.1)
    [Sun Nov 23 2008 07:38:51.371484 3086382784]: accept success 10(127.0.0.1:36465)
    [Sun Nov 23 2008 07:38:51.371578 3086382784]: 2.open user 10 [9EF5BA8] (127.0.0.1)
    [Sun Nov 23 2008 07:38:54.426372 3065400224]: Database Connect success!
    [Sun Nov 23 2008 07:38:54.452068 3054910368]: Database Connect success!
    [Sun Nov 23 2008 07:38:54.523105 3044420512]: Database Connect success!
    [Sun Nov 23 2008 07:39:51.386864 3086379936]: Database Connect success!
    [Sun Nov 23 2008 07:41:51.378669 3075890080]: Database Connect success!
    [Sun Nov 23 2008 07:41:54.104170 3086379936]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 24)
    [Sun Nov 23 2008 07:41:54.104220 3086379936]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find server 'GAMESERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
    [Sun Nov 23 2008 07:41:54.104238 3086379936]: [##ERROR##] DB ERROR(CODE) : 7202
    [Sun Nov 23 2008 07:41:54.104255 3086379936]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Sun Nov 23 2008 07:41:54.104270 3086379936]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
    [Sun Nov 23 2008 07:41:54.104287 3086379936]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ? , ? , ? , ? )}
    [Sun Nov 23 2008 07:41:54.114956 3086379936]: Database Connect success!
    [Sun Nov 23 2008 07:42:02.068834 3086379936]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 24)
    [Sun Nov 23 2008 07:42:02.068883 3086379936]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find server 'GAMESERVER' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
    [Sun Nov 23 2008 07:42:02.068901 3086379936]: [##ERROR##] DB ERROR(CODE) : 7202
    [Sun Nov 23 2008 07:42:02.068918 3086379936]: [##ERROR##] DB ERROR(VAR_INFO) :
    [Sun Nov 23 2008 07:42:02.068934 3086379936]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
    [Sun Nov 23 2008 07:42:02.068950 3086379936]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ? , ? , ? , ? )}
    [Sun Nov 23 2008 07:42:02.070640 3086379936]: Database Connect success!

    edit:
    Fixed this now, but I still can't make a character..
    try to check your LINKSERVERS string and odbc.ini
  9. 23-11-08 #714
    Jeffijoe
    Om Nom Nom Nom Jeffijoe is offline
    MemberRank
    Jun 2008 Join Date
    CodeGear DelphiLocation
    364Posts

    re: [old] My guides + databases

    Everything is working for me. I have had tons of errors, but Chumpy and Dordort helped me out alot of times.. Now, Im just looking for Add-Ons xD
  10. 23-11-08 #715
    Josh
    Ex Post Whore Josh is offline
    MemberRank
    Dec 2004 Join Date
    8,333Posts

    re: [old] My guides + databases

    Quote Originally Posted by Cath22 View Post
    try to check your LINKSERVERS string and odbc.ini
    I fixed all the errors in the logs and no errors show up. Just can't seem to make a character.
  11. 23-11-08 #716
    Advocate
    Account Upgraded | Title Enabled! Advocate is offline
    MemberRank
    Jun 2006 Join Date
    Perfect World - Yaoshous the AwakeningLocation
    1,453Posts

    re: [old] My guides + databases

    Quote Originally Posted by Josh View Post
    I fixed all the errors in the logs and no errors show up. Just can't seem to make a character.
  12. 23-11-08 #717
    Josh
    Ex Post Whore Josh is offline
    MemberRank
    Dec 2004 Join Date
    8,333Posts

    re: [old] My guides + databases

    Quote Originally Posted by Advocate View Post
    “unknown DB errors” creating characters
    You have bad linked server settings.http://forum.ragezone.com/3765659-post2.html
    Sorry for being noob.

    I think i've figured it out, using this I can view the tables in the linked server in MSSQL 2000, but I still can't make a character.

    got it to work, did the linked servers and gave it a reboot. thanks for your help.
  13. 23-11-08 #718
    Pffi
    Member Pffi is offline
    MemberRank
    Jan 2007 Join Date
    USALocation
    62Posts

    re: [old] My guides + databases

    Ok I fixed the previous error, thank you both....

    I've created an ID with pw and I still cannot connect. I put in the external.txt the same IP I also setuped in chumpys server config script.

    I start client and the login bar's just passing by... till it says unable to connect. It probably didn't even get any response to the server, or didn't even try to connect... what am I doing wrong? I did all written in the guide and sucessfull completed all the steps... and it doesn't work :(

    Any ideas? Thanks in advance.
  14. 23-11-08 #719
    Josh
    Ex Post Whore Josh is offline
    MemberRank
    Dec 2004 Join Date
    8,333Posts

    re: [old] My guides + databases

    Quote Originally Posted by Pffi View Post
    Ok I fixed the previous error, thank you both....

    I've created an ID with pw and I still cannot connect. I put in the external.txt the same IP I also setuped in chumpys server config script.

    I start client and the login bar's just passing by... till it says unable to connect. It probably didn't even get any response to the server, or didn't even try to connect... what am I doing wrong? I did all written in the guide and sucessfull completed all the steps... and it doesn't work :(

    Any ideas? Thanks in advance.
    What does log give you?


    How do I make my character a manager?
  15. 23-11-08 #720
    Pffi
    Member Pffi is offline
    MemberRank
    Jan 2007 Join Date
    USALocation
    62Posts

    re: [old] My guides + databases

    ups sry ..


« Previous Thread | Next Thread »

Advertisement