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.
[cid:image001.png@01CEDFCC.99993480]
[cid:image002.png@01CEDFCC.D0D38A90]
[cid:image003.png@01CEDFCC.EDD4C5F0]
Is this a bug? Can anyone help?
Regards
Adriaan Smuts
Junior Systems Administrator
[file:///C:\Users\adriaan.CORP\AppData\Roaming\Microsoft\Signatures\WebAfrica_Files\signature_logo.jpg]
________________________________
Direct Line
+27 21 464 9565
Reception
086 000 9500
Website
www.webafrica.co.zahttp://www.webafrica.co.za/
The stuff on the front page is generated via a query. There isn't some great overarching system of state.
Probably someone missed out limiting the query to only non-disabled ports...
You can try to find the query and fix it, or wait for one of us to do it :)
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
I had the same problem with an older version and I found that there was a limitation in the PHP to send the commands to the MySQL. If you check your logs, i guess the Apache2 logs, you will see a error message, you can google that error.
To be honest I couldn't fix it, I got the MySQL command line which sets the port to disabled state and executed it in the MySQL cli.
Best Regards,
On Tue, Nov 12, 2013 at 1:30 PM, Adriaan Smuts adriaan.smuts@webafrica.comwrote:
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*
[image: Web Africa]
Direct Line
*+27 21 464 9565*
Reception
*086 000 9500*
Website
*www.webafrica.co.za http://www.webafrica.co.za/*
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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
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
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
Hi Mike
I also see ports down which are disabled for alerting on the frontpage since this morning. But only ports that recently got down or the device got rebooted. And it's not Windows in my case.
Was not the case before.
Regards
Matthias
On 12/11/13 21:18, Mike Stupalov wrote:
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 http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
On 13.11.2013 01:10, Matthias Cramer wrote:
Hi Mike
I also see ports down which are disabled for alerting on the frontpage since this morning. But only ports that recently got down or the device got rebooted. And it's not Windows in my case.
Was not the case before.
Anyway, please send output for query (can as pastebin or attachment):
SELECT * FROM `observium`.`ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up' AND `ifLastChange` >= DATE_SUB(NOW(), INTERVAL 48 HOUR);
and tell what size of 'memory_limit' option in your php.ini.
Regards
Matthias
On 12/11/13 21:18, Mike Stupalov wrote:
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 http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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
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 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
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
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.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
-- Mike Stupalov http://observium.org/
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
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 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 -- 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
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/
participants (6)
-
Adam Armstrong -
Adriaan Smuts -
Danilo Marques de Gouveia -
Matthias Cramer -
Mike Stupalov -
Stefano Cordio