Re: Installation DB error
Denny <[email protected]> Tue, 25 Apr 2017 18:10:51 +0100
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--===============2820577151327921212==
Content-Type: multipart/alternative;
boundary="------------2BF32A42051CCBDD44F5EE6F"
This is a multi-part message in MIME format.
--------------2BF32A42051CCBDD44F5EE6F
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
I had something like this when I built my Docker container. This link
should set you straight.
http://stackoverflow.com/questions/16736891/pgerror-error-new-encoding-utf8-is-incompatible
Regards
On 25/04/17 14:46, Bjorn Mork wrote:
> Hi Team,
>
> I am trying to install OpenNMS, but getting below error. Please suggest...
>
> *[root@nms ~]# /etc/init.d/postgresql-9.6 status
> postgresql-9.6 (pid 1987) is running...
> [root@nms ~]#
>
>
> *
>
> [root@nms ~]# /opt/opennms/bin/install -dis
> ==============================================================================
> OpenNMS Installer
> ==============================================================================
>
> Configures PostgreSQL tables, users, and other miscellaneous settings.
>
> DEBUG: Platform is IPv6 ready: true
> - searching for libjicmp.so:
> - trying to load /usr/lib64/libjicmp.so: OK
> - searching for libjicmp6.so:
> - trying to load /usr/lib64/libjicmp6.so: OK
> - searching for libjrrd.so:
> - trying to load /usr/lib64/libjrrd.so: OK
> - searching for libjrrd2.so:
> - trying to load /usr/lib64/libjrrd2.so: OK
> 10:53:09.172 [Main] WARN org.opennms.install.Installer - Could not
> create file: /opt/opennms/etc/libraries.properties
> - using SQL directory... /opt/opennms/etc
> - using create.sql... /opt/opennms/etc/create.sql
> 10:53:09.178 [Main] INFO org.opennms.core.schema.Migrator -
> validating database version
> 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:464)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.opennms.core.schema.MigrationException: an error
> occurred getting the version from the database
> at
> org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:183)
> at
> org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:211)
> at org.opennms.install.Installer.install(Installer.java:244)
> at org.opennms.install.Installer.main(Installer.java:989)
> ... 6 more
> Caused by: org.postgresql.util.PSQLException: FATAL: Ident
> authentication failed for user "postgres"
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:446)
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:220)
> at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:55)
> at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:219)
> at org.postgresql.Driver.makeConnection(Driver.java:407)
> at org.postgresql.Driver.connect(Driver.java:275)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> at
> org.opennms.core.db.install.SimpleDataSource.getConnection(SimpleDataSource.java:113)
> at
> org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:171)
> ... 9 more
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> 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
--------------2BF32A42051CCBDD44F5EE6F
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: 8bit
<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body wsmode="reply" bgcolor="#FFFFFF" text="#000000">
<p>I had something like this when I built my Docker container. This
link should set you straight.</p>
<p><a class="moz-txt-link-freetext" href="http://stackoverflow.com/questions/16736891/pgerror-error-new-encoding-utf8-is-incompatible">http://stackoverflow.com/questions/16736891/pgerror-error-new-encoding-utf8-is-incompatible</a></p>
<p>Regards<br>
</p>
<br>
<div class="moz-cite-prefix">On 25/04/17 14:46, Bjorn Mork wrote:<br>
</div>
<blockquote
cite="mid:CAHh02P3s6HRjAtrRbWazWJ6fZs3tn+kjZf6gWzovEq-A9Nq-WQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hi Team,<br>
<br>
</div>
I am trying to install OpenNMS, but getting below error. Please
suggest...<br>
<br>
<b>[root@nms ~]# /etc/init.d/postgresql-9.6 status<br>
postgresql-9.6 (pid 1987) is running...<br>
[root@nms ~]# <br>
<br>
<br>
</b>
<div>
<div>
<div><br>
[root@nms ~]# /opt/opennms/bin/install -dis<br>
==============================================================================<br>
OpenNMS Installer<br>
==============================================================================<br>
<br>
Configures PostgreSQL tables, users, and other
miscellaneous settings.<br>
<br>
DEBUG: Platform is IPv6 ready: true<br>
- searching for libjicmp.so:<br>
- trying to load /usr/lib64/libjicmp.so: OK<br>
- searching for libjicmp6.so:<br>
- trying to load /usr/lib64/libjicmp6.so: OK<br>
- searching for libjrrd.so:<br>
- trying to load /usr/lib64/libjrrd.so: OK<br>
- searching for libjrrd2.so:<br>
- trying to load /usr/lib64/libjrrd2.so: OK<br>
10:53:09.172 [Main] WARN org.opennms.install.Installer -
Could not create file:
/opt/opennms/etc/libraries.properties<br>
- using SQL directory... /opt/opennms/etc<br>
- using create.sql... /opt/opennms/etc/create.sql<br>
10:53:09.178 [Main] INFO org.opennms.core.schema.Migrator
- validating database version<br>
java.lang.reflect.InvocationTargetException<br>
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<br>
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>
at
java.lang.reflect.Method.invoke(Method.java:498)<br>
at
org.opennms.bootstrap.Bootstrap$4.run(Bootstrap.java:464)<br>
at java.lang.Thread.run(Thread.java:745)<br>
Caused by: org.opennms.core.schema.MigrationException: an
error occurred getting the version from the database<br>
at
org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:183)<br>
at
org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:211)<br>
at
org.opennms.install.Installer.install(Installer.java:244)<br>
at
org.opennms.install.Installer.main(Installer.java:989)<br>
... 6 more<br>
Caused by: org.postgresql.util.PSQLException: FATAL: Ident
authentication failed for user "postgres"<br>
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:446)<br>
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:220)<br>
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:55)<br>
at
org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:219)<br>
at
org.postgresql.Driver.makeConnection(Driver.java:407)<br>
at org.postgresql.Driver.connect(Driver.java:275)<br>
at
java.sql.DriverManager.getConnection(DriverManager.java:664)<br>
at
java.sql.DriverManager.getConnection(DriverManager.java:208)<br>
at
org.opennms.core.db.install.SimpleDataSource.getConnection(SimpleDataSource.java:113)<br>
at
org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:171)<br>
... 9 more<br>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! <a class="moz-txt-link-freetext" href="http://sdm.link/slashdot">http://sdm.link/slashdot</a></pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Please read the OpenNMS Mailing List FAQ:
<a class="moz-txt-link-freetext" href="http://www.opennms.org/index.php/Mailing_List_FAQ">http://www.opennms.org/index.php/Mailing_List_FAQ</a>
opennms-install mailing list
To *unsubscribe* or change your subscription options, see the bottom of this page:
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/opennms-install">https://lists.sourceforge.net/lists/listinfo/opennms-install</a></pre>
</blockquote>
<br>
</body>
</html>
--------------2BF32A42051CCBDD44F5EE6F--
--===============2820577151327921212==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
--===============2820577151327921212==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
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
--===============2820577151327921212==--