From OpenNMS

Administration Notes, Tips, Etc. (rdk)

Moving my ONMS from One System to Another

I'm constantly monkeying with my infrastructure and swaping boxes in and out. Consequently, I need to move my ONMS installation around. This item tells how to move the DB. To move the rest of the info, I simply tar up my ONMS dir and move it to the new machine.

FAQ-Install#Q:_How_do_I_migrate_OpenNMS_from_one_server_to_another.3F

Deleting Outage Events Directly from the DB

I wedged my ONMS DB via repeated hard reboots due to a network/hardware problem. I needed to delete some outage events directly from my db. Here is how I did it.

1. Identify the outage IDs via ONMS console
2. shutdown ONMS (but leave DB running)

3. # su - postgres

4. % psql

5. \c opennms

6. DELETE FROM outages WHERE outageid=X;

Alternately, if you don't want to delete the record of the outage, you can use the following SQL command instead of the DELETE statement above.

UPDATE outages SET ifregainedservice = NOW() WHERE outageid = X;

Using a Pre-existing Private Key and Certificate

I find the whole keystore approach a royal pain. I obtain SSL keys via CAcert.org in PEM format and then try to roll them into a Java keystore. Here is how I do this.

Standalone_HTTPS_with_Jetty#Using_a_Pre-existing_Private_Key_and_Certificate