Collecting RuuviTag measurements and displaying them with Grafana

otso · June 1, 2018, 12:29pm

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.

Scrin · June 1, 2018, 12:43pm

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.

Mike_Schattl · June 4, 2018, 11:38am

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

otso · June 4, 2018, 11:53am

You could configure the conversion with math operation in value field

Mike_Schattl · June 4, 2018, 12:08pm

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

otso · June 4, 2018, 12:41pm

I think this should do the trick.

Mike_Schattl · June 4, 2018, 12:55pm

OK, Thanx a bunch!!!

caleno · June 5, 2018, 7:17am

I’ve got Raspberry pi 3

Stefan · June 28, 2018, 6:29pm

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

}}}

Andre_Norrback · July 10, 2018, 2:51pm

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’

Mike_Schattl · July 24, 2018, 5:06pm

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

Please lemme know.

Thanx.

otso · July 25, 2018, 7:30am

Hello,

You could use the math function to convert the value

Mike_Schattl · July 25, 2018, 9:29am

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

otso · July 25, 2018, 10:43am

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

Mike_Schattl · August 1, 2018, 1:32am

Thanx for responding.

mihaa · August 21, 2018, 10:03am

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…

otso · August 21, 2018, 10:17am

Hello,

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

mihaa · August 21, 2018, 11:15am

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

Scrin · August 21, 2018, 12:12pm

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

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

Andre_Norrback · September 28, 2018, 5:41pm

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’