Clustered multiple Wurm servers

From Citadel Servers Wiki
Jump to navigation Jump to search
Download the SQLite DataBase Browser for your operating system. We recommend using the portable app version

SQLiteDBBrowser.png



Install the SQLite DB browser and run it

Open Database from sqlite\wurmslogin.db

In the top toolbar select Open Database

Navigate to the sqlite folder in your database folder

Open the wurmlogin.db database file


OpenDatabaseWurmsLogin.png

 

Browse Data Tab


Select the second tab from the left, the Browse Data tab

BrowseDataTab.png

SERVERS Table



In the dropdown Table menu select SERVERS

SERVERSTable.png

New Record in SERVERS Table



At the right hand side of this select New Record

The first thing to do is choose a unique Server ID under SERVER for the new record

NewRecordSERVERID.png



Remember the Server IDs for the existing server and the new server. They will be needed in the following step and further steps!

SERVERNEIGHBOURS Table

In the Table dropdown menu now select SERVERNEIGHBOURS

SERVERNEIGHBOURS.png



Add NEIGHBOUR and DIRECTION to SERVERNEIGHBOURS SERVER

In the SERVERNEIGHBOURS table the records for your servers and which other servers they neighbour are kept

For the existing server enter the Server ID of the new server in the NEIGHBOUR attribute

In the DIRECTION attribute specify the direction you want this new neighbouring server to be in relation to the existing server
Example: EAST (all caps)

SERVERNEIGHBOURSFilled.png





File - Write Changes

Press Ctrl+S or select Write Changes in the File menu to save the changes to the database

WriteChanges.png



Upload Database with FTP Client or File Manager

With a prefered FTP client or File Manager upload the whole database to your server

A related guide for FTP and File Managers can be found here:
FTP or File Manager Guide



Configuration Files

In the Wurm Unlimited game Control Panel select Configuration Files

ConfigurationFiles.png



 

Configuration Editor for Service Settings

In Configuration Files select Text Editor under Actions for the ServiceSettings

ServerSettings.png





Copy down the Internal Server Port, External Server Port, RMI Port, and RMI Reg Port.

ServerInfo.png





Neighbor Settings

Return to Configuration Files but now select Configuration Editor under Actions for the ServiceSettings.

Find the corresponding Neighbour Settings for the DIRECTION you chose in the SERVERNEIGHBOURS Table
Example: Eastern Neighbor Settings

ServiceSettingsConfigurationEditor.png



Enter Server Information

Enter the Server ID you chose for the new server from the SERVER table in the "Server ID of Eastern server:" field

Enter the server name and the relevant port information of your second server into the rest of the Settings fields


ServiceSettingsConfigurationEditorFilled.png



Update Database

Click Save and return to the Wurm Unlimited game Control Panel. Click the "Update Database (Click before Starting Server)" option

UpdateDatabase.png




Configuration File

Find the folder of your Login server

Open the directory of the map you're playing (Example: Creative)

Open the Wurm.ini with notepad

Find the line named "USE_INCOMING_RMI=false" with Ctrl+F

Change it to "USE_INCOMING_RMI=true"

If the "USE_INCOMING_RMI=false" line does not exist in the file then add it

Wurmpedia.png