Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by wdfstryfe*:

 

BF4DB already has that feature built into. Check bfrcon.com.

[ImportBot]

Originally Posted by Fonta*:

 

I would rather have it in AdKats/Procon.

 

Hmm, seems like I'm not the only one.

Missed a few posts above.

I'm also looking for something like this:

https://github.com/AdKats/AdKats/issues/534

But not with a command, just automatically would be nice.

[ImportBot]

Originally Posted by Chilace*:

 

BF4DB already has that feature built into. Check bfrcon.com.

bfrcon requires a monthly payment.

[ImportBot]

Originally Posted by Antivanity*:

 

Here is the existing feature request: https://github.com/AdKats/AdKats/issues/534

 

Let me know all the options/features you want it to have on that issue and we can discuss it then.

I have added to the issue on github. thanks

[ImportBot]

Originally Posted by Ruger*:

 

Hey C3,

 

Running adkats 6.7.0.114 and yesterday I noticed under the player layer control/plugins tab it was spamming

[AdKats] EXCEPTION-670114-FetchPlayerBattlelogInformation-BattlelogComm18: [Could not find persona ID for []V[]orpheus]

I restarted the layer and it stopped. Tonight I noticed the same thing going on and once again rebooted the layer to get it to stop.

 

While the individual had been playing on our server yesterday he was not on when I noticed it doing it yesterday and he hadnt played on our server today.

 

Any clue as to what is going on?

 

Thanks, Ruger

[ImportBot]

Originally Posted by dyn*:

 

Experienced the same issue as Ruger the other day. Will see if we kept any logs of the player's name to look for a pattern.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Excellent. Fetching persona ids should never fail, please post the names.

 

Sent from my SM-G920P using Tapatalk

[ImportBot]

Originally Posted by dmmaciag*:

 

If it was working for a while then stopped something happened to either your layer or database. Make sure your user for AdKats is the same as stat logger.

 

Shut down your layers running AdKats.

 

Run this setup script: https://raw.githubusercontent.com/Ad...ter/adkats.sql

 

Install this version of AdKats: https://raw.githubusercontent.com/Ad...test/AdKats.cs

 

Start your layers.

 

Let me know if the problem continues.

I am still encountering this issue. I've even re-imported that script and it's still giving me the same error. I'm unsure of how to proceed.

 

EDIT: Looking at PHPMyAdmin I'm seeing most of the AdKats tables and some others are InnoDB whereas the others are MyISAM. I'm not sure what that means or if that's what's causing the issue but how can I correct it, or do I need to wipe and start from scratch?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I am still encountering this issue. I've even re-imported that script and it's still giving me the same error. I'm unsure of how to proceed.

 

EDIT: Looking at PHPMyAdmin I'm seeing most of the AdKats tables and some others are InnoDB whereas the others are MyISAM. I'm not sure what that means or if that's what's causing the issue but how can I correct it, or do I need to wipe and start from scratch?

None of the tables related to this plugin or stat logger should be in MyISAM, all tables should be InnoDB.

 

If you are not at risk of losing important data by doing a wipe I would suggest that. If losing data would be an issue, please list the tables that are not in InnoDB and we can move from there.

[ImportBot]

Originally Posted by dmmaciag*:

 

Looks like the only tables that are MyISAM are the fbacp? tables and adkats_battlelog_players table. Everything else is InnoDB. Thanks for your help.

[Prophet731]

Originally Posted by Prophet731*:

 

Looks like the only tables that are MyISAM are the fbacp? tables and adkats_battlelog_players table. Everything else is InnoDB. Thanks for your help.

Run these queries on the DB.

 

myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry40360

[ImportBot]

Originally Posted by dmmaciag*:

 

I have done so. It affected all of the MyISAM tables except for two (bfacp_migrations and bfacp_sessions) and made them all InnoDB. I made the change to those last two tables as well so they are all showing as InnoDB but the problem is still persisting.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I have done so. It affected all of the MyISAM tables except for two (bfacp_migrations and bfacp_sessions) and made them all InnoDB. I made the change to those last two tables as well so they are all showing as InnoDB but the problem is still persisting.

If you are able to wipe all tables related to these projects please do, then just set up the stuff for AdKats. I would like to make sure that is correct on your system before you try to get the ACP online at the same time.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I'm issuing the !lock player command on an admin. The punish system I use does a say /!punish PLAYER NO EXPLOSIVES for instance. In the past when I lock a player from commands they won't get punished per say for using an explosive. But now when they for instance use C4 they get punished instead of it saying the player is command locked.

It's because you are locking them from the same place issuing the punishment.

 

You being on procon and issuing lock is the same as a plugin issuing an admin say for commands. Both procon's chat tab and any plugins issuing says to execute commands are from the same origin 'ProconAdmin'. Players are not locked to the admin who locked them.

[ImportBot]

Originally Posted by hunting_yoshi*:

 

here is an error i keep getting every few minutes or so:

Code:

[08:23:39 36] [AdKats] EXCEPTION-670116-D-UploadSetting-SettingUploader5: [Error while uploading setting to database.][MySql.Data.MySqlClient.MySqlException: Got error -1 from storage engine
   at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlCommand command)
   at PRoConEvents.AdKats.UploadSetting(CPluginVariable var)]

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

here is an error i keep getting every few minutes or so:

Code:

[08:23:39 36] [AdKats] EXCEPTION-670116-D-UploadSetting-SettingUploader5: [Error while uploading setting to database.][MySql.Data.MySqlClient.MySqlException: Got error -1 from storage engine
   at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlCommand command)
   at PRoConEvents.AdKats.UploadSetting(CPluginVariable var)]

A common cause for error -1 is full disk, please confirm your db's allowed space is not full.

 

If that's not the case go to /etc/my.cnf

Comment out or remove the line containing innodb_force_recovery

Save the file and restart mysql

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I'm issuing the !lock player command on an admin. The punish system I use does a say /!punish PLAYER NO EXPLOSIVES for instance. In the past when I lock a player from commands they won't get punished per say for using an explosive. But now when they for instance use C4 they get punished instead of it saying the player is command locked.

To clarify. The system can't tell the difference between an admin issuing commands through the procon chat tab and a plugin issuing commands via admin say, they are essentially the same thing. And since players are not locked to the person who issued the lock on them it allows the plugins to punish them. If you don't want an admin acted on by the system you'll have to lock them from in-game.

 

I have to ask though, why are you locking admins?

[ImportBot]

Originally Posted by hunting_yoshi*:

 

i am talking with my database/server provider apparently there is no limitation on storage on my database they are investigating as well

[ImportBot]

Originally Posted by CentOS*:

 

We got a error on our servers? Anyone else got the same?

 

 

[17:00:49 38] [AdKats] WARNING: Issue connecting to battlelog.

[17:01:25 42] [AdKatsLRT] EXCEPTION-2033-D-FetchPlayerLoadout-SpawnProcessing27: [Error while loading player loadout.][system.Net.WebException: The operation has timed out

at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)

at System.Net.WebClient.DownloadString(Uri address)

at System.Net.WebClient.DownloadString(String address)

at PRoConEvents.AdKatsLRT.FetchPlayerLoadout(String personaID)]

[17:01:25 42] [AdKatsLRT] WARNING: _valoulp? took abnormally long to start processing. [2m46s]

[17:01:26 06] [AdKats] User List Fetched from Database. [8 users, 0 Special Players]

[17:02:04 82] [AdKats] WARNING: Issue connecting to battlelog.

[17:02:30 90] [AdKats] WARNING: Issue connecting to battlelog.

[17:03:05 43] [AdKatsLRT] EXCEPTION-2033-D-FetchPlayerLoadout-SpawnProcessing27: [Error while loading player loadout.][system.Net.WebException: The operation has timed out

at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)

at System.Net.WebClient.DownloadString(Uri address)

at System.Net.WebClient.DownloadString(String address)

at PRoConEvents.AdKatsLRT.FetchPlayerLoadout(String personaID)]

[17:03:05 43] [AdKatsLRT] WARNING: [DOLG]Troll0Cat took abnormally long to start processing. [3m21s]

[17:03:08 85] [AdKats] Player IlDecano rejoined the server.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

We got a error on our servers? Anyone else got the same?

 

 

[17:00:49 38] [AdKats] WARNING: Issue connecting to battlelog.

[17:01:25 42] [AdKatsLRT] EXCEPTION-2033-D-FetchPlayerLoadout-SpawnProcessing27: [Error while loading player loadout.][system.Net.WebException: The operation has timed out

at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)

at System.Net.WebClient.DownloadString(Uri address)

at System.Net.WebClient.DownloadString(String address)

at PRoConEvents.AdKatsLRT.FetchPlayerLoadout(String personaID)]

[17:01:25 42] [AdKatsLRT] WARNING: _valoulp? took abnormally long to start processing. [2m46s]

[17:01:26 06] [AdKats] User List Fetched from Database. [8 users, 0 Special Players]

[17:02:04 82] [AdKats] WARNING: Issue connecting to battlelog.

[17:02:30 90] [AdKats] WARNING: Issue connecting to battlelog.

[17:03:05 43] [AdKatsLRT] EXCEPTION-2033-D-FetchPlayerLoadout-SpawnProcessing27: [Error while loading player loadout.][system.Net.WebException: The operation has timed out

at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request)

at System.Net.WebClient.DownloadString(Uri address)

at System.Net.WebClient.DownloadString(String address)

at PRoConEvents.AdKatsLRT.FetchPlayerLoadout(String personaID)]

[17:03:05 43] [AdKatsLRT] WARNING: [DOLG]Troll0Cat took abnormally long to start processing. [3m21s]

[17:03:08 85] [AdKats] Player IlDecano rejoined the server.

This is an LRT issue, please post in that thread about future LRT issues.

 

We are looking into this. Battlelog may have reduced the request frequency required to be IP temp banned. Please PM me your layer IP and who your layer host is.

[ImportBot]

Originally Posted by hunting_yoshi*:

 

i dont know if it can help i put the plugin in debug mode and here is what shows around the error (still -1)Code:

[13:08:10 54] [AdKats] User List Fetched from Database. [1 users, 1 Special Players]
[13:09:16 39] [AdKats] SQL updates fetched.
[13:09:58 53] [AdKats] EXCEPTION-670116-D-UploadSetting-SettingUploader9: [Error while uploading setting to database.][MySql.Data.MySqlClient.MySqlException: Got error -1 from storage engine
   at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlCommand command)
   at PRoConEvents.AdKats.UploadSetting(CPluginVariable var)]
[13:09:58 85] [AdKats] adkats_exception upload for AdKats by AdKats SUCCESSFUL!
[13:09:58 86] [AdKats] adkats_exception last used 5m4s ago.
[13:09:59 13] [AdKats] adkats_exception update for AdKats by AdKats SUCCESSFUL!
[13:09:59 13] [AdKats] In-Game/Automated adkats_exception record took 602ms to complete actions.

EDIT:

here is the answer my provider gave me:

 

Just checked the disk that MySQL is hosted on, and there is more than 100GB space free. I was also unable to find the option "innodb_force_recovery" under our configuration, why it should already be disabled.

[ImportBot]

Originally Posted by B-73*:

 

Hi CCC,

 

I have constance problem with AdKats. He auto restart constance in procon.

 

----------

 

[20:55:16 09] [statslogger]Error: Error in UpdateCurrentPlayerTable: Maximum number of 3 transaction retrys exceeded (Transaction delete und Insert)

[20:55:16 09] [statslogger]Error: Error in UpdateCurrentPlayerTable:

[20:55:16 10] Message: Lock wait timeout exceeded; try restarting transaction

[20:55:16 10] Native: -2147467259

[20:55:16 10] Source: MySql.Data

[20:55:16 10] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& 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.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPla yerTable(List`1 lstPlayers) in d:\Servers\USERNAME\GameServers\serverid\Plugins\B F4\Temp\khyus2mf.0.cs:line 3495

 

----------

 

Can you help me?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi CCC,

 

I have constance problem with AdKats. He auto restart constance in procon.

 

----------

 

[20:55:16 09] [statslogger]Error: Error in UpdateCurrentPlayerTable: Maximum number of 3 transaction retrys exceeded (Transaction delete und Insert)

[20:55:16 09] [statslogger]Error: Error in UpdateCurrentPlayerTable:

[20:55:16 10] Message: Lock wait timeout exceeded; try restarting transaction

[20:55:16 10] Native: -2147467259

[20:55:16 10] Source: MySql.Data

[20:55:16 10] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& 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.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPla yerTable(List`1 lstPlayers) in d:\Servers\USERNAME\GameServers\serverid\Plugins\B F4\Temp\khyus2mf.0.cs:line 3495

 

----------

 

Can you help me?

This is not an AdKats error, notice the [statlogger] prefix. Please send your full plugin logs with any other errors included in a PM.

[ImportBot]

Originally Posted by wdfstryfe*:

 

To clarify. The system can't tell the difference between an admin issuing commands through the procon chat tab and a plugin issuing commands via admin say, they are essentially the same thing. And since players are not locked to the person who issued the lock on them it allows the plugins to punish them. If you don't want an admin acted on by the system you'll have to lock them from in-game.

 

I have to ask though, why are you locking admins?

I sometimes give the guys the ability to use stuff from time to time just a few minutes at a time.

 

I noticed one other thing I think I know WHY it's occurring just now sure how.

I've been migrating databases over to a new server and this is what happens after so I'm assuming something in the migration failed.

 

[16:00:01 93] [AdKats] ERROR-670116: [admin_accept update for [PP]Cwas_Savage by [ML]TEEVOE FAILED!]

 

Also this shows in the logs when issuing a punish.

 

[16:08:33 68] [AdKats] WARNING: Unable to find source weight for command 50|72

[ImportBot]

Originally Posted by Coldstream*:

 

Is it possible to force the Spambot Tell messages to go faster then the 60 second interval it is limited to right now?

[spamBot Say Delay cannot be less than 60 seconds.]

 

I've tried setting it to 30 through SQL but that didnt work either.

[Prophet731]

Originally Posted by Prophet731*:

 

Is it possible to force the Spambot Tell messages to go faster then the 60 second interval it is limited to right now?

[spamBot Say Delay cannot be less than 60 seconds.]

 

I've tried setting it to 30 through SQL but that didnt work either.

That's hard coded to 60. This is so it doesn't spam the players all the time, 30 seconds is quite fast.

[ImportBot]

Originally Posted by tioogu*:

 

When running the adkat sql commands got this error>

Error

 

SQL query:

 

REPLACE INTO `adkats_commands` VALUES(51, 'Active', 'self_assist', 'Log', 'Assist Losing Team', 'assist', FALSE, 'Any');

 

REPLACE INTO `adkats_commands` VALUES(52, 'Active', 'self_uptime', 'Log', 'Request Uptimes', 'uptime', FALSE, 'Any');

 

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REPLACE INTO `adkats_commands` VALUES(52, 'Active', 'self_uptime', 'Log', 'Reque' at line 3

Any help plz

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

When running the adkat sql commands got this error>

 

Any help plz

This is a bug with the current version of PHPMyAdmin, several have seen it in the past. Please run this query on your database with an older version of PHPMyAdmin, or download MySQL Workbench and run the query that way. Cheers.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Is it possible to force the Spambot Tell messages to go faster then the 60 second interval it is limited to right now?

[spamBot Say Delay cannot be less than 60 seconds.]

 

I've tried setting it to 30 through SQL but that didnt work either.

60 seconds is already quite fast, the plugin does not allow spambot messages to be sent any quicker. This is an intentional block to avoid issues with players caused by admins. Ours is currently set at 120 seconds, which works great. Players are very annoyed by messages in their chat box and yells on their screen.

[ImportBot]

Originally Posted by tioogu*:

 

This is a bug with the current version of PHPMyAdmin, several have seen it in the past. Please run this query on your database with an older version of PHPMyAdmin, or download MySQL Workbench and run the query that way. Cheers.

Worked, thanks