Skip to content
This repository has been archived by the owner. 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
Member

@icinga-migration icinga-migration commented Nov 21, 2011

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Nov 21, 2011

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Nov 21, 2011

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Nov 22, 2011

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

  • Assigned to set to mfriedrich
@icinga-migration

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Nov 22, 2011

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Jan 19, 2012

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

  • Target Version deleted 1.7
@icinga-migration

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Mar 26, 2012

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Apr 18, 2012

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

  • Assigned to set to mhein
@icinga-migration

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Apr 26, 2012

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Apr 27, 2012

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
1 participant
You can’t perform that action at this time.