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 mailto: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 mailto: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 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 mailto: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 mailto:observium-bounces@observium.org ] On Behalf Of Adam Armstrong [adama@memetic.org mailto: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 http://WWW.WEBAFRICA.CO.ZA [1]
Links:
[1] http://www.webafrica.co.za/
observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium