Installing 1.8 where postgress is running in remote machine

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