Sehr geehrte Damen und Herren,
in der Zeit vom 29.04.2019 bis einschließlich 19.05.2019 befinde ich mich nicht im Büro. Beachten Sie bitte, dass Ihre E-Mail nicht automatisch weitergeleitet wird. In dringenden Fällen wenden Sie sich bitte an unsere Hotline, 0203-378530, oder an Herrn Gries ([email protected]). Mit freundlichen Grüßen Ronny Bär OPM IT Service GmbH Send icinga-users mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://lists.icinga.org/mailman/listinfo/icinga-users or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of icinga-users digest..." Today's Topics: 1. Re: After some minutes with erroneous time, I would like to clean the database (Stephane Bortzmeyer) 2. Re: After some minutes with erroneous time, I would like to clean the database (Antony Stone) ---------------------------------------------------------------------- Message: 1 Date: Thu, 2 May 2019 11:03:06 +0200 From: Stephane Bortzmeyer <[email protected]> To: [email protected] Subject: Re: [icinga-users] After some minutes with erroneous time, I would like to clean the database Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii [Are there still people using Icinga? I see no traffic on the list.] On Wed, Apr 17, 2019 at 08:27:17AM +0200, Stephane Bortzmeyer <[email protected]> wrote a message of 17 lines which said: > But the notifications widget is unusable since it is sorted by date > and notifications erroneously in the future block the beginning of the > widget. > > How to remove all these notifications (and all events during this > period) from the database? In the end, I connected directly to the PostgreSQL database with 'sudo -u postgres psql icinga' and did: BEGIN; DELETE FROM icinga_notifications WHERE start_time > '2019-06-12'; DELETE FROM icinga_contactnotifications WHERE start_time > '2019-06-12'; COMMIT; It seems to work. ------------------------------ Message: 2 Date: Thu, 2 May 2019 11:51:39 +0200 From: Antony Stone <[email protected]> To: "Icinga User's Corner" <[email protected]> Subject: Re: [icinga-users] After some minutes with erroneous time, I would like to clean the database Message-ID: <[email protected]> Content-Type: Text/Plain; charset="iso-8859-1" On Thursday 02 May 2019 at 11:03:06, Stephane Bortzmeyer wrote: > [Are there still people using Icinga? I see no traffic on the list.] I'm still happily using it, and I normally only send traffic to the list when I have a problem :) High volume traffic on a support list is often an indication that the documentation is poor... Antony. > On Wed, Apr 17, 2019 at 08:27:17AM +0200, > Stephane Bortzmeyer <[email protected]> wrote > > a message of 17 lines which said: > > But the notifications widget is unusable since it is sorted by date > > and notifications erroneously in the future block the beginning of the > > widget. > > > > How to remove all these notifications (and all events during this > > period) from the database? > > In the end, I connected directly to the PostgreSQL database with 'sudo > -u postgres psql icinga' and did: > > BEGIN; > DELETE FROM icinga_notifications WHERE start_time > '2019-06-12'; > DELETE FROM icinga_contactnotifications WHERE start_time > '2019-06-12'; > COMMIT; > > It seems to work. -- #define SIX 1+5 #define NINE 8+1 int main() { printf("%d\n", SIX * NINE); } - thanks to ECB for bringing this to my attention Please reply to the list; please *don't* CC me. ------------------------------ Subject: Digest Footer _______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users ------------------------------ End of icinga-users Digest, Vol 65, Issue 1 ******************************************* _______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users
