Hi Mike,

My memory limit is 128M and the query result is attached.

Kind Regards,

Stefano

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Mike Stupalov
Sent: mercoledì 13 novembre 2013 04:29
To: Observium Network Observation System
Subject: Re: [Observium] Disabled ports

ohh, wait. Limit query by time interval (otherwise the output will be very big):

SELECT * FROM `observium`.`ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up' AND `ifLastChange` >= DATE_SUB(NOW(), INTERVAL 48 HOUR);

On Wed, Nov 13, 2013 at 7:22 AM, Mike Stupalov <mike@observium.org> wrote:

Hi Stefano.

Query for you to be different (without filter by ifDescr):
SELECT * FROM `observium`.`ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up';

Also, please tell what size of 'memory_limit' option in your php.ini?

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:05

To: 'Observium Network Observation System'

Subject: RE: [Observium] Disabled ports

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:18

To: 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/

--
Mike Stupalov
http://observium.org/