Database schema
The Management Station uses a database to store operational and system configuration information collected from managed hosts. This data includes imported call log files, utterances, vital signs, and alarms generated by services and components. The data is stored under the mysql_installation_path\mserver directory. For a typical MySQL installation, the default location is:
- Windows: C:\ProgramData\MySQL\MySQL Server x.x\data\mserver
- Linux: /var/lib/mysql/mserver
The Management Station uses this data to generate the reports provided through the system analysis features. You can access the database contents yourself to create reports other than those provided by the Management Station.
The following topics describe in detail the Management Station database schema used to store the data collected by the Management Station:
- The above topics assume you are familiar with data management features and with the basic tenets of relational databases and SQL programming.
- The Management Station database is used exclusively for operational purposes. Do not add user-defined tables to it or use it for application-specific data. Doing so might cause performance problems.
Read-only access
Optionally, you can create a reporting user that allows read-only access to all tables.
Simply run add-report-user from the %MSTATION_HOME%\scripts directory:
> Nuance_path\mstation\scripts>add-report-user userpasswordreport_user_password
Where:
- user is an existing database user with grant privileges, for example, the root user
- password is that user’s password or the character, -, if there is no password
- report_user_password is the password for the new ms_report account the script creates
The script generates the ms_report account in the mserver database, which contains the tables for call analysis and system performance reports. You only need to run this script once. The created account is preserved when you upgrade your Nuance product.
