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.comwrote:
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.orgobservium-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