Jump to content

Chat, GUID, Stats and Mapstats Logger [1.0.0.3]


ColColonCleaner

Recommended Posts

Originally Posted by EBassie*:

 

Hey XP,

 

started testing the plugin on a new database.

But after a short while I came across this error:

 

Code:

Error: Error in Startstreaming: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
This error results in missing playerstats records.

 

 

Edit: Oops... just see this was already reported a couple of posts back. My bad.

* Restored post. It could be that the author is no longer active.
Link to post
  • Replies 2k
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

Description: This plugin is used to log player chat, player GUID's, player Stats, Weaponstats and Mapstats. This includes: Chat, PBGUID, EAGUID, IP, Stats, Weaponstats, Dogtags, Killstreaks, Country,

This should not happen. Wait for at least one round. If this does not help: Stop PRoCon Delete the config at Configs/IP/StatsLogger..... cfg Start PRoCon Do not modify anyth

Check the value of this field. Set it to 0. Does this help? Do you use AdKats? Not sure if AdKats updates the offset, but AdKats has an option to adjust the logger settings.

Posted Images

Originally Posted by mase*:

 

hey guys, i'm completly new to all that mysql stuff. wanted to use this plugin with AdKats, but as soon as i enable it i get the following errors.

 

[16:45:40 26] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlTrace" hat eine Ausnahme verursacht. ---> System.TypeLoadException: Der Typ "MySql.Data.MySqlClient.MySqlClientPermission" in der Assembly "MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" konnte nicht geladen werden.

bei MySql.Data.MySqlClient.MySqlTrace..cctor()

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:45:40 26] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:45:49 01] PRoCon Chat, GUID and Stats Logger Disabled

[16:45:51 81] Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlTrace" hat eine Ausnahme verursacht. ---> System.TypeLoadException: Der Typ "MySql.Data.MySqlClient.MySqlClientPermission" in der Assembly "MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" konnte nicht geladen werden.

bei MySql.Data.MySqlClient.MySqlTrace..cctor()

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:45:51 81] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[16:45:51 81] Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlTrace" hat eine Ausnahme verursacht. ---> System.TypeLoadException: Der Typ "MySql.Data.MySqlClient.MySqlClientPermission" in der Assembly "MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" konnte nicht geladen werden.

bei MySql.Data.MySqlClient.MySqlTrace..cctor()

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

i guess it has something to do with the login to the database, but since i dunno shit about that all it would be great if someone could help me out :smile:
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by mase*:

 

yes if the sandbox is disabled the bug should not occur.

guess it's going to be hard to get my host disableing the sandbox :biggrin:

will give it a try...thx for your answers!

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by Ralphvd*:

 

I got new error to:

 

On opening procon on my own pc:

[12:42:47 80] Error: Error in Startstreaming:

