I feel you're missing some important data...
adam. On 22/01/2016 11:19:35, Simon Smith simonsmith5521@gmail.com wrote: thats incorrect? as i installed it all with ubuntu from scratch(following guide) and strict mode was enabled from the word go,
still think it should be told about in the wiki to disable it :)
Simon
On 22 Jan 2016, at 11:10 am, Tom Laermans <tom.laermans@powersource.cx [mailto: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 [mailto:max.krabbenhoft@cinnober.com]> wrote:
Adam, your a genius! Thanks for your help! Br Max From: observium [mailto:observium-bounces@observium.org [mailto:observium-bounces@observium.org]] On Behalf Of Adam Armstrong Sent: den 22 januari 2016 11:04 To: Observium Network Observation System < [mailto:observium@observium.org]observium@observium.org [mailto: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 [http://www.bluemail.me/r] On 22 Jan 2016, at 10:00, "Max Krabbenhöft" <max.krabbenhoft@cinnober.com [mailto: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 [mailto:observium-bounces@observium.org]] On Behalf Of Adam Armstrong Sent: den 22 januari 2016 10:49 To: Observium Network Observation System < [mailto:observium@observium.org]observium@observium.org [mailto:observium@observium.org]> Cc: Observium Network Observation System < [mailto:observium@observium.org]observium@observium.org [mailto: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 [http://www.bluemail.me/r] On 22 Jan 2016, at 09:42, "Max Krabbenhöft" <max.krabbenhoft@cinnober.com [mailto: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 [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] _______________________________________________ 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] _______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium