Hello,

I'm trying to use the Query service from Centreon plugin App-Db-Influxdb-Query-custom but still get issue.

Here is the request I want to duplicate in Centreon :

select last(XXX) from backbone.raw_for_1w.snmp_nokia_bkb_tps where agent_host='YYY'

I've tried

/usr/lib/centreon/plugins//centreon_influxdb.pl --plugin=database::influxdb::plugin --mode=query --hostname= --port=8086 --proto=https --username='user' --password='***' --query='last_value,SELECT last(XXX) AS "last_value" FROM backbone.raw_for_1w.snmp_nokia_bkb_tps WHERE agent_host=''YYY'' GROUP BY "agent_host"' --instance='--instance='agent_host'' --output='--output='last_value'' --multiple-output='' --warning-status='' --critical-status='' --hostname=vip-AAA

or

/usr/lib/centreon/plugins//centreon_influxdb.pl --plugin=database::influxdb::plugin --mode=query --hostname= --port=8086 --proto=https --username='user' --password='***' --query='last_value,SELECT last(XXX) AS "last_value" FROM backbone.raw_for_1w.snmp_nokia_bkb_tps WHERE agent_host=''YYY'' GROUP BY "agent_host"' --instance='--instance='agent_host'' --output='--output='last_value'' --multiple-output='' --warning-status='' --critical-status='' --hostname=vip-AAA --verbose

without success

UNKNOWN: No queries found. for the 1st request

Below output for the 2nd : 

 

UNKNOWN: No queries found.
URL: 'https://vip-AAA:8086/query?epoch=s'
Parameters: 'q=SELECT last(XXX) AS "last_value" FROM backbone.raw_for_1w.snmp_nokia_bkb_tps WHERE agent_host=YYY GROUP BY "agent_host"'
======> request send
POST https://vip-AAA:8086/query?epoch=s
Authorization: Basic Z3JhZl9ub2NfY2VudHJlb246TUNySzc1Q2VyKjVDd014IQ==
User-Agent: centreon::plugins::backend::http::useragent
Content-Type: application/x-www-form-urlencoded

q=SELECT+last(XXX)+AS+%22last_value%22+FROM+backbone.raw_for_1w.snmp_nokia_bkb_tps+WHERE+agent_host%3DYYY+GROUP+BY+%22agent_host%22
======> response done
HTTP/1.1 200 OK
Date: Tue, 04 Feb 2025 07:50:33 GMT
Content-Type: application/json
Client-Date: Tue, 04 Feb 2025 07:50:33 GMT
Client-Peer: 10.195.31.230:8086
Client-Response-Num: 1
Client-SSL-Cert-Issuer: /C=MC/ST=Monaco/L=Monaco/O=DRS/CN=intermediate.prod.lan
Client-SSL-Cert-Subject: /C=MC/ST=Monaco/L=Monaco/O=DRS/CN=ZZZ.prod.lan
Client-SSL-Cipher: TLS_AES_256_GCM_SHA384
Client-SSL-Socket-Class: IO::Socket::SSL
Client-SSL-Version: TLSv1_3
Client-Transfer-Encoding: chunked
Request-Id: b69b3054-e2cc-11ef-b557-fa163edad6e0
X-Influxdb-Build: OSS
X-Influxdb-Version: 1.8.10
X-Request-Id: b69b3054-e2cc-11ef-b557-fa163edad6e0

{"results":s{"statement_id":0}]}

 

Can someone have experience on this ?