Memory graph not showing as intended.

Max Krabbenhöft

22 Jan 2016 22 Jan '16

3:41 a.m.

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

Attachments:

attachment.html (text/html — 6.4 KB)
image001.png (image/png — 8.5 KB)
image002.png (image/png — 6.4 KB)

Show replies by date

Adam Armstrong

22 Jan 22 Jan

3:48 a.m.

Don't run Observium on mysql servers with strict mode enabled.

Adam.

Sent from BlueMail

On 22 Jan 2016, 09:42, 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 [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.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

Max Krabbenhöft

3:59 a.m.

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 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

Adam Armstrong

4:04 a.m.

I'm actually not sure. Perhaps in /etc/mysql/my.cnf ?

Adam.

Sent from BlueMail

On 22 Jan 2016, 10:00, 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 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.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

Max Krabbenhöft

4:11 a.m.

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:

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,

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

Simon Smith

5 a.m.

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 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 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 <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 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

Tom Laermans

5:10 a.m.

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

Simon Smith

5:19 a.m.

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

Adam Armstrong

5:26 a.m.

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

Dirk-Willem van Gulik

5:12 a.m.

...

On 22 Jan 2016, at 11:04, Adam Armstrong adama@memetic.org wrote:

I'm actually not sure. Perhaps in /etc/mysql/my.cnf ?

Adam.

Snippet from our updated config for test setups below. It is the SET line you are after.

…..

set -e cd $INSTDIR

rm -rf logs rrd mkdir logs rrd chown www:www rrd

cat <<EOM | mysql CREATE DATABASE observium DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost' IDENTIFIED BY ‘$INSTPASS'; SET GLOBAL sql_mode = ‘';

EOM

./discovery.php -u ./adduser.php admin "$INSTPASS" 10

cat $CFG/devices | while read host; do ./add_device.php $host public v2c; done

./discovery.php -h all -d ./poller.php -h all -d

……..

Tom Laermans

5:14 a.m.

Hi Dirk-Willem,

Does this survive a mysql restart? I assume it doesn't? :o

Tom

On 2016-01-22 12:12, Dirk-Willem van Gulik wrote:

...

...
On 22 Jan 2016, at 11:04, Adam Armstrong adama@memetic.org wrote:

I'm actually not sure. Perhaps in /etc/mysql/my.cnf ?

Adam.

Snippet from our updated config for test setups below. It is the SET line you are after.

…..

set -e cd $INSTDIR

rm -rf logs rrd mkdir logs rrd chown www:www rrd

cat <<EOM | mysql CREATE DATABASE observium DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost' IDENTIFIED BY ‘$INSTPASS'; SET GLOBAL sql_mode = ‘';

EOM

./discovery.php -u ./adduser.php admin "$INSTPASS" 10

cat $CFG/devices | while read host; do ./add_device.php $host public v2c; done

./discovery.php -h all -d ./poller.php -h all -d

……..

observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

3303

Age (days ago)

3303

Last active (days ago)

List overview

Download

10 comments

5 participants

tags (0)

participants (5)

Adam Armstrong
Dirk-Willem van Gulik
Max Krabbenhöft
Simon Smith
Tom Laermans