postgresql - OpenNMS Win Server installation issues

Question

I am attempting to install this on my HTPC running server 2012 and have followed the wiki installation guide but when I get to putting port range to search I get these errors. This is the guide: https://docs.opennms.org/opennms/releases/latest/guide-install/guide-install.html#gi-install-opennms-windows

C:UsersAdministratorDownloadsstandalone-opennms-installer-18.0.2-1opennms-installer>SET OPENNMS_HOME=C:/Program Files (x86)/OpenNMS

C:UsersAdministratorDownloadsstandalone-opennms-installer-18.0.2-1opennms-installer>SET DBNAME=opennms

C:UsersAdministratorDownloadsstandalone-opennms-installer-18.0.2-1opennms-installer>SET DBURL=jdbc:postgresql://localhost:5432/

C:UsersAdministratorDownloadsstandalone-opennms-installer-18.0.2-1opennms-installer>SET ETCDIR=C:/Program Files (x86)/OpenNMS/etc

C:UsersAdministratorDownloadsstandalone-opennms-installer-18.0.2-1opennms-installer>SET SERVLETDIR=C:/Program Files (x86)/OpenNMS/webapps/opennms

C:UsersAdministratorDownloadsstandalone-opennms-installer-18.0.2-1opennms-installer>"C:Program FilesJavajdk1.8.0_112injava" -Xmx512m "-Dopennms.home=C:/Program Files (x86)/OpenNMS" "-Dinstall.dir=C:/Program Files (x86)/OpenNMS" "-Dinstall.database.name=opennms" "-Dinstall.database.url=jdbc:postgresql://localhost:5432/" "-Dinstall.etc.dir=C:/Program Files (x86)/OpenNMS/etc" "-Dinstall.servlet.dir=C:/Program Files (x86)/OpenNMS/webapps/opennms" -classpath "C:/Program Files (x86)/OpenNMS/lib/opennms_bootstrap.jar" org.opennms.bootstrap.InstallerBootstrap -dis -l "C:/Program Files (x86)/OpenNMS/lib"
==============================================================================
OpenNMS Installer
==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.

DEBUG: Looks like we're on Windows...  Validating.
WARNING: Unable to retrieve the value for SOFTWAREMicrosoftWindows NTCurrentVersionCSDVersion
DEBUG: Windows NT Version 6.2, Build 9200 (Service Pack 0)
DEBUG: Platform is IPv6 ready: true
- searching for jicmp.dll:
  - trying to load C:/Program Files (x86)/OpenNMS/libjicmp.dll: NO
  - trying to load C:Program FilesJavajdk1.8.0_112injicmp.dll: NO
  - trying to load C:WindowsSunJavainjicmp.dll: NO
  - trying to load C:Windowssystem32jicmp.dll: NO
  - trying to load C:Windowsjicmp.dll: NO
  - trying to load C:Program Files (x86)iis expressPHPv5.5jicmp.dll: NO
  - trying to load C:ProgramDataOracleJavajavapathjicmp.dll: NO
  - trying to load C:Program Files (x86)InteliCLS Client\jicmp.dll: NO
  - trying to load C:Program FilesInteliCLS Client\jicmp.dll: NO
  - trying to load C:Windowssystem32jicmp.dll: NO
  - trying to load C:Windowsjicmp.dll: NO
  - trying to load C:WindowsSystem32Wbemjicmp.dll: NO
  - trying to load C:WindowsSystem32WindowsPowerShellv1.0\jicmp.dll: NO
  - trying to load C:Program FilesGitcmdjicmp.dll: NO
  - trying to load C:Program FilesFileBot\jicmp.dll: NO
  - trying to load C:Goinjicmp.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
vmjicmp.dll: NO
  - trying to load C:Program Files
odejsjicmp.dll: NO
  - trying to load C:Program FilesIntelIntel(R) Management Engine ComponentsDALjicmp.dll: NO
  - trying to load C:Program Files (x86)IntelIntel(R) Management Engine ComponentsDALjicmp.dll: NO
  - trying to load C:Program FilesIntelIntel(R) Management Engine ComponentsIPTjicmp.dll: NO
  - trying to load C:Program Files (x86)IntelIntel(R) Management Engine ComponentsIPTjicmp.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
pmjicmp.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
vmjicmp.dll: NO
  - trying to load C:Program Files
odejsjicmp.dll: NO
  - trying to load .jicmp.dll: NO
- Failed to load the optional jicmp library.
  - This error is not fatal, since jicmp is only required for optional features.
  - For more information, see http://www.opennms.org/index.php/jicmp
- searching for jicmp6.dll:
  - trying to load C:/Program Files (x86)/OpenNMS/libjicmp6.dll: NO
  - trying to load C:Program FilesJavajdk1.8.0_112injicmp6.dll: NO
  - trying to load C:WindowsSunJavainjicmp6.dll: NO
  - trying to load C:Windowssystem32jicmp6.dll: NO
  - trying to load C:Windowsjicmp6.dll: NO
  - trying to load C:Program Files (x86)iis expressPHPv5.5jicmp6.dll: NO
  - trying to load C:ProgramDataOracleJavajavapathjicmp6.dll: NO
  - trying to load C:Program Files (x86)InteliCLS Client\jicmp6.dll: NO
  - trying to load C:Program FilesInteliCLS Client\jicmp6.dll: NO
  - trying to load C:Windowssystem32jicmp6.dll: NO
  - trying to load C:Windowsjicmp6.dll: NO
  - trying to load C:WindowsSystem32Wbemjicmp6.dll: NO
  - trying to load C:WindowsSystem32WindowsPowerShellv1.0\jicmp6.dll: NO
  - trying to load C:Program FilesGitcmdjicmp6.dll: NO
  - trying to load C:Program FilesFileBot\jicmp6.dll: NO
  - trying to load C:Goinjicmp6.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
vmjicmp6.dll: NO
  - trying to load C:Program Files
odejsjicmp6.dll: NO
  - trying to load C:Program FilesIntelIntel(R) Management Engine ComponentsDALjicmp6.dll: NO
  - trying to load C:Program Files (x86)IntelIntel(R) Management Engine ComponentsDALjicmp6.dll: NO
  - trying to load C:Program FilesIntelIntel(R) Management Engine ComponentsIPTjicmp6.dll: NO
  - trying to load C:Program Files (x86)IntelIntel(R) Management Engine ComponentsIPTjicmp6.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
pmjicmp6.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
vmjicmp6.dll: NO
  - trying to load C:Program Files
odejsjicmp6.dll: NO
  - trying to load .jicmp6.dll: NO
- Failed to load the optional jicmp6 library.
  - This error is not fatal, since jicmp6 is only required for optional features.
  - For more information, see http://www.opennms.org/index.php/jicmp6
- searching for jrrd.dll:
  - trying to load C:/Program Files (x86)/OpenNMS/libjrrd.dll: NO
  - trying to load C:Program FilesJavajdk1.8.0_112injrrd.dll: NO
  - trying to load C:WindowsSunJavainjrrd.dll: NO
  - trying to load C:Windowssystem32jrrd.dll: NO
  - trying to load C:Windowsjrrd.dll: NO
  - trying to load C:Program Files (x86)iis expressPHPv5.5jrrd.dll: NO
  - trying to load C:ProgramDataOracleJavajavapathjrrd.dll: NO
  - trying to load C:Program Files (x86)InteliCLS Client\jrrd.dll: NO
  - trying to load C:Program FilesInteliCLS Client\jrrd.dll: NO
  - trying to load C:Windowssystem32jrrd.dll: NO
  - trying to load C:Windowsjrrd.dll: NO
  - trying to load C:WindowsSystem32Wbemjrrd.dll: NO
  - trying to load C:WindowsSystem32WindowsPowerShellv1.0\jrrd.dll: NO
  - trying to load C:Program FilesGitcmdjrrd.dll: NO
  - trying to load C:Program FilesFileBot\jrrd.dll: NO
  - trying to load C:Goinjrrd.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
vmjrrd.dll: NO
  - trying to load C:Program Files
odejsjrrd.dll: NO
  - trying to load C:Program FilesIntelIntel(R) Management Engine ComponentsDALjrrd.dll: NO
  - trying to load C:Program Files (x86)IntelIntel(R) Management Engine ComponentsDALjrrd.dll: NO
  - trying to load C:Program FilesIntelIntel(R) Management Engine ComponentsIPTjrrd.dll: NO
  - trying to load C:Program Files (x86)IntelIntel(R) Management Engine ComponentsIPTjrrd.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
pmjrrd.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
vmjrrd.dll: NO
  - trying to load C:Program Files
odejsjrrd.dll: NO
  - trying to load .jrrd.dll: 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
- searching for jrrd2.dll:
  - trying to load C:/Program Files (x86)/OpenNMS/libjrrd2.dll: NO
  - trying to load C:Program FilesJavajdk1.8.0_112injrrd2.dll: NO
  - trying to load C:WindowsSunJavainjrrd2.dll: NO
  - trying to load C:Windowssystem32jrrd2.dll: NO
  - trying to load C:Windowsjrrd2.dll: NO
  - trying to load C:Program Files (x86)iis expressPHPv5.5jrrd2.dll: NO
  - trying to load C:ProgramDataOracleJavajavapathjrrd2.dll: NO
  - trying to load C:Program Files (x86)InteliCLS Client\jrrd2.dll: NO
  - trying to load C:Program FilesInteliCLS Client\jrrd2.dll: NO
  - trying to load C:Windowssystem32jrrd2.dll: NO
  - trying to load C:Windowsjrrd2.dll: NO
  - trying to load C:WindowsSystem32Wbemjrrd2.dll: NO
  - trying to load C:WindowsSystem32WindowsPowerShellv1.0\jrrd2.dll: NO
  - trying to load C:Program FilesGitcmdjrrd2.dll: NO
  - trying to load C:Program FilesFileBot\jrrd2.dll: NO
  - trying to load C:Goinjrrd2.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
vmjrrd2.dll: NO
  - trying to load C:Program Files
odejsjrrd2.dll: NO
  - trying to load C:Program FilesIntelIntel(R) Management Engine ComponentsDALjrrd2.dll: NO
  - trying to load C:Program Files (x86)IntelIntel(R) Management Engine ComponentsDALjrrd2.dll: NO
  - trying to load C:Program FilesIntelIntel(R) Management Engine ComponentsIPTjrrd2.dll: NO
  - trying to load C:Program Files (x86)IntelIntel(R) Management Engine ComponentsIPTjrrd2.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
pmjrrd2.dll: NO
  - trying to load C:UsersAdministratorAppDataRoaming
vmjrrd2.dll: NO
  - trying to load C:Program Files
odejsjrrd2.dll: NO
  - trying to load .jrrd2.dll: NO
- Failed to load the optional jrrd2 library.
  - This error is not fatal, since jrrd2 is only required for optional features.
  - For more information, see http://www.opennms.org/index.php/jrrd2
- using SQL directory... C:Program Files (x86)OpenNMSetc
- using create.sql... C:Program Files (x86)OpenNMSetccreate.sql
* using 'postgres' as the PostgreSQL user for OpenNMS
* using 'opennms' as the PostgreSQL database name for OpenNMS
java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.opennms.bootstrap.Bootstrap$4.run(Bootstrap.java:460)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.opennms.core.schema.MigrationException: an error occurred creating the OpenNMS user
    at org.opennms.core.schema.Migrator.createUser(Migrator.java:339)
    at org.opennms.core.schema.Migrator.prepareDatabase(Migrator.java:447)
    at org.opennms.install.Installer.install(Installer.java:254)
    at org.opennms.install.Installer.main(Installer.java:989)
    ... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: unrecognized role option "createuser"
  Position: 54
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
    at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:321)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:313)
    at org.opennms.core.schema.Migrator.createUser(Migrator.java:337)
    ... 9 more

Then when trying the start.bat inside opennms i get

C:Program Files (x86)OpenNMSin>"C:Program FilesJavajdk1.8.0_112injava"
    -Xmx1024m -XX:MaxMetaspaceSize=256m    -XX:+HeapDumpOnOutOfMemoryError    -D
isThreadContextMapInheritable=true    -Dopennms.home="C:/Program Files (x86)/Ope

Answer 1

Not sure if you ever figured this out - but I had the same issue installing OpenNMS on Windows 2012/R2. I ended up figuring out that the latest PostGres DB version is the problem. If you install PostGres v9.2.19 (http://www.enterprisedb.com/postgresql-9219-installers-win64?ls=Crossover&type=Crossover) the installation will complete, as long as the other prereq's are met.