Jump to content
  • 0

Hive taking over a minute to load/waiting for auth..


Sorry for another question!

So Ive ordered a dedi box from OVH, the MC-32 one just to see if I could get it working as I have no experience with this at all!

Ive installed Win 2012R2 trial, xampp, got all the server stuff done and its all good..


When I start the console, and the game loads, it stops as it should until a player joins. The player joins and on thier screen they see the waiting to authenticate screen and its starts to count up.

The issue is, the console sits there saying game started for a while before the hive starts loading, all the while the authenticate screen is still counting up. It gets ato about 80-90 before you actually load into the game, which isnt normal!


The database has about 5500k objects, but even so, shouldnt take that long. Ive got the same database on my test server and it loads far faster, and also on my home pc server.

Ive messed around with my.ini, but no real difference has been made and Im not really sure what Im doing, Ive just copied other examples off the web.

The database is in c:/xammp on a 240gb ssd in raid0

The server files are in c:/epochserver....on the same disk. Im aware databases run better on a seperate disk, But I dont have that option right now.

Im guessing its either an issue with speed connecting to the database or something is stalling it from starting quick enough.

I read about clean up scripts being run before start up could cause this, and that would make sense, as when loaded into the game, loads of stuff is missing, specifically stuff thats not been mantained or interacted with in the last few days.

However I cant find these scripts anywhere, Ive looked using navicat in events, Ive looked using phpadmin and also heidy sql. I can find no reference to any events, querys, functions or anything.

In Hiveext.ini, cleanup is set to -1


Any help would be greatly appreciated, Im amazed I got this far on my own, but this one little issue I just cant figure out.

Share this post

Link to post
Share on other sites

18 answers to this question

Recommended Posts

  • 0

Ok, still struggling with this, but also a new issue has arises. Instead of the waiting for authentication screen taking ages, its loading me into the game, but with a black screen and just the HUD showing. Then after a minute or so, everything loads in. Again on the console, the database doesn't even start loading until a out 30s-minute after the game loads once a player connects.

Im sure its a MySQL issue, but not sure why or how to fix it. Maybe xampp is the issue and I should try a different sql server?

Share this post

Link to post
Share on other sites
  • 0

I believe -1 disables the cleanup script completely. Altho it doesn't seem like 5.5k items is all that many. Have you checked your server and client reports? They should tell you what is happening.

Share this post

Link to post
Share on other sites
  • 0

I've tried with a Completely empty database and still the same, it takes a minute for the hive to start loading once the game starts in which time you are thrown into the game but just with the back screen and Hud.  It wouldn't be so bad if it took that time but kept you in the load screen, although no ther server Have or have been on takes that amount of time  


 I'll have a look at the rpt's in a minute

Share this post

Link to post
Share on other sites
  • 0

Can't see anything in rpt that point to why there is such a delay. 

Just tried with completely standard fresh epoch files and there is still a delay, albeit not as long and you are still thrown into the game before the hive has finished loading meaning a long black screen. 

Of course this only happens on the first login after a restart and isn't the end of the world, but I've not experienced it before. Usually you stay at waiting for auth screen and then load into game once it's ready  but this seems to skip that part and load you straight in. 

Share this post

Link to post
Share on other sites
  • 0

Thanks Ebay, thats solved the black screen issue, but Im still having to wait 90 seconds or more for the database to load. At least Im on the waiting for Auth... screen rather than black! Just now I even got kicked back to lobby and had to re log where it took another 80 seconds on top, even though nothing has changed since the first restart and login where it took 90 seconds.

There are about 6k items in the database, but I use the same database and files on 3 other servers and all load in under half the time this new dedi server is.

It must be an sql issue im sure, but I just dont know what to change in the my.ini and basic.cfg to get the most from it.

If you could help with that Id be forever grateful!



Share this post

Link to post
Share on other sites
  • 0
20 hours ago, lwbuk said:

Thanks Ebay, thats solved the black screen issue, but Im still having to wait 90 seconds or more for the database to load. At least Im on the waiting for Auth... screen rather than black! Just now I even got kicked back to lobby and had to re log where it took another 80 seconds on top, even though nothing has changed since the first restart and login where it took 90 seconds.

There are about 6k items in the database, but I use the same database and files on 3 other servers and all load in under half the time this new dedi server is.

It must be an sql issue im sure, but I just dont know what to change in the my.ini and basic.cfg to get the most from it.

If you could help with that Id be forever grateful!



I'm also using MC-32 Game server hosted in France.

https://mysqltuner.codeplex.com/ Download that and use it to tell you what you need to change and how to optimize your my.ini. Also i recommend just installing the latest version of MYSQL server instead of using XAMPP, i noticed a slight performance increase by doing so. I run a Overpoch server with 60 Slots and have around 30-50 players on most of the time.

You can also check this out:https://forums.dayz.com/topic/51542-psa-server-admins-how-to-optimize-your-dayz-server-for-maximum-performance/

Here is my basic.cfg


Hope this helps! If you need more help, feel free to pm me!


Share this post

Link to post
Share on other sites
  • 0

Hi Hoplox, many thanks for that link, I shall have a play with it later. 

I have already ditched xampp and now using MySQL community server. I also messed around with the basic.cfg a bit yesterday. 

Once the server is running its fine, 45-50 server fps, albeit with just me in game and likely to plummet when full, it's just the initial loading time straight after restart.  I'm being kicked back to the lobby before its done loading every time which isn't good. 

Great to see someone with a (few) successful servers still willing to help others out! 

Share this post

Link to post
Share on other sites
  • 0

I have the exact same issue. All works fine, but the initial loading after restart takes couple of minutes to start loading from the database. After it starts it loads everything within few seconds and I can connect to the server. Have you find a solution for this? I am using Windows to host the server.




Share this post

Link to post
Share on other sites
  • 0

On a windows 2012 r2 server I use WAMP 64-bit very easy to setup and use I have had no issues running wamp server with arma2 servers (even 1 database for multiple a2 servers)


WAMP is an acronym that means: Windows, Apache, Mysql, Php.

  1. XAMPP is NOT cross-platform. There is XAMPP for Windows, XAMPP for Linux, for Mac and for Solaris, but each pack contains different pieces of software, runs differently with different performance, etc. (cross-platform means that you take the exact same piece of software and it runs the same way on different platforms ... like Azureus used to be: a jar that you could use the same way)

  2. XAMPP for Windows is bloated, big time. You have mail server, FTP server, accelerator, web-dav, ssl out of the box, etc. Do you really need them all? It's not exactly an entry-level package, but in general it makes installation of everything much easier. Beyond that, any customization requires the same effort as for any other pre-made stack. But if you install on your own box, you probably don't need FTP server, do you?

  3. WAMP is lighter (mostly the basics). Everything that's AMP is there, beyond that you have a couple of tools ,phpMyAdmin, sqlite, xdebug. You need SSL? You have to configure it. You want access to mail server? Must install it yourself. FTP? Ditto.

  4. WAMP (like the name says) runs only on Windows (either 64/32-bit).

For a local machine on Windows, WAMP is the way to go. Light, smooth and post-install config takes a click. XAMPP for Windows isn't much of a competitor due to issues on 64-bit installation (naturally: more bloatware to install, you need to manage each piece of extra software between 32/64-bit)

Share this post

Link to post
Share on other sites
  • 0

I don't know why anyone would use xampp or wamp when all you really need is MySQL and MySQL workbench or a more lightweight DB administration application.  if you're installing either you already have desktop access to your server and can just RDP into the server, or remotely connect using MySQL workbench

For all of my servers, I use mysql 5.7.xx http://dev.mysql.com/downloads/mysql/ and tweak the settings accordingly (believe it or not the defaults are not always the best) https://www.percona.com/blog/2016/10/12/mysql-5-7-performance-tuning-immediately-after-installation/

Anyway, 1.0.6 uses a significantly improved server_monitor.sqf and a new loading method in HiveExt.ini. When looking into why the server took so long to start up in, I found that the HiveEXT.ini only took 2-3 seconds to load all objects from the DB into SQF, but server_monitor took minutes to spawn the objects into the game.

Share this post

Link to post
Share on other sites
  • 0

