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 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.
    • By Achef
      Greetings!
      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 WeepiestLem0n
      So I've been wanting to create a private ArmA 2 DayZ Epoch server for a bunch of my mates to play on, however I dont have a dedicated machine and want to run it on my PC. So I looked at the server download files on the GitHub page and followed the ReadMe, however I absolutely cannot figure out how to get the MySQL server and DB set up. I have downloaded MySQL Server on my PC and created the admin role, root passwords and ran it as a windows service. I now have no clue how to create the database and am wondering if anyone can help me set this up or let me know if I've done anything wrong. 

      I can add on Steam or Discord if need be for convenience.
  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...