Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by wdfstryfe*:

 

Hey ColColon, I was thinking about this with that request I did. I'm sure it can be done just not sure what the correct query is. But, I'd like to get a report of all the people that have reserved slots and how much time they have left currently.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hey ColColon, I was thinking about this with that request I did. I'm sure it can be done just not sure what the correct query is. But, I'd like to get a report of all the people that have reserved slots and how much time they have left currently.

I can write up a query for this shortly.

 

EDIT: It will probably be a query for all groups, not just reserved slots, so everyone can use it.

[ImportBot]

Originally Posted by ripper23*:

 

Ah, i thought you meant the chat logs AdKats uses. If you just want the normal chat logs then you can turn on chat logging on your procon layer. It's in the same place that you turn on event logging and procon plugin logging. You just need to turn on the chat logging option and reboot your layer. If you do not know where this setting is ask your layer host.

oh ok but that will only give me chat logs when I have procon open on my desktop right? what about getting chat logs when I am not attending the server and can go look at them later?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

oh ok but that will only give me chat logs when I have procon open on my desktop right? what about getting chat logs when I am not attending the server and can go look at them later?

No, turning that setting on with the layer will create log files every day for chat. They are always updated throughout the day but a new one is created for each day.

[ImportBot]

Originally Posted by Pallywhacker*:

 

Our database was logging all data. Then it abruptly started logging only soldier name and EA Guid. Can anyone tell me what happened? Is there a way to get the database logging all data again? Please see attached photo. Thanks in advance.

 

Database 46 2016.JPG

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Our database was logging all data. Then it abruptly started logging only soldier name and EA Guid. Can anyone tell me what happened? Is there a way to get the database logging all data again? Please see attached photo. Thanks in advance.

 

Database 46 2016.JPG

You turned off your stat logger plugin?

[ImportBot]

Originally Posted by keb2*:

 

Hi.I get this error

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

Help fix it

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi.I get this error

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 65] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

[11:15:57 66] [AdKats] ERROR-6810: [player was null in hasAccess.]

Help fix it

Run this command /pupdate

 

Reboot your procon layer

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

 

Is there a function that protects for player from Kick, ban, tban? So that administrators who have the status of less than "Full admin" could not be applied Kick, ban, tban to protected player.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

@ColColonCleaner

 

Is there a function that protects for player from Kick, ban, tban? So that administrators who have the status of less than "Full admin" could not be applied Kick, ban, tban to protected player.

There is the command whitelist, which you can set up to block a list of commands on those whitelisted. However, that means no admin can issue those commands on them. I don't have a list of override roles which bypass the whitelist, you'll need to request a feature for that.

[ImportBot]

Originally Posted by Junior-Zancan*:

 

There's some way to execute a Yell command from database? Via "adkats_orchestration" or something?

 

Thank you.

[ImportBot]

Originally Posted by keb2*:

 

Run this command /pupdate

 

Reboot your procon layer

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

 

Error remained

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

[08:07:52 18] [AdKats] ERROR-68189: [player was null in hasAccess.]

 

Error remained

Hmmm, i'll look into it.

[ImportBot]

Originally Posted by HitchItch*:

 

I have a few questions,

We just starting using A13-2 Ban enforcer settings.

Our setup:

use ban enforcer=true

enforce bans by name, guid,ip are set to true

use metabans=true

metabans username= entered the name

metabans api key= entered the api key

 

metabans filter strings= this section is blank, I dont see anything telling us what this is for?

 

After we set the above the below name and guid ban count went to the below listed. Those numbers have not changed in two weeks, is this proper? We are following cheat detector, I Stats and ADK Gamers in metabans

A13-3 Mini Ban Management:

name ban count=19

guid ban count= 54

ban search= blank, no entry

 

I would have thought the ban count would have changed as time goes on since we follow the above mentioned. I just want to make sure Im not missing something

 

 

One other question:

We are using almost every section of adkats and adkats lrt. Is there a way to backup/export the entire plug in? Our procon layer host has screwed us in the past and had to factory reset the layer which meant we needed to upload the plugins and input all of the settings manually again from scratch. This is a lengthy process for adkats since we have so much setup. It would be great to backup everything including all of our settings and then just upload it to procon again if our providers screws us again in the future.

Any help on this would be greatly appreciated

 

Hitch

[ImportBot]

Originally Posted by kcuestag*:

 

So our BF4 provider got a huge DDOS attack an hour ago and since then Procon is throwing MySQL errors for both AdKats and the Stats plugin:

 

 

Code:

