Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Jamesonp*:

 

Can anyone else confirm when Adkats detects the database is down and then the connection is restored that the "Enable Live Scoreboard in DB" option is automatically disabled?

[ImportBot]

Originally Posted by kcuestag*:

 

Can anyone else confirm when Adkats detects the database is down and then the connection is restored that the "Enable Live Scoreboard in DB" option is automatically disabled?

That happened to me yesterday, the web stats stopped working until I noticed that.

[ImportBot]

Originally Posted by Backapcker*:

 

hi,

 

after release 2nd assault we got an error on adkats. when we want to nuke the russian-team we type: !nuke rus answer from adkats: nuke us?

same when we wrote: russian.

 

best regards

 

Backpacker

[ImportBot]

Originally Posted by tbird412*:

 

Getting these errors ever since the update ...

 

[10:36:02 64] UltimateMapManager: WORK -> Level loaded. Setting server preset to Normal.

[10:36:14 40] [AdKats] Enabled! Beginning startup sequence...

[10:36:14 40] [AdKats] Waiting a few seconds for requirements and other plugins to initialize, please wait...

[10:36:19 56] [AdKats] SUCCESS: Server IP is 108.61.100.72:30000!

[10:36:19 91] [AdKats] Attempting database connection. Attempt 1 of 5.

[10:36:19 93] [AdKats] SUCCESS: Database connection open.

[10:36:20 96] [AdKats] SUCCESS: Database confirmed functional for AdKats use.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:21 41] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:22 77] [AdKats] SUCCESS: Database Server Info Fetched. Server ID is 1!

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 20] [AdKats] ERROR: Unable to find teamswap command when assigning conditional commands.

[10:36:23 50] [AdKats] EXCEPTION: Line 0: [FetchUserList][Error while fetching access list.]: MySql.Data.MySqlClient.MySqlException: Table 'c1071925_bf4stats.adkats_specialplayers' doesn't exist

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.ExecuteReader( )

at PRoConEvents.AdKats.FetchUserList()

[10:36:23 85] [AdKats] Running! Version: 4.1.0.0

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hi,

 

after release 2nd assault we got an error on adkats. when we want to nuke the russian-team we type: !nuke rus answer from adkats: nuke us?

same when we wrote: russian.

 

best regards

 

Backpacker

Please read the documentation. Nuke is either us, ru, cn, or all. You are typing in rus which contains both ru, and us, which is confusing the system.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Can anyone else confirm when Adkats detects the database is down and then the connection is restored that the "Enable Live Scoreboard in DB" option is automatically disabled?

Strange. The only thing i call for stat logger on db disconnect is disable, then enable once connection is restored. I'll look into it.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Getting these errors ever since the update ...

You did not run the database update script. Please refer to the 4.1.0.0 release notes post in this thread to get that script.

[ImportBot]

Originally Posted by TMiland*:

 

Any ideas why this is happening? ->

 

The player says he is banned, when he's not...

[ImportBot]

Originally Posted by JR8355*:

 

Can anyone else confirm when Adkats detects the database is down and then the connection is restored that the "Enable Live Scoreboard in DB" option is automatically disabled?

confirmed, also my web admin live scoreboard has stopped working, no updates

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

confirmed, also my web admin live scoreboard has stopped working, no updates

This issue is being looked into. multiple people have reported the problem. I will post progress tonight.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Any ideas why this is happening? ->

 

The player says he is banned, when he's not...

First, have you updated to 4.1? If not, do that, this is related to an issue that was fixed.

 

Then to repair what the issue caused in 4.0 run this:

 

Code:

UPDATE
     adkats_records_main
SET
    record_message = "Record Message Invalid"
WHERE 
    record_message <> "Record Message Invalid"
AND
(
    (command_action = 20 AND command_type <> 20)
    OR 
    (command_action = 35 AND command_type <> 35)
);

The player might be getting an enforce ban because his account is being linked to a banned player's account by the database. If this is working incorrectly I will need to look further.

 

