Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Stormfire*:

 

tried that this is what I'm getting.

[14:01:43 17] [AdKats] ERROR: User id had invalid formatting, please try again.

[14:02:46 18] [AdKats] EXCEPTION: Line Unknown-6500: [uploadUser][Error while updating player access.]: MySql.Data.MySqlClient.MySqlException: Unknown column 'user_expiration' in 'field list'

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.UploadUser(AdKatsUser aUser)

[14:02:47 23] [AdKats] EXCEPTION: Line Unknown-6500: [FetchUserList][Error while fetching user list.]: MySql.Data.MySqlClient.MySqlException: Unknown column 'adkats_users.user_expiration' in 'field list'

at PRoConEvents.AdKats.SafeExecuteReader(MySqlCommand command)

at PRoConEvents.AdKats.FetchUserList()

[14:02:47 35] [AdKats] WARNING: No users have been added. Add a new user with 'Add User'.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Please update to the latest test version before continuing debug. Let me know if you still see the same issue.

 

http://api.gamerethos.net/adkats/fetch/test_force=1

[ImportBot]

Originally Posted by Stormfire*:

 

getting a different output now, still can not add a user, log follows

 

[15:02:48 67] [AdKats] ENABLED! Beginning startup sequence...

[15:02:51 10] [AdKats] SUCCESS: Fetched 76 BF4 weapon stat definitions.

[15:02:51 87] [AdKats] SUCCESS: Fetched reputation definitions.

[15:02:53 03] [AdKats] SUCCESS: Fetched weapon names.

[15:02:53 79] [AdKats] SUCCESS: Fetched special player group definitions.

[15:02:54 07] [AdKats] SUCCESS: Global timing confirmed.

[15:02:54 07] [AdKats] SUCCESS: Server IP is 104.243.35.2:19577

[15:02:54 85] [AdKats] SUCCESS: SQL Update 'addChatlogDateIndex' completed execution (tbl_chatlog.logDate index successfully created).

[15:02:54 85] [AdKats] SUCCESS: SQL Update 'addRecordTimeIndex' completed execution (adkats_records_main.record_time index successfully created).

[15:02:54 87] [AdKats] SUCCESS: SQL Update 'increaseSPGroupMaxSize' completed execution (Increased special player group size).

[15:02:56 71] [AdKats] SUCCESS: SQL Update 'addChatlogDateIndex' completed execution (tbl_chatlog.logDate index successfully created).

[15:02:56 71] [AdKats] SUCCESS: SQL Update 'addRecordTimeIndex' completed execution (adkats_records_main.record_time index successfully created).

[15:02:56 75] [AdKats] SUCCESS: SQL Update 'increaseSPGroupMaxSize' completed execution (Increased special player group size).

[15:03:02 65] [AdKats] INFO: Fetching user list.

[15:03:02 65] [AdKats] ERROR-6579: [Non-Query failed. [Adding user expiration.]: MySql.Data.MySqlClient.MySqlException: ALTER command denied to user 'procon'@'localhost' for table 'adkats_users'

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.SendNonQuery(String desc, String nonQuery, Boolean verbose)]

[15:03:02 65] [AdKats] ERROR-6579: [Non-Query failed. [Adding initial user expiration values.]: MySql.Data.MySqlClient.MySqlException: Unknown column 'user_expiration' in 'field list'

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.SendNonQuery(String desc, String nonQuery, Boolean verbose)]

[15:03:02 67] [AdKats] ERROR-6579: [Non-Query failed. [Adding user notes.]: MySql.Data.MySqlClient.MySqlException: ALTER command denied to user 'procon'@'localhost' for table 'adkats_users'

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.SendNonQuery(String desc, String nonQuery, Boolean verbose)]

[15:03:02 67] [AdKats] EXCEPTION-6579-D-HandleException-AccessFetching48: [Error while fetching user list.][MySql.Data.MySqlClient.MySqlException: Unknown column 'adkats_users.user_expiration' in 'field list'

at PRoConEvents.AdKats.SafeExecuteReader(MySqlCommand command)

at PRoConEvents.AdKats.FetchUserList()]

[15:03:02 81] [AdKats] SUCCESS: User fetch complete [0 users, 0 Special Players].

[15:03:02 81] [AdKats] WARNING: No users have been added. Add a new user with 'Add User'.

[15:03:02 81] [AdKats] INFO: Fetching player list.

[15:03:09 06] [AdKats] SUCCESS: Player listing complete [0 players].

[15:03:09 06] [AdKats] INFO: Performing final startup.

[15:04:42 71] [AdKats] EXCEPTION-6579-D-HandleException-DatabaseComm44: [Error while updating player access.][MySql.Data.MySqlClient.MySqlException: Unknown column 'user_expiration' in 'field list'

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.UploadUser(AdKatsUser aUser)]

[15:04:43 85] [AdKats] EXCEPTION-6579-D-HandleException-AccessFetching48: [Error while fetching user list.][MySql.Data.MySqlClient.MySqlException: Unknown column 'adkats_users.user_expiration' in 'field list'

at PRoConEvents.AdKats.SafeExecuteReader(MySqlCommand command)

at PRoConEvents.AdKats.FetchUserList()]

[15:04:44 00] [AdKats] WARNING: No users have been added. Add a new user with 'Add User'.

 

[15:03:09 56] [AdKats] SUCCESS: AdKats 6.5.7.9 startup complete [13s]. Commands are now online.

[ImportBot]

Originally Posted by Stormfire*:

 

I still can not add a user, I'm now seeing and error.

 

[23:46:07 15] [AdKats] In-Game/Automated adkats_exception record took 109ms to complete actions.

[23:46:07 71] [AdKats] EXCEPTION-6579-D-HandleException-AccessFetching5: [Error while fetching user list.][MySql.Data.MySqlClient.MySqlException: Unknown column 'adkats_users.user_expiration' in 'field list'

at PRoConEvents.AdKats.SafeExecuteReader(MySqlCommand command)

at PRoConEvents.AdKats.FetchUserList()]

[23:46:07 78] [AdKats] adkats_exception upload for AdKats by AdKats SUCCESSFUL!

[23:46:07 79] [AdKats] adkats_exception last used 0s ago.

[23:46:07 82] [AdKats] adkats_exception update for AdKats by AdKats SUCCESSFUL!

[23:46:07 82] [AdKats] In-Game/Automated adkats_exception record took 109ms to complete actions.

[23:46:07 84] [AdKats] WARNING: No users have been added. Add a new user with 'Add User'.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I still can not add a user, I'm now seeing and error.

 

[23:46:07 15] [AdKats] In-Game/Automated adkats_exception record took 109ms to complete actions.

[23:46:07 71] [AdKats] EXCEPTION-6579-D-HandleException-AccessFetching5: [Error while fetching user list.][MySql.Data.MySqlClient.MySqlException: Unknown column 'adkats_users.user_expiration' in 'field list'

at PRoConEvents.AdKats.SafeExecuteReader(MySqlCommand command)

at PRoConEvents.AdKats.FetchUserList()]

[23:46:07 78] [AdKats] adkats_exception upload for AdKats by AdKats SUCCESSFUL!

[23:46:07 79] [AdKats] adkats_exception last used 0s ago.

[23:46:07 82] [AdKats] adkats_exception update for AdKats by AdKats SUCCESSFUL!

[23:46:07 82] [AdKats] In-Game/Automated adkats_exception record took 109ms to complete actions.

[23:46:07 84] [AdKats] WARNING: No users have been added. Add a new user with 'Add User'.

That should not be happening (obviously). The only thing I can think of that could cause this is you giving credentials to AdKats that can't modify/add tables. That column is added in the code if it doesn't exist in your database, so did you give AdKats a user with insufficient DB privileges?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

To anyone running test versions 6.5.6.8 or later, there is a team/teamID error popping up on some user's machines, but not all. We are looking to find out why this is happening and fix it ASAP.

[ImportBot]

Originally Posted by Lugresky*:

 

After updating to 6.5.7.9

 

Code:

[16:24:43 83] [AdKats] EXCEPTION-6579-HandleException-Main13: [Team not found for ID 2 in dictionary of 1 teams.]
[16:24:43 83] [AdKats] ERROR-6579: [Teams not loaded when they should be.]
[16:24:43 83] [AdKats] EXCEPTION-6579-HandleException-Main13: [Team not found for ID 1 in dictionary of 1 teams.]
[16:24:43 83] [AdKats] ERROR-6579: [Teams not loaded when they should be.]
[16:24:43 87] [AdKats] EXCEPTION-6579-HandleException-PlayerListing10: [Team not found for ID 1 in dictionary of 1 teams.]
[16:24:43 87] [AdKats] EXCEPTION-6579-HandleException-PlayerListing10: [Team not found for ID 2 in dictionary of 1 teams.]
[16:24:43 87] [AdKats] EXCEPTION-6579-HandleException-PlayerListing10: [Team not found for ID 3 in dictionary of 1 teams.]
[16:24:43 87] [AdKats] EXCEPTION-6579-HandleException-PlayerListing10: [Team not found for ID 4 in dictionary of 1 teams.]

The game is a BFH.

 

Moving players (fmove and move) doesn't work.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

After updating to 6.5.7.9

 

Code:

[16:24:43 83] [AdKats] EXCEPTION-6579-HandleException-Main13: [Team not found for ID 2 in dictionary of 1 teams.]
[16:24:43 83] [AdKats] ERROR-6579: [Teams not loaded when they should be.]
[16:24:43 83] [AdKats] EXCEPTION-6579-HandleException-Main13: [Team not found for ID 1 in dictionary of 1 teams.]
[16:24:43 83] [AdKats] ERROR-6579: [Teams not loaded when they should be.]
[16:24:43 87] [AdKats] EXCEPTION-6579-HandleException-PlayerListing10: [Team not found for ID 1 in dictionary of 1 teams.]
[16:24:43 87] [AdKats] EXCEPTION-6579-HandleException-PlayerListing10: [Team not found for ID 2 in dictionary of 1 teams.]
[16:24:43 87] [AdKats] EXCEPTION-6579-HandleException-PlayerListing10: [Team not found for ID 3 in dictionary of 1 teams.]
[16:24:43 87] [AdKats] EXCEPTION-6579-HandleException-PlayerListing10: [Team not found for ID 4 in dictionary of 1 teams.]

The game is a BFH.

 

Moving players (fmove and move) doesn't work.

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

 

It's being worked on. A patch will be ready tonight.

[ImportBot]

Originally Posted by Stormfire*:

 

I deleted the database, and user, then recreated them with the user having full access, not I can add the user, I was following a guide on the forum and that is where I went wrong.

The guide listed it as "grant select,insert,update,delete,create on *.* to 'procon'@'localhost' identified by 'phogue';" but that did not give enough access.

[ImportBot]

Originally Posted by Stormfire*:

 

That should not be happening (obviously). The only thing I can think of that could cause this is you giving credentials to AdKats that can't modify/add tables. That column is added in the code if it doesn't exist in your database, so did you give AdKats a user with insufficient DB privileges?

you were right about not enough privileges, changed it to full access, and not can add users, I was following a guide that was on the forum, but there is something missing.

 

This is what I was following, "grant select,insert,update,delete,create on *.* to 'procon'@'localhost' identified by 'phogue';"

this is the showthread....setup+database*.

 

The only thing I see now is I gave the user full access, but in game it says, "Your role Default Guest (Power Level 15) cannot use".

Where have I gone wrong now_, help please.

[ImportBot]

Originally Posted by Stormfire*:

 

That should not be happening (obviously). The only thing I can think of that could cause this is you giving credentials to AdKats that can't modify/add tables. That column is added in the code if it doesn't exist in your database, so did you give AdKats a user with insufficient DB privileges?

You were right about the access, I deleted the database and login credentials, and changed them, can now add users.

[ImportBot]

Originally Posted by Stormfire*:

 

I've added the first user, but in game, the user is coming up as guest, not admin, I looked in the database, and I see that it's set on user to 1 as role, when I set it in adkats as admin.

Any help on this?

 

In game the user is showing as guest, even though I gave them admin access.

 

Got it going, I was not adding soldier, which it looks like you can not add till you have been into the game once.

Am I right on that count?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I've added the first user, but in game, the user is coming up as guest, not admin, I looked in the database, and I see that it's set on user to 1 as role, when I set it in adkats as admin.

Any help on this?

 

In game the user is showing as guest, even though I gave them admin access.

Glad you can add users now.

 

Did you add your soldiers to the user?

 

When you add a user it tries to find a player in the database that matches it. If it finds a matching player it will automatically add it. If it cannot find a matching player you need to add the soldier to the user manually. In the user's "add soldier" field, type their soldier name.

 

All soldier matching to users is done by ID, this means if players ever change their names you don't need to worry about it, it will automatically stay connected and updated with the appropriate powers.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

The team issue was isolated to hardline, for the most part. For those having issues please update to test version 6.5.8.5 for the complete patch of that problem.

[ImportBot]

Originally Posted by petraunas*:

 

Testing this right now but I think it might have been fixed already.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Testing this right now but I think it might have been fixed already.

It may have looked like it was fixed, but it wasn't.

[ImportBot]

Originally Posted by spatieman*:

 

Yes :-) create a new user group and grant them only that rights and then assaign that user group to your almost admin users works fine for me.

sorry late response.

new user group ? ,uh?

please explain.

is this like the add user in section 3 ?

i got there the local clan admins in ,it has only default guest and full admin.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

sorry late response.

new user group ? ,uh?

please explain.

is this like the add user in section 3 ?

i got there the local clan admins in ,it has only default guest and full admin.

Yes under the roles section you can create a new role and assign access to whatever commands you want in there.

 

Once the role is created and set up you can assign users to it as needed.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Finally got around to updating the "hacker-checker" for hardline. It now uses battlelog for BF3/BF4/BFHL, and functions on all 3 games for TEST version 6.5.9.5. Please try it out and keep me posted on what you find. Run at least debug level 2 while testing it.

[ImportBot]

Originally Posted by Tkach*:

 

Hello everyone, i've been experimenting with procon for the last few days so do forgive me for the lame questions.)

I've just installed the latest adkats 6.5.9.5

 

https://myrcon.net/recovered/img/121204_HJLCs

 

and am a bit confused, in the 'settings' tab all i have is '1. server settings' and 'd99 debugging' plus there's an error-2020.

According to the manual i should add a user, but where is the appropriate field?

 

https://myrcon.net/recovered/img/121204_NoKuE

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

TEST 6.5.9.5 is available at the following link: http://api.gamerethos.net/adkats/fetch/test_force=1

 

Documentation will be written up and released as 6.6.0.0 tonight if all goes well, but I need more testers, the import process for player statistics was rewritten. It's running stable right now on our servers across BF3/BF4/BFHL, but we we are not the end-all.

[ImportBot]

Originally Posted by dyn*:

 

Come by to report an invisible hack of some type and see that progress is being made. Nicely done! Will see if we can help test.. but it won't be installed until later this evening if we're able to.

 

 

Haven't been in game when these users are coming in but have had several reports of "invisible cheaters" going wild. They don't seem to be following the same pattern as spectator hackers (which are caught). Here is a user that has multiple accounts using the same name prefix all doing the same thing: http://battlelog.battlefield.com/bf4...72/1569858169/ don't see any weapons, shots, or anything... just a bunch of kills.

 

Our logs through gameme are showing the kills as 'vehicle / mortar'... so take that how you will. Our logs also look the same: no head shots and just a bunch of kills being reported as a vehicle. Possible rage hack like we saw in BF3 where the user could kill everyone with spawn beacons?

 

As for detection and automatic removal: has anyone else been able to find any metrics other than a limit / rule to auto remove the players quickly that are using these cheats?

 

Do note they are only going on Vanilla servers so probably just burning their Gametime accounts.

[ImportBot]

Originally Posted by Subman_9*:

 

TEST 6.5.9.5 is available at the following link: http://api.gamerethos.net/adkats/fetch/test_force=1

I was not able to enable AdKats with this version:

[19:14:44 25] [AdKats] ERROR-6595: [Failed to fetch weapon stat definitions. AdKats cannot be started.]

 

[19:14:43 12] [AdKats] [4-UpdateFactions-Enabler86] Assigning team ID 0 to Spectator

[19:14:43 48] [AdKats] [6-m__E-Finalizer87] Locking on _aliveThreads

[19:14:43 48] [AdKats] [2-m__E-Finalizer87] Threads still exiting: Enabler[86]

[19:14:43 62] [AdKats] [6-StartAndLogThread-Enabler86] Locking on _aliveThreads

[19:14:43 63] [AdKats] [2-FetchWeaponDefinitions-Enabler86] Fetching weapon statistic definitions...

[19:14:44 03] [AdKats] [6-m__E-Finalizer87] Locking on _aliveThreads

[19:14:44 03] [AdKats] [2-m__E-Finalizer87] Threads still exiting: Enabler[86] TeamAssignmentConfirmation[88]

[19:14:44 25] [AdKats] [1-FetchWeaponDefinitions-Enabler86] Weapon statistic definitions fetched from backup location.

[19:14:44 25] [AdKats] ERROR-6595: [Failed to fetch weapon stat definitions. AdKats cannot be started.]

[19:14:44 25] [AdKats] [6-LogThreadExit-Enabler86] Locking on _aliveThreads

Reverted back to 6.5.4.6 and it started without any errors, so it's not a firewall issue.

 

EDIT:

OS: VPS with Ubuntu 14.04 with 2 CPU cores + mono 3.2.8

 

Also I've another question. It seems I've some issue with AdKats and the PalyerListing Thread. It seems it locks somehow, because when I want to disable AdKats I'm receving a following messages:

[19:51:07 41] [AdKats] WARNING: Threads still exiting: PlayerListing[35]

[19:51:07 91] [AdKats] WARNING: Threads still exiting: PlayerListing[35]

[19:51:08 43] [AdKats] WARNING: Threads still exiting: PlayerListing[35]

At the end I've to restart procon layer to enable AdKats once again.

 

Can you please tell me if you have tested AdKats with mono ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

All definition files are loaded from github on boot, and on mono this has issues as they require use of HTTPS to fetch the files. You will be able to use the latest test version once I have the gamerethos gateway updated to use the new battlelog definition file.

[ImportBot]

Originally Posted by Subman_9*:

 

Ok, thanks for update. I will wait for update, however it will problably not solve my AdKats issue.

 

As I wrote on AdKatsLRT thread, I have some issue with AdKats with mono. It seems the PlayerListing thread is not working correctly (as I wrote it above) and AdkatsLRT is repoting constantly (wtih AdKats integration) that it was not able to fetch killer or victim almost immediately after procon layer restart. Do you have any idea why this might happening ? AdKats was running earlier fine on mono for almost 4 weeks and now there's some issue with this thread

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Ok, thanks for update. I will wait for update, however it will problably not solve my AdKats issue.

 

As I wrote on AdKatsLRT thread, I have some issue with AdKats with mono. It seems the PlayerListing thread is not working correctly (as I wrote it above) and AdkatsLRT is repoting constantly (wtih AdKats integration) that it was not able to fetch killer or victim almost immediately after procon layer restart. Do you have any idea why this might happening ? AdKats was running earlier fine on mono for almost 4 weeks and now there's some issue with this thread

We'll see, but knowing the patches I added between 6.5.4.6 and the current test version it should be fixed. Just need to wait on updating that service now.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Just pushed Version 6.6.0.0 public. Mono/Linux layers may still need to wait a bit, prophet hasn't been on to update the gamerethos links for the definition file changes.

 

You can review changes here: https://github.com/AdKats/AdKats/iss...3Aupdated-desc

[Prophet731]

Originally Posted by Prophet731*:

 

Just pushed Version 6.6.0.0 public. Mono/Linux layers may still need to wait a bit, prophet hasn't been on to update the gamerethos links for the definition file changes.

It's done.

[ImportBot]

Originally Posted by CaptCourage*:

 

Have rebooted procon to effect update to adkats plugin as stated yet is still old version. Is there a direct link to download 6.6.0.0?

 

Regards

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Have rebooted procon to effect update to adkats plugin as stated yet is still old version. Is there a direct link to download 6.6.0.0?

 

Regards

Try rebooting your client , if you were told by AdKats that it had an update ready then install was already successful. Otherwise run /pupdate.