Create admin user on startup

[ralf-berger]

Discussed in #3

One of the services (or an additional one-off service/job) should invoke an upsert of an (admin) user account on startup.

[shoebjoarder]

Added a run script to create an admin user. Perhaps the compose.yaml can use this script by adding a new one-off job?

[shoebjoarder]

BTW, the CLI command to create a new admin in the learninglocker-api-1 isn't working. Seems like a connection issue to the MongoDB database.

# node cli/dist/server createSiteAdmin admin@mail.com soco 1234qweR
2025-04-10 20:06:33:311 - error: uncaughtException: The `uri` parameter to `openUri()` must be a string, got "undefined". Make sure the first parameter to `mongoose.connect()` or `mongoose.createConnection()` is a string. 
{ date:
   'Thu Apr 10 2025 20:06:33 GMT+0000 (Coordinated Universal Time)',
  process:
   { pid: 58,
     uid: 0,
     gid: 0,
     cwd: '/opt/learninglocker',
     execPath: '/usr/local/bin/node',
     version: 'v10.24.1',
     argv:
      [ '/usr/local/bin/node',
        '/opt/learninglocker/cli/dist/server',
        'createSiteAdmin',
        'admin@mail.com',
        'soco',
        '1234qweR' ],
     memoryUsage:
      { rss: 117571584,
        heapTotal: 80359424,
        heapUsed: 54730040,
        external: 36096596 } },
  os:
   { loadavg: [ 0.97119140625, 0.7998046875, 0.865234375 ],
     uptime: 23104 },
  trace:
   [ { column: 11,
       file:
        '/opt/learninglocker/node_modules/mongoose/lib/error/mongooseError.js',
       function: 'new MongooseError',
       line: 10,
       method: null,
       native: false },
     { column: 11,
       file:
        '/opt/learninglocker/node_modules/mongoose/lib/connection.js',
       function: 'NativeConnection.Connection.openUri',
       line: 542,
       method: 'openUri',
       native: false },
     { column: 17,
       file: '/opt/learninglocker/node_modules/mongoose/lib/index.js',
       function: 'Mongoose.createConnection',
       line: 278,
       method: 'createConnection',
       native: false },
     { column: 19,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/opt/learninglocker/lib/connections/mongoose.js',
       function: 'createConnection',
       line: 27,
       method: null,
       native: false },
     { column: 28,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/opt/learninglocker/lib/connections/mongoose.js',
       function: 'getConnection',
       line: 44,
       method: null,
       native: false },
     { column: 15,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/opt/learninglocker/lib/models/plugins/auditRemove.js',
       function: 'Object.module.exports.Object.defineProperty.value',
       line: 21,
       method: 'value',
       native: false },
     { column: 1,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7',
       function: '__webpack_require__',
       line: 19,
       method: null,
       native: false },
     { column: 1,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/opt/learninglocker/lib/models/user.js',
       function: 'Object.module.exports.Object.defineProperty.value',
       line: 12,
       method: 'value',
       native: false },
     { column: 1,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7',
       function: '__webpack_require__',
       line: 19,
       method: null,
       native: false },
     { column: 1,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/commands/createSiteAdmin.js',
       function: null,
       line: 3,
       method: null,
       native: false },
     { column: 1,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7',
       function: '__webpack_require__',
       line: 19,
       method: null,
       native: false },
     { column: 1,
       file: '/opt/learninglocker/cli/dist/server/webpack:/server.js',
       function: null,
       line: 4,
       method: null,
       native: false },
     { column: 1,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7',
       function: '__webpack_require__',
       line: 19,
       method: null,
       native: false },
     { column: 1,
       file:
        '/opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7',
       function: null,
       line: 62,
       method: null,
       native: false },
     { column: 10,
       file: '/opt/learninglocker/cli/dist/server/index.js',
       function: null,
       line: 70,
       method: null,
       native: false },
     { column: 30,
       file: 'internal/modules/cjs/loader.js',
       function: 'Module._compile',
       line: 778,
       method: '_compile',
       native: false },
     { column: 10,
       file: 'internal/modules/cjs/loader.js',
       function: 'Module._extensions..js',
       line: 789,
       method: '.js',
       native: false },
     { column: 32,
       file: 'internal/modules/cjs/loader.js',
       function: 'Module.load',
       line: 653,
       method: 'load',
       native: false },
     { column: 12,
       file: 'internal/modules/cjs/loader.js',
       function: 'tryModuleLoad',
       line: 593,
       method: null,
       native: false },
     { column: 3,
       file: 'internal/modules/cjs/loader.js',
       function: 'Module._load',
       line: 585,
       method: '_load',
       native: false },
     { column: 12,
       file: 'internal/modules/cjs/loader.js',
       function: 'Module.runMain',
       line: 831,
       method: 'runMain',
       native: false },
     { column: 19,
       file: 'internal/bootstrap/node.js',
       function: 'startup',
       line: 283,
       method: null,
       native: false } ],
  stack:
   [ 'MongooseError: The `uri` parameter to `openUri()` must be a string, got "undefined". Make sure the first parameter to `mongoose.connect()` or `mongoose.createConnection()` is a string.',
     '    at new MongooseError (/opt/learninglocker/node_modules/mongoose/lib/error/mongooseError.js:10:11)',
     '    at NativeConnection.Connection.openUri (/opt/learninglocker/node_modules/mongoose/lib/connection.js:542:11)',
     '    at Mongoose.createConnection (/opt/learninglocker/node_modules/mongoose/lib/index.js:278:17)',
     '    at createConnection (/opt/learninglocker/cli/dist/server/webpack:/opt/learninglocker/lib/connections/mongoose.js:27:19)',
     '    at getConnection (/opt/learninglocker/cli/dist/server/webpack:/opt/learninglocker/lib/connections/mongoose.js:44:28)',
     '    at Object.module.exports.Object.defineProperty.value (/opt/learninglocker/cli/dist/server/webpack:/opt/learninglocker/lib/models/plugins/auditRemove.js:21:15)',
     '    at __webpack_require__ (/opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7:19:1)',
     '    at Object.module.exports.Object.defineProperty.value (/opt/learninglocker/cli/dist/server/webpack:/opt/learninglocker/lib/models/user.js:12:1)',
     '    at __webpack_require__ (/opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7:19:1)',
     '    at Object.<anonymous> (/opt/learninglocker/cli/dist/server/webpack:/commands/createSiteAdmin.js:3:1)',
     '    at __webpack_require__ (/opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7:19:1)',
     '    at Object.<anonymous> (/opt/learninglocker/cli/dist/server/webpack:/server.js:4:1)',
     '    at __webpack_require__ (/opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7:19:1)',
     '    at /opt/learninglocker/cli/dist/server/webpack:/webpack/bootstrap d5ddbc453e2ae3ea25f7:62:1',
     '    at Object.<anonymous> (/opt/learninglocker/cli/dist/server/index.js:70:10)',
     '    at Module._compile (internal/modules/cjs/loader.js:778:30)',
     '    at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)',
     '    at Module.load (internal/modules/cjs/loader.js:653:32)',
     '    at tryModuleLoad (internal/modules/cjs/loader.js:593:12)',
     '    at Function.Module._load (internal/modules/cjs/loader.js:585:3)',
     '    at Function.Module.runMain (internal/modules/cjs/loader.js:831:12)',
     '    at startup (internal/bootstrap/node.js:283:19)' ] }
# 

[ralf-berger]

Added a run script to create an admin user.

How do you execute that correctly? I'm getting Error: Cannot find module '../cli/src/commands/createSiteAdmin'. Not sure what the assumed base path is—current working directory? file location? some Node config?

[shoebjoarder]

Managed to create an admin using the script file in 28353a7