Jump to content

Chat, GUID, Stats and Mapstats Logger [1.0.0.3]


ColColonCleaner

Recommended Posts

  • Administrators
silly question, can i add the table by hand ?
gameservers.com only support ONE free database, and we got that setup.
but when enabling the statslogger it spams this message here.

[17:31:38 57] Error in Tablebuilder:[17:31:38 57] Message: Authentication to host '** here was a IP adress **' for user '**  here was the user setings **' using method 'mysql_native_password' failed with message: Access denied for user '**  here was the user setings **' (using password: YES)[17:31:38 57] Native: -2147467259[17:31:38 57] Source: MySql.Data[17:31:38 57] StackTrace:    at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex)   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)   at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)   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.GetPooledConnection()   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()   at MySql.Data.MySqlClient.MySqlPool.GetConnection()   at MySql.Data.MySqlClient.MySqlConnection.Open()   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()[17:31:38 57] InnerException: MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user '** yep, here was the user setings **' (using password: YES)   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()[17:31:38 57] Error: System.NullReferenceException: Object reference not set to an instance of an object.   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder()[18:28:43 18] InnerException: MySql.Data.MySqlClient.MySqlException (0x80004005): Access denied for user '** here was the user settings **'@'%' to database '** the databasename **'   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()   at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()[18:28:43 18] Error: System.NullReferenceException: Object reference not set to an instance of an object.   at PRoConEvents.CChatGUIDStatsLogger.tablebuilder() 


 
database is working, we got batllelogcache working, so it connect, it only refused to create the tables imho.
cheers, thnsx.
 

Make sure you entered the creds correctly. If battle log cache worked on the same database then maybe you typed something wrong in the stats logger without realizing it.

Sent from my ONEPLUS A5010 using Tapatalk

The developer of the Battlefield Admin Control Panel (BFACP)

For BFACP support please post in the BFACP topic linked above.

Do not contact me via PM on the forums for help with procon. Please make a topic for it. Only PM's I will accept will revolve around any website issues.

spacer.png

Link to comment

morning Prophet.

Well, not gonna tell a joke, but i found out, the battlelog cache has no error handling as the statslogger has,

i could give in any data, it would say nothing.

but i found the bugger, it was the access list, took me a while, but i manage to find and enter the correct proconhost IP in the access list, now it works..

thnxs all.

Link to comment

Hmm, all works well, installing adkats worked great.

but i get randomly this message from statslogger (1003 that is)

[08:52:53 55] [Statslogger]Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerID(CServerInfo csiServerInfo)


well, i can live with it, no time to check it, heading to work.

cheers.

Link to comment

hmky, this is weard.

i enabled all the stats options, but i just noticed that there is data collection.

session logging works, but no player stats is collected.

tbl_playerstats and tbl_server_stats , tbl_weapons_stats keep empty, .

any idea ?

i think it has to do with the statslogger error i posted in the previous post.

Edited by iamadeadpixel
update
Link to comment
  • Administrators
Just now, iamadeadpixel said:

hmky, this is weard.

i enabled all the stats options, but i just noticed that there is data collection.

session logging works, but no player stats is collected.

tbl_playerstats and tbl_server_stats , tbl_weapons_stats keep empty, .

any idea ?

Did you enable the option that doesn't log player data? That has to be set to false. I can't remember what it's called of the top of my head.

The developer of the Battlefield Admin Control Panel (BFACP)

For BFACP support please post in the BFACP topic linked above.

Do not contact me via PM on the forums for help with procon. Please make a topic for it. Only PM's I will accept will revolve around any website issues.

spacer.png

Link to comment
  • Administrators
14 minutes ago, iamadeadpixel said:

screenshot of the settings...

worsecase i have to purge all, and start over...

Desktop Screenshot 2020.01.11 - 14.49.02.58.png

Nope, looks right. Stats won't get saved to the database unless a full complete round was done. Round restarts if population drops will not be posted to the database because the round end event never fired.

The developer of the Battlefield Admin Control Panel (BFACP)

For BFACP support please post in the BFACP topic linked above.

Do not contact me via PM on the forums for help with procon. Please make a topic for it. Only PM's I will accept will revolve around any website issues.

spacer.png

Link to comment
  • 3 weeks later...
  • 4 weeks later...
9 hours ago, GK_Nico said:

Hey

Could anyone tell me why this message is not displayed correctly here my settings

 

http://prntscr.com/r79q86 and http://prntscr.com/r79qvi 

 

there are also no mistakes http://prntscr.com/r79reo

 

is this normal or rather not or is it because no stats are stored yet?

http://prntscr.com/r79s0s

This should not happen. Wait for at least one round. If this does not help:

  1. Stop PRoCon
  2. Delete the config at Configs/IP/StatsLogger..... cfg
  3. Start PRoCon
  4. Do not modify anything and try if it works now
Edited by Hedius

Need new plugin features? I can change: Adkats, AdKatsLRT, LanguageEnforcer, InsaneLimits, xVotemap for you. Also working on new plugins. Have an idea? Share it and I might include it in my repos. Github.com/hedius

 

Check out E4GLAdKats for an advancded and maintained AdKats version.

Link to comment
  • 1 month later...

Hey,

I got a problem on a procon layer using Statslogger 1.0.0.3

