Task #3383

Task #3374: Migrate all core modules from legacy Mentat

Polish mentat-dbmngr.py module

Added by Jan Mach almost 2 years ago. Updated 7 months ago.

Status:ClosedStart date:03/22/2017
Priority:NormalDue date:
Assignee:Jan Mach% Done:

100%

Category:Development - Core
Target version:2.0

Description

The module is already implemented, however some polishing regarding documentation, optimal configuration and argument handling and general revision should be done.


Related issues

Related to Mentat - Feature #3370: Implement tool for database index creation Closed 03/21/2017

Associated revisions

Revision 634a56cc
Added by Jan Mach over 1 year ago

Fix: Fixed issue in mentat-dbmngr.py script.

When attempted to initialize the database with init command, following error occured:

pymongo.errors.OperationFailure: The field 'background’ is not valid for an id index specification. Specification: { ns: “mentat.accesslogs”, v: 2, background: true, key: { _id: 1 }, name: “_id” }

Problem was with the forced background option of index creation method. This commit is just a half of the fix, configuration file needed to be updated as well. See the next commit. (Redmine issue: #3383)

Revision cbf1a6c9
Added by Jan Mach over 1 year ago

Updated list of all required database collection and their indices.

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

Revision c069dc57
Added by Jan Mach about 1 year ago

Changed mentat-dbmngr.py to work with PostgreSQL instead of MongoDB.

Removed 'status’ and 'profile’ commands. (Redmine issue: #3383)

Revision ba8f12cc
Added by Jan Mach about 1 year ago

Improved mentat-dbmngr.py script.

  • the watchdog time interval is now configurable
  • improved content of watchdog email alert
  • improved module documentation

(Redmine issue: #3383)

Revision 8e7eb1ee
Added by Jan Mach about 1 year ago

Improved script runlog contents for mentat-dbmngr.py module.

(Redmine issue: #3383)

Revision daca7794
Added by Jan Mach 8 months ago

Implemented new database administration commands to mentat-dbmngr.py module.

Implemented reinit-main command for main database schema reinitialization. Implemented fixtures-add and fixtures-remove command for inserting respectively deleting demonstration data objects (user accounts, groups, filters and networks). This will enable use to make demonstration isntallations more easy and smooth. (Redmine issue: #3383,#3387)

Revision b81d58f6
Added by Jan Mach 8 months ago

Feature: The watchdog command in mentat-dbmngr.py module can be executed as Nagios plugin.

It is possible to execute the watchdog command of dbmngr module in a Nagios plugin compatible way, which enables users to monitor health of the system and database via Nagios. The command was also renamed to watchdog-events to enable adding additional watchdog commands. (Redmine issue: #3383)

Revision cc4e40c9
Added by Jan Mach 8 months ago

Implemented new user-add command to mentat-dbmngr.py module.

This command will be very usefull to insert initial admin user account after first Mentat installation. (Redmine issue: #3383,#3387)

History

#1 Updated by Jan Mach over 1 year ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 80

#2 Updated by Jan Mach over 1 year ago

  • Related to Feature #3370: Implement tool for database index creation added

#3 Updated by Jan Mach 7 months ago

  • Status changed from In Progress to Closed
  • % Done changed from 80 to 100

Current state of this module is sufficient for production environment. We are finally releasing 2.0 version of Mentat system, so the period of frantic coding and implementation chaos is over. Any further improvements of this module will be done as they should in separate Redmine issues.

Also available in: Atom PDF