tyler.durden/icinga2
1
0
Fork 0
mirror of https://github.com/Icinga/icinga2.git synced 2025-04-08 17:05:25 +02:00
Code Issues Packages Projects Releases Wiki Activity
14,049 Commits 421 Branches 120 Tags
Commit Graph

58 Commits

Author SHA1 Message Date
Julian Brost
23693248d4 Make MySQL schema version in full schema file and upgrade files consistent 
In the 2.12.6 release, the full schema file sets the version to 1.14.3, whereas
the latest available upgrade file 2.11.0.sql sets it to 1.15.0. Therefore, ship
a new upgrade file 2.12.7.sql for all users who imported their schema with
version 2.11.0 or later and never performed an upgrade since then. Their
databases incorrectly state schema version 1.14.3 and is bumped to the correct
version 1.15.0 by the upgrade.

In the 2.13.2 release, the full schema file sets the version to 1.15.0, whereas
the latest available upgrade file 2.13.0.sql sets it to 1.15.1. Therefore,
rename the incorrectly named upgrade file 2.13.1.sql (it was not shipped in
this or any other release so far) to 2.13.3.sql for users who imported their
schema with version 2.13.0 or later and never performed an upgrade since then.
Their databases incorrectly state schema version 1.15.0 and are bumped to the
correct version 1.15.1 by the upgrade.

The full schema is not touched by this commit as for the current branch, this
was already fixed by 815533b334395c0c1007b2de9e6c317fee50713e.
 2021-12-16 15:48:12 +01:00
Alexander Aleksandrovič Klimov
815533b334
Fix IDO MySQL schema version 
... to match the latest upgrade script.
 2021-08-05 13:17:36 +02:00
Alexander A. Klimov
e4bfb4898d IDO MySQL: support larger host and service names 
refs #7472
 2021-07-15 11:16:13 +02:00
Alexander A. Klimov
e9118d6b09 Fix IDO MySQL schema version (as in v2.11 upgrade) 2021-07-05 19:17:53 +02:00
Michael Friedrich
8d071c8d30 DB IDO: Fix upgrade script for 2.11.0 (drop index only if existing) 
fixes #7393
 2019-08-05 13:03:38 +02:00
Michael Friedrich
8a258de9bc
Merge pull request #6734 from leeclemens/remove-redundant-indexes 
db ido: remove redundant mysql indexes
 2019-04-29 09:13:22 +02:00
Michael Friedrich
37b715baf1 Replace a few more copyright strings 2019-02-25 16:30:40 +01:00
Lee Clemens
6418af3f01 dbido: remove redundant mysql indexes 2018-10-26 18:32:21 -04:00
Michael Friedrich
a2cb542a2e icinga.com: Update '*.sql' 2018-10-18 09:41:54 +02:00
Michael Friedrich
f99f5bcf17 Fix wrong schema constraint for fresh 2.8.0 installations 
This fix is only needed for a fresh 2.8.0 setup, older versions
and upgrades to current do not need this (can be applied as idempotent
update).

fixes #5947
 2018-01-16 09:49:46 +01:00
Michael Insel
6eccdff621 Change a bunch more copyright headers for 2018 
This changes more copyright headers for 2018.
 2018-01-08 18:05:12 +01:00
Eric Lippmann
6f6703042e ido: Drop unused instance_id indices from comments, downtimes and their related history tables 2017-11-07 16:37:12 +01:00
Jean Flach
1632415370 Fix commenthistory 
refs #5492
 2017-11-07 16:37:12 +01:00
Jean Flach
30be02bcae Alter DowntimeRemoval behaviour 
This adds an additional index to the downtimehistory and updates the
dbevents in a way that it uses that index
 2017-11-07 16:37:12 +01:00
Andreas Scherbaum
775bee8fe1 Replace http:// links with https:// links where a secure website exists 
Leave out tests and third party tools, and license strings

fixes #5151

Signed-off-by: Michael Friedrich <michael.friedrich@icinga.com>
 2017-04-20 11:33:27 +02:00
Markus Frosch
c34feb1fa5 ido/mysql: Remove timestamp defaults for compliance with MySQL 5.7 
refs #4950
 2017-01-24 17:14:06 +01:00
Markus Frosch
84f9824109 ido/mysql: Fix IDO upgrade compliance against MySQL 5.7 
refs #4950
 2017-01-24 17:13:49 +01:00
Markus Frosch
399827c62e Fix IDO MySQL schema for MySQL >= 5.7 
NOTE: A schema update doesn't seem to be needed, MySQL is updating
internally.

The problem comes up on fresh schema imports on MySQL 5.7.

fixes #13633
 2017-01-11 17:37:17 +01:00
Michael Friedrich
b7caf0820d Ensure that *.icinga.com is used everywhere 
fixes #13897
fixes #13277
 2017-01-10 17:19:12 +01:00
Eric Lippmann
69cb383b34 ido-mysql: Upgrade timestamp columns to default to NULL 
refs #10502
 2016-11-18 11:09:50 +01:00
Eric Lippmann
bdb3f88b25 ido-mysql: Bump schema version to 1.14.2 
refs #10502
 2016-11-18 11:09:50 +01:00
Eric Lippmann
0b9046a030 ido-mysql: Don't set the SQL mode to NO_AUTO_VALUE_ON_ZERO 
This mode is obsolete because timestamp columns now default to NULL instead of '0000-00...'.

refs #10502
 2016-11-18 11:09:50 +01:00
Eric Lippmann
1bb363091c ido-mysql: Change timestamp columns to default to NULL in the schema 
refs #10502
 2016-11-18 11:09:50 +01:00
Eric Lippmann
8a21b4af2f ido-mysql: Add yet empty v2.6.0 schema upgrade script 
refs #10502
 2016-11-18 11:09:50 +01:00
Gunnar Beutner
4dbc07e2bc Improve support for MySQL >=5.7 
fixes #12558
 2016-08-27 10:20:59 +02:00
Gunnar Beutner
2e8d3d3934 Implement support for incremental IDO updates 
fixes #12435
 2016-08-15 14:43:11 +02:00
Rune Darrud
16d1f1893e Fix typo in mysql schema 
fixes #12423
 2016-08-14 13:03:49 +02:00
Michael Friedrich
1ff6939f90 Fix missing MySQL session_token changes 
refs #12258
refs #12288
 2016-08-02 15:05:21 +02:00
Michael Friedrich
cd5c9366cf DB IDO: Use upsert and session token for comment/downtime updates 
refs #12258
fixes #12288
 2016-08-02 14:37:16 +02:00
Michael Friedrich
ce3d7ab973 DB IDO: Do not clear {host,service,contact}group_members tables on restart 
fixes #12210
 2016-07-25 17:10:27 +02:00
Michael Friedrich
ca42b4658a DB IDO: Change alias column to varchar(255) in MySQL 
fixes #10061
 2016-07-07 18:48:09 +02:00
Michael Friedrich
a0a5989181 Add missing index on statehistory table for DB IDO cleanup 
fixes #12107
 2016-07-06 12:17:41 +02:00
Michael Friedrich
7f56a04dd5 DB IDO: Add missing indexes for icinga_endpoints* and icinga_zones* tables 
fixes #10066
 2016-06-22 12:56:24 +02:00
Michael Friedrich
067cb8d283 DB IDO: Fix overflow in current_notification_number column (MySQL) 
fixes #11962
 2016-06-22 12:13:49 +02:00
Michael Friedrich
f10289aa71 DB IDO: Add missing object_id index for icinga_{scheduleddowntime,comments} tables 
fixes #10070
refs #11947
 2016-06-20 17:15:09 +02:00
Michael Friedrich
f610e56a59 DB IDO: Fix missing schema version update in {mysql,pgsql}.sql 
refs #10069
refs #11967
 2016-06-20 16:17:06 +02:00
Lee Clemens
759818d289 DB IDO: Make check_source a varchar(255) column 
fixes #10069

Signed-off-by: Michael Friedrich <michael.friedrich@netways.de>
 2016-06-17 11:03:26 +02:00
Gunnar Beutner
599929b0f6 Update copyright headers for 2016 2016-01-12 08:29:59 +01:00
Michael Friedrich
64c936d387 API Actions: Remove -by-id from actions and require names for comments and downtimes 
The documentation is updated as well. Furthermore actions provide
detailed error information in case of an exception.
Includes DB IDO schema updates.

fixes #10512
 2015-11-06 17:06:12 +01:00
Michael Friedrich
3b902b51e2 Change session_token to integer timestamp 
fixes #10529
 2015-11-05 18:05:30 +01:00
Michael Friedrich
1b9f0a8c77 Add the unique_id for comments/downtimes next to legacy_id to DB IDO 
fixes #10431
 2015-10-30 11:25:07 +01:00
Michael Friedrich
4d784dd075 DB IDO: Add an index for CV session delete 
The DELETE statement might become painfully slow on
large installations.

refs #10436
 2015-10-29 16:18:49 +01:00
Michael Friedrich
cf5735e3df DB IDO: Remove deleted custom variables 
We cannot clear the custom variable tables on startup and then re-insert
all known custom vars. Instead we "fixed" it by leaving them
in the database only updating their value if changed. We certainly
forgot about deleted custom vars at that point.

Since the older fix must stay in place, we'll use a session
token stored in the backend to check whether the custom
variable has been updated/inserted in the current session, or not.
If the session token does not match, the custom vars are deleted
at the end of the config dump. Ugly but fairly the only performant
solution as CVs don't have an object_id.

fixes #10436
 2015-10-29 16:00:06 +01:00
Michael Friedrich
d618762dad Export original attributes in DB IDO and Livestatus 
fixes #10392
 2015-10-22 15:49:42 +02:00
Michael Friedrich
dcef213c8f Fix overflow in freshness_threshold column (smallint) w/ DB IDO MySQL 
fixes #9576
 2015-07-14 18:20:08 +02:00
Michael Friedrich
a788de679c DB IDO: Add zones, zonestatus tables 
refs #9286
 2015-07-14 18:09:24 +02:00
Michael Friedrich
0c0f53bc36 Fix schema version 1.14.0 
refs #9027
 2015-05-04 11:35:41 +02:00
Eric Lippmann
1e0df43127 Add yet empty MySQL schema upgrade to IDO version 1.14.0 
refs #9027
 2015-05-04 11:35:41 +02:00
Michael Friedrich
37bf9d4819 DB IDO: Fix header in sql files 2015-02-12 13:59:19 +01:00
Michael Friedrich
9d97094390 DB IDO: Fix duplicate entries in {host,service}depencencies table 
fixes #7765
 2015-02-12 13:19:27 +01:00