Merge stable to develop

Merge stable to develop

…n-MSS#2431)

Enhancing the functionality of the MSColab server to allow users to upload small images which would replace generic initials as identifiers during login. This feature personalizes user accounts and significantly enhances the visual aspect of user identification and interaction within the MSColab platform.

Co-authored-by: Aryan Gupta <work.aryangupta@gmail.com>

Merge stable to develop

With this flask-migrate is used on application setup to automatically
migrate the configured database to the latest revision shipped with
MSColab. This will make manual migrations in production environments
unnecessary in the future.

Also included is an upgrade path from databases which were previously
manually managed. This entails generating a new database and copying
over all data.

Bumps [benc-uk/workflow-dispatch](https://github.com/benc-uk/workflow-dispatch) from 1.2.3 to 1.2.4.
- [Release notes](https://github.com/benc-uk/workflow-dispatch/releases)
- [Commits](benc-uk/workflow-dispatch@v1.2.3...v1.2.4)

---
updated-dependencies:
- dependency-name: benc-uk/workflow-dispatch
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

When inserting rows into PostgreSQL tables and explicitly setting values
for e.g. auto-increment columns, like the IDs, the associated sequences
aren't automatically updated. This means that without explicitly fixing
the sequences PostgreSQL would try to insert new rows with existing
values for the IDs, failing in the process due to unique constraints.

This issue doesn't affect MariaDB nor SQLite. The former automatically
updates auto-increment counters on insert, the latter simply uses the
last rows ID as a starting point.

This change also extends the tests to try adding a new user after the
migration, which should catch this kind of issue.

Created enum types should also be dropped on downgrade. Dropping tables
must be committed to become visible.

* removing pinned xmlschema (Open-MSS#2117)

* Stop ignoring some test files (Open-MSS#2291)

* Reconfigured tutorial videos for RTFD (Open-MSS#2458)

* changed to videos/

* use mss style on rtfd

* fix urls and text (Open-MSS#2460)

* Bump benc-uk/workflow-dispatch from 1.2.3 to 1.2.4 (Open-MSS#2450)

Bumps [benc-uk/workflow-dispatch](https://github.com/benc-uk/workflow-dispatch) from 1.2.3 to 1.2.4.
- [Release notes](https://github.com/benc-uk/workflow-dispatch/releases)
- [Commits](benc-uk/workflow-dispatch@v1.2.3...v1.2.4)

---
updated-dependencies:
- dependency-name: benc-uk/workflow-dispatch
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* Limit video width to the containing block's width (Open-MSS#2463)

* pinning of libtiff is not needed but blocks a more recent libxml2 and others (Open-MSS#2469)

* fixed the model.Message description and tests now using op_id (Open-MSS#2470)

* bug fix for incomplete xml imports (Open-MSS#2468)

validate xml content

* prepare v9.2.0 (Open-MSS#2481)

---------

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: Matthias Riße <9308656+matrss@users.noreply.github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

This reverts commit 2c89c79.

Merge stable to develop

Enhancing the functionality of the MSColab server to allow users to upload small images which would replace generic initials as identifiers during login. This feature personalizes user accounts and significantly enhances the visual aspect of user identification and interaction within the MSColab platform.

This includes real-time tracking of active users per operation, enhancing the chat window, seeing who performed what changes and separating system message from user messages.


---------

Co-authored-by: Aryan Gupta <work.aryangupta@gmail.com>

Show in About a new version available.


---------

Co-authored-by: Matthias Riße <9308656+matrss@users.noreply.github.com>

removed the xmlsec binary selector based on CONDA_PREFIX
provided separate config for msidp
separate dir for mscolab server data and work asynchronously by msolab ui


---------

Co-authored-by: Matthias Riße <9308656+matrss@users.noreply.github.com>

* Further refactoring to simplify control flow

Fewer LOC to make things more maintanable.
Also Fix Open-MSS#2514

* Handle Exceptions at the outer level, so no unforeseen errors occur.
Also catch uncaught SocketIO-Exceptions to handle them gracefully.

* better solution

Merge stable to develop

…S#2528)

* option to enable flask debug added

* remove mscolab start from batch

* similiar dir as for the ui

* new module for mscolab restart

* linting satisfied

* join for recording

* fixes Open-MSS#2539

* spelling

* Further refactoring of mscolab

* Move (most) communication with server to ConnectionManager class to have
  consistent calls and error handling (e.g. timeout).
* More consistently use json() method of response.
* Removed single letter variables.

* Update mscolab_exceptions.py

update copyright string

---------

Co-authored-by: ReimarBauer <rb.proj@gmail.com>

* Further refactoring of mscolab

* Move (most) communication with server to ConnectionManager class to have
  consistent calls and error handling (e.g. timeout).
* More consistently use json() method of response.
* Removed single letter variables.

* Update mscolab_exceptions.py

update copyright string

---------

Co-authored-by: ReimarBauer <rb.proj@gmail.com>

**Purpose of PR?**:

Fixes #

**Does this PR introduce a breaking change?**

**If the changes in this PR are manually verified, list down the scenarios covered:**:

**Additional information for reviewer?** :
_Mention if this PR is part of any design or a continuation of previous PRs_

**Does this PR results in some Documentation changes?**
_If yes, include the list of Documentation changes_

**Checklist:**
- [ ] Bug fix. Fixes #<issue number>
- [ ] New feature (Non-API breaking changes that adds functionality)
- [ ] PR Title follows the convention of  `<type>: <subject>`
- [ ] Commit has unit tests

<!--

The PR title message must follow convention:
`<type>: <subject>`.

Where: <br />
- `type` is to define what type of PR is this.
  Most common types are:
    - `feat`      - for new features, not a new feature for build script
    - `fix`       - for bug fixes or improvements, not a fix for build script
    - `chore`     - changes not related to production code
    - `docs`      - changes related to documentation
    - `style`     - formatting, missing semi colons, linting fix etc; no significant production code changes
    - `test`      - adding missing tests, refactoring tests; no production code change
    - `refactor`  - refactoring production code, eg. renaming a variable or function name, there should not be any significant production code changes

- `subject` is a single line brief description of the changes made in the pull request.

-->