...
| Code Block | ||
|---|---|---|
| ||
dbDriver=com.mysql.jdbc.Driver dbType=mysql dbHostname=localhost dbPort=33073308 dbName=uptime dbUsername=uptime dbPassword=uptime |
...
| Code Block | ||
|---|---|---|
| ||
#dbDriver=net.sourceforge.jtds.jdbc.Driver #dbType=mssql #dbHostname=10.1.1.124 #dbPort=1433 #dbName=uptime #dbUsername=uptime #dbPassword=password |
Similar steps should be taken to update the <uptime_dir>\controller\resources\uptime_controller.conf file.
Step 3 - Resetting the up.time DataStore
Reset the up.time DataStore settings to create the tables and default values required by up.time on your SQL Server database. To do this, first make sure the uptime data.collector service is Make sure the "up.time Data Collector" and "up.time Controller" services are stopped before run the following command on your up.time Monitoring Station:
| Note |
|---|
| This command will reset any existing up.time-specific database settings. Before running this command, ensure that the settings in the uptime.conf file are correct. |
| Code Block | ||
|---|---|---|
| ||
up.time_install_path/<uptime_dir>\resetdb really |
Step 4 - Restarting up.time
After the resetdb utility has finished updating your database settings, restart start the "up.time data.collector serviceData Collector" and "up.time Controller" services. When up.time starts, it will be running from your SQL Server database with an empty up.time installation.
...
Now that uptime is successfully started and running from your MS - SQL database, we no longer need to have the local mysql MySQL datastore. Which , which means that we can disable the unneeded service to free up some resources on the monitoring station itself.
This is done via the Window Services tool typically found in the 'Administrator Tools' section of the Start Menu or from within Computer/Server Management. You'll first want to locate and stop the 'up.time Data Store' service. Once the service is stopped, you'll need to right click on the service name, and select 'Properties' from the context menu. On the general tab of the window that opens, you should see a drop down menu for 'Startup type' that currently shows 'Automatic'. You'll want to change this option to 'Disabled' , and then click OK to save your changes.