Support

Knowledge Base  /  Frequently Asked Questions  /  Device ManageR (Legacy)

How To Configure MySQL For Use With Device ManageR

Device ManageR can log sensor and alert data to external databases, including MySQL, PostgreSQL and SQL Server. Follow the steps below to configure MySQL for use with Device ManageR.


Step 1: Run The MySQL Installer

Step 2: Set Up Your Database In The MySQL Workbench

Step 3: Set Up Device ManageR


Step 1: Run The MySQL Installer

1. Download and run the MySQL installer from https://www.mysql.com. In our example, we are using MySQL Community Edition.

2. When the License Agreement appears, select I accept the license terms, and then select Next.

ADM_MySQL_LicenseAgreement

3. In Choosing a Setup Type, select Custom. (We’re going to install only what we need for Device ManageR and nothing else.)

ADM_MySQL_ChoosingaSetupType

4. In Select Products and Features, select the version of MySQL Server and MySQL Workbench appropriate for your Windows operating system. (Use the right-facing arrow to move them from the Available Products box into the Products/Features To Be Installed box.) Then select Next.

ADM_MySQL_SelectProducts&Features

5. If the Check Requirements windows appearsselect Execute to attempt to resolve any failing requirements. Then select Next.

6. In Installation, select Execute. Wait for MySQL Server and MySQL Workbench to install. Once their status is Complete, select Next.

ADM_MySQL_Installation

7. In Product Configuration, select Next.

8. In Type and Networking, select Server Machine in the Config Type drop-down menu. Then select Next.

ADM_MySQL_Type&Networking

9. In Accounts and Roles, enter the “root” user’s password. If you wish, you may use Device ManageR with the “root” account.

ADM_MySQL_Accounts&Roles_Root

a. Typically, however, you’ll create a new account for Device ManageR to use. To do so, select Add User in the Accounts and Roles window.

ADM_MySQL_Accounts&Roles_AddUser

b. Enter the username and password, and select OK.

ADM_MySQL_MySQLUserDetails

c. Then select Next in the Accounts and Roles window.

11. In Windows Service, leave the defaults, and select Next.

ADM_MySQL_WindowsService

12. In Plugins and Extensions, leave the defaults, and select Next.

ADM_MySQL_Plugins&Extensions

13. In Apply Server Configuration, select Execute; then, once the configuration is complete, select Finish.

ADM_MySQL_ApplyServerConfiguration_Completed

15. In Product Configuration, select Next.

16. In Installation Complete, select Finish. The MySQL Workbench will launch.

Step 2: Set Up Your Database In The MySQL Workbench

1. When the MySQL Workbench opens, right-click on the grey Local Instance box. Select Edit Connection from the drop-down menu that appears.

ADM_MySQL_Workbench_Edit

2. In Manage Server Connections, enter the username you created earlier in the Username field. (You can also use the MySQL “root” user if you prefer.) Then select Close.

ADM_MySQL_Workbench_ManageServerConnections_ITManager

5. Select the grey Local Instance box. When the Connect to MySQL Server dialog box appears, enter the user’s password. Then select OK.

ADM_MySQL_Workbench_ConnecttoMySQLServer

7. When the MySQL Workbench window opens, select the Create new schema button. (“Schema” is MySQL’s term for “database.”)

a. In Name, enter a name for your database in all lower-case letters. We’re going to call ours “devicedb.”

b. Select Apply.

ADM_MySQL_Workbench_DeviceDB

8. In the Review SQL Script window that appears, select Apply.

9. In Apply SQL Script, select Finish.

Step 3: Set Up Device ManageR

1. Open Device ManageR in your web browser. You may open it by entering ‘localhost:8080’ or ‘<IP address of host system>:8080’ in your browser’s address bar.

2. Select Settings in the navigation bar to the left.

3. In the Settings menu, select Advanced.

4. In Database Settings, follow these steps:

a. In Database Type, select MySQL.

b. If Device ManageR and MySQL are installed on the same computer, leave “localhost” in Host Name or IP Address, as we have in our example. Otherwise, enter MySQL’s hostname or IP address.

c. In Database Name, enter the name you gave your MySQL database in earlier steps. Our example is called “devicedb” (in all lowercase letters).

d. In Database Port, enter your MySQL database port. The default for MySQL is 3306, which is what we retained in our example.

e. In Database Username, enter the username you created earlier. In our example, our username is “ITManager.”

f. In Database Password, enter the password you gave to that username.

ADM_Settings_Advanced_DatabaseSettings

5. Select Save Settings.

6. The Export Logged Database Data dialog box will appear, asking if you’d like to export your currently-logged data to your new MySQL database.

ADM_Settings_Advanced_DatabaseSettings_ExportDatabaseData

a. If you do want to export your existing data, select Export.

– When the confirmation message appears, select OK.

ADM_Settings_Advanced_DatabaseSettings_ExportDataConfirmation

– You’ll see progress bars at the top of the Device ManageR window showing the progress of the export. Depending on the size of your existing database, the export can take from a few minutes to up to several hours.

ADM_Settings_Advanced_DatabaseSettings_ExportProgressBars

b. If you don’t want to export your existing data, select Save Settings. You’ll start fresh with an empty MySQL database.

Note that you can test Device ManageR’s connection to your MySQL database any time (after you save your settings) by selecting Test Database Connection.

Facebooktwitterredditpinterestlinkedinmail
Room Alert is Made in the USA, ships worldwide from our locations in the US and EU, and has been protecting facilities since 1988.

You may find Windows Command Prompt at the following path:

  • Windows 7 & 8
    Start--> All Programs--> Accessories--> Command Prompt
  • Windows 10
    Start--> All Apps--> Windows System--> Command Prompt

To run Windows Command Prompt as an administrator:

  • Windows 7 & 8
    Right-click on Command Prompt and select Run as administrator.
  • Windows 10
    Right-click on Command Prompt, select More and then select Run as administrator.

Example Polling Method Properties saved in Orion SolarWinds:

If you are using this client, you should configure the general SNMPv3 Credentials, but leave the Read / Write SNMPv3 Credentials section blank.

Room Alert Link- Supported Firmware Updates



Current S modelsCurrent E models
Room Alert 32SRoom Alert 32E
Room Alert 12SRoom Alert 12E
Room Alert 4E
Room Alert 3E

Room Alert Manager - Compatible Devices

The latest version of Room Alert Manager supports only the devices below.

It does not support any legacy Room Alert or TemPageR models.

Current S modelsCurrent E models
Room Alert 32SRoom Alert 32E
Room Alert 12SRoom Alert 12E
Room Alert 3SRoom Alert 4E
Room Alert 3E
Room Alert 3W