We're updating the issue view to help you get more done. 

Generic MariaDB plugin for Exportd

Description

Use Case:

One of our users want to create SIP Peers for an Asterisk server out of CMDB objects. SIP Peers in Asterisk are managed in a MariaDB database (https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime). For each SIP peer, an entry in the following three database tables need to be created:

  • ps_aors

  • ps_auths

  • ps_endpoints

Solution:

A generic MariaDB plugin for Exportd can be created, which creates an entry in one or multiple database tables per CMDB object. With this generic approach we can also easy integrate a lot of other external systems, like freeradius, OTRS CMDB, or other systems.

Within an export, DATAGERRY object data should be synced with a specific database table (add missing entries to the table, update existing data, delete non existing data from the table).

A configuration can look like this:

This is also a wish from our community:
https://community.datagerry.com/t/sql-exportd-module/63

Nice to have:

We should check, if we can support other database systems with this exporter:

  • PostgreSQL

  • MS SQL

  • Oracle

Activity

Show:
Michael Batz
October 12, 2020, 3:58 PM

Implementation done for MySQL/MariaDB.

Patrick Kremser
October 13, 2020, 1:37 PM

Tested with inserts into multiple tables and everything works

Michael Batz
October 13, 2020, 1:47 PM

Merged into development

Michael Batz
November 18, 2020, 10:36 AM

Changed the Jira Workflow from DATAGERRY -> DATAGERRY 2.0

Done

Assignee

Michael Batz

Reporter

Michael Batz

Labels

Story Points

5

Tester

None

Sprint

None

Fix versions

Priority

Medium
Configure