Hi Mike,
Thank you very much, I updated this morning and everything is working 100% now.
Regards
Adriaan Smuts Junior Systems Administrator
Direct Line +27 21 464 9565 Reception 0861 555 222 Website www.webafrica.co.za
-----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of Mike Stupalov Sent: Wednesday, November 13, 2013 12:38 PM To: Observium Network Observation System Subject: Re: [Observium] Disabled ports
Hi,
thank to Stefano and all others. I found where there was an error and fix that in r4760.
On 13.11.2013 12:52, Stefano Cordio wrote:
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 columnnames
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/orits
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
-- Mike Stupalov http://observium.org/ _______________________________________________ observium mailing list observium@observium.org <mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium -- Mike Stupalov http://observium.org/-- 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/