[dev.icinga.com #32] Implementation of libdbi

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/32

Created by berk on 2009-04-16 16:40:50 +00:00

Assignee: hbaecker
Status: Resolved (closed on 2009-10-19 16:56:17 +00:00)
Target Version: 1.0 RC1
Last Update: 2009-10-19 16:56:17 +00:00 (in Redmine)

---

to be open for other database-systems like oracle, db2 and postgresql

---

Relations:

• relates #108
• relates #32

[icinga-migration]

Updated by berk on 2009-04-23 14:32:57 +00:00

• Assigned to changed from mhein to hbaecker

[icinga-migration]

Updated by hbaecker on 2009-04-23 16:30:56 +00:00

• Status changed from New to Assigned
• Start Date changed from 2009 to 2009
• Done % changed from 0 to 80
• Estimated Hours set to 30

[icinga-migration]

Updated by hbaecker on 2009-05-18 21:01:40 +00:00

libdbi works just fine right now.
I would say idoutils are prepared so far, to handle different database connections.

Next steps are:

• normalize queries as good as possible to fit hopefully all databases
• switch between different query formats for those queries that can't be globalized

[icinga-migration]

Updated by mfriedrich on 2009-05-19 11:45:46 +00:00

Next steps are:
* normalize queries as good as possible to fit hopefully all databases
* switch between different query formats for those queries that can't be globalized

as Michael (Luebben) reported

• table icinga_conninfo -> agent_name = NDOMOD statt IDOMOD
  -> db.c ndo_db_hello(idi) ... idi->agent_name
  will be called ndo_db_query if connection is not established and then inserted into db
  going deeper, agent_name is set by ido2db.c and read from config-file ido2db.cfg (grep agent_name * in /usr/src/icinga-core/module/idoutils/src)
  -> NDO_API_AGENT is defined as #define NDO_API_AGENT "AGENT"
  in idomod.c NDO_API_AGENT points to NDOMOD_NAME
  and there we go it is a local #define it C (wtf?) in idomod.c

#define NDOMOD_VERSION "1.4b8"
#define NDOMOD_NAME "NDOMOD"
#define NDOMOD_DATE "01-03-2009"

• table descriptions with NDO instead of IDO

/usr/src/icinga-core/module/idoutils/db # cat mysql.sql | grep NDO
) ENGINE=MyISAM  COMMENT='NDO2DB daemon connection information';

• rework the code to full ido (cosmetic natuere, but a minor must)

I know I have to start deeper gitting... searching bugs is easy, fixing them in git not that easy...

[icinga-migration]

Updated by mfriedrich on 2009-05-25 13:44:21 +00:00

• Target Version set to 0.8.2

[icinga-migration]

Updated by berk on 2009-05-27 16:11:43 +00:00

related Issue #108

[icinga-migration]

Updated by mfriedrich on 2009-08-13 07:52:15 +00:00

• Target Version changed from 0.8.2 to 0.8.3

Rewrite of INSERT/UPDATE Queries for each RDBM needed. libdbi cannot be used for Oracle, ocilib is our choice.

[icinga-migration]

Updated by mfriedrich on 2009-08-29 13:54:50 +00:00

• Target Version changed from 0.8.3 to 1.0 RC1
• Estimated Hours changed from 30 to 100

since libdbi catches up all preferred rdbms except oracle there is the need of further improvement besides rewriting and preparing the db queries.

postponed to target version 1.0 alpha for a stable release.

[icinga-migration]

Updated by mfriedrich on 2009-10-19 16:56:17 +00:00

• Status changed from Assigned to Resolved
• Done % changed from 80 to 100

libdbi and ocilib are working next to each other. more rdbms do not depend on further libdbi implementation.