[SOLVED] DATABASE NOT LOADING-DEDICATED BOX

[Thug]

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

[juandayz]

this guy seems have same error

 

[lwbuk]

The port in the hiveext.ini you posted is 3306 

but you are using 2365 elsewhere. 

[Thug]

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 

[lwbuk]

Have you port forwarded 3306 as well though? 

[Thug]

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

[icomrade]

You need to 2010 and 2012 redistributable. The server pack readme states you need ALL versions on this page https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads

[juandayz]

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. 

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