I made that change so I¹ll wait and see if that helps.

‹Jeff

On 6/25/15, 11:36 AM, "Phillip Baker" phil@lchost.co.uk wrote:

"Delay: 3" - change the delay on your alert?

Regards, Phillip Baker Technical Director LCHost (Netcalibre Ltd)

Sent from my mobile device, please excuse any abbreviations, typos, lack of pleasantries etc. E&OE

...

On 25 Jun 2015, at 19:22, Jeffrey d'Ambly jeffrey.dambly@jasper.com wrote:

I¹m having an issue where it seems that host down alerts are always delayed. Where can I start with troubleshooting this issue? Note that alerts are working, but something seems to not work with host down alerts.<Screen Shot 2015-06-25 at 11.19.12 AM.png>

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

Note that alerts are sent when alerter.php is run, not during the poller.

If you aren't running it under poller-wrapper and it's being run by cron, that might explain!

Or perhaps not!

Alerts which are delayed will be shown in that state on the alert pages. Orange, I think.

Adam

Sent with AquaMail for Android http://www.aqua-mail.com

On 25 June 2015 20:11:11 "Jeffrey d'Ambly" jeffrey.dambly@jasper.com wrote:

I’m also seeing other alerts that are doing the same thing, like CPU, seems very odd.

Is there a SQL query I can or something to help trouble shoot this?

Just looking for some guidance on this.

—jeff

On 6/25/15, 11:42 AM, "Jeffrey d'Ambly" jeffrey.dambly@jasper.com wrote:

...

I made that change so I¹ll wait and see if that helps.

‹Jeff

On 6/25/15, 11:36 AM, "Phillip Baker" phil@lchost.co.uk wrote:

...

"Delay: 3" - change the delay on your alert?

Regards, Phillip Baker Technical Director LCHost (Netcalibre Ltd)

Sent from my mobile device, please excuse any abbreviations, typos, lack of pleasantries etc. E&OE

...

On 25 Jun 2015, at 19:22, Jeffrey d'Ambly jeffrey.dambly@jasper.com wrote:

I¹m having an issue where it seems that host down alerts are always delayed. Where can I start with troubleshooting this issue? Note that alerts are working, but something seems to not work with host down alerts.<Screen Shot 2015-06-25 at 11.19.12 AM.png>

---

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

We on the other hand have the opposite, port down alerts don't seem to work yet host down is working as expected :( This was working initially but stopped for no reason, any ideas guys?

Cheers

Serghei Golipad - CCIE® #45033 Network Consultant @ Kelway UK 1 Cyrus Way, Cygnet Park Hampton, Peterborough, PE7 8HP  DDI: 0203 069 5165 Mobile: 07469 081 910 Web:  www.kelway.com  Email: s.golipad@kelway.com

-----Original Message----- From: observium [mailto:observium-bounces@observium.org] On Behalf Of Jeffrey d'Ambly Sent: 25 June 2015 19:42 To: Observium Network Observation System Subject: Re: [Observium] alerts

I made that change so I¹ll wait and see if that helps.

<Jeff

On 6/25/15, 11:36 AM, "Phillip Baker" phil@lchost.co.uk wrote:

"Delay: 3" - change the delay on your alert?

Regards, Phillip Baker Technical Director LCHost (Netcalibre Ltd)

Sent from my mobile device, please excuse any abbreviations, typos, lack of pleasantries etc. E&OE

...

On 25 Jun 2015, at 19:22, Jeffrey d'Ambly jeffrey.dambly@jasper.com wrote:

I¹m having an issue where it seems that host down alerts are always delayed. Where can I start with troubleshooting this issue? Note that alerts are working, but something seems to not work with host down alerts.<Screen Shot 2015-06-25 at 11.19.12 AM.png>

---

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

PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL.

Kelway (UK) Ltd is a Company registered in England and Wales. This email is sent for and on behalf of Kelway Holdings Limited. Kelway Holdings Limited is the UK holding company for Kelway (UK) Limited trading as Kelway. The registered office for Kelway Holdings Limited (Company Number 05872067) and its UK group undertakings is 10 Fleet Place, London, EC4M 7RB. VAT Registration 902 1949 39. Confidentiality: This e-mail contains proprietary information, some or all of which may be confidential and/or legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail and then delete the original. If you are not the intended recipient you may not use, disclose, distribute, copy, print or rely on any information contained in this e-mail. You must not inform any other person other than Kelway or the sender of its existence.

For more information about Kelway please visit www.kelway.co.uk

It usually means your MySQL server has run out of heap space.

Alert entries (and entries for port stats and some other things) are held in MySQL memory tables, which need heap space.

You can change the heap size in your my.cnf :

[mysqld] tmp_table_size=2G max_heap_table_size=2G 2GB might be OTT, depends how big your deployment is :)

adam.

Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] ... On 26/06/2015 18:58:27, Jeffrey d'Ambly jeffrey.dambly@jasper.com wrote: I think we may be having the same issue. I also noticed that there a lot of alerts in the state other

Does mean there is an issue? What does it mean when an alert is in other?

—Jeff

From: Serghei Golipad <s.golipad@kelway.com [mailto:s.golipad@kelway.com]> Reply-To: Observium Network Observation System <observium@observium.org [mailto:observium@observium.org]> Date: Friday, June 26, 2015 at 12:53 AM To: Observium Network Observation System <observium@observium.org [mailto:observium@observium.org]> Subject: Re: [Observium] alerts

We on the other hand have the opposite, port down alerts don't seem to work yet host down is working as expected :( This was working initially but stopped for no reason, any ideas guys?

Cheers

Serghei Golipad - CCIE® #45033 Network Consultant @ Kelway UK 1 Cyrus Way, Cygnet Park Hampton, Peterborough, PE7 8HP  DDI: 0203 069 5165 Mobile: 07469 081 910 Web:  www.kelway.com  Email: s.golipad@kelway.com [mailto:s.golipad@kelway.com]

-----Original Message----- From: observium [mailto:observium-bounces@observium.org [mailto:observium-bounces@observium.org]] On Behalf Of Jeffrey d'Ambly Sent: 25 June 2015 19:42 To: Observium Network Observation System Subject: Re: [Observium] alerts

I made that change so I¹ll wait and see if that helps.

<Jeff

On 6/25/15, 11:36 AM, "Phillip Baker" <phil@lchost.co.uk [mailto:phil@lchost.co.uk]> wrote:

"Delay: 3" - change the delay on your alert?

Regards, Phillip Baker Technical Director LCHost (Netcalibre Ltd)

Sent from my mobile device, please excuse any abbreviations, typos, lack of pleasantries etc. E&OE

...

On 25 Jun 2015, at 19:22, Jeffrey d'Ambly <jeffrey.dambly@jasper.com [mailto:jeffrey.dambly@jasper.com]> wrote:

I¹m having an issue where it seems that host down alerts are always delayed. Where can I start with troubleshooting this issue? Note that alerts are working, but something seems to not work with host down alerts.<Screen Shot 2015-06-25 at 11.19.12 AM.png>

---

observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [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 [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]

PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL.

Kelway Ltd is a Company registered in England and Wales. This email is sent for and on behalf of Kelway Holdings Limited. Kelway Holdings Limited is the UK holding company for Kelway Limited trading as Kelway. The registered office for Kelway Holdings Limited (Company Number 05872067) and its UK group undertakings is 10 Fleet Place, London, EC4M 7RB. VAT Registration 902 1949 39. Confidentiality: This e-mail contains proprietary information, some or all of which may be confidential and/or legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail and then delete the original. If you are not the intended recipient you may not use, disclose, distribute, copy, print or rely on any information contained in this e-mail. You must not inform any other person other than Kelway or the sender of its existence.

For more information about Kelway please visit www.kelway.com

Running that module with -d should give more information.

./discovery.php -h <host> -m wifi -d

Adam.

Sent with AquaMail for Android http://www.aqua-mail.com

On 26 June 2015 20:33:46 Vincent Aniello VAniello@portware.com wrote:

I am trying to use the mysqli db extension with my Observium installation and when I add $config['db_extension'] = "mysqli"; to my config.php and run a discovery on a device I receive the following database errors:

Module [ ucd-diskio ] time: 0.0758s Wifi: RUCKUS-RADIO-MIB UU RUCKUS-WLAN-MIB Failed INSERT into DB, rollback transaction. +UUUUUUUUUUUUUUUUUFailed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +UUUUUUUUFailed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction.

Module [ wifi ] time: 0.3944s

When I remove the mysqli db extension from my config.php and run the same discovery it runs without issue:

Module [ ucd-diskio ] time: 0.0753s Wifi: RUCKUS-RADIO-MIB UU RUCKUS-WLAN-MIB +UUUUUUUUUUUUUUUUU+++++++++++UUUUUUUU+++++

The version information from my Observium installation is:

Observium 0.15.6.6458 OS Linux 2.6.32-358.el6.x86_64 [amd64] (CentOS 6.4) Apache 2.2.15 (CentOS) PHP 5.3.3 Python Python 2.6.6 MySQL 5.1.66 (extension: mysqli 5.1.66) SNMP NET-SNMP 5.5 RRDtool 1.3.8

I also added the following line to my php.ini:

extension=/usr/lib64/php/modules/mysqli.so

This points to the file:

-rwxr-xr-x 1 root root 136032 Feb 21 2013 /usr/lib64/php/modules/mysqli.so

Is there anything else that needs to be configured in order to start using the mysqli db extension with Observium?

Thank you.

--Vincent

---

---

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

Ahh. I see. Mysqli is enforcing strict mode, for some reason.

Well get that fixed soon :)

Adam.

Sent with AquaMail for Android http://www.aqua-mail.com

On 26 June 2015 21:55:58 Vincent Aniello VAniello@portware.com wrote:

Debug output is attached. The issue seems to be here:

ERROR[^[[0;31mError in query: (Column 'wlan_ssid' cannot be null) 1048^[[0m]^[[0m

--Vincent

From: Adam Armstrong adama@memetic.org To: Observium Network Observation System observium@observium.org Date: 06/26/2015 04:41 PM Subject: Re: [Observium] mysqli db extension Sent by: "observium" observium-bounces@observium.org

Running that module with -d should give more information. ./discovery.php -h <host> -m wifi -d Adam. Sent with AquaMail for Android http://www.aqua-mail.com On 26 June 2015 20:33:46 Vincent Aniello VAniello@portware.com wrote: I am trying to use the mysqli db extension with my Observium installation and when I add $config['db_extension'] = "mysqli"; to my config.php and run a discovery on a device I receive the following database errors:

Module [ ucd-diskio ] time: 0.0758s Wifi: RUCKUS-RADIO-MIB UU RUCKUS-WLAN-MIB Failed INSERT into DB, rollback transaction. +UUUUUUUUUUUUUUUUUFailed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +UUUUUUUUFailed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction. +Failed INSERT into DB, rollback transaction.

Module [ wifi ] time: 0.3944s

When I remove the mysqli db extension from my config.php and run the same discovery it runs without issue:

Module [ ucd-diskio ] time: 0.0753s Wifi: RUCKUS-RADIO-MIB UU RUCKUS-WLAN-MIB +UUUUUUUUUUUUUUUUU+++++++++++UUUUUUUU+++++

The version information from my Observium installation is:

Observium 0.15.6.6458 OS Linux 2.6.32-358.el6.x86_64 [amd64] (CentOS 6.4) Apache 2.2.15 (CentOS) PHP 5.3.3 Python Python 2.6.6 MySQL 5.1.66 (extension: mysqli 5.1.66) SNMP NET-SNMP 5.5 RRDtool 1.3.8

I also added the following line to my php.ini:

extension=/usr/lib64/php/modules/mysqli.so

This points to the file:

-rwxr-xr-x 1 root root 136032 Feb 21 2013 /usr/lib64/php/modules/mysqli.so

Is there anything else that needs to be configured in order to start using the mysqli db extension with Observium?

Thank you.

--Vincent

---

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

I still seem some alerts in the state other, does this mean I need to use a number larger than 2gb?

Ok Fail Delay Supp Other Alerts 56642 174 3 0 745

From: Jeffrey <jeffrey.dambly@jasper.commailto:jeffrey.dambly@jasper.com> Reply-To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Date: Friday, June 26, 2015 at 2:10 PM To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Subject: Re: [Observium] alerts

I’m not sure what is considered a large deployment, we have 566 devices, 35018 ports, and 14198 sensors.

I made the change you suggested, restart mysqld, and ran alerter.php –h all

This seems to resolve the issue. I can see the alerts in state other going down.

—Jeff

From: Adam Armstrong <adama@memetic.orgmailto:adama@memetic.org> Reply-To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Date: Friday, June 26, 2015 at 12:23 PM To: "observium@observium.orgmailto:observium@observium.org" <observium@observium.orgmailto:observium@observium.org> Subject: Re: [Observium] alerts

tmp_table_size=2G max_heap_table_size=2G