Advanced In-Game Admin and Ban Enforcer - AdKats

ImportBot · April 6, 2016

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 · April 6, 2016

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 · April 6, 2016

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 · April 6, 2016

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 · April 7, 2016

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 · April 7, 2016

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 · April 7, 2016

Originally Posted by keb2*:

Hi.I get this error

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

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

Help fix it

ColColonCleaner · April 7, 2016

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 · April 8, 2016

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 · April 8, 2016

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 · April 8, 2016

Originally Posted by Junior-Zancan*:

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

Thank you.

ImportBot · April 8, 2016

Originally Posted by keb2*:

Run this command /pupdate

Reboot your procon layer

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

Error remained

ColColonCleaner · April 8, 2016

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 · April 9, 2016

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 · April 10, 2016

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 · April 11, 2016

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 · April 11, 2016

Originally Posted by keb2*:

Advanced In-Game Admin - 6.8.1.90

Error remained

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

ColColonCleaner · April 11, 2016

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 · April 11, 2016

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 · April 11, 2016

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 · April 11, 2016

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 · April 11, 2016

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 · April 11, 2016

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 · April 11, 2016

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 · April 11, 2016

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 · April 11, 2016

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 · April 12, 2016

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 · April 12, 2016

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 · April 12, 2016

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 · April 12, 2016

Originally Posted by Chilace*:

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

Sign In

Advanced In-Game Admin and Ban Enforcer - AdKats

Recommended Posts

Link to comment

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Prophet731

maddog

Hedius

Posted Images

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Join the conversation

Important Information