Outdated goalchemy2 version?

[Drazhar]

Hello

I'm quite new to Home Assistant and was using InfluxDB since now for my long term storage. But I dislike the "new" version of Influx 2.x with the Flux part. Also it would be great to just have one database running, which can store the normal home assistant data in Postgres and the long term sensor data in Timescale.

Now onto my issue :-)
If I try to use the LTSS extension, I get the following error: Setup failed for custom integration ltss: Requirements for ltss not found: ['geoalchemy2>=0.8,<0.9'].

I checked the goalchemy2 version in the Home Assistant repository and it's sqlalchemy==1.4.45. link

I never used sqlalchemy, but are there huge breaking changes between the two versions? Do you think we/you could just upgrade to ´>=1.4.45´?

I also have no idea how to develop an integration for Home Assistant. But it seems that's not possible to have an own "venv" for each integration?

edit: I just digged a bit deeper and it seems that requirements should be installed by default. The more detailed logs show, that the c compiler gcc ist not installed in the docker container which is running home assistant. Therefor pip fails installing sqlalchemy! I will try to fit it tomorrow and close this issue if this solved it.

[Drazhar]

Adding gcc and g++ to the docker image fixed the issue!

If the error occurs in the future, here is the solution:

1. Instead of running the docker image homeassistant/home-assistant directly, create a Dockerfile and declare build in the docker-compose.yml with the path to the build directory. In my case, the Dockerfile is at build/Dockerfile, so the yml should contain build: ./build
2. The Dockerfile ist quite simple. It just contains the following:

   FROM homeassistant/home-assistant
   
   RUN apk add gcc g++
   

3. Use docker-compose up -d --build to build the image

[freol35241]

@Drazhar Interesting, I have not seen this problem previously and I have always believed home assistant "just sorts these things out". Well, good you found a solution and thanks for reporting back!