update IP address for OpenNMS host

gistfile1.sql

$ /etc/init.d/opennms stop

$ grep password /etc/opennms/opennms-datasources.xml

$ psql -h localhost -U opennms

-- -- --

\set AUTOCOMMIT off

\set OLD_IP '\'11.11.11.11\''
\set NEW_IP '\'22.22.22.22\''

\set OLD_HOST '\'11-11-11-11.foo.bar.net\''
\set NEW_HOST '\'22-22-22-22.foo.bar.net\''

\set NODE_ID '(select nodeid from ipinterface where ipaddr = :NEW_IP and iphostname = :NEW_HOST)'

update node
set nodelabel = :NEW_HOST
where nodeid = :NODE_ID
;

update ipinterface
set ipaddr = :NEW_IP, iphostname = :NEW_HOST
where nodeid = :NODE_ID
;

update ifservices
set ipaddr = :NEW_IP
where nodeid = :NODE_ID
;

update pathoutage
set criticalpathip = :NEW_IP
where criticalpathip = :OLD_IP
;

update snmpinterface
set ipaddr = :NEW_IP
where nodeid = :NODE_ID
;

commit;

-- -- --

$ /etc/init.d/opennms start