- Joined
- Apr 2, 2007
- Messages
- 72
- Reaction score
- 4
Square Enix Attacked me so go forth minions and Set fire to their world 600 servers by months end
Lets start with this is an emulator
Prerequisites
In this section we will download every program/tool we will need to setup and maintain the servers. Do not install these yet.
Installation
MySql
(flag)
Choose Typical Installation
After the main installation, select Launch the MySQL Instance Configuration Wizard
Select Detailed Configuration
Select Developer Machine
Select Multi-functional Database
Standard Installation Directory
Select Manual Setting and 1000 Concurrent connections
Select Enable TCP/IP Networking, Port Number 3306, and Enable Strict Mode
Select Best Support for Multilingualism
Select Install as Windows Service, Launch the MySQL Server automatically, and Include Bin Directory in Windows PATH.
Select Modify Security Settings, and enter a new password twice. Write down the MySQL password. (DO NOT LEAVE BLANK.)
Select Next, Execute, then Finish
MySQL 5.6 (Updated)
Note: Server is x86, but will install 32-bit and 64-bit binaries.
Accept License Terms
Skip Check for updates
Select Developer Default
Check requirements and click Execute - will launch installers for anything you're missing
Default Installation - ~5min
Default Configuration - Check box for "Show Advance Options" - Click Next
Enter MySQL Root Password, twice. Remember it! - Click Next
It will show windows service details, leave as default and Click Next
It will show Logging options, leave as default and Click Next
Configuration will complete, Click Next
Samples and examples will configure - ~5min - Click Next
Uncheck "launch MySQL Workbench, Click Finish
Navicat Lite
(flag)
Use default installation options.
Visual Studio 2010
Use the default installation options. You may be forced to restart (sometimes twice) during the installation. You should have Visual Studio Service Pack 1 (requiring another restart). It depends on your OS.
Tortoise SVN
Use default installation options. You can skip the step to reboot since we'll reboot once everything else is installed.
Visual C++ Redistributable Runtime 2010
Use default installation options.
.Net 3.5, 3.5 SP1, and 4.0
Use default installation options.
At this point everything should be installed that needs to be and you can restart your PC to finalize them.
Downloading the Server Source Code
In this section we will use Tortoise SVN to download the latest SVN source code for the server.
Open Windows Explorer (right click the start button and choose Windows Explorer)
Right click on any folder select SVN Checkout
In the "URL of repository" put in the following url:
http://onetimexi.googlecode.com/svn/trunk/
Set the "Checkout directory" to
C:\dsp.
Click OK.
Wait for the download to finish.
Click OK to close Tortoise SVN.
Close windows explorer
At this point you have downloaded all of the source code for the latest version.
Setting up the Database
In this section we will use the data that you downloaded to build a database in MySQL.
Using a bat script
If you follow this step, you may skip the next one.
Paste the following into notepad and save it as DSP_Import.bat in your dsp\sql folder:
@ECHO OFFREM =============================================================================REM =============================================================================REM ====== =========REM ====== THis script will drop the DB specificed, then create the DB =========REM ====== specified, and then load all .sql tables from its run dir to =========REM ====== the the DB. =========REM ====== =========REM ====== File needs to be run from within the \dsp\sql folder (same =========REM ====== folder with all the .sql files. Please edit as needed. By =========REM ====== default it WILL DROP the standard dspdb DB, loosing all =========REM ====== accounts and characters. If this is not desired, then update =========REM ====== the file to load the new DB into a new DB name. =========REM ====== =========REM ====== Update -p with MySQL password. If you password is 'foo', =========REM ====== then change '-pMYSQLPASS' to '-pfoo' (3 places). =========REM ====== =========REM ====== If you want to use a different database name, change 'dspdb' =========REM ====== with a database name of your choosing. =========REM ====== =========REM =============================================================================REM =============================================================================REM ====== =========REM ====== by Thrydwolf 9/8/2012 =========REM ====== Updated with status by bluekirby0 3/30/2012 =========REM ====== Updated by Thrydwolf 9/18/2012 =========REM ====== =========REM =============================================================================REM =============================================================================ECHO Creating Database dspdbmysqladmin -h localhost -u root -pMYSQLPASS DROP dspdbECHO Creating Database dspdbmysqladmin -h localhost -u root -pMYSQLPASS CREATE dspdbECHO Loading dspdb with tablesREM FOR %%X IN (*.sql) DO mysql dspdb -h localhost -u root -pMYSQLPASS < %%XFOR %%X IN (*.sql) DO ECHO Importing %%X & mysql dspdb -h localhost -u root -pMYSQLPASS < %%XECHO Finished!At a minimum you will need to change -proot in the script to where root is your mysql root password. If your password is 'foo' then you would use '-pfoo' instead.
You can use this script any time the svn is updated, but it will drop the table and thus delete all your player data. You may want to make manual changes instead unless you are using it purely as a test server.
Using Navicat
(flag)
This is the more hands-on approach, and being comfortable doing it this way may make it easier to update individual tables later without having to learn the mysql command-line interface.
Open Navicat
Click Connection (or File, New Connection)
Connection name: DarkStar
Host Name/IP: localhost
Port: 3306
User Name: root
Password: Enter the password you wrote down during the mySQL installation.
Check Save Password
Click OK
In the connections pane double click DarkStar
Right click on DarkStar and select New Database...
Name it dspdb
Use the Default character set
Select OK.
Double click dspdb
Right click on dspdb and select Execute SQL File...
Browse to C:\dsp\sql and select abilities.sql
Click Start
Continue this process for each file in the folder.
If you have an issue with the triggers.sql file then follow this step. If not, proceed to the next step (IP address for the map server):
In Navicat Open accounts table
Click File, Design Table
Click the Triggers tab
There should a line already listed with account_delete in the Name field
If not:
click Add Trigger
Name column should be account_delete
Fires column should be Before
Check the box in the Delete column
In the definition box below add the following code:
DELETE FROM `accounts_banned` WHERE `accid` = OLD.id; DELETE FROM `chars` WHERE `accid` = OLD.id;Select Save and then close the table.
Open the chars table
Click File, Design Table
Click the Triggers tab
There should already be a line listed with char_delete in the name field.
If not:
click Add Trigger
Name column should be char_delete
Fires column should be Before
Check the box in the Delete column
In the definition box below add the following code:
DELETE FROM `char_exp` WHERE `charid` = OLD.charid; DELETE FROM `char_jobs` WHERE `charid` = OLD.charid; DELETE FROM `char_equip` WHERE `charid` = OLD.charid; DELETE FROM `char_effects` WHERE `charid` = OLD.charid; DELETE FROM `char_look` WHERE `charid` = OLD.charid; DELETE FROM `char_stats` WHERE `charid` = OLD.charid; DELETE FROM `char_skills` WHERE `charid` = OLD.charid; DELETE FROM `char_titles` WHERE `charid` = OLD.charid; DELETE FROM `char_inventory` WHERE `charid` = OLD.charid; DELETE FROM `char_vars` WHERE `charid` = OLD.charid;
Select Save and then close the table.
Note: Leave Navicat open for the next section.
Configure the ZoneIP for the Map Server
Now you need to determine what IP address that will be used for the Map Server, then update MySQL with it.
Most devs & enthusiasts will not have a separate map server, but will run both map server and login server on the same PC.
1. Determine what IP address will be used for the map server.
If the server will be public, then use your external IP in the next step. (Looks really random 173.194.43.104)
If the server will be internal and you want it available on other PCs in your internal network, use the internal network IP (192.168.x.x) in the next step.
If you only plan to run the client and the server on the same PC, you can use the localhost address (127.0.0.1) in the next step.
2. Calculate the new form from the IP address.
The IP must be entered in different form, so first we must calculate the new form. Use the formula below or
Formula = 1st Octet + 2nd Octet * 256 + 3rd Octet *256 (squared) + 4th Octet * 256 (cubed)
Example: 127.0.0.1 = 127 + 0 + 0 + 1*256(cubed) = 16777343
Example: 192.168.1.102 = 192 + 168*256 + 1*256(squared) + 102*256(cubed) = 1711384768
Example: 67.41.45.115 = 67 + 41*256 + 45*256(squared) + 115*256(cubed) = 1932339523
(flag) In Navicat double click on the table dspdb and expand
Click on Query
Right click and select New Query
Add the following code into the empty space, inserting the value calculated above. The value in the code below (16777343) would be used if only running the client from the same PC as the server.
UPDATE zone_settings SET zoneip = '16777343';Select Run. "256 queries should be successful!" should be the result.
I recommend you save the Query in case you need to run it again later after updating the server.
Close Navicat.
Building the Servers
In this section we will be building the Dark Star servers.
Dark Star uses 3 separate servers. A Login server, a Map/Game server, and an optional Search/Auction House server. Using the ZoneIP mentioned earlier, every map could run on its own server at a different IP address. If you have 4 computers each computer could run different areas, as long as they were all connected to the same MySQL database server.
Build the Login Server
Open Visual Studio
Click File, Open, Project/Solution (or Ctrl+Shift+O)
Navigate to C:\dsp\win32\DSConnect-Server
Select DSConnect-server.sln (usually the first one)
It may take a few minutes to load files.
Click Debug then Build Server (or F7, or Ctrl+Shift+B)
Building will take a few minutes.
Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:
========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.
If there is a #include error, change that #include to say #include <mysql/mysql.h>
Build the Map Server
Click File, Open, Project/Solution (or Ctrl+Shift+O)
Navigate to C:\dsp\win32\DSGame-Server
Select DSGame-server.sln (usually the first one)
It may take a few minutes to load files.
Click Debug then Build Server (or F7, or Ctrl+Shift+B)
Building will take a few minutes.
Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:
========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.
If there is a #include error, change that #include to say #include <mysql/mysql.h>
Building the Optional Search Server
Navigate to C:\dsp\win32\DSSearch-server
Select DSSearch-server.sln (usually the first one)
It may take a few minutes to load files.
Click Debug then Build Server (or F7, or Ctrl+Shift+B)
Building will take a few minutes.
Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:
========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.
If there is a #include error, change that #include to say #include <mysql/mysql.h>
When all of the Servers are built
Verify in the C:\dsp directory that the servers you built are there:
DSConnect-server.exe for the Login Server
DSGame-server.exe for the Map Server
DSSearch-server.exe for the Search Server
Configuring the Servers
Now you will configure the Login Server and Map Server to connect to the MySQL database.
Do not mess with any other settings in these files unless you know what they are for and what they do.
Login Server Settings
In windows explorer navigate to c:\dsp\conf
Open login_darkstar.conf in a text editer (notepad)
Scroll down to the bottom and validate/update the following lines:
mysql_host: 127.0.0.1mysql_port: 3306mysql_login: rootmysql_password: root <-- change this to your password you wrote down during the MySQL install (flag)mysql_database: dspdb
Map Server Settings
In windows explorer navigate to c:\dsp\conf
Open map_darkstar.conf in a text editer (notepad)
Scroll down to the bottom and validate/update the following lines:
mysql_host: 127.0.0.1mysql_port: 3306mysql_login: rootmysql_password: root <-- change this to your password you wrote down during the MySQL install (flag)mysql_database: dspdbSearch Server Settings
In windows explorer navigate to c:\dsp\conf
Open search_server.conf in a text editer (notepad)
Scroll down to the bottom and validate/update the following lines:
mysql_host: 127.0.0.1mysql_port: 3306mysql_login: rootmysql_password: root <-- change this to your password you wrote down during the MySQL install (flag)mysql_database: dspdb
At this point we have configured the servers to connect to the SQL database.
Starting the Servers
In this section we will launch our new servers.
Navigate to c:\dsp
Run DSConnect-server.exe as Admin
Run DSGame-server.exe as Admin
(Optional) Run DSSearch-server.exe as Admin
At this point if your servers fail to load, you probably missed a step. Go back through the steps and try to find out what you missed. It may also be helpful to look at the log files located in c:\dsp\log.
Forward Ports to Allow Others to Join (& Firewall)
In this section we will provide the port numbers that need to be forwarded to the server. This is only needed to allow people outside your local intranet to join your server.
In your router and firewall the following ports need to be opened/forwarded to your server:
TCP Ports:54230542315400154002UDP Port:54230If still having trouble, disable any firewall software completely for testing. This includes the Windows firewall that comes on all modern Windows systems, which can be found in the Control Panel.
Installing & Setting up the DS Server on Linux
The server is known to build in recent
Fedora-specific instructions may be found on the page:
Generic build instructions for most POSIX (GNU/Linux, and possibly FreeBSD, NetBSD, UNIX or even OSX with some additional work) systems follow. Some knowledge of how to compile software on your distribution is assumed. You may find it helpful to reference the Windows guide above if something is unclear.
Prerequisites:
A compiler with C++11 support. Currently tested with GCC and G++, and requires a minimum version of 4.6
Subversion to retrieve the source code.
patch to apply the search server patch (should be installed with subversion if your system lacks it)
Autotools (automake autoconf m4sh) and pkg-config to generate the configure script and Makefile
mysql server
mysql client library (select the developer version if your distro has one)
lua library version 5.1 or higher (select the developer version if your distro has one)
If you plan to run from a console, you may also wish to install "screen" as there is no daemon mode for the servers yet.
Preparing the Source Code
Once you have everything mentioned above installed, grab the latest source from the repository via the command:
svn co
patch -p0 -i dssearchv6.diffCompiling
Next is a typical autotools build. Run the autogen script, followed by configure, and then make:
sh autogen.sh./configure --enable-debugmakeYou can choose not to configure with debug enabled, but there is very little potential gain in this and it prevents many useful break statements from triggering. The Makefile also has separate targets to build each server named "dsconnect" "dsgame" and "dssearch" but will build all 3 if none are specified.
Compiling on 64-bit
These steps were done on Ubuntu 12.04. First you need to install the relevant packages:
sudo apt-get install libc-dev-i386sudo apt-get install g++-multilibsudo apt-get install libmysqlclient-dev:i386sudo apt-get install liblua5.1-dev:i386 You'll note that these are 32-bit packages which are needed to build in 32-bit mode. If you already have the 64-bit mysql client libraries already installed, you have to uninstall them. Sadly the 32-bit version and 64-bit version can not coexist. NOTE: This is not advised if you have applications relying on the sql libraries! In order to get rid of it you can do:
sudo apt-get remove --purge libmysqlclient-devAt this point you should be all set up but there is one more thing that needs to be addressed. The source is looking for a liblua.so library which didn't exist from the liblua5.1 installation. To manually set it up do:
cd /usr/lib/i386-linux-gnu/sudo ln -s liblua5.1.so liblua.soNow the environment is set up so you can run the configure script. We have to force it into 32-bit mode using CPPFLAGS and CXXFLAGS:
CPPFLAGS=-m32 CXXFLAGS=-m32 ./configuremakeAt this point it should complete the build and you can continue on to the next section.
Setting Up the Database
If you do not know your mysql root password, the default on most systems is blank. It is a good idea to change this for security reasons, as your mysql root user has full permissions on all databases. The first time you run the mysql client, you should be prompted to change the password. After doing so, you will want to create a user specifically for dealing with the darkstar server database. Run mysql as follows:
mysql -u root -pEnter your root password at the prompt. Next, create a new user as follows:
CREATE USER 'darkstar'@'localhost' IDENTIFIED BY 'password';Substitute "password" with a password of your choice. Next, we want to create a database, and set up our new user with permissions to work with it.
CREATE DATABASE dspdb;USE dspdb;GRANT ALL PRIVILEGES ON dspdb.* TO 'darkstar'@'localhost';exitThis will make it to where your new user can do anything necessary, but can only connect from localhost, so even if your password is compromised, it will be difficult to mess with the database remotely. If you need to be able to access the database remotely (like if the database is stored on a separate machine from the server), change the configuration according to the host that will be accessing the database.
Now, you need to populate the database.
cd sqlfor f in *.sql do echo -n "Importing $f into the database..." mysql dspdb -u darkstar -ppassword < $f && echo "Success" donecd ..To set up your ZoneIP, see the related windows section
mysql -u darkstar -ppasswordUSE dspdb;UPDATE zone_settings SET zoneip = '16777343';exitreplacing "16777343" with the value you determined in your calculation. You should see a message that 256 changes have occured after the update command.
Configuring the Server
Before running your new servers, you will need to update the configuration files to tell it how to talk to the database. You will need to update the files in the conf/ sub-folder named "login_darkstar.conf" "map_darkstar.conf" and "search_server.conf" at a minimum. Find the mysql settings in each and change as appropriate, using the new user, password and database you created earlier.
You may also wish to browse through the various configuration files for any settings that might be of interest to you, but more details on server customization can be found at
Starting the Servers
You may now start your new servers. If you are using a desktop environment, you may wish to open 3 separate terminals and run each server in a separate one to monitor them efficiently. Otherwise, you will want to run them in screen sessions as follows:
screen -d -m -S dsconnect ./dsconnectscreen -d -m -S dsgame ./dsgamescreen -d -m -S dssearch ./dssearchThis will start and auto-detach all three servers, assigning them meaningful names to make it easy to reattach later by using the commands:
screen -r dsconnector
screen -r dsgameor
screen -r dssearchto monitor a given server. Once you've attached to a screen, you can detach by first pressing "ctrl+a" and then "d". There are many other useful ways to use screen, so do whatever suits yoru preference.
Your server is now up-and-running, and a client should be able to connect as long as there are no obvious errors on any of the server screens. If the search server is having issues, it is not vital for basic game functionality, but you will be unable to use search functions or the auction house. If you have run into any major issues, contact bluekirby0 (the current maintainer of the linux port as of the time of this writing) on IRC #darkstarproject@irc.rizon.net or in the
Automatic Server Restarts & Crash Logs
If your server goes down, no one can connect. If it goes down when you're not looking, it can be down for an extended period of time. To fix this, you probably want to have a way to have your server auto-restart. In addition, it's good to know when the server crashed.
Getting the software
First, you'll want to download Knas Restarter here:
Creating the Logging files
In the dsp directory where your game, connect, and search server reside, create a 'tools' folder. In the folder create 4 new text files by right clicking, and going to New > Text Document
Make sure you have file extension view turned on so that you can see the .txt at the end.
Rename the 4 files to the following:
connect_crash.bat <Change the file type to bat file, deleting .txt
connect_crash_log.txt
game_crash.bat <Change the file type to bat file, deleting .txt
game_crash_log.txt
Right click on connect_crash.bat and click 'edit' Place the following inside: echo %date% %time% >> connect_crash_log.txt Save and close
Right click on game_crash.bat and click 'edit' Place the following inside: echo %date% %time% >> game_crash_log.txt Save and close
Connect Server Restart
Launch Knas Restarter Find DSConnect-server.exe and click on it Click "Select" Change itnerval to 10 seconds Under "Restart Paramters"; Check Keep restarter minimized in "Working Directory" enter the directory where dsp is installed Under Actions; Check "External Script" and browse to your tools folder and select connect_crash.bat Click "Create Shortcut" and save to your desktop
Game Server Restart
Launch Knas Restarter Find DSGame-server.exe and click on it Click "Select" Change itnerval to 10 seconds Under "Restart Paramters"; Check Keep restarter minimized in "Working Directory" enter the directory where dsp is installed Under Actions; Check "External Script" and browse to your tools folder and select game_crash.bat Click "Create Shortcut" and save to your desktop
Launching
Open the shortcuts you created on your desktop, and open the search server as you normally would.
Crash logs will be found in the text files you created in the tools directory showing the date and time the crash occurred.
Problems
In some Windows opperating systems, a window will pop up saying the program has crashed, leaving the crashed program up and preventing an auto-restart. This can be avoided by disabling the user interface for critical errors. To do this follow these steps:
Start > Run gpedit.msc
Computer Configuration > Administrative Templates > Windows Components > Windows Error Reporting Set Prevent Display of the user interface for critical errors" to Enabled
Common Errors
Getting Errors on Load / In Game
You have to run all changed sql files! Be careful you keep zoneip correct in zone_settings.sql.
Can't Connect to Game Server
Make sure your zoneip in zone_settings table is correct. Also make sure packets can reach the 53445 port.
Restart server after changing zoneip.
Packet or key is invalid:
Restart login server, game server and game client.
make: *** No rule to make target
Delete .deps
source autogen.sh./configuremake
Lets start with this is an emulator
Prerequisites
In this section we will download every program/tool we will need to setup and maintain the servers. Do not install these yet.
You must be registered to see links
(flag) -Or-
You must be registered to see links
(flag)
You must be registered to see links
(flag)
You must be registered to see links
You must be registered to see links
You must be registered to see links
You must be registered to see links
You must be registered to see links
(already comes with Win 7)
You must be registered to see links
(already comes with Win 7)
You must be registered to see links
Installation
MySql
(flag)
Choose Typical Installation
After the main installation, select Launch the MySQL Instance Configuration Wizard
Select Detailed Configuration
Select Developer Machine
Select Multi-functional Database
Standard Installation Directory
Select Manual Setting and 1000 Concurrent connections
Select Enable TCP/IP Networking, Port Number 3306, and Enable Strict Mode
Select Best Support for Multilingualism
Select Install as Windows Service, Launch the MySQL Server automatically, and Include Bin Directory in Windows PATH.
Select Modify Security Settings, and enter a new password twice. Write down the MySQL password. (DO NOT LEAVE BLANK.)
Select Next, Execute, then Finish
MySQL 5.6 (Updated)
Note: Server is x86, but will install 32-bit and 64-bit binaries.
Accept License Terms
Skip Check for updates
Select Developer Default
Check requirements and click Execute - will launch installers for anything you're missing
Default Installation - ~5min
Default Configuration - Check box for "Show Advance Options" - Click Next
Enter MySQL Root Password, twice. Remember it! - Click Next
It will show windows service details, leave as default and Click Next
It will show Logging options, leave as default and Click Next
Configuration will complete, Click Next
Samples and examples will configure - ~5min - Click Next
Uncheck "launch MySQL Workbench, Click Finish
Navicat Lite
(flag)
Use default installation options.
Visual Studio 2010
Use the default installation options. You may be forced to restart (sometimes twice) during the installation. You should have Visual Studio Service Pack 1 (requiring another restart). It depends on your OS.
Tortoise SVN
Use default installation options. You can skip the step to reboot since we'll reboot once everything else is installed.
Visual C++ Redistributable Runtime 2010
Use default installation options.
.Net 3.5, 3.5 SP1, and 4.0
Use default installation options.
At this point everything should be installed that needs to be and you can restart your PC to finalize them.
Downloading the Server Source Code
In this section we will use Tortoise SVN to download the latest SVN source code for the server.
Open Windows Explorer (right click the start button and choose Windows Explorer)
Right click on any folder select SVN Checkout
In the "URL of repository" put in the following url:
http://onetimexi.googlecode.com/svn/trunk/
Set the "Checkout directory" to
C:\dsp.
Click OK.
Wait for the download to finish.
Click OK to close Tortoise SVN.
Close windows explorer
At this point you have downloaded all of the source code for the latest version.
Setting up the Database
In this section we will use the data that you downloaded to build a database in MySQL.
Using a bat script
If you follow this step, you may skip the next one.
Paste the following into notepad and save it as DSP_Import.bat in your dsp\sql folder:
@ECHO OFFREM =============================================================================REM =============================================================================REM ====== =========REM ====== THis script will drop the DB specificed, then create the DB =========REM ====== specified, and then load all .sql tables from its run dir to =========REM ====== the the DB. =========REM ====== =========REM ====== File needs to be run from within the \dsp\sql folder (same =========REM ====== folder with all the .sql files. Please edit as needed. By =========REM ====== default it WILL DROP the standard dspdb DB, loosing all =========REM ====== accounts and characters. If this is not desired, then update =========REM ====== the file to load the new DB into a new DB name. =========REM ====== =========REM ====== Update -p with MySQL password. If you password is 'foo', =========REM ====== then change '-pMYSQLPASS' to '-pfoo' (3 places). =========REM ====== =========REM ====== If you want to use a different database name, change 'dspdb' =========REM ====== with a database name of your choosing. =========REM ====== =========REM =============================================================================REM =============================================================================REM ====== =========REM ====== by Thrydwolf 9/8/2012 =========REM ====== Updated with status by bluekirby0 3/30/2012 =========REM ====== Updated by Thrydwolf 9/18/2012 =========REM ====== =========REM =============================================================================REM =============================================================================ECHO Creating Database dspdbmysqladmin -h localhost -u root -pMYSQLPASS DROP dspdbECHO Creating Database dspdbmysqladmin -h localhost -u root -pMYSQLPASS CREATE dspdbECHO Loading dspdb with tablesREM FOR %%X IN (*.sql) DO mysql dspdb -h localhost -u root -pMYSQLPASS < %%XFOR %%X IN (*.sql) DO ECHO Importing %%X & mysql dspdb -h localhost -u root -pMYSQLPASS < %%XECHO Finished!At a minimum you will need to change -proot in the script to where root is your mysql root password. If your password is 'foo' then you would use '-pfoo' instead.
You can use this script any time the svn is updated, but it will drop the table and thus delete all your player data. You may want to make manual changes instead unless you are using it purely as a test server.
Using Navicat
(flag)
This is the more hands-on approach, and being comfortable doing it this way may make it easier to update individual tables later without having to learn the mysql command-line interface.
Open Navicat
Click Connection (or File, New Connection)
Connection name: DarkStar
Host Name/IP: localhost
Port: 3306
User Name: root
Password: Enter the password you wrote down during the mySQL installation.
Check Save Password
Click OK
In the connections pane double click DarkStar
Right click on DarkStar and select New Database...
Name it dspdb
Use the Default character set
Select OK.
Double click dspdb
Right click on dspdb and select Execute SQL File...
Browse to C:\dsp\sql and select abilities.sql
Click Start
Continue this process for each file in the folder.
If you have an issue with the triggers.sql file then follow this step. If not, proceed to the next step (IP address for the map server):
In Navicat Open accounts table
Click File, Design Table
Click the Triggers tab
There should a line already listed with account_delete in the Name field
If not:
click Add Trigger
Name column should be account_delete
Fires column should be Before
Check the box in the Delete column
In the definition box below add the following code:
DELETE FROM `accounts_banned` WHERE `accid` = OLD.id; DELETE FROM `chars` WHERE `accid` = OLD.id;Select Save and then close the table.
Open the chars table
Click File, Design Table
Click the Triggers tab
There should already be a line listed with char_delete in the name field.
If not:
click Add Trigger
Name column should be char_delete
Fires column should be Before
Check the box in the Delete column
In the definition box below add the following code:
DELETE FROM `char_exp` WHERE `charid` = OLD.charid; DELETE FROM `char_jobs` WHERE `charid` = OLD.charid; DELETE FROM `char_equip` WHERE `charid` = OLD.charid; DELETE FROM `char_effects` WHERE `charid` = OLD.charid; DELETE FROM `char_look` WHERE `charid` = OLD.charid; DELETE FROM `char_stats` WHERE `charid` = OLD.charid; DELETE FROM `char_skills` WHERE `charid` = OLD.charid; DELETE FROM `char_titles` WHERE `charid` = OLD.charid; DELETE FROM `char_inventory` WHERE `charid` = OLD.charid; DELETE FROM `char_vars` WHERE `charid` = OLD.charid;
Select Save and then close the table.
Note: Leave Navicat open for the next section.
Configure the ZoneIP for the Map Server
Now you need to determine what IP address that will be used for the Map Server, then update MySQL with it.
Most devs & enthusiasts will not have a separate map server, but will run both map server and login server on the same PC.
1. Determine what IP address will be used for the map server.
If the server will be public, then use your external IP in the next step. (Looks really random 173.194.43.104)
If the server will be internal and you want it available on other PCs in your internal network, use the internal network IP (192.168.x.x) in the next step.
If you only plan to run the client and the server on the same PC, you can use the localhost address (127.0.0.1) in the next step.
2. Calculate the new form from the IP address.
The IP must be entered in different form, so first we must calculate the new form. Use the formula below or
You must be registered to see links
to calculate it. If you use the site you must put the IP in reverse order to get the required value (i.e. instead of 127.0.0.1 which gives 2130706433 put in 1.0.0.127 to get 16777343).Formula = 1st Octet + 2nd Octet * 256 + 3rd Octet *256 (squared) + 4th Octet * 256 (cubed)
Example: 127.0.0.1 = 127 + 0 + 0 + 1*256(cubed) = 16777343
Example: 192.168.1.102 = 192 + 168*256 + 1*256(squared) + 102*256(cubed) = 1711384768
Example: 67.41.45.115 = 67 + 41*256 + 45*256(squared) + 115*256(cubed) = 1932339523
(flag) In Navicat double click on the table dspdb and expand
Click on Query
Right click and select New Query
Add the following code into the empty space, inserting the value calculated above. The value in the code below (16777343) would be used if only running the client from the same PC as the server.
UPDATE zone_settings SET zoneip = '16777343';Select Run. "256 queries should be successful!" should be the result.
I recommend you save the Query in case you need to run it again later after updating the server.
Close Navicat.
Building the Servers
In this section we will be building the Dark Star servers.
Dark Star uses 3 separate servers. A Login server, a Map/Game server, and an optional Search/Auction House server. Using the ZoneIP mentioned earlier, every map could run on its own server at a different IP address. If you have 4 computers each computer could run different areas, as long as they were all connected to the same MySQL database server.
Build the Login Server
Open Visual Studio
Click File, Open, Project/Solution (or Ctrl+Shift+O)
Navigate to C:\dsp\win32\DSConnect-Server
Select DSConnect-server.sln (usually the first one)
It may take a few minutes to load files.
Click Debug then Build Server (or F7, or Ctrl+Shift+B)
Building will take a few minutes.
Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:
========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.
If there is a #include error, change that #include to say #include <mysql/mysql.h>
Build the Map Server
Click File, Open, Project/Solution (or Ctrl+Shift+O)
Navigate to C:\dsp\win32\DSGame-Server
Select DSGame-server.sln (usually the first one)
It may take a few minutes to load files.
Click Debug then Build Server (or F7, or Ctrl+Shift+B)
Building will take a few minutes.
Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:
========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.
If there is a #include error, change that #include to say #include <mysql/mysql.h>
Building the Optional Search Server
Navigate to C:\dsp\win32\DSSearch-server
Select DSSearch-server.sln (usually the first one)
It may take a few minutes to load files.
Click Debug then Build Server (or F7, or Ctrl+Shift+B)
Building will take a few minutes.
Once complete, validate that there are no Errors listed in the summary line at the bottom. It should look like this:
========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========If there are any SQL errors it is probably caused by the SQL dev package was extracted to the wrong folder.
If there is a #include error, change that #include to say #include <mysql/mysql.h>
When all of the Servers are built
Verify in the C:\dsp directory that the servers you built are there:
DSConnect-server.exe for the Login Server
DSGame-server.exe for the Map Server
DSSearch-server.exe for the Search Server
Configuring the Servers
Now you will configure the Login Server and Map Server to connect to the MySQL database.
Do not mess with any other settings in these files unless you know what they are for and what they do.
Login Server Settings
In windows explorer navigate to c:\dsp\conf
Open login_darkstar.conf in a text editer (notepad)
Scroll down to the bottom and validate/update the following lines:
mysql_host: 127.0.0.1mysql_port: 3306mysql_login: rootmysql_password: root <-- change this to your password you wrote down during the MySQL install (flag)mysql_database: dspdb
Map Server Settings
In windows explorer navigate to c:\dsp\conf
Open map_darkstar.conf in a text editer (notepad)
Scroll down to the bottom and validate/update the following lines:
mysql_host: 127.0.0.1mysql_port: 3306mysql_login: rootmysql_password: root <-- change this to your password you wrote down during the MySQL install (flag)mysql_database: dspdbSearch Server Settings
In windows explorer navigate to c:\dsp\conf
Open search_server.conf in a text editer (notepad)
Scroll down to the bottom and validate/update the following lines:
mysql_host: 127.0.0.1mysql_port: 3306mysql_login: rootmysql_password: root <-- change this to your password you wrote down during the MySQL install (flag)mysql_database: dspdb
At this point we have configured the servers to connect to the SQL database.
Starting the Servers
In this section we will launch our new servers.
Navigate to c:\dsp
Run DSConnect-server.exe as Admin
Run DSGame-server.exe as Admin
(Optional) Run DSSearch-server.exe as Admin
At this point if your servers fail to load, you probably missed a step. Go back through the steps and try to find out what you missed. It may also be helpful to look at the log files located in c:\dsp\log.
Forward Ports to Allow Others to Join (& Firewall)
In this section we will provide the port numbers that need to be forwarded to the server. This is only needed to allow people outside your local intranet to join your server.
In your router and firewall the following ports need to be opened/forwarded to your server:
TCP Ports:54230542315400154002UDP Port:54230If still having trouble, disable any firewall software completely for testing. This includes the Windows firewall that comes on all modern Windows systems, which can be found in the Control Panel.
Installing & Setting up the DS Server on Linux
The server is known to build in recent
You must be registered to see links
GNU/Linux,
You must be registered to see links
, and
You must be registered to see links
versions, and is tested regularly against all three platforms. It is also known to build on
You must be registered to see links
.Fedora-specific instructions may be found on the page:
You must be registered to see links
Generic build instructions for most POSIX (GNU/Linux, and possibly FreeBSD, NetBSD, UNIX or even OSX with some additional work) systems follow. Some knowledge of how to compile software on your distribution is assumed. You may find it helpful to reference the Windows guide above if something is unclear.
Prerequisites:
A compiler with C++11 support. Currently tested with GCC and G++, and requires a minimum version of 4.6
Subversion to retrieve the source code.
patch to apply the search server patch (should be installed with subversion if your system lacks it)
Autotools (automake autoconf m4sh) and pkg-config to generate the configure script and Makefile
mysql server
mysql client library (select the developer version if your distro has one)
lua library version 5.1 or higher (select the developer version if your distro has one)
If you plan to run from a console, you may also wish to install "screen" as there is no daemon mode for the servers yet.
Preparing the Source Code
Once you have everything mentioned above installed, grab the latest source from the repository via the command:
svn co
You must be registered to see links
dsp/Now, find the latest version of the search server patch at
You must be registered to see links
. Extract the diff file into the dsp folder and apply it using the command:patch -p0 -i dssearchv6.diffCompiling
Next is a typical autotools build. Run the autogen script, followed by configure, and then make:
sh autogen.sh./configure --enable-debugmakeYou can choose not to configure with debug enabled, but there is very little potential gain in this and it prevents many useful break statements from triggering. The Makefile also has separate targets to build each server named "dsconnect" "dsgame" and "dssearch" but will build all 3 if none are specified.
Compiling on 64-bit
These steps were done on Ubuntu 12.04. First you need to install the relevant packages:
sudo apt-get install libc-dev-i386sudo apt-get install g++-multilibsudo apt-get install libmysqlclient-dev:i386sudo apt-get install liblua5.1-dev:i386 You'll note that these are 32-bit packages which are needed to build in 32-bit mode. If you already have the 64-bit mysql client libraries already installed, you have to uninstall them. Sadly the 32-bit version and 64-bit version can not coexist. NOTE: This is not advised if you have applications relying on the sql libraries! In order to get rid of it you can do:
sudo apt-get remove --purge libmysqlclient-devAt this point you should be all set up but there is one more thing that needs to be addressed. The source is looking for a liblua.so library which didn't exist from the liblua5.1 installation. To manually set it up do:
cd /usr/lib/i386-linux-gnu/sudo ln -s liblua5.1.so liblua.soNow the environment is set up so you can run the configure script. We have to force it into 32-bit mode using CPPFLAGS and CXXFLAGS:
CPPFLAGS=-m32 CXXFLAGS=-m32 ./configuremakeAt this point it should complete the build and you can continue on to the next section.
Setting Up the Database
If you do not know your mysql root password, the default on most systems is blank. It is a good idea to change this for security reasons, as your mysql root user has full permissions on all databases. The first time you run the mysql client, you should be prompted to change the password. After doing so, you will want to create a user specifically for dealing with the darkstar server database. Run mysql as follows:
mysql -u root -pEnter your root password at the prompt. Next, create a new user as follows:
CREATE USER 'darkstar'@'localhost' IDENTIFIED BY 'password';Substitute "password" with a password of your choice. Next, we want to create a database, and set up our new user with permissions to work with it.
CREATE DATABASE dspdb;USE dspdb;GRANT ALL PRIVILEGES ON dspdb.* TO 'darkstar'@'localhost';exitThis will make it to where your new user can do anything necessary, but can only connect from localhost, so even if your password is compromised, it will be difficult to mess with the database remotely. If you need to be able to access the database remotely (like if the database is stored on a separate machine from the server), change the configuration according to the host that will be accessing the database.
Now, you need to populate the database.
cd sqlfor f in *.sql do echo -n "Importing $f into the database..." mysql dspdb -u darkstar -ppassword < $f && echo "Success" donecd ..To set up your ZoneIP, see the related windows section
You must be registered to see links
above for how to calculate it, and then run:mysql -u darkstar -ppasswordUSE dspdb;UPDATE zone_settings SET zoneip = '16777343';exitreplacing "16777343" with the value you determined in your calculation. You should see a message that 256 changes have occured after the update command.
Configuring the Server
Before running your new servers, you will need to update the configuration files to tell it how to talk to the database. You will need to update the files in the conf/ sub-folder named "login_darkstar.conf" "map_darkstar.conf" and "search_server.conf" at a minimum. Find the mysql settings in each and change as appropriate, using the new user, password and database you created earlier.
You may also wish to browse through the various configuration files for any settings that might be of interest to you, but more details on server customization can be found at
You must be registered to see links
.Starting the Servers
You may now start your new servers. If you are using a desktop environment, you may wish to open 3 separate terminals and run each server in a separate one to monitor them efficiently. Otherwise, you will want to run them in screen sessions as follows:
screen -d -m -S dsconnect ./dsconnectscreen -d -m -S dsgame ./dsgamescreen -d -m -S dssearch ./dssearchThis will start and auto-detach all three servers, assigning them meaningful names to make it easy to reattach later by using the commands:
screen -r dsconnector
screen -r dsgameor
screen -r dssearchto monitor a given server. Once you've attached to a screen, you can detach by first pressing "ctrl+a" and then "d". There are many other useful ways to use screen, so do whatever suits yoru preference.
Your server is now up-and-running, and a client should be able to connect as long as there are no obvious errors on any of the server screens. If the search server is having issues, it is not vital for basic game functionality, but you will be unable to use search functions or the auction house. If you have run into any major issues, contact bluekirby0 (the current maintainer of the linux port as of the time of this writing) on IRC #darkstarproject@irc.rizon.net or in the
You must be registered to see links
.Automatic Server Restarts & Crash Logs
If your server goes down, no one can connect. If it goes down when you're not looking, it can be down for an extended period of time. To fix this, you probably want to have a way to have your server auto-restart. In addition, it's good to know when the server crashed.
Getting the software
First, you'll want to download Knas Restarter here:
You must be registered to see links
.Creating the Logging files
In the dsp directory where your game, connect, and search server reside, create a 'tools' folder. In the folder create 4 new text files by right clicking, and going to New > Text Document
Make sure you have file extension view turned on so that you can see the .txt at the end.
Rename the 4 files to the following:
connect_crash.bat <Change the file type to bat file, deleting .txt
connect_crash_log.txt
game_crash.bat <Change the file type to bat file, deleting .txt
game_crash_log.txt
Right click on connect_crash.bat and click 'edit' Place the following inside: echo %date% %time% >> connect_crash_log.txt Save and close
Right click on game_crash.bat and click 'edit' Place the following inside: echo %date% %time% >> game_crash_log.txt Save and close
Connect Server Restart
Launch Knas Restarter Find DSConnect-server.exe and click on it Click "Select" Change itnerval to 10 seconds Under "Restart Paramters"; Check Keep restarter minimized in "Working Directory" enter the directory where dsp is installed Under Actions; Check "External Script" and browse to your tools folder and select connect_crash.bat Click "Create Shortcut" and save to your desktop
Game Server Restart
Launch Knas Restarter Find DSGame-server.exe and click on it Click "Select" Change itnerval to 10 seconds Under "Restart Paramters"; Check Keep restarter minimized in "Working Directory" enter the directory where dsp is installed Under Actions; Check "External Script" and browse to your tools folder and select game_crash.bat Click "Create Shortcut" and save to your desktop
Launching
Open the shortcuts you created on your desktop, and open the search server as you normally would.
Crash logs will be found in the text files you created in the tools directory showing the date and time the crash occurred.
Problems
In some Windows opperating systems, a window will pop up saying the program has crashed, leaving the crashed program up and preventing an auto-restart. This can be avoided by disabling the user interface for critical errors. To do this follow these steps:
Start > Run gpedit.msc
Computer Configuration > Administrative Templates > Windows Components > Windows Error Reporting Set Prevent Display of the user interface for critical errors" to Enabled
Common Errors
Getting Errors on Load / In Game
You have to run all changed sql files! Be careful you keep zoneip correct in zone_settings.sql.
Can't Connect to Game Server
Make sure your zoneip in zone_settings table is correct. Also make sure packets can reach the 53445 port.
Restart server after changing zoneip.
Packet or key is invalid:
Restart login server, game server and game client.
make: *** No rule to make target
Delete .deps
source autogen.sh./configuremake
Last edited:
