My guides + databases + server files repack -V2!

Printable View

Show 100 post(s) from this thread on one page

23-11-08
Josh

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
23-11-08
Cath22

re: [old] My guides + databases

its just a glitch
simply

type in after that service cabal start
23-11-08
chumpywumpy

re: [old] My guides + databases

Quote:

Originally Posted by neutonsp

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?

http://img209.imageshack.us/img209/773/imagem1dw1.jpg

http://img376.imageshack.us/img376/8148/imagem2zb8.jpg

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

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.
23-11-08
Josh

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.
23-11-08
chumpywumpy

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.
23-11-08
mav3r1cksandy

re: [old] My guides + databases

Quote:

Originally Posted by Pffi

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
23-11-08
Josh

Quote:

Originally Posted by chumpywumpy

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.. :blink:

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..
http://www.freeimagehosting.net/uploads/6e51693429.jpg
23-11-08
Cath22

re: [old] My guides + databases

Quote:

Originally Posted by Josh

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..
http://www.freeimagehosting.net/uploads/6e51693429.jpg

try to check your LINKSERVERS string and odbc.ini
23-11-08
Jeffijoe

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
23-11-08
Josh

re: [old] My guides + databases

Quote:

Originally Posted by Cath22

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. :ehh:
23-11-08
Advocate

re: [old] My guides + databases

Quote:

Originally Posted by Josh

I fixed all the errors in the logs and no errors show up. Just can't seem to make a character. :ehh:
23-11-08
Josh

re: [old] My guides + databases

Quote:

Originally Posted by Advocate

“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.
23-11-08
Pffi

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.
23-11-08
Josh

re: [old] My guides + databases

Quote:

Originally Posted by Pffi

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?
23-11-08
Pffi

re: [old] My guides + databases

ups sry ..

Show 100 post(s) from this thread on one page