Re: v 21.0.0
Jonathan Heard <[email protected]>
| Newsgroups | gmane.network.opennms.general |
|---|---|
| Message-ID | <[email protected]> |
As you've only got a few nodes registered you can easily just do a 'SELECT * FROM node;' to see all nodes, and then you'll be able to see if, for example' it actually puts the foreignsource in lower case or something? On 16/11/17 14:56, Colin Bell via opennms-discuss wrote: > > My permissions on the opennms account in postgress is exactly the same > as you’ve posted. > > The command > > SELECT * FROM node WHERE foreignsource LIKE 'SNMPv3' > > Doesn’t appear to return anything, was expecting to see a list of nodes > > *Colin Bell*/ > Senior Solutions Architect (Technology)/ > > /Enterprise Architect Team/ > > /IT/ > > /Renfrewshire House, Cotton Street, Paisley, PA1 1HY/ > <http://maps.renfrewshire.gov.uk/LocalView/Sites/MyCouncil/?identifyitem=layer1:0:OBJECTID:13&scale=2500&layers=layer1:0>/ > Mobile: 07796941786 > Desk: 0141 618 4848/ > > /Email: /[email protected] > <mailto:[email protected]>/ > Web: //Renfrewshire Council Website/ <http://www.renfrewshire.gov.uk/>// > > *From:*Jonathan Heard [mailto:[email protected]] > *Sent:* 16 November 2017 12:59 > *To:* [email protected] > *Subject:* Re: [opennms-discuss] v 21.0.0 > > Hi Colin, > > I meant to say in my previous the <fs> is a placeholder for the name > of the requisition in question but I guess you figured that out. > > Please see my email from a short while ago about collecting some debug > info. Have you edited the default foreign source at all - it would be > evident if the file /etc/opennms/default-foreign-source.xml exists > (it's only created if the defaults are changed). > > When you import a requisition it is typically stored in an XML file > like the SNMPv3.xml file you found, and then 'synchronised' with the > Postgres database. My limited understanding was that this is typically > a one-way sync from the XML to the database but I think you must be > experiencing an issue whereby the database entries aren't dropped and > are being used to repopulate the XML files. > > It would be worth checking your Postgres configuration to ensure that > OpenNMS has sufficient privileges to delete entries. > > root@opennms# su postgres -c psql > postgres=# \l > List of databases > Name | Owner | Encoding | Collate | Ctype | Access > privileges > -----------+----------+----------+-------------+-------------+----------------------- > opennms | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > =T/postgres + > | | | | | postgres=CTc/postgres+ > | | | | | *opennms=CTc/postgres* > > If these permissions are wrong, then when you delete your requisition > it perhaps fails to delete the nodes from the database (the debug log > should indicate this). > > Make sure you have at least something like this in > /etc/opennms/opennms-datasources.xml > > <jdbc-data-source name="opennms" > database-name="opennms" > class-name="org.postgresql.Driver" > url="jdbc:postgresql://localhost:5432/opennms" > user-name="opennms" > password="/OPENMS_PASSWORD/" /> > > <jdbc-data-source name="opennms-admin" > database-name="template1" > class-name="org.postgresql.Driver" > url="jdbc:postgresql://localhost:5432/template1" > user-name="postgres" > password="/POSTGRES_PASSWORD/" /> > > If you really want to nuke the SNMPv3 requisition then you should be > able to connect to postgres as above (with OpenNMS stopped) and do: > > \c opennms > \x > SELECT * FROM node WHERE foreignsource LIKE 'SNMPv3' > > Assuming the list of nodes is what you'd expect, you can delete them with: > > DELETE from node WHERE foreignsource LIKE 'SNMPv3' > > If they come back from the dead after deleting the XML and the DB > entries then I'm stumped. However, you should not have to do this > normally and my current suspicion lies with database permissions. > > HTH > > Jonathan > > On 16/11/17 11:21, Colin Bell via opennms-discuss wrote: > > Hi > > So I went into the following directories after stopping the > opennms service > > /etc/import/<fs>.xml – Removed file called SNMPv3.xml (this is the > name of the requisition) > > /etc/import/pending/<fs>.xml – Empty > > /etc/foreign-sources/<fs>.xml – Empty > > /etc/foreign-sources/pending/<fs>.xml – Empty > > Restarted Opennms and the requisition was still there and the file > /etc/import/SNMPv3.xml returned. > > *Colin Bell*/ > Senior Solutions Architect (Technology)/ > > /Enterprise Architect Team/ > > /IT/ > > /Renfrewshire House, Cotton Street, Paisley, PA1 1HY/ > <http://maps.renfrewshire.gov.uk/LocalView/Sites/MyCouncil/?identifyitem=layer1:0:OBJECTID:13&scale=2500&layers=layer1:0>/ > Mobile: 07796941786 > Desk: 0141 618 4848/ > > /Email: /[email protected] > <mailto:[email protected]>/ > Web: //Renfrewshire Council Website/ <http://www.renfrewshire.gov.uk/> > > *From:*Jonathan Heard [mailto:[email protected]] > *Sent:* 15 November 2017 15:24 > *To:* [email protected] > <mailto:[email protected]> > *Subject:* Re: [opennms-discuss] v 21.0.0 > > Hi Colin, > > I agree that what Ronny has suggested should work - However, if > you're using any kind of automatic provisioning such as from > VMWare ESXi or DNS (as would be configured in > provisiond-configuration.xml) then deleted requisitions would be > rediscovered every time the automatic provisioning runs until you > disable it. > > Assuming you just used the GUI to create a requisition and then > add some hosts you should be able to get rid of it using Ronny's > instructions. However as a last resort, you could stop the opennms > service and delete /etc/import/<fs>.xml , > /etc/import/pending/<fs>.xml , /etc/foreign-sources/<fs>.xml and > /etc/foreign-sources/pending/<fs>.xml (The 'pending' directories > should be empty but I mention them in case they aren't)... Then > when you restart OpenNMS the requisition should be complete gone. > > Good Luck :-) > > Jonathan > > On 15/11/17 11:03, Ronny Trommer wrote: > > Hi Colin, > > first of all delete all nodes in the requisition. Synchronise > the empty requisition and make sure you have 0 nodes in the > database from your requisition. Afterwards you can delete the > empty requisition. > > Do you just use the Web UI to generate them? > > On 15. Nov 2017, at 11:12, Colin Bell via opennms-discuss > <[email protected] > <mailto:[email protected]>> wrote: > > Can anyone help with this? Is this actually a bug? > > *Colin Bell*/ > Senior Solutions Architect (Technology)/ > > /Enterprise Architect Team/ > > /IT/ > > /Renfrewshire House, Cotton Street, Paisley, PA1 1HY/ > <http://maps.renfrewshire.gov.uk/LocalView/Sites/MyCouncil/?identifyitem=layer1:0:OBJECTID:13&scale=2500&layers=layer1:0>/ > Mobile: 07796941786 > Desk: 0141 618 4848/ > > /Email:/[email protected] > <mailto:[email protected]>/ > Web://Renfrewshire Council Website/ > <http://www.renfrewshire.gov.uk/> > > *From:*Colin Bell via opennms-discuss > [mailto:[email protected]] > *Sent:*13 November 2017 14:12 > *To:*General OpenNMS Discussion > <[email protected] > <mailto:[email protected]>> > *Cc:*Colin Bell <[email protected] > <mailto:[email protected]>> > *Subject:*Re: [opennms-discuss] v 21.0.0 > > Where to I find this synchronize? Once I delete the > requisition there is no option to synchronize. Also after > choosing the “remove all nodes” the pop up says nodes > have been removed and the requisition has been synchronized. > > Why does the requisition keep re-appearing? Along with > the nodes? > > Hi Colin, > > you have to synchronize it. There is a button in the menu. > > -- > > Marcel > > Am 10.11.2017 um 11:31 schrieb Colin Bell via opennms-discuss: > > > > > > Im setting up a new OpenNMS environment for the first time. > > > > > > I had created a new requisitioning but I would like to remove it. > > > From the Admin section in the GUI I choose Manage Provisioning > > > Requisitions, I then remove all nodes and deleted requisition. > > > > > > When I leave and come back to this page, the requisition returns. > > > What am I missing? > > > > > > *Colin Bell*/ > > *Colin Bell*/ > Senior Solutions Architect (Technology)/ > > /Enterprise Architect Team/ > > /IT/ > > /Renfrewshire House, Cotton Street, Paisley, PA1 1HY/ > <http://maps.renfrewshire.gov.uk/LocalView/Sites/MyCouncil/?identifyitem=layer1:0:OBJECTID:13&scale=2500&layers=layer1:0>/ > Mobile: 07796941786 > Desk: 0141 618 4848/ > > /Email:/[email protected] > <mailto:[email protected]>/ > Web://Renfrewshire Council Website/ > <http://www.renfrewshire.gov.uk/> > > Renfrewshire Council Website -http://www.renfrewshire.gov.uk > > This email and any files transmitted with it are > confidential and intended solely for the use of the > individual or entity to whom they are addressed. If you > have received this email in error please notify the system > manager. Renfrewshire Council may, in accordance with the > Telecommunications(Lawful Business Practice) (Interception > of Communications) Regulations 2000, intercept e-mail > messages for the purpose of monitoring or keeping a record > of communications on the Council's system. If a message > contains inappropriate dialogue it will automatically be > intercepted by the Council's Internal Audit section who > will decide whether or not the e-mail should be onwardly > transmitted to the intended recipient(s). > > Paisley2021 Facebook <http://www.paisley2021.co.uk/> > > *Paisley2021 Facebook /paisley2021 * > <https://www.facebook.com/paisley2021/> > > > > *Paisley2021 Twitter @Paisley2021 * > <https://twitter.com/paisley2021> > > > > *Paisley2021 /paisley2021* > <https://www.instagram.com/paisley2021/> > > Renfrewshire Council is decommissioning all gcsx email > between now and November 2017. The Council email domain > will change to @renfrewshire.gov.uk. My new email address > will still allow me to send email to you securely as it > meets the UK Government’s Secure Email Blueprint (SEB) > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's > most > engaging tech sites, Slashdot.org <http://Slashdot.org>! > http://sdm.link/slashdot_______________________________________________ > 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 > > > > > > ------------------------------------------------------------------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, Slashdot.org!http://sdm.link/slashdot > > > > > > _______________________________________________ > > 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 > > Renfrewshire Council Website -http://www.renfrewshire.gov.uk > > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom > they are addressed. If you have received this email in error > please notify the system manager. Renfrewshire Council may, in > accordance with the Telecommunications(Lawful Business Practice) > (Interception of Communications) Regulations 2000, intercept > e-mail messages for the purpose of monitoring or keeping a record > of communications on the Council's system. If a message contains > inappropriate dialogue it will automatically be intercepted by the > Council's Internal Audit section who will decide whether or not > the e-mail should be onwardly transmitted to the intended > recipient(s). > > Paisley2021 Facebook <http://www.paisley2021.co.uk/> > > *Paisley2021 Facebook /paisley2021 * > <https://www.facebook.com/paisley2021/> > > > > *Paisley2021 Twitter @Paisley2021 * <https://twitter.com/paisley2021> > > > > *Paisley2021 /paisley2021* <https://www.instagram.com/paisley2021/> > > Renfrewshire Council is decommissioning all gcsx email between now > and November 2017. The Council email domain will change to > @renfrewshire.gov.uk. My new email address will still allow me to > send email to you securely as it meets the UK Government’s Secure > Email Blueprint (SEB) > > > > > ------------------------------------------------------------------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, Slashdot.org!http://sdm.link/slashdot > > > > > _______________________________________________ > > 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 > > Renfrewshire Council Website -http://www.renfrewshire.gov.uk > > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. Renfrewshire Council may, in accordance with the > Telecommunications(Lawful Business Practice) (Interception of > Communications) Regulations 2000, intercept e-mail messages for the > purpose of monitoring or keeping a record of communications on the > Council's system. If a message contains inappropriate dialogue it will > automatically be intercepted by the Council's Internal Audit section > who will decide whether or not the e-mail should be onwardly > transmitted to the intended recipient(s). > > Paisley2021 Facebook <http://www.paisley2021.co.uk/> > > Paisley2021 Facebook /paisley2021 > <https://www.facebook.com/paisley2021/> Paisley2021 > Twitter @Paisley2021 <https://twitter.com/paisley2021> > Paisley2021 /paisley2021 <https://www.instagram.com/paisley2021/> > > Renfrewshire Council is decommissioning all gcsx email between now and > November 2017. The Council email domain will change to > @renfrewshire.gov.uk. My new email address will still allow me to send > email to you securely as it meets the UK Government’s Secure Email > Blueprint (SEB) > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > > _______________________________________________ > 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 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ 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