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

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

  • Our picks

    • Game Server Hosting:

      We're happy to announce that EZRCON will branch out into the game server provider scene. This is a big step for us so please having patience if something doesn't go right in this area. Now, what makes us different compared to other providers? Well, we're going with the idea of having a scaleable server hosting and providing more control in how you set up your server. For example, in Minecraft, you have the ability to control how many CPU cores you wish your server to have access to, how much RAM you want to use, how much disk space you want to use. This type of control can't be offered in a single service package so you're able to configure a custom package the way you want it.

      You can see all the available games here. Currently, we have the following games available.

      Valheim (From $1.50 USD)


      Rust (From $3.20 USD)


      Minecraft (Basic) (From $4.00 USD)


      Call of Duty 4X (From $7.00 USD)


      OpenTTD (From $4.00 USD)


      Squad (From $9.00 USD)


      Insurgency: Sandstorm (From $6.40 USD)


      Changes to US-East:

      Starting in January 2022, we will be moving to a different provider that has better support, better infrastructure, and better connectivity. We've noticed that the connection/routes to this location are not ideal and it's been hard getting support to correct this. Our contract for our two servers ends in March/April respectively. If you currently have servers in this location you will be migrated over to the new provider. We'll have more details when the time comes closer to January. The new location for this change will be based out of Atlanta, GA. If you have any questions/concerns please open a ticket and we'll do our best to answer them.
      • 1 reply
    • Hello All,

      I wanted to give an update to how EZRCON is doing. As of today we have 56 active customers using the services offered. I'm glad its doing so well and it hasn't been 1 year yet. To those that have services with EZRCON, I hope the service is doing well and if not please let us know so that we can improve it where possible. We've done quite a few changes behind the scenes to improve the performance hopefully. 

      We'll be launching a new location for hosting procon layers in either Los Angeles, USA or Chicago, IL. Still being decided on where the placement should be but these two locations are not set in stone yet. We would like to get feedback on where we should have a new location for hosting the Procon Layers, which you can do by replying to this topic. A poll will be created where people can vote on which location they would like to see.

      We're also looking for some suggestions on what else you would like to see for hosting provider options. So please let us know your thoughts on this matter.
      • 4 replies
    • Hi All,

      So seeing as Venice Unleased is released, I'm looking into if I should offer game hosting for it. I would like some feedback on this subject.

      VU - Experience Battlefield 3 like never before! (veniceunleashed.net)
      • 3 replies
    • So as the topic title says, should EZRCON offer general web hosting services?
      • 1 reply
    • Added ability to disable the new API check for player country info


      Updated GeoIP database file


      Removed usage sending stats


      Added EZRCON ad banner



      If you are upgrading then you may need to add these two lines to your existing installation in the file procon.cfg. To enable these options just change False to True.

      procon.private.options.UseGeoIpFileOnly False
      procon.private.options.BlockRssFeedNews False



       
      • 2 replies
×
×
  • 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.