Chat, GUID, Stats and Mapstats Logger [1.0.0.3]

[ImportBot]

Originally Posted by Scheibes*:

 

Hab dort den Business Tarif.

 

Hab aber jetzt mal testweise bei db4free.net eine Datenbank angelegt um zu testen ob es dort geht.

 

Fehler:

Error: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

bei System.Security.CodeAccessPermission.Demand()

bei System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

bei System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

bei System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

bei MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

bei MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

bei MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

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

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

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

bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bei MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bei MySql.Data.MySqlClient.MySqlPool.GetConnection()

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

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

Die Aktion, bei der ein Fehler aufgetreten ist:

Demand

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

System.Net.SocketPermission

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

MyComputer

[13:00:38 96] Error: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoConEvents.CChatGUIDStatsLogger.tablebuilder()

[ImportBot]

Originally Posted by XpKiller*:

 

New Version 1.0.0.2 is released

 

This version is now the recommended version.

 

Changelog:

1.0.0.2

Bugfixes for column errors.

Bugfixes for the sessions streaming bug

Weaponstats working again.

Bugfix for Identifier name is too long.

[ImportBot]

Originally Posted by Hand-of-Shadow*:

 

update sql statement ? for update the db from

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

_BF4 PRoCon Chat, GUID, Stats and Mapstats Logger[1.0.0.2] ?

[ImportBot]

Originally Posted by XpKiller*:

 

update sql statement ? for update the db from

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

_BF4 PRoCon Chat, GUID, Stats and Mapstats Logger[1.0.0.2] ?

Maybe tonight i have some time for it.

[ImportBot]

Originally Posted by victory-Gamerz*:

 

This is what im getting no matter what host-name i use local-host or the ip... i have never done a mysqladmin flush-hosts any help?

 

[statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Host '69.31.134.74' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

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

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

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

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by rbtmarshall*:

 

New Version 1.0.0.2 is released

 

This version is now the recommended version.

 

Changelog:

1.0.0.2

Bugfixes for column errors.

Bugfixes for the sessions streaming bug

Weaponstats working again.

Bugfix for Identifier name is too long.

Thank You.

 

Just installed the plugin update and was glad to see my settings were kept. no errors

[ImportBot]

Originally Posted by victory-Gamerz*:

 

Ok got the mysqlflush done now i get a new one some one help me here my web host sucks for support

 

 

 

[statslogger]Error: getUpdateServerID1: MySql.Data.MySqlClient.MySqlException: Authentication method 'mysql_old_password' not supported by any of the available plugins.

at MySql.Data.MySqlClient.Authentication.Authenticati onPluginManager.GetPlugin(String method)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.GetPlugin(String method, NativeDriver driver, Byte[] authData)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.HandleAuthChange(MySqlPacket packet)

at MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)

at MySql.Data.MySqlClient.NativeDriver.Authenticate(S tring authMethod, Boolean reset)

at MySql.Data.MySqlClient.NativeDriver.Open()

at MySql.Data.MySqlClient.Driver.Open()

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

at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

at MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

at MySql.Data.MySqlClient.MySqlPool.GetConnection()

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

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by XpKiller*:

 

@victory Gamerz

 

Your Database support the 'mysql_old_password' only. Unfortunately the Mysql Connector bundled with PRoCon, which is used by the stats plugin support the new and secure password auth. only.

[ImportBot]

Originally Posted by farmtool33*:

 

Hello,

I love the plugin , but I got a question , I would like live updating the !Rank/!Stats command. When you do !stats it says 23kills , when you make 5 more kills and do !stats again it shows again 23 kills. When the next map is loaded and you do !stats , you get all your stats.

 

Is there anyway to enable a live-update !stats ?

[ImportBot]

Originally Posted by XpKiller*:

 

@farmtool33

 

not possible right know, but i may addt this request to my todo list.

 

The problem with live stats is if would cause many many additional queries So the requirements to the database will increase too.

[ImportBot]

Originally Posted by ty_ger07*:

 

Hello,

I love the plugin , but I got a question , I would like live updating the !Rank/!Stats command. When you do !stats it says 23kills , when you make 5 more kills and do !stats again it shows again 23 kills. When the next map is loaded and you do !stats , you get all your stats.

 

Is there anyway to enable a live-update !stats ?

The plugin updates all the stats at round end to reduce database load. So I suppose what you are asking for is that it would take the stats in database plus the current round's temporary stats and add them together to display the current temporary total.

[ImportBot]

Originally Posted by farmtool33*:

 

@farmtool33

 

not possible right know, but i may addt this request to my todo list.

 

The problem with live stats is if would cause many many additional queries So the requirements to the database will increase too.

Thank you for the quick answer .

 

Well then maybe a 5minut update or so ?

Would really be nice to have the feature .

 

Anyway great work !!

[ImportBot]

Originally Posted by victory-Gamerz*:

 

@victory Gamerz

 

Your Database support the 'mysql_old_password' only. Unfortunately the Mysql Connector bundled with PRoCon, which is used by the stats plugin support the new and secure password auth. only.

What can I do to get around this? can i use

MySQL Community Edition from my pc?

[ImportBot]

Originally Posted by bFe*:

 

I have a few servers i wish to sync up, is all i need to do type in the same server group id?

[ImportBot]

Originally Posted by Hutchew*:

 

Thanks for the update, XP.

 

Is adkats now fully compatible, or are we still working-around issues?

 

 

Hutchew

[ImportBot]

Originally Posted by XpKiller*:

 

@bFe

Yes, give them all the same ServerGroup and enable merged serverranking.

You can add or remove server to that group at any times without lossing any statsdata.

 

@victory Gamerz

Here is small tutorial:

myrcon.net/.../set-up-a-mysql-server-for-procon

 

Note the ODBC Steps are not needed anymore.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Thanks for the update, XP.

 

Is adkats now fully compatible, or are we still working-around issues?

 

 

Hutchew

Player ID is still not in chat logs, but i have found a better way of storing them now. With this method stat logger can still be used for chat logging and the database will automatically grab player IDs and assign them. It will be with the next release.

[ImportBot]

Originally Posted by Belligerent*:

 

Hey,

 

Is there some way we can use the database that was created with the BF3 plugin with the new version?

 

I read way back that there would be a script?

 

Im having the issue with the "Unknown column GameID in field list"(also with AdKats)

 

Cheers.

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Hey,

 

Is there some way we can use the database that was created with the BF3 plugin with the new version?

 

I read way back that there would be a script?

 

Im having the issue with the "Unknown column GameID in field list"(also with AdKats)

 

Cheers.

He is releasing a script soon to update the old database to the new definition.

[ImportBot]

Originally Posted by Belligerent*:

 

He is releasing a script soon to update the old database to the new definition.

Cheers CC.

[ImportBot]

Originally Posted by Dudenell*:

 

got this error earlier, brand new database

[21:16:31 15] [statslogger]Error: getUpdateServerID1: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

[ImportBot]

Originally Posted by Xjmhd*:

 

For some reason it dosen't log kills, death kdr etc on my servers (As seen here http://stats.nicz.dk/players.php)

 

Here is my settings and settings2

[ImportBot]

Originally Posted by Athlon*:

 

We have two servers, and I installed the updated plugin yesterday and set each server to the same database. Server group is '0' for each server.

 

I started with a clean database for each server.

 

I remember with the BF3 version that it would automatically assign each server a different server ID, and it seems to have done that here as well (1 & 2), but it looks as though the stats are all about server ID 1. There are no stats for server ID 2.

 

For example, when looking at my database in the table tbl_chatlog, every chat yesterday was attributed to ServerID 1.

 

Where could I have gone wrong?

[ImportBot]

Originally Posted by supermillhouse*:

 

Just to check, what is the common id between the dogtag table and the server_player table. This is for counting the number of dog tags kills on server ID whatever.

 

Is it KillerID and PlayerID or KillerID and StatsID

[ImportBot]

Originally Posted by XpKiller*:

 

@Athlon

 

could you check the content of tbl_server?

do you run adkats?

 

@supermillhouse

KillerID StatsID

VictimID StatsID

 

So its

KillerID | VictimID | count

[ImportBot]

Originally Posted by Scheibes*:

 

Ich krieg das Plugin einfach nicht zum laufen!

 

Aktuelle Fehlermeldung....

 

[statslogger]Error: getUpdateServerID1: System.Security.SecurityException: Fehler bei der Anforderung des Berechtigungstyps "System.Net.SocketPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089".

bei System.Security.CodeAccessSecurityEngine.Check(Obj ect demand, StackCrawlMark& stackMark, Boolean isPermSet)

bei System.Security.CodeAccessPermission.Demand()

bei System.Net.Sockets.Socket.CheckCacheRemote(EndPoin t& remoteEP, Boolean isOverwrite)

bei System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)

bei System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)

bei MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

bei MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

bei MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

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

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

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

bei MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection()

bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()

bei MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()

bei MySql.Data.MySqlClient.MySqlPool.GetConnection()

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

bei PRoConEvents.CChatGUIDStatsLogger.getUpdateServerI D(CServerInfo csiServerInfo)

Die Aktion, bei der ein Fehler aufgetreten ist:

Demand

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

System.Net.SocketPermission

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

MyComputer

 

 

Hab jetzt den Account bei db4free.net gelassen, da es hier bei allen bis jetzt funktioniert hat. lt. anderen Foren zumindest.

Vorschläge?

[ImportBot]

Originally Posted by XpKiller*:

 

@Scheibes

 

Entweder muss der host "db4free.net" in die Trusted Hosts oder die Sandbox muss deaktiviert werden. Manche Layeranbieter erlauben auch keine Verbindungen zu externen Datenbanken.

 

Die Tusted hosts werden in die procon.cfg auf dem Layer eingetragen. Ein setzten dieser Einstellung mit dem Client ist nicht möglich.

[ImportBot]

Originally Posted by Athlon*:

 

@Athlon

 

could you check the content of tbl_server?

do you run adkats?

I don't run Adkats.

 

All is good now. My tbl_server content shows both servers. No idea why it wasn't working yesterday, but it's fine now.

 

