[prev in list] [next in list] [prev in thread] [next in thread]
List: opennms-install
Subject: Re: [opennms-install] [opennms-discuss] Installing 1.8 where
From: joe fu <joefuu10 () gmail ! com>
Date: 2010-06-23 5:30:28
Message-ID: AANLkTinO1JWdX78T3ghHp-8TFTLzDqm_7hi9A7wPF8U4 () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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 <
bradley.j.willson@gmail.com> 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 <joefuu10@gmail.com> 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
>
[Attachment #5 (text/html)]
Thanks Bradley for the quick response.<br><br>As I mentioned in my original \
email:<br>1) OpenNMS1.8 @SRV2 can contact postgres@SRV1<br> ->Postgresql.conf \
file has entries like<br> listen_addresses = '*' # what IP \
address(es) to listen on;<br> # comma-separated list of addresses;<br> \
# defaults to 'localhost', '*' = all<br> \
# (change requires restart)<br> port = 5432 # (change \
requires restart)<br>2) Changes are made to opennms-datasources.xml to contact \
SRV1:5432, database-name="opennms18", with appropriate \
credentials. <br>
-> 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.<br> <br>In summary I \
think there is two bug:<br><br>1) OpenNMS ignores 'database-name' value. <br> \
When opennms-datasources.xml is configured to use database 'opennms18', \
OpenNMS1.8 ignores it and continues to access 'opennms' database.<br> <br>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.<br> <br>==<br>Thanks,<br>Joe<br><br><br><br><div \
class="gmail_quote">On Tue, Jun 22, 2010 at 9:20 PM, Bradley Willson <span \
dir="ltr"><<a href="mailto:bradley.j.willson@gmail.com">bradley.j.willson@gmail.com</a>></span> \
wrote:<br> <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, \
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">And finally...<div \
class="im"><br><br> <jdbc-data-source name="opennms"<br> \
database-name="opennms18"<br>
class-name="org.postgresql.</div><div>Driver"<br> \
url="jdbc:postgresql://<a href="http://192.168.1.75:5432/opennms" \
target="_blank">192.168.1.75:5432/opennms<span style="background-color: rgb(255, 255, \
51);">18</span></a><span style="background-color: rgb(255, 255, \
51);">"</span><div class="im"> <br>
user-name="opennms"<br>
password="opennms" /></div></div><br>Might work \
better...<br><br><br><div class="gmail_quote"><div class="im">On Tue, Jun 22, 2010 at \
8:25 AM, joe fu <span dir="ltr"><<a href="mailto:joefuu10@gmail.com" \
target="_blank">joefuu10@gmail.com</a>></span> wrote:<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, \
204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div \
class="h5">Hello,<br><br>Currently, we are using 1.6.10 and we want to qualify 1.8 \
for deployment. <br>
<br>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.<br>
--pg_hba--<br>local all all trust<br>host \
all all <a href="http://127.0.0.1/32" \
target="_blank">127.0.0.1/32</a> trust<br>host all all <a \
href="http://192.168.0.0/16" target="_blank">192.168.0.0/16</a> trust<br>
host all all ::1/128 trust<br>-----end \
pg_hba--<br><br>We are working on making SRV1 as database server in long term and \
move all applications (openNms like) to different servers.<br><br>
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. <br><br>== \
Steps followed ==<br>1) [SRV1] created new database 'opennms18' for OpenNMS \
1.8 usage<br>
2) [SRV2] $OPENNMS_HOME/etc/opennms-datasource.xml has been modified to talk to \
SRV1:5432 and access database opennm18<br>----opennms-datasource.xml----<br> \
<jdbc-data-source name="opennms"<br> \
database-name="opennms18"<br>
class-name="org.postgresql.Driver"<br> \
url="jdbc:postgresql://<a href="http://192.168.1.75:5432/opennms" \
target="_blank">192.168.1.75:5432/opennms</a>"<br> \
user-name="opennms"<br>
password="opennms" /><br><br> <jdbc-data-source \
name="opennms-admin"<br> \
database-name="template1"<br> \
class-name="org.postgresql.Driver"<br>
url="jdbc:postgresql://<a \
href="http://192.168.1.75:5432/template1" \
target="_blank">192.168.1.75:5432/template1</a>"<br> \
user-name="postgres"<br> password="" /><br>
----end .xml ---<br><br><br>== Problems ==<br><br>Problem-1) How do I convince \
installer<br><pre> $OPENNMS_HOME/bin/install -dis<br></pre>to connect to SRV1 and \
create all new tables in database 'opennms18'? Is this possible?<br>
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).<br><br><br>Problem-2) How do I convince OpenNMS-1.8 to use database \
'opennms18'?<br>
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?<br>
<br>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. <br><br>Any workaround/fixes?<br>
<br>Thanks,<br><font color="#888888">Joe<br><br><br><br>
</font><br></div></div><div \
class="im">------------------------------------------------------------------------------<br>
ThinkGeek and WIRED's GeekDad team up for the Ultimate<br>
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the<br>
lucky parental unit. See the prize list and enter to win:<br>
<a href="http://p.sf.net/sfu/thinkgeek-promo" \
target="_blank">http://p.sf.net/sfu/thinkgeek-promo</a><br>_______________________________________________<br>
Please read the OpenNMS Mailing List FAQ:<br>
<a href="http://www.opennms.org/index.php/Mailing_List_FAQ" \
target="_blank">http://www.opennms.org/index.php/Mailing_List_FAQ</a><br> <br>
opennms-discuss 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-discuss" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/opennms-discuss</a><br></div></blockquote></div><div><div></div><div \
class="h5"><br><br clear="all"> <br>-- <br>Best regards, <br>
Bradley Willson<br><a title="phone number" style="color: rgb(19, 19, 83); \
background-color: rgb(255, 255, 191);">425.296.1687</a><br> <a \
href="http://www.linkedin.com/in/bradleywillson" \
target="_blank">http://www.linkedin.com/in/bradleywillson</a><br><br> \
</div></div><br>------------------------------------------------------------------------------<br>
ThinkGeek and WIRED's GeekDad team up for the Ultimate<br>
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the<br>
lucky parental unit. See the prize list and enter to win:<br>
<a href="http://p.sf.net/sfu/thinkgeek-promo" \
target="_blank">http://p.sf.net/sfu/thinkgeek-promo</a><br>_______________________________________________<br>
Please read the OpenNMS Mailing List FAQ:<br>
<a href="http://www.opennms.org/index.php/Mailing_List_FAQ" \
target="_blank">http://www.opennms.org/index.php/Mailing_List_FAQ</a><br> <br>
opennms-discuss 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-discuss" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/opennms-discuss</a><br></blockquote></div><br>
------------------------------------------------------------------------------
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic