search

MantasTumenas / Zabbix-template-for-Microsoft-SQL-Server

Zabbix templates for Microsoft SQL Server. Features MS SQL performance counters. MS SQL instance Low Level Discovery. MS SQL database Low Level Discovery. MS SQL agent job Low Level Discovery. MS SQL database mirroring monitoring. MS SQL Always On monitoring. MS SQL Log Shipping monitoring. Supported versions Tested on Microsoft SQL Server 2012, 2014 and 2016. It may work with earlier versions, but some items (with missing performance counters) may be unsupported. For the extensive overview on the performance counters difference between MS SQL 2008 and MS SQL 2012 you can read here (https://blog.dbi-services.com/sql-server-2012-new-perfmon-counters/). Tested on Zabbix 3.4.0. It may work with earlier versions, but some items (for example service.info[service,]) may be unsupported. The template was started on Zabbix 2.4.0 but after each new Zabbix version, objects were modified or new things were added.
GNU General Public License v3.0
50 stars 27 forks source link

Discovery - Value should be a JSON object #9

Closed FabianZimbalev closed 5 years ago

FabianZimbalev commented 5 years ago

Hello,

I followed the instructions and added the baseline template to one host. Now when the discovery runs, it returns me the following message: Value should be a JSON object. This happens for the SQL Server Database Discovery and for the SQL Server Instances Discovery. Is there anything I´m missing in my configuration ?

MantasTumenas commented 5 years ago

Hi. Which win server version and which powershell version? Mantas

On Tue, 26 Feb 2019, 13:17 FabianZimbalev <notifications@github.com wrote:

Hello,

I followed the instructions and added the baseline template to one host. Now when the discovery runs, it returns me the following message: Value should be a JSON object. This happens for the SQL Server Database Discovery and for the SQL Server Instances Discovery. Is there anything I´m missing in my configuration ?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9, or mute the thread https://github.com/notifications/unsubscribe-auth/AthqTP_rOdSNTmACDnNuts3IsgJWykmYks5vRRfXgaJpZM4bR8LS .

FabianZimbalev commented 5 years ago

Powershell version 5.1 Win-Server 2016 Standard

Best regards

Fabian Zimbalev

MantasTumenas commented 5 years ago

Send me zabbix agent log and config file

On Tue, 26 Feb 2019, 13:23 FabianZimbalev <notifications@github.com wrote:

Powershell version 5.1 Win-Server 2016 Standard

Best regards

Fabian Zimbalev

Von: Mantas Tumenas [mailto:notifications@github.com] Gesendet: Dienstag, 26. Februar 2019 12:21 An: MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server < Zabbix-template-for-Microsoft-SQL-Server@noreply.github.com> Cc: Fabian Zimbalev Fabian.Zimbalev@crmaddon.com; Author < author@noreply.github.com> Betreff: Re: [MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server] Discovery - Value should be a JSON object (#9)

Hi. Which win server version and which powershell version? Mantas

On Tue, 26 Feb 2019, 13:17 FabianZimbalev <notifications@github.com wrote:

mailto:notifications@github.com%20wrote:%0b%0b> Hello,

I followed the instructions and added the baseline template to one host. Now when the discovery runs, it returns me the following message: Value should be a JSON object. This happens for the SQL Server Database Discovery and for the SQL Server Instances Discovery. Is there anything I´m missing in my configuration ?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub < https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9>,

or mute the thread < https://github.com/notifications/unsubscribe-auth/AthqTP_rOdSNTmACDnNuts3IsgJWykmYks5vRRfXgaJpZM4bR8LS>

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub< https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9#issuecomment-467400775>, or mute the thread< https://github.com/notifications/unsubscribe-auth/Aq8l6fLgLBGPceVBYsrz3wAXwoI1Vg3bks5vRRiQgaJpZM4bR8LS>.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9#issuecomment-467401429, or mute the thread https://github.com/notifications/unsubscribe-auth/AthqTCXpNWtKD_ael25Zb5gzMTsAhpjcks5vRRkdgaJpZM4bR8LS .

MantasTumenas commented 5 years ago

Yesterday had a similar case wit "Value should be a JSON object". Turns out the path in user parameters was not correct - it did not point to powershell scripts. Mantas

On Tue, Feb 26, 2019 at 1:50 PM Mantas Tumenas mantas.tumenas@gmail.com wrote:

Send me zabbix agent log and config file

On Tue, 26 Feb 2019, 13:23 FabianZimbalev <notifications@github.com wrote:

Powershell version 5.1 Win-Server 2016 Standard

Best regards

Fabian Zimbalev

Von: Mantas Tumenas [mailto:notifications@github.com] Gesendet: Dienstag, 26. Februar 2019 12:21 An: MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server < Zabbix-template-for-Microsoft-SQL-Server@noreply.github.com> Cc: Fabian Zimbalev Fabian.Zimbalev@crmaddon.com; Author < author@noreply.github.com> Betreff: Re: [MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server] Discovery - Value should be a JSON object (#9)

Hi. Which win server version and which powershell version? Mantas

On Tue, 26 Feb 2019, 13:17 FabianZimbalev <notifications@github.com wrote:

mailto:notifications@github.com%20wrote:%0b%0b> Hello,

I followed the instructions and added the baseline template to one host. Now when the discovery runs, it returns me the following message: Value should be a JSON object. This happens for the SQL Server Database Discovery and for the SQL Server Instances Discovery. Is there anything I´m missing in my configuration ?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub < https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9>,

or mute the thread < https://github.com/notifications/unsubscribe-auth/AthqTP_rOdSNTmACDnNuts3IsgJWykmYks5vRRfXgaJpZM4bR8LS>

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub< https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9#issuecomment-467400775>, or mute the thread< https://github.com/notifications/unsubscribe-auth/Aq8l6fLgLBGPceVBYsrz3wAXwoI1Vg3bks5vRRiQgaJpZM4bR8LS>.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9#issuecomment-467401429, or mute the thread https://github.com/notifications/unsubscribe-auth/AthqTCXpNWtKD_ael25Zb5gzMTsAhpjcks5vRRkdgaJpZM4bR8LS .

MantasTumenas commented 5 years ago

Hi, Please update on your situation. If you are still experience problem, I can find a time to help you via teamviewer. Mantas

On Tue, Feb 26, 2019 at 2:35 PM Mantas Tumenas mantas.tumenas@gmail.com wrote:

Yesterday had a similar case wit "Value should be a JSON object". Turns out the path in user parameters was not correct - it did not point to powershell scripts. Mantas

On Tue, Feb 26, 2019 at 1:50 PM Mantas Tumenas mantas.tumenas@gmail.com wrote:

Send me zabbix agent log and config file

On Tue, 26 Feb 2019, 13:23 FabianZimbalev <notifications@github.com wrote:

Powershell version 5.1 Win-Server 2016 Standard

Best regards

Fabian Zimbalev

Von: Mantas Tumenas [mailto:notifications@github.com] Gesendet: Dienstag, 26. Februar 2019 12:21 An: MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server < Zabbix-template-for-Microsoft-SQL-Server@noreply.github.com> Cc: Fabian Zimbalev Fabian.Zimbalev@crmaddon.com; Author < author@noreply.github.com> Betreff: Re: [MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server] Discovery - Value should be a JSON object (#9)

Hi. Which win server version and which powershell version? Mantas

On Tue, 26 Feb 2019, 13:17 FabianZimbalev <notifications@github.com wrote:

mailto:notifications@github.com%20wrote:%0b%0b> Hello,

I followed the instructions and added the baseline template to one host. Now when the discovery runs, it returns me the following message: Value should be a JSON object. This happens for the SQL Server Database Discovery and for the SQL Server Instances Discovery. Is there anything I´m missing in my configuration ?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub < https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9>,

or mute the thread < https://github.com/notifications/unsubscribe-auth/AthqTP_rOdSNTmACDnNuts3IsgJWykmYks5vRRfXgaJpZM4bR8LS>

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub< https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9#issuecomment-467400775>, or mute the thread< https://github.com/notifications/unsubscribe-auth/Aq8l6fLgLBGPceVBYsrz3wAXwoI1Vg3bks5vRRiQgaJpZM4bR8LS>.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9#issuecomment-467401429, or mute the thread https://github.com/notifications/unsubscribe-auth/AthqTCXpNWtKD_ael25Zb5gzMTsAhpjcks5vRRkdgaJpZM4bR8LS .

FabianZimbalev commented 5 years ago

Hi Mantas,

I found the issue. I wrote a litte ps file that would install Zabbix for me and download your files. Unfortunatly the stream did break and the the file download was not completed. When zabbix tried to run the Powershell Script, it returned some errors which are not JSON objects. This issue is "fixed" and was not caused by your software.

Thanks. Fabian

MantasTumenas commented 5 years ago

Hi, RD, "Value should be a JSON object" in discovery windows means the poweshell script for some reasons cannot be executed correctly. You have run PS script via commandline ant got the similar results. So we can for sure that the problem is with powershell. How do you know that you have powershell 4? What does this command show $PSVersionTable.PSVersion https://stackoverflow.com/questions/1825585/determine-installed-powershell-version mantas

On Wed, Mar 6, 2019 at 10:42 AM romdudPL notifications@github.com wrote:

Hi Mantas, I've installed your files to monitor two SQL server. One is working great, but the second has problem Discovery - Value should be a JSON object. I'm not sure where to look for reason of that situation. Problematic server is Win2008R2, Powershell 4. I've run PS scripts on commandline and I receive similar answer. So where is the problem? Regards RD

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9#issuecomment-470019200, or mute the thread https://github.com/notifications/unsubscribe-auth/AthqTD3bvqp-gozxB2oWV116DJIpTGpIks5vT39mgaJpZM4bR8LS .

romdudPL commented 5 years ago

thanks for your answer. In the meantime I've deleted my post, because "JSON returned home" ;-) I was impatient. After an hour everything worked correctly. thanks again regards RD

MantasTumenas commented 5 years ago

A, wonderfull. Good luck

On Thu, 7 Mar 2019, 12:20 romdudPL <notifications@github.com wrote:

thanks for your answer. In the meantime I've deleted my post, because "JSON returned home" ;-) I was impatient. After an hour everything worked correctly. thanks again regards RD

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/9#issuecomment-470468986, or mute the thread https://github.com/notifications/unsubscribe-auth/AthqTPpA1gJTvpvUGJkV1EXaKqeu5qnVks5vUOfzgaJpZM4bR8LS .