rSec 3.0 - RYL Server Security Software

BountyHunter · Aug 14, 2014

matt_warfare said:
he is maybe? :dontknow: just give him a chance would you?

and why dont you post your log here? or to be exact what kind of error do you get.

posted on 1st page , and 2nd log like yours .

Code:

14/08/2014 16:42:01 : [Character Data Collector] - ERR: Cannot insert the value NULL into column 'ID', table 'Part2_Zodiac.dbo.UserLoginInfo'; column does not allow nulls. INSERT fails.
The statement has been terminated.
 (U:156, C:0, Z:0, L:0, IP:127.0.0.1)
Command : 1
ParamA : 0
ParamB : 0
Compressed : False

9c 00 00 00   16 00 

Exception:
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'ID', table 'Part2_Zodiac.dbo.UserLoginInfo'; column does not allow nulls. INSERT fails.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at rSec.Database.sendNonQueryReturnId(Databases db, String Query)
   at rSec.PacketChecker.AuthLoginReturn(Packet p, Character c)
   at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)
ClientConnectionId:dfe65439-0d44-4512-89cc-42d9da6af3a7

alphaest said:
His game server login packet has invalid content. Theres only one setting in rSec that changes this - ryl version in config. I have ever only seen 2 login packet formats and therefor only has support for 2. If his server doesn't use either of those two formats - well, hes f*cked.

ok well , thanks . .

IzzdihaR · Aug 18, 2014

@Alphaest

Hello Sir,

I facing this problem on RYL2 Server 1753/1750 version.
It from Character Data Collector the first is " ERR: Sequence contains more than one matching element" and the second is "ERR: Sequence contains no matching element"

Here the full log from rSecLog.txt

Code:

8/18/2014 3:42:20 AM : [Character Data Collector] - ERR: Sequence contains no matching element
MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166)
Command : a1
ParamA : 0
ParamB : 0
Compressed : False

f8 50 00 00   26 00 32 05   00 00 00 14   3e 82 53 01   
00 00 00 10   e1 ed 32 05   14 01 00 00   00 00 00 00   


Exception:
System.InvalidOperationException: Sequence contains no matching element
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
   at rSec.Server.ItemHandler.Combine(IPos from, IPos to, UInt16 leftOverId, Byte leftOverAmount, Stream item)
   at rSec.PacketChecker.ItemCombine(Packet p, Character c)
   at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

here the other one

Code:

8/18/2014 3:43:09 AM : [Character Data Collector] - ERR: Sequence contains more than one matching element
MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166)
Command : 34
ParamA : 0
ParamB : 0
Compressed : False

00 00 00 00   00 00 00 00   f8 50 00 00   00 00 00 00   
42 05 00 32   

Exception:
System.InvalidOperationException: Sequence contains more than one matching element
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
   at rSec.Server.ItemHandler.Add(IPos to, Int32 amount)
   at rSec.PacketChecker.ParsePickupItem(Packet p, Character c)
   at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

kz_3d · Aug 18, 2014

@IzzdihaR

Did you read the your privat messages?

alphaest · Aug 19, 2014

IzzdihaR said:

@Alphaest

Hello Sir,

I facing this problem on RYL2 Server 1753/1750 version.
It from Character Data Collector the first is " ERR: Sequence contains more than one matching element" and the second is "ERR: Sequence contains no matching element"

Here the full log from rSecLog.txt

Code:

8/18/2014 3:42:20 AM : [Character Data Collector] - ERR: Sequence contains no matching element
MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166)
Command : a1
ParamA : 0
ParamB : 0
Compressed : False

f8 50 00 00   26 00 32 05   00 00 00 14   3e 82 53 01   
00 00 00 10   e1 ed 32 05   14 01 00 00   00 00 00 00   


Exception:
System.InvalidOperationException: Sequence contains no matching element
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
   at rSec.Server.ItemHandler.Combine(IPos from, IPos to, UInt16 leftOverId, Byte leftOverAmount, Stream item)
   at rSec.PacketChecker.ItemCombine(Packet p, Character c)
   at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

here the other one

Code:

8/18/2014 3:43:09 AM : [Character Data Collector] - ERR: Sequence contains more than one matching element
MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166)
Command : 34
ParamA : 0
ParamB : 0
Compressed : False

00 00 00 00   00 00 00 00   f8 50 00 00   00 00 00 00   
42 05 00 32   

Exception:
System.InvalidOperationException: Sequence contains more than one matching element
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)
   at rSec.Server.ItemHandler.Add(IPos to, Int32 amount)
   at rSec.PacketChecker.ParsePickupItem(Packet p, Character c)
   at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

Is the item, you are trying to combine and pickup, in the itemscript rSec is using? The ones with rSec are just some out of the box files. If you have, try a relogin and again. If its still the same then i don't know.

IzzdihaR · Aug 19, 2014

@kz_3d

yes i see, i already reply your message for multiple time i think. @_@ ..

@Alphaest

thank you sir, i fix it by using rSec build from the source, the one connect to mysql database. If i use the one you release here i will get this error again. I dont know why @_@. Weird

alphaest · Aug 19, 2014

IzzdihaR said:
@kz_3d

yes i see, i already reply your message for multiple time i think. @_@ ..

@Alphaest

thank you sir, i fix it by using rSec build from the source, the one connect to mysql database. If i use the one you release here i will get this error again. I dont know why @_@. Weird

The version that got released by that idiot has a major security issue. Good luck!

IzzdihaR · Aug 19, 2014

alphaest said:
The version that got released by that idiot has a major security issue. Good luck!

yea i saw rSec Changelogs 3.0

1. Fixed a security hole in rSec itself

I dont know what the problem with this version of rSec. But i'm sure it should be related the the script maybe. I will figure this out

.

Thank you alpha for the great support. Thank You.

BountyHunter · Aug 20, 2014

just test on RYL1 tyfix released :

Error log :

Code:

8/20/2014 1:14:03 PM : [DB Data Validator] - EQ Check failed
Exception:
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EQ_Changed'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at rSec.Database.sendSelectQuery(Databases db, String Query)
   at rSec.DBTestsRunner.RunEQ()
   at rSec.DBTestsRunner.Tick(Object runner, ElapsedEventArgs arg)
ClientConnectionId:1b9509d3-f510-4c92-9734-8fe0745b971c

PHP:

USE [winner1]
GO

/****** Object:  Table [dbo].[CharInfo]    Script Date: 08/17/2010 12:02:00 ******/

ALTER TABLE [dbo].[CharInfo_1] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO

ALTER TABLE [dbo].[CharInfo_1] ADD  CONSTRAINT [DF_CharInfo_1_EQ_Changed]  DEFAULT ((1)) FOR [EQ_Changed]
GO

ALTER TABLE [dbo].[CharInfo_2] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO

ALTER TABLE [dbo].[CharInfo_2] ADD  CONSTRAINT [DF_CharInfo_2_EQ_Changed]  DEFAULT ((1)) FOR [EQ_Changed]
GO

ALTER TABLE [dbo].[CharInfo_3] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO

ALTER TABLE [dbo].[CharInfo_3] ADD  CONSTRAINT [DF_CharInfo_3_EQ_Changed]  DEFAULT ((1)) FOR [EQ_Changed]
GO

ALTER TABLE [dbo].[CharInfo_4] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO

ALTER TABLE [dbo].[CharInfo_4] ADD  CONSTRAINT [DF_CharInfo_4_EQ_Changed]  DEFAULT ((1)) FOR [EQ_Changed]
GO

alphaest · Aug 21, 2014

BountyHunter said:

just test on RYL1 tyfix released :

Error log :

Code:

8/20/2014 1:14:03 PM : [DB Data Validator] - EQ Check failed
Exception:
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EQ_Changed'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at rSec.Database.sendSelectQuery(Databases db, String Query)
   at rSec.DBTestsRunner.RunEQ()
   at rSec.DBTestsRunner.Tick(Object runner, ElapsedEventArgs arg)
ClientConnectionId:1b9509d3-f510-4c92-9734-8fe0745b971c

PHP:

USE [winner1]
GO

/****** Object:  Table [dbo].[CharInfo]    Script Date: 08/17/2010 12:02:00 ******/

ALTER TABLE [dbo].[CharInfo_1] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO

ALTER TABLE [dbo].[CharInfo_1] ADD  CONSTRAINT [DF_CharInfo_1_EQ_Changed]  DEFAULT ((1)) FOR [EQ_Changed]
GO

ALTER TABLE [dbo].[CharInfo_2] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO

ALTER TABLE [dbo].[CharInfo_2] ADD  CONSTRAINT [DF_CharInfo_2_EQ_Changed]  DEFAULT ((1)) FOR [EQ_Changed]
GO

ALTER TABLE [dbo].[CharInfo_3] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO

ALTER TABLE [dbo].[CharInfo_3] ADD  CONSTRAINT [DF_CharInfo_3_EQ_Changed]  DEFAULT ((1)) FOR [EQ_Changed]
GO

ALTER TABLE [dbo].[CharInfo_4] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO

ALTER TABLE [dbo].[CharInfo_4] ADD  CONSTRAINT [DF_CharInfo_4_EQ_Changed]  DEFAULT ((1)) FOR [EQ_Changed]
GO

Use this:

You must be registered to see links

KaitoDaumoto · Aug 22, 2014

Sounds like the server files need to modified then .. any point?

matt_warfare · Aug 22, 2014

KaitoDaumoto said:
Sounds like the server files need to modified then .. any point?

for ?

KaitoDaumoto · Aug 23, 2014

makes rsec support?

BountyHunter · Aug 24, 2014

KaitoDaumoto said:
makes rsec support?

how about the source 2.8 that been release ? so no need to modified serverfile . .isnt it?

matt_warfare · Aug 24, 2014

BountyHunter said:
how about the source 2.8 that been release ? so no need to modified serverfile . .isnt it?

yeah you're still talking about the source.

alphaest said:
The version that got released by that idiot has a major security issue. Good luck!

doesn't really know specifically what he is talking bout,but 3.0 ftw for me.

KaitoDaumoto said:
makes rsec support?

and doesn't really get what are you trying to say.

BountyHunter · Aug 24, 2014

test on v1900 . .result not working :laugh:

Code:

Exception:
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at rSec.Server.Data.SkillScript.ClassLearnedSkills(Byte bClass)
   at rSec.PacketChecker.WorldLoginReturn(Packet p, Character c)
   at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

matt_warfare · Aug 25, 2014

BountyHunter said:
test on v1900 . .result not working :laugh:

well then I guest you're f*cked.

nazaryman · Aug 25, 2014

Dear alpha i need your help

What offset to modify to make red colored chat in client.exe for RYL2 ??

BountyHunter · Aug 25, 2014

matt_warfare said:
well then I guest you're f*cked.

hell yeah! rsec support only for poop version of RYL/ROW :fanny:

alphaest · Aug 25, 2014

nazaryman said:
Dear alpha i need your help

What offset to modify to make red colored chat in client.exe for RYL2 ??

In my forum knowledge portal is a picture of olly/hex, search for those values in your client. The colors are constants.

BountyHunter said:
hell yeah! rsec support only for poop version of RYL/ROW

Versions supported by rSec were those active/popular at that time. So i would turn this around and say your choice for the version is poop.

BountyHunter · Aug 26, 2014

alphaest said:
Features

[*]Ryl 1 and Ryl 2 support

you need to edit this line then . . write only which RYL2 version that fully work with rsec . . :bath:

Welcome!

rSec 3.0 - RYL Server Security Software

Infraction bannëd

Noob

Newbie Spellweaver

Moooooooooooooooo

Noob

Moooooooooooooooo

Noob

Infraction bannëd

Moooooooooooooooo

Can't touch this!

Newbie Spellweaver

Can't touch this!

Infraction bannëd

Newbie Spellweaver

Infraction bannëd

Newbie Spellweaver

Newbie Spellweaver

Infraction bannëd

Moooooooooooooooo

Infraction bannëd

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor