Original idea wa to use Docker for this purpose, but it turned out full
featured virtual server will be much better suited for this task due to
the comlexity of the whole environment.

(Redmine issue: #7041)

After this all code related to MongoDB is gone and database migration from MongoDB to PostgreSQL is no longer possible. I have kept the documentation page about migration for now, so that the users can still at least find the information. (Redmine issue: #4225)

This commit contains following work:

* SQL data model for representing IDEA events in PostgreSQL.
* SQL schema for IDEA event table and indices.
* Event storage service - database abstraction layer for working with IDEA events.
* Migration script for converting events from MongoDB collection into PostgreSQL table.

This code is based on initial prototype and work done by Radko Krkoš <radko.krkos@cesnet.cz> and he deserves credit for a lot of research and pilot work.

(Redmine issue: #3734)

PostgreSQL migration: Implemented prototype of SQL storage service to be used both in backend and web GUI modules.

(Redmine issue: #3752)

This commit represents huge amount of work and introduces new Python-based version of Hawat web user interface for Mentat system. It is built on top of the great Flask framework. Currently it is still work in progress and many features are implemented only as dummy stubs, however the core functionality is almost finished. Following is a list of current key features:

  * Focus on modular architecture using Flask`s blueprint feature.
  * Multi-layered configurability (defaults, multiple file overrides).
  * Plugin system.
  * Internationalization support.
  * Support for multiple authentication systems.

This commit provides working albeit hollow starting point for future web interface development. IT IS NOT READY FOR PRODUCTION USAGE!!!

(Redmine issue: #3734,#3361)

Added missing collections, now the initialization method should be complete. (Redmine issue: #3383)

Status display command is fully working, the update command still needs few tweaks and more testing before it can be considered production tool. There is an issue with storing network records into database, because the database is not capable to store IPv6 as 16 byte integers. Because of this the existing query interface in Hawat will not work. For the necesary conversions the typedcol library could be used.

(Redmine issue: #3385)

This commit introduces finished working prototype of mentat-storage.py real-time message processing module including appropriate unit tests and basic documentation work. Key features are possible customization of target database and collection, usage of core database configuration file, which can be overriden with local config file, or command line options. Messages are currently stored in database one by one, however batch processing will possibly be implemented in the future.

(Redmine issues: #3364, #1017 and #3361)