user registration error: null value in column "systemUserId" violates not-null constraint

[dzxt]

Hello,
When I tried to register a new user I got the following error, I changed the username from admin to admin1 and re-registered but got the same error.

Node 15.8.0
Example version 1.2.0
impress: ^2.2.0
metasql: ^1.0.1

17:56:11 W3 debug INSERT INTO "SystemUser" ("login", "password", "fullName") VALUES ($1, $2, $3) [admin,$scrypt$N=32768,r=8,p=1,maxmem=xxx,]
17:56:11 W3 debug INSERT INTO "SystemSession" ("token", "data", "ip", "systemUserId") VALUES ($1, $2, $3, $4) [xxx,{},127.0.0.1,]
17:56:11 W3 log 127.0.0.1 auth/register
17:56:11 W3 error error: null value in column "systemUserId" violates not-null constraint
Parser.parseErrorMessage (/node_modules/pg-protocol/dist/parser.js:287:98)
Parser.handlePacket (/node_modules/pg-protocol/dist/parser.js:126:29)
Parser.parse (/node_modules/pg-protocol/dist/parser.js:39:38)
Socket. (/node_modules/pg-protocol/dist/index.js:11:42)
Socket.emit (node:events:378:20)
addChunk (node:internal/streams/readable:313:12)
readableAddChunk (node:internal/streams/readable:288:9)
Socket.Readable.push (node:internal/streams/readable:227:10)
TCP.onStreamRead (node:internal/stream_base_commons:190:23)

[tshemsedinov]

Thanks, we are in the middle of refactoring AAA subsystem, this will decouple impress, metacom and applied code using abstract interface, so AAA will be plugable, we also will use metasql 1.1.x (with metaschema 1.1.1) for new AAA database structure so application may extend core database structure. This will be ready in impress 2.3.0 (15 May) https://github.com/metarhia/impress/milestone/8