Dise Complete Installation

Described here are the steps you need to take to setup a Dise Complete database server or update an already existing Dise Complete database. Dise Complete is used in a Dise Enterprise system for central monitoring, reporting, and management. Maybe you already have a database server setup and ready to be used.

Requirements

• A server computer meeting the server requirements, accessible from all computers in the Dise system.
• MySQL (version 4.1 and 5.0 are verified) or Microsoft SQL Server (2005+ verified) with valid licenses. SQL Server Express editions. Administrator account details.

Recommended

• SQLyog or similar SQL administration tool for MySQL administration.

Installation

MySQL

• Follow directions on the Installing MySQL on Microsoft Windows - mysql.com page how to install MySQL. The default settings should in most circumstances be enough. The MySQL installation is most preferably done on a dedicated or shared server. It is also possible to install the server on a workstation for testing or small installations. The MySQL server does not have to be on a Windows OS.
• During setup, enter and note the password for the user root. This is the administrative user which we will use initially to create the database and its tables.
• Make sure that remote connections to the server are possible.

Microsoft SQL Server

• Follow directions on the How to: Install SQL Server 2008 R2 (Setup) - microsoft.com page how to install SQL Server. The default settings should in most circumstances be enough. The SQL Server is most preferably done on a Windows Server OS. It is also possible to install the server on a workstation for testing or small installations.

Note: If the server is simultaneously running IIS (Internet Information Services), disabling the log feature will prevent the server from running out of storage.

• During setup, enter and note the password for the user sa. This is the administrative user which we will use initially to create the database and its tables.
• Configure so that you can use the SQL Server Management Studio.
• Make sure that remote connections to the server are possible.

Dise Complete Applications

• Download the Dise Complete Applications & Database package from the Dise support web.
• Run the installer.
• During the install you can select to install the Dise Complete Service, this service will go through the database doing both maintenance and status updating work.
  If you select the service, then you will be presented with the Dise Complete Service Manager during the installation. Click Setup in this manager to specify This service will now automatically start when the computer starts and you can control it easily with the Manager program.
• In the end of the installation, run the Dise Complete Setup Wizard. This Wizard will help you create or update your Dise Complete database. If you are doing an update and not a new installation, please make sure to take a backup of the database before updating, or that you do not install a clean database on top of another as this would remove all your previous data.
• Enter the administrator username and password when asked to enter the database connection details.

• Enter a name for your new Dise Complete database.

• The wizard will create the database and all tables for you.

Create a Dise Complete user

Create a user that you will enter on the players to access the database. The user will be restricted to have full access only to the Dise Complete database.

MySQL

Log in to the MySQL instance and enter the following commands (or use your favourite database editor):

Create a new user:

CREATE USER 'dise'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON DiseComplete.* TO 'dise'@'%';
FLUSH PRIVILEGES;

Microsoft SQL Server

Log in to the SQL Server instance and enter the following commands:

Create a new user:

USE DiseComplete;
CREATE LOGIN dise WITH PASSWORD = 'password';
CREATE USER dise FOR LOGIN dise; 
GRANT ALTER TO dise; 
GRANT CONTROL TO dise;

Upgrade notes

If you are upgrading from a earlier Dise Complete installation then you only have to run the Dise Complete Setup Wizard after you have done a new installation of our Dise Complete Applications & Database package.

Important notes

Important: By default an administrator account will be created in the Dise Complete system. The username for this account is Admin.

Important: The administrator password is blank by default, this means that no password is required to login to the Dise Complete database when logging in from any of the Dise applications. You can easily change the password from the Dise Complete Management tool.

Troubleshooting

In the case that the Complete Setup Wizard is not able to access the database server, please copy the SQL queries in the DiseComplete.sql (for MySQL) or DiseCompleteMSSQL.sql (for SQL Server) files, located in the Dise Complete Applications installation directory, and run them from your preferred database management software.