Collecting RuuviTag measurements and displaying them with Grafana

There’s no changelog, but you can find the description of image at https://lab.ruuvi.com/ruuvitag-fw/ .
What version of Raspberry Pi you’re running?

Grafana shows all tags by mac on default, you can configure the aliases if you want to.

For the name tags to work you need to add a GROUP BY clause as tag (name) in the panel configuration on the Metrics tab, because otherwise InfluxDB will not return the names to Grafana. The example planels have only tag (mac) as the GROUP BY. After that you can set ALIAS BY to $tag_name for example.

2 Likes

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

You could configure the conversion with math operation in value field

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

I think this should do the trick.

OK, Thanx a bunch!!!

I’ve got Raspberry pi 3

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’)

}}}

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’

1 Like

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

Please lemme know.

Thanx.

Hello,

You could use the math function to convert the value

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

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

Thanx for responding.

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…

Hello,

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

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

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

2 Likes

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’