Tutorials for EP8 Server Files

mattu · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

I'm waiting for a miracle. "TDP" , "Other.vdmk" , I'm try two times same error .

Code:

[Fri Jan 25 2013 13:33:27.730051 3086321360]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Fri Jan 25 2013 13:33:27.730232 3086321360]: [##ERROR##] DB ERROR(CODE)     : 20009
[Fri Jan 25 2013 13:33:27.730256 3086321360]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Fri Jan 25 2013 13:33:27.730275 3086321360]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Fri Jan 25 2013 13:33:27.730294 3086321360]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Fri Jan 25 2013 13:33:27.730313 3086321360]: [##ERROR##] Database Connect Fail ((null))
[Fri Jan 25 2013 13:33:27.730360 3086321360]: [##ERROR##] check 'pDB' fail
[Fri Jan 25 2013 13:33:27.730381 3086321360]: [##ERROR##] 'DungeonRankingSchedule' fail (Proc/DungeonRanking.cpp:138)
[Fri Jan 25 2013 13:33:27.730412 3086321360]: try listening 38181 port

ERROR #2:
[##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.

FIX/SOLUTION #2:
This means the server (CentOS) cannot connect to MSSQL database (Windows).
For testing purposes, temporarily stop iptables in your server (CentOS) and disable the windows firewall 'til you get all working.

Make sure your MSSQQL database user and password matches the ones you set in your server "ini" (AuthDBAgent.ini, CashDBAgent.ini, DBAgent.ini, EventDBAgent.ini, GlobalDBAgent.ini and PCBangDBAgent.ini).

DBId = (your database user name) and DBPwd = (your database password).

Don't forget to double check your odbc.ini (as posted by walkernight88) settings as well and don't rush make sure of everything.

mu6020 · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

Lazy said:
[root@localhost ~]# service cabal status
AuthDBAgent (pid 4091) is opgestart...
RockAndRollITS (pid 4162) is opgestart...
DBAgent_01 (pid 4060) is opgestart...
GlobalDBAgent (pid 4127) is opgestart...
GlobalMgrSvr (pid 4188) is opgestart...
ChatNode_01 (pid 4369) is opgestart...
CashDBAgent (pid 4214) is opgestart...
PCBangDBAgent (pid 4249) is opgestart...
EventDBAgent (pid 4282) is opgestart...
EventMgrSvr (pid 4343) is opgestart...
AgentShop_01 is gestopt
LoginSvr_01 (pid 4455) is opgestart...
PartySvr_01 (pid 4317) is opgestart...
WorldSvr_01_01 is gestopt

Whit that startup script 2 dont work
chatnode & worldsvr :s

wtf... just cant get it working, i put up an ep2 server in 15min.. :S

already tried to connect manually?
service AgentShop_01 start ....
service WorldSvr_01_01 start

th1nk · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

Invalid object name 'dbo.cabal_addgmip'. how to fix?

Extornia said:

SIMP cabal version info:

client_version=369
NormalClientMagicKey=543957823

How to become GM ingame:
Go to db Account create procedure

Code:

USE [Account]
GO
/****** Object:  StoredProcedure [dbo].[cabal_addgmip]    Script Date: 01/24/2013 07:13:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_addgmip] (@fromip VARCHAR(15), @toip VARCHAR(15) = @fromip) AS
BEGIN
    DECLARE @IP1 VARCHAR(15), @IP2 VARCHAR(15)

    SET @IP1 = 
        (
          CAST( PARSENAME( @fromIP, 4 ) AS BIGINT ) * 16777216 +
          CAST( PARSENAME( @fromIP, 3 ) AS BIGINT ) * 65536 +
          CAST( PARSENAME( @fromIP, 2 ) AS BIGINT ) * 256 +
          CAST( PARSENAME( @fromIP, 1 ) AS BIGINT )
        ) 

    SET @IP2 = 
        (
          CAST( PARSENAME( @toIP, 4 ) AS BIGINT ) * 16777216 +
          CAST( PARSENAME( @toIP, 3 ) AS BIGINT ) * 65536 +
          CAST( PARSENAME( @toIP, 2 ) AS BIGINT ) * 256 +
          CAST( PARSENAME( @toIP, 1 ) AS BIGINT )
        ) 

    IF @IP1 = @IP2
        BEGIN
        INSERT INTO cabal_GM_ip_table (fromip, toip) VALUES (@IP1, @IP2)
        END
    ELSE IF @IP1 <> @IP2
        BEGIN
        INSERT INTO cabal_GM_ip_table (fromip, toip) VALUES (@IP1, @IP2)
        END
END
SET NOCOUNT OFF

Then do exec cabal_addgmip 'YOURIP'

Then go to Server01 DB - cabal_character_table find your character change nation to 3

For MSSQL enable named pipes in MSSQL configuration for MSSQLSERVER instance, and install as Chinese_PRC (accent sensitive)

To send items ingame exec on cabalcash

Code:

exec up_AddMyCashItemByItem 'ACCOUNTID','0','SERVERID','ITEMID','ITEMOPTION','DURATIONID'

PwrDex · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

th1nk said:
Invalid object name 'dbo.cabal_addgmip'. how to fix?

ALTER PROCEDURE -> changeto CREATE PROCEDURE!

dragonrojo · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

again problem only problem are centos , centos ,centos **** centos

nuevo problema - Tutorials for EP8 Server Files - RaGEZONE Forums

Lazy · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

mu6020 said:
already tried to connect manually?
service AgentShop_01 start ....
service WorldSvr_01_01 start

yeah did.

now i found this, and seems to work all running no errors, just my event procedure, i deleted it
Could anyone post the event procedure whit fixed lines?

Code:

[COLOR=#333333]service iptables stop
[/COLOR]sleep 3
service DBAgent_01 start
sleep 3
service AuthDBAgent start
sleep 3
service GlobalDBAgent start
sleep 3
service RockAndRollITS start
sleep 3
service GlobalMgrSvr start
sleep 3
service CashDBAgent start
sleep 3
service PCBangDBAgent start
sleep 3
service EventDBAgent start
sleep 3
service PartySvr_01 start
sleep 5
service EventMgrSvr start
sleep 3
service ChatNode_01 start
sleep 3
service AgentShop_01 start
sleep 3
service WorldSvr_01_01 start
sleep 3
service LoginSvr_01 start
sleep 3

so if someone could post to create that event procedure again whit fixed lines, would be gratefull, now i just need to find a way to connect whit theftgames client to my server..

slawdos · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

dragonrojo said:
again problem only problem are centos , centos ,centos **** centos View attachment 122173

Dude, search in google root, sudo and RTFM!

kaisen · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

kaisen said:
trying now to connect to the server since 10h and i rly dont get whats the problem
odbc.ini got mysql ips
inis got localhost ip/mysql pws/user
IgnoreClientVersion=1 in login server
on Worldsvr.ini 3x centos ip(lan) like this:
AddrForClient=192.168.0.20
AddrForServer=127.0.0.1

every time i hit ok on the client there is just nothing happening(not even an auth try)
using bat+item.enc+internal
mysql can ping centos, centos can ping mysql

still couldnt pass the login screen, looks like my client cant connect the login server...
anyone got a idea?

here are my logs and inis, would be awsome if u could take a look at it(using only lan)
View attachment 122161 View attachment 122164

Extornia · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

AkiSora said:
ALTER PROCEDURE -> changeto CREATE PROCEDURE!

That was quite the failure on my part...

schneemann101 · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

#edit

mattu · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

dragonrojo said:
again problem only problem are centos , centos ,centos **** centos View attachment 122173

vi /etc/sudoers
find this line "root ALL=(ALL) ALL" and after this line add this:
dragonrojo ALL=(ALL) ALL

note: You must be root to edit this file.

deezad · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

How to coppy this code?

-Now copy these files into centos
-Type into console:
Code:
service cabal stop
wait until all finished and again:
Code:
service cabal stop
and if finished than write:
Code:
service cabal start

Where is it? :?:

schneemann101 · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

@AkiSora
a Changelog of your first post would be nice

than all can check what did you change

)

VizesLufi · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

Hello Guys! Any1 know what my problems? Cuz i didnt know how to fix that i already tried all configs and all tutorials but same here!

A(z) AuthDBAgent (pid: 4441) running
A(z) RockAndRollITS (pid: 4468) running
A(z) DBAgent_01 (pid: 4485) running
A(z) GlobalDBAgent (pid: 4506) running
A(z) GlobalMgrSvr (pid: 4532) running
A(z) ChatNode_01 stopped
A(z) CashDBAgent (pid: 4573) running
A(z) PCBangDBAgent (pid: 4599) running
A(z) EventDBAgent (pid: 4623) running
A(z) EventMgrSvr stopped
A(z) AgentShop_01 stopped
A(z) LoginSvr_01 stopped
A(z) PartySvr_01 (pid: 4886) running
A(z) WorldSvr_01_01 stopped
A(z) WorldSvr_01_02 stopped
A(z) WorldSvr_01_03 (pid: 5638 5629) running
A(z) WorldSvr_01_04 stopped
A(z) WorldSvr_01_05 stopped
A(z) WorldSvr_01_06 stopped

Here is my logs:

To view the content, you need to sign in or register

Thanks For Helping if you know what my problem...

EDIT: Already Fixed the problem...

Lazy · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

in DBAgent_01 you will have CabalGame01 change to SERVER01
same in ODBC.ini change Titel and dsn there to SERVER01

then do "Service cabal stop"
after past this in the terminal..

Code:

service DBAgent_01 start
sleep 3
service AuthDBAgent start
sleep 3
service GlobalDBAgent start
sleep 3
service RockAndRollITS start
sleep 3
service GlobalMgrSvr start
sleep 3
service CashDBAgent start
sleep 3
service PCBangDBAgent start
sleep 3
service EventDBAgent start
sleep 3
service PartySvr_01 start
sleep 5
service EventMgrSvr start
sleep 3
service ChatNode_01 start
sleep 3
service AgentShop_01 start
sleep 3
service WorldSvr_01_01 start
sleep 3
service LoginSvr_01 start
sleep 3

worked for me.

now i got 1 more problem left, and that is connecting to the server, just aint working.

EDIT: Nvm i can connect whit SIMP client.

VizesLufi · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

I have another Problem with that... I can login now but i can't see any channels! anyone know that what my problem?

killasoundx · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

it would be very nice if u can add a tut or guide how to make a free homepage with free domain to create accounts.. for example with xampp

allocen · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

@Lazy, you use wrong main, use cabal machine client for fully 100% synced packets client <-> server.

Extornia · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

allocen said:
@Lazy, you use wrong main, use cabal machine client for fully 100% synced packets client <-> server.

SIMP/TG/MYSTERY/MACHINE all use exactly same client, all a day between compiling. Just fyi.

VizesLufi · Jan 25, 2013

Re: Tutorials for EP8 Server Files (DETAILED)

Okey guys i have another problem i can login but i cant see any channels how can i fix that?

:/

Tutorials for EP8 Server Files

Newbie Spellweaver

🚫

Socius Decennalis

Cabal is a virus!

Newbie Spellweaver

Junior Spellweaver

Junior Spellweaver

Newbie Spellweaver

Elite Diviner

Socius Decennalis

Newbie Spellweaver

Socius Decennalis

Socius Decennalis

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Initiate Mage

┌П┐(•_•)┌П┐

Elite Diviner

Newbie Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners