search

Expaso / hassos-addons

Home Assistant Add-ons
Apache License 2.0
46 stars 14 forks source link

Problem with fresh pgAdmin install #21

Closed Mario-H closed 1 year ago

Mario-H commented 1 year ago

Hi,

Thanks for the add-ons. I'm trying to install the timescaledb and pgadmin4 add-ons on a newly setup system but I can't get pgadmin4 running.

Add-on: TimescaleDB
Add-on version: 2.0.1
You are running the latest version of this add-on.
System: Home Assistant OS 9.0  (amd64 / generic-x86-64)
Home Assistant Core: 2022.9.4
Home Assistant Supervisor: 2022.08.6

In the TimescaleDB log I see some Errors, Hints and Statements but it ends with "NOTICE: TimescaleDb is running!" so I assume that's OK.

After that I started pgadmin4 but although it looks like it starts at first it seems to be killed after an "Illegal instruction" is reported.

Add-on: pgAdmin4
Add-on version: 2.0.0
You are running the latest version of this add-on.
System: Home Assistant OS 9.0  (amd64 / generic-x86-64)
Home Assistant Core: 2022.9.4
Home Assistant Supervisor: 2022.08.6

<Snip>

[17:42:06] INFO: Starting NGinx...
[17:42:06] NOTICE: pgAdmin is running.
[17:42:06] NOTICE: pgAdmin4 is ready to accept connections.
nginx: [warn] lua_load_resty_core is deprecated (the lua-resty-core library is required since ngx_lua v0.10.16) in /etc/nginx/nginx.conf:43
./run: line 28:   585 Illegal instruction     (core dumped) exec nginx
[cont-finish.d] executing container finish scripts...
[cont-finish.d] 99-message.sh: executing... 
[cont-finish.d] 99-message.sh: exited 0.
[cont-finish.d] done.
[s6-finish] waiting for services.
[s6-finish] sending all processes the TERM signal.
[2022-09-18 17:42:07 +0200] [568] [INFO] Handling signal: hup
[2022-09-18 17:42:07 +0200] [568] [INFO] Hang up: Master
[2022-09-18 17:42:07 +0200] [568] [WARNING] Worker with pid 577 was terminated due to signal 1
[2022-09-18 17:42:08 +0200] [568] [INFO] Handling signal: term
[2022-09-18 17:42:08 +0200] [635] [INFO] Booting worker with pid: 635
[s6-finish] sending all processes the KILL signal and exiting.

Any advice on how to proceed?

Expaso commented 1 year ago

Hi @Mario-H!

What system / processor architecture are you running on?

Is it x86 of x64 ?

Mario-H commented 1 year ago

Hi,

I use AMD G-T48E Dual Core 1,4GHz, Cache 1M (64-bit dual-core x86)

Expaso commented 1 year ago

Hmm, should have no problems with that. Are you running on HassOS? Or do you have it installed it on a custom docker setup?

Mario-H commented 1 year ago

HassOS on a Dell Wise Thin Client.

Did another frsh install om my Thin Client, installed timescaledb and pgAdmin. No problem with starting timescaledb but when I try to start pgAdmin:

[19:32:30] INFO: Starting NGinx... [19:32:30] NOTICE: pgAdmin is running. [19:32:30] NOTICE: pgAdmin4 is ready to accept connections.

nginx: [warn] lua_load_resty_core is deprecated (the lua-resty-core library is required since ngx_lua v0.10.16) in /etc/nginx/nginx.conf:43
./run: line 28:   554 Illegal instruction     (core dumped) exec nginx
[cont-finish.d] executing container finish scripts...
[cont-finish.d] 99-message.sh: executing... 
[cont-finish.d] 99-message.sh: exited 0.
[cont-finish.d] done.
[s6-finish] waiting for services.
[s6-finish] sending all processes the TERM signal.
[2022-09-25 19:32:32 +0200] [537] [INFO] Handling signal: hup
[2022-09-25 19:32:32 +0200] [537] [WARNING] Worker with pid 546 was terminated due to signal 1
[2022-09-25 19:32:32 +0200] [537] [INFO] Hang up: Master
[2022-09-25 19:32:32 +0200] [537] [INFO] Handling signal: term
[2022-09-25 19:32:32 +0200] [602] [INFO] Booting worker with pid: 602
[s6-finish] sending all processes the KILL signal and exiting.
Expaso commented 1 year ago

Hi @Mario-H, I am releasing a new version of the addon.. stay tuned, it will be available this week.

Expaso commented 1 year ago

Hui @Mario-H! The new version is ready! Please make sure you clear your browser cache if you experience any issues.

If the issue above still remains, please let me know!

Mario-H commented 1 year ago

Hi, Thanks for the update.

The add-on did not detect the update so in the end I: Uninstalled PGadmin4 Uninstalled TimescaleDB Removed repository Added repository again and re-installed TimescaleDB & PGadmin4. TimescaleDB started without errors but PGadmin4 still didn't won't to start.

With SSL disabled:

s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service fix-attrs successfully started
s6-rc: info: service legacy-cont-init: starting
cont-init: info: running /etc/cont-init.d/00-banner.sh
-----------------------------------------------------------
 Add-on: pgAdmin4
 A PostgreSQL Management and Query tool
-----------------------------------------------------------
 Add-on version: 2.1.1
 You are running the latest version of this add-on.
 System: Home Assistant OS 9.0  (amd64 / generic-x86-64)
 Home Assistant Core: 2022.9.6
 Home Assistant Supervisor: 2022.10.2
-----------------------------------------------------------
 Please, share the above information when looking for help
 or support in, e.g., GitHub, forums or the Discord chat.
-----------------------------------------------------------
cont-init: info: /etc/cont-init.d/00-banner.sh exited 0
cont-init: info: running /etc/cont-init.d/01-log-level.sh
cont-init: info: /etc/cont-init.d/01-log-level.sh exited 0
cont-init: info: running /etc/cont-init.d/nginx.sh
cont-init: info: /etc/cont-init.d/nginx.sh exited 0
cont-init: info: running /etc/cont-init.d/pgadmin4.sh
NOTE: Configuring authentication for DESKTOP mode.
s6-rc: fatal: timed out
/run/s6/basedir/scripts/rc.init: warning: s6-rc failed to properly bring all the services up! Check your logs (in /run/uncaught-logs/current if you have in-container logging) for more information.
prog: fatal: stopping the container.
s6-sudoc: fatal: unable to get exit status from server: Operation timed out
s6-rc: info: service fix-attrs: stopping
s6-rc: info: service fix-attrs successfully stopped
s6-rc: info: service s6rc-oneshot-runner: stopping
s6-rc: info: service s6rc-oneshot-runner successfully stopped

When I enabled SSL it started up (with one warning):

s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service fix-attrs successfully started
s6-rc: info: service legacy-cont-init: starting
cont-init: info: running /etc/cont-init.d/00-banner.sh
-----------------------------------------------------------
 Add-on: pgAdmin4
 A PostgreSQL Management and Query tool
-----------------------------------------------------------
 Add-on version: 2.1.1
 You are running the latest version of this add-on.
 System: Home Assistant OS 9.0  (amd64 / generic-x86-64)
 Home Assistant Core: 2022.9.6
 Home Assistant Supervisor: 2022.10.2
-----------------------------------------------------------
 Please, share the above information when looking for help
 or support in, e.g., GitHub, forums or the Discord chat.
-----------------------------------------------------------
cont-init: info: /etc/cont-init.d/00-banner.sh exited 0
cont-init: info: running /etc/cont-init.d/01-log-level.sh
cont-init: info: /etc/cont-init.d/01-log-level.sh exited 0
cont-init: info: running /etc/cont-init.d/nginx.sh
cont-init: info: /etc/cont-init.d/nginx.sh exited 0
cont-init: info: running /etc/cont-init.d/pgadmin4.sh
cont-init: info: /etc/cont-init.d/pgadmin4.sh exited 0
cont-init: info: running /etc/cont-init.d/user.sh
cont-init: info: /etc/cont-init.d/user.sh exited 0
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service legacy-services: starting
services-up: info: copying legacy longrun nginx (no readiness notification)
services-up: info: copying legacy longrun pgadmin4 (no readiness notification)
s6-rc: info: service legacy-services successfully started
[20:56:07] INFO: Starting pgAdmin..
[20:56:33] INFO: Waiting for pgadmin to become available..
.
.
.
.
.
.
.
.
.
.
.
[2022-11-10 20:56:38 +0100] [368] [INFO] Starting gunicorn 20.1.0
[2022-11-10 20:56:38 +0100] [368] [INFO] Listening at: unix:/tmp/pgadmin4.sock (368)
[2022-11-10 20:56:38 +0100] [368] [INFO] Using worker: gthread
[2022-11-10 20:56:38 +0100] [391] [INFO] Booting worker with pid: 391
[20:56:38] INFO: Starting NGinx...
[20:56:39] NOTICE: pgAdmin is running.
[20:56:39] NOTICE: pgAdmin4 is ready to accept connections.
nginx: [warn] lua_load_resty_core is deprecated (the lua-resty-core library is required since ngx_lua v0.10.16) in /etc/nginx/nginx.conf:43

I do have a GUI now so I can start exploring.

Thanks for your help.