Importing the new database schema

Starting with Watch4net 6.2u4, schema are preloaded. If you installed from an earlier version, import the new database schema.

Prerequisites

Procedure

1. Load the events block file Event-Processing/Generic-Live-Writer/cisco-ucs/ddl/my-ucs_live.sql.
2. Run mysql-client.sh (mysql-client.cmd on Windows).
3. Type username, database name, and password.
4. Copy the contents of the /my-ucs_live.sql file and paste it into the mysql client at the mysql> prompt.
   This creates the ucs_live table.
5. Start the event processing manager service.
6. To enable events reporting from the frontend:
   1. Edit the Web-Application configuration file Web-Servers/Tomcat/Default/conf/Catalina/localhost/APG.xml.
   2. If the cisco-ucs-events section is present, uncomment it.
   3. If the cisco-ucs-events section is missing, add the following lines:

      <!-- cisco-ucs-events --> 
      <ResourceLink name="jdbc/FLOW-UCS-LIVE:{ mapping=FLOW-UCS.xml, table=ucs_live
       }" global="jdbc/FLOW-EVENTS" type="javax.sql.DataSource" />

7. Restart the tomcat service.