Private Dayz with NFO VDS - Help needed

[axRhino]

I am to this point in my attempt to setup a private DayZ server for our community.

I've worked through the following:

1. I installed Arma2 CO via steam (the the unmanged VDS) and combined the two directories in a directory named DayZ Private Server (located in the Programs x86 directory)

2. Setup a SQL database via webhosting from NFO (same host city as the VDS)

3. Installed the following on the VDS as per the DayZ - Private - Master readme file:
- Microsoft Visual C++ 2010 SP1 x86 Redistributable (http://www.microsoft.com/en-us/download ... px?id=8328)
- Microsoft .NET Framework 4 or higher
- MySQL Server 5.x with TCP/IP Networking enabled **NOTE:** You **must** use the official MySQL installer, not XAMPP (http://dev.mysql.com/downloads/mysql/)
- The decimal separator on your server MUST BE a period. (https://github.com/thevisad/DayZ-Privat ... -Separator)
- Strawberry Perl 32 Bit (NOT 64 Bit)>= 5.16 (http://strawberryperl.com/) (64 bit does not have all the dependencies properly setup)
- DayZ 1.7.6.1 client (http://cdn.armafiles.info/latest/1.7.6/)

4. Ran RealityCP from the desktop and entered the mysql databse info.
-IP: something.site.nfoservers.com (do I need the IP?)
-Port 3306
-Usename thatsasecret
-Password thatsasecret2
-Database dayzdatabase_chernarus (Do I need the databse name?)

5. Then I get the "BUILD" button which has me select:
-World Chernaus (Ultimately we want to host Taviana)
Instance (??? help!!! No idea here...)
Packages (what are " disable server zombies and ssZedsMessaging?")

Something is wrong at this point. Maybe the database settings??
I'm also wondering if RealityCP is trying to install this in the Private DayZ Server directory or not.

[.=QUACK=.Major.Pain]

You have to setup your database with the CP.
Install initial Reality db.

Your instance can be any number, but may as well start at 1.
The zzeds things is if you want zeds to spawn via server or client.
Not sure which is which.

In your database you have to insert your instance and world id.
Taviana is 10 I think.

[ax-Undertow]

Hi quack. We were able to setup the Reality CP, or should I say we got the "build icon comlete successfull". We had to run the setup_perl first. However, when we log into the PHP mysql on NFO, there is 2 options, information schema, and our dayz database, but it seems we are missing alot of tables and data.

We really need a step by step installation guide on how to get this server setup/running, as there are bits and pieces of information, and some detailed instructions, but some steps are very generalized, and are missing key info.

Any help would be greatly appreciated.

Thanks

[.=QUACK=.Major.Pain]

I will try to make a complete list of instructions in the next day or so when I can fit it in, but I can help you out step by step. Note though that because I can't actually see your files, we may get confused about what your seeing and what I think your referring to.

I never really like using the control panel, but prefer using .bat files.

If you ran setup of database from the control panel, you will get all the basic tables required.
If you want, you can create a .bat file with the following:

Code: Select all

perl db_migrate.pl --host dbip --user dbuser --pass dbpassword --name dbname --port=3306
pause

This should tell you what your current db version is and if out of date, it should update it.

If your building with --with-messages --with-buildings, etc
Your have to install the db tables using the control panel or a .bat

[axRhino]

If it helps the process along here is a look at out database as it sits now. It looks like we are lacking map specific data for Chernarus and of course Taviana (or any map for that matter)

The only two database we have are information schema and one named axdayz.

[.=QUACK=.Major.Pain]

That isn't a Reality based database.
Tables in there look like they might be from another project.

Here's a screenshot of a test db I just installed:



The tables starting with v_ might not appear for you, but that is ok.
Generally they are there but hidden depending on what program you use to view your db.

[.=QUACK=.Major.Pain]

I would suggest starting your database over.
Delete the database and recreate it so you have a blank db.

Here's the steps to continue:

1) Open Reality control panel and insert your db details. (If it doesn't ask because you did it before, then hit "Setup DB" and then "MySQL Details")
2) Save everything and the control panel will close. Now restart the control panel and it's now ready for your db.
3) Go to "Setup DB" and then "Database".
4) Just us the 1st line and select in the drop down menu "Reality Main (req.)" and select "Go" to the right of it. It will now install the basic db tables.
5) Once done, close the cmd box.
6) If your going to using things like "Buildings", "Messaging", or "Custom Inv", then you have to select each one in the same dropdown box and install each one to install the tables for those addons.

That should be everything you need to create your db.

Here's is a very handy desktop tool called Navicat Lite that can be used to connect to your database and is much easier to use for editing your database.
http://www.computerbild.de/download/Nav ... 98757.html
NOTE: You will probably have to add your home ip to your Remote MySQL to provide access to connect to your database.

Once the database is created, you now have to add your world/map to the instance table. If you look at the world table, it will list all the worlds, and your looking for the "id" number to the left of the world your trying to create. Remember that number, and now go to the "instance" table.

By default it provides id=1 and world=1.

1a) If this is your first server and instance, your can edit instance 1 and change the world id to the number you got from the world table for your map.
eg: Change (id=1 world_id=1) to (id=1 world_id=10) for Taviana

1b) If this is not your first server and instance on this db, add a new line and insert the instance number 1 higher than your highest number and add the world id that you want to use.
eg: If your highest instance id used is 6, then create a new line with (id=7 world_id=2) for Lingor.

That's pretty much the basics. If your using addons, some edits may be needed in the db, but you have the basics to get your server going.

[ax-Undertow]

I think the issue resolves with the setup_perl.cmd. I attached a screenshot, but not sure if we should run that batch file, and if we do, if we should just use the default locations to install.

Thanks for your help

[.=QUACK=.Major.Pain]

Yes - install everything to the default locations.

Also, in your screenshot, it shows a few things not installed and mentions running something else.
You should run what it says to be sure everything gets installed.

Something about running something to install missing things. Hard to read the image.

I ran the setup_perl.bat on one of my servers that I already have things installed on, and found I was apparently missing 3 modules. So I updated everything and good here.

When you run setup_perl.bat, once you have everything installed correctly, it should run completely through and close by itself with no notes or errors.

Then everything with perl should be good.

[ax-Undertow]

Would you be willing to remote desktop into our server, and take a quick look at our setup? I have a feeling the tables are not importing correctly, and we are probably missing a step. Much appreciated.

[.=QUACK=.Major.Pain]

Sure - but not till tomorrow night.

There's no PM messaging here and don't want to post my email, so if you want you can PM me on our forum at http://www.aaquacks.com/forum/ and I can take a quick look.

[ax-Undertow]

I created an account and sent you a PM with my email. Thanks bro!

[.=QUACK=.Major.Pain]

Question for staff:

I am trying to help him setup his database, but it appears to be failing.
Do we need to setup remote mysql for connection from VDS to web hosting?

[Edge100x]

I do not recommend using the shared webhosting as a remote database, but he can try it. If he does this, he may need to enable external connections if he uses a custom reverse DNS; anything from "%.nfoservers.com" is already allowed.

[.=QUACK=.Major.Pain]

It appears to connect to the database, and it seems to read from it, but it fails to create the new tables.

Code: Select all

INFO: Trying to connect to dayzdatabase.site.nfoservers.com, database dayz_db as dayz_user
INFO: Did not find an existing schema for Reality
INFO: Attempting migration to 0.39
FATAL: Database migration failed!
Press any key to continue . . .