-
Notifications
You must be signed in to change notification settings - Fork 27
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Issue with upgrading older version of UISP (1.6.5 --> 2.3.57) #103
Comments
Hi, do you actually use a docker volume or do you simply mean a local directory that get's passed to the container? Do you use docker compose or did you initially simply start UISP with A normal update would look something like this: First of all, make sure to download the latest backup directly from the UISP web interface. I suggest updating one major version at a time, because Ubiquiti's install script also doesn't allow you to skip major versions as far as I know. Example for updating without docker compose to 1.7.5 (then 2.2.15, latest)
|
Hi Nico640,
Thanks for taking the time to help me with this. I installed this a number
of years ago and now trying to wrap my brain around the installation. I
have a windows PC with docker desktop installed, but also a linux
distribution on the same computer (I guess this was a prerequisite for
UISP?). UISP is running in a container in docker desktop with a volume for
persistent storage (not a bind mount). See pics for clarification. I don't
use the command line too often, mostly if the container crashes I use the
restart button on the container.
Please find below the 'copy docker run' command from Docker Desktop, I'm
not using Docker Compose.
docker run --hostname=84a2ced97dde --mac-address=02:42:ac:11:00:02
--env=PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/home/app/unms/node_modules/.bin:/opt/rabbitmq/sbin:/usr/local/openresty/bin
--env=NODE_VERSION=16.13.1 --env=YARN_VERSION=1.22.15
--env=S6_OVERLAY_ARCH=x86_64 --env=S6_KEEP_ENV=1 --env=APK_ARCH=x86_64
--env=LIBVIPS_VERSION=8.12.2 --env=OPEN_RESTY_VERSION=openresty-1.21.4.1
--env=PHP_VERSION=php-7.4.26 --env=PHP_INI_DIR=/usr/local/etc/php
--env=SYMFONY_ENV=prod --env=LIBCLERI_VERSION=0.12.2
--env=SIRIDB_VERSION=2.0.45 --env=QUIET_MODE=0 --env=PUBLIC_HTTPS_PORT=443
--env=PUBLIC_WS_PORT=443 --env=HTTP_PORT=80 --env=HTTPS_PORT=443
--volume=servervol:/config --volume=/config --workdir=/home/app/unms -p
2055:2055/udp -p 443:443 -p 80:80 --restart=unless-stopped --runtime=runc
-d nico640/docker-unms:latest
This is all on one drive on the windows machine (same as OS disk). It would
be cool to find a way to move or just re-map the 'servervol' volume to a
new drive. Or maybe move the entire Linux distribution to a new drive if
that's easier? The Linux distribution is "Alpine Linux version 3.15".
Cheers
…On Tue, 27 Feb 2024 at 10:54, Nico640 ***@***.***> wrote:
Hi,
do you actually use a docker volume or do you simply mean a local
directory that get's passed to the container? Do you use docker compose or
did you initially simply start UISP with docker run ...? Can you post the
command used for starting / the docker compose file?
A normal update would look something like this:
First of all, make sure to download the latest backup directly from the
UISP web interface.
I suggest updating one major version at a time, because Ubiquiti's install
script also doesn't allow you to skip major versions as far as I know.
Example for updating without docker compose to 1.7.5 (then 2.2.15, latest)
sudo docker pull nico640/docker-unms:1.7.5
sudo docker stop unms
sudo docker rm unms
docker run -d --name unms -p 80:80 -p 443:443 -p 2055:2055/udp -v </path/to/config>:/config nico640/docker-unms:1.7.5
—
Reply to this email directly, view it on GitHub
<#103 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BGLCHWLBJRFPGK4TH44U6JDYVUACVAVCNFSM6AAAAABDUO5LXGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRVGM3DKNZQHA>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
Rich Tucker
AV & Tech Entrepreneur
|
docker pics attached!
…On Thu, 29 Feb 2024 at 11:33, Rich Tucker ***@***.***> wrote:
docker pic 1
On Thu, 29 Feb 2024 at 11:32, Rich Tucker ***@***.***>
wrote:
> Hi Nico640,
>
> Thanks for taking the time to help me with this. I installed this a
> number of years ago and now trying to wrap my brain around the
> installation. I have a windows PC with docker desktop installed, but also a
> linux distribution on the same computer (I guess this was a
> prerequisite for UISP?). UISP is running in a container in docker desktop
> with a volume for persistent storage (not a bind mount). See pics for
> clarification. I don't use the command line too often, mostly if the
> container crashes I use the restart button on the container.
>
> Please find below the 'copy docker run' command from Docker Desktop, I'm
> not using Docker Compose.
>
> docker run --hostname=84a2ced97dde --mac-address=02:42:ac:11:00:02
> --env=PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/home/app/unms/node_modules/.bin:/opt/rabbitmq/sbin:/usr/local/openresty/bin
> --env=NODE_VERSION=16.13.1 --env=YARN_VERSION=1.22.15
> --env=S6_OVERLAY_ARCH=x86_64 --env=S6_KEEP_ENV=1 --env=APK_ARCH=x86_64
> --env=LIBVIPS_VERSION=8.12.2 --env=OPEN_RESTY_VERSION=openresty-1.21.4.1
> --env=PHP_VERSION=php-7.4.26 --env=PHP_INI_DIR=/usr/local/etc/php
> --env=SYMFONY_ENV=prod --env=LIBCLERI_VERSION=0.12.2
> --env=SIRIDB_VERSION=2.0.45 --env=QUIET_MODE=0 --env=PUBLIC_HTTPS_PORT=443
> --env=PUBLIC_WS_PORT=443 --env=HTTP_PORT=80 --env=HTTPS_PORT=443
> --volume=servervol:/config --volume=/config --workdir=/home/app/unms -p
> 2055:2055/udp -p 443:443 -p 80:80 --restart=unless-stopped --runtime=runc
> -d nico640/docker-unms:latest
>
> This is all on one drive on the windows machine (same as OS disk). It
> would be cool to find a way to move or just re-map the 'servervol' volume
> to a new drive. Or maybe move the entire Linux distribution to a new drive
> if that's easier? The Linux distribution is "Alpine Linux version 3.15".
>
> Cheers
>
> On Tue, 27 Feb 2024 at 10:54, Nico640 ***@***.***> wrote:
>
>> Hi,
>>
>> do you actually use a docker volume or do you simply mean a local
>> directory that get's passed to the container? Do you use docker compose or
>> did you initially simply start UISP with docker run ...? Can you post
>> the command used for starting / the docker compose file?
>>
>> A normal update would look something like this:
>>
>> First of all, make sure to download the latest backup directly from the
>> UISP web interface.
>>
>> I suggest updating one major version at a time, because Ubiquiti's
>> install script also doesn't allow you to skip major versions as far as I
>> know.
>>
>> Example for updating without docker compose to 1.7.5 (then 2.2.15,
>> latest)
>>
>> sudo docker pull nico640/docker-unms:1.7.5
>> sudo docker stop unms
>> sudo docker rm unms
>> docker run -d --name unms -p 80:80 -p 443:443 -p 2055:2055/udp -v </path/to/config>:/config nico640/docker-unms:1.7.5
>>
>> —
>> Reply to this email directly, view it on GitHub
>> <#103 (comment)>,
>> or unsubscribe
>> <https://github.com/notifications/unsubscribe-auth/BGLCHWLBJRFPGK4TH44U6JDYVUACVAVCNFSM6AAAAABDUO5LXGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRVGM3DKNZQHA>
>> .
>> You are receiving this because you authored the thread.Message ID:
>> ***@***.***>
>>
>
>
> --
> Rich Tucker
> AV & Tech Entrepreneur
>
--
Rich Tucker
AV & Tech Entrepreneur
--
Rich Tucker
AV & Tech Entrepreneur
|
Hi, im not very familiar with Docker Desktop or Docker Volumes. If you are not using the WSL 2 backend, then I think you can simply change the location in the Docker Desktop Resources settings, though I am not sure if that will retain the existing data. If not, you might need to export and later import the volume, e.g. https://docs.docker.com/storage/volumes/#back-up-restore-or-migrate-data-volumes (shutdown UISP prior to doing this) Also, don't forget to download a UISP backup before doing any of this, so that you can always roll back if something goes wrong. Also, because your UISP data seems to be very important, I guess it wouldn't hurt to also export the volume (second link) in addition to downloading a UISP backup, so that there a two separate backups. |
Hi Nico640,
All good. If I end up losing the volume I can always restore from the
backup. Thanks for the tips.
Cheers
…On Mon, 11 Mar 2024 at 11:10, Nico640 ***@***.***> wrote:
Hi,
im not very familiar with Docker Desktop or Docker Volumes.
If your Docker Desktop installation is using the WSL 2 backend, which you
can check in the Docker Desktop settings under Resources, then you should
be able to move the whole WSL 2 linux VM to a different location somehow
like this:
https://dev.to/kim-ch/move-docker-desktop-data-distro-out-of-system-drive-4cg2
If you are not using the WSL 2 backend, then I think you can simply change
the location in the Docker Desktop Resources settings, though I am not sure
if that will retain the existing data. If not, you might need to export and
later import the volume, e.g.
https://docs.docker.com/storage/volumes/#back-up-restore-or-migrate-data-volumes
Also, don't forget to download a UISP backup before doing any of this, so
that you can always roll back if something goes wrong.
—
Reply to this email directly, view it on GitHub
<#103 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BGLCHWPUD27GV5H2PJDP7RLYXTK4ZAVCNFSM6AAAAABDUO5LXGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOBXGM3TQOJYGA>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
Rich Tucker
AV & Tech Entrepreneur
|
Hi Nico640,
After a windows update overnight, my unms docker container is completely
ruined. I have tried pulling down the container image again, wiping the
volume, pulling a later version (2.2.15), changing the ports yet nothing
solves the problem. Just wondering if you have been contacted by anyone
else in the same boat today. Pulling my hair out trying to get my
monitoring back up (I run a WISP business). Getting a load of connection
refused to upstream client messages in the log and when I view the login
page it simply says 'Something went wrong'. Also very high cpu usage on
that container.
Windows 10 version 10.0.19045 build 19045
Docker Desktop for Windows version 4.36.0
Running UISP version 1.7.5
Thanks
…On Mon, 11 Mar 2024 at 13:30, Rich Tucker ***@***.***> wrote:
Hi Nico640,
All good. If I end up losing the volume I can always restore from the
backup. Thanks for the tips.
Cheers
On Mon, 11 Mar 2024 at 11:10, Nico640 ***@***.***> wrote:
> Hi,
>
> im not very familiar with Docker Desktop or Docker Volumes.
> If your Docker Desktop installation is using the WSL 2 backend, which you
> can check in the Docker Desktop settings under Resources, then you should
> be able to move the whole WSL 2 linux VM to a different location somehow
> like this:
> https://dev.to/kim-ch/move-docker-desktop-data-distro-out-of-system-drive-4cg2
>
> If you are not using the WSL 2 backend, then I think you can simply
> change the location in the Docker Desktop Resources settings, though I am
> not sure if that will retain the existing data. If not, you might need to
> export and later import the volume, e.g.
> https://docs.docker.com/storage/volumes/#back-up-restore-or-migrate-data-volumes
>
> Also, don't forget to download a UISP backup before doing any of this, so
> that you can always roll back if something goes wrong.
>
> —
> Reply to this email directly, view it on GitHub
> <#103 (comment)>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/BGLCHWPUD27GV5H2PJDP7RLYXTK4ZAVCNFSM6AAAAABDUO5LXGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOBXGM3TQOJYGA>
> .
> You are receiving this because you authored the thread.Message ID:
> ***@***.***>
>
--
Rich Tucker
AV & Tech Entrepreneur
--
Rich Tucker
AV & Tech Entrepreneur
|
May be related to #110, can you post the log output here? |
Hi Nico640,
Thanks for your quick reply. I think there has been some other self-hosters
with this issue within the last 24 hours. Please find attached the log
file. I am going to uninstall the updates from last night (KB5048652 and
KB5046613) and see if that's the cause.
Cheers
…On Thu, 12 Dec 2024 at 09:55, Nico640 ***@***.***> wrote:
May be related to #110 <#110>,
can you post the log output here?
—
Reply to this email directly, view it on GitHub
<#103 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/BGLCHWOVHKT6YL3V7FHQZPT2FCRDHAVCNFSM6AAAAABTOJDMVSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKMZXGE2DIOJTG4>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
Rich Tucker
AV & Tech Entrepreneur
2024-12-12 09:46:37 s6-rc: info: service s6rc-oneshot-runner: starting
2024-12-12 09:46:37 s6-rc: info: service s6rc-oneshot-runner successfully started
2024-12-12 09:46:37 s6-rc: info: service fix-attrs: starting
2024-12-12 09:46:37 s6-rc: info: service fix-attrs successfully started
2024-12-12 09:46:37 s6-rc: info: service legacy-cont-init: starting
2024-12-12 09:46:37 cont-init: info: running /etc/cont-init.d/10-set-timezone
2024-12-12 09:46:37 cont-init: info: /etc/cont-init.d/10-set-timezone exited 0
2024-12-12 09:46:37 cont-init: info: running /etc/cont-init.d/20-adduser
2024-12-12 09:46:37
2024-12-12 09:46:37 -------------------------------------
2024-12-12 09:46:37 GID/UID
2024-12-12 09:46:37 -------------------------------------
2024-12-12 09:46:37 User uid: 911
2024-12-12 09:46:37 User gid: 911
2024-12-12 09:46:37 -------------------------------------
2024-12-12 09:46:37
2024-12-12 09:47:01 The files belonging to this database system will be owned by user "unms".
2024-12-12 09:47:01 This user must also own the server process.
2024-12-12 09:47:01
2024-12-12 09:47:01 The database cluster will be initialized with locales
2024-12-12 09:47:01 COLLATE: C
2024-12-12 09:47:01 CTYPE: C.UTF-8
2024-12-12 09:47:01 MESSAGES: C
2024-12-12 09:47:01 MONETARY: C
2024-12-12 09:47:01 NUMERIC: C
2024-12-12 09:47:01 TIME: C
2024-12-12 09:47:01 The default database encoding has accordingly been set to "UTF8".
2024-12-12 09:47:01 The default text search configuration will be set to "english".
2024-12-12 09:47:01
2024-12-12 09:47:01 Data page checksums are disabled.
2024-12-12 09:47:01
2024-12-12 09:46:37 cont-init: info: /etc/cont-init.d/20-adduser exited 0
2024-12-12 09:46:37 cont-init: info: running /etc/cont-init.d/30-prepare
2024-12-12 09:46:37 cont-init: info: /etc/cont-init.d/30-prepare exited 0
2024-12-12 09:46:37 cont-init: info: running /etc/cont-init.d/40-permissions
2024-12-12 09:47:00 cont-init: info: /etc/cont-init.d/40-permissions exited 0
2024-12-12 09:47:00 cont-init: info: running /etc/cont-init.d/50-postgres
2024-12-12 09:47:01 fixing permissions on existing directory /config/postgres ... ok
2024-12-12 09:47:01 creating subdirectories ... ok
2024-12-12 09:47:01 selecting dynamic shared memory implementation ... posix
2024-12-12 09:47:01 selecting default max_connections ... 100
2024-12-12 09:47:01 selecting default shared_buffers ... 128MB
2024-12-12 09:47:03 selecting default time zone ... UTC
2024-12-12 09:47:03 creating configuration files ... ok
2024-12-12 09:47:03 running bootstrap script ... ok
2024-12-12 09:47:04 performing post-bootstrap initialization ... ok
2024-12-12 09:47:05 syncing data to disk ... ok
2024-12-12 09:47:05
2024-12-12 09:47:05
2024-12-12 09:47:05 Success.
2024-12-12 09:47:05
2024-12-12 09:47:04 sh: locale: not found
2024-12-12 09:47:04 2024-12-11 20:47:04.016 UTC [122] WARNING: no usable system locales were found
2024-12-12 09:47:05 initdb: warning: enabling "trust" authentication for local connections
2024-12-12 09:47:05 You can change this by editing pg_hba.conf or using the option -A, or
2024-12-12 09:47:05 --auth-local and --auth-host, the next time you run initdb.
2024-12-12 09:47:05 cont-init: info: /etc/cont-init.d/50-postgres exited 0
2024-12-12 09:47:05 s6-rc: info: service legacy-cont-init successfully started
2024-12-12 09:47:05 s6-rc: info: service legacy-services: starting
2024-12-12 09:47:05 services-up: info: copying legacy longrun netflow (no readiness notification)
2024-12-12 09:47:05 services-up: info: copying legacy longrun nginx (no readiness notification)
2024-12-12 09:47:05 services-up: info: copying legacy longrun postgres (no readiness notification)
2024-12-12 09:47:05 services-up: info: copying legacy longrun rabbitmq (no readiness notification)
2024-12-12 09:47:05 services-up: info: copying legacy longrun siridb (no readiness notification)
2024-12-12 09:47:05 services-up: info: copying legacy longrun ucrm (no readiness notification)
2024-12-12 09:47:05 services-up: info: copying legacy longrun unms (no readiness notification)
2024-12-12 09:47:05 s6-rc: info: service legacy-services successfully started
2024-12-12 09:47:05 2024-12-11 20:47:05.246 UTC [286] LOG: starting PostgreSQL 13.8 on x86_64-alpine-linux-musl, compiled by gcc (Alpine 10.3.1_git20211027) 10.3.1 20211027, 64-bit
2024-12-12 09:47:05 2024-12-11 20:47:05.246 UTC [286] LOG: listening on IPv6 address "::1", port 5432
2024-12-12 09:47:05 2024-12-11 20:47:05.246 UTC [286] LOG: listening on IPv4 address "127.0.0.1", port 5432
2024-12-12 09:47:05 2024-12-11 20:47:05.253 UTC [286] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"
2024-12-12 09:47:05 2024-12-11 20:47:05.262 UTC [362] LOG: database system was shut down at 2024-12-11 20:47:04 UTC
2024-12-12 09:47:05 Starting siridb-server...
2024-12-12 09:47:05 Waiting for rabbitmq to start...
2024-12-12 09:47:05 Starting nginx...
2024-12-12 09:47:05 Starting rabbitmq-server...
2024-12-12 09:47:05 Running entrypoint.sh
2024-12-12 09:47:05 /run/postgresql:5432 - no response
2024-12-12 09:47:05 Waiting for postgres to come up...
2024-12-12 09:47:05 /run/postgresql:5432 - no response
2024-12-12 09:47:05 Waiting for postgres to come up...
2024-12-12 09:47:05 Starting postgres...
2024-12-12 09:47:05 Creating nginx configuration
2024-12-12 09:47:05 Enabling UNMS https and wss connections on port 443
2024-12-12 09:47:05 2024-12-11 20:47:05.266 UTC [286] LOG: database system is ready to accept connections
2024-12-12 09:47:06 Error:
2024-12-12 09:47:06 process_not_running
2024-12-12 09:47:06 2024-12-11 20:47:06.697 UTC [504] FATAL: role "root" does not exist
2024-12-12 09:47:06 2024/12/11 20:47:06 [error] 470#470: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:06 2024/12/11 20:47:06 [error] 470#470: *2 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:08 2024/12/11 20:47:08 [error] 470#470: *5 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:08 2024-12-11 20:47:08.192 UTC [613] FATAL: role "root" does not exist
2024-12-12 09:47:08 2024-12-11 20:47:08.194 UTC [612] FATAL: role "root" does not exist
2024-12-12 09:47:08 2024/12/11 20:47:08 [error] 470#470: *7 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:08 2024/12/11 20:47:08 [error] 470#470: *9 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:05 Generating self-signed certificate for 'localhost'.
2024-12-12 09:47:06 Entrypoint finished
2024-12-12 09:47:06 Calling exec
2024-12-12 09:47:06 Waiting for pid file ***@***.***' to appear
2024-12-12 09:47:06 pid is 166
2024-12-12 09:47:06 Waiting for erlang distribution on node ***@***.***' while OS process '166' is running
2024-12-12 09:47:06 /run/postgresql:5432 - accepting connections
2024-12-12 09:47:06 Starting unms-netflow...
2024-12-12 09:47:08 /run/postgresql:5432 - accepting connections
2024-12-12 09:47:08 /run/postgresql:5432 - accepting connections
2024-12-12 09:47:08 /usr/src/ucrm/scripts/init_log.sh
2024-12-12 09:47:08 /usr/src/ucrm/scripts/dirs.sh
2024-12-12 09:47:08 Creating database...
2024-12-12 09:47:08 {"message":"Creating directories.","channel":"dirs.sh","datetime":"2024-12-11T20:47:08+00:00","severity":"INFO","level":200}
2024-12-12 09:47:08 {"message":"Creating /var/log/nginx.","channel":"dirs.sh","datetime":"2024-12-11T20:47:08+00:00","severity":"INFO","level":200}
2024-12-12 09:47:08 {"message":"Creating /run/nginx.","channel":"dirs.sh","datetime":"2024-12-11T20:47:08+00:00","severity":"INFO","level":200}
2024-12-12 09:47:08 {"message":"Creating /etc/nginx/enabled-servers.","channel":"dirs.sh","datetime":"2024-12-11T20:47:08+00:00","severity":"INFO","level":200}
2024-12-12 09:47:08 Migrating database...
2024-12-12 09:47:08 CREATE ROLE
2024-12-12 09:47:08 GRANT
2024-12-12 09:47:08 CREATE ROLE
2024-12-12 09:47:08 GRANT
2024-12-12 09:47:08 ALTER SCHEMA
2024-12-12 09:47:08 CREATE SCHEMA
2024-12-12 09:47:08 CREATE SCHEMA
2024-12-12 09:47:08 ALTER ROLE
2024-12-12 09:47:08 ALTER ROLE
2024-12-12 09:47:08 ALTER SCHEMA
2024-12-12 09:47:08 ALTER SCHEMA
2024-12-12 09:47:08 {"message":"Creating /tmp/plugins.","channel":"dirs.sh","datetime":"2024-12-11T20:47:08+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Listening for netflow packets on port 2055 (8 ms)","time":"2024-12-11T20:47:09.019Z","v":0}
2024-12-12 09:47:09 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Initializing database","time":"2024-12-11T20:47:09.027Z","v":0}
2024-12-12 09:47:09 {"message":"Done creating directories.","channel":"dirs.sh","datetime":"2024-12-11T20:47:08+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 Migrating extensions...
2024-12-12 09:47:09 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":50,"msg":"Failed to get DB schema version: relation \"version\" does not exist","time":"2024-12-11T20:47:09.055Z","v":0}
2024-12-12 09:47:09 Running docker-entrypoint /home/app/unms/index.js
2024-12-12 09:47:09 Sentry release:
2024-12-12 09:47:09
2024-12-12 09:47:09 ## ##
2024-12-12 09:47:09 ## ## RabbitMQ 3.7.14. Copyright (C) 2007-2019 Pivotal Software, Inc.
2024-12-12 09:47:09 ########## Licensed under the MPL. See https://www.rabbitmq.com/
2024-12-12 09:47:09 ###### ##
2024-12-12 09:47:09 ########## Logs: ***@***.***
2024-12-12 09:47:09 ***@***.***_upgrade.log
2024-12-12 09:47:09
2024-12-12 09:47:09 Starting broker...
2024-12-12 09:47:09 {"message":"Creating symbolic links.","channel":"dirs.sh","datetime":"2024-12-11T20:47:09+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 Version: 1.7.5+cb1e737889.2023-03-15T13:23:56+01:00
2024-12-12 09:47:09 Waiting for database containers
2024-12-12 09:47:09 2024-12-11 20:47:09.051 UTC [776] ERROR: relation "version" does not exist at character 21
2024-12-12 09:47:09 2024-12-11 20:47:09.051 UTC [776] STATEMENT: SELECT version FROM version WHERE system = 'unms'
2024-12-12 09:47:09 {"message":"Creating symbolic link for /usr/src/ucrm/app/data.","channel":"dirs.sh","datetime":"2024-12-11T20:47:09+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 {"message":"Creating symbolic link for /usr/src/ucrm/app/EmailQueue.","channel":"dirs.sh","datetime":"2024-12-11T20:47:09+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 {"message":"Creating symbolic link for /usr/src/ucrm/app/logs.","channel":"dirs.sh","datetime":"2024-12-11T20:47:09+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 {"message":"Creating symbolic link for /usr/src/ucrm/web/uploads.","channel":"dirs.sh","datetime":"2024-12-11T20:47:09+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 {"message":"Creating symbolic links for /data/updates.","channel":"dirs.sh","datetime":"2024-12-11T20:47:09+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 {"message":"Publishing current /usr/src/ucrm/app/config/version.yml.","channel":"dirs.sh","datetime":"2024-12-11T20:47:09+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 2024/12/11 20:47:09 [error] 470#470: *11 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:09 {"message":"Done creating symbolic links.","channel":"dirs.sh","datetime":"2024-12-11T20:47:09+00:00","severity":"INFO","level":200}
2024-12-12 09:47:09 /usr/src/ucrm/scripts/parameters.sh
2024-12-12 09:47:09 2024/12/11 20:47:09 [error] 470#470: *12 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:10 2024/12/11 20:47:10 [error] 468#468: *15 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:10 2024/12/11 20:47:10 [error] 468#468: *16 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:10 2024/12/11 20:47:10 [error] 468#468: *17 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:11 2024/12/11 20:47:11 [error] 468#468: *22 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:12 2024/12/11 20:47:12 [error] 468#468: *21 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:12 2024/12/11 20:47:12 [error] 469#469: *25 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:12 2024/12/11 20:47:12 [error] 469#469: *27 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:09 {"message":"Replacing configuration parameters.","channel":"parameters.sh","datetime":"2024-12-11T20:47:09+00:00","severity":"INFO","level":200}
2024-12-12 09:47:12 Restoring backups and/or running migrations
2024-12-12 09:47:12 completed with 0 plugins.
2024-12-12 09:47:13 yarn run v1.22.15
2024-12-12 09:47:13 $ yarn backup:apply && yarn migrate && yarn check-crm-db
2024-12-12 09:47:13 $ node -r ts-node/register/transpile-only ./cli/apply-backup
2024-12-12 09:47:12 2024/12/11 20:47:12 [error] 469#469: *29 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:13 2024/12/11 20:47:13 [error] 469#469: *31 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:13 2024/12/11 20:47:13 [error] 469#469: *32 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:14 2024/12/11 20:47:14 [error] 469#469: *35 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:14 2024/12/11 20:47:14 [error] 469#469: *36 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:14 2024/12/11 20:47:14 [error] 469#469: *37 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:14 2024/12/11 20:47:14 [error] 469#469: *41 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:15 2024/12/11 20:47:15 [error] 469#469: *43 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:15 2024/12/11 20:47:15 [error] 469#469: *45 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:16 2024/12/11 20:47:16 [error] 469#469: *47 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:16 2024/12/11 20:47:16 [error] 469#469: *48 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:16 2024/12/11 20:47:16 [error] 469#469: *49 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:16 2024/12/11 20:47:16 [error] 469#469: *53 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:16 2024/12/11 20:47:16 [error] 469#469: *54 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:16 2024/12/11 20:47:16 [error] 469#469: *57 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:16 2024/12/11 20:47:16 [error] 469#469: *59 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:17 2024/12/11 20:47:17 [error] 469#469: *61 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:17 2024/12/11 20:47:17 [error] 469#469: *62 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:17 2024/12/11 20:47:17 [error] 469#469: *64 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:18 2024/12/11 20:47:18 [error] 469#469: *67 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:19 2024/12/11 20:47:19 [error] 469#469: *69 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:19 2024/12/11 20:47:19 [error] 469#469: *70 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:19 2024/12/11 20:47:19 [error] 469#469: *73 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:19 2024/12/11 20:47:19 [error] 469#469: *75 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:19 2024/12/11 20:47:19 [error] 469#469: *76 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:19 2024/12/11 20:47:19 [error] 469#469: *77 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:20 2024-12-11 20:47:20.233 UTC [957] ERROR: relation "option" does not exist at character 25
2024-12-12 09:47:20 2024-12-11 20:47:20.233 UTC [957] STATEMENT: SELECT code, value FROM option
2024-12-12 09:47:20 2024-12-11 20:47:20.274 UTC [957] ERROR: relation "option" does not exist at character 25
2024-12-12 09:47:20 2024-12-11 20:47:20.274 UTC [957] STATEMENT: SELECT code, value FROM option
2024-12-12 09:47:20 {"message":"Done replacing configuration parameters.","channel":"parameters.sh","datetime":"2024-12-11T20:47:20+00:00","severity":"INFO","level":200}
2024-12-12 09:47:20 /usr/src/ucrm/scripts/cron_jobs_disable.sh
2024-12-12 09:47:20 crontab /tmp/crontabs/server
2024-12-12 09:47:20 su-exec unms /usr/src/ucrm/scripts/database_ready.sh
2024-12-12 09:47:20 {"message":"Waiting for database.","channel":"database_ready.sh","datetime":"2024-12-11T20:47:20+00:00","severity":"INFO","level":200}
2024-12-12 09:47:20 /usr/src/ucrm/scripts/database_ready.sh: line 7: /tmp/UCRM_init.log: Permission denied
2024-12-12 09:47:20 {"message":"Database ready.","channel":"database_ready.sh","datetime":"2024-12-11T20:47:20+00:00","severity":"INFO","level":200}
2024-12-12 09:47:20 su-exec unms /usr/src/ucrm/scripts/database_create_extensions.sh
2024-12-12 09:47:20 {"message":"Creating database extensions.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:20+00:00","severity":"INFO","level":200}
2024-12-12 09:47:20 {"message":"Extension \"citext\" does not exist.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:20+00:00","severity":"INFO","level":200}
2024-12-12 09:47:21 $ node -r ts-node/register/transpile-only ./cli/migrate
2024-12-12 09:47:21 {"message":"Creating \"citext\" extension.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:21+00:00","severity":"INFO","level":200}
2024-12-12 09:47:22 CREATE EXTENSION
2024-12-12 09:47:22 {"message":"Extension \"citext\" exists.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:22+00:00","severity":"INFO","level":200}
2024-12-12 09:47:22 {"message":"Extension \"unaccent\" does not exist.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:22+00:00","severity":"INFO","level":200}
2024-12-12 09:47:20 2024/12/11 20:47:20 [error] 469#469: *81 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:21 2024/12/11 20:47:21 [error] 469#469: *84 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:21 2024/12/11 20:47:21 [error] 469#469: *83 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:21 2024/12/11 20:47:21 [error] 469#469: *85 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:21 2024/12/11 20:47:21 [error] 469#469: *86 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:22 2024/12/11 20:47:22 [error] 469#469: *91 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:22 2024/12/11 20:47:22 [error] 469#469: *93 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:22 2024/12/11 20:47:22 [error] 467#467: *95 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:22 2024/12/11 20:47:22 [error] 467#467: *96 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:22 2024/12/11 20:47:22 [error] 467#467: *97 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:22 2024/12/11 20:47:22 [error] 467#467: *98 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:22 2024/12/11 20:47:22 [error] 467#467: *103 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:23 2024/12/11 20:47:23 [error] 467#467: *105 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:23 2024/12/11 20:47:23 [error] 467#467: *106 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:23 2024/12/11 20:47:23 [error] 467#467: *107 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:23 2024/12/11 20:47:23 [error] 467#467: *108 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:23 {"message":"Creating \"unaccent\" extension.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:23+00:00","severity":"INFO","level":200}
2024-12-12 09:47:23 CREATE EXTENSION
2024-12-12 09:47:23 {"message":"Extension \"unaccent\" exists.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:23+00:00","severity":"INFO","level":200}
2024-12-12 09:47:23 {"message":"Extension \"uuid-ossp\" does not exist.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:23+00:00","severity":"INFO","level":200}
2024-12-12 09:47:23 2024/12/11 20:47:23 [error] 467#467: *113 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:23 2024/12/11 20:47:23 [error] 467#467: *114 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:23 2024/12/11 20:47:23 [error] 467#467: *116 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:23 2024/12/11 20:47:23 [error] 467#467: *115 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:23 2024/12/11 20:47:23 [error] 467#467: *120 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:24 2024/12/11 20:47:24 [error] 467#467: *123 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:24 2024/12/11 20:47:24 [error] 467#467: *124 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:24 2024/12/11 20:47:24 [error] 467#467: *126 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:24 2024/12/11 20:47:24 [error] 467#467: *125 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:24 2024/12/11 20:47:24 [error] 467#467: *128 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:24 {"message":"Creating \"uuid-ossp\" extension.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:24+00:00","severity":"INFO","level":200}
2024-12-12 09:47:24 CREATE EXTENSION
2024-12-12 09:47:24 {"message":"Extension \"uuid-ossp\" exists.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:24+00:00","severity":"INFO","level":200}
2024-12-12 09:47:24 {"message":"Finished creating database extensions.","channel":"database_create_extensions.sh","datetime":"2024-12-11T20:47:24+00:00","severity":"INFO","level":200}
2024-12-12 09:47:24 /usr/src/ucrm/scripts/backup_control_do.sh
2024-12-12 09:47:24 su-exec unms /usr/src/ucrm/scripts/verify_database_migrations_integrity.sh
2024-12-12 09:47:24 {"message":"Verifying database migrations integrity.","channel":"verify_database_migrations_integrity.sh","datetime":"2024-12-11T20:47:24+00:00","severity":"INFO","level":200}
2024-12-12 09:47:24 2024/12/11 20:47:24 [error] 467#467: *132 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:24 2024/12/11 20:47:24 [error] 467#467: *134 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:24 2024/12/11 20:47:24 [error] 469#469: *137 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:24 2024/12/11 20:47:24 [error] 469#469: *138 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:24 2024-12-11 20:47:24.932 UTC [1118] ERROR: relation "option" does not exist at character 25
2024-12-12 09:47:24 2024-12-11 20:47:24.932 UTC [1118] STATEMENT: SELECT code, value FROM option
2024-12-12 09:47:24 2024-12-11 20:47:24.943 UTC [1118] ERROR: relation "option" does not exist at character 25
2024-12-12 09:47:24 2024-12-11 20:47:24.943 UTC [1118] STATEMENT: SELECT code, value FROM option
2024-12-12 09:47:24 2024-12-11 20:47:24.969 UTC [1118] ERROR: relation "_db_version" does not exist at character 21
2024-12-12 09:47:24 2024-12-11 20:47:24.969 UTC [1118] STATEMENT: SELECT version FROM _db_version
2024-12-12 09:47:25 2024/12/11 20:47:25 [error] 469#469: *141 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:25 2024/12/11 20:47:25 [error] 467#467: *142 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:25 2024-12-11 20:47:25.281 UTC [1141] ERROR: relation "option" does not exist at character 25
2024-12-12 09:47:25 2024-12-11 20:47:25.281 UTC [1141] STATEMENT: SELECT code, value FROM option
2024-12-12 09:47:25 2024-12-11 20:47:25.305 UTC [1141] ERROR: relation "option" does not exist at character 25
2024-12-12 09:47:25 2024-12-11 20:47:25.305 UTC [1141] STATEMENT: SELECT code, value FROM option
2024-12-12 09:47:25 2024/12/11 20:47:25 [error] 467#467: *145 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:25 2024-12-11 20:47:25.650 UTC [1161] ERROR: relation "option" does not exist at character 25
2024-12-12 09:47:25 2024-12-11 20:47:25.650 UTC [1161] STATEMENT: SELECT code, value FROM option
2024-12-12 09:47:25 2024-12-11 20:47:25.663 UTC [1161] ERROR: relation "option" does not exist at character 25
2024-12-12 09:47:25 2024-12-11 20:47:25.663 UTC [1161] STATEMENT: SELECT code, value FROM option
2024-12-12 09:47:25 2024/12/11 20:47:25 [error] 467#467: *147 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:25 2024/12/11 20:47:25 [error] 467#467: *148 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:25 {"message":"Database migrations integrity verified.","channel":"verify_database_migrations_integrity.sh","datetime":"2024-12-11T20:47:24+00:00","severity":"INFO","level":200}
2024-12-12 09:47:25 su-exec unms /usr/src/ucrm/scripts/migrate.sh
2024-12-12 09:47:25 {"message":"Start replace shared views.","channel":"migrate.sh","datetime":"2024-12-11T20:47:25+00:00","severity":"INFO","level":200}
2024-12-12 09:47:25 {"message":"Done replace shared views.","channel":"migrate.sh","datetime":"2024-12-11T20:47:25+00:00","severity":"INFO","level":200}
2024-12-12 09:47:25 {"message":"Start database migration.","channel":"migrate.sh","datetime":"2024-12-11T20:47:25+00:00","severity":"INFO","level":200}
2024-12-12 09:47:26 {"name":"UNMS","hostname":"53ded0002d78","pid":1015,"level":30,"msg":"Connected to SiriDB server version: 2.0.45","time":"2024-12-11T20:47:26.391Z","v":0}
2024-12-12 09:47:26 {"name":"UNMS","hostname":"53ded0002d78","pid":1015,"level":30,"msg":"SiriDB database 'unms' does not exists. Creating...","time":"2024-12-11T20:47:26.394Z","v":0}
2024-12-12 09:47:26 [W 2024-12-11 20:47:26] Shards directory not found, creating directory '/config/siridb/unms/shards/'.
2024-12-12 09:47:26 [W 2024-12-11 20:47:26] Tags directory not found, creating directory '/config/siridb/unms/tags/'.
2024-12-12 09:47:26 {"name":"UNMS","hostname":"53ded0002d78","pid":1015,"level":30,"msg":"SiriDB database 'unms_archive' does not exists. Creating...","time":"2024-12-11T20:47:26.398Z","v":0}
2024-12-12 09:47:26 [W 2024-12-11 20:47:26] Shards directory not found, creating directory '/config/siridb/unms_archive/shards/'.
2024-12-12 09:47:26 [W 2024-12-11 20:47:26] Tags directory not found, creating directory '/config/siridb/unms_archive/tags/'.
2024-12-12 09:47:26 {"name":"UNMS","hostname":"53ded0002d78","pid":1015,"level":30,"msg":"Adjusting limits for SiriDB database 'unms'","time":"2024-12-11T20:47:26.400Z","v":0}
2024-12-12 09:47:26 {"name":"UNMS","hostname":"53ded0002d78","pid":1015,"level":30,"msg":"Adjusting limits for SiriDB database 'unms_archive'","time":"2024-12-11T20:47:26.406Z","v":0}
2024-12-12 09:47:26 Extension 'uuid-ossp:1.1 installed.
2024-12-12 09:47:26 Extension 'pgcrypto:1.3 installed.
2024-12-12 09:47:26 Extension 'cube:1.4 installed.
2024-12-12 09:47:26 Extension 'earthdistance:1.1 installed.
2024-12-12 09:47:26 Extension 'unaccent:1.1 installed.
2024-12-12 09:47:26 Extension 'pg_stat_statements:1.8 installed.
2024-12-12 09:47:26 == Initial migration: migrating =======
2024-12-12 09:47:27 == Initial migration: migrated (1.267s)
2024-12-12 09:47:27 == 20201113095804-add-udapi-version (1.4.0): migrating =======
2024-12-12 09:47:27 == 20201113095804-add-udapi-version: migrated (0.016s)
2024-12-12 09:47:27 == 20201118104122-add_table_data_link_statistics (1.4.0): migrating =======
2024-12-12 09:47:27 == 20201118104122-add_table_data_link_statistics: migrated (0.048s)
2024-12-12 09:47:27 == 20201203140108-remove-data-link-statistics-table (1.4.0): migrating =======
2024-12-12 09:47:27 == 20201203140108-remove-data-link-statistics-table: migrated (0.022s)
2024-12-12 09:47:27 == 20210105143421-wireless-antenna-built-in (1.4.0): migrating =======
2024-12-12 09:47:27 == 20210105143421-wireless-antenna-built-in: migrated (0.022s)
2024-12-12 09:47:27 == 20210106144535-add-table-mac_token (1.4.0): migrating =======
2024-12-12 09:47:27 == 20210106144535-add-table-mac_token: migrated (0.026s)
2024-12-12 09:47:27 == 20210118131621-add-bridge-version (1.4.0): migrating =======
2024-12-12 09:47:27 == 20210118131621-add-bridge-version: migrated (0.016s)
2024-12-12 09:47:27 2024/12/11 20:47:27 [error] 467#467: *151 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:27 2024/12/11 20:47:27 [error] 467#467: *153 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:28 == 20210122095039-uisp-interface-id-statistics (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210122095039-uisp-interface-id-statistics: migrated (0.143s)
2024-12-12 09:47:28 == 20210127121849-alter-column-backup-id-device-backup (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210127121849-alter-column-backup-id-device-backup: migrated (0.016s)
2024-12-12 09:47:28 == 20210128154842-add-token-ip (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210128154842-add-token-ip: migrated (0.05s)
2024-12-12 09:47:28 == 20210202091538-wifiman-url (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210202091538-wifiman-url: migrated (0.014s)
2024-12-12 09:47:28 == 20210211145338-device-capabilities-gps (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210211145338-device-capabilities-gps: migrated (0.019s)
2024-12-12 09:47:28 == 20210223135229-stations-mcs-index (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210223135229-stations-mcs-index: migrated (0.023s)
2024-12-12 09:47:28 == 20210322095417-clear-table-config (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210322095417-clear-table-config: migrated (0.027s)
2024-12-12 09:47:28 == 20210419173912-remove-wifiman-enum-type (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210419173912-remove-wifiman-enum-type: migrated (0.023s)
2024-12-12 09:47:28 == 20210421145122-turn-on-new-dashboard (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210421145122-turn-on-new-dashboard: migrated (0.01s)
2024-12-12 09:47:28 == 20210422184346-add-new-poe-enum-values (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210422184346-add-new-poe-enum-values: migrated (0.025s)
2024-12-12 09:47:28 == 20210426132739-add-gw-connectivity-provider (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210426132739-add-gw-connectivity-provider: migrated (0.03s)
2024-12-12 09:47:28 == 20210426154023-add-gateway-stats-table (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210426154023-add-gateway-stats-table: migrated (0.082s)
2024-12-12 09:47:28 == 20210430152248-ensure-gateway-statistics-records (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210430152248-ensure-gateway-statistics-records: migrated (0.022s)
2024-12-12 09:47:28 == 20210506105130-remove-blog (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210506105130-remove-blog: migrated (0.048s)
2024-12-12 09:47:28 == 20210514182449-migrate-outage-stats-to-device-table (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210514182449-migrate-outage-stats-to-device-table: migrated (0.029s)
2024-12-12 09:47:28 == 20210517091457-create-blog-posts (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210517091457-create-blog-posts: migrated (0.096s)
2024-12-12 09:47:28 == 20210524150157-return-outage-score (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210524150157-return-outage-score: migrated (0.04s)
2024-12-12 09:47:28 == 20210526151201-extend-speed-report (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210526151201-extend-speed-report: migrated (0.029s)
2024-12-12 09:47:28 == 20210527102155-add-system-vendor-device (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210527102155-add-system-vendor-device: migrated (0.023s)
2024-12-12 09:47:28 == 20210531150157-add-autoedge-capability (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210531150157-add-autoedge-capability: migrated (0.017s)
2024-12-12 09:47:28 2024/12/11 20:47:28 [error] 467#467: *155 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:28 2024/12/11 20:47:28 [error] 467#467: *156 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:28 == 20210608110329-add-column-firmware-compatibility (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210608110329-add-column-firmware-compatibility: migrated (0.021s)
2024-12-12 09:47:28 == 20210608133002-device-capabilities-support_router (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210608133002-device-capabilities-support_router: migrated (0.009s)
2024-12-12 09:47:28 == 20210716165006-add-uknown-to-site-status-enum (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210716165006-add-uknown-to-site-status-enum: migrated (0.013s)
2024-12-12 09:47:28 == 20210716182402-remove-device-upgrade-preference (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210716182402-remove-device-upgrade-preference: migrated (0.013s)
2024-12-12 09:47:28 == 20210720133711-add-gw-internet-capacity (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210720133711-add-gw-internet-capacity: migrated (0.017s)
2024-12-12 09:47:28 == 20210826234659-stations-airtime (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210826234659-stations-airtime: migrated (0.018s)
2024-12-12 09:47:28 == 20210917103601-ideal-capacity (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210917103601-ideal-capacity: migrated (0.013s)
2024-12-12 09:47:28 == 20210924152801-update-expose-status-values (1.4.0): migrating =======
2024-12-12 09:47:28 == 20210924152801-update-expose-status-values: migrated (0.015s)
2024-12-12 09:47:28 == 20211007184058-site-device-outage-count (1.4.0): migrating =======
2024-12-12 09:47:28 == 20211007184058-site-device-outage-count: migrated (0.014s)
2024-12-12 09:47:28 == 20211022105009-theoretical-total-capacity (1.4.0): migrating =======
2024-12-12 09:47:28 == 20211022105009-theoretical-total-capacity: migrated (0.012s)
2024-12-12 09:47:28 == 20211110150422-add_interface_mss_clamping (1.4.0): migrating =======
2024-12-12 09:47:28 == 20211110150422-add_interface_mss_clamping: migrated (0.009s)
2024-12-12 09:47:28 == 20211117160422-extend-numeric-altitude (1.4.0): migrating =======
2024-12-12 09:47:28 == 20211117160422-extend-numeric-altitude: migrated (0.007s)
2024-12-12 09:47:28 == 20211216114500-add_stp_state (1.4.0): migrating =======
2024-12-12 09:47:28 == 20211216114500-add_stp_state: migrated (0.01s)
2024-12-12 09:47:28 == 20220105105447-add-user-offline-passwords (1.4.0): migrating =======
2024-12-12 09:47:28 2024/12/11 20:47:28 [error] 467#467: *159 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:28 == 20220105105447-add-user-offline-passwords: migrated (0.019s)
2024-12-12 09:47:29 == 20220214113813-migrage-wireless-interfaces-stats (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220214113813-migrage-wireless-interfaces-stats: migrated (0.69s)
2024-12-12 09:47:29 == 20220225092450-add-device-maintenance-enabled (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220225092450-add-device-maintenance-enabled: migrated (0.013s)
2024-12-12 09:47:29 == 20220301130005-add_secondary_ssid_column (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220301130005-add_secondary_ssid_column: migrated (0.011s)
2024-12-12 09:47:29 == 20220304155828-remove_theoretical_max_capacity_columns (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220304155828-remove_theoretical_max_capacity_columns: migrated (0.021s)
2024-12-12 09:47:29 == 20220321122506-add-wave-ai-status-column (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220321122506-add-wave-ai-status-column: migrated (0.016s)
2024-12-12 09:47:29 == 20220322115559-add-mac-override (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220322115559-add-mac-override: migrated (0.014s)
2024-12-12 09:47:29 == 20220324092421-add-expected-signal-and-rate-column (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220324092421-add-expected-signal-and-rate-column: migrated (0.022s)
2024-12-12 09:47:29 == 20220420125428-turn-nosmtp-to-cloudsmtp-on-cloud (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220420125428-turn-nosmtp-to-cloudsmtp-on-cloud: migrated (0.089s)
2024-12-12 09:47:29 == 20220429121400-add_timestamp_to_sla_stats (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220429121400-add_timestamp_to_sla_stats: migrated (0.015s)
2024-12-12 09:47:29 == 20220429140816-fw-batch-upgrade-tasks (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220429140816-fw-batch-upgrade-tasks: migrated (0.053s)
2024-12-12 09:47:29 == 20220503105903-fix-new-ltu-products-model-name (1.4.0): migrating =======
2024-12-12 09:47:29 2024/12/11 20:47:29 [error] 467#467: *161 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:29 == 20220503105903-fix-new-ltu-products-model-name: migrated (0.022s)
2024-12-12 09:47:29 == 20220708132712-device-uptime-statistics-migration (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220708132712-device-uptime-statistics-migration: migrated (0.018s)
2024-12-12 09:47:29 == 20220809095411-change_platform_id_lbe_to_rax (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220809095411-change_platform_id_lbe_to_rax: migrated (0.011s)
2024-12-12 09:47:29 == 20220916115559-new-interface-speeds (1.4.0): migrating =======
2024-12-12 09:47:29 == 20220916115559-new-interface-speeds: migrated (0.019s)
2024-12-12 09:47:29 Migrations finished in 3.585s
2024-12-12 09:47:29 Setting database schema version to 1.7.5
2024-12-12 09:47:29 Done
2024-12-12 09:47:30 $ node -r ts-node/register/transpile-only cli/check-crm-db
2024-12-12 09:47:29 2024/12/11 20:47:29 [error] 467#467: *163 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:30 2024/12/11 20:47:30 [error] 467#467: *165 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:30 2024/12/11 20:47:30 [error] 467#467: *167 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:31 2024/12/11 20:47:31 [error] 467#467: *169 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:31 2024/12/11 20:47:31 [error] 467#467: *171 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:32 2024/12/11 20:47:32 [error] 467#467: *173 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:32 2024/12/11 20:47:32 [error] 467#467: *174 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:32 2024/12/11 20:47:32 [error] 467#467: *175 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:32 2024/12/11 20:47:32 [error] 467#467: *176 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:32 2024/12/11 20:47:32 [error] 469#469: *181 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:33 2024/12/11 20:47:33 [error] 469#469: *183 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:33 2024/12/11 20:47:33 [error] 469#469: *185 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:33 2024/12/11 20:47:33 [error] 469#469: *186 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:33 2024/12/11 20:47:33 [error] 469#469: *187 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:33 2024/12/11 20:47:33 [error] 469#469: *188 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:34 Checking CRM database schema version.
2024-12-12 09:47:34 No data returned from the query.
2024-12-12 09:47:34 Retrying in 10s
2024-12-12 09:47:35 2024/12/11 20:47:35 [error] 469#469: *193 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:35 2024/12/11 20:47:35 [error] 469#469: *194 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:35 2024/12/11 20:47:35 [error] 469#469: *197 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:35 2024/12/11 20:47:35 [error] 469#469: *200 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:35 2024/12/11 20:47:35 [error] 469#469: *199 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:35 2024/12/11 20:47:35 [error] 469#469: *201 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:36 2024/12/11 20:47:36 [error] 469#469: *205 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:36 2024/12/11 20:47:36 [error] 469#469: *206 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:36 2024/12/11 20:47:36 [error] 469#469: *209 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:37 2024/12/11 20:47:37 [error] 469#469: *212 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:37 2024/12/11 20:47:37 [error] 469#469: *211 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:37 2024/12/11 20:47:37 [error] 469#469: *213 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:37 2024/12/11 20:47:37 [error] 469#469: *214 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:37 2024/12/11 20:47:37 [error] 469#469: *219 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:38 2024/12/11 20:47:38 [error] 469#469: *221 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:38 2024/12/11 20:47:38 [error] 469#469: *223 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.10.44"
2024-12-12 09:47:38 2024/12/11 20:47:38 [error] 469#469: *225 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:38 2024/12/11 20:47:38 [error] 469#469: *226 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Database initialized (30058 ms)","time":"2024-12-11T20:47:39.085Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Initializing RabbitMQ","time":"2024-12-11T20:47:39.085Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"RabbitMQ initialized (76 ms)","time":"2024-12-11T20:47:39.161Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Subscribed for managed networks change notifications at queue 'settings.networks.changed'","time":"2024-12-11T20:47:39.185Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Subscribed for managed networks change notifications at queue 'settings.blacklist.changed'","time":"2024-12-11T20:47:39.191Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Subscribed for site IP addresses change notifications at queue 'site.ips.changed'","time":"2024-12-11T20:47:39.196Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Subscribed for device authorizations at queue 'device.*.authorized'","time":"2024-12-11T20:47:39.202Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Subscribed for device authorizations at queue 'device.*.settings.changed'","time":"2024-12-11T20:47:39.206Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Subscribed for settings change notifications at queue 'settings.changed'","time":"2024-12-11T20:47:39.211Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Subscribed for log verbosity change notifications at queue 'server.log.verbosity'","time":"2024-12-11T20:47:39.216Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"There are no managed networks in the database, using default list (3 ms) [ '10.0.0.0/8', '100.64.0.0/10', '172.16.0.0/12', '192.168.0.0/16' ]","time":"2024-12-11T20:47:39.219Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Loaded blacklist from database (2 ms) []","time":"2024-12-11T20:47:39.222Z","v":0}
2024-12-12 09:47:39 {"name":"netflow","hostname":"53ded0002d78","pid":505,"level":30,"msg":"Cannot determine UNMS IP address (2 ms)","time":"2024-12-11T20:47:39.235Z","v":0}
2024-12-12 09:47:39 {"message":"Done database migration.","channel":"migrate.sh","datetime":"2024-12-11T20:47:39+00:00","severity":"INFO","level":200}
2024-12-12 09:47:39 {"message":"Start shared views migration.","channel":"migrate.sh","datetime":"2024-12-11T20:47:39+00:00","severity":"INFO","level":200}
2024-12-12 09:47:39 {"message":"Done shared views migration.","channel":"migrate.sh","datetime":"2024-12-11T20:47:39+00:00","severity":"INFO","level":200}
2024-12-12 09:47:39 {"message":"Start notification templates migration.","channel":"migrate.sh","datetime":"2024-12-11T20:47:39+00:00","severity":"INFO","level":200}
2024-12-12 09:47:40 2024/12/11 20:47:40 [error] 469#469: *229 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:40 {"message":"Done notification templates migration.","channel":"migrate.sh","datetime":"2024-12-11T20:47:40+00:00","severity":"INFO","level":200}
2024-12-12 09:47:40 {"message":"Bumping UNMS version from ENV variable to database.","channel":"migrate.sh","datetime":"2024-12-11T20:47:40+00:00","severity":"INFO","level":200}
2024-12-12 09:47:40 {"message":"Done bumping UNMS version from ENV variable to database.","channel":"migrate.sh","datetime":"2024-12-11T20:47:40+00:00","severity":"INFO","level":200}
2024-12-12 09:47:40 su-exec unms /usr/src/ucrm/scripts/database_migrations_ready.sh
2024-12-12 09:47:40 {"message":"Waiting for migrations.","channel":"database_migrations_ready.sh","datetime":"2024-12-11T20:47:40+00:00","severity":"INFO","level":200}
2024-12-12 09:47:40 /usr/src/ucrm/scripts/database_migrations_ready.sh: line 7: /tmp/UCRM_init.log: Permission denied
2024-12-12 09:47:40 {"message":"Migrations ready.","channel":"database_migrations_ready.sh","datetime":"2024-12-11T20:47:40+00:00","severity":"INFO","level":200}
2024-12-12 09:47:40 /usr/src/ucrm/scripts/web.sh
2024-12-12 09:47:40 {"message":"Preparing server configuration.","channel":"web.sh","datetime":"2024-12-11T20:47:40+00:00","severity":"INFO","level":200}
2024-12-12 09:47:40 cp: cannot stat '/etc/nginx/available-servers/ucrm.conf': No such file or directory
2024-12-12 09:47:40 {"message":"Done preparing server configuration.","channel":"web.sh","datetime":"2024-12-11T20:47:40+00:00","severity":"INFO","level":200}
2024-12-12 09:47:40 {"message":"Updating environment variables.","channel":"web.sh","datetime":"2024-12-11T20:47:40+00:00","severity":"INFO","level":200}
2024-12-12 09:47:40 2024/12/11 20:47:40 [error] 469#469: *231 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:40 2024/12/11 20:47:40 [error] 469#469: *233 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "uisp.valleywireless.nz"
2024-12-12 09:47:41 2024/12/11 20:47:41 [error] 469#469: *235 connect() failed (111: Connection refused) while connecting to upstream, client: 172.17.0.1, server: ,
|
Hi Nico640,
Firstly, thanks for coding and hosting this version of UISP, I run this on a docker container inside Linux and it works wonderfully. However I have 2 issues which I need help with, as I'm not very proficient with Github or Docker commands.
Firstly I would like to upgrade my current container instance of UISP to the latest, as it's very old now. I have tried the pull command but can't seem to get to the next step. I have a persistent volume set up, so could you point me in the right direction with some upgrade commands? I have a fully operational and live WISP network so I can't afford to lose the data from the container.
Secondly I would like to move my UISP persistent volume to a different disk as I'm running out of space. Not specifically your realm as not directly associated with the application but wouldn't mind a suggestion here either!
Many Thanks
The text was updated successfully, but these errors were encountered: