Opennms-db unmet dependency on Raspberry Pi

Trying to install Opennms Horizon on a 64-bit Raspberry Pi, currently receiving unmet dependencies re: opennms-db…current output
root@raspberrypi:/# apt show opennms
Package: opennms
Version: 27.0.2-1
Priority: optional
Section: contrib/net
Maintainer: Jeff Gehlbach jeffg@opennms.org
Installed-Size: 9,216 B
Depends: opennms-db (= 27.0.2-1), opennms-server (= 27.0.2-1), opennms-webapp-jetty (= 27.0.2-1)
Recommends: opennms-source (= 27.0.2-1), openjdk-11-jdk-headless | openjdk-11-jdk | adoptopenjdk-11-openj9xl | adoptopenjdk-11-openj9 | adoptopenjdk-11-hotspot | oracle-java8-installer | adoptopenjdk-8-openj9xl | adoptopenjdk-8-openj9 | adoptopenjdk-8-hotspot | openjdk-8-jdk-headless | openjdk-8-jdk | java8-jdk
Suggests: opennms-doc
Download-Size: 2,324 B
APT-Sources: https://debian.opennms.org stable/main arm64 Packages
Description: Enterprise-grade Open-source Network Management Platform (Full Install)
OpenNMS is an enterprise-grade network management system written in Java.
.
OpenNMS can monitor various network services to determine status and service
level availability. Data collection is performed using protocols such as SNMP
to generate reports and alert on thresholds. An extensible event management
and notification system handles both internally and externally generated
events (such as SNMP traps), and generates notices via email, pager, SMS, etc.
.
This package provides the components needed for a reasonable default
installation of OpenNMS.

Is there a way to manually install PostgreSQL?

See the PostgreSQL downloads page:

Thank you so much for the response. I was able to install PostgreSQL but still have dependency errors:
root@raspberrypi:/# apt -y install opennms
Reading package lists… Done
Building dependency tree
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
opennms : Depends: opennms-db (= 27.0.2-1) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

I assumed that installing the PostgreSQL app would eliminate the opennms-db error…can I manually install the opennms-db package? https://debian.opennms.org/dists/opennms-27/main/binary-arm64/Packages

I mised the step where you mentioned you were using a Raspberry Pi for this install. I haven’t installed on a Pi. Try these resources:

Can you run the command and share the output from:

apt-get -y -o Debug::pkgProblemResolver=yes install opennms-db

I appreciate your response but I’ve since reinstalled a different OS and am currently running into different issues. This project is currently on hold.


root@raspberrypi:/etc/apt# root@raspberrypi:/etc/apt# apt-get update
Hit:1 http://deb.debian.org/debian buster InRelease
Hit:2 http://deb.debian.org/debian-security buster/updates InRelease
Hit:3 http://deb.debian.org/debian buster-updates InRelease
Ign:5 https://debian.opennms.org stable InRelease
Hit:6 http://archive.raspberrypi.org/debian buster InRelease
Ign:4 https://debian.opennms.org opennms-27 InRelease
Hit:7 https://debian.opennms.org stable Release
Hit:8 https://debian.opennms.org opennms-27 Release
Hit:11 http://apt.postgresql.org/pub/repos/apt buster-pgdg InRelease
Reading package lists… Done
W: Conflicting distribution: https://debian.opennms.org stable Release (expected stable but got opennms-27)
N: Skipping acquire of configured file ‘main/binary-armhf/Packages’ as repository ‘http://apt.postgresql.org/pub/repos/apt buster-pgdg InRelease’ doesn’t support architecture ‘armhf’
root@raspberrypi:/etc/apt#

Any suggestions?

I think I found the reason, our iplike stored procedure for PostgreSQL isn’t available as arm64 package. We have to investigate how complicated it is to build an ARM64 package for liplike. Maybe @RangerRick can shed some light here.

I have since uninstalled all instances of Postgresql and reverted back to the install of opennms step, here are the results:
root@raspberrypi:/etc/apt/sources.list.d# apt -y install opennms
Reading package lists… Done
Building dependency tree
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
opennms : Depends: opennms-db (= 27.0.3-1) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
root@raspberrypi:/etc/apt/sources.list.d# apt-get -y -o Debug::pkgProblemResolver=yes install opennms-db
Reading package lists… Done
Building dependency tree
Reading state information… Done
Starting pkgProblemResolver with broken count: 1
Starting 2 pkgProblemResolver with broken count: 1
Investigating (0) opennms-db:arm64 < none -> 27.0.3-1 @un puN Ib >
Broken opennms-db:arm64 Depends on postgresql-13:arm64 < none @un H >
Broken opennms-db:arm64 Depends on postgresql-12:arm64 < none @un H >
Broken opennms-db:arm64 Depends on postgresql-11:arm64 < none | 11.9-0+deb10u1 @un uH >
Considering postgresql-11:arm64 1 as a solution to opennms-db:arm64 9999
Re-Instated postgresql-client-common:arm64
Re-Instated postgresql-client-11:arm64
Re-Instated postgresql-common:arm64
Re-Instated postgresql-11:arm64
Broken opennms-db:arm64 Depends on iplike-pgsql13:arm64 < none @un H >
Broken opennms-db:arm64 Depends on iplike-pgsql12:arm64 < none @un H >
Broken opennms-db:arm64 Depends on iplike-pgsql11:arm64 < none @un H >
Broken opennms-db:arm64 Depends on iplike-pgsql10:arm64 < none @un H >
Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
opennms-db : Depends: iplike-pgsql13 but it is not installable or
iplike-pgsql12 but it is not installable or
iplike-pgsql11 but it is not installable or
iplike-pgsql10 but it is not installable
E: Unable to correct problems, you have held broken packages.
root@raspberrypi:/etc/apt/sources.list.d#

I’m assuming that I need to wait for an arm64 iplike package? Thank you for your help!

Yeah, the stuff we’ve made arm64 packages for was mostly to facilitate running Minion. I suppose as arm64 becomes a thing it’s worth bothering to run OpenNMS on, we could look into building iplike packages as well.

I just built some (untested) packages for iplike/arm64 and stuck them in the Debian stable OpenNMS repo. Let me know if that works for you.

2 Likes

I definitely got further but with the following errors:

When I run the ./install command, I get a text output
root@raspberrypi:/usr/share/opennms/bin# ./install

OpenNMS Installer

Configures PostgreSQL tables, users, and other miscellaneous settings.

usage: usage: install [options]
-a,–admin-username replaced by opennms-datasources.xml
-A,–admin-password replaced by opennms-datasources.xml
-c,–clean-database this option does nothing
-d,–do-database perform database actions
-D,–database-url replaced by opennms-datasources.xml
-e,–extended-repairs enable extended repairs of old schemas
-f,–vacuum-full vacuum full the database (recovers unused
disk space)
-h,–help this help
-i,–insert-data (obsolete)
-l,–library-path library search path (directories separated
by ‘:’)
-p,–password replaced by opennms-datasources.xml
-P,–database-name replaced by opennms-datasources.xml
-Q,–ignore-database-version disable the database version check
-r,–rpm-install RPM install (deprecated)
-s,–stored-procedure add the IPLIKE stored procedure if it’s
missing
-S,–skip-upgrade-tools Skip the execution of the upgrade tools
(post-processing tasks)
-T,–tomcat-conf location of tomcat.conf
-u,–username replaced by opennms-datasources.xml
-v,–vacuum vacuum (optimize) the database
-w,–tomcat-context location of the tomcat context (eg,
conf/Catalina/localhost)
-x,–database-debug turn on debugging for the database data
transformation
-y,–do-webapp install web application (see ‘-w’)
-Z,–remove-database remove the OpenNMS database
An error occurred: Nothing to do. Use -h for help.

But during the installation, I also ran into the following message:


When I try running ./install_iplike.sh, this is the output:
root@raspberrypi:/usr/sbin# ./install_iplike.sh
Password for user postgres:
CREATE FUNCTION
root@raspberrypi:/usr/sbin#

I feel like we’re close. I’ve also ran the following command: sudo /usr/share/opennms/bin/install -dis
but to no avail. Your help is greatly appreciated.

Disregard the errors…I was able to successfully install OpenNMS on the raspberry pi4. I appreciate all your hard work and efforts. Thank you!!

1 Like

Disregard the topic that I submitted. I had to change the localhost information in the opennms-datasources.xml file. I apologize for the inconvenience but the OpenNMS web interface became available after changing that information.

Thank you,

image001.png

2 Likes

Wondering if you will have an opennms-webapp-minion package available for arm64/aarch64? I looked through the repositories and was unable to find a package for opennms-webapp-minion.

Thank you,

image001.png

image001.jpg

There is no such thing as opennms-webapp-minion on any platform – what exactly are you trying to do?

GitHub - OpenNMS/smnnepo - the URL mentioned opennms-webapp-minion.
I have OpenNMS installed but cannot see the minion w/in the interface. ActiveMQ shows the connection but wasn’t sure why OpenNMS didn’t populate any minion instances. After reading, I believe I need to do a little more configuration w/ the ActiveMQ port on the server side.

Ah, I see. The “smnnepo” archive should probably be archived. That was where the “proof-of-concept” minion was built, but the code is integrated into the main OpenNMS codebase now.

The proper instructions for using/configuring minions is now part of the main admin and installation guides at OpenNMS Releases: 27.0.3

I’m having an issue when rebooting my OpenNMS server (also acts as Kafka server). When the OS loads the zookeeper and Kafka services have to be manually started, then I have to restart Postgresql because I won’t be able to access the opennms database…essentially the following services need to start in this order: Zookeeper, KAFKA, PostgreSQL, and then OpenNMS.

I would also like to know if I need to reenter the docker-compose up –d command after entering the 9092 port for Kafka and eliminating the 61616 port for ActiveMQ?

Even after verifying that the rpc and sink have started, the minion still times out when connecting to the server. If you need to look at any configuration files or outputs, let me know.

Your help is greatly appreciated. Thank you,