Difference between revisions of "ServerSetup"

From RPC Test Wiki
Jump to: navigation, search
(Created page with "== Server Setup == === Setting up with WAMP === ==== Installing WAMP ==== : 1. Download and install WAMP : 2. Start the server by clicking on the '''WampServer64''' icon c...")
 
(Minor adjustments)
Line 1: Line 1:
 
== Server Setup ==
 
== Server Setup ==
  
=== Setting up with WAMP ===
+
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 ===
 
 
==== Installing WAMP ====
 
 
: 1. Download and install WAMP
 
: 1. Download and install WAMP
 
: 2. Start the server by clicking on the '''WampServer64''' icon created by the installer
 
: 2. Start the server by clicking on the '''WampServer64''' icon created by the installer
Line 14: Line 12:
 
'''Note:''' Start/restart/stop the WAMP server by clicking on the '''W''' icon and selecting Start/Stop/Restart All Services
 
'''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 ====
==== Setting Up the Database ====
+
: 1. Confirm all services are installed and started
: 1. Confirm all WAMP services are installed
 
 
: 2. Download, install, and run HeidiSQL
 
: 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   
 
: 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   
Line 37: Line 35:
 
: 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.
 
: 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.
 
: [[File:Heidi_WAMP_04_Select_SQL_file.png]]
 
: [[File: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.
 +
<pre>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</pre>
 +
:: 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 ====
 
==== Setting Up the Login Server ====
Line 55: Line 68:
 
# Copy '''world_config.ini''' from '''<Classic Server source location>/data/'''
 
# Copy '''world_config.ini''' from '''<Classic Server source location>/data/'''
 
#: to '''<Classic Server source location>\FFXIVClassic World Server\bin\(Debug\Release)\'''
 
#: to '''<Classic Server source location>\FFXIVClassic World Server\bin\(Debug\Release)\'''
 
=== Installing Manually ===
 
<div style="padding-left:2em;">
 
==== Requirements ====
 
: 1. Install and start desired web server
 
: 2. Install and start desired PHP processor
 
: 3. Install and start desired SQL engine
 
 
==== Database ====
 
: 1. Create a database named '''ffxiv_server'''
 
: 2. Confirm that the sql server is set with the following behavioral defaults:
 
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
 
: 3. Load the SQL files of '''<Classic Server source code location>\sql\''' into the database
 
 
==== Login Server ====
 
: 1. Copy the following to web server: '''<Classic Server source location>\www'''
 
: 2. '''OPTIONAL:''' If you have modified the database login settings, change them at:
 
:: '''<web server www folder>\config.php'''
 
: 3. Restart the web server service
 
: 4. Navigate to '''<nowiki>http://<web server ip>/create_user.php</nowiki>''' and create a new account<br>
 
 
==== Setting up Lobby, World and Map Servers ====
 
# '''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
 
# Copy '''lobby_config.ini''' from '''<Classic Server source location>/data/'''
 
#: to '''<Classic Server source location>\FFXIVClassic Lobby Server\bin\(Debug\Release)\'''
 
# 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)\'''
 
# Copy world'''_config.ini''' from '''<Classic Server source location>/data/'''
 
#: to '''<Classic Server source location>\FFXIVClassic World Server\bin\(Debug\Release)\'''
 
</div>
 
  
 
=== Starting the servers ===
 
=== Starting the servers ===

Revision as of 17:19, 2 May 2019

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