Jump to content

Advanced In-Game Admin and Ban Enforcer - AdKats


Message added by Prophet731,

If you've been banned from a server then you will need to appeal the ban with the owners/community of that server. We do not control any bans done on servers that utilize AdKats as all bans are local to that server.

Recommended Posts

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

* Restored post. It could be that the author is no longer active.
Link to comment

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?

* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer

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.

Link to comment
  • Administrators

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

The developer of the Battlefield Admin Control Panel (BFACP)

For BFACP support please post in the BFACP topic linked above.

Do not contact me via PM on the forums for help with procon. Please make a topic for it. Only PM's I will accept will revolve around any website issues.

spacer.png

Link to comment

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.

* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer

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.
Link to comment
  • Plugin Developer

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.

Link to comment

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)]
* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer

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

Link to comment
  • Plugin Developer

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?

Link to comment

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.

* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer

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.

Link to comment

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.

* Restored post. It could be that the author is no longer active.
Link to comment

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?

* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer

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.
Link to comment

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

* Restored post. It could be that the author is no longer active.
Link to comment

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. :tongue:

* Restored post. It could be that the author is no longer active.
Link to comment
  • Administrators

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. :tongue:

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

The developer of the Battlefield Admin Control Panel (BFACP)

For BFACP support please post in the BFACP topic linked above.

Do not contact me via PM on the forums for help with procon. Please make a topic for it. Only PM's I will accept will revolve around any website issues.

spacer.png

Link to comment

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
* Restored post. It could be that the author is no longer active.
Link to comment
  • Plugin Developer

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.
Link to comment
  • Plugin Developer

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. :tongue:

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.
Link to comment

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
* Restored post. It could be that the author is no longer active.
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




  • Our picks

    • Game Server Hosting:

      We're happy to announce that EZRCON will branch out into the game server provider scene. This is a big step for us so please having patience if something doesn't go right in this area. Now, what makes us different compared to other providers? Well, we're going with the idea of having a scaleable server hosting and providing more control in how you set up your server. For example, in Minecraft, you have the ability to control how many CPU cores you wish your server to have access to, how much RAM you want to use, how much disk space you want to use. This type of control can't be offered in a single service package so you're able to configure a custom package the way you want it.

      You can see all the available games here. Currently, we have the following games available.

      Valheim (From $1.50 USD)


      Rust (From $3.20 USD)


      Minecraft (Basic) (From $4.00 USD)


      Call of Duty 4X (From $7.00 USD)


      OpenTTD (From $4.00 USD)


      Squad (From $9.00 USD)


      Insurgency: Sandstorm (From $6.40 USD)


      Changes to US-East:

      Starting in January 2022, we will be moving to a different provider that has better support, better infrastructure, and better connectivity. We've noticed that the connection/routes to this location are not ideal and it's been hard getting support to correct this. Our contract for our two servers ends in March/April respectively. If you currently have servers in this location you will be migrated over to the new provider. We'll have more details when the time comes closer to January. The new location for this change will be based out of Atlanta, GA. If you have any questions/concerns please open a ticket and we'll do our best to answer them.
      • 5 replies
    • Hello All,

      I wanted to give an update to how EZRCON is doing. As of today we have 56 active customers using the services offered. I'm glad its doing so well and it hasn't been 1 year yet. To those that have services with EZRCON, I hope the service is doing well and if not please let us know so that we can improve it where possible. We've done quite a few changes behind the scenes to improve the performance hopefully. 

      We'll be launching a new location for hosting procon layers in either Los Angeles, USA or Chicago, IL. Still being decided on where the placement should be but these two locations are not set in stone yet. We would like to get feedback on where we should have a new location for hosting the Procon Layers, which you can do by replying to this topic. A poll will be created where people can vote on which location they would like to see.

      We're also looking for some suggestions on what else you would like to see for hosting provider options. So please let us know your thoughts on this matter.
      • 4 replies
    • Added ability to disable the new API check for player country info


      Updated GeoIP database file


      Removed usage sending stats


      Added EZRCON ad banner



      If you are upgrading then you may need to add these two lines to your existing installation in the file procon.cfg. To enable these options just change False to True.

      procon.private.options.UseGeoIpFileOnly False
      procon.private.options.BlockRssFeedNews False



       
      • 2 replies
    • I wanted I let you know that I am starting to build out the foundation for the hosting services that I talked about here. The pricing model I was originally going for wasn't going to be suitable for how I want to build it. So instead I decided to offer each service as it's own product instead of a package deal. In the future, hopefully, I will be able to do this and offer discounts to those that choose it.

      Here is how the pricing is laid out for each service as well as information about each. This is as of 7/12/2020.

      Single MySQL database (up to 30 GB) is $10 USD per month.



      If you go over the 30 GB usage for the database then each additional gigabyte is charged at $0.10 USD each billing cycle. If you're under 30GB you don't need to worry about this.


      Databases are replicated across 3 zones (regions) for redundancy. One (1) on the east coast of the USA, One (1) in Frankfurt, and One (1) in Singapore. Depending on the demand, this would grow to more regions.


      Databases will also be backed up daily and retained for 7 days.




      Procon Layer will be $2 USD per month.


      Each layer will only allow one (1) game server connection. The reason behind this is for performance.


      Each layer will also come with all available plugins installed by default. This is to help facilitate faster deployments and get you up and running quickly.


      Each layer will automatically restart if Procon crashes. 


      Each layer will also automatically restart daily at midnight to make sure it stays in tip-top shape.


      Custom plugins can be installed by submitting a support ticket.




      Battlefield Admin Control Panel (BFACP) will be $5 USD per month


      As I am still working on building version 3 of the software, I will be installing the last version I did. Once I complete version 3 it will automatically be upgraded for you.





      All these services will be managed by me so you don't have to worry about the technical side of things to get up and going.

      If you would like to see how much it would cost for the services, I made a calculator that you can use. It can be found here https://ezrcon.com/calculator.html

       
      • 11 replies
    • I have pushed out a new minor release which updates the geodata pull (flags in the playerlisting). This should be way more accurate now. As always, please let me know if any problems show up.

       
      • 9 replies
×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.