Re: [opennms-devel] problem with opennms-datasources.xml?

I don't think so. I did a fresh checkout, bulld and install in a new
directory. Also, I noticed that the current opennms-datasources.xml
file seems to mix postgres and template1 since it has
database-name="template1" and
url="jdbc:postgresql://localhost:5432/postgres". Shouldn't they both
be either template1 or postgres?

--Bill--


On Tue, Jun 17, 2008 at 7:06 PM, DJ Gregor <[email protected]> wrote:
> You kinda hit bug #2369, but it looks like you have a combination of an
> older opennms-datasources.xml file and newer installer code.  Did you
> upgrade but miss the changes to opennms-datasources.xml (it has switched
> back to using template1 instead of postgres for the administrative
> database)?
>
> See:
> http://bugzilla.opennms.org/show_bug.cgi?id=2369
>
> On Tue, 17 Jun 2008 17:07:57 -0700, "bill ayres" <[email protected]>
> said:
>> I just installed revision 9387 and encountered a problem running install.
>>
>> - checking database version... Exception in thread "main"
>> 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/postgres',
>> driver class='org.postgresql.Driver', properties: user='postgres',
>> password=''].  Original error: org.postgresql.util.PSQLException:
>> FATAL: database "postgres" does not exist
>>
>>
>> I fixed this by editing opennms-datasources.xml and changing
>>
>> url="jdbc:postgresql://localhost:5432/postgres"
>>
>> to
>>
>> url="jdbc:postgresql://localhost:5432/template1"
>>
>> I assume this is an error in the file, or should I have done something
>> else?
>>
>> --Bill--
>>
>> -------------------------------------------------------------------------
>> Check out the new SourceForge.net Marketplace.
>> It's the best place to buy or sell services for
>> just about anything Open Source.
>> http://sourceforge.net/services/buy/index.php
>> _______________________________________________
>> Please read the OpenNMS Mailing List FAQ:
>> http://www.opennms.org/index.php/Mailing_List_FAQ
>>
>> opennms-devel mailing list
>>
>> To *unsubscribe* or change your subscription options, see the bottom of
>> this page:
>> https://lists.sourceforge.net/lists/listinfo/opennms-devel
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Please read the OpenNMS Mailing List FAQ:
> http://www.opennms.org/index.php/Mailing_List_FAQ
>
> opennms-devel mailing list
>
> To *unsubscribe* or change your subscription options, see the bottom of this page:
> https://lists.sourceforge.net/lists/listinfo/opennms-devel
>

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

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