Owners Manual

New Features/Devices Supported in 6.2 Service Pack 3 17
sudo iptables -D INPUT 7-p tcp --dport 3306 -j ACCEPT
sudo iptables -A INPUT -p tcp --dport 3306 -s localhost -j ACCEPT
sudo iptables -A INPUT -p tcp --dport 3306 -s synergy.domain.int -j
ACCEPT
sudo iptables -A INPUT -p tcp --dport 3306 -j DROP
sudo service iptables save
• MySQL passwords are not secure. (30777)
Workaround: 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.
1. Stop web and application servers.
2. 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');
3. 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'@'%';
4. Change the MySQL password used for application access by “oware” and
“owmeta” users.
Example MySQL commands:
SET PASSWORD FOR 'oware'@'%' = PASSWORD('SecretAppPassword');
SET PASSWORD FOR 'owmeta'@'%' = PASSWORD('SecretAppPassword');
5. 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
6. 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
7. Start web and application servers