Summary

This document describes how to setup and configure a Meridix installation targeting a Zylinc system.

Meridix applications

Meridix web UI – MXWU

A Microsoft .NET 4.5.2 ASP.NET IIS hosted web application. Is installed and updated with a WebDeploy package.
This application will use the Zylinc Stat DB as the data source for statistics data and will therefor need to be able to access a couple of stored procedures (spmeridix_*) to get the data directly from the Stat DB.
It also make use of a dedicated system database that manages Meridix logins, saved reports etc. and will preferably be hosted side by side with the other Zylinc databases (in the same MSSQL instance) but can also be hosted on a different MSSQL instance if desirable.

Meridix backend service – MXBS

A Microsoft .NET 4.5 Windows service application that handles all scheduled tasks such as report distributions, maintenance, cache population etc.
Same database access requirements against the Zylinc database as MXWU.
Is installed and updated with a MSI package.

Meridix Zylinc catalog synchronization client – MXZSC

An application that handles the synchronization of catalog data from the Zylinc database (master) to the Meridix system (slave).
The application executes SQL commands against a pair of views in the Zylinc Stat DB (meridix_queues, meridix_users, meridix_ivrs) and interprets the data and converts it to a format that can be synchronized into MWU through its HTTP Web API. This application must be scheduled to run at desired times ex: with Windows task scheduler or any other means of scheduling execution of applications.
Is installed and updated with a xcopy operation (i.e. copy the files to a folder manually).

Meridix sys database – MXSDB

This MSSQL database contains all the Meridix application specific information like logins, saved reports etc. no actual report data is stored in this database.
The database and the sql server authentication login are created manually and the schema is created/updated automatically by the application.
The user need to have db_owner rights granted.

Prerequisites

MXWU, MXBS and MXZSC needs to be installed on a Windows Server 2012 or later with .NET Framework 4.5.2 installed. Recommended minimum hardware are 4 CPU Cores and 8 GB RAM. The server need to have network access to the Microsoft SQL Server-server that host the ZyProdDB and the ZyStatDB.

MXSDB needs to be hosted on an Microsoft SQL Server 2012 or later (Express, Web, Standard or Enterprise edition). The recommended approach is to host it on the same MSSQL server as ZyProdDB and ZyStatDB. If no existing database server exist it can be installed side by side with the other Meridix applications (Not recommended for production systems).

The target ZyProdDB need to contain the views meridix_queues, meridix_agents, meridix_ivrs and meridix_users. The ZyStatDB need to have the latest version of the meridix stored procedures and functions which currently is provided through the sql file Zylinc_statdb_meridix_database_objects.sql located in the release_base folder. (This will be handled included in Zylincs main distribution in the future).

How to get the Meridix software

The latest Meridix software is available on Meridix partner SFTP server sftp://partner-share.meridix.se:22

1. Log in on sftp://partner-share.meridix.se:22 with a SFTP client using Zylincs username and password.
2. Download all content from the sub folder with the latest release date (format release_20170101) and the folder release_base and transfer it to the target server(s).

Install a new system

1. Create an empty database named meridix_sys on the MSSQL server that should host the MXSDB. Also create
   1. Create a SQL Server Authentication login and user with db_owner rights on the meridix_sys database.
2. Install Internet Informations Service (IIS) with the Web Server (IIS) - Role 
   1. Make sure ASP.NET 4.5/4.6 Feature is installed.
3. Install Microsoft .NET 4.5.2 or later (https://www.microsoft.com/net/download/framework)
4. Install IIS Web Deploy 3.5 or later (included in the release_base folder or http://www.iis.net/downloads/microsoft/web-deploy)
5. Create an IIS Site named
   1. Set the site name to Meridix (can be named differently)
   2. Set the physical path to (drive):\meridix\webapp
6. Unzip the file VERSION_AND_DATE_meridix_studio_webdeploy_package.zip into a folder on the server called _webdeploypackage.
7. Edit the BAT file included in release_base called deploy_webpackage.bat with a text editor (e.g. Notepad++/Notepad)
   1. Replace the placeholder PATH_HERE with the full rooted path to the _webdeploypackage folder created in step 6.
   2. Replace the placeholder NAME_HERE with the IIS Site name (default: Meridix) created in step 5.a.
   3. Save the updated bat file.
8. Execute the the deploy_webpackage.bat file with administrator rights (right click and click Run as administrator).
9. Open the web application folder (defined in step 5.b)
   1. Rename the file NOT_SET.basic.config to basic.config
   2. Open basic.config in a text editor and change the following settings
      
      1. Change the connection string to target the meridix_sys database created in step 1 using the SQL Server Authentication login created in step 1.a.
      2. Define a unique application id (Meridix.Studio.Application.Id) - Can be any value but should be system unique e.g. companyx.reporting etc.
      3. Set  Zylinc_ZylincModuleContainer as the value for the key Meridix.Studio.Enabled.Exchanges.
10. Open a web browser and browse to the site created in step 5.
    1. The first time the application is started it might take a couple of minutes before it loads due to internal initialization operations, database schema updates etc.
    2. If everything works as expected a login page will be loaded - Log in with the default credentials U: admin@meridix.se and P: ppn
       If you get an error message open the App_Data/Logs folder under the web application folder and review the logs for more information about the error.
11. Once logged in the system must be Zylinc branded which is achieved by applying the Zylinc theme package.
    1. In the web UI go to System administration → Theme settings
    2. Upload the Zylinc_theme_pack_1_0_1.zip found in the release_base folder (the theme upload section is found at the bottom of the page)
    3. Change the Theme name to Zylinc_theme_pack_1_0_1 and make sure the Theme package type is set to Theme package.
    4. Click save and hit Ctrl+Shift+R to make sure the new theme package content is loaded. (If that does not work, clear the browser cache manually).
    5. The UI should now have a Zylinc look and feel instead of the default Meridix theme.
12. Configure the system by navigating to System administration → Application settings
    1. Define the System location (a descriptive name e.g. Zylinc Reports) - This value will be used in initialization e-mails etc. to identify the system for end-users.
    2. Set the System public URL to the public/internal URI that the end-user will access the system through.
    3. Configure the SMTP server settings to use. Will be used for user initialization e-mails, report distribution etc.
    4. Verify that the security settings comply with the customers policy (minimum password lengths etc.).
13. Enable the Zylinc module by navigation to System administration → Module settings
    1. Expand the Zylinc section and check both the Loaded and Enabled checkboxes.
    2. Define the connection string against the ZyStatDB that should be used as the report data source.

Upgrade an existing system