[19:17:12 63] [Statslogger]Error: LogChat: 
[19:17:12 63] Message: Lock wait timeout exceeded; try restarting transaction
[19:17:12 63] Native: -2147467259
[19:17:12 63] Source: MySql.Data
[19:17:12 63] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)
[19:17:12 63] [Statslogger]Error: LogChat_2: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)
[19:17:20 86] [AdKats] INFO: Average Read: 0.035s 2611 | Average Write: 0.035s 399
[19:17:20 86] [AdKats] INSERT INTO `adkats_records_main`
                            (
                                `server_id`, 
                                `command_type`, 
                                `command_action`, 
                                `command_numeric`, 
                                `target_name`, 
                                `target_id`, 
                                `source_name`, 
                                `source_id`, 
                                `record_message`, 
                                `record_time`, 
                                `adkats_read`
                            ) 
                            VALUES 
                            ( 
                                1, 
                                49, 
                                49,
                                0,
                                VProge, 
                                18144, 
                                AdKats, 
                                NULL, 
                                xx.xxx.xx.xxx (This was a server ip address), 
                                UTC_TIMESTAMP(), 
                                Y
                            )
[19:17:20 86] [AdKats] WARNING: Database connection issue detected. Trigger 13/15.

Any idea what it could be?

 

 

Edit:

 

Seems to be working correctly again now.

[ImportBot]

Originally Posted by CEBEP78*:

 

[02:05:26 98] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:29 47] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:31 96] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:34 47] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:36 97] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:39 57] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

 

Hello, permanent error, advise how to fix?

[ImportBot]

Originally Posted by keb2*:

 

Advanced In-Game Admin - 6.8.1.90

Error remained

[AdKats] ERROR-68189: [player was null in hasAccess.]

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I have a few questions,

We just starting using A13-2 Ban enforcer settings.

Our setup:

use ban enforcer=true

enforce bans by name, guid,ip are set to true

use metabans=true

metabans username= entered the name

metabans api key= entered the api key

 

metabans filter strings= this section is blank, I dont see anything telling us what this is for?

 

After we set the above the below name and guid ban count went to the below listed. Those numbers have not changed in two weeks, is this proper? We are following cheat detector, I Stats and ADK Gamers in metabans

A13-3 Mini Ban Management:

name ban count=19

guid ban count= 54

ban search= blank, no entry

 

I would have thought the ban count would have changed as time goes on since we follow the above mentioned. I just want to make sure Im not missing something

 

 

One other question:

We are using almost every section of adkats and adkats lrt. Is there a way to backup/export the entire plug in? Our procon layer host has screwed us in the past and had to factory reset the layer which meant we needed to upload the plugins and input all of the settings manually again from scratch. This is a lengthy process for adkats since we have so much setup. It would be great to backup everything including all of our settings and then just upload it to procon again if our providers screws us again in the future.

Any help on this would be greatly appreciated

 

Hitch

Firstly. Connecting AdKats to metabans only pushes new bans YOU ADD up to metabans' servers, it does not do anything else. This is because the actual metabans plugin reads info out of the procon banlist, and using the AdKats ban enforcer bypasses that list for admin-issued bans. You still need to use the metabans plugin for all the other functionality metabans offers like enforcing followed bans.

 

Secondly. Those ban counts are only counting bans you and your admins have issued and the server is currently enforcing locally, it does not include any bans associated with other groups/metabans/etc.

 

Thirdly. All settings are backed up in the database by server. This means as soon as you connect a new layer or replacement layer to a server with the same IP all the settings for that server are automatically loaded. If you have a new server and want to import settings from another server, just enter that server's ID in the 'setting import' setting, and it will automatically load in the settings from that server.

[ImportBot]

Originally Posted by ripper23*:

 

No, turning that setting on with the layer will create log files every day for chat. They are always updated throughout the day but a new one is created for each day.

oh ok where are they located i must not be looking in the right place?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

So our BF4 provider got a huge DDOS attack an hour ago and since then Procon is throwing MySQL errors for both AdKats and the Stats plugin:

 

 

Code:

[19:17:12 63] [Statslogger]Error: LogChat: 
[19:17:12 63] Message: Lock wait timeout exceeded; try restarting transaction
[19:17:12 63] Native: -2147467259
[19:17:12 63] Source: MySql.Data
[19:17:12 63] StackTrace:    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)
[19:17:12 63] [Statslogger]Error: LogChat_2: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErrorCollection(MySqlException myException)
   at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)
[19:17:20 86] [AdKats] INFO: Average Read: 0.035s 2611 | Average Write: 0.035s 399
[19:17:20 86] [AdKats] INSERT INTO `adkats_records_main`
                            (
                                `server_id`, 
                                `command_type`, 
                                `command_action`, 
                                `command_numeric`, 
                                `target_name`, 
                                `target_id`, 
                                `source_name`, 
                                `source_id`, 
                                `record_message`, 
                                `record_time`, 
                                `adkats_read`
                            ) 
                            VALUES 
                            ( 
                                1, 
                                49, 
                                49,
                                0,
                                VProge, 
                                18144, 
                                AdKats, 
                                NULL, 
                                xx.xxx.xx.xxx (This was a server ip address), 
                                UTC_TIMESTAMP(), 
                                Y
                            )
[19:17:20 86] [AdKats] WARNING: Database connection issue detected. Trigger 13/15.

Any idea what it could be?

 

 

Edit:

 

Seems to be working correctly again now.

Lock wait timeout happens with transactional DB engines, and moreso when the DB is under stress. All that happens is the query is cancelled. Stat logger does not handle this error very well, while AdKats just retries the query it attempted.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

[02:05:26 98] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:29 47] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:31 96] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:34 47] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:36 97] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

[02:05:39 57] [AdKats] EXCEPTION-68185-FetchPlayerBattlelogInformation-BattlelogComm53572: [Could not find persona ID for gigafan645 [GER]]

 

Hello, permanent error, advise how to fix?

This is an issue i'm working to resolve. Some players do not have "valid" names. For example they have spaces or brackets in their player name for some reason. AdKats does not handle this very well since it was built for BF3 where those characters were not allowed. I tried an initial patch but it failed.

[ImportBot]

Originally Posted by CEBEP78*:

 

This is an issue i'm working to resolve. Some players do not have "valid" names. For example they have spaces or brackets in their player name for some reason. AdKats does not handle this very well since it was built for BF3 where those characters were not allowed. I tried an initial patch but it failed.

Thank you, we will wait for the decision problem then.

 

 

And another very important question !! very important!!

Dear ColColonCleaner, using punish team players reveals (chat or yellow text, who both put) only the number of items of violations(pts), and violations of time does not show how to make the time and showed the ban?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Advanced In-Game Admin - 6.8.1.90

Error remained

[AdKats] ERROR-68189: [player was null in hasAccess.]

Does this happen all the time? Does it happen right when you start the plugin?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Thank you, we will wait for the decision problem then.

 

 

And another very important question !! very important!!

Dear ColColonCleaner, using punish team players reveals (chat or yellow text, who both put) only the number of items of violations(pts), and violations of time does not show how to make the time and showed the ban?

I do not understand what you are asking about. Please put more information about what is wrong.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

oh ok where are they located i must not be looking in the right place?

Should just be in the /logs/YourServerIPAndPort folder.

 

You will see things like this:

 

plugin_today'sdate.log

chat_today'sdate.log

 

look in the chat_today'sdate.log file for your chat logs.

[ImportBot]

Originally Posted by CEBEP78*:

 

Does this happen all the time? Does it happen right when you start the plugin?

This happened two days, and after switching off the plugin. Today this error is gone.

 

------

 

 

 

I do not understand what you are asking about. Please put more information about what is wrong.

Dear ColColonCleaner, using punish team players reveals (chat or yellow text, who both put) only the number of items of violations(pts), and violations of time does not show how to make the time and showed the ban?

After points, the current time to ban showed?

HsuTZrE.jpg

[ImportBot]

Originally Posted by keb2*:

 

Does this happen all the time? Does it happen right when you start the plugin?

It happens all the time

[ImportBot]

Originally Posted by kcuestag*:

 

Lock wait timeout happens with transactional DB engines, and moreso when the DB is under stress. All that happens is the query is cancelled. Stat logger does not handle this error very well, while AdKats just retries the query it attempted.

Yeah, it was caused by +260Gbps DDOS attack.

 

It started working again a few hours later.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

This happened two days, and after switching off the plugin. Today this error is gone.

 

------

 

 

 

 

 

Dear ColColonCleaner, using punish team players reveals (chat or yellow text, who both put) only the number of items of violations(pts), and violations of time does not show how to make the time and showed the ban?

After points, the current time to ban showed?

HsuTZrE.jpg

I do not understand what the issue is.

 

What is not working?

 

How do you want it to work?

[ImportBot]

Originally Posted by Chilace*:

 

I think he wants to see a duration of tempban additionaly to infraction points in punish message.