# \[APP\]\[Pro\] InfluxDb

**URL:** <https://community.homey.app/t/app-pro-influxdb/32405>\
**Category:** Apps\
**Tags:** app\
**Created:** [July 15, 2020, 5:21am UTC](https://community.homey.app/t/app-pro-influxdb/32405 "2020-07-15T05:21:40Z")\
**Posts on this page:** 20\
**Page:** 7

<div class="post-metadata">

**Author:** ![TheSource](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/thesource/32/53900_2.png) [@TheSource](https://community.homey.app/u/TheSource)\
**Post date:** [November 12, 2023, 11:00am UTC](https://community.homey.app/t/app-pro-influxdb/32405/124 "2023-11-12T11:00:07Z")

</div>

Does anybody have clear instructions to run influxDb locally? Since I see the cloud has a retention of 1 month (free version) which means I guess 1 month data is purged.

---

<div class="post-metadata">

**Author:** ![Sharkys](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sharkys/32/54029_2.png) [@Sharkys](https://community.homey.app/u/Sharkys)\
**Post date:** [November 12, 2023, 3:06pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/125 "2023-11-12T15:06:02Z")

</div>

NAS ? Docker?

Eg. [Setting up InfluxDB using Docker | GH2home](https://gh2home.nl/synology/setting-up-influxdb-using-docker/)

I guess you can even run it on RPi etc.

---

<div class="post-metadata">

**Author:** ![Friedhofsblond](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/friedhofsblond/32/93838_2.png) [@Friedhofsblond](https://community.homey.app/u/Friedhofsblond)\
**Post date:** [November 13, 2023, 4:53pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/126 "2023-11-13T16:53:33Z")

</div>

Hello  
I’ve been running influxdb directly on a small ioserver (Dell Wyse) for a long time, together with iobroker and grafana.

---

<div class="post-metadata">

**Author:** ![TheSource](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/thesource/32/53900_2.png) [@TheSource](https://community.homey.app/u/TheSource)\
**Post date:** [November 15, 2023, 11:23pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/127 "2023-11-15T23:23:42Z")

</div>

I decided to run both InfluxDB and Grafana in Hassio, after lot of trying I finally got it running. (ip instead of local host did the trick).

I got the impression that with having everything connected the data isn’t automaticly transfered and I saw some people talking about flows. What kind of flow should I create that all data is logged to Influx?

---

<div class="post-metadata">

**Author:** ![Sharkys](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sharkys/32/54029_2.png) [@Sharkys](https://community.homey.app/u/Sharkys)\
**Post date:** [November 16, 2023, 7:21am UTC](https://community.homey.app/t/app-pro-influxdb/32405/128 "2023-11-16T07:21:56Z")

</div>

For example :  
 ![obrazek](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/0/e00d7fc8bbe06ca374281a7837fcfaead42974ef.png)

---

<div class="post-metadata">

**Author:** ![TheSource](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/thesource/32/53900_2.png) [@TheSource](https://community.homey.app/u/TheSource)\
**Post date:** [November 16, 2023, 3:42pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/129 "2023-11-16T15:42:08Z")

</div>

Thanks I got it working. Now I will need to spend some days in Grafana to create some dashboards to visulize everything. My SQL knowledge from 20 year ago… so will be cost some time.

Q1: If the database goes offline will it sync all missed data again once it goed online? Or does it only sync realtime generated data?  
Q2: Any way to import old data from insights to InfluxDB?

---

<div class="post-metadata">

**Author:** ![Marius\_Stensrod](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/marius_stensrod/32/56540_2.png) [@Marius\_Stensrod](https://community.homey.app/u/Marius_Stensrod)\
**Post date:** [December 24, 2023, 1:28pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/130 "2023-12-24T13:28:51Z")

</div>

Hello,

InfluxDb app-v1.2.2 (tried the offical too)  
HP23 FW-v10.2.0

Everytime i restart det HP23, det InfluxDb app has to be restarted to get it going again. I have now made a flow that automaticly restarts the app after the HP23 has started, but can you do something with the app so it is not nessessary?

Regards  
Marius

---

<div class="post-metadata">

**Author:** ![Nine](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/nine/32/82555_2.png) [@Nine](https://community.homey.app/u/Nine)\
**Post date:** [January 7, 2024, 7:20pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/131 "2024-01-07T19:20:46Z")

</div>

I’m running Grafana and InfluxDB (v1) both on an rPI. They are connected to each other. With the same user/password in homey, the InfluxDB-App (tried v1.2.1 and 1.2.2) is not able to connect to the InfluxDB. Here are my settings in homey:

 ![Bildschirmfoto 2024-01-07 um 20.19.50](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/2/824c0d336918f3cd0281f2e1f5eb0065aed09770.png)

Is there any way to check, what the problem is?

Simon

---

<div class="post-metadata">

**Author:** ![Sharkys](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sharkys/32/54029_2.png) [@Sharkys](https://community.homey.app/u/Sharkys)\
**Post date:** [January 7, 2024, 7:43pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/132 "2024-01-07T19:43:32Z")

</div>

What shows the previous screen with status ?

---

<div class="post-metadata">

**Author:** ![Nine](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/nine/32/82555_2.png) [@Nine](https://community.homey.app/u/Nine)\
**Post date:** [January 7, 2024, 8:39pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/133 "2024-01-07T20:39:37Z")

</div>

Disconnected

---

<div class="post-metadata">

**Author:** ![Marius\_Stensrod](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/marius_stensrod/32/56540_2.png) [@Marius\_Stensrod](https://community.homey.app/u/Marius_Stensrod)\
**Post date:** [January 7, 2024, 9:00pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/134 "2024-01-07T21:00:15Z")

</div>

Are you sure your credentials are right, and the user “homey” have the right access (write) to the “homey” database you have created in Influxdb on the rpi?

---

<div class="post-metadata">

**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\
**Post date:** [January 7, 2024, 9:09pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/135 "2024-01-07T21:09:20Z")

</div>

Maybe this is of any help

> [@\[APP\]\[Pro\] InfluxDb](https://community.homey.app/t/app-pro-influxdb/32405/81):
>
> I just installed influxdb (v1) and grafana using [this howto](https://computingforgeeks.com/how-to-install-influxdb-on-debian-linux/) and it works ok. I just installed it on a Debian 11 server, no docker. Do you see a number other than zero at ‘Measurements’? In what way do you query the database? On the server with influxdb I installed influx client On Debian I did: sudo apt install influxdb-client Open the database: influx -database 'homey' -precision rfc3339 Then the command line changes from ~$ to \> Now enter select …

---

<div class="post-metadata">

**Author:** ![Nine](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/nine/32/82555_2.png) [@Nine](https://community.homey.app/u/Nine)\
**Post date:** [January 8, 2024, 5:08pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/136 "2024-01-08T17:08:26Z")

</div>

```auto
Connected to http://localhost:8086 version 1.8.10
InfluxDB shell version: 1.8.10
> CREATE USER homey WITH PASSWORD ' *******' WITH ALL PRIVILEGES
> SHOW USERS
user admin
admin true
homey true

> GRANT ALL ON homey TO homey
> SHOW GRANTS FOR homey
database privilege
-------- ---------
homey ALL PRIVILEGES

```

yes, I’m pretty sure that the user homey exists and has write access. Is there a way to see what error occures in the homey influxdb-app?

---

<div class="post-metadata">

**Author:** ![Sharkys](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sharkys/32/54029_2.png) [@Sharkys](https://community.homey.app/u/Sharkys)\
**Post date:** [January 8, 2024, 6:36pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/137 "2024-01-08T18:36:10Z")

</div>

Actually now I remember, I had those issues as well, so I have switched to v2. Can you try that ?

---

<div class="post-metadata">

**Author:** ![Marius\_Stensrod](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/marius_stensrod/32/56540_2.png) [@Marius\_Stensrod](https://community.homey.app/u/Marius_Stensrod)\
**Post date:** [January 8, 2024, 6:50pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/138 "2024-01-08T18:50:02Z")

</div>

> [@Nine](#):
>
> Is there a way to see what error occures in the homey influxdb-app?

Not as far as i know. Just a couple of more questions: Have you modified the influxdb.conf file to accept http-connections? No inbound network restrictions using http? Have your tried the hostname of the PI-influxdb instead of the IP-adress (in homey app)? You are able to connect to the database in Grafana, using the credentials you are trying to use in homey-app? Have you tried to manually write data to the influxdb-database using CLI in RaspberryPi? Have you tried adding a normal user, only with write privileges to the homey-database? If all is checked/veryfied, then i do not have anymore suggestions.

---

<div class="post-metadata">

**Author:** ![Nine](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/nine/32/82555_2.png) [@Nine](https://community.homey.app/u/Nine)\
**Post date:** [January 9, 2024, 7:02am UTC](https://community.homey.app/t/app-pro-influxdb/32405/139 "2024-01-09T07:02:12Z")

</div>

- I set in influxdb.conf

```auto
[http]
 enabled = true
 bind-address = ":8086"
 auth-enabled = true
 pprof-enabled = true
 pprof-auth-enabled = true
 ping-auth-enabled = true

```

- inbound network restrictions using http → I don’t understand this questen
- tried localhost and the hostname of the rPI instead of the IP-Adress: did not work
- yes, Grafana can connect with the credentials I use in homey
- yes, I can add data to influxdb using CLI (and display them in Grafana)
- tried a normal user → did not work as well

Will try to install the influxDB v2 and give it new chance…

---

<div class="post-metadata">

**Author:** ![M\_a\_r\_c\_o](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/m_a_r_c_o/32/146_2.png) [@M\_a\_r\_c\_o](https://community.homey.app/u/M_a_r_c_o)\
**Post date:** [January 9, 2024, 10:38am UTC](https://community.homey.app/t/app-pro-influxdb/32405/140 "2024-01-09T10:38:00Z")

</div>

Firewall in de rPI Linux? does it allow port 8086 from outside?  
This is needed to open up if connecting from outside the rPI are needed, unless you have influx and Grafana running in a docker (stack).

```auto
[http]
  enabled = true
  bind-address = ":8086"
  auth-enabled = true
  https-enabled = false

```

Add the last line to the config file to do only http and not https

---

<div class="post-metadata">

**Author:** ![Nine](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/nine/32/82555_2.png) [@Nine](https://community.homey.app/u/Nine)\
**Post date:** [January 9, 2024, 11:15am UTC](https://community.homey.app/t/app-pro-influxdb/32405/141 "2024-01-09T11:15:35Z")

</div>

I just installed v2 – and it connects without any problems

→ troubleshooting v1: 2h vs. installing v2: 5min 🤷‍♂️

---

<div class="post-metadata">

**Author:** ![Sharkys](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sharkys/32/54029_2.png) [@Sharkys](https://community.homey.app/u/Sharkys)\
**Post date:** [January 9, 2024, 3:43pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/142 "2024-01-09T15:43:00Z")

</div>

So I did recall it correctly 😉

---

<div class="post-metadata">

**Author:** ![Friedhofsblond](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/friedhofsblond/32/93838_2.png) [@Friedhofsblond](https://community.homey.app/u/Friedhofsblond)\
**Post date:** [January 20, 2024, 7:41pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/143 "2024-01-20T19:41:35Z")

</div>

@balmli

Hello  
Sorry, I wanted to try again with the influx app.  
I think I’m doing something wrong.  
I have the following questions again:  
Does the influxdb (e.g. homeydb) have to be created beforehand?  
How must the token be entered:  
e.g. with “token g6x7AI\_4G…3PHlYI-uaQg==” ?  
No matter what password I enter, I always have “connected” - but no data in the Influx.  
(InfluxDB v2.7.4, App 1.2.2 test)

What am I doing wrong??  
Many thanks for the help

 ![influx-homey211221211](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/f/cf7bce86c1be14784fa51e565fb882af73d9741b.png)  
 ![influx-homey21112](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/3/639dbe8daee6db51c7eac41100a0e75bdab4d3f2.png)  
 ![influx-homey2111211](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/9/8/9815abc4296b95a918636fd0e5cdc625501f2821.png)  
 ![influx-homey212112](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/6/063d55ffb744052cfc58bcad4723aa5fa99d8c91.png)

[Previous page](https://community.homey.app/t/app-pro-influxdb/32405.md?page=6)

[Next page](https://community.homey.app/t/app-pro-influxdb/32405.md?page=8)