Can make it work on ROW v1105 ?
Printable View
I did try.. the db char collector is not working well..
@alphaest
may i know how can this happen? well at first i have try it and it is goes really well, just got this kind of error;
and this;Quote:
12/8/2014 2:32:58 AM : [Attack Check] - (NOTIFY) {|0} Attacking while the cell doesn't contain the character itself, allowed: The character has to be present in every cell update
Char: (U:0, C:0, Z:0, L:0, IP:127.0.0.1)
Exception:
rSec.Server.HackAttemptException: Exception of type 'rSec.Server.HackAttemptException' was thrown.
at rSec.PacketChecker.Range(UInt16 skill, Int32 major, Packet p, Character c)
at rSec.PacketChecker.CharAttack(Packet p, Character c)
at rSec.Server.PacketForwarder.HandleFilteredPacket(Packet p, Filter filter, Character c, Boolean toServer)
at rSec.Server.PacketForwarder.clientToServer_IncomingPackets(Session sender, Packet p)
Command : e
ParamA : 51970
ParamB : 165
Compressed : False
9b 41 30 45 df cb 56 41 8d 62 33 45 9c 81 75 40
03 00 00 00 89 02 03 00 00 00 00 00 00 00 00 00
00 00 00 00 01 27 00 16 80 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 f3 12 00
25 49 7c 5f 10 46 36 8d 26 69 de 73 cc a6 d7 bd
00 00 10 8d f5 a9 f4 1f 00 00 00 57 00 00 00 56
it was like my character was not in server or I am not really connect properly or database/connection issue?Quote:
12/8/2014 2:32:59 AM : [Name Check] - (NOTIFY) {|0} Chat without being logged in
Char: (U:0, C:0, Z:0, L:0, IP:127.0.0.1)
Exception:
rSec.Server.HackAttemptException: Exception of type 'rSec.Server.HackAttemptException' was thrown.
at rSec.PacketChecker.ChatCheck(Packet p, Character c)
at rSec.Server.PacketForwarder.HandleFilteredPacket(Packet p, Filter filter, Character c, Boolean toServer)
at rSec.Server.PacketForwarder.clientToServer_IncomingPackets(Session sender, Packet p)
Command : d
ParamA : 0
ParamB : 0
Compressed : False
00 00 00 00 00 00 68 61 68 61 7a 20 3a 20 73 61
73 61 73 61 00
as you can see;
I have already reinstall sql and building up the server (restoring database etc) again but it gave me same result.Quote:
Char: (U:0, C:0, Z:0, L:0, IP:127.0.0.1)
Sorry, my problem is the samething with him.. im not sure what ryl version he use...I just want to know is there's any solution to make it work on customs version of ryl/row server?
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.
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
ok well , thanks . .
@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
here the other oneCode: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)
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)
@IzzdihaR
Did you read the your privat messages?
@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