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 BlueMailhttp://www.bluemail.me/r On 22 Jan 2016, at 10:00, "Max Krabbenhöft" <max.krabbenhoft@cinnober.commailto: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.orgmailto:observium@observium.org> Cc: Observium Network Observation System <observium@observium.orgmailto: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 BlueMailhttp://www.bluemail.me/r On 22 Jan 2016, at 09:42, "Max Krabbenhöft" <max.krabbenhoft@cinnober.commailto: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 [http://i.imgur.com/NMkyhMB.png]
This is how it looks: [http://i.imgur.com/VEFSP1K.png]
Thank you for your help
Best regards Max
________________________________
observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
________________________________
observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium