expaso / hassos-addon-timescaledb

A HomeAssistant add-on containing PostgreSQL, psql client and TimeScaleDb
Apache License 2.0
51 stars 14 forks source link

Errors compiling on armv7 #7

Closed berga closed 3 years ago

berga commented 4 years ago

Following issue Expaso/hassos-addons#5 I've tried to compile this on armv7 throws some errors on GO tools and alpine package dependencies

  openexr-2.5.3-r0:
    masked in: @edge
    satisfies: gdal-3.1.3-r1[so:libHalf-2_5.so.25]
               gdal-3.1.3-r1[so:libIex-2_5.so.25]
               gdal-3.1.3-r1[so:libIlmImf-2_5.so.25]
  cfitsio-3.49-r0:
    masked in: @edge
    satisfies: gdal-3.1.3-r1[so:libcfitsio.so.9]
  charls-2.1.0-r1:
    masked in: @edge
    satisfies: gdal-3.1.3-r1[so:libcharls.so.2]
  libdap-3.20.6-r0:
    masked in: @edge
    satisfies: gdal-3.1.3-r1[so:libdap.so.25]
               gdal-3.1.3-r1[so:libdapclient.so.6]
  freexl-1.0.6-r0:
    masked in: @edge
    satisfies: gdal-3.1.3-r1[so:libfreexl.so.1]
  hdf5-1.10.6-r1:
    masked in: @edge
    satisfies: gdal-3.1.3-r1[so:libhdf5.so.103]
  json-c-0.15-r0:
    masked in: @edge
    satisfies: world[json-c]
               postgis-3.0.2-r0[so:libjson-c.so.5]
               gdal-3.1.3-r1[so:libjson-c.so.5]
  libkml-1.3.0-r5:
    masked in: @edge
    satisfies: gdal-3.1.3-r1[so:libkmlbase.so.1]
               gdal-3.1.3-r1[so:libkmldom.so.1]
               gdal-3.1.3-r1[so:libkmlengine.so.1]
  poppler-20.10.0-r0:
    masked in: @edge
    satisfies: gdal-3.1.3-r1[so:libpoppler.so.103]
  proj-datumgrid-7.1.0-r0:
    masked in: @edge
    satisfies: proj-7.1.0-r0[proj-datumgrid]
  proj-7.1.0-r0:
    masked in: @edge
    satisfies: world[proj]
               postgis-3.0.2-r0[so:libproj.so.20]
               gdal-3.1.3-r1[so:libproj.so.20]
  gdal-3.1.3-r1:
    masked in: @edge
    satisfies: world[gdal]
               postgis-3.0.2-r0[so:libgdal.so.27]
  postgis-3.0.2-r0:
    masked in: @edge
    satisfies: world[postgis]
expaso commented 4 years ago

Nice one! Let's see if this passes CI. We have to test the upgrade path for existing users though, because of the different postgis package. Thanks for the PR!

expaso commented 4 years ago

Looks like we could also enable x86.. Although I don't know if this is used anywhere in home-assistant world.

expaso commented 4 years ago

Can you try using docker image 1.1.5 manually? It's a prelease now. Edit: When doing armv7, I also want to support armhf (and possibly i386) in 1 update, so the users database downtime is kept to a minimum.

berga commented 4 years ago

Hi,

I'm sorry for the delay, I'm running the latest version since last commit and it's going well:

Add-on version: 1.1.5
 You are running the latest version of this add-on.
parse error: Expected string key before ':' at line 1, column 4
[17:37:28] ERROR: Unknown HTTP error occured
 System:   (armv7 / raspberrypi4)
 Home Assistant Core: 0.116.4
 Home Assistant Supervisor: 247
expaso commented 4 years ago

Allright! I will upgrade the instance to support armhf/i386 as well..

expaso commented 4 years ago

Released v1.1.6, which also added armhf and i386.

Thanks @berga for your help!

boesing commented 3 years ago

The addon works for 32-bit but the postgis extension doesn't.

I'm getting the following error when I want to create the extension:

ERROR: could not load library "/usr/lib/postgresql/postgis-3.so": Error relocating /usr/lib/postgresql/postgis-3.so: __time64: symbol not found

Is that 64-bit related?

expaso commented 3 years ago

Hmm I suppose it is indeed. See if we can get this fixed for you. Whats is your current setup? Like device&architechture?

boesing commented 3 years ago

@Expaso I was on Raspberry Pi 4 with HassOS 32-bit version (v4.x). I've recently migrated to HassOS 64-bit due to a migration to full SSD.

So now I am on Raspberry Pi 4 with NVMe SSD with HassOS 64-bit (v5.x pre-release) and this plugin works as expected. 👍 But there might be others out there who might want to use Postgis.

expaso commented 3 years ago

Should be fixed in the upcoming 2.0.0 release.

Caution! Running PostgreSQL on non 64-Bit architectures is no longer supported due to the lack of resources (mem <2GB). Since the 64-bit versions of Hassos are now the recommended versions, support for non 64-bit architectures will be removed in future versions of this addon.

boesing commented 3 years ago

I've already upgrade to x64 so no problem here. Thanks for the feedback anyways!