Khan M. Rizwan | 11 Jul 2012 13:14
Picon

OpenNMS installation on Windows

Hi All,


I am trying to install OpenNMS on Windows 7 machine with Postgres Plus Advance Server 8.4.
Every time I run the setup32.exe the installation stops at Step 9 with following error:

==============================================================================
OpenNMS Installer
==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.

DEBUG: Looks like we're on Windows...  Validating.
DEBUG: Found Service Pack 1
DEBUG: Windows NT Version 6.1, Build 7601 (Service Pack 1)
- searching for jicmp:
  - trying to load C:/Program Files/OpenNMS/lib\jicmp.dll: OK
- searching for jicmp6:
  - trying to load C:/Program Files/OpenNMS/lib\jicmp6.dll: OK
- searching for jrrd:
  - trying to load C:/Program Files/OpenNMS/lib\jrrd.dll: NO
  - trying to load C:\Program Files\Java\jdk1.6.0\bin\jrrd.dll: NO
  - trying to load .\jrrd.dll: NO
  - trying to load C:\Windows\Sun\Java\bin\jrrd.dll: NO
  - trying to load C:\Windows\system32\jrrd.dll: NO
  - trying to load C:\Windows\jrrd.dll: NO
  - trying to load C:\Users\Sathya\Desktop\1-06-2012\mysql-connector-java-5.1.20\jrrd.dll: NO
  - trying to load C:\Program Files\Xuggle\bin\jrrd.dll: NO
  - trying to load C:\Windows\system32\jrrd.dll: NO
  - trying to load C:\Windows\jrrd.dll: NO
  - trying to load C:\Windows\System32\Wbem\jrrd.dll: NO
  - trying to load C:\Windows\System32\WindowsPowerShell\v1.0\\jrrd.dll: NO
  - trying to load C:\Program Files\TortoiseSVN\bin\jrrd.dll: NO
  - trying to load D:\Ant\bin\jrrd.dll: NO
  - trying to load C:\Program Files\SlikSvn\bin\jrrd.dll: NO
  - trying to load C:\Program Files\VideoLAN\VLC\jrrd.dll: NO
  - trying to load C:\Program Files\MySQL\MySQL Server 5.5\bin\jrrd.dll: NO
  - trying to load C:\Program Files\Java\jdk1.6.0\bin\jrrd.dll: NO
  - trying to load C:\jrrd-1.0.5\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
- using SQL directory... C:\Program Files\OpenNMS\etc
- using create.sql... C:\Program Files\OpenNMS\etc\create.sql
Exception in thread "main" org.opennms.core.schema.MigrationException: Could not parse version number out of version string: EnterpriseDB 8.4.7.20, compiled by Visual C++ build 1400, 32-bit
    at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:186)
    at org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:206)
    at org.opennms.install.Installer.install(Installer.java:226)
    at org.opennms.install.Installer.main(Installer.java:950)

Thanks in Advance.

--
Regards,
M. Rizwan Khan

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install
Khan M. Rizwan | 11 Jul 2012 13:19
Picon

OpenNMS installation on Windows

Hi All,


I am trying to install OpenNMS on Windows 7 machine with Postgres Plus Advance Server 8.4.
Every time I run the setup32.exe the installation stops at Step 9 with following error:

==============================================================================
OpenNMS Installer
==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.

DEBUG: Looks like we're on Windows...  Validating.
DEBUG: Found Service Pack 1
DEBUG: Windows NT Version 6.1, Build 7601 (Service Pack 1)
- searching for jicmp:
  - trying to load C:/Program Files/OpenNMS/lib\jicmp.dll: OK
- searching for jicmp6:
  - trying to load C:/Program Files/OpenNMS/lib\jicmp6.dll: OK
- searching for jrrd:
  - trying to load C:/Program Files/OpenNMS/lib\jrrd.dll: NO
  - trying to load C:\Program Files\Java\jdk1.6.0\bin\jrrd.dll: NO
  - trying to load .\jrrd.dll: NO
  - trying to load C:\Windows\Sun\Java\bin\jrrd.dll: NO
  - trying to load C:\Windows\system32\jrrd.dll: NO
  - trying to load C:\Windows\jrrd.dll: NO
  - trying to load C:\Users\Sathya\Desktop\1-06-2012\mysql-connector-java-5.1.20\jrrd.dll: NO
  - trying to load C:\Program Files\Xuggle\bin\jrrd.dll: NO
  - trying to load C:\Windows\system32\jrrd.dll: NO
  - trying to load C:\Windows\jrrd.dll: NO
  - trying to load C:\Windows\System32\Wbem\jrrd.dll: NO
  - trying to load C:\Windows\System32\WindowsPowerShell\v1.0\\jrrd.dll: NO
  - trying to load C:\Program Files\TortoiseSVN\bin\jrrd.dll: NO
  - trying to load D:\Ant\bin\jrrd.dll: NO
  - trying to load C:\Program Files\SlikSvn\bin\jrrd.dll: NO
  - trying to load C:\Program Files\VideoLAN\VLC\jrrd.dll: NO
  - trying to load C:\Program Files\MySQL\MySQL Server 5.5\bin\jrrd.dll: NO
  - trying to load C:\Program Files\Java\jdk1.6.0\bin\jrrd.dll: NO
  - trying to load C:\jrrd-1.0.5\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
- using SQL directory... C:\Program Files\OpenNMS\etc
- using create.sql... C:\Program Files\OpenNMS\etc\create.sql
Exception in thread "main" org.opennms.core.schema.MigrationException: Could not parse version number out of version string: EnterpriseDB 8.4.7.20, compiled by Visual C++ build 1400, 32-bit
    at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:186)
    at org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:206)
    at org.opennms.install.Installer.install(Installer.java:226)
    at org.opennms.install.Installer.main(Installer.java:950)

Thanks in Advance.

--
Regards,
M. Rizwan Khan



------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install
Benjamin Reed | 16 Jul 2012 21:30
Favicon
Gravatar

Re: OpenNMS installation on Windows


On 7/11/12 7:14 AM, Khan M. Rizwan wrote:
> Exception in thread "main"
> org.opennms.core.schema.MigrationException: Could not parse version
> number out of version string: EnterpriseDB 8.4.7.20, compiled by
> Visual C++ build 1400, 32-bit

Would you mind opening an issue about this at
http://issues.opennms.org/? We're probably expecting it to say
"PostgreSQL 8.4.7" instead, and have to handle "EnterpriseDB" being a
synonym.

--

-- 
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/

Khan M. Rizwan | 17 Jul 2012 06:55
Picon

Re: OpenNMS installation on Windows

Hi Benjamin,

Thanks for the advise. Created an Issue, Issue # NMS-5431 (http://issues.opennms.org/browse/NMS-5431)
I tried on multiple machine having PostgreSQL Plus Advance Server, but it failed with each of them. I too, think that the problem might be with OpenNMS with PostgreSQL Plus Advance Server.
Hope this resolves quickly. 

Regards,
M. Rizwan Khan

On Tue, Jul 17, 2012 at 1:00 AM, Benjamin Reed <ranger <at> opennms.org> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 7/11/12 7:14 AM, Khan M. Rizwan wrote:
> Exception in thread "main"
> org.opennms.core.schema.MigrationException: Could not parse version
> number out of version string: EnterpriseDB 8.4.7.20, compiled by
> Visual C++ build 1400, 32-bit

Would you mind opening an issue about this at
http://issues.opennms.org/? We're probably expecting it to say
"PostgreSQL 8.4.7" instead, and have to handle "EnterpriseDB" being a
synonym.


- --
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/



-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iD8DBQFQBGvHUu+jZtP2Zf4RAhluAJ4lgOHWiK0ug6Zet+EI9fqXdS6a/QCeP/kb
Wu9RGl1OCPZ3qPPv2zzrLyY=
=Vysq
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install
Khan M. Rizwan | 19 Jul 2012 12:10
Picon

Re: OpenNMS installation on Windows

Hi Benjamin,

Thanks for the solution.
Got 1.10.5 (standalone-opennms-installer-1.10.5-0.20120627.265.zip) and tried installing, but now getting following error.

- using SQL directory... C:\Program Files\OpenNMS\etc
- using create.sql... C:\Program Files\OpenNMS\etc\create.sql
* using 'postgres' as the PostgreSQL user for OpenNMS
* using 'opennms' as the PostgreSQL database name for OpenNMS
- checking if database "opennms" is unicode... ALREADY UNICODE
- Creating imports directory (C:\Program Files\OpenNMS\etc\imports... OK
- Checking for old import files in C:\Program Files\OpenNMS\etc... DONE
Exception in thread "main" org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"
  Position: 13
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
    at org.opennms.netmgt.dao.db.InstallerDb.databaseSetUser(InstallerDb.java:2018)
    at org.opennms.install.Installer.install(Installer.java:249)
    at org.opennms.install.Installer.main(Installer.java:949)

Regards,
M. Rizwan Khan

On Tue, Jul 17, 2012 at 10:25 AM, Khan M. Rizwan <khanrizwan.net <at> gmail.com> wrote:
Hi Benjamin,

Thanks for the advise. Created an Issue, Issue # NMS-5431 (http://issues.opennms.org/browse/NMS-5431)
I tried on multiple machine having PostgreSQL Plus Advance Server, but it failed with each of them. I too, think that the problem might be with OpenNMS with PostgreSQL Plus Advance Server.
Hope this resolves quickly. 

Regards,
M. Rizwan Khan


On Tue, Jul 17, 2012 at 1:00 AM, Benjamin Reed <ranger <at> opennms.org> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 7/11/12 7:14 AM, Khan M. Rizwan wrote:
> Exception in thread "main"
> org.opennms.core.schema.MigrationException: Could not parse version
> number out of version string: EnterpriseDB 8.4.7.20, compiled by
> Visual C++ build 1400, 32-bit

Would you mind opening an issue about this at
http://issues.opennms.org/? We're probably expecting it to say
"PostgreSQL 8.4.7" instead, and have to handle "EnterpriseDB" being a
synonym.


- --
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/



-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iD8DBQFQBGvHUu+jZtP2Zf4RAhluAJ4lgOHWiK0ug6Zet+EI9fqXdS6a/QCeP/kb
Wu9RGl1OCPZ3qPPv2zzrLyY=
=Vysq
-----END PGP SIGNATURE-----


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install

Gmane