[dev.icinga.com #2584] web 1.7 installation

[icinga-migration]

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

Created by Tommi on 2012-05-06 19:51:02 +00:00

Assignee: jmosshammer
Status: Resolved (closed on 2012-10-01 19:27:01 +00:00)
Target Version: 1.8
Last Update: 2012-10-09 15:41:52 +00:00 (in Redmine)

---

Try to install from git sources of today. I found the following points noticable, because i couldnt succeed with installation up to now.
I used following configure:

./configure \
--prefix=/opt/icinga-web \
--with-web-user=apache \
--with-web-group=apache \
--with-db-type=oracle \
--with-db-user=icinga_web \
--with-db-pass=icinga \
--with-db-port=1521 \
--with-db-host=localhost \
--with-db-name=//localhost:1521/xe \
--with-api-cmd-file=/opt/icinga/var/rw/icinga.cmd \
--with-api-subtype=icingaOracle \
--with-api-port=1521 \
--with-api-host=localhost \
--with-api-db-prefix='' \
--with-api-db-user=icinga \
--with-api-db-pass=icinga \
--with-api-db-name=//localhost:1521/xe \
--with-icinga-objects-dir=/opt/icinga/etc/objects \
--with-icinga-bin=/opt/icinga/bin/icinga \
--with-icinga-cfg=/opt/icinga/etc/icinga.cfg \

1. What is the option --with-icinga-objects-dir=/opt/icinga/etc/objects for? This dir is not used in my icinga.cfg. This option looks new in 1.7, but couldnt found in Changelog or somewhere else

2. It checks for mysql, but i configured it with --with-db-type=oracle

3. There is a warning, icinga not found even i select it with --with-icinga-bin. And yes, its there, but not in $PATH and not executable by the user doing the configure

   checking if resource /opt/icinga/etc/objects exists... found
   checking for /opt/icinga/bin/icinga... not found
   configure: WARNING: binary /opt/icinga/bin/icinga not found in PATH
   checking if resource /opt/icinga/etc/icinga.cfg exists... found
   ls -l /opt/icinga/bin
   -rwxrwxr-- 1 icinga icinga 664488 3. Mai 21:14 icinga
   -rwxrwxr-- 1 icinga icinga 44672 3. Mai 21:14 icingastats
   -rwxrwxr-- 1 icinga icinga 548599 3. Mai 21:14 ido2db
   -rwxrwxr-- 1 icinga icinga 41807 3. Mai 21:14 log2ido

4. After configure there is a hint

   Please check the new Apache2 configuration (etc/apache2/icinga-web.conf).

But this is a CentOS system, on which the apache configs are below /etc/httpd. The 'make install-apache-config' command installs it correctly.
5. db-initialize dosnt work This is because i raised the ticket as you requested

icinga-web > db-prepare:

Use the db-user specified in icinga-webs database.xml (Needs create Database/create Table rights)?(n,y)? y

**************************WARNING***********************
 The selected DB driver is only experimental supported! 
 This means you *could* experience problems.
 Please check https://dev.icinga.org/projects/icinga-web/issues
 if you encounter problems and report a bug! Thank you!
********************************************************

icinga-web > db-create:

make: *** [db-initialize] Fehler 255

6. There should be a hint already within the Readme, how to find the sql script to run it manually instead.
   7.To get db-initialize working, you should mention phing as requirement and howto install it

Changesets

2012-05-09 09:46:38 +00:00 by jmosshammer c8b8c96

Fixed wrong paths in makefile, removed unused checks in configure, updated hints
in db-initialize to inform about sql paths and removed oracle from support db-initialize targets
(must be installed via sql files)
refs #2584

2012-05-11 09:50:56 +00:00 by mhein 552b75d

Upgraded oracle SQL initial dump

Thanks Tommi, refs #2584

2012-05-11 13:43:36 +00:00 by jmosshammer b29d187

* Added some hints for database creation (refs #2584)

2012-05-11 13:46:47 +00:00 by jmosshammer fda66e2

Added some hints for database setup (refs #2584)

---

Relations:

• relates #2584

[icinga-migration]

Updated by jmosshammer on 2012-05-09 08:00:11 +00:00

• Status changed from New to Assigned
• Assigned to set to jmosshammer

[icinga-migration]

Updated by jmosshammer on 2012-05-09 09:56:39 +00:00

Thx for testing!

1. This is not used at the moment, so it can be ignored
2. I removed this check completely , as it isn't needed anymore (and doesn't tell us if mysql is set up properly, for this we require the php mysql package)
3. and 4) Fixed this
4. When using db-initialize with oracle the script now aborts and tells you to look at the etc/schema folder for manual installation. Also, this path is now added to the 'experimental' hint
5. You're right, but this should be added to the documentation, as we don't have a classical README
6. Currently, you'll get a warning in configure when PHING is not installed

[icinga-migration]

Updated by Tommi on 2012-05-09 20:18:37 +00:00

OK, configure runs and first start was OK. some remarks again

1. This check is very confusing (at least me)
2. I think you should rember the user to run the db install/update in addition to the review of the apache config
3. I know you have no classical README or INSTALL, but the most classical users dont want to start a browser, especially if they dont have an internet connection ready or have only a nongui screen.
4. Maybe its worth to add the hint, where to get phing, because it is not available via packetmanager.

Some more:
Oracle upgrade scripts looking like copys from mysql. But syntax is different

ALTER TABLE nsm_user DROP INDEX user_email_unique;
                          *
ERROR at line 1:
ORA-00905: missing keyword

Drop index is not an alter table table command in oracle

DROP TABLE IF EXISTS nsm_db_version
              *
ERROR at line 1:
ORA-00933: SQL command not properly ended

(If exists in this context is not allowed)

CREATE TABLE nsm_db_version (id INT, version VARCHAR(32) NOT NULL, modified TIMESTAMP NOT NULL, created TIMESTAMP NOT NULL, PRIMARY KEY(id));
/

Typo: should be VARCHAR2. VARCHAR is deprecated for Years. Oracle will not complain up to now and create this automaticly as varchar2, but this might be changed with the next release

The connect identifiers as given in configure was not working at first time. here i had to change some environments first.
Now it startet and i took some very limited clicks around the cronks. in servicestatus some error popups. in debug log i found

[Wed May  9 22:07:53 2012] [fatal] Uncaught AppKitPHPError: PHP Error oci_execute() [function.oci-execute]: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4864, maximum: 4000) (/opt/icinga-web/lib/doctrine/lib/Doctrine/Adapter/Statement/IcingaOracle.php:457) (/opt/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:59)

[icinga-migration]

Updated by Tommi on 2012-05-10 19:54:56 +00:00

The oracle.sql contains for me some problematic steps. Atleast the final commit is missing. I refreshed my personal version (https://wiki.icinga.org/download/attachments/3047532/create\_icingaweb\_objects-1.7.0.sql). The full schema installation works with this version.

[icinga-migration]

Updated by mhein on 2012-05-11 09:36:54 +00:00

Hi. Thank you.

Can I include the oracle script into our master?

[icinga-migration]

Updated by jmosshammer on 2012-05-11 14:24:53 +00:00

Hi,

thx for the oracle script.
I'll add the hints - a fallback version of phing is delivered (lib/phing, or bin/phing as executable) with the icinga-web packages

[icinga-migration]

Updated by Tommi on 2012-05-14 19:10:48 +00:00

no problem with the script. There is a second script in the wiki which does the SYS part like creating user, grant rights etc., but the current version from Mar 2011 needs a small update regarding tablespaces.

Most of problems looks solved (dont checked the upgrade sql)
But the lob handling is still open. You cant do an implicit cast from clob to string with a size >4000Bytes, you need the OCI lob functions to retrieve it

[icinga-migration]

Updated by mfriedrich on 2012-09-24 12:51:07 +00:00

• Target Version set to 1.8

what's the status of this?

[icinga-migration]

Updated by Tommi on 2012-10-01 19:27:01 +00:00

• Status changed from Assigned to Resolved

Oracle version works fine for me (tested with V1.7.2)
Build my own rpm on top of this

[icinga-migration]

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

• Done % changed from 0 to 100

works.