This is why i wish i had more testers , as soon as a full release happens obscure bugs start to surface.

[ImportBot]

Originally Posted by JR8355*:

 

This issue is being looked into. multiple people have reported the problem. I will post progress tonight.

rgr that, your response is appreciated, thank you.

[ImportBot]

Originally Posted by TMiland*:

 

First, have you updated to 4.1? If not, do that, this is related to an issue that was fixed.

 

Then to repair what the issue caused in 4.0 run this:

 

Code:

UPDATE
     adkats_records_main
SET
    record_message = "Record Message Invalid"
WHERE 
    record_message <> "Record Message Invalid"
AND
(
    (command_action = 20 AND command_type <> 20)
    OR 
    (command_action = 35 AND command_type <> 35)
);

The player might be getting an enforce ban because his account is being linked to a banned player's account by the database. If this is working incorrectly I will need to look further.

 

This is why i wish i had more testers , as soon as a full release happens obscure bugs start to surface.

I have updated to 4.1, yesterday morning.

 

I haven't done the above sql query before, and the upgrade sql query was the same as i got from you earlier or no?

 

When i ran:

Code:

ALTER TABLE `adkats_specialplayers`
  ADD CONSTRAINT `adkats_specialplayers_game_id` FOREIGN KEY (`player_game`) REFERENCES `tbl_games`(`GameID`) ON UPDATE NO ACTION ON DELETE CASCADE, 
  ADD CONSTRAINT `adkats_specialplayers_server_id` FOREIGN KEY (`player_server`) REFERENCES `tbl_server`(`ServerID`) ON UPDATE NO ACTION ON DELETE CASCADE, 
  ADD CONSTRAINT `adkats_specialplayers_player_id` FOREIGN KEY (`player_id`) REFERENCES `tbl_playerdata`(`PlayerID`) ON UPDATE NO ACTION ON DELETE CASCADE;

I got this error:

Code:

#1005 - Can't create table 'nbfc_bf4log.#sql-dc7_36d48' (errno: 121)

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I have updated to 4.1, yesterday morning.

 

I haven't done the above sql query before, and the upgrade sql query was the same as i got from you earlier or no?

 

When i ran:

Code:

ALTER TABLE `adkats_specialplayers`
  ADD CONSTRAINT `adkats_specialplayers_game_id` FOREIGN KEY (`player_game`) REFERENCES `tbl_games`(`GameID`) ON UPDATE NO ACTION ON DELETE CASCADE, 
  ADD CONSTRAINT `adkats_specialplayers_server_id` FOREIGN KEY (`player_server`) REFERENCES `tbl_server`(`ServerID`) ON UPDATE NO ACTION ON DELETE CASCADE, 
  ADD CONSTRAINT `adkats_specialplayers_player_id` FOREIGN KEY (`player_id`) REFERENCES `tbl_playerdata`(`PlayerID`) ON UPDATE NO ACTION ON DELETE CASCADE;

I got this error:

Code:

#1005 - Can't create table 'nbfc_bf4log.#sql-dc7_36d48' (errno: 121)

So many people are getting that error when running the update...

 

It doesn't stop the program from working when the error happens, but i'm wondering why it's happening. That error means the foreign key you are trying to add already exists...which should only happen if you accidentally run it twice. I've tried to replicate the error on my machines, and it only happens when i do it twice.

 

But yes, run that fix query then have that player attempt to join again. If the enforce ban record has "LINKED ACCOUNT *some ID here*" in it, then it's the linked account system keeping him out.

[ImportBot]

Originally Posted by TMiland*:

 

So many people are getting that error when running the update...

 

It doesn't stop the program from working when the error happens, but i'm wondering why it's happening. That error means the foreign key you are trying to add already exists...which should only happen if you accidentally run it twice. I've tried to replicate the error on my machines, and it only happens when i do it twice.

 

But yes, run that fix query then have that player attempt to join again. If the enforce ban record has "LINKED ACCOUNT *some ID here*" in it, then it's the linked account system keeping him out.

Okay, thanks for clearing that up.

 

I'll check if he has gotten in or not tomorrow.

[ImportBot]

Originally Posted by _CH_KeyserSoze*:

 

Definitely a problem with the webadmin live scoreboard..The "Enable live Scoreboard in DB" will not stay on. I turn it on for all our servers and within a minute it shuts off again. The started after upgrading Adkats. Though this maybe something with stats logger but I haven't made any changes to that.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Definitely a problem with the webadmin live scoreboard..The "Enable live Scoreboard in DB" will not stay on. I turn it on for all our servers and within a minute it shuts off again. The started after upgrading Adkats. Though this maybe something with stats logger but I haven't made any changes to that.

Just to keep my sanity on this....do you all have "Feed stat logger settings" set to True? Because if you do, yes those settings will be changed. If that is set to true, then set it to false, turn enable live scoreboard in DB on in stat logger, then tell me if the issue continues.

 

EDIT: If this does end up resolving the issue, then i will remove the "Enable live Scoreboard in DB" "False" setting feed.

[ImportBot]

Originally Posted by _CH_KeyserSoze*:

 

It was set to true and had been even before the update with no issues. I have now set it to false and enabled live scoreboard in Statslogger. It is sticking on yes now, However..No live scoreboard. Chat is feeding to webmin properly

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

It was set to true and had been even before the update with no issues. I have now set it to false and enabled live scoreboard in Statslogger. It is sticking on yes now, However..No live scoreboard. Chat is feeding to webmin properly

Yes, in 4.1 the variables fed to stat logger changed. I will modify them so they do not impede your live DB settings.

 

The live scoreboard issues is on our end as well, and unfortunately i do not control/develop that element, that is prophet's domain. We are waiting on him to fix it on our end as well.

[ImportBot]

Originally Posted by _CH_KeyserSoze*:

 

Sounds good....Hopefully he can debug that issue. I am assuming he knows about it so I won't post the problem on the webadmin forum.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Sounds good....Hopefully he can debug that issue. I am assuming he knows about it so I won't post the problem on the webadmin forum.

Please do anyway, his ass needs a kicking every now and then as does mine.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

For the rest of you, the live DB problem has been resolved. You do not need to change any settings, i will post an update tonight that fixes the issue. Thank you for your patience.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Also, to the 2 servers still running the test/beta version 4.0.0.8, that version is very unstable, your layers are probably spazzing out and running into deadlock every couple hours. Please update ASAP.

[ImportBot]

Originally Posted by JR8355*:

 

For the rest of you, the live DB problem has been resolved. You do not need to change any settings, i will post an update tonight that fixes the issue. Thank you for your patience.

ty sir

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Alrighty, try this one boys:

 

https://raw2.github.com/ColColonClea...test/AdKats.cs

 

It's a test version of the fix i'm planning to release tonight. If it works, i'll push the full release.

[ImportBot]

Originally Posted by Jamesonp*:

 

Running it now, will report back with any issues.

[ImportBot]

Originally Posted by JR8355*:

 

Loaded up, see version 4.1.0.4, no joy on Live Scoreboard

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Loaded up, see version 4.1.0.4, no joy on Live Scoreboard

Like i said, live scoreboard is not under my control. I'm not sure why it is not working, but i am not the developer of that component.

 

The live scoreboard is a direct RCON link to the server just like procon is, it does not rely on the live scoreboard in the database to function, something else is making it malfunction.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Running it now, will report back with any issues.

And let me know if the PBSS on report is working properly.

[ImportBot]

Originally Posted by JR8355*:

 

Like i said, live scoreboard is not under my control. I'm not sure why it is not working, but i am not the developer of that component.

 

The live scoreboard is a direct RCON link to the server just like procon is, it does not rely on the live scoreboard in the database to function, something else is making it malfunction.

Well nothing has changed since 4.0.0.0, worked fine then, then updated to the new version and now it doesn't.