Volume 2 Server Setup

From OuroDev

Required Software

  • Ouroboros Volume 2 Binaries. For this guide, we will assume that you are installing them into C:\Ouroboros. You can either:
    • Download a released version of Volume 2 (not yet available)
    • Follow Volume 2 Build to compile it from source, then copy the contents of the bin directory to c:\Ouroboros
  • Database schema definitions. For now, get them from https://git.ourodev.com/CoX/Source/src/tag/v2-i1.0.0/Assets/DBSchemas
  • SQL Server 2012 or later (Express is good enough for development)

Install SQL Server 2017 Express

You can install SQL Server pretty much on the default settings.
Select Basic under installation type:
Agree to the EULA if you want to use SQL Server.
Tell the server where to install files. I changed this for ease on my system.
It should begin installing and eventually you should see "Install has completed successfully". Click close.

Install SQL Server Management(SSMS)

You can install SQL Server Management on default settings.
Select the location you'd like to install SSMS to. The default is fine.
It will take awhile to install and you'll see a little progress bar letting you know whats going on
Eventually it will ask you to reboot the system. Might as well as do that now.

Setup Server Files

Create a directory in C:\Ouroboros called data.
Open ServerData.7z and extract all files into C:\Ouroboros\data (the newly created directory).
Open CoHDev_Source_Files_Current(Updated).zip.
Extract "i24 Server and Client Piggs (extracted with CoHTools)" into C:\Ouroboros\data.
Copy maps.db from "map.db (modified, working on current VS2010 build)" and place it in C:\Ouroboros\data\server\db, overwriting the old maps.db
Copy the piggs folder from your i24 client directory and place them in C:\Ouroboros\. You should end up with C:\Ouroboros\piggs\ populated.
Create a directory in your C: drive called "CoH_Data" and another directory inside that, called "attributes" (C:\CoH_Data\attributes).
Run this in a command prompt:
cd Source\bin
.\mapserver.exe -productionmode -templates
Copy all files from C:\CoH_Data\attributes and place them into C:\Ouroboros\data\server\db\templates.
Open C:\Ouroboros\DBSchemas and execute all the .sql files in the directory. You may need to change the file path -- anywhere works. Drop old database references before if there are any.

Database setup

  1. You will need to choose a password for the database user. In these examples it will be "YOURL33TPASS!".
  2. Launch SQL Server Management Studio from the start menu
  3. Hit "Connect" on the screen that pops up, with default settings:
  4. We need to enable the sa login so that server can login to the database.
    1. If you look to the left panel you will see the object explorer and your connection. Right click it and select properties.
    2. When this window comes up hit Security to the left and enable "sql server and windows authentication". Then click ok.
    3. In the same panel you used before navigate to Security -> Logins then right click and enter properties the sa user.
    4. In this window set the password to the same password you set back at step 4
    5. Choose Status from the left panel in this same window and set login to enabled and hit ok.
    6. Right click the connection in the object explorer again and click Restart.
  5. Next we need to apply the schema for the databases which require this to be done manually (account, auction, auth, and chat)
    1. Click File -> Open -> File, navigate to the dbschemas that you downloaded at the start, and select cohauc.sql
    2. You will see a create database statement near the top of the file, with two lines that include a filename parameter.
    3. Set these to the directory where you want to create the database files. For this example, I have created a directory C:\OuroborsDb and put the database there: 
      ( NAME = N'cohauc', FILENAME = N'C:\OuroborosDb\cohauc.mdf' , SIZE = 157440KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

      ( NAME = N'cohauc_log', FILENAME = N'C:\OuroborosDb\cohauc_log.ldf' , SIZE = 353216KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
    4. Click the Execute button
    5. Repeat these steps for cohacc.sql, cohauth.sql and cohchat.sql. Do not use cohdb.sql

Server database connection configuration

Navigate to C:\Ouroboros\data\server\db. In each of the following files, look for an SqlLogin line, and change the Pwd= value to your password. Using our example YOURL33TPASS!: 

SqlLogin "DRIVER={SQL Server Native Client 11.0};Server=localhost\SQLEXPRESS;Uid=sa;Pwd=YOURL33TPASS!;"
  • account_server.cfg
  • auction_server.cfg
  • chat_server.cfg
  • servers.cfg

In servers.cfg, also fix SqlInit to be: 

SqlInit "create database cohdb;"

For authserver, we have to configure the connection via ODBC data sources.

  1. Launch "ODBC Data Sources (32-bit)" from the start menu, or run directly from C:\Windows\SysWOW64\odbcad32.exe. (Do not use the 64-bit version)
  2. Click File DSN then click add to the right.
  3. Choose ODBC Driver 17 for SQL Server.
  4. Click Next.
  5. Enter AuthDB into the box
  6. Click Next, then Finish.
  7. One of the boxes on the next page will say "Which SQL Server do you want to connect to?". Type localhost\SQLEXPRESS
  8. Click Next
  9. Choose "With SQL Server authentication using a login ID and password entered by the user". Enter "sa" for the username, and the password that you chose:
  10. Click Next
  11. Enable "Change the default database to" and select "cohauth".
  12. Click Next
  13. Default settings are fine on the last page
  14. Click Finish
  15. A box will appear with the settings you have selected. Click "Test Data Source"
  16. You should see "TESTS COMPLETED SUCCESSFULLY!" in the output. If not, go back and check your settings.
  17. Click OK, then OK again.

Launch Server

Start DBServer.exe and then Launcher.exe. This can be done simply by double clicking on them.
You could also use a .bat file to start everything up and in the correct order.
The below is an example bat file to launch the DBServer, Launcher, and finally the Client.
 
@echo off
echo Starting DB Server
START c:\Ouroboros\dbserver.exe
TIMEOUT 2
echo Starting Launcher Server
START c:\Ouroboros\launcher.exe
TIMEOUT 2
echo Starting Chat Server
START c:\Ouroboros\ChatServer.exe -noreserved
TIMEOUT 2
echo Everything should be launched! Go enjoy CoH.
Retrieved from "https://wiki.ourodev.com/index.php?title=Volume_2_Server_Setup&oldid=1207"