ub-server #

Added #

_5.18.12 _2020-08-31 #

new command line option -env env/file/path: adds all environment variables from env file into process.env. Such variable values are NOT visible to the child processes and OS, but available in JS (for example during config parsing)
new command line option -T: parse, validate and output parsed config to the stdout. Also, output environment variables (and it values) wanted by the config. If config contains errors - output line number for a first error and exit with code 1.

Use ub -T | nl to get line numbers in console
trailing commas now supported in config and meta files (actually trailing commas are replaced by ' ' in removeCommentsFromJSON function), so JSONs like

 "someArray": [
    "val",
    // "val2"
 ]

now VALID. It's very conveniently in config files, for example to comment a last array element etc.

%ENVVAR||default% - if environment variable ENVVAR ton found or empty default will be used. Example:

"mailerConfig": {
   "targetHost": "%UB_SMTP_HOST%",
   "targetPort": "%UB_SMTP_PORT||25%",
   "fromAddr": "%UB_SMTP_FROMADDR||no-reply@fake.com%",
   "user": "%UB_SMTP_USER%",
   "password": "%UB_SMTP_PWD%",
   "autoTLS": %UB_SMTP_TLS||false%,
   "auth": %UB_SMTP_AUTH||false%

//#ifdef and //#ifndef ubConfig directives parser added:
- remove part of JSON content between //#ifdef(%VAR_NAME%) ... //#endif if environment variable VAR_NAME is not defined or empty
- remove part of JSON content between //#ifndef(%VAR_NAME%) ... //#endif if environment variable VAR_NAME is defined and not empty
- case-sensitive equal comparison can be used as //#ifdef(%VAR_NAME%=VarValue) or //#ifdef(%VAR1_NAME%=%VAR2_NAME%)
- nested conditions IS NOT SUPPORTED
- content replaced by empty strings to keep the same line numbers as in original file
In example below section mailerConfig is removed from config in case UB_SKIP_MAILER environment variable is defined and not empty, and iGov model is added in case DOCFLOW_IGOV environment variable defined and not empty:

  "customSettings": {
    //#ifndef(%UB_SKIP_MAILER%)
    "mailerConfig": {
    
    },
    //#endif
  },
  "domain": {
    "models": [
       {
         "path": "./node_modules/@unitybase/ub"
       },
       //#ifdef("%DOCFLOW_IGOV%)
       {
         "path": "./node_modules/@docflow/iGov"
       }
      //#endif
    ] 
  }

use ub -T to view and validate parsed config

partial configs: in case ubConfog-partial.json exists in the model folder it will be merged into application ubConfig during server startup This allows moving a model configuration parameters into model folder and uses environment variables to define a parameters values. For example ubConfig-partial.json in @unitybase/ubq model is:

{
  "application": {
    "customSettings": {
      "mailerConfig": {
        "targetHost": "%UB_SMTP_HOST%",
        "targetPort": "%UB_SMTP_PORT||25%",
        "fromAddr": "%UB_SMTP_FROMADDR||no-reply@fake.com%",
        "user": "%UB_SMTP_USER%",
        "password": "%UB_SMTP_PWD%",
        "autoTLS": %UB_SMTP_TLS||false%,
        "auth": %UB_SMTP_AUTH||false%
      }
    }
  }
}

Do not forget to document environment variables in model README.md. See @unitybase/ubq/README.md for template.

ub-server package installation changes:
- folder changed to /opt/unitybase
- deb/rmp package creates a unitybase user/group; products/apps folder structure and unitybas@ systemd service See production enviromnent tutorial for details.
new properties in application.models ubConfig section vendorModels and customerModels - a colon separated string of folders inside %UB_APPDATA%/models to be added into domain models collection during config parsing (before the domain is loaded).
BREAKING - if NODE_PATH environment variable is not defined then server sets NODE_PATH to ${process.configPath}/node_modules:${process.configPath}. This allows specifying model location to be outside the application root folder, and it js files still can require modules from an application root. For example consider ub starts with -cfg /opt/unitybase/products/docflow/appConfig.json and our model entry point is located in /opt/unitybase/apps/customer1/vendor-model/index.js and:

 require('models/myModel/someScript') // resolves to /opt/unitybase/products/docflow/models/myModel/someScript.js
 require('@unitybase/ub') // resolves to /opt/unitybase/products/docflow/node_modules/@unitybase/ub/index.js`

As a side effect any js file can require a top-level module starting from a configPath instead of moving up using '../../../..'.

JS engine's for all worker threads now inherits from a main engine instance. This allows SpiderMonkey storing there some shared information and reduce overall program memory consummation up to 20% (depends on threadPoolSize)

_5.18.11 _2020-08-09 #

aclRls mixin: exprMethod accept 3-d parameter - mParams of original request (optional). Can be used to generate a aclRls expression what depends on UBQL context.
experimental cmd line switch -cj - force logging to journald

Changed #

_5.18.12 _2020-08-31 #

CentOS docker container now builds from CentOS8 (instead of CentOS7)
BREAKING javascript key in ubConfig is obsolete. Use cmd line switches or env variables to override default engine settings. See ub --help for additional info. Available switches are:
- --engine-max-mem (or UB_ENGINE_MAX_MEM env var)
- --engine-lifetime (or UB_ENGINE_LIFETIME env var)
- --engine-full-gc (or UB_ENGINE_FULL_GC env var)
- --debug-port
SQL query parameters logging:
- all parameters logged in one line as a JSON object (instead of log line per parameter)
- Custom1 log level is used to log parameters (instead of Debug) - this allows removing Debug log level on production and still got an SQL tracing
- string parameters truncated to 50 character on production (instead of 100) (without -dev switch)
- parameters of type Date logged without T00:00:00 part: 9999-12-31 instead of 9999-12-31T00:00:00
- parameter type added into key part of parameters JSON just after parameter index
  - for Boolean and Int64 parameters type is omitted: P1: true, P2: 12121 - parameter #1 is Boolean, parameter #2 is Int64
  - for String type added as s || string length: "P6s9":"127.0.0.1" - value of parameter #6 is a string of length 9
  - for BLOB type added as b and value is a BLOB length: "P4b": 2048 - value of parameter #6 is a blob of 2048 bytes length
  - for Date type added as d: "P5d":"2020-08-12T10:51:35" Log before changes:

" debug            P1: Str(8)      uba_user
" debug            P2: Int64       10
" debug            P4: Str(5)      admin
" debug            P5: DateTime    2020-08-12T09:58:33
" debug            P6: Str(9)      127.0.0.1
" debug            P7: Str(5)      admin
" debug            P8: Str(0)
" debug            P9: Int64       333812888535052
" debug            P10: Str(203..) Host: localhost:8881  User-Agent: Mozilla/5.0 (Linux; mORMot 1.18 TCurlHTTP)  Accept: */*  Accept-En...
" SQL              r=1 t=32 c=0 q=INSERT INTO uba_audit (entity,entityinfo_id,actionType,actionUser,actionTime,remoteIP,targetUser,targetRole,ID,fromValue) VALUES (?,?,?,?,?,?,?,?,?,?)

Log after changes:

" cust1            {"P1s8":"uba_user", "P2":10, "P3s5":"LOGIN", "P4s5":"admin", "P5d":"2020-08-12T10:51:35", "P6s9":"127.0.0.1", "P7s5":"admin", "P8s0":"", "P9":333812992802828, "P10s203":"Host: localhost: 8881\r\nUser-Agent: Mozilla/5.0 (Lin..."}
" SQL              r=1 t=33 c=0 q=INSERT INTO uba_audit (entity,entityinfo_id,actionType,actionUser,actionTime,remoteIP,targetUser,targetRole,ID,fromValue) VALUES (?,?,?,?,?,?,?,?,?,?)

As a result log size is decreased on ~10% and log lines count is decreased on ~20%.

_5.18.11 _2020-08-09 #

on Linux default server setup path changed to /opt/unitybase/ub-server for both rpm and deb packages. Prior to these changes, rpm install ub into /usr/lib64/ub-server and deb - into /usr/lib/ub-server
in case application config (passed as -cfg) is a symlink then server resolve it to a realpath and start with a resolved config. This allows to symlink configs for all available applications into a single folder (for example /etc/unitybase/apps-enabled)
mORMot updated to revision #6105
logging:
- endpoint name logging level (call endpoint ubql) replaced to Debug -> dedug endpoint ubql. Endpoint name is the first path of the URI, so discoverable from the HTTP log level output in production logs without debug log level enabled.
- Enter/Leave for DataStore.BuildAndExecInsertSQL shows only in case Debug log level enabled

Deprecated #

_5.18.12 _2020-08-31 #

Removed #

_5.18.12 _2020-08-31 #

Fixed #

_5.18.12 _2020-08-31 #

JS Debugger: gracefully disconnect debugger if counterpart closes connection

_5.18.11 _2020-08-09 #

Windows only: prevent "pausing" of a server when user clicks inside server console by enabling console extended mode and disabling "quick edit" mode. We strongly recommend to use ConEmu there such problems does not exist (or better linux + bash 😃 )
journald logging: message with % inside does not stop log process (for example, thread 4 = % in text representation)

@unitybase/adminui-vue #

Added #

_1.13.0 _2020-08-31 #

UDropdown: prop childPlacement - popper placement relative to opened dropdown
UTable: param formatHead in column config. Render function for header cell
UButtonGroup: added border for child UButton's
UFormRow: prop preventLabelEvents - disable label click, hover etc.
UTableEntity: view mode option in user settings, also added slot viewMode to overlap it.
UTableEntity: prop cardColumns. Array of column configs for card view
UTableEntity: prop beforeInitialLoad. Hook which called after store created, but data didn't start to load.
UNavbar: Close all and Close inactive actions added to tabs menu (as in tab popup)
USelectEntity, USelectEnum, USelectMultiple, USelectMany: prop searchStrategy which sets search request condition
USelectEntity, USelectEnum, USelectMultiple, USelectMany: user input debounce timeout increased from 120 to 600

_1.12.5 _2020-08-19 #

Tajik locale translation
Form/mount: added param openInBackgroundTab to mountTab. If true - the tab with a newly opened form does not become active. Default is false and new tab is activated.

_1.12.4 _2020-08-03 #

SignatureVerificationResult view: in case signature is invalid and library provide some reason this reason will be shown in () For example: Signature invalid (Неверный сертификат OSCP сервера)

Changed #

_1.13.0 _2020-08-31 #

UButton: changed sizes according design in figma
UTableEntity: display of filter and sort. It is displayed as a button with a popup
UTableEntity: color of filter tags. Value has "black" color, condition - "grey"

_1.12.5 _2020-08-19 #

UNavbar: tabs now displayed inside scroll box and prepended by "All tabs" button for tab management
UTableEntity in case window.outerHeight < 500px then table header hides while user scroll down (as with address bar in mobile browsers)
UNavbar in case window.outerHeight < 500px then navbar visibility can be toggled on/off (new toggle button added)

Deprecated #

_1.12.5 _2020-08-19 #

styleguidist package replaced as external application in ubjs/styleguide

Removed #

_1.13.0 _2020-08-31 #

UTable: event sort

_1.12.5 _2020-08-19 #

cross-env dependency removed

Fixed #

_1.13.0 _2020-08-31 #

UNavbar: fix Close all behavior
lookups.js: onEntityChange for delete event - in case response resultData do not contains ID, get it from response object not from resultData of response object

_1.12.5 _2020-08-19 #

UDropdown: in case dropdown is placed into HTML attribute with position: sticky/absolute/fixed then it it shown in full size (not cropped to the outer elements bounds as before)
ub-icons iconic font uses fixed character code for each icon, so adding new icons do not broke unicode codes for old icons.

_1.12.4 _2020-08-03 #

ensure adminui-vue exports magicLink (SystemJS.set freeze object, so should be exported before call to SystemJS)
Vue package if exist window.Vue use it as package entry point else use Vue from node_modules
UTableEntity.pageSize set default value 50 in case storeDefaultPageSize didn't present in ubConfig.json

@unitybase/adminui-pub #

Added #

_5.13.32 _2020-08-19 #

Tajik locale translation

Removed #

_5.13.32 _2020-08-19 #

cross-env dependency removed

Fixed #

_5.13.34 _2020-08-20 #

in case title property is defined in nav shortcut JSON - use it, otherwise - use a ubm_navshortcut.caption for title. Before this fix ubm_navshortcut.caption always overrides title.

_5.13.32 _2020-08-19 #

typo in Ukrainian translation for key doYouWantFillOtherAttr, removed quotes for unnecessarily quoted properties

@unitybase/base #

Added #

_5.3.0 _2020-08-31 #

config parser enhancements - see server 5.18.12 changelog for details
//#ifdef(%VAR_NAME%)..//#endif & //#ifndef(%VAR_NAME%)..//#endif
//#ifdef(%VAR_NAME%=someValue)
%VARNAME||default%
support for vendorModels and customerModels
trailing commas now supported in config and meta files
partial configs for models
argv.setServerConfiguration method - allows to set a config for native part

_5.2.15 _2020-08-19 #

support for #ifdef..#endif & #ifndef..#endif in ubConfig

Changed #

_5.3.0 _2020-08-31 #

ubConfig parser implementation is moved into UB.js (compiled as resource into ub server)

@unitybase/cdn #

Added #

_5.4.28 _2020-08-19 #

Tajik locale translation

_5.4.27 _2020-08-03 #

cdn_orgaccount: added complex unique index on (code, currencyID, bankID)

Fixed #

_5.4.27 _2020-08-03 #

cdn_orgaccount: change cache type to "None" since row count can be huge
cdn_orgaccount: fix error during updating of account with currencyID===null

@unitybase/only-office #

Changed #

_1.1.0 _2020-08-31 #

application.customSettings.mailerConfig section now defined in model partial config and automatically merged into main config (starting from ub@5.18.12). See README.md for environment variables list.

@unitybase/org #

Added #

_5.3.28 _2020-08-19 #

Tajik locale translation

Changed #

_5.4.0 _2020-08-31 #

BREAKING login for user who not assigned to employee allowed only for superusers (users admin and root = uba_common.isSuperuser()). Before these changes' logon without an employee is allowed for members of Admin group.

@unitybase/ub-pub #

Added #

_5.5.20 _2020-08-19 #

Tajik locale translation

Changed #

_5.5.22 _2020-08-31 #

EventEmitter.defaultMaxListeners increased from 10 to 20. This removes warning then event emitter are used for by JS mixins (EAV etc) to adds :after and :before events - in this case listeners count can exceed 10

_5.5.19 _2020-08-03 #

nodeJS usage example (in a README.md) rewritten using async function

Fixed #

_5.5.20 _2020-08-19 #

default login page top logo URL changed from /models/ub-pub/img/ub-login-logo.png to models/ub-pub/img/login-logo.svg. For any app we recommend to change uiSettings.loginWindowTopLogoURL to a logo for your app and not to use default logo.

@unitybase/ub #

Deprecated #

_5.6.0 _2020-08-31 #

javascript section in ubConfig is deprecated. Starting from UB 5.18.12 use command line switches or env. vars Use ub --help for details.

Removed #

_5.5.12 _2020-08-19 #

nodeJS compatibility test suite is moved from @unitybase/ub to apps/autotest/models/TST. This reduced the @unitybase/ub module size by 900Kb.

@unitybase/ubcli #

Changed #

_5.7.0 _2020-08-31 #

ubcli initDb command execute all SQL statements from a command line script. This allows not to start a server and prevents fake config creation.

Deprecated #

_5.6.4 _2020-08-19 #

ubcli prepareGZIP command is removed (obsolete). For a production environment generateNgingCfg & linkStatic should be used instead.

Fixed #

_5.7.0 _2020-08-31 #

ubcli createStore creates a tempPath even in case path is empty (for example for mdb store)

@unitybase/ubm #

Added #

_5.4.10 _2020-08-19 #

Tajik locale translation

@unitybase/ubq #

Added #

_5.3.26 _2020-08-19 #

Tajik locale translation

Changed #

_5.4.0 _2020-08-31 #

application.customSettings.mailerConfig section now defined in model partial config and automatically merged into main config (starting from ub@5.18.12). See README.md for environment variables list.

@unitybase/ubs #

Added #

_5.4.17 _2020-08-19 #

Tajik locale translation

Changed #

_5.4.17 _2020-08-19 #

ubs_message_edit-fm.vue: refactored, fixed layouts and loading mask

Removed #

_5.4.17 _2020-08-19 #

cross-env dependency removed

@unitybase/udisk #

Added #

_5.0.138 _2020-08-19 #

Tajik locale translation

ub-server #

Added #

5.18.12 2020-08-31 #

5.18.11 2020-08-09 #

Changed #

5.18.12 2020-08-31 #

5.18.11 2020-08-09 #

Deprecated #

5.18.12 2020-08-31 #

Removed #

5.18.12 2020-08-31 #

Fixed #

5.18.12 2020-08-31 #

5.18.11 2020-08-09 #

Added #

1.13.0 2020-08-31 #

1.12.5 2020-08-19 #

1.12.4 2020-08-03 #

Changed #

1.13.0 2020-08-31 #

1.12.5 2020-08-19 #

Deprecated #

1.12.5 2020-08-19 #

Removed #

1.13.0 2020-08-31 #

1.12.5 2020-08-19 #

Fixed #

1.13.0 2020-08-31 #

1.12.5 2020-08-19 #

1.12.4 2020-08-03 #

Added #

5.13.32 2020-08-19 #

Removed #

5.13.32 2020-08-19 #

Fixed #

5.13.34 2020-08-20 #

5.13.32 2020-08-19 #

Added #

5.3.0 2020-08-31 #

5.2.15 2020-08-19 #

Changed #

5.3.0 2020-08-31 #

Added #

5.4.28 2020-08-19 #

5.4.27 2020-08-03 #

Fixed #

5.4.27 2020-08-03 #

Changed #

1.1.0 2020-08-31 #

Added #

5.3.28 2020-08-19 #

Changed #

5.4.0 2020-08-31 #

Added #

5.5.20 2020-08-19 #

Changed #

5.5.22 2020-08-31 #

5.5.19 2020-08-03 #

Fixed #

5.5.20 2020-08-19 #

Deprecated #

5.6.0 2020-08-31 #

Removed #

5.5.12 2020-08-19 #

Changed #

5.7.0 2020-08-31 #

Deprecated #

5.6.4 2020-08-19 #

Fixed #

5.7.0 2020-08-31 #

Added #

5.4.10 2020-08-19 #

Added #

5.3.26 2020-08-19 #

Changed #

5.4.0 2020-08-31 #

Added #

5.4.17 2020-08-19 #

Changed #

5.4.17 2020-08-19 #

_5.18.12 _2020-08-31 #

_5.18.11 _2020-08-09 #

_5.18.12 _2020-08-31 #

_5.18.11 _2020-08-09 #

_5.18.12 _2020-08-31 #

_5.18.12 _2020-08-31 #

_5.18.12 _2020-08-31 #

_5.18.11 _2020-08-09 #

_1.13.0 _2020-08-31 #

_1.12.5 _2020-08-19 #

_1.12.4 _2020-08-03 #

_1.13.0 _2020-08-31 #

_1.12.5 _2020-08-19 #

_1.12.5 _2020-08-19 #

_1.13.0 _2020-08-31 #

_1.12.5 _2020-08-19 #

_1.13.0 _2020-08-31 #

_1.12.5 _2020-08-19 #

_1.12.4 _2020-08-03 #

_5.13.32 _2020-08-19 #

_5.13.32 _2020-08-19 #

_5.13.34 _2020-08-20 #

_5.13.32 _2020-08-19 #

_5.3.0 _2020-08-31 #

_5.2.15 _2020-08-19 #

_5.3.0 _2020-08-31 #

_5.4.28 _2020-08-19 #

_5.4.27 _2020-08-03 #

_5.4.27 _2020-08-03 #

_1.1.0 _2020-08-31 #

_5.3.28 _2020-08-19 #

_5.4.0 _2020-08-31 #

_5.5.20 _2020-08-19 #

_5.5.22 _2020-08-31 #

_5.5.19 _2020-08-03 #

_5.5.20 _2020-08-19 #

_5.6.0 _2020-08-31 #

_5.5.12 _2020-08-19 #

_5.7.0 _2020-08-31 #

_5.6.4 _2020-08-19 #

_5.7.0 _2020-08-31 #

_5.4.10 _2020-08-19 #

_5.3.26 _2020-08-19 #

_5.4.0 _2020-08-31 #

_5.4.17 _2020-08-19 #

_5.4.17 _2020-08-19 #

_5.4.17 _2020-08-19 #

_5.0.138 _2020-08-19 #