Hi Mike,

After update the DB Scheme it shown as Database is up to date.

As I check again in observium, its still shown as 0% and the error is still there when I debug.

Is this something related to the mysql DB?

Thank you.

On Sun, Jun 11, 2017 at 9:29 PM, Idzma Zakaria <idzmaz@aism.edu.my> wrote:
Thank you Mike.

I will look into it.Thank for the advise.

On Fri, 9 Jun 2017 at 1:06 PM, Mike Stupalov <mike@observium.org> wrote:
I see such errors in output:



Error in query: (Unknown column 'processor_usage' in 'field list') 1054

Error in query: (Unknown column 'mempool_polled' in 'field list') 1054

Error in query: (Unknown column 'storage_polled' in 'field list') 1054



this mean, you not update DB schema after update code (svn up):



./discovery.php -u



In normal case, this should be done by cron run with this entry (see

cron jobs

<http://docs.observium.org/install_debian/#perform-initial-discovery-and-poll>):



|# Run a complete discovery of all devices once every 6 hours

33  */6   * * *   root    /opt/observium/discovery.php -h all >> /dev/null 2>&1|





Idzma Zakaria wrote:

> Hi Mike and All,

>

> Sorry about that.I thought it was a full output given.Maybe I typing a

> wrong command without the host.Attached hopefully the right one as

> requested.

>

>

> On Tue, Jun 6, 2017 at 7:22 PM, Adam Armstrong <adama@observium.org

> <mailto:adama@observium.org>> wrote:

>

>     The strict mode stuff should no longer be a problem.

>

>     adam.

>>

>>     On 06/06/2017 12:21:21, Max Krabbenhöft

>>     <max.krabbenhoft@cinnober.com

>>     <mailto:max.krabbenhoft@cinnober.com>> wrote:

>>

>>     Hi,

>>

>>

>>

>>

>>

>>     I had the same problem, in my case it was MySQL that was set to

>>     strict mode.

>>

>>

>>

>>     //Max

>>

>>

>>

>>     *From:*observium [mailto:observium-bounces@observium.org

>>     <mailto:observium-bounces@observium.org>] *On Behalf Of *Idzma

>>     Zakaria

>>     *Sent:* den 6 juni 2017 03:10

>>     *To:* Observium Network Observation System

>>     <observium@observium.org <mailto:observium@observium.org>>

>>     *Subject:* Re: [Observium] Unable to pulled data for Processor,

>>     Memory and storage.

>>

>>

>>

>>     Hi,

>>

>>

>>

>>     Anybody care to help me? Any information needed I willingly to

>>     supply.

>>

>>

>>

>>     Thank you.

>>

>>

>>

>>     On Thu, Jun 1, 2017 at 10:17 AM, Idzma Zakaria

>>     <idzmaz@aism.edu.my <mailto:idzmaz@aism.edu.my>> wrote:

>>

>>         Hi ,

>>

>>

>>

>>

>>

>>         Having problem after updating to Observium 17.5.8580  . All

>>         of my servers unable to pulled Processor ,memory and storage

>>         data.

>>

>>

>>

>>         Its shown 0B ( 100%) as below picture.I have tested pulled

>>         using wmic it able to produce data and also from the

>>         ./poller.php but in the observium it wont show any data.

>>

>>

>>

>>         Any advice is much appreciated.

>>

>>

>>

>>

>>         ​

>>

>>         Debug from poller :

>>

>>

>>

>>         +---------------------------------------+--------------------+-------+-------+--------+-------+--------+

>>

>>         | Label                                | Type              |

>>         Index| Total| Used  | Free  | Perc  |

>>

>>         +---------------------------------------+--------------------+-------+-------+--------+-------+--------+

>>

>>         | C:\\ Label:OS  Serial Number c05b38c | host-resources-mib |

>>         1     | 278GB | 70.7GB | 207GB | 25.39% |

>>

>>         +---------------------------------------+--------------------+-------+-------+--------+-------+--------+

>>

>>

>>

>>

>>

>>         --

>>

>>

>>         Kind regards,

>>

>>         Idzma Zakaria,

>>

>>         ICT Senior Executive

>>

>>         ----------------------------------------------------------------------------------------------------------

>>         Australian International School Malaysia (AISM)

>>         No.22 Jalan Anggerik,

>>         The Mines Resort City,

>>         43300 Seri Kembangan,

>>         Selangor, Malaysia.

>>

>>

>>

>>         *T:* +60 3 8949 5000 <tel:+60%203-8949%205000> *F*: +60 3

>>         8949 5100 <tel:+60%203-8949%205100>

>>         *E*: idzmaz@aism.edu.my <mailto:idzmaz@aism.edu.my> *W*:

>>         http://www.aism.edu.my/

>>         *Direct Line*:

>>         ----------------------------------------------------------------------------------------------------------

>>

>>         <https://www.facebook.com/aismalaysia><http://www.youtube.com/user/AISMvideos><https://twitter.com/AISMalaysia/> <http://www.aism.edu.my/virtualtour>

>>

>>

>>

>>

>>

>>

>>

>>

>>

>>

>>

>>     --

>>

>>

>>     Kind regards,

>>

>>     Idzma Zakaria,

>>

>>     ICT Senior Executive

>>

>>     ----------------------------------------------------------------------------------------------------------

>>     Australian International School Malaysia (AISM)

>>     No.22 Jalan Anggerik,

>>     The Mines Resort City,

>>     43300 Seri Kembangan,

>>     Selangor, Malaysia.

>>

>>

>>

>>     *T:* +60 3 8949 5000 <tel:+60%203-8949%205000> *F*: +60 3 8949

>>     5100 <tel:+60%203-8949%205100>

>>     *E*: idzmaz@aism.edu.my <mailto:idzmaz@aism.edu.my> *W*:

>>     http://www.aism.edu.my/

>>     *Direct Line*:

>>     ----------------------------------------------------------------------------------------------------------

>>

>>     <https://www.facebook.com/aismalaysia><http://www.youtube.com/user/AISMvideos><https://twitter.com/AISMalaysia/> <http://www.aism.edu.my/virtualtour>

>>

>>

>>

>>

>>

>>

>>

>>

>>     *Confidentiality Disclaimer:* This e-mail and any attachments are

>>     confidential and intended solely for the intended addressee and

>>     may also be privileged or exempt from disclosure under applicable

>>     law. If you are not the intended addressee, or have received this

>>     e-mail in error, please notify the sender immediately, delete it

>>     from your system and do not copy, disclose, distribute or

>>     otherwise act in reliance upon any part of this e-mail or its

>>     attachments. Australian International School Malaysia and all

>>     affiliates under Taylor's Education Group  does not accept

>>     responsibility for any loss arising from unauthorised access to,

>>     or interference with, any internet communications by any third

>>     party in reliance to this email, or from the transmission of any

>>     viruses. Please note that any views or opinions presented in this

>>     email are solely those of the author and do not necessarily

>>     represent those of   Australian International School Malaysia and

>>     all affiliates under Taylor's Education Group. Replies to this

>>     e-mail may be monitored by   Australian International School

>>     Malaysia and all affiliates under Taylor's Education Group for

>>     operational or business reasons.

>>

>

>     _______________________________________________

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

>

>

>

>

> --

>

> Kind regards,

>

> Idzma Zakaria,

> ICT Senior Executive

> ----------------------------------------------------------------------------------------------------------

> Australian International School Malaysia (AISM)

> No.22 Jalan Anggerik,

> The Mines Resort City,

> 43300 Seri Kembangan,

> Selangor, Malaysia.

>

>

>

> *T:* +60 3 8949 5000 *F*: +60 3 8949 5100

> *E*: idzmaz@aism.edu.my <mailto:idzmaz@aism.edu.my> *W*:

> http://www.aism.edu.my/

> *Direct Line*:

> ----------------------------------------------------------------------------------------------------------

>

> <https://www.facebook.com/aismalaysia><http://www.youtube.com/user/AISMvideos><https://twitter.com/AISMalaysia/> <http://www.aism.edu.my/virtualtour>

>

>

>

>

>

> *Confidentiality Disclaimer:* This e-mail and any attachments are

> confidential and intended solely for the intended addressee and may

> also be privileged or exempt from disclosure under applicable law. If

> you are not the intended addressee, or have received this e-mail in

> error, please notify the sender immediately, delete it from your

> system and do not copy, disclose, distribute or otherwise act in

> reliance upon any part of this e-mail or its attachments. Australian

> International School Malaysia and all affiliates under Taylor's

> Education Group  does not accept responsibility for any loss arising

> from unauthorised access to, or interference with, any internet

> communications by any third party in reliance to this email, or from

> the transmission of any viruses. Please note that any views or

> opinions presented in this email are solely those of the author and do

> not necessarily represent those of   Australian International School

> Malaysia and all affiliates under Taylor's Education Group. Replies to

> this e-mail may be monitored by   Australian International School

> Malaysia and all affiliates under Taylor's Education Group for

> operational or business reasons.

> _______________________________________________

> observium mailing list

> observium@observium.org

> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium



--

Mike Stupalov

Observium Limited, http://observium.org



_______________________________________________

observium mailing list

observium@observium.org

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




--

Kind regards,

Idzma Zakaria,
ICT Senior Executive
----------------------------------------------------------------------------------------------------------
Australian International School Malaysia (AISM)
No.22 Jalan Anggerik, 
The Mines Resort City,
43300 Seri Kembangan, 
Selangor, Malaysia.



T: +60 3 8949 5000 F: +60 3 8949 5100 
E: idzmaz@aism.edu.my W: http://www.aism.edu.my/
Direct Line: 
----------------------------------------------------------------------------------------------------------

 





Confidentiality Disclaimer: This e-mail and any attachments are confidential and intended solely for the intended addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the intended addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose, distribute or otherwise act in reliance upon any part of this e-mail or its attachments. Australian International School Malaysia and all affiliates under Taylor's Education Group  does not accept responsibility for any loss arising from unauthorised access to, or interference with, any internet communications by any third party in reliance to this email, or from the transmission of any viruses. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of   Australian International School Malaysia and all affiliates under Taylor's Education Group. Replies to this e-mail may be monitored by   Australian International School Malaysia and all affiliates under Taylor's Education Group for operational or business reasons.