Page History

...

1. On the UIM monitoring station, open a terminal or command prompt and navigate to the UIM directory <uptime_dir>.
2. From within the <uptime_dir>, navigate to the mysql/bin directory.
3. Run the following command to connect to the Uptime Infrastructure Monitor datastore as the root user:
   

   Code Block
   language sql
   mysql -uroot -puptimerocks

4. Once connected to the database, run the below grant statement. This statement will allow the Uptime Infrastructure Monitor user to connect to the database from any external host, so for additional security you can replace the % symbol with the IP address or hostname of the reporting instance
   

   Code Block
   language sql
   grant all privileges on uptime.* to "uptime"@"%" identified by "uptime";

Increasing the max_connections on the bundled mysql instance:

1. On the Monitoring Station, navigate to the <uptime_dir>/mysql directory and open the my.ini file.
2. Find the below line "max_connections=110" in the file and change it to:
   

   Code Block
   language sql
   max_connections=160

3. After saving these changes, restart the 'uptime_datastore' service to pick-up the changes made to the my.ini file.