Re: opennms on ubuntu 10.04 x64

Hi ec,

Configure the username/password for your Postgres server
in /usr/share/opennms/opennms-datasources.xml

Daniel

On Wed, Jun 23, 2010 at 10:49, Edmond Cukalla <[email protected]> wrote:

> hi all,
>
> i have installed opennms from packages but when i try to start it i get the
> following error:
>
> root:/usr/share/opennms/bin# /etc/init.d/opennms start
> Starting Open Network Management System: opennms/usr/sbin/opennms: OpenNMS
> not configured.
> /usr/share/opennms/etc/configured does not exist.
>
> You need to run the installer to set up the database.  In most
> cases, it is enough to run:
>
>   /usr/share/opennms/bin/install -dis
>
> For details, see the install guide at:
>
>
> http://www.opennms.org/index.php/QuickStart#Initialize_OpenNMS_and_the_Database
>
> root:/usr/share/opennms/bin#  /usr/share/opennms/bin/install -dis
>
> ==============================================================================
> OpenNMS Installer Version $Id$
>
> ==============================================================================
>
> Configures PostgreSQL tables, users, and other miscellaneous settings.
>
> - searching for jicmp:
>   - trying to load /usr/lib64/jni/libjicmp.so: OK
> - searching for jrrd:
>   - trying to load /usr/lib64/jni/libjrrd.so: OK
> - using SQL directory... /usr/share/opennms/etc
> - using create.sql... /usr/share/opennms/etc/create.sql
> Exception in thread "main" java.lang.Exception: The database server's error
> messages are not in English, however the installer requires them to be in
> English when using PostgreSQL earlier than 7.4.  You either need to set
> "lc_messages = 'C'" in your postgresql.conf file and restart PostgreSQL or
> upgrade to PostgreSQL 7.4 or later.  The installer executed the query
> "SELECT bogus_column_1277304222456 FROM bogus_table_1277304222456 WHERE
> another_bogus_column_1277304222456 IS NULL" and expected "does not exist" in
> the error message, but this exception was received instead:
> java.sql.SQLException: Could not get an administrative connection to the
> database.  Is the database running, listening for TCP connections, and
> allowing us to connect and authenticate from localhost?  Tried connecting to
> database specified by data source
> SimpleDataSource[URL='jdbc:postgresql://localhost:5432/template1', driver
> class='org.postgresql.Driver', properties: user='postgres', password=''].
>  Original error: org.postgresql.util.PSQLException: FATAL: password
> authentication failed for user "postgres"
>         at
> org.opennms.netmgt.dao.db.InstallerDb.databaseCheckLanguage(InstallerDb.java:1615)
>         at org.opennms.install.Installer.install(Installer.java:225)
>         at org.opennms.install.Installer.main(Installer.java:859)
> Caused by: java.sql.SQLException: Could not get an administrative
> connection to the database.  Is the database running, listening for TCP
> connections, and allowing us to connect and authenticate from localhost?
>  Tried connecting to database specified by data source
> SimpleDataSource[URL='jdbc:postgresql://localhost:5432/template1', driver
> class='org.postgresql.Driver', properties: user='postgres', password=''].
>  Original error: org.postgresql.util.PSQLException: FATAL: password
> authentication failed for user "postgres"
>         at
> org.opennms.netmgt.dao.db.InstallerDb.rethrowDatabaseConnectionException(InstallerDb.java:2248)
>         at
> org.opennms.netmgt.dao.db.InstallerDb.initializeAdminConnection(InstallerDb.java:2225)
>         at
> org.opennms.netmgt.dao.db.InstallerDb.getAdminConnection(InstallerDb.java:2214)
>         at
> org.opennms.netmgt.dao.db.InstallerDb.databaseCheckLanguage(InstallerDb.java:1604)
>         ... 2 more
> Caused by: org.postgresql.util.PSQLException: FATAL: password
> authentication failed for user "postgres"
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
>         at
> org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
>          at
> org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.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:525)
>         at java.sql.DriverManager.getConnection(DriverManager.java:140)
>         at
> org.opennms.netmgt.dao.db.SimpleDataSource.getConnection(SimpleDataSource.java:79)
>         at
> org.opennms.netmgt.dao.db.InstallerDb.initializeAdminConnection(InstallerDb.java:2223)
>         ... 4 more
> root:/usr/share/opennms/bin#
>
>
> Can any one give me a hint?
>
> Thanks,
> ec
>
>
> ------------------------------------------------------------------------------
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit.  See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo
> _______________________________________________
> 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
>



-- 
Daniel Geske
Technology Director
Horn Group -- Digital Communications for Technology Companies
www.horngroup.com
(O) 646.202.9762
[email protected]

Awards - www.horngroup.com/company-awards
Brass Tacks Blog - horngroup.blogs.com
Twitter - twitter.com/horngroup

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo

_______________________________________________
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