Skip to content
This repository has been archived by the owner on Jan 15, 2019. It is now read-only.

[dev.icinga.com #2096] Web-Store Database Schema Version in Table icinga_dbversion #580

Closed
icinga-migration opened this issue Nov 21, 2011 · 9 comments

Comments

@icinga-migration
Copy link

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

Created by Frankstar on 2011-11-21 09:57:09 +00:00

Assignee: mhein
Status: Resolved (closed on 2012-04-26 14:22:44 +00:00)
Target Version: 1.7
Last Update: 2012-04-27 09:30:02 +00:00 (in Redmine)


It would be helpful für Testing, Upgrading and Troublshooting if we could Read out the Database Schema Version from the Icinga-Web Database.
So Please add the Version from Icinga-Web to the "icinga_dbversion" Table.

Like we can do it for the IDOUtils DB-Schema:

mysql> use icinga;

Database changed

mysql> select * from icinga_dbversion;

+--------------+----------+---------+
| dbversion_id | name   | version |
+--------------+----------+---------+
|           1 | idoutils | 1.5.0   |
+--------------+----------+---------+
1 row in set (0.00 sec)

mysql>

Changesets

2012-04-26 14:21:21 +00:00 by mhein e1b1079

icinga-web's release version in db

changed table nsm_db_version with new fields and changed initial and
update schema scripts to write right version into fixes #2096

Relations:

@icinga-migration
Copy link
Author

Updated by Frankstar on 2011-11-21 10:24:44 +00:00

Just realized my Typo.

There a more ways to include the DB Shema Version.
Create a Table in the icinga_web with the db-version content.

OR

add the content to the icinga Databases - "icinga_dbversion" Table.

@icinga-migration
Copy link
Author

Updated by mhein on 2011-11-21 16:07:06 +00:00

  • Target Version deleted 1.6

Hi.

Sorry. We're on the sprint for version 1.6. I remove the target version to keep in mind for the next releases.

Thanks for your interest.

Kind regards,
Marius.

@icinga-migration
Copy link
Author

Updated by Frankstar on 2011-11-22 08:20:42 +00:00

  • Assigned to set to mfriedrich

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2011-11-22 09:40:38 +00:00

  • Assigned to deleted mfriedrich
  • Target Version set to 1.7

that's considered to be an internal api change as well, so i'll leave it to web devs to changes that for 1.7

@icinga-migration
Copy link
Author

Updated by mhein on 2012-01-19 17:10:21 +00:00

  • Target Version deleted 1.7

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2012-03-26 18:08:46 +00:00

  • Target Version set to 1.7

given the demand in #2462 as well, please consider it for 1.7

@icinga-migration
Copy link
Author

Updated by mhein on 2012-04-18 09:07:09 +00:00

  • Assigned to set to mhein

@icinga-migration
Copy link
Author

Updated by mhein on 2012-04-26 14:22:44 +00:00

  • Status changed from New to Resolved
  • Done % changed from 0 to 100

Applied in changeset e1b1079.

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2012-04-27 09:30:02 +00:00

works, thanks. modified and created seem to be good for idoutils as well.

mysql> select * from nsm_db_version;
+----+-------------------+---------------------+---------------------+
| id | version           | modified            | created             |
+----+-------------------+---------------------+---------------------+
|  1 | icinga-web/v1.7.0 | 2012-04-27 11:28:58 | 2012-04-27 11:28:58 |
+----+-------------------+---------------------+---------------------+
1 row in set (0.00 sec)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant