[How To] Setup A DayZ Epoch server (out of date) being revised!

[Guest]

After reading a couple of guides on setting up a DayZ Server for people to play on I have noticed that many tutorials have missing information or the user is left with different error messages to deal with or ignore.

 

The following tutorial is based on my knowledge, trial and error, debugging and contact with different users on the issue. I hope to provide the most detailed, and easy-to-follow tutorial on the web.

 

[Files Required]  

1. Steam. http://store.steampowered.com/about/
2. Arma 2 (Look at "Creating your server" section.)
3. Arma 2 : Operation Arrowhead (Look at "Creating your server" section.)
4. DayZ Commander, http://www.dayzcommander.com/
5. Visual C++ Redistributable Packages for Visual Studio 2013, http://www.microsoft.com/en-us/download/details.aspx?id=40784 (x86 is for 32 Bit.)
6. Visual C++ Redistributable Packages for Visual Studio 2010, http://www.microsoft.com/en-us/download/details.aspx?id=5555
7. WAMP / XAMPP, http://www.wampserver.com/en/ or https://www.apachefriends.org/download.html (XAMPP for this tutorial)
8. HeidySQL, http://www.heidisql.com/download.php (I recomend getting the installer)
9. uTorrent, http://www.utorrent.com/
10. DayZ Epoch Client Files, http://goo.gl/IN1Pt1 (Taken From http://epochmod.com/a2dayzepoch.php)
11. DayZ Epoch Server Files, http://goo.gl/3GyZ0P (Taken From http://epochmod.com/a2dayzepoch.php)
12. WinRar, http://www.rarlabs.com/download.htm
13. Notepad++, http://notepad-plus-plus.org/

(Optional) Download this package made by Rotzloch https://mega.co.nz/#!uc9E0SgK!pZxZflTVTSs2jgYuBM6tUmBsYksAC4DtUeitSgmRfTU

 

[Prerequisites]

1. A Computer with atleast 2GB Ram for a smooth experience for about 24 players. (4GB for around 60 players.)
2. Harddrive of atleast 25GB for the game files.
3. A Good connection (40Mbit Upload / Download)
4. Atleast a Two-Core CPU.

[Creating your server]

 

If you have any of the games installed previously, I would recommend deleting them to not face any problems in the future.

1. Install the C++ Redistributable Packages and restart your computer/box. (I recommend to install both x64 and x86 if you have a 64bit Operating system.
2. Create a folder, preferably on your Desktop called "Dayz Epoch Server".
3. Launch steam, login.
4. Download Arma 2.
5. Download Arma 2 : Operation Arrowhead.
6. Wait until they are complete.
7. Launch Arma 2 in windowed mode, wait until you are at the main menu, then close the game.
8. Do the same for Arma 2 : Operation Arrowhead.
9. Launch DayZ Commander.
10. Click "install/update" in the top right of the window.
11. Install the Arma 2 Beta Patch http://i.imgur.com/RwNq8ti.png
12. Wait until that is complete.
13. Now, go to your Steam Folder. Usually C:\Program Files (x86)\Steam\SteamApps\common\
14. Copy everything from inside your "Arma 2" Folder inside the "DayZ Epoch Server" folder we created on your desktop in Step 1.
15. Do the same for your "Arma 2 Operation Arrowhead" Folder EXCEPT any folders starting with an @.
16. Click "Yes" to any popups asking you to overwrite the files.
17. Take a deep breath. The easy part is now done.
18. Take the Epoch Client and Server files that you downloaded earlier and put them on your Desktop.
19. Open them up with WinRar http://i.imgur.com/g48k2s5.png
20. Copy "@DayZ_Epoch" from the Client files into "DayZ Epoch Server" on your Desktop.
21. Copy "@DayZ_Epoch_Server" from the Server files into "DayZ Epoch Server" on your Desktop.
22. Copy the "Keys" folder from the Server files into "DayZ Epoch Server".
23. Open the "Battleye" folder inside the Server files and copy everything inside into the "BattlEye" folder inside the "DayZ Epoch Server folder" on your Desktop. (Note the difference in Capitalization.)
24. Copy all the 4 ".dll" files from your Server files into the "Dayz Epoch Server" folder. http://i.imgur.com/vzYLZ4v.png
25. Open up "MPMissions" from your Server files and find the mission that you want. I will be using "DayZ_Epoch_11.Chernarus" for this tutorial.
26. Copy that to your "MPMissions" folder inside the "Dayz Epoch Server" folder that is on your Desktop.
27. Open "Config-Examples" from your Server files, then copy the matching instance number as your Mission to your "Dayz Epoch Server" folder. We will use "instance_11_Charnarus".
28. Copy "DayZ_Epoch_instance_11_Chernarus.bat" from that same folder into the "Dayz Epoch Server" on your Desktop.
29. Setup and install XAMPP, then make sure mysql and apache are started.
30. Click the "Admin" button next to MySQL in the XAMPP control panel.
31. Once the phpMyAdmin page is loaded, at the top, click "Users".
32. Under the Users overview, click Add user.
33. Enter "Epoch_User" as the User name. (without the "" ).
34. As the Host, select "Local" from the dropdown box.
35. Enter a password. I will use "password123" but please make sure to use something more secure.
36. Scroll down and click "Check All" from the Global privileges then remove ALL Administration privileges like GRANT and SUPER.
37. At the bottom, click Go on the right.
38. Now you have your user created. Click "Databases" at the top.
39. Under Create database, type in "Epoch_Database" as the Database name then click Create.
40. Now you have your database. You can go ahead and stop Apache from the XAMPP control panel, you dont need it enabled anymore.
41. Inside your Server files, open up the SQL folder and copy "epoch.sql" to your Desktop.
42. Open HeidySQL.
43. As the session name in the top left, we will have it just named as "DayZ Server SQL"
44. Hostname / IP should be "127.0.0.1".
45. User should be "Epoch_User"
46. Password is "password123" or whatever you specified in your user setup.
47. Click "Save" at the bottom left. then click Open.
48. On the left hand side, you should see "Epoch_Database" go ahead and double click it.
49. It should say "Database: Epoch_Database" at the middle tab on top.
50. Click the "Query" tab.
51. You should be presented with a text box, just drag your "epoch.sql" from your desktop into that textbox.
52. Click the blue Play button above the Query tab or press F9.
53. It should start executing the SQL into your database. You might get a "3 Warnings" popup at the end, ignore that.
54. Restart HeidySQL and double click your database on the left, you should see some tables created. http://i.imgur.com/xBknVUv.png
55. Close HeidySQL.
56. Take another deep breath. The hard part is now done, you are nearly finished with your server!
57. Go to your desktop and open your DayZ Epoch Server folder. It should look something like this. http://i.imgur.com/CHeOg9o.png
58. Open up your instance_11_Chernarus folder.
59. Open "config.cfg" with Notepad++.
60. Edit this file to your liking, and set a "passwordAdmin" value for you to be able to login as an admin from ingame.
61. Add requiredSecureId = 2; under BattlEye = 1; This is to prevent the UID spoofing.
62. At the bottom, change your difficulty="veteran"; to difficulty="regular";
63. Save and close.
64. Open up "HiveExt.ini" with Notepad++.
65. Scroll down to the [Database] section.
66. Make sure Host = 127.0.0.1
67. Same with Database = Epoch_Database
68. The same with Username = Epoch_User
69. And finally, Password = password123
70. Save and close.
71. Run DayZ_Epoch_instance_11_Chernarus.bat to start your server.

(Optional) Open up "cmd" from your start menu and type ipconfig to get your server's ip. Put that into DayZ Commander as a favorite so you can connect easily.

(Note) If your MySQL hosting is provided by your host, you can skip the MySQL setup part and not download XAMPP / Wamp and just use that info from your host.

(Linux Note) If you are running a linux machine, and running Wine to allow you to run windows applications, please put "msvcp120.dll" & "msvcr120.dll" into your "DayZ Epoch Server" folder. A simple google search should help you find those two files. <Credits to Flodding for reminding me about this.>

(NEW) Created an Auto-Restarter.

 

I hope that my tutorial has covered any questions you may have, and good luck with all your servers!

[Strictly Zeus]

Anytime I try to connect I get this error

http://steamcommunity.com/id/strictlyzeus/screenshot/269471959157404833

[TheHansMan]

Awesome stuff. Just a reminder for the new guys. Ive done exactly as stated however running the .bat file halted. Just make sure that the directory in the batch file is of the same location that your server files are in. You can edit it inside the .bat file. Its in the first line you see. So very easy to spot. Ive had a few issues with it connecting to db as well just make sure your name prefixes and passwords are in line. Else you will wait at the "waiting for host" screen for ages. 

 

Once again thanks for the awesome post.

[wozzsta]

Hi guys i am getting this error when i join my server and it crashes, any ideas?

 

[juandayz]

2 hours ago, wozzsta said:

Hi guys i am getting this error when i join my server and it crashes, any ideas?

 

you put the name and pass in hiveExt ?

;Database name to connect to.
Database = your db name

;Username to connect with
Username = your mysql username
;Password to authenticate with (default is blank)
Password = your  user pass

 

[Cubitron]

Hello all 

after install i get this Error

Spoiler

=====================================================================
== C:\Users\cubi\Desktop\Arma2\ARMA2OASERVER.exe
== arma2oaserver.exe  -port=2302 "-config=instance_11_Chernarus\config.cfg" "-cfg=instance_11_Chernarus\basic.cfg" "-profiles=instance_11_Chernarus" -name=instance_11_Chernarus "-mod=@DayZ_Epoch;@DayZ_Epoch_Server;"
=====================================================================
Exe timestamp: 2016/09/29 18:11:16
Current time:  2016/10/02 09:46:24

Version 1.63.131129
Unsupported language German in stringtable
Item STR_EQUIP_NAME_41 listed twice
Item STR_EQUIP_DESC_41 listed twice
Updating base class ->NonStrategic, by ca\config.bin/CfgVehicles/HouseBase/
Updating base class ->HouseBase, by ca\config.bin/CfgVehicles/Ruins/
Updating base class ->DestructionEffects, by ca\config.bin/CfgVehicles/House/DestructionEffects/
Updating base class ->FlagCarrierCore, by ca\ca_pmc\config.bin/CfgVehicles/FlagCarrier/
Updating base class ->VehicleMagazine, by ca\weapons\config.bin/CfgMagazines/14Rnd_FFAR/
Updating base class ->PistolCore, by ca\weapons\config.bin/cfgWeapons/Pistol/
Updating base class ->LauncherCore, by ca\weapons\config.bin/cfgWeapons/RocketPods/
Updating base class ->RocketPods, by ca\weapons\config.bin/cfgWeapons/FFARLauncher/
Updating base class ->Default, by ca\weapons\config.bin/cfgWeapons/ItemCore/
Updating base class ->Citizen, by ca\characters2\config.bin/CfgVehicles/Citizen1/
Updating base class ->SkodaBase, by ca\wheeled\config.bin/CfgVehicles/car_sedan/
Updating base class ->UH60_Base, by ca\air\config.bin/CfgVehicles/MH60S/
Updating base class ->House, by ca\misc3\config.bin/CfgVehicles/Land_Fire/
Updating base class ->House, by ca\misc3\config.bin/CfgVehicles/Land_A_tent/
Updating base class ->Camp_base, by ca\misc3\config.bin/CfgVehicles/ACamp/
Updating base class ->Car, by ca\wheeled2\lada\config.bin/CfgVehicles/Lada_base/
Updating base class StreetLamp_EP1->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_Lamp_Small_EP1/
Updating base class StreetLamp_EP1->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_Lamp_Street1_EP1/
Updating base class StreetLamp_EP1->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_Lamp_Street2_EP1/
Updating base class StreetLamp_EP1->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_Lampa_Ind_EP1/
Updating base class StreetLamp_EP1->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_PowLines_Conc2L_EP1/
Updating base class StreetLamp_BaseMediumOrange->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_lampa_sidl/
Updating base class StreetLamp_BaseMediumOrange->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_lampa_sidl_2/
Updating base class StreetLamp_BaseMediumOrange->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_lampa_sidl_3/
Updating base class StreetLamp_BaseWeakYellow->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_lampa_ind/
Updating base class StreetLamp_BaseWeakYellow->StreetLamp, by z\addons\dayz_code\config.bin/CfgNonAIVehicles/Land_lampa_ind_zebr/
Updating base class RscStandardDisplay->, by z\addons\dayz_code\config.bin/RscDisplayStart/
Updating base class RscShortcutButton->RscShortcutButtonMain, by z\addons\dayz_code\config.bin/RscDisplayMain/controls/CA_Exit/
Updating base class RscText->, by z\addons\dayz_code\config.bin/RscTitles/Default/
Updating base class zZombie_Base->zZombie_new_Base, by z\addons\dayz_code\config.bin/CfgVehicles/z_villager1/
Updating base class zZombie_Base->zZombie_new_Base, by z\addons\dayz_code\config.bin/CfgVehicles/z_worker1/
Updating base class Soldier_Crew_PMC->Soldier_Bodyguard_M4_PMC, by z\addons\dayz_code\config.bin/CfgVehicles/SurvivorW2_DZ/
Updating base class HighCommand->Logic, by z\addons\dayz_code\config.bin/CfgVehicles/HighCommandSubordinate/
Updating base class ->ViewOptics, by z\addons\dayz_code\config.bin/CfgVehicles/Mi17_base/Turrets/MainTurret/ViewOptics/
Updating base class HouseBase->, by z\addons\dayz_code\config.bin/CfgVehicles/House/
Updating base class NonStrategic->BuiltItems, by z\addons\dayz_code\config.bin/CfgVehicles/Fort_RazorWire/
Updating base class MeleeHatchet->MeleeWeapon, by z\addons\dayz_code\config.bin/CfgWeapons/MeleeCrowbar/
Updating base class VehicleMagazine->CA_Magazine, by z\addons\dayz_code\config.bin/CfgMagazines/29Rnd_30mm_AGS30/
Updating base class VehicleMagazine->CA_Magazine, by z\addons\dayz_code\config.bin/CfgMagazines/48Rnd_40mm_MK19/
Updating base class 4000Rnd_762x51_M134->CA_Magazine, by z\addons\dayz_code\config.bin/CfgMagazines/2000Rnd_762x51_M134/
Updating base class VehicleMagazine->CA_Magazine, by z\addons\dayz_code\config.bin/CfgMagazines/100Rnd_127x99_M2/
Updating base class VehicleMagazine->CA_Magazine, by z\addons\dayz_code\config.bin/CfgMagazines/50Rnd_127x107_DSHKM/
Updating base class Hatchet_Swing->Melee_Swing, by z\addons\dayz_code\config.bin/CfgMagazines/crowbar_swing/
Updating base class CA_Magazine->Melee_Swing, by z\addons\dayz_code\config.bin/CfgMagazines/Hatchet_Swing/
Updating base class Land_HouseV_1I2->House, by zero_buildings\config.cpp/CfgVehicles/Land_HouseV_1L2/
Updating base class Land_HouseV_1I2->House, by zero_buildings\config.cpp/CfgVehicles/Land_HouseV_3I3/
Updating base class ->Plane, by ca\air2\mv22\config.bin/CfgVehicles/MV22/
Updating base class ViewOptics->, by ca\air2\uh1y\config.bin/CfgVehicles/UH1_Base/Turrets/MainTurret/ViewOptics/
Updating base class ->HouseBase, by ca\misc_e\config.bin/CfgVehicles/House/
Updating base class ->Land_CamoNet_EAST, by ca\misc_e\config.bin/CfgVehicles/Land_CamoNet_EAST_EP1/
Updating base class ->Land_CamoNetB_EAST, by ca\misc_e\config.bin/CfgVehicles/Land_CamoNetB_EAST_EP1/
Updating base class ->Sign_1L_Noentry, by ca\misc_e\config.bin/CfgVehicles/Sign_1L_Noentry_EP1/
Updating base class ->Sign_circle, by ca\misc_e\config.bin/CfgVehicles/Helper_Base_EP1/
Updating base class ->Rifle, by ca\weapons_baf\config.bin/cfgWeapons/BAF_AS50_scoped/
Updating base class ->Rifle, by ca\weapons_e\config.bin/cfgWeapons/M60A4_EP1/
Updating base class ->M249, by ca\weapons_e\config.bin/cfgWeapons/M249_EP1/
Updating base class ->M249, by ca\weapons_e\config.bin/cfgWeapons/M249_m145_EP1/
Updating base class ->m107, by ca\weapons_e\m107\config.bin/CfgWeapons/m107_TWS_EP1/
Updating base class ->M240, by ca\weapons_e\m240\config.bin/CfgWeapons/m240_scoped_EP1/
Updating base class ->V3S_Base, by ca\wheeled_e\v3s\config.bin/CfgVehicles/V3S_Base_EP1/
Updating base class ->V3S_Base_EP1, by ca\wheeled_e\v3s\config.bin/CfgVehicles/V3S_Refuel_TK_GUE_EP1/
Updating base class House->DZE_OpenHouse, by warehouse\config.bin/CfgVehicles/Land_Ind_Pec_03/
Updating base class ->C130J_base, by ca\air_e\config.bin/CfgVehicles/C130J_US_EP1/
Updating base class ->Helicopter, by ca\air_e\ah6j\config.bin/CfgVehicles/AH6_Base_EP1/
Updating base class ->Plane, by ca\air_e\an2\config.bin/CfgVehicles/An2_Base_EP1/
Updating base class ->CH47_base_EP1, by ca\air_e\ch47\config.bin/CfgVehicles/CH_47F_EP1/
Updating base class ViewOptics->, by ca\air_e\uh1h\config.bin/CfgVehicles/UH1H_base/Turrets/MainTurret/ViewOptics/
Updating base class ->Soldier_Base_PMC, by ca\characters_pmc\config.bin/cfgVehicles/Soldier_Crew_PMC/
Updating base class ->Soldier_Base_PMC, by ca\characters_pmc\config.bin/cfgVehicles/Soldier_TL_PMC/
Updating base class ->Soldier_Base_PMC, by ca\characters_pmc\config.bin/cfgVehicles/Soldier_Bodyguard_M4_PMC/
Updating base class ->Soldier_Base_PMC, by ca\characters_pmc\config.bin/cfgVehicles/Soldier_Bodyguard_AA12_PMC/
Updating base class ->BAF_Soldier_MTP, by ca\characters_w_baf\config.bin/CfgVehicles/BAF_Soldier_W/
Updating base class ->BAF_Soldier_L_MTP, by ca\characters_w_baf\config.bin/CfgVehicles/BAF_Soldier_L_W/
Updating base class ->BAF_Soldier_Officer_MTP, by ca\characters_w_baf\config.bin/CfgVehicles/BAF_Soldier_Officer_W/
Updating base class ->BAF_Soldier_SniperH_MTP, by ca\characters_w_baf\config.bin/CfgVehicles/BAF_Soldier_SniperH_W/
Updating base class ->M113Ambul_Base, by ca\tracked_e\m113\config.bin/CfgVehicles/M113Ambul_UN_EP1/
Updating base class ->M113_Base, by ca\tracked_e\m113\config.bin/CfgVehicles/M113_UN_EP1/
Updating base class ->M113Ambul_Base, by ca\tracked_e\m113\config.bin/CfgVehicles/M113Ambul_TK_EP1/
Updating base class ->M113_Base, by ca\tracked_e\m113\config.bin/CfgVehicles/M113_TK_EP1/
Updating base class ->Helicopter, by ca\air_d_baf\config.bin/CfgVehicles/BAF_Merlin_HC3_D/
Updating base class ReammoBox->Small_items, by corepatch\corepatch_additionalobjects\config.cpp/CfgVehicles/CardboardBox/
Updating base class CA_Magazine->4000Rnd_762x51_M134, by corepatch\corepatch_ccp_71142_cit_13602_25047\config.cpp/CfgMagazines/2000Rnd_762x51_M134/
 9:46:29 Initializing Steam server - Game Port: 2302, Steam Query Port: 2303
 9:46:30 Connected to Steam servers
ErrorMessage: Include file z\addons\dayz_code\gui\description.hpp not found.
 

 

[Lunastone]

I am trying to create a Taviana Epoch server however i keep getting this error message;

23:34:47 HiveExt(0): [Information] Method: 302 Params: 13:false:
23:34:47 Database(0): [Error] Error 1146 (Table 'mysql.object_data' doesn't exist) in MySQLQuery SQL: 'SELECT COUNT(*) FROM Object_DATA WHERE `Instance` = 13 AND `ObjectID` <> 0 AND `ObjectID` <> (`ObjectUID` - 1)'
23:34:47 Database(0): [Error] Error 1146 (Table 'mysql.object_data' doesn't exist) in MySQLQuery SQL: 'SELECT COUNT(*) FROM `Object_DATA` WHERE `Instance` = 13 AND `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 6 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]')  OR (`Classname` IN ( 'Land_DZE_GarageWoodDoorLocked','Land_DZE_LargeWoodDoorLocked','Land_DZE_WoodDoorLocked','CinderWallDoorLocked_DZ','CinderWallDoorSmallLocked_DZ','Plastic_Pole_EP1_DZ') ))'
23:34:47 Database(0): [Error] Error 1146 (Table 'mysql.object_data' doesn't exist) in MySQLQuery SQL: 'SELECT `ObjectID`, `Classname`, `CharacterID`, `Worldspace`, `Inventory`, `Hitpoints`, `Fuel`, `Damage`, `StorageCoins` FROM `Object_DATA` WHERE `Instance`=13 AND `Classname` IS NOT NULL AND `Damage` < 1'
23:34:47 HiveExt(0): [Error] Failed to fetch objects from database

My init.sqf has been changed to " dayZ_instance = 13; " but i cant get it to work, could someone point me in the right direction? 

 

[coresync]

have you added the epoch.sql on your Database?

[Lunastone]

39 minutes ago, coresync said:

have you added the epoch.sql on your Database?

Yes, the one included in the server files (https://www.dropbox.com/s/uuqf7ij19k622rm/epoch.sql?dl=0)

 

init.sqf (https://www.dropbox.com/s/7nafky508sw12rj/init.sqf?dl=0)

HiveExt.ini (https://www.dropbox.com/s/ylugfc57h18vcnj/HiveExt.ini?dl=0)

.bat file;

@echo off
start "arma2" /min arma2oaserver.exe -port=2315 "-config=instance_13_Tavi\config.cfg" "-cfg=instance_13_Tavi\basic.cfg" "-profiles=instance_13_Tavi" -name=instance_13_Tavi "-mod=@Taviana;@DayZ_Epoch;@DayZ_Epoch_Server;"
 

[coresync]

1 hour ago, Lunastone said:

Yes, the one included in the server files (https://www.dropbox.com/s/uuqf7ij19k622rm/epoch.sql?dl=0)

 

init.sqf (https://www.dropbox.com/s/7nafky508sw12rj/init.sqf?dl=0)

HiveExt.ini (https://www.dropbox.com/s/ylugfc57h18vcnj/HiveExt.ini?dl=0)

.bat file;

@echo off
start "arma2" /min arma2oaserver.exe -port=2315 "-config=instance_13_Tavi\config.cfg" "-cfg=instance_13_Tavi\basic.cfg" "-profiles=instance_13_Tavi" -name=instance_13_Tavi "-mod=@Taviana;@DayZ_Epoch;@DayZ_Epoch_Server;"
 

Have you set your Database Username/passwort/DBNAME etc? in hiveext.ini?

[Database]
;Hostname or IP of the server to connect to
;If you leave this line commented or blank, HiveExt will connect to the OFFICIAL Hive, which requires registration
;See support.dayzmod.com for more information on what OFFICIAL Hive means, what are the rules, etc.
;If using OFFICIAL hive, the rest of the settings in this section have no effect
Host = 127.0.0.1

;Currently, only MySQL is supported
Type = MySQL

;Port to connect to. The default is the default listening port of a server of the selected Type
;Instead of specifying Port, you can specify Socket and set Value to the socket name
Port = 3306

;Database name to connect to.
Database = MySQL

;Username to connect with
Username = USER
;Password to authenticate with (default is blank)
Password = PASS

 

[Lunastone]

Yes, I only changed the USER and PASS for this forum. The server is connecting to the database.

[coresync]

I think you have not loaded the correct SQL file into the database

[Lunastone]

That Could be the problem but i cannot find the correct. Sql file to load.

[lwbuk]

Have you changed this to whatever you called your database?

;Database name to connect to.
Database = MySQL

 

This error

Error 1146 (Table 'mysql.object_data' doesn't exist)

Looks like you have some events or queries set up and its looking for a database called MySQL, which doesn't exist.

[Lunastone]

Yes, I have named the database MySQL. And i think it can find most tables but not the object_data.

[lwbuk]

Are your tables written as object_data, or object_DATA or some other variation?

[Lunastone]

25 minutes ago, lwbuk said:

Are your tables written as object_data, or object_DATA or some other variation?

The table is named "object_data" no caps, i have changed this in the HiveEXT.ini but i am getting the same error message.

;Table = object_data

 

[Lunastone]

The server is up and running, apparently there were two MySQL servers running and it was connecting to the wrong one. Thank you all for the information!

[juandayz]

"Guest".... the main post still works on 1.6 ... you only need change the step 5.. visual c++ must be 2015.  and step 10 and 11.. must be the 1.6 server and client file.  the rest is the same.