Jump to content
  • 0
Thug

[SOLVED] DATABASE NOT LOADING-DEDICATED BOX

Question

I have setup many Epoch servers over the past 4 years. All of which were built on old PC's I have.
Players have no problem getting into game.
In the past month I built a Dedicated Server  Xeon, Server board, Server memory, etc 
Installed Windows 2016 essentials on it.
Set up a game server, one that has dinosaurs in it.    It works!

Have the same Taviana Epoch server working on a nomal PC, Players can join!

Now on with my problem
Installed MySQL for Windows
Installed all files for the Taviana Epoch Server
Created a data base called tavi_2365
Have port forwarded the port of 2365
Setup new rules for inbound and outbound 2365 in the firewall

When I start the server all goes as planned
Server starts up
Can see the server from my computer
When I try to join, I get the lobby and click ok
The loading screen comes up and the first white bar runs as normal
The second white bar starts and says waiting for server to start authentication
Then times out at 120 seconds

On my second monitor I am watching the server load
It gets to game started and it just sets there
Database never starts, get the following error in server RPT
 2:09:23 "HIVE: Starting"
 2:09:24 Error in expression <erver_hiveReadWrite;
_outcome = _result select 0;
if (_outcome == "PASS") then {>
 2:09:24   Error position: <select 0;
if (_outcome == "PASS") then {>
 2:09:24   Error select: Type String, expected Array,Config entry
 2:09:24 File z\addons\dayz_server\system\server_monitor.sqf, line 23

Below are my Server RPT, Client RPT, HiveExt.ini, and server_monitor.sqf

server RPT

https://pastebin.com/6M9sG9RB

client RPT

https://pastebin.com/9ayVMXjF

hiveext.ini

https://pastebin.com/3wx9VDM9

server_monitor.sqf

https://pastebin.com/fUnU09Gp

UPDATE   PROBLEM SOLVED

Had to install all of the Visual C++  from 08 to 17   they were a little hard to find, but I did it.    Thanks to all that helped me. :smile:  @juandayz @icomrade  and more

below is a pic of what I had to install to get it to work

https://dl.dropboxusercontent.com/u/487376647/MS Visual C.PNG

Here is a link to my drop box for a .rar and a .zip for all the MS Visual C++ that I used to get my dedicated server working.

https://dl.dropboxusercontent.com/u/487376647/All Microsoft Visual C%2B%2B Redistributables.rar

https://dl.dropboxusercontent.com/u/487376647/All Microsoft Visual C%2B%2B Redistributables.zip

Share this post


Link to post
Share on other sites

7 answers to this question

Recommended Posts

  • 0
3 minutes ago, lwbuk said:

The port in the hiveext.ini you posted is 3306 

3306 is the database port and 2365 is the game port. Two different ports.

but thank you for checking the post 

Share this post


Link to post
Share on other sites
  • 0

@juandayz In your first post you said you removed localhost and put 127.0.0.1 and it worked.  I did the same and made no differents.

55 minutes ago, juandayz said:

this guy seems have same error

Thank you for the information. I have read that and made sure I installed the MS Visual C++.  Also I updated the post with a pic to show what was installed.

Still the database will not run.

Thank you for your time.   This one has stopped me in my track. Have been up all night trying to find out what is wrong. :sleep:

Share this post


Link to post
Share on other sites
  • 0
Just now, Thug said:

@juandayz In your first post you said you removed localhost and put 127.0.0.1 and it worked.  I did the same and made no differents.

Thank you for the information. I have read that and made sure I installed the MS Visual C++.  Also I updated the post with a pic to show what was installed.

Still the database will not run.

Thank you for your time.   This one has stopped me in my track. Have been up all night trying to find out what is wrong. :sleep:

oh yes,, i comment about truncate your player login , player data and character.. but after read the post that i link you,, and icomrade said the same.. so i remove it... anyway --- yes u need the latest visual c++ i had the same problem when i leave 1.0.5.1 and pass to 1.6..  install the visual c++ 2015 and server works.

 

YOu already try truncate your db?

post for you again the .bat

Spoiler
@echo off
:: MAKE SURE TO CHANGE THESE BEFORE STARTING THE SERVER!
:: Directory Settings
set MYSQLDIR=C:\xampp\mysql\bin //redirect to your mysql.exe
:: Your Settings Here
set MYSQLHOST=127.0.0.1
set MYSQLUSER=your user
set MYSQLPASS= youruser pass
SET MYSQLDB= your db name
cls
title   Server Cleanup Started
:start
"%MYSQLDIR%\mysql.exe" -h %MYSQLHOST% --user=%MYSQLUSER% --password=%MYSQLPASS% --database=%MYSQLDB% --execute="truncate object_data;"
"%MYSQLDIR%\mysql.exe" -h %MYSQLHOST% --user=%MYSQLUSER% --password=%MYSQLPASS% --database=%MYSQLDB% --execute="truncate character_data;"
"%MYSQLDIR%\mysql.exe" -h %MYSQLHOST% --user=%MYSQLUSER% --password=%MYSQLPASS% --database=%MYSQLDB% --execute="truncate player_data;"
"%MYSQLDIR%\mysql.exe" -h %MYSQLHOST% --user=%MYSQLUSER% --password=%MYSQLPASS% --database=%MYSQLDB% --execute="truncate player_login;"
echo (%time%)  Server Cleanup Complete
exit

 

 

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.

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

Loading...

  • Similar Content

    • By Reaper5150
      Simple but fun little script I put together awhile ago.
      What it does? It is bound to a object in this case "ItemObsidian" as a right click, but can be changed to whatever you want. It then will sends out a message to the players on the server and marks the player with red smoke and a marker on the map.
      The player will then get 2 mins of god mod acting like the amour. Once the amour takes damage (All it is is a countdown timer really) The god mode is then disabled so they can be killed.
      I'm still working on this and will update it when it is done. If any of you better scriptwriters then myself ( I'm still a noob lol) have any ideas on how to improve this? contact me so I can give you credit in the update :)
      Known bugs:
      marker sometimes stays on map Credits to : @Schalldampfer  For helping me understand map markers
      Install: Place this in your scripts folder name it something like Jugg.sqf
      //========================================================
      //========= Juggernaut script-Written by Reaper5150 ===========
      //=======================================================
      sleep 2;
      [nil,nil,rTitleText,"THERE IS A JUGGERNAUT,FIND HIM AND KILL HIM IF YOU CAN!!!","PLAIN",3] call RE;
      sleep 1;
      [nil, player, rSAY, "YOURSOUND.OGG", 100] call RE; //Add your custom sound here when Juggernaut spawns 
      [] spawn {
      player removeMagazine 'ItemObsidian';//Add whatever object you want and bound to your right click function
      sleep 5;
      [nil,nil,rTitleText,"THE JUGGERNAUT HAS BODY ARMOR,WE CAN'T KILL HIM...HELP!!!","PLAIN",3] call RE;
      ////////Set marker/////////////////////////////////////////////////////////////////////
      [] execVM "scripts\marker.sqf";
      //Start Smoke Marker//////////////////////////////////////////////////////////////////////////
      sleep 5;
      PJ_grenade = "SmokeShellRed" createVehicle position player;
      PJ_grenade attachto [vehicle player,[0.1,0,0]];
      sleep 2;
      [nil,nil,rTitleText,"THE JUGGERNAUT (PLAYER) HAS BEEN MARKED WITH SMOKE AND ON THE MAP!!!","PLAIN",3] call RE;
       
      //Temp Godmode for 2 mins////////////////////////////////////////////////////
      (vehicle player) removeAllEventHandlers "handleDamage";
      (vehicle player) addEventHandler ["handleDamage", { false }];    
      (vehicle player) allowDamage false;
       
      //Acts like a countdown timer//////////////////////////////////////////////////////////////////
      sleep 90;
      [nil,nil,rTitleText,"THE JUGGERNAUTS ARMOR HAS TAKEN 30% DAMAGE","PLAIN",3] call RE;
      sleep 100;
      [nil,nil,rTitleText,"THE JUGGERNAUTS ARMOR HAS TAKEN 50% DAMAGE","PLAIN",3] call RE;
      sleep 110;
      [nil,nil,rTitleText,"THE JUGGERNAUTS ARMOR HAS TAKEN 90% DAMAGE","PLAIN",3] call RE;
      uiSleep 120;
      [nil,nil,rTitleText,"THE JUGGERNAUTS ARMOR IS WEAK...TAKE HIM OUT NOW!!!","PLAIN",3] call RE;
      sleep 2;
       
      //Start ending Juggernaut///////////////////////////////////
      (vehicle player) addEventHandler ["handleDamage", { true }];    
      (vehicle player) removeAllEventHandlers "handleDamage";
      (vehicle player) allowDamage true;
      uiSleep 240;
      deleteVehicle PJ_grenade;
      END;
      Call it from your right click
      ["ItemObsidian","JUGGERNAUT","execVM 'scripts\Jugg.sqf';","true"], 
      marker.sqf:
      _unit = player;
      _nameP = name _unit;
      _markerobjp = createMarker [_namep,[0,0]];
      _markerobjp setMarkerShape "ICON";
      _markerobjp setMarkerType "mil_dot";
      _markerobjp setMarkerColor "ColorRed";
      _markerobjp setMarkerText _nameP;
      _markerobjp setMarkerSize [1,1];

      while {alive _unit} do {
      _markerobjp setmarkerdir (getdir _unit);
      _markerobjp setMarkerPos (getPos _unit);
      _markerobjp setMarkerText _nameP;
      sleep 5;
      };
      ////////////////////////////////////////////
      uiSleep 240;
      deleteMarker _markerobjp;
       
    • By Vladick
      BSBS Server IP: 216.244.93.103:7802
      Website: https://bsbsepoch.000webhostapp.com/
      Discord: https://discord.gg/PVn8PvG
      Server Features:
      PvPvE Database wiped 1/5/18 ESS V3 spawn selection Coins and Global Banking WAI missions and Roaming DZAI Bandits Customized map additions Skalisky Bridge Skalisky Island Bandit Camp with high loot (fun mission!) Garage Door Opener Virtual Garage Deploy bike Refuel, Repair, Rearm Take clothes Bury Body Butcher Body Locate vehicle with keys and GPS One plot poll per player Indestructible bases Trader Safe Zones Day/Night Schedule 4-hour restarts
    • By FG_Trap
      Made this in my free time awhile ago thought id make it public.
      Right Alt is the key to open the menu.
      Install instructions are inside the download.
      https://github.com/NWDZ-Trapxxgods/traps-menu
       
       
      here is a picture of the server menu
       
    • By lordacus
      so i have been making a server between trying to get my provider to update their mods section. after getting this don i found the server with epoch and infistar were conflicting each other such as: when joining i can use infistar but when i press f9 or i to enter my inventory or f10 for the mobile pad it then conflicts (i think) infistar and i can no longer use it. any ideas on how to stop this
       
    • By vbawol
      Open world survival mod set just two years after the mass extinction of billions of people. Those that remain are left with remnants of a once technological society. Try to survive, build, or explore your way through the harsh dynamic environment.
      Features
      Powerful persistence framework for Arma 3 with native Windows and Linux dedicated server support. Fully configurable script based security checks. Base Building re-envisioned for Arma 3 PhysX. Persistent secure and insecure storage devices. Upgradeable locking doors. Barter based economy and trading systems backed a single currency ¤ called "Krypto". Hostile Environment with several different types of antagonists, Air and Water temperature extremes, and Earthquakes. Hunting, Fishing, Tame Dogs, Explore & Loot: Wrecked ships, Abandoned vehicles and buildings, Perform task based missions and more! Open source APL-SA Epoch Survival MP gamemode. Open source APL-SA Modders resource configs and Class List. Assets can be used as a mod dependency on Steam workshop.
  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...