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 (gr...@opm-computer.de).
Mit freundlichen Grüßen
Ronny Bär
OPM IT Service GmbH
Send icinga-users mailing list submissions to
icinga-users@lists.icinga.org
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
icinga-users-requ...@lists.icinga.org
You can reach the person managing the list at
icinga-users-ow...@lists.icinga.org
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 <steph...@sources.org>
To: icinga-users@lists.icinga.org
Subject: Re: [icinga-users] After some minutes with erroneous time, I
would like to clean the database
Message-ID: <20190502090306.jeyvokkyoi2hv...@sources.org>
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 <steph...@sources.org> 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 <antony.st...@icinga.open.source.it>
To: "Icinga User's Corner" <icinga-users@lists.icinga.org>
Subject: Re: [icinga-users] After some minutes with erroneous time, I
would like to clean the database
Message-ID: <201905021151.39314.antony.st...@icinga.open.source.it>
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 <steph...@sources.org> 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
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users
------------------------------
End of icinga-users Digest, Vol 65, Issue 1
*******************************************
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users
