ServerSetup - Revision history

Unnamed Mercenary: /* Installing WAMP */

2021-03-25T04:02:01Z

‎Installing WAMP

Unnamed Mercenary: /* Installing WAMP */

2021-03-25T04:01:49Z

‎Installing WAMP

Unnamed Mercenary at 03:54, 25 March 2021

2021-03-25T03:54:17Z

Unnamed Mercenary: /* Setting up Lobby, World and Map Servers */

2020-09-22T19:32:36Z

‎Setting up Lobby, World and Map Servers

Unnamed Mercenary at 16:16, 29 June 2020

2020-06-29T16:16:24Z

Unnamed Mercenary: /* Installing WAMP */

2019-10-17T02:11:25Z

‎Installing WAMP

Unnamed Mercenary at 17:22, 2 May 2019

2019-05-02T17:22:36Z

Unnamed Mercenary: Minor adjustments

2019-05-02T17:19:47Z

Minor adjustments

Unnamed Mercenary: 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..."

2018-04-18T03:32:53Z

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..."

New page

== Server Setup ==

=== Setting up with 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 ====
: 1. Confirm all WAMP services are installed
: 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
: [[File:Heidi_WAMP_01_Login.png]]

: 4. Verify you are connected: A newly set up/blank mysql server should have the following databases listed:
:: {| class="wikitable"
|+ Default tables
| information_schema
| mysql
| performance_schema
| sys
|}
: 5. Right Click '''Unnamed''' and go to '''Create new''' → '''Database''' 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'''
: [[File:Heidi_WAMP_02_Create_DB.png]]

: 6. Click the new '''ffxiv_server''' database entry
: 7. Go to '''File''' → '''Run SQL File''' and navigate to the '''<Classic Server source code location>\sql\''' folder <br>[[File: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.
: [[File:Heidi_WAMP_04_Select_SQL_file.png]]

==== 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 ====
# '''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)\'''

=== 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 ===
: 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'''

@@ Line 1: / Line 1: @@
 == Server Setup ==
@@ Line 76: / Line 77: @@
 : 3. Run the map server: '''<Project Meteor source location>\Map Server\bin\(Debug\Release)\Map Server.exe'''
 : 4. Run the map server: '''<Project Meteor source location>\World Server\bin\(Debug\Release)\World Server.exe'''

@@ Line 68: / Line 68: @@
 # Copy '''world_config.ini''' from '''<Project Meteor source location>/data/'''
 #: to '''<Project Meteor source location>\World Server\bin\(Debug\Release)\'''
 === Starting the servers ===

@@ Line 32: / Line 32: @@
 : 6. Click the new '''ffxiv_server''' database entry
-: 7. Go to '''File''' → '''Run SQL File''' and navigate to the '''<Classic Server source code location>\sql\''' folder  <br>[[File:Heidi_WAMP_03_Run_SQL.png]]
+: 7. Go to '''File''' → '''Run SQL File''' and navigate to the '''<Project Meteor source code location>\sql\''' folder  <br>[[File: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.
 : [[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.
+: 1. Open the <Project Meteor 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 PATH_SQL="<Project Meteor source location>\sql"
 SET USER=root
@@ Line 54: / Line 54: @@
 : 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
+: 3. Copy the contents of the '''<Project Meteor 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:
@@ Line 61: / Line 61: @@
 === 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
+# '''OPTIONAL:''' If the server and client are on different machines, edit the server IPs in the following locations  '''<Project Meteor 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/'''
+# Copy '''lobby_config.ini''' from '''<Project Meteor source location>/data/'''
-#: to '''<Classic Server source location>\FFXIVClassic Lobby Server\bin\(Debug\Release)\'''
+#: to '''<Project Meteor source location>\Lobby Server\bin\(Debug\Release)\'''
-# Copy '''map_config.ini''', '''staticactors.bin''' and the '''scripts''' folder from '''<Classic Server source location>/data/'''
+# Copy '''map_config.ini''', '''staticactors.bin''' and the '''scripts''' folder from '''<Project Meteor source location>/data/'''
-#: to '''<Classic Server source location>\FFXIVClassic Map Server\bin\(Debug\Release)\'''
+#: to '''<Project Meteor source location>\Map Server\bin\(Debug\Release)\'''
-# Copy '''world_config.ini''' from '''<Classic Server source location>/data/'''
+# Copy '''world_config.ini''' from '''<Project Meteor source location>/data/'''
-#: to '''<Classic Server source location>\FFXIVClassic World Server\bin\(Debug\Release)\'''
+#: to '''<Project Meteor source location>\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'''
+: 2. Run the lobby server: '''<Project Meteor source location>\Lobby Server\bin\(Debug\Release)\Lobby Server.exe'''
-: 3. Run the map server: '''<Classic Server source location>\FFXIVClassic Map Server\bin\(Debug\Release)\FFXIVClassic Map Server.exe'''
+: 3. Run the map server: '''<Project Meteor source location>\Map Server\bin\(Debug\Release)\Map Server.exe'''
-: 4. Run the map server: '''<Classic Server source location>\FFXIVClassic World Server\bin\(Debug\Release)\FFXIVClassic World Server.exe'''
+: 4. Run the map server: '''<Project Meteor source location>\World Server\bin\(Debug\Release)\World Server.exe'''

@@ Line 12: / Line 12: @@
 ::* 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
 '''Note2:''' Recent versions of WAMP try to package multiple database servers. You do not need to have both MySQL and MariaDB running. In fact, please don't try to make both run. The WAMP icon may not turn green and this is fine so long as Apache and one database server is running.

@@ Line 9: / Line 9: @@
 : 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
+::* Yellow: Some services started properly - this is fine if WAMP has installed multiple conflicting database servers.
 ::* 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 ===

@@ Line 4: / Line 4: @@
 === Installing WAMP ===
-: 1. Download and install WAMP
+: 1. Download and install [http://www.wampserver.com/en/#download-wrapper 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:

@@ Line 51: / Line 51: @@
 :: The default WAMP credentials are already in place, as there is no root password.
-==== Setting Up the Login Server ====
+=== Setting Up the Login Server ===
 : 1. Confirm all WAMP services are running
 : 2. Navigate to the location of the server source code
@@ Line 60: / Line 60: @@
 : 5. Restart the WAMP services
-==== Setting up Lobby, World and Map Servers ====
+=== 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/'''