[HOW-TO] Setup 9.1

Page 23 of 29

01/17/2017 16:13 brkhnsvr94#331

Umm.. Actually the problem is button for equipment. When I press it with my wings or unless them, result is same. Freezing..Its a general problem with my server. There is a issue with my db but what..? So I want to record a video about my problem to explain it detailed. Maybe opt files demaged or configured incorrect. So I want to share them with you.
Here is youtube link: [Only registered and activated users can see links. Click Here To Register...]

GameServer.opt

Spoiler

auth.opt

Spoiler

common.opt

Spoiler

01/17/2017 18:27 ThunderNikk#332

I think the issue is with your client because I am using the same database files and an .opt file would only cause freezes if you have set it to log.

I do not have the equipment issue which is why I think it is client mismatch.

01/17/2017 22:52 brkhnsvr94#333

I tried this 9.1 client also. But problem is still exist. I think, as you mentioned the problem is client and db mismatch. Because the arcadia db is backuping some files after I pushed the equipt button. There was a text file in the game_bin like this:

Spoiler

Can you please share with me your db files?

01/17/2017 23:27 ThunderNikk#334

I have the same DB files. I have already told you this about 3 times.

Everyone has the same 9.1 files.

That's why I think it is your client. You go ahead and keep trying to find different 9.1 files though.

01/18/2017 00:08 brkhnsvr94#335

I've tried 4 different 9.1 clients .. Every client gave me the same print. So there must be some missing columns or rows in my db I think. Cause the print of my issue is giving me this kind of warnings on text file: DB_UpdateCharacterHideEquipFlag(dbo.smp_update_cha racter_hide_equip_flag.. If its possible can you share with me your client? I want to try this way..

01/18/2017 01:22 ThunderNikk#336

My client...

[Only registered and activated users can see links. Click Here To Register...]

01/18/2017 02:18 brkhnsvr94#337

Here is my problem with sql ... not with client.

Spoiler

EDIT: Tried 5 different 9.1 clients.

01/18/2017 03:54 ThunderNikk#338

Have you tried it after you have equipped deco items.

In you video you have nothing to show or hide yet.

I tried stripping my character of deco items and using the button and mine still works, I am just not understanding how you have an issue with the smp and I don't with the same exact server files.

The following is my smp though if it helps...

Code:

USE [Telecaster]
GO

/****** Object:  StoredProcedure [dbo].[smp_update_character_hide_equip_flag]    Script Date: 1/17/2017 9:52:09 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- start of smp_update_character_hide_equip_flag
CREATE PROCEDURE [dbo].[smp_update_character_hide_equip_flag]
@IN_SID					INT,
@IN_HIDE_EQUIP_FLAG		INT
AS
SET NOCOUNT ON

UPDATE dbo.Character SET hide_equip_flag = @IN_HIDE_EQUIP_FLAG WHERE sid = @iN_SID

-- end of smp_update_character_hide_equip_flag

GO

You do have an sid column in your telecaster character table don't you?

01/18/2017 12:09 brkhnsvr94#339

Yes I've tried 2 options. With deco items and without deco items. Both of them has given same result. I tried this query but not worked: Must declare the scalar variable "@iN_SID".
And also I have sid column in my table. There is no reason to not work.. But problem is still exist. Maybe I need to try another Telecaster backup. I'll search for this.. Can you back up your Telecaster db for me?

Note: I'm afraid and ashamed to want something from you.. Because you had a lot of work with me.. So you don't have to help me ..

EDIT: Problem is not telecaster db .. god .. what the hell is this problem???...

Here is my character table script:

Spoiler

01/18/2017 21:41 Azbeen#340

Hello, when I start my "CaptainHerlockServer" he told me this :

"2017-01-18 21:30:22 Network initialize... ok

2017-01-18 21:30:22 IOCP initialize... ok

2017-01-18 21:30:22 Starting IOCP thread pool... ok

2017-01-18 21:30:22 LUA initialize... ok

2017-01-18 21:30:22 Launching ARCADIA... ok

2017-01-18 21:30:22 Start loading...

2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Sp�cification de permission non valide

2017-01-18 21:32:35 cannot connect log server: ip: 127.0.0.1, port: 4516

2017-01-18 21:32:35 cannot connect log server: ip: 127.0.0.1, port: 4516"

I have 0 error on my "RappelzServerAuth"

Do you have an idea please ?

01/19/2017 08:49 shiuyh2#341

Quote:

Originally Posted by Azbeen

Hello, when I start my "CaptainHerlockServer" he told me this :

"2017-01-18 21:30:22 Network initialize... ok

2017-01-18 21:30:22 IOCP initialize... ok

2017-01-18 21:30:22 Starting IOCP thread pool... ok

2017-01-18 21:30:22 LUA initialize... ok

2017-01-18 21:30:22 Launching ARCADIA... ok

2017-01-18 21:30:22 Start loading...

2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Sp�cification de permission non valide

2017-01-18 21:32:35 cannot connect log server: ip: 127.0.0.1, port: 4516

2017-01-18 21:32:35 cannot connect log server: ip: 127.0.0.1, port: 4516"

I have 0 error on my "RappelzServerAuth"

Do you have an idea please ?

I'm having the same issue, read through all of the pages and tried all i could think of with no luck.

01/19/2017 10:38 SilentWisdom#342

Quote:

Originally Posted by shiuyh2

I'm having the same issue, read through all of the pages and tried all i could think of with no luck.

2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Sp�cification de permission non valide

I don't speak french and I can still see your problem.

The login you specified for your Telecaster/Arcadia does not have permission to read.

01/19/2017 18:48 shiuyh2#343

Quote:

Originally Posted by SilentWisdom

2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Sp�cification de permission non valide

I don't speak french and I can still see your problem.

The login you specified for your Telecaster/Arcadia does not have permission to read.

So i got up and went from the start again, the only issue I seem to be having now is with my CaptainHerlockServer. It will load all the way up to:

"Network initialize... ok
IOCP initialize... ok
Starting IOCP thread pool... ok
LUA initialize... ok
Launching ARCADIA... ok
Loading max item index... (1) ok"

At this point I get an error that "Game Server has stopped working" and the program closes.

This is my 1st server setup and any help would be appreciated!

01/20/2017 19:23 Azbeen#344

Quote:

Originally Posted by SilentWisdom

2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Sp�cification de permission non valide

I don't speak french and I can still see your problem.

The login you specified for your Telecaster/Arcadia does not have permission to read.

Hey, hmm my Telecaster / Arcadia have the permissions for read.. So.. Do you have an other idea ?

01/20/2017 20:25 ThunderNikk#345

You either did not set up user permissions correctly in the database, or you defined your users incorrectly in the .opt files.

If it is not your database then maybe it is your .opt file.

Page 23 of 29

« First

Last »