ServerSetup

From RPC Test Wiki
Revision as of 17:19, 2 May 2019 by Unnamed Mercenary (talk | contribs) (Minor adjustments)
Jump to: navigation, search

Server Setup

If you already have your own webserver with php support and a mysql 5.6 or 5.7 server, you can skip installing WAMP.

Installing WAMP

1. Download and install WAMP
2. Start the server by clicking on the WampServer64 icon created by the installer
3. Verify all services are properly started by checking on the W Icon in the notification bar:
  • Green: All services started properly
  • Yellow: Some services started properly
  • Red: All services have stopped

Note: Start/restart/stop the WAMP server by clicking on the W icon and selecting Start/Stop/Restart All Services

Setting Up the Database

Importing with HeidiSQL

1. Confirm all services are installed and started
2. Download, install, and run HeidiSQL
3. Select the New button to create a new connection and select Open Note: If the SQL server IP/username/password differ from the defaults, change them here, otherwise continue to the next step
Heidi WAMP 01 Login.png
4. Verify you are connected: A newly set up/blank mysql server should have the following databases listed:
Default tables
information_schema mysql performance_schema sys
5. Right Click Unnamed and go to Create newDatabase and name the new database: ffxiv_server Note: If you changed the name of the server in step 3, the name will be that instead of Unnamed
Heidi WAMP 02 Create DB.png
6. Click the new ffxiv_server database entry
7. Go to FileRun SQL File and navigate to the <Classic Server source code location>\sql\ folder
Heidi WAMP 03 Run SQL.png
8. Select all SQL files in the folder, and execute them. Note: HeidiSQL may warn you about mixed linebreaks, or an empty warning prompt after executing the query. Ignore them, it'll still run the query successfully.
Heidi WAMP 04 Select SQL file.png

Importing from command line

1. Open the <Classic Server source location>\sql\import.bat file for editing.
2. Adjust the following lines to your local environment or WAMP installation.
SET PATH_MYSQL="C:\path\to\mysql.exe"
SET PATH_MYSQLADMIN="C:\path\to\mysqladmin.exe"
SET PATH_SQL="<Classic Server source location>\sql"

SET USER=root
SET PASSWORD=
SET DBADDRESS=localhost
SET DBPORT=3306
SET DBNAME=ffxiv_server
The default mysql path for WAMP is C:\wamp64\bin\mysql
The default WAMP credentials are already in place, as there is no root password.

Setting Up the Login Server

1. Confirm all WAMP services are running
2. Navigate to the location of the server source code
3. Copy the contents of the <Classic Server source location>\www folder to the WAMP install location
The default location is: C:\wamp64\www
4. OPTIONAL: If you have modified the database login settings, change them at:
<web server www folder>\login_su\config.php
5. Restart the WAMP services

Setting up Lobby, World and Map Servers

  1. OPTIONAL: If the server and client are on different machines, edit the server IPs in the following locations <Classic Server source location>\data\(lobby/map/world)_config.ini <SQL database>\ffxiv_server\servers <SQL database>\ffxiv_server\server_zones *if the map servers are not on the same server as world server
  2. Copy lobby_config.ini from <Classic Server source location>/data/
    to <Classic Server source location>\FFXIVClassic Lobby Server\bin\(Debug\Release)\
  3. Copy map_config.ini, staticactors.bin and the scripts folder from <Classic Server source location>/data/
    to <Classic Server source location>\FFXIVClassic Map Server\bin\(Debug\Release)\
  4. Copy world_config.ini from <Classic Server source location>/data/
    to <Classic Server source location>\FFXIVClassic World Server\bin\(Debug\Release)\

Starting the servers

1. Confirm all WAMP/web services are running
2. Run the lobby server: <Classic Server source location>\FFXIVClassic Lobby Server\bin\(Debug\Release)\FFXIVClassic_Lobby_Server.exe
3. Run the map server: <Classic Server source location>\FFXIVClassic Map Server\bin\(Debug\Release)\FFXIVClassic Map Server.exe
4. Run the map server: <Classic Server source location>\FFXIVClassic World Server\bin\(Debug\Release)\FFXIVClassic World Server.exe