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]*On Behalf Of*Adam Armstrong *Sent:*den 22 januari 2016 11:04 *To:*Observium Network Observation System <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 fromBlueMail 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]*On Behalf Of*Adam Armstrong *Sent:*den 22 januari 2016 10:49 *To:*Observium Network Observation System <observium@observium.org <mailto:observium@observium.org>> *Cc:*Observium Network Observation System <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 fromBlueMail <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 ------------------------------------------------------------------------ observium mailing list observium@observium.org <mailto:observium@observium.org>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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium