Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

[ImportBot]

Originally Posted by ColColonCleaner*:

 

It's okay to release a patch for a different plugin (if the plugin-author agrees or is inactive/has no time), but I didn't like you wanting to bundle it with your plugin without releasing it here, as an "official" patch for everyone. Either have that for everyone, or no one, don't split up the plugin usage even more

Oh...well in that case i'll release the patch tonight.

[ImportBot]

Originally Posted by XpKiller*:

 

could you post your patch here.

 

I was inactive for some time. So i could merge it to new version.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

could you post your patch here.

 

I was inactive for some time. So i could merge it to new version.

Yep working on it...i've added a little more so some testing is needed before posting. Still might be able to post tonight.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

@XPKiller

 

Releasing Patch Version 1.1.0.2

 

This patch in short allows other plugins to orchestrate how stat logger operates.

 

Details: A match command "GetStatus" is added on plugin load. Checking for this command lets other plugins know whether it exists. If the command exists but cannot be called it means stat logger is disabled, actions can then be taken accordingly. After manually or automatically enabling stat logger this command can be called from any other plugin passing a stringified JSON object containing the return location (plugin name, and plugin method).

 

When called it will return a stringified JSON object containing the following elements:

 

pluginVersion - Version of the plugin, currently 1.1.0.2

pluginEnabled - Whether the plugin is enabled, always true now that i realize plugin.call only works on enabled plugins.

DBHost - Hostname of the DB stat logger is using.

DBPort - Port of the DB stat logger is using.

DBName - Name of the DB stat logger is using.

DBTimeOffset - Time offset stat logger is using.

DBConnectionActive - A select is made on tbl_server with limit 1, on any return connection is deemed active.

ChatLoggingEnabled - Whether chat logging is enabled.

InstantChatLoggingEnabled - Whether Instant chat logging is enabled.

StatsLoggingEnabled - Whether stat logging is enabled.

DBliveScoreboardEnabled - Whether the live scoreboard is enabled in the database.

DebugMode - The current debug mode stat logger is in.

Error - Always False for now

 

This list is preliminary and only sends back what i need at the moment plus a couple others i thought could be nice.

 

The diff log between killer's current version (1.1.0.1) and this version (1.1.0.2) can be found in the AdKats repository here: https://github.com/ColColonCleaner/A...3c05677362e75c

 

The source for 1.1.0.2 can be found and downloaded from the AdKats repository here: https://raw.github.com/ColColonClean...tsLoggerBF3.cs

 

The section of code where AdKats 0.3.4.9 (unreleased) uses this can be found on line 10046 here: https://github.com/ColColonCleaner/A...Kats.cs#L10046

 

If you would like the source moved I will gladly do it, but this works best for modifications for now. This is for public release and usage using the link above, but a copy of this file will be released with AdKats 0.3.5.0 after testing is complete. Adkats 3.5 will refuse to start unless this patch is installed. Let me know what develops.

[ImportBot]

Originally Posted by XpKiller*:

 

@ColColonCleaner

 

its fine.

 

I will repack my plugin the next days.

I'm going to use your modded version of my stats as new base for bf4, if it is ok for you?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

@ColColonCleaner

 

its fine.

 

I will repack my plugin the next days.

I'm going to use your modded version of my stats as new base for bf4, if it is ok for you?

Perfect. Do you have a list of changes/features you are planning to make/add to the new version? Or will it just be compatibility with BF4?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

@XpKiller

 

I'm not seeing the section of code that updates player names in the database if they change their name, I'm probably just blind though. This was not happening in our servers, at least for some players. Their name in-game would not match the database even after several joins by that player. I added backup code in AdKats to make sure it changes, but i would like to make sure stat logger is doing this as well.

 

EDIT: Ah, i see where it is now, but it's only called on round end? So we can't rely on stat logger for any changes during the match aside from chat logs? I did not know this before, apparently my backup systems have been working harder than i thought...

[ImportBot]

Originally Posted by lowstep*:

 

I talked to my provider and he said, i got the access and that remote connections are allowed.

 

My error : Error: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

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

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:

System.Security.Permissions.SecurityPermission

Die Zone der Assembly, bei der ein Fehler aufgetreten ist:

MyComputer

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

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[15:03:17 12] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder( )

