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 [email protected]
      Im setting up a new epoch 1.0.6 server with very little addons/mods installed, and when i was testing i realized safes/plotpoles/walls etc werent saving to the server database. Anyone got any ideas what might be wrong?
    • By EditedSnowHD
      Hallo all,
      First I want to say i'm not the owner of this server. I just really like the server! Why?
      Well it reminds me of the good old days, and it has an 'OG Epoch feeling'. This is because the map isn't edited and the loot is really balanced. 
      You can't just join, get 25000 coins and start shooting with a tank. It's not like those servers. Ow and another thing, if you open up a map, you won't see like 300 activities all going on at once, not turbid at all. 
      The server also uses the original silver/gold system and everything you find/build/shoot feels really rewarding. 
      The addons added to the server really add something special to the experience on the server, and not distract you from the original feeling.
      I have just played for a few days on the server, and there a few standard players (and the owner is really kind!). But we're still looking to share this amazing experience with other people who might be searching for the 'OG Epoch feeling'.
      Already sold? Here is the Server IP: 78.143.13.42 port: 2302 , Server name: [EU][PvP] GGWEZ DayZ Epoch Chernarus - FreshDB | HC | Gemcrafting
      Link to loading screen and rules: https://imgur.com/a/kIsfXaX

      Features:
      Deploy Bike (old bike).
      Gem Crafting (static Weapons, decorations and more).
      AI Base.
      Custom Vehicles.
      Missions.
      Indestructible bases.
      Take Clothes.
      Spawn Selection.
      Custom Economy and Loot (Really well balanced IMO).
      Lift object with heli.
      Custom Trader City (Really cozy).
      Refuel at gasstation.
      Dogs.
      Street, -Buildinglights (for at night).
      and much more!
      Mods:
      @Epoch
      There also is a Discord channel where you can meet up and share info (like about the AI base or player builds).
      Discord: discord.gg/M6w2fun
      Staff: Drashyy & Mfkrp9 & EditedSnow
      If you have any more questions, feel free to contact me! Hope to see you in Chernarus.
      Edit 10-05-2020: I'm now part of the staff! Im a moderator on their discord.

       
       
    • By THAC0_Gewch
      https://github.com/OlofTheBald/DayZ-Humanity-Loadout-Granter/tree/Epoch_1.0.5.1
       
      Updated for 1.0.6.x
    • By MysteryGamersElite
      [EU/UK] SDF Epoch|Wiped April 1st|FPS++|WAI & DZMS|SSD|Coins|Hourly Paycheck|Custom Loot| AND MORE....
      BRAND NEW DATABASE + SERVER 1st APRIL 2020!
      Server IP: 164.132.67.27:2302
      Discord: https://discord.gg/BWJCjTe
      We offer 24 hour support via discord for any questions or issues with your game!
      Top Server Feature List:
      - Modded DZMS and WAI Mission System
      - Custom High Loot Tables and Improved Dynamic Vehicle Spawns
      - Paycheck Every Hour
      - Coin Based Currency with Storage Banking only
      - Deploy Bike & Mozzie
      - Locate Vehicle
      - Snap Build Pro
      - Group Management
      - Repair, Refuel and Rearm at Service Stations
      - Vehicle Key Changer
      - infiSTAR AntiHack
      - Virtual Garage
      - Change View Distance with Binoculars
      - 3 Hour Restarts starting from Midnight GMT
      - Garage Door Opener
      - Take Clothes
      - Indestructible Bases except doors
  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...