Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Hodor*:

 

To enable plugin debugging in your procon.cfg file on the layer side there is a enablePluginDebugging setting. Change that from False to True. Reboot your layer. Once that is enabled you should see the D in those exceptions change to a number, or see the :0 change to a file name and line number. That's the info I need.

Code:

[19:36:13 56] [AdKats] EXCEPTION-68078-D-FetchPlayerStatInformation-HackerChecker36: [Error while parsing player stats data.][System.NullReferenceException: Object reference not set to an instance of an object
  at PRoConEvents.AdKats.FetchPlayerStatInformation (PRoConEvents.AdKatsPlayer aPlayer) [0x00000] in <filename unknown>:0 ]

procon.private.options.enablePluginDebugging True

Any guesses why not changed error?

 

My full cfg without server details:

/////////////////////////////////////////////

// This config will be overwritten by procon.

/////////////////////////////////////////////

procon.private.window.position Normal 0 0 0 0

procon.private.options.setLanguage "au.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 False

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 False

procon.private.options.runPluginsInSandbox False

procon.private.options.allowAllODBCConnections False

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 27360 "0.0.0.0"

procon.private.options.trustedHostDomainsPorts

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

procon.private.options.pluginMaxRuntime 0 59

procon.private.options.UsePluginOldStyleLoad False

procon.private.options.enablePluginDebugging True

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Code:

[19:36:13 56] [AdKats] EXCEPTION-68078-D-FetchPlayerStatInformation-HackerChecker36: [Error while parsing player stats data.][System.NullReferenceException: Object reference not set to an instance of an object
  at PRoConEvents.AdKats.FetchPlayerStatInformation (PRoConEvents.AdKatsPlayer aPlayer) [0x00000] in <filename unknown>:0 ]

Any guesses why not changed error?

 

My full cfg without server details:

You should see AdKats.dll, AdKats.cs, and AdKats.pdb files in your /BF4 directory. Do you see these files?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Was the issue i Posted a while ago (sudden changes in the rights of Full admins, and their role settings, like spectator blacklist not ignorable) among this? I lost track about that

Sudden removal of admin rights was fixed some time ago. Groups i don't remember.

[ImportBot]

Originally Posted by Hodor*:

 

You should see AdKats.dll, AdKats.cs, and AdKats.pdb files in your /BF4 directory. Do you see these files?

AdKats.cs, AdKats.dll and AdKats.dll.mdb

[ImportBot]

Originally Posted by schmoove*:

 

I moved the database from an online host to a local machine, that I also run procon on, exported tables from the online host, then imported them in to the local database. I have noticed since that !punish looks like it works but then never gets stored in the database, I don't know if something is locked in a table or I missed something on the export/import. Is there anyway to check if all structure is there with a script or something that won't wipe the tables, or is something else causing this issue?

[ImportBot]

Originally Posted by smogsy*:

 

So tonight the following happened.

 

All

adkats Roles Settings reset to Deny for everything

Adkat Role Group settings reset to Deny for everything.

All bans Wiped.

 

i guess either go to a backup. or start from scratch.

 

Auto Update on.

[ImportBot]

Originally Posted by mambochambo*:

 

hello-

i get this error:

