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 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.orgobservium@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.orgobservium@observium.org mailto:observium@observium.org> Cc: Observium Network Observation System < mailto:observium@observium.orgobservium@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 http://postman.memetic.org/cgi-bin/mailman/listinfo/observium