[dev.icinga.com #2890] oracle.sql schema installation script incomplete

[icinga-migration]

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

Created by cprettner on 2012-07-25 14:57:21 +00:00

Assignee: (none)
Status: Resolved (closed on 2012-10-09 15:45:02 +00:00)
Target Version: 1.8
Last Update: 2012-10-09 15:45:02 +00:00 (in Redmine)

Icinga Version: 1.7.1
Icinga Web Version: 1.7.1
IDO Version: 1.7.1
OS Version: UNKNOWN
DB Type: Oracle
DB Version: XE
Browser Version: UNKNOWN

---

Tried to install the oracle.sql in an Oracle XE Database with icinga-web-1.7.1.tar.gz and consider that the installation file was not valid because some objects and parts of the script are missing.

Trigger is not complete in the script below ..

Attachments

• oracle.sql cprettner - 2012-07-25 14:57:21 +00:00

Changesets

2012-10-09 15:43:54 +00:00 by mfriedrich f571367

add create_oracle_sys.sql, revamp oracle.sql a bit (fixes #3052 fixes #2890)

2012-10-10 11:34:53 +00:00 by mhein 069e75d

Changes to oracle schema and user_authid

Fixes missing structures and credentials (refs #2890), enlarged
content length for NsmUser->user_authid (LDAPOU, fixes #2707)

[icinga-migration]

Updated by mfriedrich on 2012-07-30 10:15:01 +00:00

• Subject changed from oracle.sql -schema installation script nicht vollständig to oracle.sql schema installation script incomplete
• Status changed from New to Feedback
• Priority changed from High to Normal
• Target Version deleted 1.7.1

[icinga-migration]

Updated by mfriedrich on 2012-07-30 10:15:09 +00:00

• Target Version set to 1.8

[icinga-migration]

Updated by mhein on 2012-08-28 13:46:19 +00:00

• Icinga Version set to 1
• Icinga Web Version set to 1
• IDO Version set to 1
• OS Version set to UNKNOWN
• DB Type set to Oracle
• DB Version set to XE
• Browser Version set to UNKNOWN

Hi Christof.

Thanks for reporting. Please can you check this agains the current master. I thought this was repaired while ago.

Kind regards,
Marius.

[icinga-migration]

Updated by mfriedrich on 2012-10-09 15:41:36 +00:00

i've made some slight modifications to the script as i have modified thomas' create_oracle_sys.sql from https://wiki.icinga.org/display/howtos/Icinga+and+Oracle+Part3+-+Configuration in order to include it upstream as well.

now it's possible to have your own table and index spaces created by that, referencing there on demand in oracle.sql

[icinga-migration]

Updated by mfriedrich on 2012-10-09 15:45:02 +00:00

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

Applied in changeset f571367.