Unable to get influxdB running [Unresolved - Abandoned]

I’ve installed the influx addon and set it up, but it doesn’t appear to be running correctly.

I’ve set up the database, username and password and also amended the configuration.yaml file, which all seems to be quite straightforward. But when I click on ‘Explore’ ‘homeassisant.autogen’ there’s no drop-down list of measurements that indicates that the database is being populated.

The addon log is quite busy, but eventually stops with an error: ‘Failed to get a0d7b954_influxdb logs, Error in input stream’.

I’m at a loss as to where to start looking for the problem and would be grateful for some guidance please.
Jim

Have a quick look at this and make sure you got it right: https://www.youtube.com/watch?v=m9qIqq104as

Thanks for the link, Tom.

I’ve had a look, but I can’t even get the influxDB database populated with any data.

If I query the DB in ‘Explore’ with:

SELECT * FROM "homeassistant"."autogen"."*" 

I get no results.

Jim

It looks like I need a reverse proxy (nginx) as I’m using Duck DNS and Let’s Encrypt.

I’m starting to lose the will!

Jim

No that should not be necessary for the addon. I used InfluxDB without issue when I had DuckDNS.

Can you share your InfluxDB integration config?

Any related errors in the logs?

My influxDB credentials are consistent across the addon, including the configuration.yaml.

The UI logs aren’t much help, but ssh’ing into the Pi to check the homeassistant.log I see:

ERROR (SyncWorker_3) [homeassistant.components.influxdb] Cannot connect to InfluxDB due to 'HTTPConnectionPool(host='192.168.1.5', port=8086): Max retries exceeded with url: /write?db=homeassistant (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f585606e0>: Failed to establish a new connection: [Errno 111] Connection refused'))'. Please check that the provided connection details (host, port, etc.) are correct and that your InfluxDB server is running and accessible. Retrying in 60 seconds.

Jim

I had the same issue. You have to change the host: in your configuraiton.yaml to your internal IP or domain. For me ha.local works.

Thanks for the reply ‘Lipown’.

The logs show errors such as:
“Cannot connect to InfluxDB due to ‘HTTPConnectionPool(host=‘https’, port=80): Max retries exceeded with url: /*******.duckdms.org:8086/write?db=homeassistant (Caused by NewConnectionError(’<urllib3.connection.HTTPConnection object at 0x7f4d18c8c0>: Failed to establish a new connection: [Errno -5] Name has no usable address’))'. Please check that the provided connection details (host, port, etc.) are correct and that your InfluxDB server is running and accessible. Retrying in 60 seconds.”

This is the relevant entry in my homeassistant.yaml file:

  external_url: https://******.duckdns.org
  internal_url: http://192.168.1.5:8123

I tried http://homeassistant.local for the internal url, but it didn’t make any difference. I’ve had Duckdns and Let’s Encrypt running without problems for several months now without other problems, but I suspect that Duckdns may be causing this problem.

(I’m mystified why the error log gave an incomplete url!)

Jim

I’ve given up on this as I’m unable to get it working no matter what I do, and I don’t want to spend any more time on it!

Thanks for those who offered assistance.

Jim

You have to use internal IP, not external one.

And another hint - you have to use the addon without SSL. Or have… I don’t know but with SSL it does not work for me :slight_smile:
(you can disable it in the influx DB configuration)

And here is part of my config in configuration.yaml
Screenshot_20241227-174604