Thank you for this great plugin!

[ImportBot]

Originally Posted by Scheibes*:

 

@Scheibes

 

Entweder muss der host "db4free.net" in die Trusted Hosts oder die Sandbox muss deaktiviert werden. Manche Layeranbieter erlauben auch keine Verbindungen zu externen Datenbanken.

 

Die Tusted hosts werden in die procon.cfg auf dem Layer eingetragen. Ein setzten dieser Einstellung mit dem Client ist nicht möglich.

Bei mir dürfte dann das die "Server.cfg" in meinem Webinterface von Gamed.de sein oder?

Hier ist bis Dato nur der Gameserver eingetragen (IP, Port und Passwort).

Was muss ich hier wie eintragen?

 

 

Ach jetzt weiß ich was du meinst.....

 

Die procon.cfg sieht bei mir so aus:

procon.private.window.position Normal 182 104 1035 815

procon.private.options.setLanguage "de.loc"

procon.private.options.chatLogging False

procon.private.options.consoleLogging False

procon.private.options.eventsLogging False

procon.private.options.pluginLogging False

procon.private.options.autoCheckDownloadUpdates True

procon.private.options.autoApplyUpdates False

procon.private.options.autoCheckGameConfigsForUpda tes True

procon.private.options.showtrayicon True

procon.private.options.minimizetotray False

procon.private.options.closetotray False

procon.private.options.allowanonymoususagedata True

procon.private.options.runPluginsInSandbox False

procon.private.options.allowAllODBCConnections True

procon.private.options.allowAllSmtpConnections False

procon.private.options.adminMoveMessage True

procon.private.options.chatDisplayAdminName True

procon.private.options.EnableAdminReason False

procon.private.options.layerHideLocalPlugins True

procon.private.options.layerHideLocalAccounts True

procon.private.options.ShowRoundTimerConstantly False

procon.private.options.ShowCfmMsgRoundRestartNext True

procon.private.options.ShowDICESpecialOptions False

procon.private.httpWebServer.enable False 16300 "0.0.0.0"

procon.private.options.trustedHostDomainsPorts db4free.net 3306

procon.private.options.statsLinkNameUrl Metabans http://metabans.com/search/%player_name%

procon.private.options.pluginMaxRuntime 0 59

procon.private.options.UsePluginOldStyleLoad False

procon.private.servers.add "xx.xxx.xxx.xxx" 16300 "passwort" "Benutzname"

 

 

Also müsste das eigentlich auch passen.

Aber Fehlermeldung bleibt wie oben gepostet.

[ImportBot]

Originally Posted by apnotix*:

 

Bei mir dürfte dann das die "Server.cfg" in meinem Webinterface von Gamed.de sein oder?

Hier ist bis Dato nur der Gameserver eingetragen (IP, Port und Passwort).

Was muss ich hier wie eintragen?

 

 

Ach jetzt weiß ich was du meinst.....

 

Die procon.cfg sieht bei mir so aus:

procon.private.window.position Normal 182 104 1035 815

procon.private.options.setLanguage "de.loc"

procon.private.options.chatLogging False

procon.private.options.consoleLogging False

procon.private.options.eventsLogging False

procon.private.options.pluginLogging False

procon.private.options.autoCheckDownloadUpdates True

procon.private.options.autoApplyUpdates False

procon.private.options.autoCheckGameConfigsForUpda tes True

procon.private.options.showtrayicon True

procon.private.options.minimizetotray False

procon.private.options.closetotray False

procon.private.options.allowanonymoususagedata True

procon.private.options.runPluginsInSandbox False

procon.private.options.allowAllODBCConnections True

procon.private.options.allowAllSmtpConnections False

procon.private.options.adminMoveMessage True

procon.private.options.chatDisplayAdminName True

procon.private.options.EnableAdminReason False

procon.private.options.layerHideLocalPlugins True

procon.private.options.layerHideLocalAccounts True

procon.private.options.ShowRoundTimerConstantly False

procon.private.options.ShowCfmMsgRoundRestartNext True

procon.private.options.ShowDICESpecialOptions False

procon.private.httpWebServer.enable False 16300 "0.0.0.0"

procon.private.options.trustedHostDomainsPorts db4free.net 3306

procon.private.options.statsLinkNameUrl Metabans http://metabans.com/search/%player_name%

procon.private.options.pluginMaxRuntime 0 59

procon.private.options.UsePluginOldStyleLoad False

procon.private.servers.add "xx.xxx.xxx.xxx" 16300 "passwort" "Benutzname"

 

 

Also müsste das eigentlich auch passen.

Aber Fehlermeldung bleibt wie oben gepostet.

Das ist aber die procon.cfg von deinem Client Zuhause. Die wirkt sich jedoch nicht auf den Procon Layer aus. Bei gamed!de sind nur die eigenen Datenbanken die beim Server dabei sind als "trustedHostDomainsPorts" eingetragen, jedoch nicht "db4free.net" entweder du benutzt eine von gamed!de oder du musst den Support anschreiben das sie "db4free.net" zu "trustedHostDomainsPorts" hinzufügen sollen. Sandbox deaktivieren machen sie nicht.