[dev.icinga.com #1358] Oracle:script for creating icinga db user and rights

[icinga-migration]

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

Created by Tommi on 2011-03-27 20:36:15 +00:00

Assignee: Tommi
Status: Resolved (closed on 2011-05-03 20:17:12 +00:00)
Target Version: 1.4
Last Update: 2014-12-08 14:34:54 +00:00 (in Redmine)

---

there should be a script which creates an oracle user and tablespaces with all rights needed for brand new icinga installations. Afterwards the usual object creation script should be called in one step

Changesets

2011-03-29 09:03:57 +00:00 by mfriedrich cdbdec6

modify version update for recent oracle changes #1358

refs #1358

2011-05-03 20:07:31 +00:00 by Tommi 0fa0b1a

add new database create scripts for oracle,postgresql and mysql #1358
refs #1358

2011-05-03 20:13:20 +00:00 by Tommi 10fd68d

modified for running with new create scripts #1358
refs #1358

2011-05-03 20:59:45 +00:00 by Tommi 874e2ad

includes all patchesi and features in upgrade/*.sql
refs #1354,#1355,#1358,#1363,#1401,#1173

[icinga-migration]

Updated by Tommi on 2011-03-27 20:42:47 +00:00

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

commit df45798
new scripts create_icinga_objects_oracle.sql create_oracle_sys.sql, started by oracle.sql

[icinga-migration]

Updated by mfriedrich on 2011-03-27 20:57:08 +00:00

please create an issue for the docs team (docs tracker) then, adding a. additional info or b. add your wiki guides as seperated url then.

[icinga-migration]

Updated by mfriedrich on 2011-03-29 09:09:53 +00:00

please keep in mind that create_icinga_objects_oracle.sql is referencing the dbversion insert. i've seen that you've create ICINGA_VERSION as variable, but not as define. furthermore, this version is to be set by a regex in the update-version script.

i've now updated oracle.sql and update-version to match that accordingly. you might wanna pull my branch and merge into yours respectively.

$ git checkout master
$ git pull
$ git branch mfriedrich/core origin/mfriedrich/core
$ git checkout mfriedrich/core
$ git pull origin mfriedrich/core
$ git log
$ git checkout tdressler/core
$ git merge mfriedrich/core

i've resolved all conflicts already, so it should fit.

ah yes, and pls use commitmsg like this:

:  #

refs #

or fixes instead of refs. but issues not yet tested should get a 'refs' because redmine triggers on those patterns and automatically resolves/refs those commits.

[icinga-migration]

Updated by mfriedrich on 2011-04-27 16:56:12 +00:00

is this verified working for 1.4?

[icinga-migration]

Updated by Tommi on 2011-05-03 20:17:12 +00:00

• Status changed from Feedback to Resolved

commit 0fa0b1a,10fd68d
new shell scripts in scripts, sql changed
Tested in local (empty) environment only

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:34:54 +00:00

• Project changed from 18 to Core, Classic UI, IDOUtils
• Category changed from 24 to IDOUtils