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.
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).
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
Create an empty database named meridix_sys on the MSSQL server that should host the MXSDB. Also create a SQL Server Authentication login and user with db_owner rights on the meridix_sys database.
Install Internet Informations Service (IIS) with the Web Server (IIS) - Role