1.3.11 no longer responding to requests. #97

GuruSR · 2023-09-19T03:18:05Z

So I cleaned out docker completely of unms, moved the data for it somewhere else, restarted using everything as basic as possible, with the latest, totally goes nowhere on the Raspberry Pi4B, fails instantly, no log, no folder setup, nothing.

docker run -d --name unms_unms_1 -p 80:80 -p 443:443 -p 2055:2055/udp -v /home/pi/unms/config:/config nico640/docker-unms:latest

It exits before I can docker ps to see if it is running.

Client: Docker Engine - Community
 Version:           19.03.15
 API version:       1.40
 Go version:        go1.13.15
 Git commit:        99e3ed8919
 Built:             Sat Jan 30 03:18:42 2021
 OS/Arch:           linux/arm
 Experimental:      false

Server: Docker Engine - Community
 Engine:
  Version:          19.03.15
  API version:      1.40 (minimum version 1.12)
  Go version:       go1.13.15
  Git commit:       99e3ed8919
  Built:            Sat Jan 30 03:16:47 2021
  OS/Arch:          linux/arm
  Experimental:     false
 containerd:
  Version:          1.4.3
  GitCommit:        269548fa27e0089a8b8278fc4fc781d7f65a939b
 runc:
  Version:          1.0.0-rc92
  GitCommit:        ff819c7e9184c13b7c2607fe6c30ae19403a7aff
 docker-init:
  Version:          0.18.0
  GitCommit:        fec3683

The text was updated successfully, but these errors were encountered:

Nico640 · 2023-10-15T19:44:00Z

Sorry for the late response, can you check if there is anything in the container logs by executing docker logs unms_unms_1?

GuruSR · 2023-10-15T19:58:35Z

A lot of core dumps with 1.4.4, figured I may as well try a newer version if I have to start over. With an empty config folder:

[s6-init] making user provided files available at /var/run/s6/etc...exited 0.
[s6-init] ensuring user provided files have correct perms...exited 0.
[fix-attrs.d] applying ownership & permissions fixes...
[fix-attrs.d] done.
[cont-init.d] executing container initialization scripts...
[cont-init.d] 10-set-timezone: executing... 
[cont-init.d] 10-set-timezone: exited 0.
[cont-init.d] 20-adduser: executing... 

-------------------------------------
GID/UID
-------------------------------------
User uid:    911
User gid:    911
-------------------------------------

[cont-init.d] 20-adduser: exited 0.
[cont-init.d] 30-prepare: executing... 
[cont-init.d] 30-prepare: exited 0.
[cont-init.d] 40-permissions: executing... 
[cont-init.d] 40-permissions: exited 0.
[cont-init.d] 50-postgres: executing... 
The files belonging to this database system will be owned by user "unms".
This user must also own the server process.

The database cluster will be initialized with locales
  COLLATE:  C
  CTYPE:    C.UTF-8
  MESSAGES: C
  MONETARY: C
  NUMERIC:  C
  TIME:     C
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /config/postgres ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... America/New_York
creating configuration files ... ok
running bootstrap script ... ok
sh: locale: not found
1970-05-30 16:11:28.012 EDT [326] WARNING:  no usable system locales were found

I changed the latest to 1.4.4 and the run command to:

docker run -d --name unms_unms_1 -p 8280:8280 -p 443:443 -p 2055:2055/udp -v /home/pi/unms/config:/config -e TZ=America/New_York -e HTTP_PORT=8280 nico640/docker-unms:1.4.4

Just want it back up so I can figure out how to copy one of the backups back in to restore operation from.

GuruSR · 2023-10-15T20:16:42Z

Setting it to latest:

s6-svscan: warning: unable to iopause: Operation not permitted
s6-svscan: warning: executing into .s6-svscan/crash
s6-svscan crashed. Killing everything and exiting.
s6-supervise s6-linux-init-shutdownd: fatal: unable to iopause: Operation not permitted
s6-linux-init-hpr: fatal: unable to reboot(): Operation not permitted

Same docker run as above.

Nico640 · 2023-10-15T20:30:59Z

Hmm, that sounds a lot like the libseccomp issue that occurs with an older libseccomp version (Debian Buster), 32bit ARM and newer Alpine Linux containers which causes these permission issues inside the container. Check if your libseccomp version is below 2.4.2. If it is, you'll need to update it. You can either update libseccomp manually, add buster-backports to your apt sources and update it that way, or update to a newer Raspberry Pi OS (Bullseye or Bookworm) which has a newer libseccomp version.

This is a pretty good explanation of the issue: https://docs.linuxserver.io/faq#libseccomp

GuruSR · 2023-10-15T20:47:38Z

Any idea what version of Docker and 2.3.3-4 of libseccomp2 will work with 1.3.11? I just want to get it back up and running, because upgrading means a complete wipe of the Pi and that is a ton of data and services to go through. Or at least the latest version that'll work with what I have of UNMS fresh that I can pull the backup data from (if I can't, I'll just have to VPN in and redo all of them manually).

Nico640 · 2023-10-15T22:25:44Z

Not sure about the Docker version, but I don't think that the Docker version is the problem. UISP 1.3.11 is the last version that will work with libseccomp2 versions lower than 2.4.2.

By the way, you don't need to get UISP running for the UISP backups.
UISP backups are saved in /config/unms/unms-backups/backups/, just replace /config with the path you specified in the docker run command (e.g. /home/pi/unms/config/unms/unms-backups/backups/)

If you don't want to upgrade libseccomp, UISP 1.3.11 should work with your current Docker / libseccomp version. What happens when you try to run 1.3.11? (nico640/docker-unms:1.3.11) Can you post the docker logs output of 1.3.11 if it doesn't work?

GuruSR · 2023-10-15T23:37:57Z

1.3.11 with an empty config (as if starting brand new) fails miserably:

The below is repeated non-stop.

FATAL:  role "root" does not exist
/tmp:5432 - accepting connections
1001
cut: write error: Broken pipe
Running docker-entrypoint /home/app/unms/index.js
Sentry release: 
Version: 1.3.11+c7edd9600d.2021-07-19T14:45:00+02:00
Waiting for database containers
LOG:  incomplete startup packet
NOTICE:  extension "timescaledb" does not exist, skipping
DROP EXTENSION
Restoring backups and/or running migrations
yarn run v1.22.4
$ yarn backup:apply && yarn migrate && yarn check-crm-db
$ node ./cli/apply-backup.js
$ node ./cli/migrate.js
2023/10/15 19:29:55 [error] 1291#1291: *2155 connect() failed (111: Connection refused) while connecting to upstream, client: 72.38.36.183, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
2023/10/15 19:29:58 [error] 1288#1288: *2157 connect() failed (111: Connection refused) while connecting to upstream, client: 64.228.243.250, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
{"name":"UNMS","hostname":"b400d745767d","pid":13552,"level":30,"msg":"Connected to SiriDB server version: 2.0.44","time":"2023-10-15T23:29:59.021Z","v":0}
{"name":"UNMS","hostname":"b400d745767d","pid":13552,"level":30,"msg":"Adjusting limits for SiriDB database 'unms'","time":"2023-10-15T23:29:59.032Z","v":0}
{"name":"UNMS","hostname":"b400d745767d","pid":13552,"level":30,"msg":"Adjusting limits for SiriDB database 'unms_archive'","time":"2023-10-15T23:29:59.140Z","v":0}
Extension 'uuid-ossp:1.1 installed.
Extension 'pgcrypto:1.3 installed.
Extension 'cube:1.2 installed.
Extension 'earthdistance:1.1 installed.
Extension 'unaccent:1.1 installed.
Migrations finished in 0.467s
Setting database schema version to 1.3.11
Done
$ node cli/check-crm-db.js
Checking CRM database schema version.
CRM database schema version is '1.3.11'.
Done in 12.40s.
Exec /home/app/unms/index.js with memory limit 798
{"message":"Done replacing configuration parameters.","channel":"parameters.sh","datetime":"2023-10-15T19:30:06-04:00","severity":"INFO","level":200}
/usr/src/ucrm/scripts/cron_jobs_disable.sh
crontab /tmp/crontabs/server
su-exec unms /usr/src/ucrm/scripts/database_ready.sh
{"message":"Waiting for database.","channel":"database_ready.sh","datetime":"2023-10-15T19:30:06-04:00","severity":"INFO","level":200}
/usr/src/ucrm/scripts/database_ready.sh: line 7: /tmp/UCRM_init.log: Permission denied
{"message":"Database ready.","channel":"database_ready.sh","datetime":"2023-10-15T19:30:07-04:00","severity":"INFO","level":200}
su-exec unms /usr/src/ucrm/scripts/database_create_extensions.sh
{"name":"UNMS","hostname":"b400d745767d","pid":13475,"level":30,"msg":"Master 13475 is running","time":"2023-10-15T23:30:07.431Z","v":0}
{"message":"Creating database extensions.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:30:07-04:00","severity":"INFO","level":200}
{"message":"Extension \"citext\" exists.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:30:07-04:00","severity":"INFO","level":200}
{"message":"Extension \"unaccent\" exists.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:30:08-04:00","severity":"INFO","level":200}
{"message":"Extension \"uuid-ossp\" exists.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:30:08-04:00","severity":"INFO","level":200}
{"message":"Finished creating database extensions.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:30:08-04:00","severity":"INFO","level":200}
su-exec unms /usr/src/ucrm/scripts/migrate.sh
{"message":"Start replace shared views.","channel":"migrate.sh","datetime":"2023-10-15T19:30:09-04:00","severity":"INFO","level":200}
2023/10/15 19:30:09 [error] 1289#1289: *2159 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.100, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.0.90"
{"message":"Done replace shared views.","channel":"migrate.sh","datetime":"2023-10-15T19:30:10-04:00","severity":"INFO","level":200}
{"message":"Start database migration.","channel":"migrate.sh","datetime":"2023-10-15T19:30:10-04:00","severity":"INFO","level":200}
{"name":"UNMS","hostname":"b400d745767d","pid":13475,"level":30,"msg":"Connected to SiriDB server version: 2.0.44","time":"2023-10-15T23:30:11.006Z","v":0}
{"name":"UNMS","hostname":"b400d745767d","pid":13475,"level":30,"msg":"Adjusting limits for SiriDB database 'unms'","time":"2023-10-15T23:30:11.016Z","v":0}
{"name":"UNMS","hostname":"b400d745767d","pid":13475,"level":30,"msg":"Adjusting limits for SiriDB database 'unms_archive'","time":"2023-10-15T23:30:11.037Z","v":0}
{"name":"UNMS","hostname":"b400d745767d","pid":13475,"level":30,"msg":"Connected to PostgreSQL server version: PostgreSQL 9.6.13 on armv6-alpine-linux-musleabihf, compiled by gcc (Alpine 6.3.0) 6.3.0, 32-bit","time":"2023-10-15T23:30:11.141Z","v":0}
{"name":"UNMS","hostname":"b400d745767d","pid":13475,"level":50,"msg":"19:30:11 error: No data returned from the query.","time":"2023-10-15T23:30:11.165Z","v":0}
19:30:11 error: No data returned from the query.
{"name":"UNMS","hostname":"b400d745767d","pid":13475,"level":50,"msg":"         query: SELECT value FROM crm_db_version_view","time":"2023-10-15T23:30:11.168Z","v":0}
         query: SELECT value FROM crm_db_version_view
QueryResultError {
    code: queryResultErrorCode.noData
    message: "No data returned from the query."
    received: 0
    query: "SELECT value FROM crm_db_version_view"
} Unexpected error in master process
/tmp:5432 - accepting connections

GuruSR · 2023-10-15T23:55:53Z

I tried it again, without creating the config folder itself (rather than it being there and empty), it isn't causing that crash loop, but it is getting nowhere either, it is complaining it can't connect to http://127.0.0.1:8081. I need to move the http to 8280 away from port 80 completely, don't think I am. Not sure where it is finding 8081 from:

[s6-init] making user provided files available at /var/run/s6/etc...exited 0.
[s6-init] ensuring user provided files have correct perms...exited 0.
[fix-attrs.d] applying ownership & permissions fixes...
[fix-attrs.d] done.
[cont-init.d] executing container initialization scripts...
[cont-init.d] 10-adduser: executing... 
usermod: no changes

-------------------------------------
GID/UID
-------------------------------------
User uid:    911
User gid:    911
-------------------------------------

[cont-init.d] 10-adduser: exited 0.
[cont-init.d] 20-set-timezone: executing... 
[cont-init.d] 20-set-timezone: exited 0.
[cont-init.d] 40-prepare: executing... 
[cont-init.d] 40-prepare: exited 0.
[cont-init.d] 50-postgres: executing... 
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locales
  COLLATE:  C
  CTYPE:    C.UTF-8
  MESSAGES: C
  MONETARY: C
  NUMERIC:  C
  TIME:     C
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /config/postgres ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
sh: locale: not found
performing post-bootstrap initialization ... No usable system locales were found.
Use the option "--debug" to see details.
ok
syncing data to disk ... ok

Success.


WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
[cont-init.d] 50-postgres: exited 0.
[cont-init.d] done.
[services.d] starting services
Starting rabbitmq-server...
Starting postgres...
Waiting for rabbitmq to start...
Starting redis...
Starting siridb-server...
Starting nginx...
/tmp:5432 - no response
/tmp:5432 - no response
Waiting for postgres to come up...
Waiting for postgres to come up...
[services.d] done.
392:C 15 Oct 2023 19:44:37.987 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
392:C 15 Oct 2023 19:44:37.987 # Redis version=5.0.13, bits=32, commit=8452d9ff, modified=0, pid=392, just started
392:C 15 Oct 2023 19:44:37.987 # Configuration loaded
392:M 15 Oct 2023 19:44:37.992 # Warning: 32 bit instance detected but no memory limit set. Setting 3 GB maxmemory limit with 'noeviction' policy now.
Running entrypoint.sh
392:M 15 Oct 2023 19:44:37.996 * Running mode=standalone, port=6379.
392:M 15 Oct 2023 19:44:37.997 # Server initialized
392:M 15 Oct 2023 19:44:37.997 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
392:M 15 Oct 2023 19:44:37.997 * Ready to accept connections
Creating user unms with UID 1001
LOG:  could not bind IPv6 socket: Address not available
HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
Creating /www directory
Creating nginx configuration
LOG:  database system was shut down at 2023-10-15 19:44:36 EDT
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
Enabling UNMS https and wss connections on port 443
Generating self-signed certificate for 'localhost'.
FATAL:  role "root" does not exist
/tmp:5432 - accepting connections
1001
FATAL:  role "root" does not exist
/tmp:5432 - accepting connections
1001
/usr/src/ucrm/scripts/init_log.sh
/usr/src/ucrm/scripts/dirs.sh
Creating database...
Migrating database...
{"message":"Creating directories.","channel":"dirs.sh","datetime":"2023-10-15T19:44:39-04:00","severity":"INFO","level":200}
CREATE ROLE
GRANT
CREATE ROLE
GRANT
ALTER SCHEMA
CREATE SCHEMA
CREATE SCHEMA
ALTER ROLE
Waiting for pid file '/var/lib/rabbitmq/mnesia/rabbit@e2a2f02550d5.pid' to appear
ALTER ROLE
pid is 372
Waiting for erlang distribution on node 'rabbit@e2a2f02550d5' while OS process '372' is running
ALTER SCHEMA
{"message":"Creating /var/log/nginx.","channel":"dirs.sh","datetime":"2023-10-15T19:44:40-04:00","severity":"INFO","level":200}
Error:
process_not_running
ALTER SCHEMA
Starting unms-netflow...
Migrating extensions...
cut: write error: Broken pipe
Running docker-entrypoint /home/app/unms/index.js
Sentry release: 
Version: 1.3.11+c7edd9600d.2021-07-19T14:45:00+02:00
Waiting for database containers
LOG:  incomplete startup packet
NOTICE:  extension "timescaledb" does not exist, skipping
DROP EXTENSION
{"message":"Creating /run/nginx.","channel":"dirs.sh","datetime":"2023-10-15T19:44:40-04:00","severity":"INFO","level":200}
{"message":"Creating /etc/nginx/enabled-servers.","channel":"dirs.sh","datetime":"2023-10-15T19:44:41-04:00","severity":"INFO","level":200}
{"message":"Creating /tmp/plugins.","channel":"dirs.sh","datetime":"2023-10-15T19:44:43-04:00","severity":"INFO","level":200}
{"message":"Done creating directories.","channel":"dirs.sh","datetime":"2023-10-15T19:44:43-04:00","severity":"INFO","level":200}
{"message":"Creating symbolic links.","channel":"dirs.sh","datetime":"2023-10-15T19:44:44-04:00","severity":"INFO","level":200}
{"message":"Creating symbolic link for /usr/src/ucrm/app/data.","channel":"dirs.sh","datetime":"2023-10-15T19:44:44-04:00","severity":"INFO","level":200}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Listening for netflow packets on port 2055 (12 ms)","time":"2023-10-15T23:44:44.834Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Initializing database","time":"2023-10-15T23:44:44.842Z","v":0}
ERROR:  relation "version" does not exist at character 21
STATEMENT:  SELECT version FROM version WHERE system = 'unms'
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":50,"msg":"Failed to get DB schema version: relation \"version\" does not exist","time":"2023-10-15T23:44:44.920Z","v":0}
{"message":"Creating symbolic link for /usr/src/ucrm/app/EmailQueue.","channel":"dirs.sh","datetime":"2023-10-15T19:44:45-04:00","severity":"INFO","level":200}
{"message":"Creating symbolic link for /usr/src/ucrm/app/logs.","channel":"dirs.sh","datetime":"2023-10-15T19:44:45-04:00","severity":"INFO","level":200}

  ##  ##
  ##  ##      RabbitMQ 3.7.14. Copyright (C) 2007-2019 Pivotal Software, Inc.
  ##########  Licensed under the MPL.  See https://www.rabbitmq.com/
  ######  ##
  ##########  Logs: /var/log/rabbitmq/rabbit@e2a2f02550d5.log
                    /var/log/rabbitmq/rabbit@e2a2f02550d5_upgrade.log

              Starting broker...
{"message":"Creating symbolic link for /usr/src/ucrm/web/uploads.","channel":"dirs.sh","datetime":"2023-10-15T19:44:45-04:00","severity":"INFO","level":200}
{"message":"Creating symbolic links for /data/updates.","channel":"dirs.sh","datetime":"2023-10-15T19:44:46-04:00","severity":"INFO","level":200}
Failed to generate self-signed certificate for 'localhost'
2023/10/15 19:44:46 [emerg] 1157#1157: open() "/etc/nginx/ip-whitelist.conf" failed (2: No such file or directory) in /etc/nginx/conf.d/unms-https+wss.conf:36
nginx: [emerg] open() "/etc/nginx/ip-whitelist.conf" failed (2: No such file or directory) in /etc/nginx/conf.d/unms-https+wss.conf:36
Starting nginx...
Running entrypoint.sh
Generating self-signed certificate for 'localhost'.
{"message":"Publishing current /usr/src/ucrm/app/config/version.yml.","channel":"dirs.sh","datetime":"2023-10-15T19:44:46-04:00","severity":"INFO","level":200}
{"message":"Done creating symbolic links.","channel":"dirs.sh","datetime":"2023-10-15T19:44:46-04:00","severity":"INFO","level":200}
/usr/src/ucrm/scripts/parameters.sh
{"message":"Replacing configuration parameters.","channel":"parameters.sh","datetime":"2023-10-15T19:44:47-04:00","severity":"INFO","level":200}
Restoring backups and/or running migrations
 completed with 0 plugins.
yarn run v1.22.4
$ yarn backup:apply && yarn migrate && yarn check-crm-db
$ node ./cli/apply-backup.js
Entrypoint finished
Calling exec 
2023/10/15 19:45:00 [alert] 1309#1309: detected a LuaJIT version which is not OpenResty's; many optimizations will be disabled and performance will be compromised (see https://github.com/openresty/luajit2 for OpenResty's LuaJIT or, even better, consider using the OpenResty releases from https://openresty.org/en/download.html)
nginx: [alert] detected a LuaJIT version which is not OpenResty's; many optimizations will be disabled and performance will be compromised (see https://github.com/openresty/luajit2 for OpenResty's LuaJIT or, even better, consider using the OpenResty releases from https://openresty.org/en/download.html)
$ node ./cli/migrate.js
{"name":"UNMS","hostname":"e2a2f02550d5","pid":1318,"level":30,"msg":"Connected to SiriDB server version: 2.0.44","time":"2023-10-15T23:45:03.753Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":1318,"level":30,"msg":"SiriDB database 'unms' does not exists. Creating...","time":"2023-10-15T23:45:03.759Z","v":0}
[W 2023-10-15 23:45:03] Shards directory not found, creating directory '/config/siridb/unms/shards/'.
[W 2023-10-15 23:45:03] Tags directory not found, creating directory '/config/siridb/unms/tags/'.
{"name":"UNMS","hostname":"e2a2f02550d5","pid":1318,"level":30,"msg":"SiriDB database 'unms_archive' does not exists. Creating...","time":"2023-10-15T23:45:03.766Z","v":0}
[W 2023-10-15 23:45:03] Shards directory not found, creating directory '/config/siridb/unms_archive/shards/'.
[W 2023-10-15 23:45:03] Tags directory not found, creating directory '/config/siridb/unms_archive/tags/'.
{"name":"UNMS","hostname":"e2a2f02550d5","pid":1318,"level":30,"msg":"Adjusting limits for SiriDB database 'unms'","time":"2023-10-15T23:45:03.771Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":1318,"level":30,"msg":"Adjusting limits for SiriDB database 'unms_archive'","time":"2023-10-15T23:45:03.790Z","v":0}
Extension 'uuid-ossp:1.1 installed.
Extension 'pgcrypto:1.3 installed.
Extension 'cube:1.2 installed.
Extension 'earthdistance:1.1 installed.
Extension 'unaccent:1.1 installed.
== 20170116111143-init.js (1.0.0): migrating =======
== 20170116111143-init.js: migrated (0.165s)
== 20170130091406-add-log-type.js (1.0.0): migrating =======
== 20170130091406-add-log-type.js: migrated (0.076s)
== 20170201081955-user-login-fail.js (1.0.0): migrating =======
== 20170201081955-user-login-fail.js: migrated (0.011s)
== 20170208134500-import-mongo.js (1.0.0): migrating =======
== 20170208134500-import-mongo.js: migrated (0.007s)
== 20170210131830-add-event-notif-fail.js (1.0.0): migrating =======
== 20170210131830-add-event-notif-fail.js: migrated (0.007s)
== 20170215091017-discovery.js (1.0.0): migrating =======
== 20170215091017-discovery.js: migrated (0.093s)
== 20170221112848-discover-ip-range.js (1.0.0): migrating =======
== 20170221112848-discover-ip-range.js: migrated (0.012s)
== 20170223104646-discover-drop-flags.js (1.0.0): migrating =======
== 20170223104646-discover-drop-flags.js: migrated (0.008s)
== 20170227100522-discovery-connect.js (1.0.0): migrating =======
== 20170227100522-discovery-connect.js: migrated (0.136s)
== 20170302145159-discovery-optimization.js (1.0.0): migrating =======
== 20170302145159-discovery-optimization.js: migrated (0.155s)
== 20170308144649-discovery-csv.js (1.0.0): migrating =======
== 20170308144649-discovery-csv.js: migrated (0.129s)
== 20170411101729-task.js (1.0.0): migrating =======
== 20170411101729-task.js: migrated (0.108s)
== 20170502104724-upgrade-logging.js (1.0.0): migrating =======
== 20170502104724-upgrade-logging.js: migrated (0.822s)
== 20170503083211-mac-aes-key.js (1.0.0): migrating =======
== 20170503083211-mac-aes-key.js: migrated (0.028s)
== 20170511153352-aes-key-update.js (1.0.0): migrating =======
== 20170511153352-aes-key-update.js: migrated (0.041s)
== 20170511160411-discovery.js (1.0.0): migrating =======
== 20170511160411-discovery.js: migrated (0.13s)
== 20170515064532-remove-customSmtpSslEnabled-key.js (1.0.0): migrating =======
== 20170515064532-remove-customSmtpSslEnabled-key.js: migrated (0.029s)
== 20170525124803-discovery-preferences.js (1.0.0): migrating =======
== 20170525124803-discovery-preferences.js: migrated (0.103s)
== 20170526114732-add-table-config-to-user.js (1.0.0): migrating =======
== 20170526114732-add-table-config-to-user.js: migrated (0.037s)
== 20170601112106-cleanup-statistics.js (1.0.0): migrating =======
== 20170601112106-cleanup-statistics.js: migrated (0.035s)
== 20170601112107-fix-statistics.js (1.0.0): migrating =======
== 20170601112107-fix-statistics.js: migrated (0.414s)
== 20170602095030-discovery.js (1.0.0): migrating =======
== 20170602095030-discovery.js: migrated (0.09s)
== 20170602124054-amend-table-config-to-user.js (1.0.0): migrating =======
== 20170602124054-amend-table-config-to-user.js: migrated (0.028s)
== 20170605143239-add-columns-table-editor.js (1.0.0): migrating =======
== 20170605143239-add-columns-table-editor.js: migrated (0.027s)
== 20170612062812-remove-table-config.js (1.0.0): migrating =======
== 20170612062812-remove-table-config.js: migrated (0.027s)
== 20170612100757-add-column-exchange-status-to-mac-aes-key.js (1.0.0): migrating =======
== 20170612100757-add-column-exchange-status-to-mac-aes-key.js: migrated (0.061s)
== 20170619084700-parse-nms-hostmane.js (1.0.0): migrating =======
== 20170619084700-parse-nms-hostmane.js: migrated (0.025s)
== 20170621122610-fix-statistics.js (1.0.0): migrating =======
== 20170621122610-fix-statistics.js: migrated (0.047s)
== 20170703121244-add-device-connection-fail.js (1.0.0): migrating =======
== 20170703121244-add-device-connection-fail.js: migrated (0.014s)
== 20170711115632-add-table-device-metadata.js (1.0.0): migrating =======
== 20170711115632-add-table-device-metadata.js: migrated (0.026s)
== 20170720104423-add_device_restart_timestamp.js (1.0.0): migrating =======
== 20170720104423-add_device_restart_timestamp.js: migrated (0.01s)
== 20170721114414-add-ip-address-table-config.js (1.0.0): migrating =======
== 20170721114414-add-ip-address-table-config.js: migrated (0.058s)
== 20170728132635-add-device-metadata-alias-note.js (1.0.0): migrating =======
== 20170728132635-add-device-metadata-alias-note.js: migrated (0.025s)
== 20170731162544-push-notifications.js (1.0.0): migrating =======
== 20170731162544-push-notifications.js: migrated (0.05s)
== 20170801101309-add-device-metadata-per-device.js (1.0.0): migrating =======
== 20170801101309-add-device-metadata-per-device.js: migrated (0.036s)
== 20170802084022-add-table-data-link.js (1.0.0): migrating =======
== 20170802084022-add-table-data-link.js: migrated (0.05s)
== 20170802115812-add-nms-outages-settings.js (1.0.0): migrating =======
== 20170802115812-add-nms-outages-settings.js: migrated (0.022s)
== 20170811083251-add-locale-to-nms.js (1.0.0): migrating =======
== 20170811083251-add-locale-to-nms.js: migrated (0.022s)
== 20170811121424-fix-google-maps-api-key.js (1.0.0): migrating =======
== 20170811121424-fix-google-maps-api-key.js: migrated (0.022s)
== 20170816105923-add-email-dispatch-fail-type.js (1.0.0): migrating =======
== 20170816105923-add-email-dispatch-fail-type.js: migrated (0.008s)
== 20170821110807-users-to-pgsql.js (1.0.0): migrating =======
== 20170821110807-users-to-pgsql.js: migrated (0.068s)
== 20170821135826-users-to-pgsql-data-migration.js (1.0.0): migrating =======
== 20170821135826-users-to-pgsql-data-migration.js: migrated (0.055s)
ERROR:  relation "option" does not exist at character 25
STATEMENT:  SELECT code, value FROM option
== 20170823103703-clean-non-existent-devices-data.js (1.0.0): migrating =======
ERROR:  relation "option" does not exist at character 25
STATEMENT:  SELECT code, value FROM option
== 20170823103703-clean-non-existent-devices-data.js: migrated (0.188s)
== 20170825083420-remove-allow-self-signed-certificate.js (1.0.0): migrating =======
== 20170825083420-remove-allow-self-signed-certificate.js: migrated (0.024s)
== 20170911190252-clean-device-metadata.js (1.0.0): migrating =======
== 20170911190252-clean-device-metadata.js: migrated (0.042s)
== 20170919153400-remove-ssldomain-key.js (1.0.0): migrating =======
== 20170919153400-remove-ssldomain-key.js: migrated (0.026s)
== 20171002135747-add_mac_aes_key_last_seen.js (1.0.0): migrating =======
== 20171002135747-add_mac_aes_key_last_seen.js: migrated (0.083s)
== 20171006113121-rename-olt-to-onu.js (1.0.0): migrating =======
== 20171006113121-rename-olt-to-onu.js: migrated (0.036s)
== 20171010130055-osm-googlemaps-picker.js (1.0.0): migrating =======
== 20171010130055-osm-googlemaps-picker.js: migrated (0.048s)
== 20171025090132-add_sites_to_pg.js (1.0.0): migrating =======
== 20171025090132-add_sites_to_pg.js: migrated (0.139s)
== 20171030150350-save-aes-key-as-buffer.js (1.0.0): migrating =======
== 20171030150350-save-aes-key-as-buffer.js: migrated (0.015s)
== 20171115114322-add-column-last_news_seen_date-migration.js (1.0.0): migrating =======
== 20171115114322-add-column-last_news_seen_date-migration.js: migrated (0.029s)
== 20171201132836-add-device-site-relation-pg-table.js (1.0.0): migrating =======
== 20171201132836-add-device-site-relation-pg-table.js: migrated (0.03s)
== 20171206133641-add-all-macs-and-all-ips-columns-to-discovery.js (1.0.0): migrating =======
== 20171206133641-add-all-macs-and-all-ips-columns-to-discovery.js: migrated (0.091s)
== 20171208140924-add-unsupported-onu-logtypeenum.js (1.0.0): migrating =======
== 20171208140924-add-unsupported-onu-logtypeenum.js: migrated (0.01s)
== 20171228090149-add-column-uptime-to-discovery-device.js (1.0.0): migrating =======
== 20171228090149-add-column-uptime-to-discovery-device.js: migrated (0.012s)
== 20180207095543-backup-types.js (1.0.0): migrating =======
{"message":"Done replacing configuration parameters.","channel":"parameters.sh","datetime":"2023-10-15T19:45:08-04:00","severity":"INFO","level":200}
/usr/src/ucrm/scripts/cron_jobs_disable.sh
== 20180207095543-backup-types.js: migrated (0.033s)
== 20180216083123-change-ip-column-to-cidr-type.js (1.0.0): migrating =======
crontab /tmp/crontabs/server
su-exec unms /usr/src/ucrm/scripts/database_ready.sh
== 20180216083123-change-ip-column-to-cidr-type.js: migrated (0.034s)
== 20180226075652-change-elevation-type-to-real.js (1.0.0): migrating =======
== 20180226075652-change-elevation-type-to-real.js: migrated (0.008s)
== 20180226121559-change-image-site-relation.js (1.0.0): migrating =======
== 20180226121559-change-image-site-relation.js: migrated (0.013s)
== 20180307174239-device-site.js (1.0.0): migrating =======
== 20180307174239-device-site.js: migrated (0.07s)
== 20180412074751-tasks.js (1.0.0): migrating =======
== 20180412074751-tasks.js: migrated (0.11s)
== 20180418133455-default-auto-profile.js (1.0.0): migrating =======
== 20180418133455-default-auto-profile.js: migrated (0.026s)
== 20180419100346-optimize_indexes.js (1.0.0): migrating =======
== 20180419100346-optimize_indexes.js: migrated (0.048s)
== 20180419125306-add-version-table.js (1.0.0): migrating =======
== 20180419125306-add-version-table.js: migrated (0.026s)
{"message":"Waiting for database.","channel":"database_ready.sh","datetime":"2023-10-15T19:45:08-04:00","severity":"INFO","level":200}
/usr/src/ucrm/scripts/database_ready.sh: line 7: /tmp/UCRM_init.log: Permission denied
== 20180420091917-add-preferences-column.js (1.0.0): migrating =======
== 20180420091917-add-preferences-column.js: migrated (0.032s)
== 20180430132856-sort-tasks-migration.js (1.0.0): migrating =======
== 20180430132856-sort-tasks-migration.js: migrated (0.018s)
== 20180503113907-transmission-profile.js (1.0.0): migrating =======
== 20180503113907-transmission-profile.js: migrated (0.033s)
== 20180516085515-netflow.js (1.0.0): migrating =======
== 20180516085515-netflow.js: migrated (0.092s)
== 20180518101200-subnet.js (1.0.0): migrating =======
== 20180518101200-subnet.js: migrated (0.021s)
== 20180524101200-add-maintenance-mode-flag.js (1.0.0): migrating =======
== 20180524101200-add-maintenance-mode-flag.js: migrated (0.035s)
== 20180615031855-add-client-id-to-netflow.js (1.0.0): migrating =======
== 20180615031855-add-client-id-to-netflow.js: migrated (0.038s)
== 20180622091557-add-default-subnets.js (1.0.0): migrating =======
== 20180622091557-add-default-subnets.js: migrated (0.005s)
== 20180711035336-netflow-source.js (1.0.0): migrating =======
== 20180711035336-netflow-source.js: migrated (0.045s)
{"message":"Database ready.","channel":"database_ready.sh","datetime":"2023-10-15T19:45:08-04:00","severity":"INFO","level":200}
su-exec unms /usr/src/ucrm/scripts/database_create_extensions.sh
== 20180719102211-device-to-pg.js (1.0.0): migrating =======
== 20180719102211-device-to-pg.js: migrated (0.33s)
== 20180719124113-fix-outages-and-logs.js (1.0.0): migrating =======
{"message":"Creating database extensions.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:45:09-04:00","severity":"INFO","level":200}
== 20180719124113-fix-outages-and-logs.js: migrated (0.105s)
== 20180719125936-discovery.js (1.0.0): migrating =======
== 20180719125936-discovery.js: migrated (0.113s)
== 20180719130819-data-links.js (1.0.0): migrating =======
{"message":"Extension \"citext\" does not exist.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:45:09-04:00","severity":"INFO","level":200}
== 20180719130819-data-links.js: migrated (0.215s)
== 20180801063317-blackbox-devices.js (1.0.0): migrating =======
== 20180801063317-blackbox-devices.js: migrated (0.058s)
== 20180806023130-firmware-upgrade.js (1.0.0): migrating =======
== 20180806023130-firmware-upgrade.js: migrated (0.128s)
== 20180806110732-gps-to-decimals.js (1.0.0): migrating =======
== 20180806110732-gps-to-decimals.js: migrated (0.152s)
== 20180814043901-assoc-ups-device-role-to-transmission-freq.js (1.0.0): migrating =======
== 20180814043901-assoc-ups-device-role-to-transmission-freq.js: migrated (0.024s)
== 20180814114335-add-ospf-enabled-prop.js (1.0.0): migrating =======
== 20180814114335-add-ospf-enabled-prop.js: migrated (0.009s)
== 20180824040219-revert-statistics.js (1.0.0): migrating =======
== 20180824040219-revert-statistics.js: migrated (0.012s)
== 20180903110327-fix-statistics.js (1.0.0): migrating =======
== 20180903110327-fix-statistics.js: migrated (0.029s)
== 20180906025618-add_locate_running_column.js (1.0.0): migrating =======
== 20180906025618-add_locate_running_column.js: migrated (0.009s)
== 20180911040425-fix-data-links-view.js (1.0.0): migrating =======
2023/10/15 19:45:10 [error] 1310#1310: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.100, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.0.90"
== 20180911040425-fix-data-links-view.js: migrated (0.187s)
== 20180912024602-interface-name-in-logs.js (1.0.0): migrating =======
== 20180912024602-interface-name-in-logs.js: migrated (0.011s)
== 20180913035909-device-backups.js (1.0.0): migrating =======
== 20180913035909-device-backups.js: migrated (0.015s)
== 20180913104354-add-user-flag-secret-deciphered.js (1.0.0): migrating =======
== 20180913104354-add-user-flag-secret-deciphered.js: migrated (0.044s)
{"message":"Creating \"citext\" extension.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:45:11-04:00","severity":"INFO","level":200}
CREATE EXTENSION
== 20180914013739-fix-airfiber-statistics.js (1.0.0): migrating =======
== 20180914013739-fix-airfiber-statistics.js: migrated (0.876s)
== 20180914062307-disable-letsencrypt-with-custom-cert.js (1.0.0): migrating =======
== 20180914062307-disable-letsencrypt-with-custom-cert.js: migrated (0.057s)
== 20180918095006-vault.js (1.0.0): migrating =======
== 20180918095006-vault.js: migrated (0.064s)
== 20180918101910-interface-addresses-optimization.js (1.0.0): migrating =======
== 20180918101910-interface-addresses-optimization.js: migrated (0.021s)
== 20180918113859-add-ucrm-enabled-settings-option.js (1.0.0): migrating =======
== 20180918113859-add-ucrm-enabled-settings-option.js: migrated (0.025s)
== 20180926011249-rename-airmax-models.js (1.0.0): migrating =======
== 20180926011249-rename-airmax-models.js: migrated (0.011s)
== 20180926024312-add-device-custom-ip-column.js (1.0.0): migrating =======
== 20180926024312-add-device-custom-ip-column.js: migrated (0.012s)
== 20181003100454-link-logs-to-outages.js (1.0.0): migrating =======
== 20181003100454-link-logs-to-outages.js: migrated (0.041s)
== 20181005014504-add-unknown-devices-table.js (1.0.0): migrating =======
== 20181005014504-add-unknown-devices-table.js: migrated (0.042s)
== 20181010010450-rename-onu-models.js (1.0.0): migrating =======
{"message":"Extension \"citext\" exists.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:45:11-04:00","severity":"INFO","level":200}
== 20181010010450-rename-onu-models.js: migrated (0.02s)
== 20181010011238-add-device-column-upgradable.js (1.0.0): migrating =======
== 20181010011238-add-device-column-upgradable.js: migrated (0.069s)
== 20181010093418-delete-unsupported-onu-logs.js (1.0.0): migrating =======
== 20181010093418-delete-unsupported-onu-logs.js: migrated (0.012s)
== 20181010095004-ensure-device-mac-uindex.js (1.0.0): migrating =======
== 20181010095004-ensure-device-mac-uindex.js: migrated (0.02s)
== 20181011083012-data-link-delete-on-interface-delete.js (1.0.0): migrating =======
== 20181011083012-data-link-delete-on-interface-delete.js: migrated (0.052s)
== 20181012040247-add-primary-key-to-netflow-tables.js (1.0.0): migrating =======
== 20181012040247-add-primary-key-to-netflow-tables.js: migrated (0.049s)
== 20181015112659-fix-device-stations.js (1.0.0): migrating =======
== 20181015112659-fix-device-stations.js: migrated (0.043s)
== 20181023105041-add-model-name-for-blackbox.js (1.0.0): migrating =======
== 20181023105041-add-model-name-for-blackbox.js: migrated (0.014s)
{"message":"Extension \"unaccent\" exists.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:45:11-04:00","severity":"INFO","level":200}
== 20181024090000-fix-unms-hostname.js (1.0.0): migrating =======
== 20181024090000-fix-unms-hostname.js: migrated (0.188s)
== 20181024093443-move-settings-to-postgres.js (1.0.0): migrating =======
== 20181024093443-move-settings-to-postgres.js: migrated (0.064s)
== 20181025014303-rename-airfiber-interfaces.js (1.0.0): migrating =======
== 20181025014303-rename-airfiber-interfaces.js: migrated (0.024s)
== 20181025100036-add-role-on-device.js (1.0.0): migrating =======
== 20181025100036-add-role-on-device.js: migrated (0.023s)
== 20181029114755-disable-upgradable-for-blackbox.js (1.0.0): migrating =======
== 20181029114755-disable-upgradable-for-blackbox.js: migrated (0.012s)
== 20181031100554-device-import.js (1.0.0): migrating =======
== 20181031100554-device-import.js: migrated (0.051s)
== 20181105121159-add-session-timeout-column.js (1.0.0): migrating =======
{"message":"Extension \"uuid-ossp\" exists.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:45:12-04:00","severity":"INFO","level":200}
== 20181105121159-add-session-timeout-column.js: migrated (0.272s)
== 20181109111526-fix-data-link-generated-exclude-vlans.js (1.0.0): migrating =======
{"message":"Finished creating database extensions.","channel":"database_create_extensions.sh","datetime":"2023-10-15T19:45:12-04:00","severity":"INFO","level":200}
su-exec unms /usr/src/ucrm/scripts/migrate.sh
== 20181109111526-fix-data-link-generated-exclude-vlans.js: migrated (0.154s)
== 20181112121752-move-clients-from-clients.js (1.0.0): migrating =======
== 20181112121752-move-clients-from-clients.js: migrated (0.009s)
== 20181114010122-add-ucrm-bind-column.js (1.0.0): migrating =======
== 20181114010122-add-ucrm-bind-column.js: migrated (0.007s)
== 20181119090521-add-earthdistance-and-cube-extensions.js (1.0.0): migrating =======
== 20181119090521-add-earthdistance-and-cube-extensions.js: migrated (0.005s)
== 20181119105426-add-site-column-updated-at.js (1.0.0): migrating =======
== 20181119105426-add-site-column-updated-at.js: migrated (0.042s)
== 20181123095816-fix-sfp-vlans.js (1.0.0): migrating =======
== 20181123095816-fix-sfp-vlans.js: migrated (0.014s)
== 20181125074204-rename-discovery-metadata.js (1.0.0): migrating =======
== 20181125074204-rename-discovery-metadata.js: migrated (0.009s)
== 20181126013131-fix-datalink-ordering.js (1.0.0): migrating =======
== 20181126013131-fix-datalink-ordering.js: migrated (0.066s)
== 20181126013558-change-site-height-type.js (1.0.0): migrating =======
== 20181126013558-change-site-height-type.js: migrated (0.041s)
== 20181128123924-change-ucrm-id-column-to-text.js (1.0.0): migrating =======
== 20181128123924-change-ucrm-id-column-to-text.js: migrated (0.047s)
== 20181201102034-add-isp-column.js (1.0.0): migrating =======
== 20181201102034-add-isp-column.js: migrated (0.015s)
== 20181203093924-stations-count-device-statistics.js (1.0.0): migrating =======
== 20181203093924-stations-count-device-statistics.js: migrated (0.009s)
{"message":"Start replace shared views.","channel":"migrate.sh","datetime":"2023-10-15T19:45:12-04:00","severity":"INFO","level":200}
== 20181205115544-set-default-country.js (1.0.0): migrating =======
== 20181205115544-set-default-country.js: migrated (0.043s)
== 20181210114216-add-tokens.js (1.0.0): migrating =======
== 20181210114216-add-tokens.js: migrated (0.041s)
== 20181211084317-add-capacity-statistics.js (1.0.0): migrating =======
== 20181211084317-add-capacity-statistics.js: migrated (0.013s)
== 20181221020829-rename-esx-platform.js (1.0.0): migrating =======
== 20181221020829-rename-esx-platform.js: migrated (0.012s)
== 20181228035214-lldp-datalink-generation.js (1.0.0): migrating =======
== 20181228035214-lldp-datalink-generation.js: migrated (0.175s)
== 20190104095708-add-user-firstname-lastname.js (1.0.0): migrating =======
== 20190104095708-add-user-firstname-lastname.js: migrated (0.015s)
== 20190107050730-fix-firmware-batch-view.js (1.0.0): migrating =======
== 20190107050730-fix-firmware-batch-view.js: migrated (0.021s)
== 20190108105651-add-signal-statistics.js (1.0.0): migrating =======
== 20190108105651-add-signal-statistics.js: migrated (0.011s)
== 20190110010119-add-regulatory-domain-to-site.js (1.0.0): migrating =======
== 20190110010119-add-regulatory-domain-to-site.js: migrated (0.008s)
== 20190114043559-add-table-gateways.js (1.0.0): migrating =======
== 20190114043559-add-table-gateways.js: migrated (0.047s)
== 20190116025542-add-suspend-site-and-site-qos-table.js (1.0.0): migrating =======
== 20190116025542-add-suspend-site-and-site-qos-table.js: migrated (0.049s)
== 20190121032516-add-deleted-sites-table.js (1.0.0): migrating =======
== 20190121032516-add-deleted-sites-table.js: migrated (0.027s)
== 20190124094711-add-ccq-statistics.js (1.0.0): migrating =======
== 20190124094711-add-ccq-statistics.js: migrated (0.01s)
== 20190130153222-cleanup-and-make-constaints-deferrable.js (1.0.0): migrating =======
== 20190130153222-cleanup-and-make-constaints-deferrable.js: migrated (0.035s)
== 20190206120505-add-gateways-alert-flag.js (1.0.0): migrating =======
ERROR:  relation "option" does not exist at character 25
STATEMENT:  SELECT code, value FROM option
ERROR:  relation "option" does not exist at character 25
STATEMENT:  SELECT code, value FROM option
== 20190206120505-add-gateways-alert-flag.js: migrated (0.047s)
== 20190208124423-add-temperature-statistics.js (1.0.0): migrating =======
== 20190208124423-add-temperature-statistics.js: migrated (0.013s)
== 20190213135719-device-import-user-id-null.js (1.0.0): migrating =======
== 20190213135719-device-import-user-id-null.js: migrated (0.01s)
== 20190222110535-remove-presentation-mode.js (1.0.0): migrating =======
== 20190222110535-remove-presentation-mode.js: migrated (0.008s)
== 20190226152346-add-obsolete-gateway-flag.js (1.0.0): migrating =======
== 20190226152346-add-obsolete-gateway-flag.js: migrated (0.012s)
== 20190227144118-create-function-unms-device-status.js (1.0.0): migrating =======
== 20190227144118-create-function-unms-device-status.js: migrated (0.012s)
== 20190306151129-device-station-deleted-at.js (1.0.0): migrating =======
== 20190306151129-device-station-deleted-at.js: migrated (0.017s)
== 20190308164957-add-ucrm-id-column-to-user.js (1.0.0): migrating =======
== 20190308164957-add-ucrm-id-column-to-user.js: migrated (0.016s)
== 20190311120903-add-ucrm-session-id-to-token.js (1.0.0): migrating =======
== 20190311120903-add-ucrm-session-id-to-token.js: migrated (0.008s)
== 20190311170449-convert-tls-if-available-smtp-to-tls.js (1.0.0): migrating =======
== 20190311170449-convert-tls-if-available-smtp-to-tls.js: migrated (0.006s)
== 20190312133325-topology-based-outages.js (1.0.0): migrating =======
== 20190312133325-topology-based-outages.js: migrated (0.05s)
== 20190318180633-generate-internet-datalink-from-gateways.js (1.0.0): migrating =======
== 20190318180633-generate-internet-datalink-from-gateways.js: migrated (0.184s)
== 20190319161220-add-user-column-updated-at.js (1.0.0): migrating =======
{"message":"Done replace shared views.","channel":"migrate.sh","datetime":"2023-10-15T19:45:13-04:00","severity":"INFO","level":200}
== 20190319161220-add-user-column-updated-at.js: migrated (0.051s)
== 20190322101156-add-fw-version-to-backups.js (1.0.0): migrating =======
== 20190322101156-add-fw-version-to-backups.js: migrated (0.008s)
== 20190325121934-fix-topology-based-outages.js (1.0.0): migrating =======
== 20190325121934-fix-topology-based-outages.js: migrated (0.013s)
== 20190327142645-remove-device-import-tables.js (1.0.0): migrating =======
== 20190327142645-remove-device-import-tables.js: migrated (0.029s)
== 20190327163446-add-superadmin-user-role.js (1.0.0): migrating =======
== 20190327163446-add-superadmin-user-role.js: migrated (0.019s)
== 20190403103527-remove-client-zone-home-page.js (1.0.0): migrating =======
== 20190403103527-remove-client-zone-home-page.js: migrated (0.006s)
== 20190403123212-add-outage-grace-period.js (1.0.0): migrating =======
== 20190403123212-add-outage-grace-period.js: migrated (0.016s)
== 20190403134455-per-device-outage-period.js (1.0.0): migrating =======
== 20190403134455-per-device-outage-period.js: migrated (0.013s)
== 20190408104540-add-column-shaping-device.js (1.0.0): migrating =======
== 20190408104540-add-column-shaping-device.js: migrated (0.04s)
== 20190410173944-disable-cloud-smtp.js (1.0.0): migrating =======
== 20190410173944-disable-cloud-smtp.js: migrated (0.006s)
== 20190411173310-add-interface-wireless.js (1.0.0): migrating =======
== 20190411173310-add-interface-wireless.js: migrated (0.018s)
== 20190412142750-add-metadata-to-token.js (1.0.0): migrating =======
== 20190412142750-add-metadata-to-token.js: migrated (0.007s)
== 20190415124502-adjust-table-config.js (1.0.0): migrating =======
== 20190415124502-adjust-table-config.js: migrated (0.009s)
== 20190424154343-remove-cpe-qos-enum-option.js (1.0.0): migrating =======
== 20190424154343-remove-cpe-qos-enum-option.js: migrated (0.011s)
== 20190426123256-log-duplication-index-change.js (1.0.0): migrating =======
== 20190426123256-log-duplication-index-change.js: migrated (0.02s)
== 20190426123257-site-relations-based-on-topology.js (1.0.0): migrating =======
== 20190426123257-site-relations-based-on-topology.js: migrated (0.014s)
== 20190506155915-discover-device-source.js (1.0.0): migrating =======
{"message":"Start database migration.","channel":"migrate.sh","datetime":"2023-10-15T19:45:14-04:00","severity":"INFO","level":200}
== 20190506155915-discover-device-source.js: migrated (0.081s)
== 20190510132730-add-running-battery-statistics.js (1.0.0): migrating =======
== 20190510132730-add-running-battery-statistics.js: migrated (0.011s)
== 20190520110718-add-last-release-notes.js (1.0.0): migrating =======
== 20190520110718-add-last-release-notes.js: migrated (0.008s)
== 20190520125529-change-platformid-to-15-chars.js (1.0.0): migrating =======
== 20190520125529-change-platformid-to-15-chars.js: migrated (0.008s)
== 20190520141811-rename-table-config-columns.js (1.0.0): migrating =======
== 20190520141811-rename-table-config-columns.js: migrated (0.011s)
== 20190522100621-add-battery-statistics.js (1.0.0): migrating =======
== 20190522100621-add-battery-statistics.js: migrated (0.011s)
== 20190523103749-add-stations-column-modulation.js (1.0.0): migrating =======
== 20190523103749-add-stations-column-modulation.js: migrated (0.011s)
== 20190524085449-join-with-ucrm-users.js (1.0.0): migrating =======
== 20190524085449-join-with-ucrm-users.js: migrated (0.092s)
== 20190524162559-rename-power-statistics.js (1.0.0): migrating =======
== 20190524162559-rename-power-statistics.js: migrated (0.038s)
== 20190529095540-add-keep-me-signed-in.js (1.0.0): migrating =======
== 20190529095540-add-keep-me-signed-in.js: migrated (0.045s)
== 20190605103720-site-parent-id-null-on-delete.js (1.0.0): migrating =======
== 20190605103720-site-parent-id-null-on-delete.js: migrated (0.015s)
== 20190606142035-add-connected-at-station.js (1.0.0): migrating =======
== 20190606142035-add-connected-at-station.js: migrated (0.008s)
== 20190606154639-fix-last-seen-release-notes.js (1.0.0): migrating =======
== 20190606154639-fix-last-seen-release-notes.js: migrated (0.008s)
== 20190607140442-extend-username-length.js (1.0.0): migrating =======
== 20190607140442-extend-username-length.js: migrated (0.015s)
== 20190619125310-fix-device-id-constraints.js (1.0.0): migrating =======
== 20190619125310-fix-device-id-constraints.js: migrated (0.092s)
== 20190626131254-change-battery-time.js (1.0.0): migrating =======
== 20190626131254-change-battery-time.js: migrated (0.011s)
== 20190918112627-fix-airgw-firmware.js (1.0.4): migrating =======
== 20190918112627-fix-airgw-firmware.js: migrated (0.015s)
== 20190528131755-add-simulation.js (1.1.0): migrating =======
== 20190528131755-add-simulation.js: migrated (0.061s)
== 20190703134402-allow-shaping-for-gbps.js (1.1.0): migrating =======
ERROR:  relation "option" does not exist at character 25
STATEMENT:  SELECT code, value FROM option
ERROR:  relation "option" does not exist at character 25
STATEMENT:  SELECT code, value FROM option
== 20190703134402-allow-shaping-for-gbps.js: migrated (0.159s)
== 20190709163724-fix-minimum-default-ip-qos.js (1.1.0): migrating =======
== 20190709163724-fix-minimum-default-ip-qos.js: migrated (0.006s)
== 20190717084800-fix-device-ids.js (1.1.0): migrating =======
== 20190717084800-fix-device-ids.js: migrated (0.028s)
== 20190717175222-fix-edgerouter-backups-and-stats.js (1.1.0): migrating =======
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":50,"msg":"Failed to get DB schema version: No data returned from the query.","time":"2023-10-15T23:45:14.950Z","v":0}
== 20190717175222-fix-edgerouter-backups-and-stats.js: migrated (0.042s)
== 20190718000000-alter-running-on-battery.js (1.1.0): migrating =======
== 20190718000000-alter-running-on-battery.js: migrated (0.012s)
== 20190718010000-unifi-interface-speed-format.js (1.1.0): migrating =======
== 20190718010000-unifi-interface-speed-format.js: migrated (0.01s)
== 20190718020000-extend-interface-wireless-state.js (1.1.0): migrating =======
== 20190718020000-extend-interface-wireless-state.js: migrated (0.013s)
== 20190718030000-add-device-started.js (1.1.0): migrating =======
== 20190718030000-add-device-started.js: migrated (0.007s)
== 20190718040000-add-note-pinned-device-backup.js (1.1.0): migrating =======
== 20190718040000-add-note-pinned-device-backup.js: migrated (0.036s)
== 20190718050000-set-autobackups-true.js (1.1.0): migrating =======
== 20190718050000-set-autobackups-true.js: migrated (0.024s)
== 20190718060000-allow-sso-login.js (1.1.0): migrating =======
== 20190718060000-allow-sso-login.js: migrated (0.035s)
== 20190718161508-change-primary-key-neighbors.js (1.1.0): migrating =======
== 20190718161508-change-primary-key-neighbors.js: migrated (0.027s)
== 20190802072429-change_crated_at_to_updated_at.js (1.1.0): migrating =======
== 20190802072429-change_crated_at_to_updated_at.js: migrated (0.017s)
== 20190802080602-discovery-distributed.js (1.1.0): migrating =======
== 20190802080602-discovery-distributed.js: migrated (0.219s)
== 20190815121645-blog-posts.js (1.1.0): migrating =======
== 20190815121645-blog-posts.js: migrated (0.055s)
== 20190826163335-discovery-buffer.js (1.1.0): migrating =======
== 20190826163335-discovery-buffer.js: migrated (0.029s)
== 20190827102501-add-hash-to-firmware.js (1.1.0): migrating =======
== 20190827102501-add-hash-to-firmware.js: migrated (0.011s)
== 20190828131950-maintenance-window.js (1.1.0): migrating =======
== 20190828131950-maintenance-window.js: migrated (0.068s)
== 20190830165111-add-unms-host.js (1.1.0): migrating =======
== 20190830165111-add-unms-host.js: migrated (0.009s)
== 20190916131451-connection-timeout-discovery-status.js (1.1.0): migrating =======
== 20190916131451-connection-timeout-discovery-status.js: migrated (0.008s)
== 20190919183205-discovery-interface-type.js (1.1.0): migrating =======
== 20190919183205-discovery-interface-type.js: migrated (0.068s)
== 20190923134947-processing-discovery-status-enum.js (1.1.0): migrating =======
2023/10/15 19:45:15 [error] 1310#1310: *3 connect() failed (111: Connection refused) while connecting to upstream, client: 72.38.36.183, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
== 20190923134947-processing-discovery-status-enum.js: migrated (0.016s)
== 20191008105008-guess-subnet-ranges.js (1.1.0): migrating =======
== 20191008105008-guess-subnet-ranges.js: migrated (0.015s)
== 20191009095535-remove-huge-public-ranges.js (1.1.0): migrating =======
== 20191009095535-remove-huge-public-ranges.js: migrated (0.016s)
== 20191015131642-remove-column-new-firmware-id-in-firmware-upgrade.js (1.1.0): migrating =======
== 20191015131642-remove-column-new-firmware-id-in-firmware-upgrade.js: migrated (0.017s)
== 20191022161003-fix-credentials-primary-key.js (1.1.0): migrating =======
== 20191022161003-fix-credentials-primary-key.js: migrated (0.024s)
== 20191025080421-link-score.js (1.1.0): migrating =======
== 20191025080421-link-score.js: migrated (0.015s)
== 20191025130412-add-station-id.js (1.1.0): migrating =======
== 20191025130412-add-station-id.js: migrated (0.059s)
== 20191031153853-discovery-settings.js (1.1.0): migrating =======
== 20191031153853-discovery-settings.js: migrated (0.019s)
== 20191106165941-remove-nms-summary-view.js (1.1.0): migrating =======
== 20191106165941-remove-nms-summary-view.js: migrated (0.006s)
== 20191107170856-aes-key-expiration.js (1.1.0): migrating =======
== 20191107170856-aes-key-expiration.js: migrated (0.018s)
== 20191113131802-join-ucrm-and-isp-mode.js (1.1.0): migrating =======
== 20191113131802-join-ucrm-and-isp-mode.js: migrated (0.022s)
== 20191113152934-optimize-indexes.js (1.1.0): migrating =======
== 20191113152934-optimize-indexes.js: migrated (0.03s)
== 20191115100643-change-statistics-wifi-to-wlan.js (1.1.0): migrating =======
== 20191115100643-change-statistics-wifi-to-wlan.js: migrated (0.036s)
== 20191115100643-change-wifi-to-wlan.js (1.1.0): migrating =======
== 20191115100643-change-wifi-to-wlan.js: migrated (0.116s)
== 20191118102412-rename-setting-trafficShapingAdjustement.js (1.1.0): migrating =======
== 20191118102412-rename-setting-trafficShapingAdjustement.js: migrated (0.011s)
== 20191120152011-set-default-ping-address-mode.js (1.1.0): migrating =======
== 20191120152011-set-default-ping-address-mode.js: migrated (0.012s)
== 20191121100300-add-user-column-map-config.js (1.1.0): migrating =======
== 20191121100300-add-user-column-map-config.js: migrated (0.056s)
== 20191121112032-add-blacklist-table.js (1.1.0): migrating =======
== 20191121112032-add-blacklist-table.js: migrated (0.029s)
== 20191122120512-add-column-theoretical-uplink.js (1.1.0): migrating =======
== 20191122120512-add-column-theoretical-uplink.js: migrated (0.008s)
== 20191125111638-fix-antenna-records.js (1.1.0): migrating =======
== 20191125111638-fix-antenna-records.js: migrated (0.009s)
== 20191126075837-add-column-theoretical-downlink.js (1.1.0): migrating =======
== 20191126075837-add-column-theoretical-downlink.js: migrated (0.01s)
== 20191128111618-add_60g_statistics.js (1.1.0): migrating =======
== 20191128111618-add_60g_statistics.js: migrated (0.012s)
== 20191205145841-add-gateway-created-at.js (1.1.0): migrating =======
== 20191205145841-add-gateway-created-at.js: migrated (0.049s)
== 20191205204117-fix-duplicate-stations.js (1.1.0): migrating =======
== 20191205204117-fix-duplicate-stations.js: migrated (0.008s)
== 20191206160430-unset-ucrm-id-for-regular-sites.js (1.1.0): migrating =======
== 20191206160430-unset-ucrm-id-for-regular-sites.js: migrated (0.011s)
== 20191217102807-remove-invalid-neighbors.js (1.1.2): migrating =======
== 20191217102807-remove-invalid-neighbors.js: migrated (0.008s)
== 20200121103545-add-questionare-table.js (1.1.4): migrating =======
== 20200121103545-add-questionare-table.js: migrated (0.047s)
== 20200130081926-set-install-time-if-missing.js (1.1.5): migrating =======
== 20200130081926-set-install-time-if-missing.js: migrated (0.011s)
== 20191204140611-interface-macs.js (1.2.0): migrating =======
== 20191204140611-interface-macs.js: migrated (0.036s)
== 20191216121122-add-frequency-60g.js (1.2.0): migrating =======
== 20191216121122-add-frequency-60g.js: migrated (0.009s)
== 20191217134129-add-gateway-overload-traffic-shaping.js (1.2.0): migrating =======
== 20191217134129-add-gateway-overload-traffic-shaping.js: migrated (0.011s)
== 20200113083030-set-default-site-height.js (1.2.0): migrating =======
== 20200113083030-set-default-site-height.js: migrated (0.009s)
== 20200131170234-permanent-logs.js (1.2.0): migrating =======
== 20200131170234-permanent-logs.js: migrated (0.069s)
== 20200207110823-rename-sso-token-info-to-data.js (1.2.0): migrating =======
== 20200207110823-rename-sso-token-info-to-data.js: migrated (0.013s)
== 20200207141613-alter-type-devicepsustatistics.js (1.2.0): migrating =======
== 20200207141613-alter-type-devicepsustatistics.js: migrated (0.012s)
== 20200212142732-theoretical-max-signal.js (1.2.0): migrating =======
== 20200212142732-theoretical-max-signal.js: migrated (0.01s)
== 20200213081223-sorting-dim.js (1.2.0): migrating =======
== 20200213081223-sorting-dim.js: migrated (0.009s)
== 20200218174550-add-poe-and-speed-values.js (1.2.0): migrating =======
== 20200218174550-add-poe-and-speed-values.js: migrated (0.021s)
== 20200225110745-add-interface-lag-ports.js (1.2.0): migrating =======
== 20200225110745-add-interface-lag-ports.js: migrated (0.009s)
== 20200226104507-ptp-installer.js (1.2.0): migrating =======
== 20200226104507-ptp-installer.js: migrated (0.125s)
== 20200303104930-remove-frequency-60g.js (1.2.0): migrating =======
== 20200303104930-remove-frequency-60g.js: migrated (0.081s)
== 20200305101716-ptp-installer-installations.js (1.2.0): migrating =======
== 20200305101716-ptp-installer-installations.js: migrated (0.084s)
== 20200305114230-add-chain-values-to-station.js (1.2.0): migrating =======
== 20200305114230-add-chain-values-to-station.js: migrated (0.014s)
== 20200309142006-add-link-score-column.js (1.2.0): migrating =======
== 20200309142006-add-link-score-column.js: migrated (0.013s)
== 20200317191846-add-pppoe-address-columns.js (1.2.0): migrating =======
== 20200317191846-add-pppoe-address-columns.js: migrated (0.014s)
== 20200320093024-new-user-roles.js (1.2.0): migrating =======
== 20200320093024-new-user-roles.js: migrated (0.12s)
== 20200401123351-add-model.js (1.2.0): migrating =======
== 20200401123351-add-model.js: migrated (0.008s)
== 20200401181646-add-interface-wireless-columns.js (1.2.0): migrating =======
== 20200401181646-add-interface-wireless-columns.js: migrated (0.015s)
== 20200408155843-change-frequency-band-format-add-country.js (1.2.0): migrating =======
== 20200408155843-change-frequency-band-format-add-country.js: migrated (0.07s)
== 20200414173310-add-pk-to-subnet.js (1.2.0): migrating =======
== 20200414173310-add-pk-to-subnet.js: migrated (0.021s)
== 20200415103358-add-noise-floor.js (1.2.0): migrating =======
== 20200415103358-add-noise-floor.js: migrated (0.014s)
== 20200417102135-wlan-active-interface-on-device.js (1.2.0): migrating =======
== 20200417102135-wlan-active-interface-on-device.js: migrated (0.01s)
== 20200420111851-bigint-for-station-capacity.js (1.2.0): migrating =======
== 20200420111851-bigint-for-station-capacity.js: migrated (0.049s)
== 20200423135420-remove-data-noisefloor.js (1.2.0): migrating =======
== 20200423135420-remove-data-noisefloor.js: migrated (0.01s)
== 20200423161708-prune-stations-on-60g-ubond-interface.js (1.2.0): migrating =======
== 20200423161708-prune-stations-on-60g-ubond-interface.js: migrated (0.009s)
== 20200504134944-add-port-columns.js (1.2.0): migrating =======
== 20200504134944-add-port-columns.js: migrated (0.016s)
== 20200430100255-channel-width-frequency.js (1.2.1): migrating =======
== 20200430100255-channel-width-frequency.js: migrated (0.009s)
== 20200504090352-wireless_antenna_name.js (1.2.1): migrating =======
== 20200504090352-wireless_antenna_name.js: migrated (0.014s)
== 20200511132430-cable_length.js (1.2.1): migrating =======
== 20200511132430-cable_length.js: migrated (0.008s)
== 20200520121508-change-uptime-to-bigint.js (1.2.1): migrating =======
== 20200520121508-change-uptime-to-bigint.js: migrated (0.124s)
== 20200528084758-add-es-capabilities-poe-statistics-and-lag.js (1.2.5): migrating =======
== 20200528084758-add-es-capabilities-poe-statistics-and-lag.js: migrated (0.021s)
== 20200608110213-rx_tx_bytes_frequency_center.js (1.2.5): migrating =======
== 20200608110213-rx_tx_bytes_frequency_center.js: migrated (0.012s)
== 20200611095725-unmss-speed-limit.js (1.2.5): migrating =======
== 20200611095725-unmss-speed-limit.js: migrated (0.011s)
== 20200615103433-link-quality.js (1.2.5): migrating =======
== 20200615103433-link-quality.js: migrated (0.034s)
== 20200702100248-udapi-link-score.js (1.2.5): migrating =======
== 20200702100248-udapi-link-score.js: migrated (0.014s)
== 20200703091532-table-config-column-widths.js (1.2.5): migrating =======
== 20200703091532-table-config-column-widths.js: migrated (0.008s)
== 20200716133613-remote-lldp-from-wlan-interfaces.js (1.2.6): migrating =======
== 20200716133613-remote-lldp-from-wlan-interfaces.js: migrated (0.009s)
== 20200727081428-move-columns-udapi-link.js (1.2.7): migrating =======
== 20200727081428-move-columns-udapi-link.js: migrated (0.017s)
== 20200602131115-remove-is-discovery-first-time.js (1.3.0): migrating =======
== 20200602131115-remove-is-discovery-first-time.js: migrated (0.007s)
== 20200604102757-add-location-columns.js (1.3.0): migrating =======
== 20200604102757-add-location-columns.js: migrated (0.014s)
== 20200604121502-wireless_authentication_ssid.js (1.3.0): migrating =======
== 20200604121502-wireless_authentication_ssid.js: migrated (0.011s)
== 20200610121306-set-firmware-to-not-null.js (1.3.0): migrating =======
== 20200610121306-set-firmware-to-not-null.js: migrated (0.02s)
== 20200622121922-interfaces-wireless-add-dlratio.js (1.3.0): migrating =======
== 20200622121922-interfaces-wireless-add-dlratio.js: migrated (0.008s)
== 20200625142201-device-shapping.js (1.3.0): migrating =======
== 20200625142201-device-shapping.js: migrated (0.692s)
== 20200702133525-ospf-auth-keys-md5.js (1.3.0): migrating =======
== 20200702133525-ospf-auth-keys-md5.js: migrated (0.029s)
== 20200703150807-cloud-vault-key.js (1.3.0): migrating =======
== 20200703150807-cloud-vault-key.js: migrated (0.016s)
== 20200710105255-interfaces-wireless-add-wireless-stations-count.js (1.3.0): migrating =======
== 20200710105255-interfaces-wireless-add-wireless-stations-count.js: migrated (0.007s)
== 20200714092107-interfaces-wireless-wds.js (1.3.0): migrating =======
== 20200714092107-interfaces-wireless-wds.js: migrated (0.012s)
== 20200729135128-last_ip_accounting.js (1.3.0): migrating =======
2023/10/15 19:45:18 [error] 1311#1311: *5 connect() failed (111: Connection refused) while connecting to upstream, client: 64.228.243.250, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
== 20200729135128-last_ip_accounting.js: migrated (0.036s)
== 20200817124343-add-interface-enums.js (1.3.0): migrating =======
== 20200817124343-add-interface-enums.js: migrated (0.016s)
== 20200819082338-change-design-network-score.js (1.3.0): migrating =======
== 20200819082338-change-design-network-score.js: migrated (0.02s)
== 20200820111725-add-sla-stats.js (1.3.0): migrating =======
== 20200820111725-add-sla-stats.js: migrated (0.028s)
== 20200827161224-add-sso-id-to-user.js (1.3.0): migrating =======
== 20200827161224-add-sso-id-to-user.js: migrated (0.023s)
== 20200831134549-add-device-weak-capacity.js (1.3.0): migrating =======
== 20200831134549-add-device-weak-capacity.js: migrated (0.084s)
== 20200901162130-wifi-man.js (1.3.0): migrating =======
== 20200901162130-wifi-man.js: migrated (0.033s)
== 20200902141240-mark-q1-as-answered.js (1.3.0): migrating =======
== 20200902141240-mark-q1-as-answered.js: migrated (0.008s)
== 20200902145139-fix-site-group-id.js (1.3.0): migrating =======
== 20200902145139-fix-site-group-id.js: migrated (0.013s)
== 20200908153047-setting-setup-mark-answered-for-old.js (1.3.0): migrating =======
== 20200908153047-setting-setup-mark-answered-for-old.js: migrated (0.009s)
== 20200914104927-add-user-image-url.js (1.3.0): migrating =======
== 20200914104927-add-user-image-url.js: migrated (0.012s)
== 20200915094642-fix-int-overflow.js (1.3.0): migrating =======
== 20200915094642-fix-int-overflow.js: migrated (0.033s)
== 20200917092857-fix-location-columns.js (1.3.0): migrating =======
== 20200917092857-fix-location-columns.js: migrated (0.077s)
== 20200925163110-rename-unmsr-to-uispr.js (1.3.0): migrating =======
== 20200925163110-rename-unmsr-to-uispr.js: migrated (0.014s)
== 20200925163115-move-distance-column.js (1.3.0): migrating =======
== 20200925163115-move-distance-column.js: migrated (0.009s)
== 20201005101858-rename-uispr-firmware-files.js (1.3.0): migrating =======
== 20201005101858-rename-uispr-firmware-files.js: migrated (0.007s)
== 20201005104106-make-statistics-unlogged.js (1.3.0): migrating =======
== 20201005104106-make-statistics-unlogged.js: migrated (0.299s)
== 20201006125331-rx-cinr.js (1.3.0): migrating =======
== 20201006125331-rx-cinr.js: migrated (0.014s)
== 20201007121232-add-psu-type-enum.js (1.3.0): migrating =======
== 20201007121232-add-psu-type-enum.js: migrated (0.008s)
== 20201007155053-redis-to-siridb.js (1.3.0): migrating =======
== 20201007155053-redis-to-siridb.js: migrated (0.045s)
== 20201016160608-add-device-outage-score.js (1.3.0): migrating =======
== 20201016160608-add-device-outage-score.js: migrated (0.085s)
== 20201023172010-add-site-distance-and-utilization.js (1.3.0): migrating =======
== 20201023172010-add-site-distance-and-utilization.js: migrated (0.009s)
== 20201030111851-flush-redis.js (1.3.0): migrating =======
== 20201030111851-flush-redis.js: migrated (0.023s)
== 20201110083051-add-psu-charging-and-max-power.js (1.3.0): migrating =======
== 20201110083051-add-psu-charging-and-max-power.js: migrated (0.022s)
== 20210216154322-add-autoedge-capability.js (1.3.0): migrating =======
== 20210216154322-add-autoedge-capability.js: migrated (0.01s)
Migrations finished in 15.589s
Setting database schema version to 1.3.11
Done
$ node cli/check-crm-db.js
Checking CRM database schema version.
No data returned from the query.
Retrying in 10s
2023/10/15 19:45:29 [error] 1310#1310: *7 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.100, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.0.90"
Checking CRM database schema version.
No data returned from the query.
Retrying in 10s
2023/10/15 19:45:35 [error] 1310#1310: *9 connect() failed (111: Connection refused) while connecting to upstream, client: 72.38.36.183, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
2023/10/15 19:45:39 [error] 1310#1310: *11 connect() failed (111: Connection refused) while connecting to upstream, client: 64.228.243.250, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
Checking CRM database schema version.
No data returned from the query.
Retrying in 10s
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Database initialized (60125 ms)","time":"2023-10-15T23:45:44.967Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Initializing RabbitMQ","time":"2023-10-15T23:45:44.968Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"RabbitMQ initialized (100 ms)","time":"2023-10-15T23:45:45.068Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Subscribed for managed networks change notifications at queue 'settings.networks.changed'","time":"2023-10-15T23:45:45.138Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Subscribed for managed networks change notifications at queue 'settings.blacklist.changed'","time":"2023-10-15T23:45:45.154Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Subscribed for site IP addresses change notifications at queue 'site.ips.changed'","time":"2023-10-15T23:45:45.170Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Subscribed for device authorizations at queue 'device.*.authorized'","time":"2023-10-15T23:45:45.187Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Subscribed for device authorizations at queue 'device.*.settings.changed'","time":"2023-10-15T23:45:45.207Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Subscribed for settings change notifications at queue 'settings.changed'","time":"2023-10-15T23:45:45.225Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Subscribed for log verbosity change notifications at queue 'server.log.verbosity'","time":"2023-10-15T23:45:45.239Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"There are no managed networks in the database, using default list (8 ms) [ '10.0.0.0/8', '100.64.0.0/10', '172.16.0.0/12', '192.168.0.0/16' ]","time":"2023-10-15T23:45:45.249Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Loaded blacklist from database (3 ms) []","time":"2023-10-15T23:45:45.255Z","v":0}
{"name":"netflow","hostname":"e2a2f02550d5","pid":793,"level":30,"msg":"Cannot determine UNMS IP address (5 ms)","time":"2023-10-15T23:45:45.276Z","v":0}
2023/10/15 19:45:49 [error] 1310#1310: *13 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.100, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.0.90"
Checking CRM database schema version.
No data returned from the query.
Retrying in 10s
{"message":"Done database migration.","channel":"migrate.sh","datetime":"2023-10-15T19:45:54-04:00","severity":"INFO","level":200}
{"message":"Start shared views migration.","channel":"migrate.sh","datetime":"2023-10-15T19:45:54-04:00","severity":"INFO","level":200}
2023/10/15 19:45:55 [error] 1311#1311: *15 connect() failed (111: Connection refused) while connecting to upstream, client: 72.38.36.183, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
{"message":"Done shared views migration.","channel":"migrate.sh","datetime":"2023-10-15T19:45:55-04:00","severity":"INFO","level":200}
{"message":"Start notification templates migration.","channel":"migrate.sh","datetime":"2023-10-15T19:45:55-04:00","severity":"INFO","level":200}
{"message":"Done notification templates migration.","channel":"migrate.sh","datetime":"2023-10-15T19:45:56-04:00","severity":"INFO","level":200}
{"message":"Bumping UNMS version from ENV variable to database.","channel":"migrate.sh","datetime":"2023-10-15T19:45:57-04:00","severity":"INFO","level":200}
{"message":"Done bumping UNMS version from ENV variable to database.","channel":"migrate.sh","datetime":"2023-10-15T19:45:58-04:00","severity":"INFO","level":200}
su-exec unms /usr/src/ucrm/scripts/database_migrations_ready.sh
2023/10/15 19:45:58 [error] 1311#1311: *17 connect() failed (111: Connection refused) while connecting to upstream, client: 64.228.243.250, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
{"message":"Waiting for migrations.","channel":"database_migrations_ready.sh","datetime":"2023-10-15T19:45:58-04:00","severity":"INFO","level":200}
/usr/src/ucrm/scripts/database_migrations_ready.sh: line 7: /tmp/UCRM_init.log: Permission denied
{"message":"Migrations ready.","channel":"database_migrations_ready.sh","datetime":"2023-10-15T19:45:58-04:00","severity":"INFO","level":200}
/usr/src/ucrm/scripts/web.sh
{"message":"Preparing server configuration.","channel":"web.sh","datetime":"2023-10-15T19:45:59-04:00","severity":"INFO","level":200}
cp: cannot stat '/etc/nginx/available-servers/ucrm.conf': No such file or directory
{"message":"Done preparing server configuration.","channel":"web.sh","datetime":"2023-10-15T19:45:59-04:00","severity":"INFO","level":200}
{"message":"Updating environment variables.","channel":"web.sh","datetime":"2023-10-15T19:45:59-04:00","severity":"INFO","level":200}
{"message":"Done updating environment variables.","channel":"web.sh","datetime":"2023-10-15T19:46:00-04:00","severity":"INFO","level":200}
{"message":"Updating UCRM version.","channel":"web.sh","datetime":"2023-10-15T19:46:00-04:00","severity":"INFO","level":200}
{"message":"Done UCRM version.","channel":"web.sh","datetime":"2023-10-15T19:46:01-04:00","severity":"INFO","level":200}
Setting up the Rabbit MQ fabric
Checking CRM database schema version.
CRM database schema version is '1.3.11'.
Done in 69.32s.
Exec /home/app/unms/index.js with memory limit 798
{"message":"Building search index.","channel":"web.sh","datetime":"2023-10-15T19:46:04-04:00","severity":"INFO","level":200}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":825,"level":30,"msg":"Master 825 is running","time":"2023-10-15T23:46:07.827Z","v":0}
2023/10/15 19:46:09 [error] 1311#1311: *19 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.100, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.0.90"
{"name":"UNMS","hostname":"e2a2f02550d5","pid":825,"component":"proc","level":30,"delay":"12.73ms","cpu":"106.05%","memory":"73MB","uptime":"8s","msg":"[api]","time":"2023-10-15T23:46:12.881Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":825,"level":30,"msg":"Connected to SiriDB server version: 2.0.44","time":"2023-10-15T23:46:12.887Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":825,"level":30,"msg":"Adjusting limits for SiriDB database 'unms'","time":"2023-10-15T23:46:12.890Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":825,"level":30,"msg":"Adjusting limits for SiriDB database 'unms_archive'","time":"2023-10-15T23:46:12.910Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":825,"level":30,"msg":"Connected to PostgreSQL server version: PostgreSQL 9.6.13 on armv6-alpine-linux-musleabihf, compiled by gcc (Alpine 6.3.0) 6.3.0, 32-bit","time":"2023-10-15T23:46:12.977Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":825,"level":30,"msg":"Registering plugins","time":"2023-10-15T23:46:14.177Z","v":0}
2023/10/15 19:46:16 [error] 1311#1311: *21 connect() failed (111: Connection refused) while connecting to upstream, client: 72.38.36.183, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
2023/10/15 19:46:18 [error] 1311#1311: *23 connect() failed (111: Connection refused) while connecting to upstream, client: 64.228.243.250, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
{"message":"Generating static suspension page.","channel":"web.sh","datetime":"2023-10-15T19:46:26-04:00","severity":"INFO","level":200}
{"message":"Done generating static suspension page.","channel":"web.sh","datetime":"2023-10-15T19:46:27-04:00","severity":"INFO","level":200}
{"message":"Re/generating plugin symlinks and config files.","channel":"web.sh","datetime":"2023-10-15T19:46:27-04:00","severity":"INFO","level":200}
RangeError: Model is only valid from Tue Sep 18 2018 to Mon Sep 18 2023
    at o.getTimedModel (/home/app/unms/lib/link-score/linkCoreBackendLib.js:2:743276)
    at Object.i.model (/home/app/unms/lib/link-score/linkCoreBackendLib.js:2:140035)
    at calcMagneticHeadingInfo (/home/app/unms/lib/link-score/linkCoreBackendLib.js:2:1058808)
    at Object.<anonymous> (/home/app/unms/lib/api/v2.1/installations/schemas.js:152:15)
    at Module._compile (internal/modules/cjs/loader.js:1137:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1157:10)
    at Module.load (internal/modules/cjs/loader.js:985:32)
    at Function.Module._load (internal/modules/cjs/loader.js:878:14)
    at Module.require (internal/modules/cjs/loader.js:1025:19)
    at require (internal/modules/cjs/helpers.js:72:18)
    at Object.<anonymous> (/home/app/unms/lib/api/v2.1/installations/routes.js:18:5)
    at Module._compile (internal/modules/cjs/loader.js:1137:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1157:10)
    at Module.load (internal/modules/cjs/loader.js:985:32)
    at Function.Module._load (internal/modules/cjs/loader.js:878:14)
    at Module.require (internal/modules/cjs/loader.js:1025:19)
    at require (internal/modules/cjs/helpers.js:72:18)
    at Object.<anonymous> (/home/app/unms/lib/api/v2.1/installations/plugin.js:10:28)
    at Module._compile (internal/modules/cjs/loader.js:1137:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1157:10)
    at Module.load (internal/modules/cjs/loader.js:985:32)
    at Function.Module._load (internal/modules/cjs/loader.js:878:14)
    at Module.require (internal/modules/cjs/loader.js:1025:19)
    at require (internal/modules/cjs/helpers.js:72:18)
    at Object.internals.requireRelativeTo (/home/app/unms/node_modules/@hapi/glue/lib/index.js:108:12)
    at Object.internals.parsePlugin (/home/app/unms/node_modules/@hapi/glue/lib/index.js:93:41)
    at /home/app/unms/node_modules/@hapi/glue/lib/index.js:43:30
    at Array.map (<anonymous>)
    at Object.exports.compose (/home/app/unms/node_modules/@hapi/glue/lib/index.js:41:51)
    at MergeMapSubscriber.project (/home/app/unms/application.js:199:26)
    at MergeMapSubscriber._tryNext (/home/app/unms/node_modules/rxjs/operators/mergeMap.js:122:27)
    at MergeMapSubscriber._next (/home/app/unms/node_modules/rxjs/operators/mergeMap.js:112:18)
    at MergeMapSubscriber.Subscriber.next (/home/app/unms/node_modules/rxjs/Subscriber.js:93:18)
    at DoSubscriber._next (/home/app/unms/node_modules/rxjs/operators/tap.js:88:30)
    at DoSubscriber.Subscriber.next (/home/app/unms/node_modules/rxjs/Subscriber.js:93:18)
    at DeferSubscriber.OuterSubscriber.notifyNext (/home/app/unms/node_modules/rxjs/OuterSubscriber.js:19:26)
    at InnerSubscriber._next (/home/app/unms/node_modules/rxjs/InnerSubscriber.js:23:21)
    at InnerSubscriber.Subscriber.next (/home/app/unms/node_modules/rxjs/Subscriber.js:93:18)
    at /home/app/unms/node_modules/rxjs/util/subscribeToResult.js:37:29
    at processTicksAndRejections (internal/process/task_queues.js:97:5) Unexpected error in master process
FATAL:  role "root" does not exist
/tmp:5432 - accepting connections
1001
Running docker-entrypoint /home/app/unms/index.js
Sentry release: 
Version: 1.3.11+c7edd9600d.2021-07-19T14:45:00+02:00
Waiting for database containers
LOG:  incomplete startup packet
NOTICE:  extension "timescaledb" does not exist, skipping
DROP EXTENSION
Restoring backups and/or running migrations
yarn run v1.22.4
$ yarn backup:apply && yarn migrate && yarn check-crm-db
{"message":"Done re/generating plugin symlinks and config files.","channel":"web.sh","datetime":"2023-10-15T19:46:30-04:00","severity":"INFO","level":200}
2023/10/15 19:46:30 [error] 1311#1311: *25 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.100, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.0.90"
{"message":"Resetting in-progress states.","channel":"web.sh","datetime":"2023-10-15T19:46:30-04:00","severity":"INFO","level":200}
$ node ./cli/apply-backup.js
{"message":"Done resetting in-progress states.","channel":"web.sh","datetime":"2023-10-15T19:46:32-04:00","severity":"INFO","level":200}
{"message":"Synchronizing with UNMS.","channel":"web.sh","datetime":"2023-10-15T19:46:33-04:00","severity":"INFO","level":200}
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:46:33-04:00","severity":"INFO","level":200}
$ node ./cli/migrate.js
2023/10/15 19:46:35 [error] 1313#1313: *27 connect() failed (111: Connection refused) while connecting to upstream, client: 72.38.36.183, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:46:36-04:00","severity":"INFO","level":200}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2199,"level":30,"msg":"Connected to SiriDB server version: 2.0.44","time":"2023-10-15T23:46:37.102Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2199,"level":30,"msg":"Adjusting limits for SiriDB database 'unms'","time":"2023-10-15T23:46:37.108Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2199,"level":30,"msg":"Adjusting limits for SiriDB database 'unms_archive'","time":"2023-10-15T23:46:37.124Z","v":0}
Extension 'uuid-ossp:1.1 installed.
Extension 'pgcrypto:1.3 installed.
Extension 'cube:1.2 installed.
Extension 'earthdistance:1.1 installed.
Extension 'unaccent:1.1 installed.
Migrations finished in 0.269s
Setting database schema version to 1.3.11
Done
2023/10/15 19:46:38 [error] 1313#1313: *29 connect() failed (111: Connection refused) while connecting to upstream, client: 64.228.243.250, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
$ node cli/check-crm-db.js
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:46:40-04:00","severity":"INFO","level":200}
Checking CRM database schema version.
CRM database schema version is '1.3.11'.
Done in 11.24s.
Exec /home/app/unms/index.js with memory limit 798
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:46:43-04:00","severity":"INFO","level":200}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2020,"level":30,"msg":"Master 2020 is running","time":"2023-10-15T23:46:44.777Z","v":0}
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:46:47-04:00","severity":"INFO","level":200}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2020,"level":30,"msg":"Connected to SiriDB server version: 2.0.44","time":"2023-10-15T23:46:48.245Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2020,"level":30,"msg":"Adjusting limits for SiriDB database 'unms'","time":"2023-10-15T23:46:48.249Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2020,"level":30,"msg":"Adjusting limits for SiriDB database 'unms_archive'","time":"2023-10-15T23:46:48.264Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2020,"level":30,"msg":"Connected to PostgreSQL server version: PostgreSQL 9.6.13 on armv6-alpine-linux-musleabihf, compiled by gcc (Alpine 6.3.0) 6.3.0, 32-bit","time":"2023-10-15T23:46:48.334Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2020,"level":30,"msg":"Registering plugins","time":"2023-10-15T23:46:49.259Z","v":0}
2023/10/15 19:46:49 [error] 1312#1312: *31 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.100, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "192.168.0.90"
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:46:50-04:00","severity":"INFO","level":200}
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:46:54-04:00","severity":"INFO","level":200}
2023/10/15 19:46:55 [error] 1312#1312: *33 connect() failed (111: Connection refused) while connecting to upstream, client: 72.38.36.183, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:46:57-04:00","severity":"INFO","level":200}
RangeError: Model is only valid from Tue Sep 18 2018 to Mon Sep 18 2023
    at o.getTimedModel (/home/app/unms/lib/link-score/linkCoreBackendLib.js:2:743276)
    at Object.i.model (/home/app/unms/lib/link-score/linkCoreBackendLib.js:2:140035)
    at calcMagneticHeadingInfo (/home/app/unms/lib/link-score/linkCoreBackendLib.js:2:1058808)
    at Object.<anonymous> (/home/app/unms/lib/api/v2.1/installations/schemas.js:152:15)
    at Module._compile (internal/modules/cjs/loader.js:1137:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1157:10)
    at Module.load (internal/modules/cjs/loader.js:985:32)
    at Function.Module._load (internal/modules/cjs/loader.js:878:14)
    at Module.require (internal/modules/cjs/loader.js:1025:19)
    at require (internal/modules/cjs/helpers.js:72:18)
    at Object.<anonymous> (/home/app/unms/lib/api/v2.1/installations/routes.js:18:5)
    at Module._compile (internal/modules/cjs/loader.js:1137:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1157:10)
    at Module.load (internal/modules/cjs/loader.js:985:32)
    at Function.Module._load (internal/modules/cjs/loader.js:878:14)
    at Module.require (internal/modules/cjs/loader.js:1025:19)
    at require (internal/modules/cjs/helpers.js:72:18)
    at Object.<anonymous> (/home/app/unms/lib/api/v2.1/installations/plugin.js:10:28)
    at Module._compile (internal/modules/cjs/loader.js:1137:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1157:10)
    at Module.load (internal/modules/cjs/loader.js:985:32)
    at Function.Module._load (internal/modules/cjs/loader.js:878:14)
    at Module.require (internal/modules/cjs/loader.js:1025:19)
    at require (internal/modules/cjs/helpers.js:72:18)
    at Object.internals.requireRelativeTo (/home/app/unms/node_modules/@hapi/glue/lib/index.js:108:12)
    at Object.internals.parsePlugin (/home/app/unms/node_modules/@hapi/glue/lib/index.js:93:41)
    at /home/app/unms/node_modules/@hapi/glue/lib/index.js:43:30
    at Array.map (<anonymous>)
    at Object.exports.compose (/home/app/unms/node_modules/@hapi/glue/lib/index.js:41:51)
    at MergeMapSubscriber.project (/home/app/unms/application.js:199:26)
    at MergeMapSubscriber._tryNext (/home/app/unms/node_modules/rxjs/operators/mergeMap.js:122:27)
    at MergeMapSubscriber._next (/home/app/unms/node_modules/rxjs/operators/mergeMap.js:112:18)
    at MergeMapSubscriber.Subscriber.next (/home/app/unms/node_modules/rxjs/Subscriber.js:93:18)
    at DoSubscriber._next (/home/app/unms/node_modules/rxjs/operators/tap.js:88:30)
    at DoSubscriber.Subscriber.next (/home/app/unms/node_modules/rxjs/Subscriber.js:93:18)
    at DeferSubscriber.OuterSubscriber.notifyNext (/home/app/unms/node_modules/rxjs/OuterSubscriber.js:19:26)
    at InnerSubscriber._next (/home/app/unms/node_modules/rxjs/InnerSubscriber.js:23:21)
    at InnerSubscriber.Subscriber.next (/home/app/unms/node_modules/rxjs/Subscriber.js:93:18)
    at /home/app/unms/node_modules/rxjs/util/subscribeToResult.js:37:29
    at processTicksAndRejections (internal/process/task_queues.js:97:5) Unexpected error in master process
FATAL:  role "root" does not exist
/tmp:5432 - accepting connections
1001
Running docker-entrypoint /home/app/unms/index.js
Sentry release: 
Version: 1.3.11+c7edd9600d.2021-07-19T14:45:00+02:00
Waiting for database containers
LOG:  incomplete startup packet
NOTICE:  extension "timescaledb" does not exist, skipping
DROP EXTENSION
Restoring backups and/or running migrations
2023/10/15 19:46:59 [error] 1312#1312: *35 connect() failed (111: Connection refused) while connecting to upstream, client: 64.228.243.250, server: , request: "GET // HTTP/1.1", upstream: "http://127.0.0.1:8082//", host: "<weburl>"
yarn run v1.22.4
$ yarn backup:apply && yarn migrate && yarn check-crm-db
$ node ./cli/apply-backup.js
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:47:01-04:00","severity":"INFO","level":200}
$ node ./cli/migrate.js
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:47:04-04:00","severity":"INFO","level":200}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2524,"level":30,"msg":"Connected to SiriDB server version: 2.0.44","time":"2023-10-15T23:47:06.035Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2524,"level":30,"msg":"Adjusting limits for SiriDB database 'unms'","time":"2023-10-15T23:47:06.041Z","v":0}
{"name":"UNMS","hostname":"e2a2f02550d5","pid":2524,"level":30,"msg":"Adjusting limits for SiriDB database 'unms_archive'","time":"2023-10-15T23:47:06.056Z","v":0}
Extension 'uuid-ossp:1.1 installed.
Extension 'pgcrypto:1.3 installed.
Extension 'cube:1.2 installed.
Extension 'earthdistance:1.1 installed.
Extension 'unaccent:1.1 installed.
Migrations finished in 0.216s
Setting database schema version to 1.3.11
Done
$ node cli/check-crm-db.js
{"message":"Waiting for UNMS (127.0.0.1:8081).","channel":"unms_ready.sh","datetime":"2023-10-15T19:47:07-04:00","severity":"INFO","level":200}

Nico640 · 2023-10-17T19:45:41Z

You're right, 1.3.11 doesn't work anymore. I also tried a fresh install and it fails with the same error. Apparently some part of this particular UISP version expired on Sep 18 2023.

The only way I was able to get it to run was by manually changing the date of the Raspberry Pi to somewhere before Sep 18 2023:

sudo timedatectl set-ntp false
sudo timedatectl set-time 2023-05-05

sudo timedatectl set-ntp false disables the automatic time synchronization, so if you want the correct date back, you'll need to re-enable it: sudo timedatectl set-ntp true

Thats obviously not a long-term solution but it's enough to pull backups before updating to a newer version.

GuruSR · 2023-10-17T23:21:42Z

So now how to get everything cloned across onto a newer version of the Pi OS because there is no upgrade option, only blank and start over, that is a ton of data (the 128GB card is more than half full). Just to get that to run, almost simpler to put another unit in play just for UISP.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

1.3.11 no longer responding to requests. #97

1.3.11 no longer responding to requests. #97

GuruSR commented Sep 19, 2023 •

edited

Loading

Nico640 commented Oct 15, 2023

GuruSR commented Oct 15, 2023

GuruSR commented Oct 15, 2023

Nico640 commented Oct 15, 2023

GuruSR commented Oct 15, 2023

Nico640 commented Oct 15, 2023

GuruSR commented Oct 15, 2023

GuruSR commented Oct 15, 2023

Nico640 commented Oct 17, 2023

GuruSR commented Oct 17, 2023

1.3.11 no longer responding to requests. #97

1.3.11 no longer responding to requests. #97

Comments

GuruSR commented Sep 19, 2023 • edited Loading

Nico640 commented Oct 15, 2023

GuruSR commented Oct 15, 2023

GuruSR commented Oct 15, 2023

Nico640 commented Oct 15, 2023

GuruSR commented Oct 15, 2023

Nico640 commented Oct 15, 2023

GuruSR commented Oct 15, 2023

GuruSR commented Oct 15, 2023

Nico640 commented Oct 17, 2023

GuruSR commented Oct 17, 2023

GuruSR commented Sep 19, 2023 •

edited

Loading