Search:     Advanced search

Editing the GeoSystems Monitor UI Config for Microsoft Server Usage Database

Article ID: 332
Last updated: 21 Aug, 2018
Revision: 5
Views: 0

A config.json file will need to be edited to let the UI know that MySQL Server Usage Databases are being utilized.

1. Stop the GeoMonAppPool on the server under IIS Manager.

2. Navigate to the config.json file

This config.json file is located inside the config folder under the UI folder at the installation path.

Program Files (x86)/GeoSystemsMonitor/GeoMonUI_4.0.0/config   

Note: The default location path is Program Files (x86), yours may be different

Inside the config folder you should see config.json and config_mysql.json

config.json is the master file.

config_mysql.json is a template file that shows the required fields for MySQL setup.

3.  Rename config.json to config.json.backup for backup

4.  Rename config_mysql.json to config.json

5.  Open the newly renamed config.json file in a text editor. You should see the following:

{
  "development": {
    "dialect": "sqlite",
    "storage": "GeoMonEngine/MonitoringDB.db3",
    "logging": false
  },
  "history": {
    "dialect": "sqlite",
    "storage": "GeoMonEngine/GMonHistoryDB.db3",
    "logging": false
  },
  "ags": {
    "username": "YOUR_SQLSERVER_USERNAME",
    "password": "YOUR_SQLSERVER_PASSWORD",
    "database": "GeoMonAGSStats",
    "host":     "YOUR_SQLSERVER_HOST",
    "dialect":  "mssql",
    "logging": false
  },
   "license": {
    "username": "YOUR_SQLSERVER_USERNAME",
    "password": "YOUR_SQLSERVER_PASSWORD",
    "database": "GeoMonLicenseMgr",
    "host":     "YOUR_SQLSERVER_HOST",
    "dialect":  "mssql",
    "logging": false
  },
  "sde": {
    "username": "YOUR_SQLSERVER_USERNAME",
    "password": "YOUR_SQLSERVER_PASSWORD",
    "database": "GeoMonSDEUsage",
    "host":     "YOUR_SQLSERVER_HOST",
    "dialect":  "mssql",
    "logging": false
  },
  "install_location": "C:/Program Files (x86)/GeoSystemsMonitor/"
}

6.  Locate the "ags" and "sde" json objects.  You need to edit the YOUR_SQLSERVER_USERNAME, YOUR_SQLSERVER_PASSWORD, and YOUR_SQLSERVER_HOST placeholders to your environment.

7.  After you have done that, save the file.

8.  Start the GeoMonAppPool.

That's it, to check and make sure the UI is utilizing the MySQL Server Databases, go to the Charts and Reports page and click the "i" information button in the top right.

You should see your MySQL Databases now.

Prev   Next
Setting Up Microsoft SQL Server for License Manager Usage...     IIS Information