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
<[email protected]>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 <[email protected]> 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