1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>
Image 1

WE Solutions / Our services

  • Previous
  • Next
  • Stop
  • Play

SAMBA/LDAP

Thin Client Server

Postfix Mail Server

Postfix Mail Server

HA Clustering


Warning: Parameter 3 to mb_videobot() expected to be a reference, value given in /home/www/virtual/susethailand.com/htdocs/libraries/joomla/event/dispatcher.php on line 136

OpenNMS

PDF Print E-mail

Written by Mr. Sontaya Photibut Friday, 12 June 2009 00:00

Article Index
OpenNMS
Using openNMS
All Pages

ติดตั้ง OpenNMS บน openSUSE 11.1 (Enterprise Grade Network Management)

Adding Repository (from YaST)
Repository Name: opennms
URL: http://yum.opennms.org/stable/suse10/





Install PostgreSQL & Tomcat6
- install “PostgreSQL” from YaST
- postresql
- postresql-devel
- postresql-server
- tomcat
- gcc
- gcc-c++




Configure Database
$ vi /var/lib/pgsql/data/pg_hba.conf
- change "ident sameuser" to "trust":

#:Default
# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          ident sameuser
# IPv6 local connections:
host    all         all         ::1/128               ident sameuser

#:Change
# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32            trust
# IPv6 local connections:
host    all         all         ::1/128                     trust
host    all         all         192.168.0.0/16        trust


$ vi /var/lib/pgsql/data/postgresql.conf
- change "max_connections, shared_buffers"
max_connections = 256
shared_buffers = 1024

$ rcpostgresql start
$ rcpostgresql stop


Install IPLIKE, JAVA, JDK, JICMP, LAMP
- install from YaST








Install JDK (Additional)
Download: ftp://ftp.pbone.net/mirror/ftp.turbolinux.com/pub/TurboLinux/stable/untested/Desktop/10/i586/jdk-1_5_0-linux-i586.rpm

$ rpm -ivh jdk-1_5_0-linux-i586.rpm
warning: jdk-1_5_0-linux-i586.rpm: Header V3 DSA signature: NOKEY, key ID f6354a6d
Preparing...                ########################################### [100%]
   1:jdk                    ########################################### [100%]


Install openNMS (opennms-core)
Download : http://sourceforge.net/project/showfiles.php?group_id=4141&package_id=4151


$ rpm -ivh opennms-core-1.6.2-1.noarch.rpm
Preparing...                ########################################### [100%]
   1:opennms-core           ########################################### [100%]
- making symlink for /opt/opennms/logs... done
- making symlink for /opt/opennms/share... done
- moving *.sql.rpmnew files (if any)... done
- checking for old update files... done

 *** Installation complete.  You must still run the installer and
 *** make a few other changes before you start OpenNMS.  See the
 *** install guide and release notes for details.

$ rpm -ivh opennms-webapp-jetty-1.6.2-1.noarch.rpm
Preparing...                ########################################### [100%]
   1:opennms-webapp-jetty   ########################################### [100%]

$ rpm -ivh opennms-1.6.2-1.noarch.rpm
Preparing...                ########################################### [100%]
   1:opennms                ########################################### [100%]


Configure Java for OpenNMS
$ /opt/opennms/bin/runjava -s
:Output
runjava: Looking for an appropriate JRE...
runjava: Checking for an appropriate JRE in JAVA_HOME...
runjava: /usr/lib/jvm/java/bin/java is not a Sun JVM and only Sun JVMs are supported.
runjava: You can use the '-f' option to ignore this check, but you will be on your own for support.
runjava: "/usr/lib/jvm/java/bin/java" is not an appropriate JRE
runjava: Checking JRE in user's path: "/usr/bin/java"...
runjava: /usr/bin/java is not a Sun JVM and only Sun JVMs are supported.
runjava: You can use the '-f' option to ignore this check, but you will be on your own for support.
runjava: did not find an appropriate JRE in user's path: "/usr/bin/java"
runjava: searching for a good JRE...
runjava: found a good JRE in "/usr/java/jdk1.5.0/bin/java"
runjava: value of "/usr/java/jdk1.5.0/bin/java" stored in configuration file


Install PostgreSQL Database

$ /opt/opennms/bin/install -disU
==============================================================================
OpenNMS Installer Version $Id: Installer.java 11800 2009-01-11 23:04:48Z dhustace $
==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.

- searching for jicmp:
  - trying to load /usr/lib/libjicmp.so: OK
- searching for jrrd:
  - trying to load /usr/lib/libjrrd.so: NO
  - trying to load /usr/java/jdk1.5.0/jre/lib/i386/client/libjrrd.so: NO
  - trying to load /usr/java/jdk1.5.0/jre/lib/i386/libjrrd.so: NO
  - trying to load /usr/java/jdk1.5.0/jre/../lib/i386/libjrrd.so: NO
  - trying to load /usr/lib/mpi/gcc/openmpi/lib/libjrrd.so: NO
  - trying to load /opt/opennms/lib/libjrrd.so: NO
  - trying to load /usr/lib/jni/libjrrd.so: NO
  - trying to load /usr/lib/libjrrd.so: NO
  - trying to load /usr/local/lib/libjrrd.so: NO
  - trying to load /opt/NMSjicmp/lib/32/libjrrd.so: NO
  - trying to load /opt/NMSjicmp/lib/64/libjrrd.so: NO
- Failed to load the optional jrrd library.
  - This error is not fatal, since jrrd is only required for optional features.
  - For more information, see http://www.opennms.org/index.php/jrrd
- checking database version... 8.3
  - Full version string: PostgreSQL 8.3.5 on i686-pc-linux-gnu, compiled by GCC gcc (SUSE Linux) 4.3.2 [gcc-4_3-branch revision 141291]
* using 'opennms' as the PostgreSQL user for OpenNMS
* using 'opennms' as the PostgreSQL password for OpenNMS
* using 'opennms' as the PostgreSQL database name for OpenNMS
- using SQL directory... /opt/opennms/etc
- using create.sql... /opt/opennms/etc/create.sql
- creating database 'opennms'... DONE- checking if database "opennms" is unicode... ALREADY UNICODE
- checking database for old backup tables... NONE
- checking for rows that violate constraints...
  - checking for rows that violate constraint 'fk_dpname'... DONE
  - checking for rows that violate constraint 'fk_nodeid2'... DONE
  - checking for rows that violate constraint 'fk_nodeid1'... DONE
  - checking for rows that violate constraint 'snmpinterface_fkey2'... DONE
  - checking for rows that violate constraint 'fk_nodeid3'... DONE
  - checking for rows that violate constraint 'fk_serviceid1'... DONE
  - checking for rows that violate constraint 'ipinterface_fkey'... DONE
  - checking for rows that violate constraint 'fk_eventid1'... DONE
  - checking for rows that violate constraint 'fk_eventid2'... DONE
  - checking for rows that violate constraint 'fk_nodeid4'... DONE
  - checking for rows that violate constraint 'fk_serviceid2'... DONE
  - checking for rows that violate constraint 'ifservices_fkey1'... DONE
  - checking for rows that violate constraint 'ifservices_fkey2'... DONE
  - checking for rows that violate constraint 'fk_eventid3'... DONE
  - checking for rows that violate constraint 'fk_nodeid7'... DONE
  - checking for rows that violate constraint 'fk_notifid2'... DONE
  - checking for rows that violate constraint 'fk_eventidak2'... DONE
  - checking for rows that violate constraint 'fk_alarmid1'... DONE
  - checking for rows that violate constraint 'fk_nodeid5'... DONE
  - checking for rows that violate constraint 'categoryid_fkey1'... DONE
  - checking for rows that violate constraint 'nodeid_fkey1'... DONE
  - checking for rows that violate constraint 'fk_nodeid8'... DONE
  - checking for rows that violate constraint 'fk_demandpollid'... DONE
  - checking for rows that violate constraint 'location_monitor_fkey1'... DONE
  - checking for rows that violate constraint 'ifservices_fkey4'... DONE
  - checking for rows that violate constraint 'location_monitor_fkey2'... DONE
  - checking for rows that violate constraint 'applicationid_fkey1'... DONE
  - checking for rows that violate constraint 'ifservices_fkey3'... DONE
  - checking for rows that violate constraint 'fk_ia_nodeid1'... DONE
  - checking for rows that violate constraint 'fk_ia_nodeid8'... DONE
  - checking for rows that violate constraint 'fk_ia_nodeid2'... DONE
  - checking for rows that violate constraint 'fk_ia_nodeid3'... DONE
  - checking for rows that violate constraint 'fk_ia_nodeid4'... DONE
  - checking for rows that violate constraint 'fk_ia_nodeid5'... DONE
  - checking for rows that violate constraint 'fk_ia_nodeid6'... DONE
  - checking for rows that violate constraint 'fk_ia_nodeid7'... DONE
  - checking for rows that violate constraint 'fk_mapid'... DONE
  - checking for rows that violate constraint 'fk_statsdata_reportid'... DONE
  - checking for rows that violate constraint 'fk_statsdata_resourceid'... DONE
  - checking for rows that violate constraint 'fk_qrtz_job_listeners'... DONE
  - checking for rows that violate constraint 'fk_qrtz_triggers'... DONE
  - checking for rows that violate constraint 'fk_qrtz_simple_triggers'... DONE
  - checking for rows that violate constraint 'fk_qrtz_cron_triggers'... DONE
  - checking for rows that violate constraint 'fk_qrtz_blob_triggers'... DONE
  - checking for rows that violate constraint 'fk_qrtz_trigger_listeners'... DONE
- checking for rows that violate constraints... DONE
- creating sequences...
  - checking "opennmsNxtId" sequence... DOES NOT EXIST
    - creating sequence "opennmsNxtId"... OK
    - granting access to 'opennmsNxtId' for user 'opennms'... DONE
  - checking "nodeNxtId" sequence... DOES NOT EXIST
    - creating sequence "nodeNxtId"... OK
    - granting access to 'nodeNxtId' for user 'opennms'... DONE
  - checking "serviceNxtId" sequence... DOES NOT EXIST
    - creating sequence "serviceNxtId"... OK
    - granting access to 'serviceNxtId' for user 'opennms'... DONE
  - checking "eventsNxtId" sequence... DOES NOT EXIST
    - creating sequence "eventsNxtId"... OK
    - granting access to 'eventsNxtId' for user 'opennms'... DONE
  - checking "alarmsNxtId" sequence... DOES NOT EXIST
    - creating sequence "alarmsNxtId"... OK
    - granting access to 'alarmsNxtId' for user 'opennms'... DONE
  - checking "outageNxtId" sequence... DOES NOT EXIST
    - creating sequence "outageNxtId"... OK
    - granting access to 'outageNxtId' for user 'opennms'... DONE
  - checking "notifyNxtId" sequence... DOES NOT EXIST
    - creating sequence "notifyNxtId"... OK
    - granting access to 'notifyNxtId' for user 'opennms'... DONE
  - checking "vulnNxtId" sequence... DOES NOT EXIST
    - creating sequence "vulnNxtId"... OK
    - granting access to 'vulnNxtId' for user 'opennms'... DONE
  - checking "catNxtId" sequence... DOES NOT EXIST
    - creating sequence "catNxtId"... OK
    - granting access to 'catNxtId' for user 'opennms'... DONE
  - checking "userNotifNxtId" sequence... DOES NOT EXIST
    - creating sequence "userNotifNxtId"... OK
    - granting access to 'userNotifNxtId' for user 'opennms'... DONE
  - checking "demandPollNxtId" sequence... DOES NOT EXIST
    - creating sequence "demandPollNxtId"... OK
    - granting access to 'demandPollNxtId' for user 'opennms'... DONE
  - checking "pollResultNxtId" sequence... DOES NOT EXIST
    - creating sequence "pollResultNxtId"... OK
    - granting access to 'pollResultNxtId' for user 'opennms'... DONE
  - checking "mapNxtId" sequence... DOES NOT EXIST
    - creating sequence "mapNxtId"... OK
    - granting access to 'mapNxtId' for user 'opennms'... DONE
  - checking "reportNxtId" sequence... DOES NOT EXIST
    - creating sequence "reportNxtId"... OK
    - granting access to 'reportNxtId' for user 'opennms'... DONE
- creating sequences... DONE
- adding PL/pgSQL call handler... OK
- adding PL/pgSQL language module... OK
- adding stored procedures...
  - getManagePercentAvailIntfWindow.sql... OK
  - getManagedServiceCountForNode.sql... OK
  - getManagedOutageForNodeInWindow.sql... OK
  - getPercentAvailabilityInWindow.sql... OK
  - setIfServiceKeysOnInsertTrigger.sql... OK
  - getManagedOutageForIntfInWindow.sql... OK
  - setSnmpInterfaceKeysOnUpdateTrigger.sql... OK
  - setIpInterfaceKeysOnUpdateTrigger.sql... OK
  - getManagePercentAvailNodeWindow.sql... OK
  - setIfServiceKeysOnUpdateTrigger.sql... OK
  - getOutageTimeInWindow.sql... OK
  - getManagedServiceCountForIntf.sql... OK
  - setSnmpInterfaceKeysOnInsertTrigger.sql... OK
  - setIpInterfaceKeysOnInsertTrigger.sql... OK
- creating tables...
  - checking table "serverMap"...
  - checking table "servermap"... CREATED
    - checking index 'server_name_idx' on this table... DONE
  - granting access to 'servermap' for user 'opennms'... DONE
  - checking table "serviceMap"...
  - checking table "servicemap"... CREATED
    - checking index 'servicemap_name_idx' on this table... DONE
    - checking index 'serviceMap_ipaddr_idx' on this table... DONE
  - granting access to 'servicemap' for user 'opennms'... DONE
  - checking table "distPoller"...
  - checking table "distpoller"... CREATED
  - granting access to 'distpoller' for user 'opennms'... DONE
  - checking table "node"...
  - checking table "node"... CREATED
    - checking index 'node_id_type_idx' on this table... DONE
    - checking index 'node_label_idx' on this table... DONE
    - checking index 'node_dpname_idx' on this table... DONE
    - checking index 'node_foreign_unique_idx' on this table... DONE
  - granting access to 'node' for user 'opennms'... DONE
  - checking table "snmpInterface"...
  - checking table "snmpinterface"... CREATED
    - checking index 'snmpinterface_nodeid_ifindex_unique_idx' on this table... DONE
    - checking index 'snmpinterface_nodeid_idx' on this table... DONE
    - checking index 'snmpinterface_ipaddr_idx' on this table... DONE
  - granting access to 'snmpinterface' for user 'opennms'... DONE
  - checking table "ipInterface"...
  - checking table "ipinterface"... CREATED
    - checking index 'ipinterface_nodeid_ipaddr_notzero_idx' on this table... DONE
    - checking index 'ipinterface_nodeid_ipaddr_ismanaged_idx' on this table... DONE
    - checking index 'ipinterface_ipaddr_ismanaged_idx' on this table... DONE
    - checking index 'ipinterface_ipaddr_idx' on this table... DONE
    - checking index 'ipinterface_nodeid_ismanaged_idx' on this table... DONE
    - checking index 'ipinterface_nodeid_idx' on this table... DONE
    - checking index 'ipinterface_snmpInterfaceId_idx' on this table... DONE
    - checking trigger 'setSnmpInterfaceKeysOnUpdateTrigger' on this table... DONE
    - checking trigger 'setSnmpInterfaceKeysOnInsertTrigger' on this table... DONE
  - granting access to 'ipinterface' for user 'opennms'... DONE
  - checking table "service"...
  - checking table "service"... CREATED
  - granting access to 'service' for user 'opennms'... DONE
  - checking table "ifServices"...
  - checking table "ifservices"... CREATED
    - checking index 'ifservices_nodeid_ipaddr_svc_unique' on this table... DONE
    - checking index 'ifservices_nodeid_ipaddr_status' on this table... DONE
    - checking index 'ifservices_nodeid_status' on this table... DONE
    - checking index 'ifservices_nodeid_idx' on this table... DONE
    - checking index 'ifservices_serviceid_idx' on this table... DONE
    - checking index 'ifservices_nodeid_serviceid_idx' on this table... DONE
    - checking index 'ifservicves_ipInterfaceId_idx' on this table... DONE
    - checking trigger 'setIpInterfaceKeysOnUpdateTrigger' on this table... DONE
    - checking trigger 'setIpInterfaceKeysOnInsertTrigger' on this table... DONE
  - granting access to 'ifservices' for user 'opennms'... DONE
  - checking table "events"...
  - checking table "events"... CREATED
    - checking index 'events_uei_idx' on this table... DONE
    - checking index 'events_nodeid_idx' on this table... DONE
    - checking index 'events_ipaddr_idx' on this table... DONE
    - checking index 'events_serviceid_idx' on this table... DONE
    - checking index 'events_time_idx' on this table... DONE
    - checking index 'events_severity_idx' on this table... DONE
    - checking index 'events_log_idx' on this table... DONE
    - checking index 'events_display_idx' on this table... DONE
    - checking index 'events_ackuser_idx' on this table... DONE
    - checking index 'events_acktime_idx' on this table... DONE
    - checking index 'events_alarmid_idx' on this table... DONE
    - checking index 'events_nodeid_display_ackuser' on this table... DONE
  - granting access to 'events' for user 'opennms'... DONE
  - checking table "outages"...
  - checking table "outages"... CREATED
    - checking index 'outages_nodeid_ipaddr_svc_idx' on this table... DONE
    - checking index 'outages_svclostid_idx' on this table... DONE
    - checking index 'outages_svcregainedid_idx' on this table... DONE
    - checking index 'outages_nodeid_idx' on this table... DONE
    - checking index 'outages_serviceid_idx' on this table... DONE
    - checking index 'outages_ipaddr_idx' on this table... DONE
    - checking index 'outages_regainedservice_idx' on this table... DONE
    - checking index 'outages_ifServivceId_idx' on this table... DONE
    - checking trigger 'setIfServiceKeysOnInsertTrigger' on this table... DONE
    - checking trigger 'setIfServiceKeysOnUpdateTrigger' on this table... DONE
  - granting access to 'outages' for user 'opennms'... DONE
  - checking table "vulnerabilities"...
  - checking table "vulnerabilities"... CREATED
    - checking index 'vulnerabilities_nodeid_idx' on this table... DONE
    - checking index 'vulnerabilities_ipaddr_idx' on this table... DONE
    - checking index 'vulnerabilities_severity_idx' on this table... DONE
    - checking index 'vulnerabilities_port_idx' on this table... DONE
    - checking index 'vulnerabilities_protocol_idx' on this table... DONE
  - granting access to 'vulnerabilities' for user 'opennms'... DONE
  - checking table "vulnPlugins"...
  - checking table "vulnplugins"... CREATED
    - checking index 'vulnplugins_plugin_idx' on this table... DONE
  - granting access to 'vulnplugins' for user 'opennms'... DONE
  - checking table "notifications"...
  - checking table "notifications"... CREATED
    - checking index 'notifications_nodeid_idx' on this table... DONE
    - checking index 'notifications_ipaddr_idx' on this table... DONE
    - checking index 'notifications_serviceid_idx' on this table... DONE
    - checking index 'notifications_eventid_idx' on this table... DONE
    - checking index 'notifications_respondtime_idx' on this table... DONE
    - checking index 'notifications_answeredby_idx' on this table... DONE
    - checking index 'notifications_eventuei_idx' on this table... DONE
  - granting access to 'notifications' for user 'opennms'... DONE
  - checking table "usersNotified"...
  - checking table "usersnotified"... CREATED
    - checking index 'userid_notifyid_idx' on this table... DONE
  - granting access to 'usersnotified' for user 'opennms'... DONE
  - checking table "alarms"...
  - checking table "alarms"... CREATED
    - checking index 'alarm_uei_idx' on this table... DONE
    - checking index 'alarm_nodeid_idx' on this table... DONE
    - checking index 'alarm_reductionkey_idx' on this table... DONE
    - checking index 'alarm_clearkey_idx' on this table... DONE
    - checking index 'alarm_reduction2_idx' on this table... DONE
    - checking index 'alarm_app_dn' on this table... DONE
    - checking index 'alarm_oss_primary_key' on this table... DONE
    - checking index 'alarm_eventid_idx' on this table... DONE
  - granting access to 'alarms' for user 'opennms'... DONE
  - checking table "alarm_attributes"...
  - checking table "alarm_attributes"... CREATED
    - checking index 'alarm_attributes_idx' on this table... DONE
    - checking index 'alarm_attributes_aan_idx' on this table... DONE
  - granting access to 'alarm_attributes' for user 'opennms'... DONE
  - checking table "assets"...
  - checking table "assets"... CREATED
    - checking index 'assets_nodeid_idx' on this table... DONE
    - checking index 'assets_an_idx' on this table... DONE
  - granting access to 'assets' for user 'opennms'... DONE
  - checking table "categories"...
  - checking table "categories"... CREATED
    - checking index 'category_idx' on this table... DONE
  - granting access to 'categories' for user 'opennms'... DONE
  - checking table "category_node"...
  - checking table "category_node"... CREATED
    - checking index 'catid_idx' on this table... DONE
    - checking index 'catnode_idx' on this table... DONE
    - checking index 'catenode_unique_idx' on this table... DONE
  - granting access to 'category_node' for user 'opennms'... DONE
  - checking table "pathOutage"...
  - checking table "pathoutage"... CREATED
    - checking index 'pathoutage_nodeid' on this table... DONE
    - checking index 'pathoutage_criticalpathip' on this table... DONE
    - checking index 'pathoutage_criticalpathservicename_idx' on this table... DONE
  - granting access to 'pathoutage' for user 'opennms'... DONE
  - checking table "demandPolls"...
  - checking table "demandpolls"... CREATED
    - checking index 'demandpoll_request_time' on this table... DONE
  - granting access to 'demandpolls' for user 'opennms'... DONE
  - checking table "pollResults"...
  - checking table "pollresults"... CREATED
    - checking index 'pollresults_poll_id' on this table... DONE
    - checking index 'pollresults_service' on this table... DONE
  - granting access to 'pollresults' for user 'opennms'... DONE
  - checking table "location_monitors"...
  - checking table "location_monitors"... CREATED
  - granting access to 'location_monitors' for user 'opennms'... DONE
  - checking table "location_monitor_details"...
  - checking table "location_monitor_details"... CREATED
    - checking index 'location_monitor_details_id' on this table... DONE
    - checking index 'location_monitor_details_id_property' on this table... DONE
  - granting access to 'location_monitor_details' for user 'opennms'... DONE
  - checking table "location_specific_status_changes"...
  - checking table "location_specific_status_changes"... CREATED
    - checking index 'location_specific_status_changes_ifserviceid' on this table... DONE
    - checking index 'location_specific_status_changes_locationmonitorid' on this table... DONE
    - checking index 'location_specific_status_changes_locationmonitorid_ifserviceid' on this table... DONE
    - checking index 'location_specific_status_changes_locationmonitorid_loc_if_time' on this table... DONE
    - checking index 'location_specific_status_changes_statustime' on this table... DONE
  - granting access to 'location_specific_status_changes' for user 'opennms'... DONE
  - checking table "applications"...
  - checking table "applications"... CREATED
    - checking index 'applications_name_idx' on this table... DONE
  - granting access to 'applications' for user 'opennms'... DONE
  - checking table "application_service_map"...
  - checking table "application_service_map"... CREATED
    - checking index 'appid_idx' on this table... DONE
    - checking index 'ifserviceid_idx' on this table... DONE
    - checking index 'appid_ifserviceid_idex' on this table... DONE
  - granting access to 'application_service_map' for user 'opennms'... DONE
  - checking table "atinterface"...
  - checking table "atinterface"... CREATED
    - checking index 'atinterface_nodeid_idx' on this table... DONE
    - checking index 'atinterface_node_ipaddr_idx' on this table... DONE
    - checking index 'atinterface_atphysaddr_idx' on this table... DONE
  - granting access to 'atinterface' for user 'opennms'... DONE
  - checking table "vlan"...
  - checking table "vlan"... CREATED
    - checking index 'vlan_vlanname_idx' on this table... DONE
  - granting access to 'vlan' for user 'opennms'... DONE
  - checking table "stpnode"...
  - checking table "stpnode"... CREATED
    - checking index 'stpnode_nodeid_idx' on this table... DONE
    - checking index 'stpnode_baseBridgeAddress_idx' on this table... DONE
    - checking index 'stpnode_stpdesignatedroot_idx' on this table... DONE
  - granting access to 'stpnode' for user 'opennms'... DONE
  - checking table "stpinterface"...
  - checking table "stpinterface"... CREATED
    - checking index 'stpinterface_node_ifindex_idx' on this table... DONE
    - checking index 'stpinterface_node_idx' on this table... DONE
    - checking index 'stpinterface_stpvlan_idx' on this table... DONE
    - checking index 'stpinterface_stpdesbridge_idx' on this table... DONE
  - granting access to 'stpinterface' for user 'opennms'... DONE
  - checking table "iprouteinterface"...
  - checking table "iprouteinterface"... CREATED
    - checking index 'iprouteinterface_nodeid_idx' on this table... DONE
    - checking index 'iprouteinterface_node_ifdex_idx' on this table... DONE
    - checking index 'iprouteinterface_rnh_idx' on this table... DONE
  - granting access to 'iprouteinterface' for user 'opennms'... DONE
  - checking table "datalinkinterface"...
  - checking table "datalinkinterface"... CREATED
    - checking index 'dlint_node_idx' on this table... DONE
    - checking index 'dlint_nodeparent_idx' on this table... DONE
    - checking index 'dlint_nodeparent_paifindex_idx' on this table... DONE
  - granting access to 'datalinkinterface' for user 'opennms'... DONE
  - checking table "inventory"...
  - checking table "inventory"... CREATED
    - checking index 'inventory_nodeid_name_idx' on this table... DONE
    - checking index 'inventory_nodeid_idx' on this table... DONE
    - checking index 'inventory_lastpolltime_idx' on this table... DONE
    - checking index 'inventory_status_idx' on this table... DONE
  - granting access to 'inventory' for user 'opennms'... DONE
  - checking table "map"...
  - checking table "map"... CREATED
  - granting access to 'map' for user 'opennms'... DONE
  - checking table "element"...
  - checking table "element"... CREATED
    - checking index 'element_mapid_elementid' on this table... DONE
  - granting access to 'element' for user 'opennms'... DONE
  - checking table "reportLocator"...
  - checking table "reportlocator"... CREATED
  - granting access to 'reportlocator' for user 'opennms'... DONE
  - checking table "statisticsReport"...
  - checking table "statisticsreport"... CREATED
    - checking index 'statisticsReport_startDate' on this table... DONE
    - checking index 'statisticsReport_name' on this table... DONE
    - checking index 'statisticsReport_purgeDate' on this table... DONE
  - granting access to 'statisticsreport' for user 'opennms'... DONE
  - checking table "resourceReference"...
  - checking table "resourcereference"... CREATED
    - checking index 'resourceReference_resourceId' on this table... DONE
  - granting access to 'resourcereference' for user 'opennms'... DONE
  - checking table "statisticsReportData"...
  - checking table "statisticsreportdata"... CREATED
    - checking index 'statsData_unique' on this table... DONE
  - granting access to 'statisticsreportdata' for user 'opennms'... DONE
  - checking table "qrtz_job_details"...
  - checking table "qrtz_job_details"... CREATED
  - granting access to 'qrtz_job_details' for user 'opennms'... DONE
  - checking table "qrtz_job_listeners"...
  - checking table "qrtz_job_listeners"... CREATED
  - granting access to 'qrtz_job_listeners' for user 'opennms'... DONE
  - checking table "qrtz_triggers"...
  - checking table "qrtz_triggers"... CREATED
  - granting access to 'qrtz_triggers' for user 'opennms'... DONE
  - checking table "qrtz_simple_triggers"...
  - checking table "qrtz_simple_triggers"... CREATED
  - granting access to 'qrtz_simple_triggers' for user 'opennms'... DONE
  - checking table "qrtz_cron_triggers"...
  - checking table "qrtz_cron_triggers"... CREATED
  - granting access to 'qrtz_cron_triggers' for user 'opennms'... DONE
  - checking table "qrtz_blob_triggers"...
  - checking table "qrtz_blob_triggers"... CREATED
  - granting access to 'qrtz_blob_triggers' for user 'opennms'... DONE
  - checking table "qrtz_trigger_listeners"...
  - checking table "qrtz_trigger_listeners"... CREATED
  - granting access to 'qrtz_trigger_listeners' for user 'opennms'... DONE
  - checking table "qrtz_calendars"...
  - checking table "qrtz_calendars"... CREATED
  - granting access to 'qrtz_calendars' for user 'opennms'... DONE
  - checking table "qrtz_paused_trigger_grps"...
  - checking table "qrtz_paused_trigger_grps"... CREATED
  - granting access to 'qrtz_paused_trigger_grps' for user 'opennms'... DONE
  - checking table "qrtz_fired_triggers"...
  - checking table "qrtz_fired_triggers"... CREATED
  - granting access to 'qrtz_fired_triggers' for user 'opennms'... DONE
  - checking table "qrtz_scheduler_state"...
  - checking table "qrtz_scheduler_state"... CREATED
  - granting access to 'qrtz_scheduler_state' for user 'opennms'... DONE
  - checking table "qrtz_locks"...
  - checking table "qrtz_locks"... CREATED
  - granting access to 'qrtz_locks' for user 'opennms'... DONE
- creating tables... DONE
- inserting initial table data for "distPoller"... OK
- inserting initial table data for "categories"... OK
- inserting initial table data for "qrtz_locks"... OK
WARNING: the -U option is deprecated, it does nothing now
- checking if iplike is usable... NO
- removing existing iplike definition (if any)... OK
- inserting C iplike function... SKIPPED (location of iplike function not set)
- inserting PL/pgSQL iplike function... OK
- checking for stale eventtime.so references... OK

Installer completed successfully!

$ rcpostgresql stop
$ rcpostgresql start

Start OpenNMS
$ /etc/init.d/opennms start
/etc/rc.status: line 42: /opt/opennms/logs/daemon/output.log: No such file or directory
Starting OpenNMS:                                                     done

Login opennms:
http://localhost:8980/opennms/
Username : admin
Password : admin




Install phpPgAdmin
phpPgAdmin is a web-based administration tool for PostgreSQL.

$ rpm -ivh http://download.opensuse.org/repositories/server:/php:/applications/openSUSE_11.1/noarch/phpPgAdmin-4.2-57.1.noarch.rpm
Preparing...                ########################################### [100%]
   1:phpPgAdmin             ########################################### [100%]
$ cd /srv/www/htdocs/phpPgAdmin/conf
$ cp config.inc.php-dist config.inc.php

  $conf['servers'][0]['host'] = '';
change to :
  $conf['servers'][0]['host'] = '127.0.0.1';


Change directory owner
$ chown wwwrun.www /srv/www/htdocs/phpPgAdmin/ -R

Using phpPgAdmin
http://localhost/phpPgAdmin/
Username : opennms
Password : opennms




Run Level
- Apache2
- postfix
- postgresql
- tomcat6

System Reboot
$ shutdown -hr now