[dev.icinga.com #5636] create endpoint tables (status, config) and use object_id in status, history tables #1236

icinga-migration · 2014-02-11T19:31:06Z

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

Created by mfriedrich on 2014-02-11 19:31:06 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2014-03-20 18:44:17 +00:00)
Target Version: 0.0.9
Last Update: 2014-09-16 09:19:41 +00:00 (in Redmine)

Rework the 'icinga_node' text column into direct endpoint_object_id and populate the endpoint status table periodically with new information (similar to programstatus).

endpoints (requires new objecttype_id)
endpointstatus

Information should be retrieved using the same method as the IcingaStatusWriter object.

Changesets

2014-02-21 13:14:41 +00:00 by (unknown) cb90728

DB IDO: Add endpoints/endpointstatus tables (WIP).

Refs #5636

2014-02-21 15:49:21 +00:00 by (unknown) 508561c

DB IDO: Add endpoints/endpointstatus tables.

Refs #5636

2014-02-21 16:51:47 +00:00 by (unknown) 7b29ebe

DB IDO: Send endpoint authority for status updates.

Refs #5636

2014-03-04 08:54:58 +00:00 by (unknown) 5e4152d

DB IDO: Clean schema.

Refs #5636

2014-03-07 16:10:43 +00:00 by (unknown) e9aca5f

DB IDO: Add endpoints/endpointstatus tables.

Refs #5636

2014-03-07 16:10:43 +00:00 by (unknown) 1db3868

DB IDO: Send endpoint authority for status updates.

Refs #5636

2014-03-07 16:10:43 +00:00 by (unknown) dcb59ef

DB IDO: Clean schema.

Refs #5636

2014-03-07 16:40:10 +00:00 by (unknown) cc539fc

Move cluster endpoint/jsonrpc functionality into libremote.

Refs #5690
Refs #5636

2014-03-07 16:52:24 +00:00 by (unknown) 53c2b7d

DB IDO: Set is_connected=1 on identity==node.

Refs #5636

2014-03-08 13:44:54 +00:00 by (unknown) e8aa87d

DB IDO: Clean schema.

Refs #5636
Refs #5730

Conflicts:
	components/db_ido_mysql/schema/mysql.sql
	components/db_ido_pgsql/schema/pgsql.sql

2014-03-08 13:45:36 +00:00 by (unknown) 8f95bc8

DB IDO: Add endpoints/endpointstatus tables.

Refs #5636

2014-03-08 13:45:36 +00:00 by (unknown) 3068993

DB IDO: Send endpoint authority for status updates.

Refs #5636

2014-03-08 13:45:36 +00:00 by (unknown) fa48d83

DB IDO: Clean schema.

Refs #5636

2014-03-08 13:45:36 +00:00 by (unknown) d8134db

Move cluster endpoint/jsonrpc functionality into libremote.

Refs #5690
Refs #5636

2014-03-08 13:45:36 +00:00 by (unknown) c02170b

DB IDO: Set is_connected=1 on identity==node.

Refs #5636

2014-03-10 12:33:25 +00:00 by (unknown) 843af71

DB IDO: Add endpoints/endpointstatus tables.

Refs #5636

2014-03-10 12:42:29 +00:00 by (unknown) ac24d15

DB IDO: Send endpoint authority for status updates.

Refs #5636

2014-03-10 12:42:30 +00:00 by (unknown) bf2428e

DB IDO: Clean schema.

Refs #5636

2014-03-10 12:42:31 +00:00 by (unknown) 4c5529f

Move cluster endpoint/jsonrpc functionality into libremote.

Refs #5690
Refs #5636

2014-03-10 12:42:31 +00:00 by (unknown) bad4090

DB IDO: Set is_connected=1 on identity==node.

Refs #5636

2014-03-10 16:15:03 +00:00 by (unknown) 324a2c2

Prepare schema for endpoint object id (tbd).

Refs #5636

2014-03-10 16:15:31 +00:00 by (unknown) 39647a0

DB IDO: Add endpoints/endpointstatus tables.

Refs #5636

2014-03-10 16:15:31 +00:00 by (unknown) f283dca

DB IDO: Send endpoint authority for status updates.

Refs #5636

2014-03-10 16:15:31 +00:00 by (unknown) 81dac37

DB IDO: Clean schema.

Refs #5636

2014-03-10 16:15:31 +00:00 by (unknown) 46aeada

Move cluster endpoint/jsonrpc functionality into libremote.

Refs #5690
Refs #5636

2014-03-10 16:15:31 +00:00 by (unknown) 44ca8bf

DB IDO: Set is_connected=1 on identity==node.

Refs #5636

2014-03-10 16:15:31 +00:00 by (unknown) 2bab4a7

Fix Windows build.

Refs #5636

2014-03-10 16:15:31 +00:00 by (unknown) f89fe86

DB IDO: Additional endpoint object id tables.

Refs #5636

2014-03-19 20:34:52 +00:00 by (unknown) 3768f0d

DB IDO: Add endpoints/endpointstatus tables.

Refs #5636

2014-03-19 20:34:52 +00:00 by (unknown) cc9ed74

DB IDO: Send endpoint authority for status updates.

Refs #5636

2014-03-19 20:34:53 +00:00 by (unknown) 8fd1fc9

DB IDO: Clean schema.

Refs #5636

2014-03-19 20:34:53 +00:00 by (unknown) 77ba404

Move cluster endpoint/jsonrpc functionality into libremote.

Refs #5690
Refs #5636

2014-03-19 20:34:53 +00:00 by (unknown) fed91ee

DB IDO: Set is_connected=1 on identity==node.

Refs #5636

2014-03-19 20:34:53 +00:00 by (unknown) 0e60271

Fix Windows build.

Refs #5636

2014-03-19 20:34:53 +00:00 by (unknown) f505b3c

DB IDO: Additional endpoint object id tables.

Refs #5636

2014-03-20 09:33:42 +00:00 by (unknown) fd5f93a

DB IDO: Add endpoints/endpointstatus tables.

Refs #5636

2014-03-20 09:33:42 +00:00 by (unknown) 1141d6e

DB IDO: Send endpoint authority for status updates.

Refs #5636

2014-03-20 09:33:42 +00:00 by (unknown) b078115

DB IDO: Clean schema.

Refs #5636

2014-03-20 09:33:42 +00:00 by (unknown) 42c1b91

Move cluster endpoint/jsonrpc functionality into libremote.

Refs #5690
Refs #5636

2014-03-20 09:33:42 +00:00 by (unknown) e222159

DB IDO: Set is_connected=1 on identity==node.

Refs #5636

2014-03-20 09:33:42 +00:00 by (unknown) ca9d8f9

Fix Windows build.

Refs #5636

2014-03-20 09:33:42 +00:00 by (unknown) 6d79634

DB IDO: Additional endpoint object id tables.

Refs #5636

2014-03-20 10:36:17 +00:00 by (unknown) b9b3859

DB IDO: Add endpoints/endpointstatus tables.

Refs #5636

2014-03-20 10:36:17 +00:00 by (unknown) 940ae4b

DB IDO: Send endpoint authority for status updates.

Refs #5636

2014-03-20 10:36:17 +00:00 by (unknown) 66e8105

DB IDO: Clean schema.

Refs #5636

2014-03-20 10:36:17 +00:00 by (unknown) 9bc7683

Move cluster endpoint/jsonrpc functionality into libremote.

Refs #5690
Refs #5636

2014-03-20 10:36:17 +00:00 by (unknown) 08d6dc5

DB IDO: Set is_connected=1 on identity==node.

Refs #5636

2014-03-20 10:36:18 +00:00 by (unknown) 0e92ed2

Fix Windows build.

Refs #5636

2014-03-20 10:36:18 +00:00 by (unknown) ffe3510

DB IDO: Additional endpoint object id tables.

Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) 097bb5a

DB IDO: Add endpoints/endpointstatus tables.

Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) fc7d7cc

DB IDO: Send endpoint authority for status updates.

Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) 0264e52

DB IDO: Clean schema.

Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) ea973e5

Move cluster endpoint/jsonrpc functionality into libremote.

Refs #5690
Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) dbee02a

DB IDO: Set is_connected=1 on identity==node.

Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) c1ed614

Fix Windows build.

Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) 6899d96

DB IDO: Additional endpoint object id tables.

Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) dfd08ec

DB IDO: Use node name for local status updates.

Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) b4f0148

DB IDO: Add status/history references from local node to endpoint object.

Refs #5636

2014-03-20 17:03:47 +00:00 by (unknown) a26df23

DB IDO: Add check_source_object_id reference to endpoint objects.

Refs #5810
Refs #5636

2014-03-20 17:53:08 +00:00 by (unknown) 098dbe7

Livestatus: Add endpoints table.

Refs #5636
Refs #5811

2014-03-20 18:15:19 +00:00 by (unknown) 662e6dd

Livestatus: Add check_source to services table.

Refs #5636
Refs #5812

2014-03-20 18:17:15 +00:00 by (unknown) e22d2b7

Documentation: Add schema extensions.

Refs #5636
Refs #5811
Refs #5812

2014-03-20 18:34:05 +00:00 by (unknown) fee9257

Merge branch 'feature/db-endpoints-5636' into next

Fixes #5636
Fixes #5690
Fixes #5810
Fixes #5811
Fixes #5812

2014-03-21 09:18:03 +00:00 by (unknown) bda7e9f

Revert "DB IDO: Add check_source_object_id reference to endpoint objects."

There's not necessarily a 1:1 relation between the check source node
name and the endpoint name.

This reverts commit a26df23e3d55abee4d0bd3c34da49d63702d209f.

Refs #5810
Refs #5636

Signed-off-by: Michael Friedrich <michael.friedrich@netways.de>

Subtasks:

Feature 5810 - add check_source_object_id with reference to the endpoint the checker is running on

Relations:

relates #5470
relates #5444
relates #5438
relates #5636
relates #5636
relates #5636
relates #5636
blocks #5636

The text was updated successfully, but these errors were encountered:

icinga-migration · 2014-02-20T13:44:29Z

Updated by mfriedrich on 2014-02-20 13:44:29 +00:00

Project changed from Icinga 2 to 32
Subject changed from make icinga_node/check_source available in status tables, create cluster node table with status information to create endpoint tables (status, config) and use object_id in status, history tables
Description updated
Category deleted ~~Cluster~~

icinga-migration · 2014-02-21T08:53:19Z

Updated by mfriedrich on 2014-02-21 08:53:19 +00:00

Priority changed from Normal to High

icinga-migration · 2014-02-21T16:55:36Z

Updated by mfriedrich on 2014-02-21 16:55:36 +00:00

tables created, config and status is dumped
status updates trigger authority (endpoint object id) updates
breaks windows with linking to components (see #5690)

TODO

bind signals to authority param in servicedbobject
get endpoint object id and insert into historical tables
fix windows builds (#5690)
drop icinga_node column
update icinga 1.11 schema with final changes
document changes between 0.0.7 and 0.0.8 in #5635

icinga-migration · 2014-03-07T17:24:45Z

Updated by mfriedrich on 2014-03-07 17:24:45 +00:00

missing status tables
comments
downtimes
missing history queries

icinga-migration · 2014-03-10T16:17:27Z

Updated by mfriedrich on 2014-03-10 16:17:27 +00:00

Target Version changed from 0.0.8 to 0.0.9
Done % changed from 0 to 50

This requires additional work. The schema will be prepared with 1.11 and 0.0.8 release but the final implementation will be done with 0.0.9. The authority interface rewrite is causing me headaches for history/status updates in DB IDO.

Furthermore, additional tables/objects for livestatus and statusdat are required as well.

icinga-migration · 2014-03-19T20:44:11Z

Updated by mfriedrich on 2014-03-19 20:44:11 +00:00

only cluster messages provide the authority string, how to deal with local events on the local endpoint? GetIdentity() is reserved for ClusterListener communication.

icinga-migration · 2014-03-20T16:31:51Z

Updated by mfriedrich on 2014-03-20 16:31:51 +00:00

mysql> select oss.name1 as host, oss.name2 as service, oes.name1 as endpoint, es.is_connected as conn from icinga_servicestatus ss join icinga_objects oss on ss.service_object_id=oss.object_id join icinga_endpointstatus es join icinga_objects oes on es.endpoint_object_id=oes.object_id;
+-----------+-----------+----------+------+
| host      | service   | endpoint | conn |
+-----------+-----------+----------+------+
| icinga2b  | cluster   | icinga2a |    0 |
| icinga2b  | cluster   | icinga2b |    1 |
| localhost | disk      | icinga2a |    0 |
| localhost | disk      | icinga2b |    1 |
| localhost | http      | icinga2a |    0 |
| localhost | http      | icinga2b |    1 |
| localhost | icinga    | icinga2a |    0 |
| localhost | icinga    | icinga2b |    1 |
| localhost | load      | icinga2a |    0 |
| localhost | load      | icinga2b |    1 |
| localhost | ping4     | icinga2a |    0 |
| localhost | ping4     | icinga2b |    1 |
| localhost | ping6     | icinga2a |    0 |
| localhost | ping6     | icinga2b |    1 |
| localhost | processes | icinga2a |    0 |
| localhost | processes | icinga2b |    1 |
| localhost | ssh       | icinga2a |    0 |
| localhost | ssh       | icinga2b |    1 |
| localhost | users     | icinga2a |    0 |
| localhost | users     | icinga2b |    1 |
+-----------+-----------+----------+------+
20 rows in set (0.00 sec)

mysql> select oss.name1 as host, oss.name2 as service, oes.name1 as endpoint, es.is_connected as conn from icinga_servicestatus ss join icinga_objects oss on ss.service_object_id=oss.object_id join icinga_endpointstatus es join icinga_objects oes on es.endpoint_object_id=oes.object_id;
+-----------+-----------+----------+------+
| host      | service   | endpoint | conn |
+-----------+-----------+----------+------+
| icinga2b  | cluster   | icinga2a |    1 |
| icinga2b  | cluster   | icinga2b |    1 |
| localhost | disk      | icinga2a |    1 |
| localhost | disk      | icinga2b |    1 |
| localhost | http      | icinga2a |    1 |
| localhost | http      | icinga2b |    1 |
| localhost | icinga    | icinga2a |    1 |
| localhost | icinga    | icinga2b |    1 |
| localhost | load      | icinga2a |    1 |
| localhost | load      | icinga2b |    1 |
| localhost | ping4     | icinga2a |    1 |
| localhost | ping4     | icinga2b |    1 |
| localhost | ping6     | icinga2a |    1 |
| localhost | ping6     | icinga2b |    1 |
| localhost | processes | icinga2a |    1 |
| localhost | processes | icinga2b |    1 |
| localhost | ssh       | icinga2a |    1 |
| localhost | ssh       | icinga2b |    1 |
| localhost | users     | icinga2a |    1 |
| localhost | users     | icinga2b |    1 |
+-----------+-----------+----------+------+
20 rows in set (0.00 sec)

icinga-migration · 2014-03-20T18:44:17Z

Updated by Anonymous on 2014-03-20 18:44:17 +00:00

Status changed from Assigned to Resolved
Done % changed from 0 to 100

Applied in changeset i2:fee925720db35e643ce235530d892c6675c3f4be.

icinga-migration · 2014-09-16T09:19:41Z

Updated by mfriedrich on 2014-09-16 09:19:41 +00:00

Project changed from 32 to Icinga 2
Category set to DB IDO

icinga-migration · 2015-07-08T11:58:01Z

Updated by mfriedrich on 2015-07-08 11:58:01 +00:00

Relates set to 9586

icinga-migration closed this as completed Mar 20, 2014

icinga-migration added enhancement New feature or request area/db-ido Database output labels Jan 17, 2017

icinga-migration added this to the 0.0.9 milestone Jan 17, 2017

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[dev.icinga.com #5636] create endpoint tables (status, config) and use object_id in status, history tables #1236

[dev.icinga.com #5636] create endpoint tables (status, config) and use object_id in status, history tables #1236

icinga-migration commented Feb 11, 2014

icinga-migration commented Feb 20, 2014

icinga-migration commented Feb 21, 2014

icinga-migration commented Feb 21, 2014

icinga-migration commented Mar 7, 2014

icinga-migration commented Mar 10, 2014

icinga-migration commented Mar 19, 2014

icinga-migration commented Mar 20, 2014

icinga-migration commented Mar 20, 2014

icinga-migration commented Sep 16, 2014

icinga-migration commented Jul 8, 2015

[dev.icinga.com #5636] create endpoint tables (status, config) and use object_id in status, history tables #1236

[dev.icinga.com #5636] create endpoint tables (status, config) and use object_id in status, history tables #1236

Comments

icinga-migration commented Feb 11, 2014

icinga-migration commented Feb 20, 2014

icinga-migration commented Feb 21, 2014

icinga-migration commented Feb 21, 2014

icinga-migration commented Mar 7, 2014

icinga-migration commented Mar 10, 2014

icinga-migration commented Mar 19, 2014

icinga-migration commented Mar 20, 2014

icinga-migration commented Mar 20, 2014

icinga-migration commented Sep 16, 2014

icinga-migration commented Jul 8, 2015