Avaya Inc. – External Distribution
6.3.2 Installation completes successfully, but after launching IPFM
Dashboard user gets error message dialog with
"PersistenceException" and/or "Device Error".
IPFM database creation did not complete successfully during installation. Most probable reason is
password for MySQL root user was not entered correctly.
Note that initially both the UCM admin user password and MySQL root user password are same.
But user can always change UCM admin user password using UCM UI which does not change
the MySQL root user password. Thus, if user changes UCM admin user password and then
installs IPFM as a member UCM application, user must need to provide MySQL root user
password during IPFM installation, not the updated UCM admin user password.
To verify that the IPFM database was created successfully, user needs to open a console window
and go to MySQL/bin directory. Generally this directory can be located at:
For Windows C:\Program Files\MySQL\MySQL Server 5.1\bin
For RHEL /opt/mysql/bin
Login to MySQL as "root" and run the SQL command: "show databases;". There must be an
entry: "ipfm". Execute the following 2 SQL commands at the SQL prompt:
use ipfm;
show tables;
On SQL prompt user should see 37 table entries.
To recreate IPFM database, user needs to
Stop "UCM JBoss service" and "IPFM Collector Service".
Open a console window and go to MySQL/bin directory (see above).
Login to MySQL as "root" and run the following 3 SQL commands:
DROP DATABASEIF IF EXISTS ipfm;
CREATE DATABASE ipfm;
GRANT ALL privileges ON ipfm.* to 'eccuser'@'localhost'
identified by 'eccpassword' with grant option;
Open a console window and go to IPFM Collector directory. Generally this directory can
be located at:
For Windows C:\Program Files\Nortel\UCM\IPFM\ipfix_collector
For RHEL /opt/nortel/ucm/ipfm/ipfix_collector
Execute the following command to create IPFM tables
For Windows collectorCtrl.bat recreatedb
For RHEL ./collectorCtrl.sh recreatedb
Restart UCM JBoss service and wait for few minutes for JBoss initialization to complete
successfully.
Restart IPFM Collector Service.