SELECT * FROM `observium`.`ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up' AND `ifLastChange` >= DATE_SUB(NOW(), INTERVAL 48 HOUR);
Also, please tell what size of 'memory_limit' option in your php.ini?Hi Stefano.Query for you to be different (without filter by ifDescr):
SELECT * FROM `observium`.`ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up';
On Wed, Nov 13, 2013 at 2:23 AM, Stefano Cordio <stefano.cordio@gmail.com> wrote:
Hey Mike,
You can find a non-empty result in my attachment, related to the HP switch.
I also attached the screenshot of my home page alerts (“ca” and “asamidc01” = Windows servers, “mcsmisw01” = HP ProCurve 1810G - 24 GE).
Of course, each port is configured on Observium as “Alerts=No”.
Let me know if I can help further.
Kind Regards,
Stefano
From: Stefano Cordio [mailto:stefano.cordio@gmail.com]
Sent: martedì 12 novembre 2013 23:05Subject: RE: [Observium] Disabled ports
To: 'Observium Network Observation System'
Hello Mike,
I’m having the same issue on two Windows servers and one HP switch.
This is my SQL result, hoping it helps:
---------------------------------------------------------------
[root@observium ~]# mysql -u root -p -D observium
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 228934
Server version: 5.1.69 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT * FROM `observium`.`ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up' AND `ifDescr` LIKE 'tunnel_%';
Empty set (0.01 sec)
mysql>
---------------------------------------------------------------
King Regards,
Stefano
From: observium [mailto:observium-bounces@observium.org] On Behalf Of Mike Stupalov
Sent: martedì 12 novembre 2013 21:18To: Observium Network Observation System
Subject: Re: [Observium] Disabled ports
It's very strange, they should not be shown.
I checked the possible errors in queries, but found nothing.
If possible, make a request in mysql:SELECT * FROM `observium`.`ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up' AND `ifDescr` LIKE 'tunnel_%';and send me its output.
On Tue, Nov 12, 2013 at 11:04 PM, Adriaan Smuts <adriaan.smuts@webafrica.com> wrote:
The disabled ports are only on my Windows boxes, there are some ports that aren't used.
Regards,
Adriaan
________________________________________
From: observium [observium-bounces@observium.org] On Behalf Of Adam Armstrong [adama@memetic.org]
Sent: 12 November 2013 18:55
To: Observium Network Observation System
Subject: Re: [Observium] Disabled ports
note also that you should /not/ be disabling ports in the observium
configuration interface except as an absolute last resort.
adam.
On 2013-11-12 15:30, Adriaan Smuts wrote:
> Hey Guys,
>
> I upgraded this morning, running Observium 0.13.11.4759. I am
> currently having issues with disabled ports. On the devices
> configuration I disabled the ports (polling & alerts), but they still
> show on my home page. I have removed the devices and re-added them,
> but the issue persists.
>
> Is this a bug? Can anyone help?
>
> Regards
>
> ADRIAAN SMUTS
>
> JUNIOR SYSTEMS ADMINISTRATOR
>
> -------------------------
>
> Direct Line
>
> +27 21 464 9565
>
> Reception
>
> 086 000 9500
>
> Website
>
> WWW.WEBAFRICA.CO.ZA [1]
>
>
>
> Links:
> ------
> [1] http://www.webafrica.co.za/
>
> _______________________________________________
> observium mailing list
> observium@observium.org
> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
--
Mike Stupalov
http://observium.org/
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
--
Mike Stupalov
http://observium.org/