[12:42:47 82] Message: Cannot add or update a child row: a foreign key constraint fails (`bf4stats`.`tbl_sessions`, CONSTRAINT `tbl_sessions_ibfk_1` FOREIGN KEY (`StatsID`) REFERENCES `tbl_server_player` (`StatsID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[12:42:47 82] Native: -2147467259

[12:42:47 82] Source: MySql.Data

[12:42:47 83] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

[12:42:48 03] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

 

after some min:

[12:42:48 03] Error: Error in Startstreaming OuterException: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()

 

 

[12:43:43 39] Error: getUpdateServerID1: System.InvalidOperationException: Nested transactions are not supported.

at MySql.Data.MySqlClient.ExceptionInterceptor.Throw( Exception exception)

at MySql.Data.MySqlClient.MySqlConnection.BeginTransa ction(IsolationLevel iso)

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

 

But so far i can see ingame, everything still working

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by MarcoV1980*:

 

I Can't seem to get it to work on 3 servers at all.

 

2 of them use a different id, but the 3rd server, just keeps using the first. Does the plugin take the ports properly into account?

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

It recommend to update due the many bugfixes.

Download in first post.

 

Changelog:

 

1.0.0.1

Bugfixes for value too long for column errors.

Bugfixes for some other bugs

Changed deprecated Tracemessages

Added an error prefix in pluginlog

New feature: Tickets/teamscores are now tracked in tbl_teamscores

New feature: Simple Stats (collects playerdata only)

New feature: Switch for disabling weaponstats

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

I updated to the latest update! No problems so far, thanks!

 

Edit:

Why does it creates 4x serverID 2?

http://i.imgur.com/4qE4IQo.png

it depends on the game mode which running.

ServerID and TeamID together is the primary key.

 

In Conquest mode you will have two entries per server (TeamID 1 and 2).

In Squaddeathmatch you will get 4 entries per server (TeamID 1 , 2, 3 and 4).

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by ErichKlobecke*:

 

Hi mase

For me its not working with gamed!.de. Got the "PublicKeyToken" Error. Wrote a Ticket to gamed and became the answer that it seems there is a bug in Procon. They are in conversation with the developer and they are waiting for a Patch in the next few Days. At the moment it was only running local.

 

"Aktuell scheint es einen Bug in der neuen ProCon Version zu geben. Nach Rücksprache mit den Entwicklern gibt es ein Rechte Problem, wodurch Plugins mit Zugriffe auf MySQL Datenbanken unterbunden werden. Dieses Problem tritt jedoch nur in einer geschützten Server Umgebung aus.

Wir erwarten daher einen Patch in den nächsten Tagen, aktuell werden diese Plugins leider tatsächlich nur auf Ihrem Lokalem PC funktionieren."

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by mase*:

 

Hi mase

For me its not working with gamed!.de. Got the "PublicKeyToken" Error. Wrote a Ticket to gamed and became the answer that it seems there is a bug in Procon. They are in conversation with the developer and they are waiting for a Patch in the next few Days. At the moment it was only running local.

 

"Aktuell scheint es einen Bug in der neuen ProCon Version zu geben. Nach Rücksprache mit den Entwicklern gibt es ein Rechte Problem, wodurch Plugins mit Zugriffe auf MySQL Datenbanken unterbunden werden. Dieses Problem tritt jedoch nur in einer geschützten Server Umgebung aus.

Wir erwarten daher einen Patch in den nächsten Tagen, aktuell werden diese Plugins leider tatsächlich nur auf Ihrem Lokalem PC funktionieren."

ok, thanks for that one! :smile:
* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by supermillhouse*:

 

Just noticed a date bugs in the mapstats table

 

Any thoughts_?

 

0001-01-01 00:00:00

 

Initially thought they were because of the round warm-up but it has happened a couple of full rounds where server population was 60 odd

 

date errors.png

 

Another thought, do we no longer need the weapon keylist anymore?

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

Just noticed a date bugs in the mapstats table

 

Any thoughts_?

 

0001-01-01 00:00:00

 

Initially thought they were because of the round warm-up but it has happened a couple of full rounds where server population was 60 odd

 

date errors.png

 

Another thought, do we no longer need the weapon keylist anymore?

regarding mapstats:

 

everything is fine. Those entries mean that the round has not started, due too less players.

 

The weaponkey list is for alternate weaponnames for ingame commands.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by p19blo*:

 

getting this error which is new

 

InnerException: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by Tischi*:

 

I got the error:

 

[statslogger]Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.TypeLoadException: Der Typ "MySql.Data.MySqlClient.MySqlClientPermission" in der Assembly "MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" konnte nicht geladen werden.

bei MySql.Data.MySqlClient.MySqlPoolManager..cctor()

--- Ende der internen Ausnahmestapelüberwachung ---

bei MySql.Data.MySqlClient.MySqlPoolManager.GetPool(My SqlConnectionStringBuilder settings)

bei MySql.Data.MySqlClient.MySqlConnection.Open()

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

@p19blo

Well this appears if your mysql server is not responding. So is this no bug of the plugin.

 

@Tischi

Try to disable the procon sandbox.

This is caused by a bug in procon:

https://github.com/Myrcon/Procon-1/issues/25

 

So unfortunately i cant fix that.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by XpKiller*:

 

Hi guys,

 

Absolutely NO disrespect to you - XpKiller, but this plugin literally brought our hosting server down.

It flooded MYSQL and brought it to a standstill, then it borked something in the network.

 

I advised our client about the issue and he immediately agreed that it was deemed necessary to shut the plugin off.

Within minutes of installing it and activating it, we had hundreds/thousands of lines of errors which eventually caused the parent layer - hosted with us - to crash.

 

It also killed MYSQL and then finally the network.

 

How many requests does this plugin require?

I believe it attempted so many it flooded us out.

 

Also, what are the exact requirements for it?

 

We tried it sandbox on and off, and the errors were heavy, consistent and really caused an issue.

 

Due to the very fact that it DID bring my server to a standstill, upsetting a LOT of clients,

I do not recommend that this plugin should be available to be downloaded in order for every day use that then is run from parent layers.

 

It's very unstable :sad:

 

Absolutely no disrespect meant here, the work you do XpKiller is excellent, but this plugin needs a LOT more development to be released to the general public.

 

It's simply too unstable right now.

 

I hope that you don't become offended by this post of ours - but after discussing it with the client, we both agreed that it is essential to bring this to your attention, as it will help the development of your plugins further.

 

Very many thanks and kind regards

Rcon-Admin.

 

EDIT;

Just found this as well so I'm really not sure where the fault (bug) lies but it is a big one;

https://github.com/Myrcon/Procon-1/issues/25

@Rcon-Admin

 

i cant fix bugs, which dont occur in my test. Basically i dont get any layercrash during my testing yet.

 

So if there are some many errors where are the reports?

 

EDIT;

Just found this as well so I'm really not sure where the fault (bug) lies but it is a big one;

https://github.com/Myrcon/Procon-1/issues/25

this is NOT caused by the plugin itself. It seems a bug in procon, which i cant fix in my plugin code. Because the bug dont lies in the plugin code. So dont blame me for bug i cant fix.

 

It also killed MYSQL and then finally the network.

 

How many requests does this plugin require?

I believe it attempted so many it flooded us out.

i cant believe that since th plugin is using connection pooling to limit the active connections to the mysql server.

I would say your mysql server is not configured very well or your are using insane high values for the connection pool.

* Restored post. It could be that the author is no longer active.
Link to post

Originally Posted by Rcon-Admin*:

 

@ Morpheus - thank you for sharing this information, as you can imagine the recent issues have caused a problem, and I for one am looking forward to hearing how you get on with this and how the patch/remedy goes.

 

Many thanks

* Restored post. It could be that the author is no longer active.
Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.