Welcome to RaGEZONE - MMORPG Development Forums (sponsored by tfn.gr) Mark forums read | View Forum Leaders
RaGEZONE - MMORPG Development Forums (sponsored by tfn.gr)
Register Members Blogs Chat
Quick Login:

Cabal Tutorials Discuss, [dead] My guides + databases + server files repack -V2! at Cabal Online forum; I now finally could bring my server to run, but tbh iam stuck at account registration... I read about 18 ...


> MMORPG Server Files > Server Developments > Cabal Online > Cabal Tutorials » [dead] My guides + databases + server files repack -V2!


Closed Thread
Page 29 of 30 « First < 192122232425262728 29 30 >
Thread Tools
[dead] My guides + databases + server files repack -V2!
 
 
Average Member

Rank: Omicron


 
Join Date: Jan 2007
Location: USA
Posts: 59
 11-21-2008, 07:02 PM
 
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
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 :(
 
 
permalink
 

 
Banned
bmn23's Avatar

Status: Banned


 
Join Date: Oct 2008
Location: C:\WINDOWS\System32
Posts: 18
 11-22-2008, 05:05 PM
 
Wow... many people are getting errors with the server it self...
My problem is the guide! o.O
I can't read the PDF-Files because there are only very strange symbols instead of a text...
Anybody knows how to fix this?
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
 11-22-2008, 06:04 PM
 
Quote: Originally Posted by devn142 View Post
Hey Chumpy

I used your Server files to setup cabal server....

I was trying to add more Channels in Mercury server... So i followed the Darkly guide to add channel

I did exactly same as given in the guide but when i run the server...... it is not showing any Channel to select.....

What should i do????
Adding channels requires quite a few edits and getting even 1 wrong will mean it won't work and the guides i have seen are not complete. Writing a guide on adding channels is too tricky to do as various parts of the config would only work with specific combinations and any guide would only work for some people. Unless you know exactly how a multi-channel config works i don't recommend you do it by hand, use the config script and pick a template that is closest to what you want. If you need a specific layout then let me know and i can add a template for it.

Quote: Originally Posted by BloodLineLimit View Post
Hey Chumpy , i need help , when i did what you followed after i press the LinkedServer thing , they say cant connect to the server, do you still want to keep the server?
You got one of the values wrong for your network. Use the windows IP instead of "localhost" in the connection string as that is the usual problem that causes that type of error.

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
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 :(
It is better to execute "exec cabal_tool_registerAccount 'user', 'pass'" on the account db from a query window in mssql 2005. NULL errors registering accounts are always xp_md5 not working properly though.

On your account db run "select dbo.fn_md5('test')" in a query window. If you get a NULL back instead of a password hash then xp_md5 isn't working. Check it's entry in the extended procedures folder of the "master" database to make sure the path to the dll is correct and that it's permissions allow the server to access it.

Quote: Originally Posted by bmn23 View Post
Wow... many people are getting errors with the server it self...
My problem is the guide! o.O
I can't read the PDF-Files because there are only very strange symbols instead of a text...
Anybody knows how to fix this?
I have had 1 other person say this. What version of Acrobat Reader do you use? You will need the latest version for my guides.
 
 
permalink
 

 
Banned
bmn23's Avatar

Status: Banned


 
Join Date: Oct 2008
Location: C:\WINDOWS\System32
Posts: 18
 11-22-2008, 06:28 PM
 
Well, i'm not using Adobe Acrobat... =D
I'm going to try this... ^^
 
 
permalink
 

 
Member

Rank: Omicron


 
Join Date: Apr 2006
Location: Brasil
Posts: 47
 11-23-2008, 04:11 AM
 
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
 
 
permalink
 

 
Ex Post Whore
Josh's Avatar

Rank: Omega


 
Join Date: Dec 2004
Posts: 9,248
 11-23-2008, 07:22 AM
 
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
 
 
permalink
 

 
Rock ON Cabal
Cath22's Avatar

Rank: Member


Blog Entries: 1
 
Join Date: Aug 2008
Location: cabalpilipinas....
Posts: 232
 11-23-2008, 07:26 AM
 
its just a glitch
simply

type in after that service cabal start
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
 11-23-2008, 11:35 AM
 
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.
 
 
permalink
 

 
Ex Post Whore
Josh's Avatar

Rank: Omega


 
Join Date: Dec 2004
Posts: 9,248
 11-23-2008, 12:14 PM
 
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.
 
 
permalink
 

 
Certified PBKAC

Rank: Moderator


 
Join Date: Jun 2008
Location: 2 clouds to your right
Posts: 1,647
 11-23-2008, 01:40 PM
 
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.
 
 
permalink
 

 
Newbie

Rank: Omicron


 
Join Date: Aug 2006
Posts: 22
 11-23-2008, 02:04 PM
 
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
 
 
permalink
 

 
Ex Post Whore
Josh's Avatar

Rank: Omega


 
Join Date: Dec 2004
Posts: 9,248
 11-23-2008, 02:17 PM
 
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; 11-23-2008 at 03:45 PM. Reason: fixed dbl post.
 
 
permalink
 

 
Rock ON Cabal
Cath22's Avatar

Rank: Member


Blog Entries: 1
 
Join Date: Aug 2008
Location: cabalpilipinas....
Posts: 232
 11-23-2008, 03:06 PM
 
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
 
 
permalink
 

 
Monster Member
Jeffijoe's Avatar

Rank: New Blood


 
Join Date: Jun 2008
Location: The Milkroad
Posts: 193
 11-23-2008, 03:18 PM
 
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
 
 
permalink
 

 
Ex Post Whore
Josh's Avatar

Rank: Omega


 
Join Date: Dec 2004
Posts: 9,248
 11-23-2008, 03:23 PM
 
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.
 
 
permalink
 

 
SecretSquirrel
Advocate's Avatar

Rank: Member


 
Join Date: Jun 2006
Location: Perfect World - Yaoshous the Awakening
Posts: 1,475
 11-23-2008, 03:29 PM
 
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.
“unknown DB errors” creating characters
You have bad linked server settings.[Only Registered and Activated Users Can See Links. Click Here To Register...]
 
 
permalink
 

 
Ex Post Whore
Josh's Avatar

Rank: Omega


 
Join Date: Dec 2004
Posts: 9,248
 11-23-2008, 03:55 PM
 
Quote: Originally Posted by Advocate View Post
“unknown DB errors” creating characters
You have bad linked server settings.[Only Registered and Activated Users Can See Links. Click Here To Register...]
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.
 
 
permalink
 

 
Average Member

Rank: Omicron


 
Join Date: Jan 2007
Location: USA
Posts: 59
 11-23-2008, 05:40 PM
 
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.
 
 
permalink
 

 
Ex Post Whore
Josh's Avatar

Rank: Omega


 
Join Date: Dec 2004
Posts: 9,248
 11-23-2008, 05:41 PM
 
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?
 
 
permalink
 

 
Average Member

Rank: Omicron


 
Join Date: Jan 2007
Location: USA
Posts: 59
 11-23-2008, 05:42 PM
 
ups sry ..
 
 
permalink
 

 
Ex Post Whore
Josh's Avatar

Rank: Omega


 
Join Date: Dec 2004
Posts: 9,248
 11-23-2008, 05:45 PM
 
Quote: Originally Posted by Pffi View Post
ehm sry this dumb question but where's the log located?
The logs are in /var/log/cabal in the centos machine.
 
 
permalink
 

 
Average Member

Rank: Omicron


 
Join Date: Jan 2007
Location: USA
Posts: 59
 11-23-2008, 06:01 PM
 
Fixed some error's in log, now it looks like this, seems to be fine, but still, I can't connect, still the same problem :(
It seems like the client doesn't even connect to the server ... log doesn't change at all, no matter if I try to login. I tried alot IP's (wan, local and such) and nothing works.... any advice? Thanks in advance.
Sry I didn't know which log caus