#influxdb

I only started a few days ago

so what im doing isnt totally crazy?

it unlocks a lot of power

arader: Do you have a query that gives a list of the hosts you care about as the result?

im sure i could make one, or even hardcoding it for now would be good

Manage Dashboard -> Templating

Put that query in the "Query" spot, and put something in for the variable name

now the variable you just set will be available in your graph metric selector

and then you can select one/some/all of the hosts in the query result

and it will update the graph based on that selection

sweet thanks, i'll give it a shot

It's great, added two querys, now i can select any combination of ethernet ports or switches out of our cisco gear to display usage stats from

same thing with linux systems load/disk/ram/etc

i would like to 'paste' mutli line continuous query into influxdb terminal, but without luck

is there a way to do this?

ok.. web interface works.

one more question why this DOESN'T WORK """select * from woocommerce_order_line_items where status = 'completed' and (product_id != '174' or product_id != '173')"""

BUT THIS DOES """select * from woocommerce_order_line_items where status = 'completed' and (product_id != '174')"""

this last part in paranteses ... or <another id>

i would just like to set condition which would allow me to get all other products

??

i would really appreciate some help here

setup question: One of my public influx servers is behind cloudflare, which doesn't have 8086 open. is there any reason i *shouldnt* run influx behind nginx on port 80/443?

i wouldnt expose it to the internet at all myself

sztanpet: that one in particular is for a JS app

doesnt make a difference

eh?

whats up?

just make your app access the db on localhost without exposing it wholesale, etc

fair enough, but another server in the same situation's for a desktop app :)

so?

make a tiny gateway that exposes only the needed data for the app, who cares

am i missing something? that sounds like nginx

no, nginx is a web server

sztanpet: i should specify this is for writes, not reads

the db is public write-only

sztanpet: why should i gate it at all, rather than just transparently proxy it? that was the idea behind putting it behind nginx

sure, go ahead, im just saying that i am paranoid about it because there clearly wasnt much effort put into the access control bits

mmh

fair enough, thanks

Hi all o/

I have a small question, I have a InfluxDB 0.9 server that I can't get to start after a snapshot....

I get this : http://pastebin.com/Kuqs40Su

(It has been shutdown for the snapshot, it's a single node system)

I'm fightning with it for hours and I can't get it to start properly

Any idea ? :)