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 MySQL standard database back end. The default embedded database MySQL 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 MySQL database with the MyISAM backend. Please note that no other MySQL databse backend are currently supported. 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 .need to select the appropriate database (mysql) and 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
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 mysql.bat file in the mysql directory in your server root. Executing this will log you into mysql. Here are some tips for using mysql:
- Before doing operations on the Nesstar database, you must switch to it using 'use nesstar;' (or your JDBC Database name).
- List the tables in the nesstar database using 'show tables;'.
- The command line will accept SQL statements terminated with a semi-colon (i.e. select * from studyejb where id = 'uk.ac.data-archive.ddi.4213';).
Creating Nesstar Database
From your MySQL client enter the following SQL commands (replace text in bold with your personal settings):
CREATE DATABASE IF NOT EXISTS nesstar;
GRANT ALL PRIVILEGES ON nesstar.* TO nesstar@localhost IDENTIFIED BY 'YourPassword';
