[Check_mk (english)] Error with: check_mk_active-sql: query is 'select count(No_) from [Prodata Systems nv_sa$Unit]'

Caines, Max Max.Caines at wlv.ac.uk
Thu Jul 7 16:41:31 CEST 2016


Hi

Looking on the web, it seems like you might try \\$$

See this page: https://www.krenger.ch/blog/nagios-escape-dollar-character/

Regards

Max

From: checkmk-en-bounces at lists.mathias-kettner.de [mailto:checkmk-en-bounces at lists.mathias-kettner.de] On Behalf Of Eric Lecocq
Sent: 07 July 2016 15:33
To: Marcel Schulte <schulte.marcel at gmail.com>; checkmk-en at lists.mathias-kettner.de
Subject: Re: [Check_mk (english)] Error with: check_mk_active-sql: query is 'select count(No_) from [Prodata Systems nv_sa$Unit]'

Hello,

As you can see, I tried to escape the $ sign with ‘\’, but without success. Any idea ?

check_mk_active-sql! --hostname '$HOSTADDRESS$' --dbms 'mssql' --name '<DBName>' --user '<User>' --password '<Psw>' 'select count(No_) from [Prodata Systems nv_sa\\$Unit]'


Best regards,

Eric

From: Marcel Schulte [mailto:schulte.marcel at gmail.com]
Sent: mardi 5 juillet 2016 19:33
To: Eric Lecocq <Eric.Lecocq at prodata-systems.be<mailto:Eric.Lecocq at prodata-systems.be>>; checkmk-en at lists.mathias-kettner.de<mailto:checkmk-en at lists.mathias-kettner.de>
Subject: Re: [Check_mk (english)] Error with: check_mk_active-sql: query is 'select count(No_) from [Prodata Systems nv_sa$Unit]'


Hi Eric,

Did you try masking the character (like "\$" or similar)?

BTW: that's just a thought, I do not use that check ;)

Regards,
Marcel

Eric Lecocq <Eric.Lecocq at prodata-systems.be<mailto:Eric.Lecocq at prodata-systems.be>> schrieb am Di., 5. Juli 2016 17:32:
Hello,

Maybe a silly question but i’m checking a mssql DB with the following query : 'select count(No_) from [Prodata Systems nv_sa$Unit]’
Check_mk says that there is an error near ‘$’… But in sql management studio this is not a problem. Do you have any idea about this ?

Thank you in advance,

Eric.


_______________________________________________
checkmk-en mailing list
checkmk-en at lists.mathias-kettner.de<mailto:checkmk-en at lists.mathias-kettner.de>
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mathias-kettner.de/pipermail/checkmk-en/attachments/20160707/d3c248ca/attachment.html>


More information about the checkmk-en mailing list