Re: [opennms-discuss] Installing 1.8 where postgress is running in remote machine
joe fu <[email protected]>
| Newsgroups | gmane.network.opennms.install,gmane.network.opennms.general |
|---|---|
| Message-ID | <[email protected]> |
Thanks Bradley for the quick response.
As I mentioned in my original email:
1) OpenNMS1.8 @SRV2 can contact postgres@SRV1
->Postgresql.conf file has entries like
listen_addresses = '*' # what IP address(es) to listen
on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
port = 5432 # (change requires
restart)
2) Changes are made to opennms-datasources.xml to contact SRV1:5432,
database-name="opennms18", with appropriate credentials.
-> There is a problem here. OpenNMS1.8 @SRV2 can connect to
postgres@SRV1 using above info but not to database 'opennms18'. Instead
OpenNMS1.8 is accessing database 'opennms'! I think this is a bug.
In summary I think there is two bug:
1) OpenNMS ignores 'database-name' value.
When opennms-datasources.xml is configured to use database 'opennms18',
OpenNMS1.8 ignores it and continues to access 'opennms' database.
2) Installer "$OPENNMS_HOME/bin/install -dis" also has same problem where it
connects to Postgres@SRV1 but updates database 'opennms' instead of
'opennms18'! It doesn't use database-name attribute from
opennms-datasources.xml.
==
Thanks,
Joe
On Tue, Jun 22, 2010 at 9:20 PM, Bradley Willson <
[email protected]> wrote:
> And finally...
>
>
> <jdbc-data-source name="opennms"
> database-name="opennms18"
> class-name="org.postgresql.
> Driver"
> url="jdbc:postgresql://192.168.1.75:5432/opennms18<http://192.168.1.75:5432/opennms>
> "
>
> user-name="opennms"
> password="opennms" />
>
> Might work better...
>
>
> On Tue, Jun 22, 2010 at 8:25 AM, joe fu <[email protected]> wrote:
>
>> Hello,
>>
>> Currently, we are using 1.6.10 and we want to qualify 1.8 for deployment.
>>
>>
>> We have a server (SRV1 - 192.168.1.75) running OpenNMS 1.6.10 and postgres
>> DB. Postgres auth file pg_hba files are setup to accept connection from
>> localhost and from network. This setup is working fine.
>> --pg_hba--
>> local all all trust
>> host all all 127.0.0.1/32 trust
>> host all all 192.168.0.0/16 trust
>> host all all ::1/128 trust
>> -----end pg_hba--
>>
>> We are working on making SRV1 as database server in long term and move all
>> applications (openNms like) to different servers.
>>
>> I have downloaded 1.8 opennms and installed in another server (SRV2 -
>> 192.168.1.x). Now I need somehelp in convincing new 1.8 to talk to postgres
>> in SRV1.
>>
>> == Steps followed ==
>> 1) [SRV1] created new database 'opennms18' for OpenNMS 1.8 usage
>> 2) [SRV2] $OPENNMS_HOME/etc/opennms-datasource.xml has been modified to
>> talk to SRV1:5432 and access database opennm18
>> ----opennms-datasource.xml----
>> <jdbc-data-source name="opennms"
>> database-name="opennms18"
>> class-name="org.postgresql.Driver"
>> url="jdbc:postgresql://192.168.1.75:5432/opennms"
>> user-name="opennms"
>> password="opennms" />
>>
>> <jdbc-data-source name="opennms-admin"
>> database-name="template1"
>> class-name="org.postgresql.Driver"
>> url="jdbc:postgresql://192.168.1.75:5432/template1"
>> user-name="postgres"
>> password="" />
>> ----end .xml ---
>>
>>
>> == Problems ==
>>
>> Problem-1) How do I convince installer
>>
>> $OPENNMS_HOME/bin/install -dis
>>
>> to connect to SRV1 and create all new tables in database 'opennms18'? Is
>> this possible?
>> I just ran above command to setup DB and no tables were created in
>> postgres running in SRV1:5432 (SRV1 - psql - \c opennms18 ; \d ; gave 'no
>> relations' message).
>>
>>
>> Problem-2) How do I convince OpenNMS-1.8 to use database 'opennms18'?
>> After making .xml changes, if I start opennms, OpenNMS1.8 connects to
>> SRV1:5432 but it continues to access database 'opennms' instead of
>> 'opennms18'. (When I login into OpenNMS1.8 it starts displaying all nodes
>> that were configured for OpenNMS 1.6.10). How do I get this resolved?
>>
>> We are planning to host postgress in a central server with good HW
>> configuration so that we can make good use of it for other applications too.
>> I am currently stuck with above two problems.
>>
>> Any workaround/fixes?
>>
>> Thanks,
>> Joe
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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-discuss mailing list
>>
>> To *unsubscribe* or change your subscription options, see the bottom of
>> this page:
>> https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>>
>
>
>
> --
> Best regards,
> Bradley Willson
> 425.296.1687
> http://www.linkedin.com/in/bradleywillson
>
>
>
> ------------------------------------------------------------------------------
> 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-discuss mailing list
>
> To *unsubscribe* or change your subscription options, see the bottom of
> this page:
> https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
------------------------------------------------------------------------------
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