Collecting RuuviTag measurements and displaying them with Grafana


#168

Is there a way to change the temperature measurement and display to Fahrenheit in the JSON file that you import into Grafana???

Thanx in Advance


#169

You could configure the conversion with math operation in value field


#170

I was never that good at math…How would I go about configuring it?


#171

I think this should do the trick.


#172

OK, Thanx a bunch!!!


#173

I’ve got Raspberry pi 3


#174

hey guys, could anyone please help me with a tickscript?

goal: get notificated when humidity of Ruuvi1 is lower than humidity of Ruuvi2.
my actual try after some fails:

{{{
var ruuvi1= stream
|from()
.database(‘ruuvi-measurements’)
.retentionPolicy(‘autogen’)
.measurement(‘humidity’)
.where(lambda: “name” == ‘ruuvi1’)
.groupBy(*)
|httpOut(‘ruuvi1’)

var ruuvi2= stream
|from()
.database(‘ruuvi-measurements’)
.retentionPolicy(‘autogen’)
.measurement(‘humidity’)
.where(lambda: “name” == ‘ruuvi2’)
.groupBy(*)
|httpOut(‘ruuvi2’)

ruuvi1
|join(ruuvi2)
.as(‘ruuvi1’, ‘ruuvi2’)
.tolerance(1s)
|httpOut(‘join’)
|eval(lambda: “ruuvi1” < “ruuvi2”)
.as(‘diff’)
|alert()
.message(‘test’)
.telegram()
.chatId(‘6’)

}}}


#175

how can I remove the wifi hotspot and connect to a router with the image? As it was before.

edit: got the br0 removed…

/Andre’


#176

Hello,
One more thing…How do you convert Pascals to Inches of Mercury (inHg) in Grafana???

Please lemme know.

Thanx.


#177

Hello,

You could use the math function to convert the value


#178

I don’t know what values to enter…Enlighten me, please.


#179

Hello,

we’ll check the conversion factor from the Google


And then apply the conversion in value field of the query

You can then edit the header of graph in “General” tab


#180

Thanx for responding.


#181

Hi,

I would like to store data to two separated DB’s at same time, for backup purposes. I am currently taking backups on OS-level by shutting down DB and tarring&zipping needed DB-files followed by startup of the DB.

It would be handy to store data from collector directly to two DB’s, something like this:

.# Base url to connect to, including protocol, hostname or ip address, and port
influxUrl=http://192.168.0.199:8086
Backup_influxUrl=http://192.168.0.200:8086

.# InfluxDB Database to use for measurements
influxDatabase=ruuvi
Backup_influxDatabase=ruuvi

.# InfluxDB measurement name to use for measurements
influxMeasurement=ruuvi_measurements
Backup_influxMeasurement=ruuvi_measurements

.# Username and password to use in influxdb. These can be ignored if you don’t use authentication in InfluxDB.
influxUser=ruuvi
Backup_influxUser=ruuvi
influxPassword=secret
Backup_influxPassword=secret

This requires code change of course…


#182

Hello,

InfluxDB supports live backups, is there a specific reason to not use them?


#183

If source DB gets corrupted or data erased by some reason, live backup is not option.


#184

Technically speaking fully-automatic live-backup-replication is not a backup at all (same reason why RAID is not a backup), so in that sense it makes sense to store the data in parallel, rather than replicating it forwards like a chain. It is actually on my long-term roadmap to support multiple simultaneous database/storage types, so I may as well adjust that a bit and support ambiguous database/storage types (ie. multiple InfluxDB) to support this use-case as well :thinking:

I’ll bump this feature forwards on my todo-list a little bit, but I don’t want to give any promises yet on when this will be done


transfer the data measured by ruuviTag to my influxDB database
#185

had to install this image again on a new card. Now I cannot find a/the guide on how to remove the bridge br0 and enable wlan0 with a static IP.I need to have the rb pi connected to my wifi at home.

Can some one please link to a complete guide or just tell me the steps.

/Andre’


#186

Hello, the steps are at https://blog.ruuvi.com/rpi-gateway-6e4a5b676510


#187

but how do I remove the br0 and wlan0 ruuviGW?

I don’t want/need anything else than just a simple wifi connection from ti PI to my router.

/Andre’