HI @jamesj,
Thanks for the reply.
I followed your instructions for the question (1) and (2) : Iām using the docker compose environment for the first attempt.
I call the Serial Vault web interfare at the url http://localhost:8081/models/keypairs/new.
The attempt is not successful and I have the following log messages:
web_1 | 2017/05/23 19:40:23 Database opened successfully.
web_1 | 2017/05/23 19:40:23 Database opened successfully.
web_1 | 2017/05/23 19:40:55 GET /v1/token 86.94µs
web_1 | 2017/05/23 19:40:55 POST /v1/keypairs 33.184µs
db_1 | ERROR: relation "settings" does not exist at character 29
db_1 | STATEMENT:
db_1 | WITH upsert AS (
db_1 | update settings set code=$1, data=$2
db_1 | where code=$1
db_1 | RETURNING *
db_1 | )
db_1 | insert into settings (code,data)
db_1 | select $1, $2
db_1 | where not exists (select * from upsert)
db_1 |
web_1 | 2017/05/23 19:40:55 Error updating the database setting: pq: relation "settings" does not exist
db_1 | ERROR: relation "keypair" does not exist at character 29
db_1 | STATEMENT:
db_1 | WITH upsert AS (
db_1 | update keypair set authority_id=$1, key_id=$2, sealed_key=$3, assertion=$4
db_1 | where authority_id=$1 and key_id=$2
db_1 | RETURNING *
db_1 | )
db_1 | insert into keypair (authority_id,key_id,sealed_key,assertion)
db_1 | select $1, $2, $3, $4
db_1 | where not exists (select * from upsert)
db_1 |
web_1 | 2017/05/23 19:40:55 Error updating the database keypair: pq: relation "keypair" does not exist
web_1 | 2017/05/23 19:40:58 GET /v1/token 1.665µs
web_1 | 2017/05/23 19:40:58 POST /v1/keypairs 1.556µs
web_1 | 2017/05/23 19:40:58 Error updating the database setting: pq: relation "settings" does not exist
web_1 | 2017/05/23 19:40:58 Error updating the database keypair: pq: relation "keypair" does not exist
db_1 | ERROR: relation "settings" does not exist at character 29
db_1 | STATEMENT:
db_1 | WITH upsert AS (
db_1 | update settings set code=$1, data=$2
db_1 | where code=$1
db_1 | RETURNING *
db_1 | )
db_1 | insert into settings (code,data)
db_1 | select $1, $2
db_1 | where not exists (select * from upsert)
db_1 |
db_1 | ERROR: relation "keypair" does not exist at character 29
db_1 | STATEMENT:
db_1 | WITH upsert AS (
db_1 | update keypair set authority_id=$1, key_id=$2, sealed_key=$3, assertion=$4
db_1 | where authority_id=$1 and key_id=$2
db_1 | RETURNING *
db_1 | )
db_1 | insert into keypair (authority_id,key_id,sealed_key,assertion)
db_1 | select $1, $2, $3, $4
db_1 | where not exists (select * from upsert)
db_1 |
web_1 | 2017/05/23 19:41:00 GET /models/keypairs/new 36.321µs
web_1 | 2017/05/23 19:41:00 GET /v1/version 4.251µs
web_1 | 2017/05/23 19:41:25 GET /v1/token 1.456µs
web_1 | 2017/05/23 19:41:25 POST /v1/keypairs 1.364µs
web_1 | 2017/05/23 19:41:25 Error updating the database setting: pq: relation "settings" does not exist
db_1 | ERROR: relation "settings" does not exist at character 29
db_1 | STATEMENT:
db_1 | WITH upsert AS (
db_1 | update settings set code=$1, data=$2
db_1 | where code=$1
db_1 | RETURNING *
db_1 | )
db_1 | insert into settings (code,data)
db_1 | select $1, $2
db_1 | where not exists (select * from upsert)
db_1 |
db_1 | ERROR: relation "keypair" does not exist at character 29
db_1 | STATEMENT:
db_1 | WITH upsert AS (
db_1 | update keypair set authority_id=$1, key_id=$2, sealed_key=$3, assertion=$4
db_1 | where authority_id=$1 and key_id=$2
db_1 | RETURNING *
db_1 | )
db_1 | insert into keypair (authority_id,key_id,sealed_key,assertion)
db_1 | select $1, $2, $3, $4
db_1 | where not exists (select * from upsert)
db_1 |
web_1 | 2017/05/23 19:41:25 Error updating the database keypair: pq: relation "keypair" does not exist
web_1 | 2017/05/23 19:47:12 GET /models 6.891µs
db_1 | ERROR: relation "keypair" does not exist at character 57
db_1 | STATEMENT: select id, authority_id, key_id, active, assertion from keypair order by authority_id, key_id
web_1 | 2017/05/23 19:47:13 GET /v1/keypairs 1.333µs
web_1 | 2017/05/23 19:47:13 Error retrieving database keypairs: pq: relation "keypair" does not exist
db_1 | ERROR: relation "model" does not exist at character 155
db_1 | STATEMENT:
db_1 | select m.id, brand_id, name, keypair_id, k.authority_id, k.key_id, k.active, user_keypair_id, ku.authority_id, ku.key_id, ku.active, ku.assertion
db_1 | from model m
db_1 | inner join keypair k on k.id = m.keypair_id
db_1 | inner join keypair ku on ku.id = m.user_keypair_id
db_1 | order by name
db_1 |
web_1 | 2017/05/23 19:47:13 GET /v1/models 2.395µs
web_1 | 2017/05/23 19:47:13 GET /v1/version 5.723µs
web_1 | 2017/05/23 19:47:13 Error retrieving database models: pq: relation "model" does not exist
web_1 | 2017/05/23 19:47:17 GET /models/new 1.467µs
web_1 | 2017/05/23 19:47:17 GET /v1/keypairs 2.925µs
db_1 | ERROR: relation "keypair" does not exist at character 57
db_1 | STATEMENT: select id, authority_id, key_id, active, assertion from keypair order by authority_id, key_id
web_1 | 2017/05/23 19:47:17 GET /v1/version 1.655µs
web_1 | 2017/05/23 19:47:17 Error retrieving database keypairs: pq: relation "keypair" does not exist
web_1 | 2017/05/23 19:47:43 GET /accounts 1.303µs
web_1 | 2017/05/23 19:47:43 GET /v1/accounts 1.718µs
db_1 | ERROR: relation "account" does not exist at character 41
db_1 | STATEMENT: select id, authority_id, assertion from account order by authority_id
web_1 | 2017/05/23 19:47:43 Error retrieving database accounts: pq: relation "account" does not exist
db_1 | ERROR: relation "model" does not exist at character 155
web_1 | 2017/05/23 19:47:43 GET /v1/models 1.825µs
web_1 | 2017/05/23 19:47:43 Error retrieving database models: pq: relation "model" does not exist
db_1 | STATEMENT:
db_1 | select m.id, brand_id, name, keypair_id, k.authority_id, k.key_id, k.active, user_keypair_id, ku.authority_id, ku.key_id, ku.active, ku.assertion
db_1 | from model m
db_1 | inner join keypair k on k.id = m.keypair_id
db_1 | inner join keypair ku on ku.id = m.user_keypair_id
db_1 | order by name
db_1 |
web_1 | 2017/05/23 19:47:43 GET /v1/keypairs 1.893µs
web_1 | 2017/05/23 19:47:43 Error retrieving database keypairs: pq: relation "keypair" does not exist
web_1 | 2017/05/23 19:47:43 GET /v1/version 2.329µs
db_1 | ERROR: relation "keypair" does not exist at character 57
db_1 | STATEMENT: select id, authority_id, key_id, active, assertion from keypair order by authority_id, key_id
web_1 | 2017/05/23 19:47:45 GET /models 76.099µs
db_1 | ERROR: relation "model" does not exist at character 155
db_1 | STATEMENT:
db_1 | select m.id, brand_id, name, keypair_id, k.authority_id, k.key_id, k.active, user_keypair_id, ku.authority_id, ku.key_id, ku.active, ku.assertion
db_1 | from model m
db_1 | inner join keypair k on k.id = m.keypair_id
db_1 | inner join keypair ku on ku.id = m.user_keypair_id
db_1 | order by name
db_1 |
db_1 | ERROR: relation "keypair" does not exist at character 57
db_1 | STATEMENT: select id, authority_id, key_id, active, assertion from keypair order by authority_id, key_id
web_1 | 2017/05/23 19:47:46 GET /v1/models 1.496µs
web_1 | 2017/05/23 19:47:46 Error retrieving database models: pq: relation "model" does not exist
web_1 | 2017/05/23 19:47:46 GET /v1/keypairs 77.612µs
web_1 | 2017/05/23 19:47:46 Error retrieving database keypairs: pq: relation "keypair" does not exist
web_1 | 2017/05/23 19:47:46 GET /v1/version 98.627µs
web_1 | 2017/05/23 19:47:49 GET / 37.437µs
web_1 | 2017/05/23 19:47:49 GET /v1/version 1.769µs
web_1 | 2017/05/23 19:47:50 GET /models 1.533µs
db_1 | ERROR: relation "model" does not exist at character 155
db_1 | STATEMENT:
db_1 | select m.id, brand_id, name, keypair_id, k.authority_id, k.key_id, k.active, user_keypair_id, ku.authority_id, ku.key_id, ku.active, ku.assertion
db_1 | from model m
db_1 | inner join keypair k on k.id = m.keypair_id
db_1 | inner join keypair ku on ku.id = m.user_keypair_id
db_1 | order by name
db_1 |
db_1 | ERROR: relation "keypair" does not exist at character 57
db_1 | STATEMENT: select id, authority_id, key_id, active, assertion from keypair order by authority_id, key_id
web_1 | 2017/05/23 19:47:50 GET /v1/models 1.634µs
web_1 | 2017/05/23 19:47:50 Error retrieving database models: pq: relation "model" does not exist
web_1 | 2017/05/23 19:47:50 GET /v1/keypairs 2.28µs
web_1 | 2017/05/23 19:47:50 Error retrieving database keypairs: pq: relation "keypair" does not exist
web_1 | 2017/05/23 19:47:50 GET /v1/version 2.26µs
Could I have missed something ?
Cheers,
Nicolino