Clear alert for deleted node

The forum for help and support with FreeNATS as well as any useful hints and tips
Post Reply
paullanders
Posts: 92
Joined: Thu Sep 04, 2008 9:48 pm

Clear alert for deleted node

Post by paullanders » Wed Nov 12, 2008 8:44 pm

Hi Dave.

I removed a node that no longer exists, but the alert in the NATS ALERT window is still there. How do I remove this 'stuck' alert?

Thanks!

P.S. I was going to upload a screen shot but I don't see the option to upload files to the forum.

Paul

dave
Site Admin
Posts: 260
Joined: Fri May 30, 2008 9:09 pm
Location: UK
Contact:

Re: Clear alert for deleted node

Post by dave » Wed Nov 12, 2008 11:04 pm

Hi Paul,

Yes this is a known quirk (which I said I'd do something about but haven't) :(

What you need to do is execute the following through the SQL console (you may need to enable this, see here):

Code: Select all

update fnalert set closedx=now() where nodeid="your_node_id"
I really really must put a manual close option in if not sort out the deletions properly.

Hope that helps,

Dave.

paullanders
Posts: 92
Joined: Thu Sep 04, 2008 9:48 pm

Re: Clear alert for deleted node

Post by paullanders » Wed Nov 12, 2008 11:13 pm

Worked beautifully! Thanks!

dave
Site Admin
Posts: 260
Joined: Fri May 30, 2008 9:09 pm
Location: UK
Contact:

Re: Clear alert for deleted node

Post by dave » Thu Nov 13, 2008 6:51 pm

Good stuff!

I really really will now go and update some of the delete procedures.

Cheers,

Dave.

dave
Site Admin
Posts: 260
Joined: Fri May 30, 2008 9:09 pm
Location: UK
Contact:

Re: Clear alert for deleted node

Post by dave » Thu Nov 13, 2008 7:03 pm

In fact... done now in 1.02.2a.

Cheers,

Dave.

Post Reply