[prev in list] [next in list] [prev in thread] [next in thread] 

List:       opennms-install
Subject:    Re: [opennms-install] Reg:opennms install issue
From:       Bob Greene <BGreene () liquidnetworx ! com>
Date:       2012-07-31 19:33:45
Message-ID: DB9D2488-3F4B-4778-934A-2896B9C3FA67 () liquidnetworx ! com
[Download RAW message or body]

Have you modified pg_hba.conf to use a trust rather than ident?

http://www.opennms.org/wiki/QuickStart#Edit_pg_hba.conf_to_Allow_postgres_t=
o_Authenticate

On Jul 31, 2012, at 12:16 PM, saranya guna <sarangunasns@gmail.com<mailto:s=
arangunasns@gmail.com>> wrote:


Hi,

I started postgresql db by using the script in /etc/init.d. Now the postgre=
sql db is started .

When I run the install script using  ./install -dis ,  I am getting the bel=
ow error:

Failed to load the optional jrrd library.
  - This error is not fatal, since jrrd is only required for optional featu=
res.
  - For more information, see http://www.opennms.org/index.php/jrrd
- using SQL directory... /opt/opennms/etc
- using create.sql... /opt/opennms/etc/create.sql
Exception in thread "main" org.opennms.core.schema.MigrationException: an e=
rror occurred getting the version from the database
        at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.jav=
a:178)
        at org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrato=
r.java:206)
        at org.opennms.install.Installer.install(Installer.java:226)
        at org.opennms.install.Installer.main(Installer.java:950)
Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry f=
or host "10.212.96.35", user "postgres", database "template1", SSL off
        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(Co=
nnectionFactoryImpl.java:291)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(=
ConnectionFactoryImpl.java:108)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionF=
actory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc=
2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc=
3Connection.java:30)
        at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJd=
bc3gConnection.java:22)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc=
4Connection.java:30)
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java=
:24)
        at org.postgresql.Driver.makeConnection(Driver.java:393)
        at org.postgresql.Driver.connect(Driver.java:267)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at org.opennms.netmgt.dao.db.SimpleDataSource.getConnection(SimpleD=
ataSource.java:90)
        at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.jav=
a:166)
        ... 3 more

 Please help in resolving this issue. -------------------------------------=
-----------------------------------------
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 thi=
s page:
https://lists.sourceforge.net/lists/listinfo/opennms-install


[Attachment #3 (text/html)]

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "> Have you modified pg_hba.conf to use a trust rather than ident?
<div><br>
</div>
<div><a href="http://www.opennms.org/wiki/QuickStart#Edit_pg_hba.conf_to_Allow_postgre \
s_to_Authenticate">http://www.opennms.org/wiki/QuickStart#Edit_pg_hba.conf_to_Allow_postgres_to_Authenticate</a></div>
 <div><br>
<div>
<div>On Jul 31, 2012, at 12:16 PM, saranya guna &lt;<a \
href="mailto:sarangunasns@gmail.com">sarangunasns@gmail.com</a>&gt; wrote:</div> <br \
class="Apple-interchange-newline"> <blockquote type="cite"><br>
Hi,<br>
&nbsp;<br>
I started postgresql db by using the script in /etc/init.d. Now the postgresql db is \
started .<br> &nbsp;<br>
When I run the install script using&nbsp; ./install -dis ,&nbsp; I am getting the \
below error:<br> &nbsp;<br>
Failed to load the optional jrrd library.<br>
&nbsp; - This error is not fatal, since jrrd is only required for optional \
features.<br> &nbsp; - For more information, see <a \
href="http://www.opennms.org/index.php/jrrd">http://www.opennms.org/index.php/jrrd</a><br>
                
- using SQL directory... /opt/opennms/etc<br>
- using create.sql... /opt/opennms/etc/create.sql<br>
Exception in thread &quot;main&quot; org.opennms.core.schema.MigrationException: an \
error occurred getting the version from the database<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:178)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:206)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.opennms.install.Installer.install(Installer.java:226)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.opennms.install.Installer.main(Installer.java:950)<br> Caused by: \
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host \
&quot;10.212.96.35&quot;, user &quot;postgres&quot;, database &quot;template1&quot;, \
SSL off<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)<br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)<br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.jdbc2.AbstractJdbc2Connection.&lt;init&gt;(AbstractJdbc2Connection.java:125)<br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.jdbc3.AbstractJdbc3Connection.&lt;init&gt;(AbstractJdbc3Connection.java:30)<br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.jdbc3g.AbstractJdbc3gConnection.&lt;init&gt;(AbstractJdbc3gConnection.java:22)<br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.jdbc4.AbstractJdbc4Connection.&lt;init&gt;(AbstractJdbc4Connection.java:30)<br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.jdbc4.Jdbc4Connection.&lt;init&gt;(Jdbc4Connection.java:24)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.Driver.makeConnection(Driver.java:393)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.postgresql.Driver.connect(Driver.java:267)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
java.sql.DriverManager.getConnection(DriverManager.java:582)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
java.sql.DriverManager.getConnection(DriverManager.java:154)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.opennms.netmgt.dao.db.SimpleDataSource.getConnection(SimpleDataSource.java:90)<br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \
org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:166)<br> \
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ... 3 more <br> &nbsp;<br>
&nbsp;Please help in resolving this issue. \
------------------------------------------------------------------------------<br> \
Live Security Virtual Conference<br> Exclusive live event will cover all the ways \
today's security and <br> threat landscape has changed and how IT managers can \
respond. Discussions <br> will include endpoint security, mobile security and the \
latest in malware <br> threats. <a \
href="http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________">
 http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________</a><br>
 Please read the OpenNMS Mailing List FAQ:<br>
<a href="http://www.opennms.org/index.php/Mailing_List_FAQ">http://www.opennms.org/index.php/Mailing_List_FAQ</a><br>
 <br>
opennms-install mailing list<br>
<br>
To *unsubscribe* or change your subscription options, see the bottom of this \
page:<br> <a href="https://lists.sourceforge.net/lists/listinfo/opennms-install">https://lists.sourceforge.net/lists/listinfo/opennms-install</a></blockquote>
 </div>
<br>
</div>
</body>
</html>


[Attachment #4 (--===============3135177144046948103==)]
------------------------------------------------------------------------------
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

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic