Comments (10)
Sorry for the late response, can you check if there is anything in the container logs by executing docker logs unms_unms_1
?
from docker-unms.
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.
from docker-unms.
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.
from docker-unms.
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
from docker-unms.
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).
from docker-unms.
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?
from docker-unms.
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
from docker-unms.
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/[email protected]' 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/[email protected]
/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}
from docker-unms.
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.
from docker-unms.
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.
from docker-unms.
Related Issues (20)
- Open Ports for Postgresql HOT 1
- Core (sigsegv) on startup with QNAP and 2.3 series HOT 4
- Issue with upgrading older version of UISP (1.6.5 --> 2.3.57) HOT 5
- Update Docker Image for UISP 2.4.93 HOT 2
- Unable to do fresh install of 2.4.93 HOT 1
- Running with reverse proxy HOT 2
- clean install but infinite loop HOT 2
- s6-overlay-suexec: fatal: can only run as pid 1 on Container start. HOT 2
- How to get UNMS (UISP) to take a lets encrypt (or converted) .key/.crt using docker-compose, no Wiki info. HOT 8
- Changing ports doesn't seem to be working HOT 1
- UISP never starts. Container restarts HOT 2
- Update to 2.2.12 HOT 2
- Suggestion:
- Limit memory usage of container
- Connection refused while connecting to upstream, client HOT 2
- UISP container starts only after recreation, but than not and have to recreate container every time HOT 2
- Docker Compose Version HOT 1
- RabbitMQ not start HOT 13
- Can't start on A1 Oracle instances because of outdated Node.js version HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from docker-unms.