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