...
| Code Block | ||
|---|---|---|
| ||
dbDriver=com.mysql.jdbc.Driver dbType=mysql dbHostname=localhost dbPort=3307 dbName=uptime dbUsername=uptime dbPassword=uptime |
Just below the lines listed above, there is a second group of lines in the uptime.conf file that define how up.time will connect to a SQL Server database (see below). Remove the # character from the beginning of these lines and update the dbHost, dbPort, dbName, dbUsername and dbPassword to match the settings of your SQL Server database and the user that you created in Step 1.
| No Format |
|---|
#dbDriver=net.sourceforge.jtds.jdbc.Driver #dbType=mssql #dbHostname=10.1.1.124 #dbPort=1433 #dbName=uptime #dbUsername=uptime #dbPassword=password |
...
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 stopped before run the following command on your up.time monitoring station:
...
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. |
...
| No Format |
|---|
up.time_install_path/resetdb really |
Step 4 - Restarting up.time
After the resetdb utility has finished updating your database settings, restart the up.time data.collector service. When up.time starts, it will be running from your SQL Server database with an empty up.time installation.