Documentation Center

Viz Mosart Administrator Guide

Version 3.9 | Published November 04, 2019 ©

Installing the Viz Mosart Database

Installing and creating the Viz Mosart Database is outlined in this section.

This functionality has been developed and tested on MySQL, consequently Viz Mosart recommends MySQL for hosting the Viz Mosart Database.

Setting up the Viz Mosart Database is done as follows:

  1. Install MySQL

  2. Create the database

  3. Configure Viz Mosart to use the database
    Configuring AV Automation to work with the Viz Mosart Database is outlined in AV Automation Device Properties.

This section contains the following topics:

Installing WampServer

WampServer is a software package including, among others, MySQL and the management tool phpMyAdmin.

At the time of writing, WampServer 2.1e, includes MySQL 5.5.8 (x86) or MySQL 5.1.53 (x64).

The template Database has been developed and tested on this version, consequently Viz Mosart recommends installing WampServer 2.1e or later.

IMPORTANT! WampServer has to be installed without the following Windows components: HTTP Support for MSMQ (part of Message Queuing).

WampServer is installed by following the steps below, the exact steps may vary on OS used:

  1. Using a web browser, navigate to: http://www.wampserver.com/en/download\-wampserver\-32bits/

  2. Download the appropriate version of WampServer

  3. Run the downloaded file
    If WampServer is installed on a server also running Internet Information Services further action should be taken:

  1. Start WampServer from the Start menu. The WampServer icon should then appear in green in the system tray.

  2. Click the WampServer icon, select Apache, and then Version, to see the Apache version, it should be similar to 2.2.17

  3. Locate the following file, if you are unable to locate it move to step 9 and take extra care:
    C:\wamp\bin\apache\Apache<version>\conf\httpd.conf.

  4. Make a backup copy of the httpd.conf file

  5. Click the WampServer icon, select Apache, and then httpd.conf
    A Notepad with the file contents should appear.

  6. Locate the line:

    Listen 80

  7. Make a copy of this line, comment the original line and rename the new line as follows:

    #Listen 80 Listen 8080

  8. Save and exit.

  9. Restart WampServer by clicking the WampServer icon and selecting Restart all services.
    Verify that no error messages are given

MySQL Security

As default MySQL server creates a user with all privileges.

For security purposes, please create a user relevant to your broadcast environment, and disable or set a password for the default root user.

This will also appear as an alert within MyPHPAdmin on this homepage during initial setup