Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[iamadeadpixel]

actualy, it should not deny it, we have battlelog cache working on the same database, and that works, wel, it didnt came with a error, oh please, dont tell me there is no error handling for it.

 

[Prophet731]

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

[iamadeadpixel]

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.

[iamadeadpixel]

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.

[iamadeadpixel]

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 January 11, 2020 by iamadeadpixel
update

[Prophet731]

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.

[iamadeadpixel]

screenshot of the settings...

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

[Prophet731]

14 minutes ago, iamadeadpixel said:

screenshot of the settings...

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

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.

[iamadeadpixel]

The only thing i can think of ,is that i installed adkats (sql that is) after 10 minutes .

[maxdralle]

@iamadeadpixel
your punkbuster is off... no punkbuster = no statslogger. enable pb and it should work

[iamadeadpixel]

well, thats a problem.

most of the platoon members i play with are unfairfull banned by PB, so PB has be turned off so they could play, and even my own platoon members got unfairfull banned.

but that explains a lot.

Thank you maxdralle !

[Rockthis1]

Hello all,

I am running PRoCon Chat, GUID, Stats and Map Logger - 1.0.0.3. and ProconRulz - 44j.1

Could anyone tell or show me how to enable in chat the country of a player while joining the server?

[GK_Nico]

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

Edited February 25, 2020 by GK_Nico

[Hedius]

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 February 25, 2020 by Hedius

[GK_Nico]

Okay thanks I will do when my server is well visited again ..

[mikalexmik]

Hi,

direktly after activating the statslogger, i get following messages.

I'm using RoCon Chat, GUID, Stats and Map Logger - 1.0.0.3.

I'm at a loss what to do.

 

[Checka_Wiemi]

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?

[Hedius]

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?

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 April 22, 2020 by Hedius

[Checka_Wiemi]

7 minutes ago, Hedius said:

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.

man, I really love you

Thanks a lot!

[To22ek95PL]

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??

[Hedius]

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 April 24, 2020 by Hedius

[To22ek95PL]

[Hedius]

2 minutes ago, to22ek said:

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?

[To22ek95PL]

I workin on this plugin about 5 days and no errors. Its my database screen 

[Prophet731]

Stats don't collect until the end of a completed round.

[To22ek95PL]

I know but on my server i completed 50+ rounds and nothing 

Edited April 24, 2020 by to22ek

[Prophet731]

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.

[To22ek95PL]

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

[Hedius]

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 April 24, 2020 by Hedius

[To22ek95PL]

When i type something on chat its shows on database. When switching to another debug level i see only followed guns and not suported guns like p90 or jng 90