[Help]Cannot connect to gameserver

[SpeedDevil]

I'm using the EP4 files adapted to work with C:\
Everything runs green and in GameGroups01 I've set the public IP to the hamachi IP.
On my main machine I've got a client from a current private server and pasted the EP4 decrypted .sdata files, hexed the correct hamachi IP.
The game runs and I can log in but when I select the server to play on the game tells me it can't connect to the gameserver.

Did I forget to put the correct IP's on some places? Or am I using the wrong client?

EDIT: Where the hell are the server logs?

Thx,
Speedy

 

[Twilight]

I'm using the EP4 files adapted to work with C:\
Everything runs green and in GameGroups01 I've set the public IP to the hamachi IP.
On my main machine I've got a client from a current private server and pasted the EP4 decrypted .sdata files, hexed the correct hamachi IP.
The game runs and I can log in but when I select the server to play on the game tells me it can't connect to the gameserver.

Did I forget to put the correct IP's on some places? Or am I using the wrong client?

EDIT: Where the hell are the server logs?

Thx,
Speedy

Check IP on ports -

You must be registered to see links

login - port 30800 - protocol - TCP
game -port 30810 - protocol TCP
session - port 30900 - protocol TCP
userlog - port 30901 - protocol TCP
dbagent - port 30911 - protocol TCP
gamelog - port 30912 - protocol TCP
Psmagent - port 40900 - protocol TCP
connectionManager - port 1060 - protocol TCP
dbagent2 - port 1056 - protocol TCP
gamelog - port 1072 - protocol TCP

All logs in
PSM_Client\Bin\Log\*.log

 

[SpeedDevil]

Check IP on ports -

You must be registered to see links

login - port 30800 - protocol - TCP
game -port 30810 - protocol TCP
session - port 30900 - protocol TCP
userlog - port 30901 - protocol TCP
dbagent - port 30911 - protocol TCP
gamelog - port 30912 - protocol TCP
Psmagent - port 40900 - protocol TCP
connectionManager - port 1060 - protocol TCP
dbagent2 - port 1056 - protocol TCP
gamelog - port 1072 - protocol TCP

All logs in
PSM_Client\Bin\Log\*.log

The whole concept of hamachi is to not have to open em. But will try.
The logs don't show anything that a user passed login but failed game server connection ... hmz
Where do you put the necessary ip's for public use?

EDIT: Server runs in virtual box (didn't want to mess up my cabal database :/ )
EDIT2: ports didn't help :/ I noticed if I changed the name of the server in the server patch config from Gaia to something else, after restarting and going ingame it's still called Gaia ...

 

[Twilight]

Use any scanner to check the open ports. Ports must be available for other players.
To change the server name should be in multiple files INI change Gaia for the necessary



If you need to see the real state of connections that use a sniffer for connections ...
FOR SQL connection and execution use SQL Profiler

 

[SpeedDevil]

Alright ports were not the problem. I checked the .ini's and they didn't update, I always got a message "Update Disable".

I managed to log in, chose faction, crashed to desktop, booted up, and at character creation every name is in use, sounds like DB issues?

2010-08-18 11:39:14 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Er is een fout opgetreden bij het converteren van het gegevenstype varchar naar datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-08-18 11:39:14 ::CreateCharacter 9 Speedy retVal=-1, qerr=-1, {?=call Usp_Save_Char_Item_Add_E(9,3036756343169024001, 0,5, 12006,12,6, 1200, 0,0,0,0,0,0, '±âº»¾ÆÀÌÅÛ',1,'2010-08-18 11:39:14','S')}

2010-08-18 11:39:14 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2010-08-18 11:39:22 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Er is een fout opgetreden bij het converteren van het gegevenstype varchar naar datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-08-18 11:39:22 ::CreateCharacter 10 SpeedDevil retVal=-1, qerr=-1, {?=call Usp_Save_Char_Item_Add_E(10,3036756373233795073, 0,5, 12006,12,6, 1200, 0,0,0,0,0,0, '±âº»¾ÆÀÌÅÛ',1,'2010-08-18 11:39:21','S')}

2010-08-18 11:39:22 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2010-08-18 11:39:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Er is een fout opgetreden bij het converteren van het gegevenstype varchar naar datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-08-18 11:39:27 ::CreateCharacter 11 zoemg retVal=-1, qerr=-1, {?=call Usp_Save_Char_Item_Add_E(11,3036756399003598849, 0,5, 12006,12,6, 1200, 0,0,0,0,0,0, '±âº»¾ÆÀÌÅÛ',1,'2010-08-18 11:39:27','S')}

2010-08-18 11:39:27 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

Er is een fout opgetreden bij het converteren van het gegevenstype varchar naar datetime. = There occured an error in converting the datatype varchar to datetime. is he trying to input a name in a date??

 

[Twilight]

Alright ports were not the problem. I checked the .ini's and they didn't update, I always got a message "Update Disable".

I managed to log in, chose faction, crashed to desktop, booted up, and at character creation every name is in use, sounds like DB issues?

2010-08-18 11:39:14 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Er is een fout opgetreden bij het converteren van het gegevenstype varchar naar datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-08-18 11:39:14 ::CreateCharacter 9 Speedy retVal=-1, qerr=-1, {?=call Usp_Save_Char_Item_Add_E(9,3036756343169024001, 0,5, 12006,12,6, 1200, 0,0,0,0,0,0, '±âº»¾ÆÀÌÅÛ',1,'2010-08-18 11:39:14','S')}

2010-08-18 11:39:14 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2010-08-18 11:39:22 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Er is een fout opgetreden bij het converteren van het gegevenstype varchar naar datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-08-18 11:39:22 ::CreateCharacter 10 SpeedDevil retVal=-1, qerr=-1, {?=call Usp_Save_Char_Item_Add_E(10,3036756373233795073, 0,5, 12006,12,6, 1200, 0,0,0,0,0,0, '±âº»¾ÆÀÌÅÛ',1,'2010-08-18 11:39:21','S')}

2010-08-18 11:39:22 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2010-08-18 11:39:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Er is een fout opgetreden bij het converteren van het gegevenstype varchar naar datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-08-18 11:39:27 ::CreateCharacter 11 zoemg retVal=-1, qerr=-1, {?=call Usp_Save_Char_Item_Add_E(11,3036756399003598849, 0,5, 12006,12,6, 1200, 0,0,0,0,0,0, '±âº»¾ÆÀÌÅÛ',1,'2010-08-18 11:39:27','S')}

2010-08-18 11:39:27 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

Er is een fout opgetreden bij het converteren van het gegevenstype varchar naar datetime. = There occured an error in converting the datatype varchar to datetime. is he trying to input a name in a date??

Yes. this errors in DB (types in tables and some stored procedures)
see forum.. fixes...

 

[SpeedDevil]

Followed the fixes, now when selecting server it times out
Connection Lost

 

[Twilight]

check all in PSMServer_Mgr
stop all services..find apply windows registry..and start all services in PSMServer_Mgr

 

[SpeedDevil]

FIXED, thanks Twilight +1

 

[FoShaiya]

USE [PS_UserData]
GO
/****** Objekt: StoredProcedure [dbo].[usp_Try_GameLogin_Taiwan] Skriptdatum: 04/23/2012 17:36:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


/****** Object: Stored Procedure dbo.usp_Try_GameLogin_Taiwan Script Date: 2008-6-7 18:34:05 ******/


/*================================================== date 2007-12-04 Brief Login Proc( Taiwan )
==================================================*/


ALTER Proc [dbo].[usp_Try_GameLogin_Taiwan]

userID varchar(18),
@InPassword varchar(32),

SessionID bigint, userIP varchar(15),


-- ???? ??? ??, ???? ?? ??

userUID int = 0, LogiNType smallint = 1, LogiNTime datetime = NULL


AS


SET NOCOUNT ON


DECLARE

Leave tinyint,
@Status smallint,

CoMpanyIP varchar(15), tempIP varchar(15), Check int


SET @Status = -1
SET LogiNTime = GETDATE()


--------------------------------------------------
SET CoMpanyIP = '61.107.81'
SET userIP = LTRIM( RTRIM userIP) )
--------------------------------------------------
SET Check = 0
--------------------------------------------------


SELECT userUID=UserUID, @Status=Status, Leave=Leave FROM Users_Master WHERE UserID = userID


-- NotExist User OR Leave User
IF( userUID = 0 OR Leave = 1 )
BEGIN
SET @Status = -3
END
ELSE
BEGIN
-- Check Password
EXEC dbo.sp_LoginSuccessCheck userID, @InPassword, Check output
IF ( @@ERROR = 0 )
BEGIN
IF( Check <> 1 )
BEGIN
SET @Status = -1
END
END
ELSE
BEGIN
SET @Status = -1
END


/* Old
SET @InEnPassword = master.dbo.fn_md5(@InPassword)
IF ( @InEnPassword <> @EnPassword )
BEGIN
SET @Status = -1
END
*/
END


-- BlockUser Check
IF( (@Status >= 2) AND (@Status <= 6) )
BEGIN
-- Get Block Limit Date AND Replace date text
DECLARE BlockEndDate datetime
SELECT BlockEndDate = BlockEndDate FROM Users_Block WHERE UserUID = userUID
IF ( @@ROWCOUNT <> 0 )
BEGIN
-- Block Release
IF ( BlockEndDate <= LogiNTime )
BEGIN
SET @Status = 0
UPDATE Users_Master SET Status = @Status WHERE UserUID = userUID
END
END
END


-- Admin IP Check(2006-02-21)
/*
IF( @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
SET tempIP = LEFT userIP, 9)
IF( tempIP <> CoMpanyIP )
BEGIN
SET @Status = -999
END
END
*/


-- Select
SELECT @Status AS Status, userUID AS UserUID


-- Log Insert
IF( @Status = 0 OR @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
EXEC usp_Insert_LoginLog_E SessionID SessionID, userUID userUID, userIP userIP, logType=0, logTime LogiNTime, LogiNType LogiNType
END
SET NOCOUNT OFF

Fix login script run this in your database it should also help as well