Adam, your a genius!

Thanks for your help!

Br

Max

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong
Sent: den 22 januari 2016 11:04
To: Observium Network Observation System <observium@observium.org>
Subject: Re: [Observium] Memory graph not showing as intended.

I'm actually not sure. Perhaps in /etc/mysql/my.cnf ?

Adam.

Sent from BlueMail

On 22 Jan 2016, at 10:00, "Max Krabbenhöft" <max.krabbenhoft@cinnober.com> wrote:

Thanks for your imput Adam, as you say, our MariaDB is set to Strict:

mysql> SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE;

+--------------------------------------------+--------------------------------------------+

| @@SQL_MODE                                 | @@GLOBAL.SQL_MODE                          |

+--------------------------------------------+--------------------------------------------+

| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |

+--------------------------------------------+--------------------------------------------+

Problem is, I’m not that good with SQL syntaxes in general, so I don’t  know how to change this.

Mind giving me a heads up?

BR
Max

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong
Sent: den 22 januari 2016 10:49
To: Observium Network Observation System <observium@observium.org>
Cc: Observium Network Observation System <observium@observium.org>
Subject: Re: [Observium] Memory graph not showing as intended.

Don't run Observium on mysql servers with strict mode enabled.

Adam.

Sent from BlueMail

On 22 Jan 2016, at 09:42, "Max Krabbenhöft" <max.krabbenhoft@cinnober.com> wrote:

Hello,

I just set up Observium on CentOS 7 and everything works great!

Except for one thing. The Memory and Virtual memory graph on the dashboard for windows/linux servers won’t draw.

Switches work fine though.

When doing a debug I get this error message:

SQL[INSERT INTO `mempools-state` (`mempool_id`)  VALUES ('5')]

RUNTIME[0.00012898s]

ERROR[Error in query: (1364) Field 'mempool_polled' doesn't have a default value]

I’ve been looking all over and can’t find a resolution for this.

This is how it should look

This is how it looks:

Thank you for your help

Best regards

Max

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