Use "Tail for win32" and watch the RPT file live as its generated. you'll see there is a lot going on during this time probably.  There's probably a way to call the database to load sooner but its still gonna leave you waiting for everything else to load up still.

Share this post

Link to post
Share on other sites
  • 0

@lwbuk any suggestions? im getting this now aswell. using stock epoch files still taking up to 2 mins to for the hive to start.

I just sit at

 1:11:44 "PRELOAD_ Functions\init [[<No group>:0 (FunctionsManager)],any]"
 1:11:44 "MPframework inited"
 1:11:45 "dayz_preloadFinished reset"


 1:14:13 "HIVE: Starting"
 1:14:13 ["TIME SYNC: Local Time set to:",[2012,8,2,13,13],"Fullmoon:",true,"Date given by HiveExt.dll:",[2017,6,9,13,13]]
 1:14:13 "HIVE: trying to get objects"
 1:14:14 "SERVER FPS: 31  PLAYERS: 2"
 1:14:14 "HIVE: found 184 objects"
 1:14:14 "HIVE: Request sent"
 1:14:14 "HIVE: Streamed 184 objects"

installed and uninstalled every Visual C++ just incase that was the issue, still having this problem.

No errors anywhere that i can see. checked client server rpt, hive log, server log.

No major changes made to the server machine since this happened.

Share this post

Link to post
Share on other sites

Join the conversation

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

Answer this question...

×   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.


  • Similar Content

    • By Achef
      So I recently started up in a new host and haven't gotten to make the server run, found that a ca/modules bis_fnc issue is recurring but doesn't affect players when running coop missions like the default arma 2 oa ones, but when trying with Epoch hive won't connect/start despite being configured.
      Hive error
      Meanwhile at line 23...
      I'm still bad with Pastebin, sorry.
      This error has been chasing me for 2 days now
    • By Sandbird
      Dayz.Epoch.1.0.62 - 3d.Editor.Live.Mission with Database interaction

      -=Youtube Demo=-
      What is this
      A custom mission file for the purpose of testing/writing scripts for DayZ Epoch without the need of a server.
      It emulates the dayz_server and dayz_mission files, so you can write scripts using the 3d editor. No need to use a dayz_server for debugging anymore. We all know how time consuming that is.

      Full Database integration (yes thats right... [:)] I would suggest to have a maximum of 100 objects in your object_data table for faster results.
      Took 5 min to load 10000 objs from my real database, so also make sure you dont go crazy with the MaxVehicleLimit, MaxDynamicDebris values in the init.sqf Fully working GUI, zombies, hit registration, addactions, everything! Write code and execute it on the fly. No need to start a server and join with a client to test things. 100% of your scripts will work! (dynamic weather, default loadouts, custom scripts etc) 2 setups. A default 3d editor player with a default loadout or a Real database character based on your UID Includes most of BIS_fnc functions, so actions like BIS_fn_invAdd will work (i've added most common ones...more included though...check details bellow.) Everything works...when i say everything i mean EVERYTHING !. (Spawning objects on mission start, traders (buy/sell), maintenance, character update, events, stats...etc) New Features!
      All .FSM files have been converted to .SQF meaning the mission acts as a full fledged server / client merge. New character creation has been ignored though, so the server expects that the client that is about to connect exists in the database. The server will start, wait for a 'fake client connection to happen' (you pressing the Preview button), and then it will load your character from the database, spawn Hive objects and create new based on your MaxVehicleLimit values etc, then initialize the events and finally spawn the character to his worldspace location. Use AdminTools to spawn any Perm, Temp vehicle you want, including buildings, crates etc. Building objects is working as expected with a little AddAction trick. Unfortunately the primary display (eg: findDisplay 46) isnt working inside the editor. That means that building stuff or placing objects is very hard to do since we can't 'capture' keystrokes.
      Further details below after the Installation instructions. Arma2Net is not allowed by Battleye anymore, so i am using extDB3 now. Requirements:
      A mysql server on the same machine as your Arma2 editor. Well...a remote PC would work as well...just make sure YOU ARE NOT using your original database. Make a copy of it!. This mission will interact with your database !
      If you don't have a mysql server on your pc...i suggest you get WampServer. It's the easiest php/mysql server out there.
      Head over to the GitHub where the project is. Click Download on the right sidebar, and extract the rar file. Copy the 3d.live1062.DayzEpochTemplate.Chernarus mission file in your \My Documents\ArmA 2\missions\ folder If your active Arma profile is not the default one, then you probably should extract it in the \My Documents\ArmA 2 Other Profiles 2\missions\ folder, otherwise you won't be able to find the mission inside the editor. Copy everything inside "Arma2OA root folder" in your root Arma2OA folder (the same folder where @DayZ_Epoch_Server, MPMissions are). The real_date.dll...(Thanks to killzonekid) is used to get your machine's date/time to be used for live day/night cycles inside the game (...you can set a fixed day if you want...details bellow). The tbbmalloc - tbbmalloc_x64.dll files are provided by extDB3. They shouldnt interfere with your normal game, but they are needed for the mission to be able to connect to your MySQL server. (Make a backup of your original ones if you want, just be safe.) EATbaseExporter is used by the AdminTools, and allows you to export bases to an .sqf format so you can import them afterwards to your server. Now edit -=START HIVE MISSION=-.bat which was placed in your Arma2 folder, and fix the paths to their proper values. If you are using DZLauncher then the @Dayz_Epoch folder is probably where i placed it myself.  Battleye needs to be disabled inside the editor otherwise the extDB3 addon will not work. The .bat is taking care of that. It will disable Battleye after 7 seconds. Depending on your machine, if you see that the time isn't sufficient, raise that value a little bit. A sample Database has been provided with me as a character and a basic loadout. You can of course use your own database, just remember to delete most of your Object_Data table vehicles. The more vehicles you have there, the longer it will take for the dayz_server to spawn them. If you just want to write a script independent of cars etc...why wait 5 minutes for the server to spawn 10000 vehicles :) Open "ArmaOA\@extDB\extdb3-conf.ini" and add your test database data there. I named the test SQL DB dayz_cherno [dayz_cherno] IP = localhost Port = 3306 Username = dayz Password = mypass123 Database = dayz_cherno # dayz_cherno is the name of the database (change it in both values) # localhost is your mysql server (could be an IP value as well) # 3306 your mysql port # dayz is your database username # mypass123 is your database password  
      When the game launches, press Alt+E, select Chernarus, then Load mission 3d.live1062.DayzEpochTemplate.Chernarus
      Open \My Documents\ArmA 2\missions\3d.live1062.DayzEpochTemplate.Chernarus\init.sqf
      Go to line 61 and start editing the values there. DB_NAME is the name of your database (same as the extdb3 config file).
      Add your PlayerUID value (same as the DB one) in line 72. (That the player you want to load from the database)
      Depending which map you want to use, you have to change the dayZ_instance variable and also the MarkerP values (line 62) based on your mission.sqm file. Its for the Hive to spawn random vehicles, roadblocks and mines at proper locations based on the map. Just read the comments there for how to get the values. Its really simple. Just copy paste stuff from your mission.sqm file.
      Default setup vs Database setup
      There are 2 ways of initializing your player.
      A live database player based on his UID in the character_data table (coordinates, medical states, inventory etc) A default 3d editor player with a basic loadout. (Ignores Hive Loadouts and initial vehicle spawns) Default setup (extDB3)
      [DefaultTruePreMadeFalse = true;] This option is now the default one, because it's so much easier to set up, plus a lot of things have changed in the 1062 Epoch version. I couldn't totally separate the server files from the client files, so in the end a Database is necessary for the Mission files to work properly. To setup your character with this method, leave DefaultTruePreMadeFalse to true;  Everything is database based..so no need to do anything else. The mission will start with all your stats, inventory, conditions and spawn you where your world coordinates are. Premade Character Setup
      [DefaultTruePreMadeFalse = false;] This setup DOES NOT initialize the character based on a database entry, or does any HIVE related queries on mission start. (like load objects etc). Instead it uses some premade stats that you set, and only uses the Database on updates (buy vehicles etc) The loadout of the player is set in the init.sqf in line 77  
      player setVariable ["CharacterID", "1", true]; // Set here the characterID of the player. It can be anything...just leave it 1 if you want. player setVariable ["playerUID", "111111", true]; // Set here the playerUID of the player you want to have. player setVariable["Z_globalVariable", 100000]; player setVariable["Z_BankVariable", 100000]; player setVariable["Z_MoneyVariable", 100000]; player setVariable["humanity", 11000]; player setVariable["humanKills", 10]; player setVariable["banditKills", 20]; player setVariable["zombieKills", 30]; player setVariable ["friendlies", ["222222","333333"], true]; //Both DZE_Friends and this must be set for friendlies to work properly DZE_Friends = ["222222","333333"]; Everything else should work fine with the database....like traders, salvaging, etc...Unfortunately since the 1062 ver had many differences from the 1051 one, i couldn't really make this Profile option a standalone one, without any Database interaction. So in order for you to minimize any errors in the log file, i would suggest you load my sample db file provided, and also change those CharacterID and PlayerUID values in PLAYER_Data and CHARACTER_Data tables to the ones you set up here, just in case.... The Premade character setup is for people that want to fast debug a script they are making and don't want to wait for the Hive to load all map objects and authenticate the player first. Further Details to change (in both Profile Cases)
      The description.ext, mission.sqf, mission.biedi files have your character's name in them. Just search for the word Sandbird in all of them and change it according to the PlayerName value you have in your Player_DATA table for your PlayerUID value.
      Example taken from description.ext. DONT change the actual My_Player text. The mission file needs that string to read what you typed in the name field.
      class My_Player { name="Sandbird"; face="Face20"; glasses="None"; speaker="Male01EN"; pitch=1.1; };  
      Important info
      Init.sqf values
      DefaultTruePreMadeFalse = true; // True: Read player's data from the database (based on UID), False: the normal player the editor has StaticDayOrDynamic = true; // A static date is set at the bottom of \dayz_server\init\server_function.sqf. Set this to false if you want real time/date inside the mission. DZEdebug = false; // Set to true if you want a more detailed log file Enable Keyboard actions (menu option) // (findDisplay 46) wont work inside the editor. That means that building stuff or placing objects is very hard to do since we cant 'capture' keystrokes. I kinda fixed this with a trick. In order to build something first you have to initiate the building action (holding the object in your hands) and then scroll with your mouse wheel and select Enable Keyboard actions. This will create a layer on your screen capturing your keystrokes thus allowing you to change orientations etc. Pressing ESC twice after and it will close the fake display and return to normal play mode. You will have to do this every time you want to build something. Related to coding
      Since the Editor has some limitations because its not a real server some things will never work. For example:
      _playerUID = getPlayerUID player; will never work in the editor. To get the _playerUID you have to do this:
      _playerUID = player getVariable ["playerUID", 0];
      This is the most important thing to remember. Lots of scripts use getPlayerUID. You have to remember to change it every time you want to use it.  Of course the player value is just an example here. If you were inside a loop and it had (getPlayerUID _x) then you have to rewrite it like this: (_x getVariable["PlayerUID",0]) findDisplay 46 does not work in the editor. If you are using/making a script that uses Display 46 try using my Enable Keyboard action. It might work in your case. publicvariableServercommands don't exist in the editor. There is no server to accept the command. If you want to use addpublicvariableeventhandler you can do it with call/spawn commands. You can find the handlers usually in the PublicEH.sqf.
      Example: PVDZE_plr_Save = [player,dayz_Magazines,false,true]; publicVariable "PVDZE_plr_Save"; can be written like:
      PVDZE_plr_Save = [player,dayz_Magazines,false,true]; publicVariableServer "PVDZE_plr_Save"; // keeping this so when you move the code to the real server you remember to add it. [player,dayz_Magazines,false,true] spawn server_playerSync; // what to call is usually inside publicEH.sqf. In this case search for PVDZE_plr_Save in the PublicEH file and check the call it makes in the end. You could also change the publicVariableServer to publicVariable. That should work inside the editor. But keep in mind these changes wont work on the live server, since one command broadcasts something to the server while the other just to the client running it. I would suggest you keep the original value and do the PublicEH call instead, marking it down with some debug comments next to it, so when you are done and want to transfer the files to your live server you just remove the call and everything should work as expected.
      Don't forget to change the paths when you are adding addons to test/modify them. For example, notice the differences here:  player_switchModel = compile preprocessFileLineNumbers "dayz_code\compile\player_switchModel.sqf"; player_checkStealth = compile preprocessFileLineNumbers "\z\addons\dayz_code\compile\player_checkStealth.sqf"; The first line will look up for player_switchModel.sqf inside the editor mission files, while the 2nd one will go to the @Dayz_Epoch map file and get the .sqf file. Same thing applies for the dayz_server files (server_functions.sqf). Once you are done with your script and you have added new compile lines, you need to fix them back to their proper values before you upload them to your live server.
        If you are missing any BIS_fnc functions then check the folder dayz_code\system\functions and see if it's available there to include it in the compiles.sqf. Set DZEdebug = true;  in the init.sqf. And ALWAYS check your RPT log file for debugging. Its located at : %AppData%\Local\ArmA 2 OA folder. Related to mission file included
      You'll notice when you start the mission there are 2 bots standing there. If you double click the soldier you'll see that he initiates this script scripts\BotInit.sqf. I left that in purpose in case you want to do some scripting that requires 'another player', and you want to initialize the fake player like that. The other bot can be deleted. I just left it there because i was testing a Tag Friendly script, and needed a 3rd 'player' that has me as a friend. I've included a simple Fireworks script i made a while back only this time i used some better effects taken from aliascartoons work. Just add a 'SMAW_HEDP' into your inventory and right click on it to test it out. Here is how the old script used to look like Fireworks. Also you'll find a little 'hat script' in the files, just right click a 'IRStrobe' item to add a hat to your player. Both script were written inside the editor using the mission file above...just a small example to show you how easy it is to write code there. The @extDB folder contains a folder called debug_files. These .dlls (when replaced the ones provided) activate a more detailed log file (found under arma 2 operation arrowhead\logs folder). It will show ALL MySQL queries going in/out of the database. Very useful if you are running any custom SQL queries and the RTP log file isn't enough.
      Final Notes
      These are heavily modified files...Dont overwrite them with your own files. Add to them instead of replacing them.
      If you are writing scripts that dont require the server to restart, then you can just go to 2D editor and press Preview again after you make the changes. No need to hit Restart. As long as you are doing changes that doesnt affect the Hive loading you can basically run things on the fly. For example in the init.sqf at the bottom i added a Add BankMonkey example. That command just loads the custom\money.sqf and shows a simple extDB3 example on how to select/update a DB table. Since this command doesnt require the server to restart, you can just hit Preview, test things out, and if you want to make changes, go back to 2D Editor, edit your changes in the money.sqf file and hit Preview again. No need to hit Restart and wait for the dayz_server functions to do their thing again.
      The whole purpose of this project was to not waste any more time trying to code on this god forsaken Arma engine.
      And a personal note....You will NEVER find an easier way to code stuff for Dayz....period. This is the fastest way to write code and see it in action.

      Hope this code will help you write code faster and easier !
      ### Credits
      This mission file would not be possible without the help of these addons/people

      DayzEpochTeam | http://epochmod.com
      killzonekid | http://killzonekid.com
      extDB3 | https://bitbucket.org/torndeco/extdb3/wiki/Home
      ebayShopper | https://github.com/ebayShopper/TestKit
      JasonTM (for the latest beta AdminTools)| https://epochmod.com/forum/topic/44863-release-epoch-admin-tools-v-1107-test-branch/
    • By Warburgg
      Hello everyone. I would like to ask for help regarding a problem I have been having on my server.
      Items stored in the vault are not being stored in the SQL database.
      I have tested with the safe and the lockbox and both are not working but with the tent it works and saves the items in the database after the server restart.
      ArmA2OA.RPT: https://pastebin.com/X2cT7BBU
      arma2oaserve.RPT: https://pastebin.com/rqFNGbDy
      server_log.txt: https://pastebin.com/ZVWAzgNP
      Please help me. My players do not want to stay on the server because of this and if I remove the safe and leave only the tent (which is what saves the items) they will cry hahaha
  • Advertisement
  • Supporters
  • Discord

  • Create New...