there is always the same message coming again and again:

[Statslogger]Error: CreateSession: System.ArgumentOutOfRangeException: Value to add was out of range.
Parameter name: value
  at System.DateTime.Add (System.Double value, System.Int32 scale) [0x0003f] in <a1ae6166591d4020b810288d19af38d4>:0
  at System.DateTime.AddHours (System.Double value) [0x00000] in <a1ae6166591d4020b810288d19af38d4>:0
  at PRoConEvents.CStats+myDateTime.get_Now () [0x00006] in <4ac787d65ba4475eb113d4c0e56e2856>:0
  at PRoConEvents.CStats..ctor (System.String guid, System.Int32 score, System.Int32 kills, System.Int32 headshots, System.Int32 deaths, System.Int32 suicides, System.Int32 teamkills, System.Int32 playtime, System.Double timeoffset, System.Collections.Generic.Dictionary`2[TKey,TValue] _weaponDic) [0x000be] in <4ac787d65ba4475eb113d4c0e56e2856>:0
  at PRoConEvents.CChatGUIDStatsLogger.CreateSession (System.String SoldierName, System.Int32 intScore, System.String EAGUID) [0x00031] in <4ac787d65ba4475eb113d4c0e56e2856>:0

 

Does anyone know about this issue?

Link to comment
5 minutes ago, Checka_Wiemi said:

Hey,

I got a problem on a procon layer using Statslogger 1.0.0.3

there is always the same message coming again and again:

[Statslogger]Error: CreateSession: System.ArgumentOutOfRangeException: Value to add was out of range.
Parameter name: value
  at System.DateTime.Add (System.Double value, System.Int32 scale) [0x0003f] in <a1ae6166591d4020b810288d19af38d4>:0
  at System.DateTime.AddHours (System.Double value) [0x00000] in <a1ae6166591d4020b810288d19af38d4>:0
  at PRoConEvents.CStats+myDateTime.get_Now () [0x00006] in <4ac787d65ba4475eb113d4c0e56e2856>:0
  at PRoConEvents.CStats..ctor (System.String guid, System.Int32 score, System.Int32 kills, System.Int32 headshots, System.Int32 deaths, System.Int32 suicides, System.Int32 teamkills, System.Int32 playtime, System.Double timeoffset, System.Collections.Generic.Dictionary`2[TKey,TValue] _weaponDic) [0x000be] in <4ac787d65ba4475eb113d4c0e56e2856>:0
  at PRoConEvents.CChatGUIDStatsLogger.CreateSession (System.String SoldierName, System.Int32 intScore, System.String EAGUID) [0x00031] in <4ac787d65ba4475eb113d4c0e56e2856>:0

 

Does anyone know about this issue?

image.png.c89f6794d5fdaa38a7cc8bbc6936f3cf.png

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.

Edited by Hedius

Need new plugin features? I can change: Adkats, AdKatsLRT, LanguageEnforcer, InsaneLimits, xVotemap for you. Also working on new plugins. Have an idea? Share it and I might include it in my repos. Github.com/hedius

 

Check out E4GLAdKats for an advancded and maintained AdKats version.

Link to comment
6 minutes ago, to22ek said:

Hi Im hosting BfBC2 server and using this plugin PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.3 and i have problem. This plugin dont collecting any stats. Any one can help??

Please share a screenshot of your settings without the mysql connection data. (Collapse the block)

Edited by Hedius

Need new plugin features? I can change: Adkats, AdKatsLRT, LanguageEnforcer, InsaneLimits, xVotemap for you. Also working on new plugins. Have an idea? Share it and I might include it in my repos. Github.com/hedius

 

Check out E4GLAdKats for an advancded and maintained AdKats version.

Link to comment
2 minutes ago, to22ek said:

Zrzut ekranu (35).png

Zrzut ekranu (36).png

Hmm looks ok. You can increase the loglevel of the plugin so you can see more information in the plugin console.

Are there any errors or warnings in the plugin console?

Need new plugin features? I can change: Adkats, AdKatsLRT, LanguageEnforcer, InsaneLimits, xVotemap for you. Also working on new plugins. Have an idea? Share it and I might include it in my repos. Github.com/hedius

 

Check out E4GLAdKats for an advancded and maintained AdKats version.

Link to comment
  • Administrators

What's your server population like? Also, are you running a server that's ranked? I don't think unranked servers get counted but I'm not sure.

The developer of the Battlefield Admin Control Panel (BFACP)

For BFACP support please post in the BFACP topic linked above.

Do not contact me via PM on the forums for help with procon. Please make a topic for it. Only PM's I will accept will revolve around any website issues.

spacer.png

Link to comment
25 minutes ago, to22ek said:

Its ranked server with punkbuster. And 2000+ players on this server 

Enable debugging: trace and look at the actions of the plugin. What does it do?

 

Also enable instant logging of chat msgs. (First section) What happens if you write a chat message?

 

What happens on RoundOver? The plugin should write round stats to the DB. 

Edited by Hedius

Need new plugin features? I can change: Adkats, AdKatsLRT, LanguageEnforcer, InsaneLimits, xVotemap for you. Also working on new plugins. Have an idea? Share it and I might include it in my repos. Github.com/hedius

 

Check out E4GLAdKats for an advancded and maintained AdKats version.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

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