- 90
- 2024
- 38
I have seen a few people mentioning that they wish to host 2 off the same machine, be it which ever expansions this is how you do it and it works every time.
YOU WILL NOT BE ABLE TO LAUNCH BOTH FROM THE APP, YOU WILL HAVE TO USE THE FOLDER PROGRAMS MAKE SURE YOU KNOW WHERE YOU INSTALL YOUR SERVERS TO!
Requirements:
~Eyes
Step one:
Make sure you have all of which ever repacks you wish to run, for the purpose of the tutorial, and other obvious reasons, i will be using Emucoach Repacks.
Currently I have 4.3.4 V19 (cataclysm VIP Beta) and 5.4.8 6.1(Mists of Pandaria Premium)
for the purpose of this tutorial i will isolate Cataclysm as the first one to deal with, setup your cataclysm as normal
Step 1.5 (optional, depends if you want to forward to the outside world):
~ Ensure Ports 3724 and 8085 are forwarded and accessible through both your Firewall, and Router, aswell as port 3725 and 8086 (these will be needed for MOP Section might as well do it now!)
Step 2: Start installing your MoP server repack, but DO NOT LAUNCH YOUR MOP SERVER YET!
This is where it gets different, but not difficult. You are going to want to right click > Edit in Notepad the mysql.bat file found in the database folder.
when you open that bat file, you will see the code below:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@Echo off
COLOR F
echo ______________________Portable MySQL Server________________
echo _________________________________MySQL 8.0.30____________________________
echo.
echo MySQL is currently running. Please only close this window for shutdown.
echo Please disregard any InoDB messages that are prompted. They have no use.
echo After your server is shut off, press CTRL C to shut down this service.
mysql\bin\mysqld --standalone --console
if errorlevel 1 goto error
goto finish
:error
echo.
echo MySQL could not be started.
pause
:finish
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This is correct if you were only launching One repack, you are not, your launching multiple, so you need to tell mysql to start on a different port, instead of syfting through your my.ini settings, simply change the bat file to override what it specifies for the port with the command:
--port=3308 (or whatever port you have available to switch it to, I am not your dad
)
Now your mysql.bat should look like this:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@Echo off
COLOR F
echo ______________________Portable MySQL Server________________
echo _________________________________MySQL 8.0.30____________________________
echo.
echo MySQL is currently running. Please only close this window for shutdown.
echo Please disregard any InoDB messages that are prompted. They have no use.
echo After your server is shut off, press CTRL C to shut down this service.
mysql\bin\mysqld --standalone --console --port=3308
if errorlevel 1 goto error
goto finish
:error
echo.
echo MySQL could not be started.
pause
:finish
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Now that your MySQL server is going to launch on a seperate port, you need to change a couple more settings. You will need to edit your Auth.conf and your world.conf to match the new ports now aswell (REMEMBER THE PORT FORWARDING PORTS I MENTIONED EARLIER) so your going to see a few lines that have this:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;auth" (This one is the only one that will also be present in your Auth, the rest is only in world.conf)
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters"
HotfixDatabaseInfo = "127.0.0.1;3306;root;ascent;hotfixes;"
Auth File Only:
RealmServerPort = 3724
World.conf only:
RealmID = 1
WorldServerPort = 8085
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Change the ports to what you chose to forward, i chose 3308, 3725, and 8086 and so my lines will look like this:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LoginDatabaseInfo = "127.0.0.1;3308;root;ascent;auth"
WorldDatabaseInfo = "127.0.0.1;3308;root;ascent;world"
CharacterDatabaseInfo = "127.0.0.1;3308;root;ascent;characters"
HotfixDatabaseInfo = "127.0.0.1;3308;root;ascent;hotfixes;"
Auth File Only:
RealmServerPort = 3725
World.conf only:
RealmID = 2
WorldServerPort = 8086
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Last step, and probably the most forgotten, The SQL Database!
Launch your mysql.bat, and load into whichever database program you use (HeidiSQL is my go to)
NOTE: Please dont forget to change your connection port to 3308 or whichever port you chose!
Once connected to the database, follow the below Navigation:
Auth>realmlist
Once there you need to change a minimum of 2 values ( 3 if your forwarding the server for public play):
id: 1 -> 2
address: 127.0.0.1 -> Your Public IP (Yellow due to only required if Public Play)
port: 8085 -> 8086
Now its as simple as connecting! There is one more snaffu that most people forget about, and that dedicating the connection realmlist to the new AUTH port like this:
SET realmlist "darkestwow.servegame.com" -> SET realmlist "darkestwow.servegame.com:3725"
There you are! you have reached the end of the tutorial! i hope this helps some people!
YOU WILL NOT BE ABLE TO LAUNCH BOTH FROM THE APP, YOU WILL HAVE TO USE THE FOLDER PROGRAMS MAKE SURE YOU KNOW WHERE YOU INSTALL YOUR SERVERS TO!
Requirements:
~Eyes
Step one:
Make sure you have all of which ever repacks you wish to run, for the purpose of the tutorial, and other obvious reasons, i will be using Emucoach Repacks.
Currently I have 4.3.4 V19 (cataclysm VIP Beta) and 5.4.8 6.1(Mists of Pandaria Premium)
for the purpose of this tutorial i will isolate Cataclysm as the first one to deal with, setup your cataclysm as normal
Step 1.5 (optional, depends if you want to forward to the outside world):
~ Ensure Ports 3724 and 8085 are forwarded and accessible through both your Firewall, and Router, aswell as port 3725 and 8086 (these will be needed for MOP Section might as well do it now!)
Step 2: Start installing your MoP server repack, but DO NOT LAUNCH YOUR MOP SERVER YET!
This is where it gets different, but not difficult. You are going to want to right click > Edit in Notepad the mysql.bat file found in the database folder.
when you open that bat file, you will see the code below:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@Echo off
COLOR F
echo ______________________Portable MySQL Server________________
echo _________________________________MySQL 8.0.30____________________________
echo.
echo MySQL is currently running. Please only close this window for shutdown.
echo Please disregard any InoDB messages that are prompted. They have no use.
echo After your server is shut off, press CTRL C to shut down this service.
mysql\bin\mysqld --standalone --console
if errorlevel 1 goto error
goto finish
:error
echo.
echo MySQL could not be started.
pause
:finish
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This is correct if you were only launching One repack, you are not, your launching multiple, so you need to tell mysql to start on a different port, instead of syfting through your my.ini settings, simply change the bat file to override what it specifies for the port with the command:
--port=3308 (or whatever port you have available to switch it to, I am not your dad
)Now your mysql.bat should look like this:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@Echo off
COLOR F
echo ______________________Portable MySQL Server________________
echo _________________________________MySQL 8.0.30____________________________
echo.
echo MySQL is currently running. Please only close this window for shutdown.
echo Please disregard any InoDB messages that are prompted. They have no use.
echo After your server is shut off, press CTRL C to shut down this service.
mysql\bin\mysqld --standalone --console --port=3308
if errorlevel 1 goto error
goto finish
:error
echo.
echo MySQL could not be started.
pause
:finish
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Now that your MySQL server is going to launch on a seperate port, you need to change a couple more settings. You will need to edit your Auth.conf and your world.conf to match the new ports now aswell (REMEMBER THE PORT FORWARDING PORTS I MENTIONED EARLIER) so your going to see a few lines that have this:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;auth" (This one is the only one that will also be present in your Auth, the rest is only in world.conf)
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters"
HotfixDatabaseInfo = "127.0.0.1;3306;root;ascent;hotfixes;"
Auth File Only:
RealmServerPort = 3724
World.conf only:
RealmID = 1
WorldServerPort = 8085
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Change the ports to what you chose to forward, i chose 3308, 3725, and 8086 and so my lines will look like this:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LoginDatabaseInfo = "127.0.0.1;3308;root;ascent;auth"
WorldDatabaseInfo = "127.0.0.1;3308;root;ascent;world"
CharacterDatabaseInfo = "127.0.0.1;3308;root;ascent;characters"
HotfixDatabaseInfo = "127.0.0.1;3308;root;ascent;hotfixes;"
Auth File Only:
RealmServerPort = 3725
World.conf only:
RealmID = 2
WorldServerPort = 8086
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Last step, and probably the most forgotten, The SQL Database!
Launch your mysql.bat, and load into whichever database program you use (HeidiSQL is my go to)
NOTE: Please dont forget to change your connection port to 3308 or whichever port you chose!
Once connected to the database, follow the below Navigation:
Auth>realmlist
Once there you need to change a minimum of 2 values ( 3 if your forwarding the server for public play):
id: 1 -> 2
address: 127.0.0.1 -> Your Public IP (Yellow due to only required if Public Play)
port: 8085 -> 8086
Now its as simple as connecting! There is one more snaffu that most people forget about, and that dedicating the connection realmlist to the new AUTH port like this:
SET realmlist "darkestwow.servegame.com" -> SET realmlist "darkestwow.servegame.com:3725"
There you are! you have reached the end of the tutorial! i hope this helps some people!