Users Guide

Securing MySQL Passwords | Completing Post-Installation Tasks

OMNM 6.5.3 Installation Guide 67

Securing MySQL Passwords

Secure MySQL passwords for all OMNM versions using the following steps to change the MySQL

root and application passwords. These procedures also prevent the MySQL root password from

being stored in configuration files and obviates MySQL root access by the application.

Stop web and application servers.

Change the MySQL root password.

This password is

not

stored in any application configuration files.

Example MySQL commands:

SET PASSWORD FOR 'root'@'%' = PASSWORD('SecretRootPassword');

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('SecretRootPassword');

Create a MySQL user “synergy” with access to ”synergy” and “lportal” databases.

Example MySQL commands:

CREATE USER 'synergy'@'%' IDENTIFIED BY 'SecretAppPassword';

GRANT ALL ON synergy.* TO 'synergy'@'%';

GRANT ALL ON lportal.* TO 'synergy'@'%';

Change the MySQL password used for application access by “oware” and “owmeta” users.

Example MySQL commands:

SET PASSWORD FOR 'oware'@'%cd2

SET PASSWORD FOR 'owmeta'@'%' = PASSWORD('SecretAppPassword');

Store the MySQL application credentials in the portal-ext.properties configuration file.

a. Open the following file:

.../oware/synergy/tomcat-7.0.40/webapps/ROOT/WEB-INF/classes/portal-

ext.properties

b. Update the following properties:

jdbc.default.username=synergy

jdbc.default.password=SecretAppPassword

Store MySQL application credentials in installed.properties configuration file.

a. Open the following file:

.../owareapps/installprops/lib/installed.properties

b. Add/update the following property:

com.dorado.jdbc.password=SecretAppPassword

Start web and application servers

Installing Third-Party Software

This section includes the installation of some third-party software used with the OpenManage

Network Manager (OMNM) application, such as:

•

Installing Acrobat Reader

•

Installing Perl