No configuration file loaded - checking env: While parsing config: invalid character '\x7f' looking for beginning of value ERRO[0000] No configuration file loaded - using defaults - checking env We don't have any active DB session configured. Please check your config about promcasa HOT 5 CLOSED

Hello @aitudorm

The configuration is simply a parameter of the binary. For instance ./promcasa config.json
As of the ClickHouse queries, please refer to the examples and go from there. Note you need tags as well:

{
   "_info": "Custom Metrics from Clickhouse",
   "name": "my_status", // must be unique
   "help": "My Status",
   "query": "SELECT tags, count(*) as counter FROM orders FINAL PREWHERE (date>= toDateTime(now()-3600)) AND (date< toDateTime(now()) ) group by tags",
   "labels": ["tags"], // must match columns
   "counter_name": "counter",
   "refresh": "1h", //  Refesh takes unit sign: (ns, ms, s, m, h)
   "type":"gauge" // gauge, histogram, counter
}

Promcasa queries ClickHouse and exposes it's own /metrics endpoint.
Configuring an endpoint in ClickHouse is not part of the capabilities.

from promcasa.

Ok then, is it required to install certain version of Golang (1.19) on instance?

from promcasa.

@aitudorm not unless you want to compile it. just download a release

from promcasa.

@lmangani could you explain how to configure connection to database? What does mean "table_prefix" in json configuration. How to specify to which database connect. Also is there any opportunity to add one more query to fetch another custom metric? Or I should deploy second prompaca config?

from promcasa.

It seems you have not actually tried to use promcasa. Please do and feel free to submit any actual issues you might find.

from promcasa.