Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by ParadoxCAV*:

 

[22:15:11 16] [AdKats] EXCEPTION-6540-D-HandleException-PlayerListing11: [Error while fetching player.][MySql.Data.MySqlClient.MySqlException: 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 'EA_50D856841E037F76842067C0110E63C2'

 

' at line 11

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.FetchPlayer(Boolean allowUpdate, Boolean allowOtherGames, Boolean allowNameSubstringSearch, Nullable`1 gameID, Int64 playerID, String playerName, String playerGUID, String playerIP)]

Getting this, using 6.5.4.0 hardline test build. known issue?

[ImportBot]

Originally Posted by CoVeX*:

 

Hi,

 

wirth the test version from the post #3932, i become this error!

 

[16:53:55 29] [AdKats] ENABLED! Beginning startup sequence...

[16:53:56 09] [AdKats] SUCCESS: Fetched reputation definitions.

[16:53:56 59] [AdKats] SUCCESS: Fetched special player group definitions.

[16:53:56 60] [AdKats] ERROR-6540: [unable to confirm global timing. Global UTC Timestamp could not be fetched.]

[16:53:56 60] [AdKats] SUCCESS: Server IP is 5.101.166.110:33300

[16:53:56 60] [AdKats] SUCCESS: Database connection open.

[16:53:56 60] [AdKats] ERROR-6540: [Tables from XPKiller's Stat Logger not present in the database. Enable that plugin then re-run AdKats!]

[16:53:56 60] [AdKats] INFO: Shutting down AdKats.

[16:53:56 62] [AdKats] SUCCESS: Database timing confirmed.

[16:53:57 15] [AdKats] AdKats 6.5.4.0 Disabled! =(

 

what can i do ?

 

Thanks in advance

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi,

 

wirth the test version from the post #3932, i become this error!

 

[16:53:55 29] [AdKats] ENABLED! Beginning startup sequence...

[16:53:56 09] [AdKats] SUCCESS: Fetched reputation definitions.

[16:53:56 59] [AdKats] SUCCESS: Fetched special player group definitions.

[16:53:56 60] [AdKats] ERROR-6540: [unable to confirm global timing. Global UTC Timestamp could not be fetched.]

[16:53:56 60] [AdKats] SUCCESS: Server IP is 5.101.166.110:33300

[16:53:56 60] [AdKats] SUCCESS: Database connection open.

[16:53:56 60] [AdKats] ERROR-6540: [Tables from XPKiller's Stat Logger not present in the database. Enable that plugin then re-run AdKats!]

[16:53:56 60] [AdKats] INFO: Shutting down AdKats.

[16:53:56 62] [AdKats] SUCCESS: Database timing confirmed.

[16:53:57 15] [AdKats] AdKats 6.5.4.0 Disabled! =(

 

what can i do ?

 

Thanks in advance

Do you have stat logger installed and running without error on your server?

[ImportBot]

Originally Posted by iraqiboy90*:

 

3,5 seconds average for executing the tell command until it tells me "3,5second" (because I have my soldier as the debugger), is it normal?

Trying to understand if my database needs optimisation or the plugin is this slow

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

3,5 seconds average for executing the tell command until it tells me "3,5second" (because I have my soldier as the debugger), is it normal?

Trying to understand if my database needs optimisation or the plugin is this slow

Something is wrong on your end. Avg i've seen for that command is 100-300ms.

[ImportBot]

Originally Posted by iraqiboy90*:

 

Something is wrong on your end. Avg i've seen for that command is 100-300ms.

How do I diagnose this?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

How do I diagnose this?

Firstly I would say watch in game to see how long it takes after entering the command for the tell to show. That duration is the total time for all command actions and database work, so it could be shorter in game.

 

Secondly change your debug level to at least 1 and reboot your layer. When AdKats starts up and starts loading players it will display how long it takes to load each player. What is the average duration?

[ImportBot]

Originally Posted by iraqiboy90*:

 

Firstly I would say watch in game to see how long it takes after entering the command for the tell to show. That duration is the total time for all command actions and database work, so it could be shorter in game.

 

Secondly change your debug level to at least 1 and reboot your layer. When AdKats starts up and starts loading players it will display how long it takes to load each player. What is the average duration?

ok, I will try this out.

 

What I've just noticed is:

I had 8gb ram set on my VPS and had the table_cache set on 3200. Then I decided to reduce the ram to 2gb, but forgot about this setting.

Running mysqltuner.pl with ssh tells me that the "Max possible memory usage" is set on 3,2gb (177% of installed RAM).

Running htop tells me that only 947MB is being used, and the rest is cached..

Can this be an issue?

 

Edit:

So, i've just tried the ingame counting with a stop-watch.

The tell command takes about 1750ms seconds to display the say and yell, and then the debugger tells me 3100ms

 

Edit 2:

Restarted the procon server. Adkats uses avg 3100ms for each player

[ImportBot]

Originally Posted by armypoilce*:

 

hi whats my SQL settings?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

ok, I will try this out.

 

What I've just noticed is:

I had 8gb ram set on my VPS and had the table_cache set on 3200. Then I decided to reduce the ram to 2gb, but forgot about this setting.

Running mysqltuner.pl with ssh tells me that the "Max possible memory usage" is set on 3,2gb (177% of installed RAM).

Running htop tells me that only 947MB is being used, and the rest is cached..

Can this be an issue?

 

Edit:

So, i've just tried the ingame counting with a stop-watch.

The tell command takes about 1750ms seconds to display the say and yell, and then the debugger tells me 3100ms

 

Edit 2:

Restarted the procon server. Adkats uses avg 3100ms for each player

That's more than 3x slower than the times on our remote database.

 

Wait, your database is local on the VPS right? For that it would be nearly instantaneous loading for each player, less than 10-20ms per player, full startup taking no more than 15 seconds.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hi whats my SQL settings?

The settings to connect to your MySQL database. These are explained in the stat logger thread.

[ImportBot]

Originally Posted by iraqiboy90*:

 

That's more than 3x slower than the times on our remote database.

 

Wait, your database is local on the VPS right? For that it would be nearly instantaneous loading for each player, less than 10-20ms per player, full startup taking no more than 15 seconds.

The DB is on the VPS. ProCon is on another VPS located somewhere else.

The ping between the two is about 64ms

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

The DB is on the VPS. ProCon is on another VPS located somewhere else.

The ping between the two is about 64ms

Ok, it's remote. A measurable delay is to be expected, but over 3 seconds per player loaded is a long time. I have seen layers running anywhere from 10ms per player loaded to 6000ms, it's all up to the connection and hardware. Ours sits at almost exactly 1000ms per player loaded using a remote database.

 

It's directly related to the query and transfer rates between your two boxes.

[ImportBot]

Originally Posted by iraqiboy90*:

 

Ok, it's remote. A measurable delay is to be expected, but over 3 seconds per player loaded is a long time. I have seen layers running anywhere from 10ms per player loaded to 6000ms, it's all up to the connection and hardware. Ours sits at almost exactly 1000ms per player loaded using a remote database.

 

It's directly related to the query and transfer rates between your two boxes.

I've just moved the ProCon from that server to the same machine the DB is hosted at. Now it only takes maximum 300ms

 

 

Btw, what is the chunk size for the packets sent by Adkats?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I've just moved the ProCon from that server to the same machine the DB is hosted at. Now it only takes maximum 300ms

 

 

Btw, what is the chunk size for the packets sent by Adkats?

They are simple MySQL server requests, nothing special.

[ImportBot]

Originally Posted by SmackDown*:

 

Hmmm. Alright, you are using ban enforcer, which means it is fetching actions from the database. Check your adkats_records_main table for records with adkats_read = 'N'. If you find any, check the server ID for that record and make sure it matches the ID of the server you want to act on it. You can find the server ID at the top of AdKats settings when the plugin is running.

I have search my data base and my adkats_records_main table all read ='Y".

 

I still am not able to issue punishments through BF4adminCp nor can any of my admins. We can issue punishments through the game console though.

 

Any suggestions?

[ImportBot]

Originally Posted by Talzac*:

 

Hi

What about the Internal Hacker-Checker?

How many of this setting works on a hardline sever?

What can I use to protect the server?

 

Thanks.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I have search my data base and my adkats_records_main table all read ='Y".

 

I still am not able to issue punishments through BF4adminCp nor can any of my admins. We can issue punishments through the game console though.

 

Any suggestions?

Change debug level to 7. Issue a command though the admincp, confirm all records are Y again, then send me the plugin debug logs for that time.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi

What about the Internal Hacker-Checker?

How many of this setting works on a hardline sever?

What can I use to protect the server?

 

Thanks.

"Hacker-Checker" is not visible on hardline and cannot be activated.

[ImportBot]

Originally Posted by SmackDown*:

 

Change debug level to 7. Issue a command though the admincp, confirm all records are Y again, then send me the plugin debug logs for that time.

Here is the Debug file you requested. I attempted to enter a punishment on a player named z1Rezin

 

 

 

z1Rezin

 

 

 

 

[08:50:55] [AdKats] 7:sad:main:10) Entering queueKillForProcessing

[08:50:55] [AdKats] 6:sad:main:10) Preparing to queue kill for processing

[08:50:55] [AdKats] 6:sad:main:10) Kill queued for processing

[08:50:55] [AdKats] 7:sad:main:10) Exiting queueKillForProcessing

[08:50:55] [AdKats] 7:sad:KillProcessing:23) Entering Kill Processing Thread Loop

[08:50:55] [AdKats] 7:sad:main:10) Exiting OnPlayerKilled

[08:50:55] [AdKats] 7:sad:KillProcessing:23) Preparing to lock inbound kill queue to retrive new player kills

[08:50:55] [AdKats] 6:sad:KillProcessing:23) Inbound kills found. Grabbing.

[08:50:55] [AdKats] 6:sad:KillProcessing:23) begin reading player kills

[08:50:55] [AdKats] 7:sad:KillProcessing:23) uploadWeaponCode starting!

[08:50:56] [AdKats] 7:sad:KillProcessing:23) Setting [KAOS]xlilmissmjx time of death to 3/29/2015 8:50:55 AM

[08:50:56] [AdKats] 7:sad:KillProcessing:23) Exiting OnPlayerKilled

[08:50:56] [AdKats] 7:sad:KillProcessing:23) Entering Kill Processing Thread Loop

[08:50:56] [AdKats] 6:sad:KillProcessing:23) No inbound player kills. Waiting for Input.

[08:50:56] [AdKats] 7:sad:BanEnforcer:29) Entering Ban Enforcer Thread Loop

[08:50:56] [AdKats] 6:sad:BanEnforcer:29) No inbound ban checks. Waiting for Input.

[08:50:56] [AdKats] 7:sad:main:46) Entering OnPlayerKilled

[08:50:56] [AdKats] 7:sad:main:46) Entering queueKillForProcessing

[08:50:56] [AdKats] 6:sad:main:46) Preparing to queue kill for processing

[08:50:56] [AdKats] 6:sad:main:46) Kill queued for processing

[08:50:56] [AdKats] 7:sad:main:46) Exiting queueKillForProcessing

[08:50:56] [AdKats] 7:sad:KillProcessing:23) Entering Kill Processing Thread Loop

[08:50:56] [AdKats] 7:sad:KillProcessing:23) Preparing to lock inbound kill queue to retrive new player kills

[08:50:56] [AdKats] 7:sad:main:46) Exiting OnPlayerKilled

[08:50:56] [AdKats] 6:sad:KillProcessing:23) Inbound kills found. Grabbing.

[08:50:56] [AdKats] 6:sad:KillProcessing:23) begin reading player kills

[08:50:56] [AdKats] 7:sad:KillProcessing:23) uploadWeaponCode starting!

[08:50:56] [AdKats] 7:sad:KillProcessing:23) Setting z1Rezin time of death to 3/29/2015 8:50:56 AM

[08:50:56] [AdKats] 7:sad:KillProcessing:23) Setting z1Rezin time of death to 3/29/2015 8:50:56 AM

[08:50:56] [AdKats] 7:sad:DatabaseComm:26) Entering Database Comm Thread Loop

[08:50:56] [AdKats] 7:sad:DatabaseComm:26) Skipping server ID fetch. Server ID: 1

[08:50:56] [AdKats] 7:sad:KillProcessing:23) Exiting OnPlayerKilled

[08:50:56] [AdKats] 7:sad:DatabaseComm:26) Skipping DB action fetch

[08:50:56] [AdKats] 7:sad:KillProcessing:23) Entering Kill Processing Thread Loop

[08:50:56] [AdKats] 7:sad:DatabaseComm:26) No inbound user changes.

[08:50:56] [AdKats] 6:sad:KillProcessing:23) No inbound player kills. Waiting for Input.

[08:50:56] [AdKats] 7:sad:DatabaseComm:26) No unprocessed records. Waiting for input

[08:50:57] [AdKats] 7:sad:TeamSwap:28) Entering TeamSwap Thread Loop

[08:50:57] [AdKats] 5:sad:TeamSwap:28) Team Info: RU: 14/32 CN: 16/32

[08:50:57] [AdKats] 6:sad:TeamSwap:28) No players to swap. Waiting for Input.

[08:50:57] [AdKats] 7:sad:Command:25) Entering Command Parsing Thread Loop

[08:50:57] [AdKats] 7:sad:Command:25) No inbound commands, ready.

[08:50:57] [AdKats] 7:sad:IPAPIComm:32) Entering IP API Comm Thread Loop

[08:50:58] [AdKats] 6:sad:IPAPIComm:32) No inbound players. Waiting.

[08:50:58] [AdKats] 7:sad:main:46) Entering OnServerInfo

[08:50:58] [AdKats] 6:sad:main:46) FeedStatLoggerSettings starting!

[08:50:58] [AdKats] 6:sad:main:46) FeedStatLoggerSettings finished!

[08:50:58] [AdKats] 7:sad:main:46) Exiting OnServerInfo

[08:50:58] [AdKats] 7:sad:main:46) Entering OnListPlayers

[08:50:58] [AdKats] 7:sad:main:46) Entering QueuePlayerListForProcessing

[08:50:58] [AdKats] 6:sad:main:46) Preparing to queue player list for processing

[08:50:58] [AdKats] 6:sad:main:46) Player list queued for processing

[08:50:58] [AdKats] 7:sad:main:46) Exiting QueuePlayerListForProcessing

[08:50:58] [AdKats] 7:sad:main:46) Exiting QueuePlayerListForProcessing

[08:50:[08:50:58] [AdKats] 7:sad:main:46) Exiting OnListPlayers

[08:50:58] [AdKats] 7:sad:PlayerListing:9) Preparing to lock player list queues to retrive new player lists

[08:50:58] [AdKats] 6:sad:PlayerListing:9) Inbound player lists found. Grabbing.

[08:50:58] [AdKats] 5:sad:PlayerListing:9) Listing Players

[08:50:58] [AdKats] 7:sad:PlayerListing:9) Entering Player Listing Thread Loop

[08:50:58] [AdKats] 7:sad:TeamSwap:28) Entering TeamSwap Thread Loop

[08:50:58] [AdKats] 5:sad:PlayerListing:9) No inbound player lists or removals found. Waiting for Input.

[08:50:58] [AdKats] 5:sad:TeamSwap:28) Team Info: RU: 14/32 CN: 16/32

[08:50:58] [AdKats] 6:sad:TeamSwap:28) No players to swap. Waiting for Input.

[08:50:58] [AdKats] 6:sad:main:46) FetchAuthorizedSoldiers starting!

[08:50:58] [AdKats] 6:sad:main:46) FetchAuthorizedSoldiers finished!

[08:50:58] [AdKats] 6:sad:main:6) SendAuthorizedSoldiers starting!

[08:50:58] [AdKats] 6:sad:SendAuthorizedSoldiers:6) SendAuthorizedSoldiers finished!

[08:50:58] [AdKats] 5:sad:main:39) Reserved slots listed.

[08:50:59] [AdKats] 7:sad:ActionHandling:27) Entering Action Thread Loop

[08:50:59] [AdKats] 6:sad:ActionHandling:27) No inbound actions. Waiting.

[08:50:59] [AdKats] 7:sad:BattlelogComm:31) Entering Battlelog Comm Thread Loop

[08:50:59] [AdKats] 6:sad:BattlelogComm:31) No inbound players. Waiting.

[

[ImportBot]

Originally Posted by Talzac*:

 

I am getting an error with the teamkill monitoring, it says that there need to bee more people online to kick

but I have disabled the population on adkats punishment.

[ImportBot]

Originally Posted by Talzac*:

 

The only kill players when server in low population is set to false

[ImportBot]

Originally Posted by Talzac*:

 

I Think I have found the error... it was the Team Kill Tracker that was reporting not adkats.

[ImportBot]

Originally Posted by spatieman*:

 

stupid question.

is there a way to add half admins?

as in, only able to kill and kick players from a server ?

[ImportBot]

Originally Posted by Talzac*:

 

stupid question.

is there a way to add half admins?

as in, only able to kill and kick players from a server ?

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.

[ImportBot]

Originally Posted by iraqiboy90*:

 

stupid question.

is there a way to add half admins?

as in, only able to kill and kick players from a server ?

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.

@...*

or you can give them the punish command. Even better and it can add up to bans.

[ImportBot]

Originally Posted by 99sonicx*:

 

every time i enter my password on Adkats it says invalid password help please is there a way to reset it

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

every time i enter my password on Adkats it says invalid password help please is there a way to reset it

Shut down procon, open the AdKats config file, remove/change your setting password.

[ImportBot]

Originally Posted by SmackDown*:

 

Here is the Debug file you requested. I attempted to enter a punishment on a player named z1Rezin

Any suggestions on this?

[ImportBot]

Originally Posted by 99sonicx*:

 

Shut down procon, open the AdKats config file, remove/change your setting password.

ok thanks very much for the help