Server Anti-cheat Conflict [Fixed]

[Beck (DayZ) 1768]

Hey guys, I've just recently set up a DayZ server for testing. I'm trying to install this anti-cheat I have but the instructions tell me to add this to the end of my server_functions.sqf.

          #include "AH.sqf"

This causes a conflict with the database and it no longer requests authentication. Obviously I can't add this to the end of the server_functions.sqf because there is a line that calls the database. Where should I input my anti-cheat line?

Edited August 25, 2013 by Beck

[AmberHelios 2071]

you add it to the bottom of the server_functions.sqf after the last };

 

put it in the same folder as it

[geryon 180]

Is it the free one from Blur or another one from opendayz?  If it isn't a current one you might be exposed with the latest scripts.  You also pay a price that your battleeye filters will be reduce.  If you are willing to live with this it is a pretty effective antihack.

 

My guess why you are getting authentication issues is the following:

 

You need to comment out the line the following line in init.sqf in the client mission file.

//#include "\z\addons\dayz_code\system\REsec.sqf"

 

The anti remote execution script thinks everyone entering is attempting to do a remote execution.  It's a compromise and you pay a price by losing resec.sqf.  

 

Protection wise I think it is even between what battleeye currently does.  The advantage is that you essentially get an admin console and some other functionality.  However I must caution that you have to be on top of your admins.  Great powers comes great responsibilities.  I would recommend that admins do not play on the server, it's simply too much temptation.

 

Cheers,

 

Geryon

[AmberHelios 2071]

if its the free one from blur or the other one from opendayz he should exec it not include it 

 

like this 

 

execVM "\z\addons\dayz_server\init\ah.sqf";

[Beck (DayZ) 1768]

you add it to the bottom of the server_functions.sqf after the last };

 

put it in the same folder as it

This creates an issue with "requesting server authentication". 

 

Is it the free one from Blur or another one from opendayz?  If it isn't a current one you might be exposed with the latest scripts.  You also pay a price that your battleeye filters will be reduce.  If you are willing to live with this it is a pretty effective antihack.

 

My guess why you are getting authentication issues is the following:

 

You need to comment out the line the following line in init.sqf in the client mission file.

//#include "\z\addons\dayz_code\system\REsec.sqf"

 

The anti remote execution script thinks everyone entering is attempting to do a remote execution.  It's a compromise and you pay a price by losing resec.sqf.  

 

Protection wise I think it is even between what battleeye currently does.  The advantage is that you essentially get an admin console and some other functionality.  However I must caution that you have to be on top of your admins.  Great powers comes great responsibilities.  I would recommend that admins do not play on the server, it's simply too much temptation.

 

Cheers,

 

Geryon

I am running DayZ Overwatch and the closest thing I can find to that line is this:

// [] execVM "\z\addons\dayz_code\system\antihack.sqf";

It was already commented out.

 

The anti-cheat I am trying to install is this: http://dayzmod.com/forum/index.php?/topic/132999-new-sporkulus-antihaxwhitelister/

[geryon 180]

Ah okay Beck.  Your assessment on the client mission file is correct if you are running Overwatch.  I'm not familiar with the antihack you are using and the Overwatch servers I've setup I haven't used any antihacks.  

 

I would raise a service ticket or if you haven't already ask on the developer's forum.  By the way the official Overwatch servers use a version specifically implemented by Blur (well last time I checked).

 

Sorry I can't be more help. 

[geryon 180]

Oh by the way if you repackaged the server file with the antihack script commented out are you able to authenticate?  Maybe it's a corrupt pbo?  Another obvious question is the script location and the path the same?

[Beck (DayZ) 1768]

Oh by the way if you repackaged the server file with the antihack script commented out are you able to authenticate?  Maybe it's a corrupt pbo?  Another obvious question is the script location and the path the same?

My AH.sqf is in the same folder as my init.sqf for the server. I think that by default the Overwatch missions.pbo has that script commented out. It was like that when it came in the server package.

[geryon 180]

If you comment out your AH.sqf script and repack the server file does the problem go away?

[Beck (DayZ) 1768]

If you comment out your AH.sqf script and repack the server file does the problem go away?

This is what I did, I moved the

          #include "AH.sqf"

line above this

call compile preprocessFileLineNumbers "\z\addons\dayz_server\compile\fa_hiveMaintenance.sqf";

#include "owcleanup.sqf";

//Buildings

call compile preProcessFileLineNumbers "\z\addons\dayz_server\buildings\main.sqf"

and my server connects to the database fine, but the anti-cheat doesn't work.

The lines above are the last few lines in my server_functions.sqf.

Edited August 25, 2013 by Beck

[geryon 180]

Do you have the semicolon after the line: #include "AH.sqf"?

 

It should look like this: #include "AH.sqf";

 

Also put it at as the last line.

 

If not try this at the last line.

 

execVM "\z\addons\dayz_server\init\AH.sqf";

[Beck (DayZ) 1768]

03:23:19 HiveExt(0): [Error] Error executing |Child:101:10304838:1:[bP]Beck:|

Well now the HiveExt - dayz_overwatch command prompt window is opening but it's having issues finding me in the database I guess.

 

This is with execVM "\z\addons\dayz_server\init\AH.sqf";

 

Edit:

Even after I remove the execVM "\z\addons\dayz_server\init\AH.sqf I still get the error, and now I'm having and issue with:

This server is running an incorrect version of the server side application. You cannot play on this server. If you are the server administrator please contact DayZ Staff.

Edited August 25, 2013 by Beck

[geryon 180]

Okay I'm going out on a limb here but is the server and your client versions matching?  Maybe refresh both of them?  I assume the Overwatch server is based off of the latest?

 

Edit:

Is this a fresh install?  Meaning other then you there are no one else who have logged in. There is not history of other players and their gear?

Edited August 25, 2013 by Geryon

[Beck (DayZ) 1768]

Okay I'm going out on a limb here but is the server and your client versions matching?  Maybe refresh both of them?  I assume the Overwatch server is based off of the latest?

 

Edit:

Is this a fresh install?  Meaning other then you there are no one else who have logged in. There is not history of other players and their gear?

I have been playing on the server with a few friends for the past day or so. I think my character data is corrupt. Could you take a look at this and maybe translate it to something I could understand?

Error 1062 (Duplicate entry '10304838' for key 'uq_profile') in MySQLStmtExecute SQL: 'insert into profile ('unique_id', 'name') values (?, ?) values("10304838", "[bP] Beck")'

Everyone else seems to be able to connect fine.

Edited August 25, 2013 by Beck

[geryon 180]

Ah cool at least everyone can connect (except you).  That's a start.

 

I think your assessment is correct your character instance in the database is corrupt. The game is trying to insert into the profile table incorrectly thinking your unique id and name is not there.  

 

Warning not tested and with limited knowledge:

A possible correction would be to delete the current row representing you in the profile table.  However there might be other tables that reference the row you are about to delete.  If it does it won't allow you to delete it.  If the database prevents it (foreign key constraint) then you will have to delete the row(s) from the other tables referencing the row in the profile table first.  

 

This will all likely remove your current character out of the database and what ever gear you had.  Note make sure you only delete your guy and be very sure when you do it.

 

Another less drastic option would be to change your name and log in.  I doubt this will work but it won't be game busting.

 

 

Cheers,

 

Geryon

[Beck (DayZ) 1768]

Thanks for all the help so far! I can't access the server (Still trying to fix my character corruption in the database) but one of my admins hopped on to test it out. He keeps getting kicked for some public variable restrictions.

25.08.2013 05:10:03: [bP] Urban (24.145.89.10:2316) {GUID} - #0 "tlmadminrq" = [1,<NULL-object>,[4623.52,10236.9,0]]

25.08.2013 05:12:42: [bP] Urban (24.145.89.10:2316) {GUID} - #0 "tlmadminrq" = [0,<NULL-object>,"350z_ruben",[14025.3,11294.9,0]]

25.08.2013 05:18:51: [bP] Urban (24.145.89.10:2316) {GUID} - #0 "tlmadminrq" = [0,<NULL-object>,"350z_red",[14028.8,11293.1,0]]

25.08.2013 05:20:40: [bP] Urban (24.145.89.10:2316) {GUID} - #0 "tlmadminrq" = [17,<NULL-object>,1,2000]

25.08.2013 05:24:39: [bP] Urban (24.145.89.10:2316) {GUID} - #0 "tlmadminrq" = [5,<NULL-object>,<NULL-object>]

25.08.2013 05:27:01: [bP] Urban (24.145.89.10:2316) {GUID} - #0 "tlmadminrq" = [6,<NULL-object>]

 

Edit:

Finally got my database issue fixed but I was kicked as soon as I joined:

25.08.2013 05:33:15: [bP] Beck (69.250.60.18:2316) {GUID} - #0 "v_hji3e" = ["[bP] Beck","10304838","F1"]

 

Edited August 25, 2013 by Beck

[Beck (DayZ) 1768]

Just cleared out my public variable restrictions. Case closed, thanks for all the help!

[geryon 180]

Ah great that's really good to hear.  It took me a while to get it working myself.  Now you have to put in some nasty Sarge AI to make things interesting.   :)   Well maybe not. 

[Beck (DayZ) 1768]

Ah great that's really good to hear.  It took me a while to get it working myself.  Now you have to put in some nasty Sarge AI to make things interesting.   :)   Well maybe not. 

Already done!