On 22 Jan 2016, at 11:10 am, Tom Laermans <tom.laermans@powersource.cx> wrote:

Actually, strict mode is simply not enabled if you follow the recommended (= Debian/Ubuntu) instructions ... Apparently someone at RH decided to change that on CentOS/RH around our back...

Tom

On 2016-01-22 12:00, Simon Smith wrote:

I had this issue a while ago and it turns out it was the mysql strict mode, and removing the strict mode helped :) 

Adam, can you change the wiki install to tell users to disable the mysql strict from the word go!

it would solve a lot of peoples problems, me thinks :) 

Simon

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

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

_______________________________________________ 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