Building the Server - Revision history

Teo: /* Installation */

2019-08-26T13:26:31Z

‎Installation

Apocalypse612: /* Installation */

2019-07-01T01:19:15Z

‎Installation

Whasf: VS 2019

2019-04-05T01:07:39Z

VS 2019

Whasf: upgrade to VS 2019

2019-04-05T01:06:52Z

upgrade to VS 2019

Teo: /* Using a bat script */

2019-02-26T01:12:26Z

‎Using a bat script

Teo: lets count how many people complain they used this and get errors now, for lols

2019-02-26T01:03:13Z

lets count how many people complain they used this and get errors now, for lols

Teo: /* Downloading the Server Source Code */

2019-02-11T12:55:35Z

‎Downloading the Server Source Code

Teo: /* Installation */

2018-11-05T00:05:03Z

‎Installation

Teo at 20:22, 21 October 2018

2018-10-21T20:22:01Z

Teo: I blame spellcheck

2018-10-21T20:19:14Z

I blame spellcheck

@@ Line 34: / Line 34: @@
 '''Recommended versions are:'''
-* MariaDB 10.2.18
+* MariaDB 10.4
 * MySQL Community Server 5.7
 * MySQL Community Server 5.6

@@ Line 35: / Line 35: @@
 '''Recommended versions are:'''
 * MariaDB 10.2.18
-* MySQL 5.7
+* MySQL Community Server 5.7
-* MySQL 5.6
+* MySQL Community Server 5.6
 ==== MariaDB ====

@@ Line 16: / Line 16: @@
 * all of:
-** [https://www.visualstudio.com/downloads/ Visual Studio 2017 (Community is fine, make sure you select C++ development and windows SDK during install)]
+** [https://www.visualstudio.com/downloads/ Visual Studio 2019 (Community is fine, make sure you select C++ development and windows SDK during install)]
 ** [https://git-for-windows.github.io/ Git For Windows]
 ** [https://tortoisegit.org/ TortoiseGit]

@@ Line 136: / Line 136: @@
 Use default installation options. This can still be installed and will still function even if you use MariaDB instead of stock MySQL. It will generate a few warnings from by a version number check that you can safely ignore.
-==== Visual Studio 2017 ====
+==== Visual Studio 2019 ====
 Any edition works.  Community is free.
-Make sure you install Desktop development with C++ when selecting development packages.
+'''Make sure you install Desktop development with C++ when selecting development packages.'''
 ==== Git for Windows ====

@@ Line 229: / Line 229: @@
 ECHO Creating Database dspdb
-"c:\\edit\this\path\bin\mysqladmin" -h localhost -u root -pMYSQLPASS CREATE dspdb
+"c:\edit\this\path\bin\mysqladmin" -h localhost -u root -pMYSQLPASS CREATE dspdb
 ECHO Loading dspdb tables into the database
 cd c:\path\to\darkstar\sql
-FOR %%X IN (*.sql) DO ECHO Importing %%X & "\edit\this\path\bin\mysql" dspdb -h localhost -u root -pMYSQLPASS < %%X
+FOR %%X IN (*.sql) DO ECHO Importing %%X & "c:\edit\this\path\bin\mysql" dspdb -h localhost -u root -pMYSQLPASS < %%X
 ECHO Finished!

@@ Line 206: / Line 206: @@
 REM =============================================================================
 REM ======                                                              =========
-REM ====== THis script will drop the DB specificed, then create the DB  =========
+REM ====== This script will drop the DB specified, then create the DB  =========
 REM ====== specified, and then load all .sql tables from its run dir to =========
 REM ====== the the DB.                                                  =========
@@ Line 212: / Line 212: @@
 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 ====== default it WILL DROP the standard dspdb DB, losing 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.              =========
@@ Line 221: / Line 221: @@
 REM ====== If you want to use a different database name, change 'dspdb' =========
 REM ====== with a database name of your choosing.                       =========
 REM ======                                                              =========
 REM =============================================================================
@@ Line 233: / Line 226: @@
 ECHO Creating Database dspdb
-"c:\program files\mysql\mysql server 5.6\bin\mysqladmin" -h localhost -u root -pMYSQLPASS DROP dspdb
+"c:\edit\this\path\bin\mysqladmin" -h localhost -u root -pMYSQLPASS DROP dspdb
 ECHO Creating Database dspdb
-"c:\program files\mysql\mysql server 5.6\bin\mysqladmin" -h localhost -u root -pMYSQLPASS CREATE dspdb
+"c:\\edit\this\path\bin\mysqladmin" -h localhost -u root -pMYSQLPASS CREATE dspdb
 ECHO Loading dspdb tables into the database
-cd c:\darkstar\sql
+cd c:\path\to\darkstar\sql
-FOR %%X IN (*.sql) DO ECHO Importing %%X & "c:\program files\mysql\mysql server 5.6\bin\mysql" dspdb -h localhost -u root -pMYSQLPASS < %%X
+FOR %%X IN (*.sql) DO ECHO Importing %%X & "\edit\this\path\bin\mysql" dspdb -h localhost -u root -pMYSQLPASS < %%X
 ECHO Finished!
@@ Line 276: / Line 269: @@
 del delivery_box.sql
 del linkshells.sql
-FOR %%X IN (*.sql) DO ECHO Importing %%X & "c:\program files\mysql\mysql server 5.6\bin\mysql" dspdb -h localhost -u root -pMYSQLPASS < %%X
+FOR %%X IN (*.sql) DO ECHO Importing %%X & "c:\edit\this\path\bin\mysql" dspdb -h localhost -u root -pMYSQLPASS < %%X
 </pre>

@@ Line 174: / Line 174: @@
 <code><nowiki>http://github.com/DarkstarProject/darkstar.git</nowiki></code>
-Set the "Directory" to your choice (blank will default to current location /darkstar
+Set the "Directory" to your choice (blank will default to a new folder named "darkstar" at the current location)
 Click OK.
 Wait for the download to finish.
 Click OK to close TortoiseGit.

← Older revision		Revision as of 00:05, 5 November 2018
Line 23:		Line 23:

	=== Installation ===		=== Installation ===
		+
		+	'''IMPORTANT NOTICE!'''
		+
		+	There may be certain issues when trying to use newer versions of MySQL or MariaDB. Pull requests to remedy these issues are welcome.
		+
		+	Some feature change:
		+	* The PASSWORD() function is removed in the latest version of MySQL
		+	* Use of the VALUES() function is limited to INSERT ... ON DUPLICATE KEY UPDATE in the latest versions of MariaB ''and'' MySQL
		+	* The latest MySQL may complain about default timestamps on certain tables - this is also a known issue with using XAMP distributions in some configurations.
		+
		+	'''Recommended versions are:'''
		+	* MariaDB 10.2.18
		+	* MySQL 5.7
		+	* MySQL 5.6

	==== MariaDB ====		==== MariaDB ====

@@ Line 399: / Line 399: @@
 Select Save and then close the table.
 ==== 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.

@@ Line 264: / Line 264: @@
 ==== Using HeidiSQL ====
-Configure Heidi to use your MariaDB or MySQL connection. Read [https://www.heidisql.com/help.php the documentation] or click "new" and wing it like those brave souls who pretend they understand idea manuals.
+Configure Heidi to use your MariaDB or MySQL connection. Read [https://www.heidisql.com/help.php the documentation] or click "new" and wing it like those brave souls who pretend they understand ikea manuals.
 Open the "session" then right click it and move your cursor to "new" so the submenu opens and click "database". All instructions after this point will assume you named your database "dspdb" without quotes.