External Database


Another case where you will need to modify the Advanced Mode settings is to configure your server to use an external database.

The server currently supports MariaDB (or MySQL) standard database back end. The default embedded database MariaDB is completely integrated into the server, so there is no need for further modifications if you use this one. Alternatively, you may choose to run your server using external MariaDB (or MySQL) database. The following describes the essentials for setting up your server to work with an alternative database.

Common Configuration

In the configuration tool you can access the database configuration fields in the advanced mode, you need to adjust the Database Name, Jdbc User Name, Jdbc Password and finally adjust the Jdbc Url.

In the Jdbc Url shown below replace localhost with the actual IP (or host address) of the machine on which the database server is running on (if not running on the same machine as your nesstar server). E.g. replace localhost with ess.nsd.uib.no
jdbc:mysql://localhost:33306/nesstar?useUnicode=true&characterEncoding=UTF-8

The rest depends on the configuration of the external database itself with essentially the appropriate Database, User Name and Password. The following are very brief instructions of what to do and need to be carried out by an experienced database administrator.

 

Administration/Browsing

Currently, MySQL-tools can be used to browse/administer both MariaDB and MySQL-instances.

The recommended MySQL clients are MySQL Administrator and MySQL Query Browser graphical clients ( download from MySQL Home ). The alternative is to use the command line interface.

MySQL

Using MySQL Administrator/Query Browser

When setting up the graphical MySQL clients, you will need to point it to the hostname of the machine on which the server was installed. The database name is nesstar, the username is root, and the password is the administrator password entered during installation.

Using Command line interface

To use the command line interface, locate the mariadb.bat file in the MariaDB directory in your server root. Executing this will log you into MariaDB. Here are some tips for using MariaDB:

Creating Nesstar Database

From your MySQL client enter the following SQL commands

CREATE DATABASE IF NOT EXISTS nesstar DEFAULT CHARACTER SET utf8;
ALTER DATABASE nesstar COLLATE 'utf8_general_ci';
GRANT ALL PRIVILEGES ON nesstar.* TO nesstar@localhost IDENTIFIED BY {YOUR_PASSWORD};