On Mon, Jun 12, 2017 at 3:28 AM, Adam Armstrong <adama@memetic.org> wrote:
Hi,It seems like somehow your database schema has gotten desynced.It would probably be pretty complex to fix this, so if you don't need to retain the logs in MySQL, I'd recommend just removing the database, recreating it and then readding devices.It's a bit of a pain, but you'll never be sure that the database isn't broken otherwise.Btw, what is it running on? What distribution? What version of MySQL?Adam.Sent from BlueMailOn 11 Jun 2017, at 20:25, Idzma Zakaria <idzmaz@aism.edu.my> wrote: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.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/observi um
> <http://postman.memetic.org/cgi-bin/mailman/listinfo/observ >ium
>
>
>
>
> --
>
> 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/observiu m
--
Mike Stupalov
Observium Limited, http://observium.org
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observiu m --
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:
------------------------------------------------------------ ------------------------------ ----------------
observium mailing list
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
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:
----------------------------------------------------------------------------------------------------------
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:
----------------------------------------------------------------------------------------------------------