ERROR-68079: [unable to confirm global timing. Global UTC Timestamp could not be fetched

i set UTC for my Database, but i still getting this error. Can somebody help me to fix that?

[ImportBot]

Originally Posted by iraqiboy90*:

 

It doesnt seem to fire

 

US was the loosing team at this line

 

US Rate: -20.92 (-18.58) t/m | RU Rate: -1.97 (0) t/m | ConquestLarge0

 

Settings:

Loosing team Max -100

Loosing team Min -15

Winning team Max -5

Winning team Min 0

Triggers 1

Ticket gap 100

[ImportBot]

Originally Posted by QuadPrime*:

 

This is definitly not fixed. I still cant ignore Spectator Blacklist for the role Full Admin. AdKats accepts it, and changes that back in a matter of seconds. (this was the post)

 

well seince i appear to be the only one haiving this issue i guess i'll have to work it around somehow...

[ImportBot]

Originally Posted by wdfstryfe*:

 

What is crashing?

PRoCon crashes on a regular basis. After a few days of the server running you can issue a command in game and it wont actually see it occurring for sometimes up to 5 minutes. I know it has something to do with the database but I'm not sure how to go about correcting it. Is there any queries I can run to clean up bad or old records? Chat logs?

[ImportBot]

Originally Posted by Hodor*:

 

[21:30:25 98] [AdKats] INFO: STATDIFF - MrGlanzz - M9 [1/1][100 DPS][+85%]

[21:30:53 54] [AdKatsLRT] SgtBratwurst2808 SPAWN KILLED for invalid loadout.

[21:31:16 95] [AdKats] INFO: STATDIFF - BOBAH2142 - CZ3A1 [3/8][38 DPS][+56%]

[21:31:35 97] [AdKatsLRT] dmsda JOIN KILLED for invalid loadout.

[21:31:36 64] [AdKats] EXCEPTION-68078-D-FetchPlayerStatInformation-HackerChecker36: [Error while parsing player stats data.][system.NullReferenceException: Object reference not set to an instance of an object

at PRoConEvents.AdKats.FetchPlayerStatInformation (PRoConEvents.AdKatsPlayer aPlayer) [0x00000] in :0 ]

[ImportBot]

Originally Posted by Fonta*:

 

Hi CCC,

 

We are currently running adkats on a procon layer hosted at gamed.de.

Since they are running procon in sandbox mode, I have to add every host plugins connects to, to a whitelist.cfg.

 

The current entries in the list are:

Code:

149.210.183.21:3306
api.bf3stats.com:80
api.bf3stats.com:443
api.bf4stats.com:80
api.bf4stats.com:443

sourceforge.net:80
sourceforge.net:443
api.gamerethos.net:80
api.gamerethos.net:443
ip-api.com:80
ip-api.com:443
metabans.com:80
metabans.com:443
www.timeanddate.com:80
www.timeanddate.com:443

githubusercontent.com:80
github.com
github.com:80
raw.github.com:80
raw.github.com:443
192.30.252.128:80
raw.githubusercontent.com
raw.githubusercontent.com:80
raw.githubusercontent.com:443
185.31.17.133:80
gamerethos.net
gamerethos.net:80
104.28.13.90:80

But I'm still getting this error:

Code:

[14:51:18 18] [AdKats] EXCEPTION-68078-D-<CheckForPluginUpdates>b__d4b-PluginUpdater16: [Error while running update thread.][System.Security.SecurityException: Fehler bei der Anfrage.
   bei PRoConEvents.AdKats.CompilePluginSource(String pluginSource)
   bei PRoConEvents.AdKats.UpdateExtensions(String dllPath)
   bei PRoConEvents.AdKats.<CheckForPluginUpdates>b__d4b()
Die Aktion, bei der ein Fehler aufgetreten ist:
LinkDemand
Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:
System.Security.PermissionSet
Die Zone der Assembly, bei der ein Fehler aufgetreten ist:
MyComputer]

What should I add to the whitelist?

[ImportBot]

Originally Posted by muhevana*:

 

pff... i get this error

 

Attached Files:

• kdEBTrW.jpg
• NSWrQ2l.jpg

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

The last couple weeks have been crazy busy and I am trying to find time to catch up on things. Right now on a business trip cross-country and won't be back until later this week, but i'll try to work on things and answer questions from here at night.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

AdKats.cs, AdKats.dll and AdKats.dll.mdb

Strange, i guess linux does not produce those file types. Sorry, i do not offer full support for that operating system for reasons previously mentioned. At least for this time. I have never done full testing on it and don't have the time/ability to do so right now.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I moved the database from an online host to a local machine, that I also run procon on, exported tables from the online host, then imported them in to the local database. I have noticed since that !punish looks like it works but then never gets stored in the database, I don't know if something is locked in a table or I missed something on the export/import. Is there anyway to check if all structure is there with a script or something that won't wipe the tables, or is something else causing this issue?

Sounds like your tables/triggers are messed up. You need to do the following.

 

Firstly check that you have two triggers on your adkats_records_main table, one for add and one for delete. If you do not have these, tell me, and don't continue through these steps.

 

Shut down your layers.

 

Back up your records table. Just that table.

 

TRUNCATE `adkats_records_main`;

TRUNCATE `adkats_records_debug`;

TRUNCATE `adkats_infractions_global`;

TRUNCATE `adkats_infractions_server`;

 

Re-import your records table.

 

Your infractions will be correct again.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

So tonight the following happened.

 

All

adkats Roles Settings reset to Deny for everything

Adkat Role Group settings reset to Deny for everything.

All bans Wiped.

 

i guess either go to a backup. or start from scratch.

 

Auto Update on.

If your bans are gone something else happened outside this system, there is no code in the plugin to delete bans from the database. It sounds like something wiped out your adkats_rolecommands and adkats_bans tables, which would cause what your are seeing. Either way it's not possible from within the plugin.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hello-

i get this error:

ERROR-68079: [unable to confirm global timing. Global UTC Timestamp could not be fetched

i set UTC for my Database, but i still getting this error. Can somebody help me to fix that?

I should remove that message. It does not affect the plugin's function as i have backup systems in place, it should only be a warning.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

It doesnt seem to fire

 

US was the loosing team at this line

 

US Rate: -20.92 (-18.58) t/m | RU Rate: -1.97 (0) t/m | ConquestLarge0

 

Settings:

Loosing team Max -100

Loosing team Min -15

Winning team Max -5

Winning team Min 0

Triggers 1

Ticket gap 100

-15 is not smaller than -100, you have your min/max flipped around. Open a ticket for me to make that impossible to enter that way. Min should not be bigger than max, -15 is bigger than -100.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

This is definitly not fixed. I still cant ignore Spectator Blacklist for the role Full Admin. AdKats accepts it, and changes that back in a matter of seconds. (this was the post)

 

well seince i appear to be the only one haiving this issue i guess i'll have to work it around somehow...

Send me creds for your layer and i'll look at it.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

PRoCon crashes on a regular basis. After a few days of the server running you can issue a command in game and it wont actually see it occurring for sometimes up to 5 minutes. I know it has something to do with the database but I'm not sure how to go about correcting it. Is there any queries I can run to clean up bad or old records? Chat logs?

You aren't doing daily layer reboots? That's generally a good idea, I would consider setting that up.

 

But, to check for database issues. Reboot your layer and wait till AdKats has been running for 5-10 minutes, then enter 3958 as the debug level in AdKats. That will spit out metrics for how long it takes for average queries to your db. Let me know what those numbers are.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

[21:30:25 98] [AdKats] INFO: STATDIFF - MrGlanzz - M9 [1/1][100 DPS][+85%]

[21:30:53 54] [AdKatsLRT] SgtBratwurst2808 SPAWN KILLED for invalid loadout.

[21:31:16 95] [AdKats] INFO: STATDIFF - BOBAH2142 - CZ3A1 [3/8][38 DPS][+56%]

[21:31:35 97] [AdKatsLRT] dmsda JOIN KILLED for invalid loadout.

[21:31:36 64] [AdKats] EXCEPTION-68078-D-FetchPlayerStatInformation-HackerChecker36: [Error while parsing player stats data.][system.NullReferenceException: Object reference not set to an instance of an object

at PRoConEvents.AdKats.FetchPlayerStatInformation (PRoConEvents.AdKatsPlayer aPlayer) [0x00000] in :0 ]

Interesting, some player's stats are coming through but others aren't. So this doesn't have to do with the same Linux issue I saw before. I still don't know where in that section this error is coming from. Open a ticket and i'll examine it closer now that i know it's not from the OS.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi CCC,

 

We are currently running adkats on a procon layer hosted at gamed.de.

Since they are running procon in sandbox mode, I have to add every host plugins connects to, to a whitelist.cfg.

 

The current entries in the list are:

Code:

149.210.183.21:3306
api.bf3stats.com:80
api.bf3stats.com:443
api.bf4stats.com:80
api.bf4stats.com:443

sourceforge.net:80
sourceforge.net:443
api.gamerethos.net:80
api.gamerethos.net:443
ip-api.com:80
ip-api.com:443
metabans.com:80
metabans.com:443
www.timeanddate.com:80
www.timeanddate.com:443

githubusercontent.com:80
github.com
github.com:80
raw.github.com:80
raw.github.com:443
192.30.252.128:80
raw.githubusercontent.com
raw.githubusercontent.com:80
raw.githubusercontent.com:443
185.31.17.133:80
gamerethos.net
gamerethos.net:80
104.28.13.90:80

But I'm still getting this error:

Code:

[14:51:18 18] [AdKats] EXCEPTION-68078-D-<CheckForPluginUpdates>b__d4b-PluginUpdater16: [Error while running update thread.][System.Security.SecurityException: Fehler bei der Anfrage.
   bei PRoConEvents.AdKats.CompilePluginSource(String pluginSource)
   bei PRoConEvents.AdKats.UpdateExtensions(String dllPath)
   bei PRoConEvents.AdKats.<CheckForPluginUpdates>b__d4b()
Die Aktion, bei der ein Fehler aufgetreten ist:
LinkDemand
Der Typ der ersten Berechtigung, bei der ein Fehler aufgetreten ist:
System.Security.PermissionSet
Die Zone der Assembly, bei der ein Fehler aufgetreten ist:
MyComputer]

What should I add to the whitelist?

Just like insane limits, AdKats is not meant to run in sandbox. That error is from the plugin failing to compile the updated plugin source and write the updated plugin to your layer's file system. Sandboxing blocks that. You need to turn off sandbox.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

pff... i get this error

Did you follow the install instructions?

[ImportBot]

Originally Posted by muhevana*:

 

Thanks for answering.

 

Yes im reading that installation manual again again and again. My little problem is this my eng is not very good. This plugin is installed and working " Procon Chat, GUID, Stats and Mapstats Logger " Step 3 Run the contents of the AdKats Database Setup Script on your database, on the same schema stat logger uses. This is making me a trouble. I maded copy that script txt but where i must paste it? I think here im stucked.

[ImportBot]

Originally Posted by staazvaind*:

 

I had a gamed!.de server once too. their sandbox setting annoyed me that much, that i just bought

an additional procon layer somewhere else to connect to my server - saves you lots of trouble.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Thanks for answering.

 

Yes im reading that installation manual again again and again. My little problem is this my eng is not very good. This plugin is installed and working " Procon Chat, GUID, Stats and Mapstats Logger " Step 3 Run the contents of the AdKats Database Setup Script on your database, on the same schema stat logger uses. This is making me a trouble. I maded copy that script txt but where i must paste it? I think here im stucked.

You need to run the contents of the adkats.sql script on your database. If you don't know how, please ask your database host to run it.

[ImportBot]

Originally Posted by muhevana*:

 

You need to run the contents of the adkats.sql script on your database. If you don't know how, please ask your database host to run it.

Im now very confused. Here is message what nitrado sent me" there is no database for the battlefield server. Therefore, the named procedure by the developer can not be executed. "

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Im now very confused. Here is message what nitrado sent me" there is no database for the battlefield server. Therefore, the named procedure by the developer can not be executed. "

Talk to your database host, not your server host.

[ImportBot]

Originally Posted by muhevana*:

 

Talk to your database host, not your server host.

I dont have any database i think :/ i say seriously im a noob and i try learn every day new stuff