[15:03:17 14] Error: getUpdateServerID1: System.TypeInitializationException: Der Typeninitialisierer für "MySql.Data.MySqlClient.MySqlPoolManager" hat eine Ausnahme verursacht. ---> System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Security.Permissions.SecurityPermissio n, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

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

Die Aktion, bei der ein Fehler aufgetreten ist:

LinkDemand

Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:

System.Security.Permissions.SecurityPermission

Die Zone der Assembly, bei der ein Fehler aufgetreten ist:

MyComputer

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

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

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

bei PRoConEvents.CChatGUIDStatsLoggerBF3.getUpdateServ erID(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by XpKiller*:

 

@lowstep

your error typical for a procon permission error.

 

you need to add your database host to the trusted host list in procon or the sandbox needs to be disabled.

 

I recommend to add the host to the trusted hosts list. Procon needs a restart to apply that settings.

 

In the most causes that step needs to be done by your layer provider.

[ImportBot]

Originally Posted by lowstep*:

 

Sandbox mode is off...

[ImportBot]

Originally Posted by XpKiller*:

 

Sandbox mode is off...

i dont think so, or procon needs a restart.

 

This sandbox related setting needs a restart of the proconlayer to apply.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

@XpKiller

 

Getting this error:

 

Error: Error in UnregisterAllCommands: System.InvalidOperationException: Collection was modified; enumeration operation may not execute.

at System.ThrowHelper.ThrowInvalidOperationException( ExceptionResource resource)

at System.Collections.Generic.Dictionary`2.Enumerator .MoveNext()

at PRoConEvents.CChatGUIDStatsLoggerBF3.UnregisterAll Commands()

[ImportBot]

Originally Posted by lowstep*:

 

i dont think so, or procon needs a restart.

 

This sandbox related setting needs a restart of the proconlayer to apply.

I restartet the layer and the gameserver multiple times but i still get the error.

[ImportBot]

Originally Posted by XpKiller*:

 

I restartet the layer and the gameserver multiple times but i still get the error.

how did you change that setting? Did you modify the the procon.cfg of your layer?

 

Please note you cannot the sandbox setting with a client connected to the proconlayer. The setting show in your client is for your local procon.

[ImportBot]

Originally Posted by XpKiller*:

 

@XpKiller

 

Getting this error:

 

Error: Error in UnregisterAllCommands: System.InvalidOperationException: Collection was modified; enumeration operation may not execute.

at System.ThrowHelper.ThrowInvalidOperationException( ExceptionResource resource)

at System.Collections.Generic.Dictionary`2.Enumerator .MoveNext()

at PRoConEvents.CChatGUIDStatsLoggerBF3.UnregisterAll Commands()

this error is rised, if one thread is reading for a collection within UnregisterAllCommands() and at the same time an other thread is modifying that collection (eg. a list). I guess error is cause by your patch. You probably needed to add a lock object to avoid such situations.

 

Unfortunately i have no gameserver for development atm.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

this error is rised, if one thread is reading for a collection within UnregisterAllCommands() and at the same time an other thread is modifying that collection (eg. a list). I guess error is cause by your patch. You probably needed to add a lock object to avoid such situations.

 

Unfortunately i have no gameserver for development atm.

Alright, can you tell me which object to lock around (assuming one already exists)? I can go searching, but asking will probably be faster, lol.

[ImportBot]

Originally Posted by lowstep*:

 

how did you change that setting? Did you modify the the procon.cfg of your layer?

 

Please note you cannot the sandbox setting with a client connected to the proconlayer. The setting show in your client is for your local procon.

Where do i find it ? Its not in my procon ftp.

[ImportBot]

Originally Posted by XpKiller*:

 

Where do i find it ? Its not in my procon ftp.

the file procon.cfg is located in the configs folder. if you cannot see it, you must ask your provider.

[ImportBot]

Originally Posted by Jasonpb*:

 

this error is rised, if one thread is reading for a collection within UnregisterAllCommands() and at the same time an other thread is modifying that collection (eg. a list). I guess error is cause by your patch. You probably needed to add a lock object to avoid such situations.

 

Unfortunately i have no gameserver for development atm.

I have a spare 32x slot instance you can use if you want, at least for the next 2-3 weeks.

[ImportBot]

Originally Posted by anditfeels*:

 

Hello.

I asked my server support about InnoDB, they told me it is available and works properly.

Then I created db, user after this I checked the data by Navicat and connection was success.

So only after I entered all the data needed into plugin settings, and when I started it, procon showned me the error message:

Code:

[16:05:36 13] BF3 Chat, GUID and Stats Logger Enabled
[16:05:36 13] BF3 Chat, GUID and Stats Logger:  Floodprotection set to 10 Request per Round for each Player
[16:05:59 88] Error in Tablebuilder: 
[16:05:59 88] Message: Unable to connect to any of the specified MySQL hosts.
[16:05:59 88] Native: -2147467259
[16:05:59 88] Source: MySql.Data
[16:05:59 88] StackTrace:    at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[16:05:59 88] 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 *.***.*.***:3306
   at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)
   at MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, Boolean unix)
   at MySql.Data.Common.StreamCreator.GetStreamFromHost(String pipeName, String hostName, UInt32 timeout)
   at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
   at MySql.Data.MySqlClient.NativeDriver.Open()
[16:05:59 88] Error: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[16:06:22 90] Error in Tablebuilder: 
[16:06:22 90] Message: Unable to connect to any of the specified MySQL hosts.
[16:06:22 90] Native: -2147467259
[16:06:22 90] Source: MySql.Data
[16:06:22 90] StackTrace:    at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()
[16:06:22 90] 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 *.***.*.***:3306
   at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)
   at MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, Boolean unix)
   at MySql.Data.Common.StreamCreator.GetStreamFromHost(String pipeName, String hostName, UInt32 timeout)
   at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)
   at MySql.Data.MySqlClient.NativeDriver.Open()
[16:06:22 90] Error: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLoggerBF3.tablebuilder()

But I'm sure, the data base is available and all data there is correct. So what can be wrong?

[ImportBot]

Originally Posted by XpKiller*:

 

Could you post your connection info without password?

 

Your error is typical if the plugin cannot reach the mysql server.

[ImportBot]

Originally Posted by jking54*:

 

I have a spare 32x slot instance you can use if you want, at least for the next 2-3 weeks.

16 player server here as well if you need it, I'm using it for procon work getting ready for BF4.

[ImportBot]

Originally Posted by anditfeels*:

 

Could you post your connection info without password?

Your error is typical if the plugin cannot reach the mysql server.

I've made some restrictions by IP in my firewall and the strange thing is I wrote exact IP into the white list of firewall but the plugin tell me that it is not possible to connect to the server.

When I deleted the rule in firewall table, the plugin successfully was connected to the MySQLDB. Seems like I need to figure why firewall is blocking the plugin, because I'm sure the written IP was correct.

 

Can you tell me, is there any option in your plugin to make the stats simple?

[ImportBot]

Originally Posted by ty_ger07*:

 

"Make the stats simple"?

 

What do you mean? What do you consider simple and what do you consider complex?

[ImportBot]

Originally Posted by anditfeels*:

 

This plugin* will tell it for itself

[ImportBot]

Originally Posted by ColColonCleaner*:

 

This plugin* will tell it for itself

Still not making sense. A lot of us analyze the data stored by this plugin without issue. What specific simple data were you looking for? Maybe we can let you know how to extract it.

[ImportBot]

Originally Posted by ty_ger07*:

 

This plugin* will tell it for itself

Do you mean to say that you want the plugin to work and keep track of data without needing a database? SQL databases are very efficient and maintain good performance even with huge databases if properly designed. There is no way you could produce this quality of plugin without using a database. And the plugin can't create its own database since a database requires the correct environment which the plugin has no control over.

[ImportBot]

Originally Posted by anditfeels*:

 

MySQL database it is not a problem at all.

"Simple stats" meaning the stats with player data (guids, nicknames, ip and etc) and chat data only.

The other kind of data (kills, dogtags etc) will increase the database size and traffic on my server.

So is there any option to make the stats simple?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

MySQL database it is not a problem at all.

"Simple stats" meaning the stats with player data (guids, nicknames, ip and etc) and chat data only.

The other kind of data (kills, dogtags etc) will increase the database size and traffic on my server.

So is there any option to make the stats simple?

Stats -> Enable Stat Logging -> False

[ImportBot]

Originally Posted by Skorpius*:

 

Hello all!! The pluggin has been working fine up until a few weeks ago. About the time the servers went from R38 to R39 then reverted back to R38. It seems to record all the stats for 1 round then stop. I restart my layer and it works again for 1 round and stop. Any ideas?