Documentation Center

Viz Mosart Administrator Guide

Version 4.0 | Published September 22, 2020 ©

Installing the Viz Mosart Template Database

Both installing and creating the Viz Mosart Template database is outlined in this section.

Prerequisites

  • A MySQLor equivalent database server (MariaDB, AWS Aurora MySQL) need to be installed and accessible from the Mosart server. The database server may either be dedicated for the Mosart automation servers or an existing in-house or cloud based server.

  • A database user with credentials sufficient for creating and altering databases. This is mandatory for AvAutomation which is responsible for automatic upgrading of the template database.

  • A local mysql client or tool that makes it possible to connect and run sql scripts towards the database.

MySQL Database Servers and Clients

  • Wampserver - which is a complete Windows web development environment using Apache2 and PHP. It contains both MySQL and MariaDb database servers and supports PhpMyAdmin or Adminer for database management and configuration.
    This solution is recommended when installing a dedicated template database for the Mosart automation servers. It allows remote access to the database via http.

  • MySQL server - Use the MySQL Installer to install the native MySQL database server. Normally also install the MySQL Workbench as a client for managing and configuring the database server.

  • MySQL Workbench - which provides an integrated tools environment for database management and administration.

  • MariaDB - Open source equvivalent of MySQL server

  • HeidiSQL - Simple free MySql/ProgreSQL/Microsoft SQL client.

  • dbVisualizer - Client for multiple database servers.

Refer to section Prerequisites for details of supported versions.

Verify the connection to the template database

Verify the connection to the template database from the Mosart Server using a MySql client before configuring the Mosart Server. Typical issues here are related to firewall and credentials.

MySQL Users

Four types of users may be created for using the Mosart template database:

Role

Description

Application

Server management

Full rights, at least the possibility to create and alter databases

Database management

Full rights within a single database / schema

Minimum rights for AvAutomation

Database use (read/write)

Need to be able to do CRUD operations on a single database

Minimum rights for ManusAdmin

Database use (read only)

Only need to be able to do read operations on a single database

Minimum rights for ActiveX

It is recommend is to create two users for Mosart automation. One for the Mosart Server (AvAutomation and ManusAdmin) will full admin rights for the Mosart database and the other for the Mosart ActiveX which only requires rights to perform read operations.

Initial Mosart Template Database

The initial database is located in the Sql directory as part of the Mosart Server installation. Pick the .sql file with the highest version number. Currently version 1.0.5:

InitialMosartTemplateDatabase_1.0.5.sql

The sql file containing the initial Mosart Template Database shall be used to create the initial database on the database server.

Creating the Initial Template Database

Creating the initial template database can be done in one of the following ways:

  1. By importing the initial database sql file using a database client, All MySql database clients given above supports import of sql scripts. Normally requires root access.

  2. Using the MySQL command line tool mysql.exe. The script RunDbScripts.cmd contains command lines to import the initial database using mysql. This script is located in the BatchFiles directory as part of the Mosart Server installation.

    RunDbScripts.cmd
    ::: RunDbScripts.cmd:
    ::: Command script to upload an initial and empty database as the Mosart template database:
     
    ::: Option 1: Invoke mysql with user credentials on the command line.
    ::: Note localhost is assumed if host is not given.
    mysql [--host=hostname] --user=username --password=password mosarttemplatedb < ../Sql/InitialMosartTemplateDatabase_1.0.5.sql
     
    ::: Option 2: Invoke mysql with user credentials from the corresponding mysql.ini file.
    mysql --defaults-extra-file=mysql.ini < ../Sql/InitialMosartTemplateDatabase_1.0.5.sql

  3. After import, a database mosarttemplatedb is created

mysql.exe

mysql.exe is part of MySQL Server, MySQL Workbench or Wampserver installations