[icinga-checkins] icinga.org: New commits on branch cmaser/fixes

git at icinga.org git at icinga.org
Wed May 12 21:15:52 CEST 2010


URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=adac25f71a1c26564c8932c61c3fa54a1d39bf6a
Merge: 0e0853bcfb65a1f85e0d402100f61d0c505a8af2 3664dc6978fef938df725a29252c6b037ca5df6f
Author: Christoph Maser <cmr at financial.com>
Date:   Wed May 12 21:14:46 2010 +0200

    Merge branch 'master' into cmaser/fixes
    
    Conflicts:
    	module/idoutils/db/mysql/mysql.sql

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=3664dc6978fef938df725a29252c6b037ca5df6f
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue May 11 14:25:05 2010 +0200

    fix for oracle when binding a NULL value on contactnotificationmethods

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=ee0ab2d479f822959dc02daf49eef3c158c210a0
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed May 5 16:07:31 2010 +0200

    minor cleanups to cgiutils.c (Eric Sesterhenn)
    
    fixes #386

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=93e05bff1ac0d66e7e880e4764e68f99f34a723a
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed May 5 15:15:36 2010 +0200

    minor cleanups to icingastats.c (Eric Sesterhenn)
    
    fixes #385

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=0a98462f01f6cdf7b4fda3ad0b78e0c8658f5761
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Thu Apr 29 16:25:04 2010 +0200

    modify string escaping again for mysql, pgsql
    
    needs a rewrite though. the actual solution is not acceptable anymore.
    
    fixes #384

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=32bd11ed15070a9ee2930de4d23c680ce4d28e0d
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Apr 21 22:39:32 2010 +0200

    fix postgres wrong type in service_object_id

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=b497f865b10908b69d6b6ef5605c6b2953ea4b9f
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 19:42:35 2010 +0200

    init script shows config errors option; don't remove pidfile if icinga did not stop in a timely manner
    
    and some minor output improvements.
    
    fixes #341

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=e32c73bf95b05963cf7dcd3e4ae68f308e7b5d03
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 17:54:24 2010 +0200

    If a contactgroup cannot be found, validation now fails correctly (Ton Voon)
    
    fixes #367

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=285fe93e06e541494138a1ffc85124ebdcccd97d
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 17:39:25 2010 +0200

    Fix for choosing next valid time on day of DST change when clocks go one hour backwards (Ton Voon)
    
    fixes #356

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=1c0957dca998e0b0bf0979f87474f7ae9a7a8381
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 16:56:38 2010 +0200

    add syslog output, if ido2db is unable to do initial db query
    
    ido2db now bails out with a telling error message in syslog.
    before it was misleading - ido2db "died" and noboby reflected that error.
    
    fixes #369

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=bb1ff18f489fc2495d84cc52db2028fa7efcbaed
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 16:03:37 2010 +0200

    remove mysql binary selects, use case-sensitive collation instead (William Preston)
    
    The binary selects fail to use indexes, causing poor performance during restart/ reload.
    
    added upgrade path for mysql
    
    fixes #267
    fixes #361
    fixes #365

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=c4bb6a18fa132139b95589000866e4a86afcc687
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 15:09:12 2010 +0200

    change select * into select [*_]id if unused results
    
    fixes #375
    refs #361

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=b369022e264738b159707c8c6666394d92f04e5e
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 14:35:44 2010 +0200

    oracle: ndo2db_get_object_id fails to return existing IDs

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=201b683c0fe0a703057c9683c45100df83d4f111
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 14:32:46 2010 +0200

    ndo2db_get_object_id fails to return existing IDs (William Preston)
    
    fixes #364

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=4d7721a9c1ccc3a62ceab2445795014c3527dfc0
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 14:03:39 2010 +0200

    Host DB inserts use string 'NULL\n' instead of NULL (William Preston)
    
    The initial inserts of host entries into the objects
    table use the string 'NULL' instead of actual null values.
    
    fixes #363

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=6198ab4db9f57eb944ce4e56e1651966e908281b
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Apr 20 13:33:35 2010 +0200

    Spread the list of linked lists thinner (extend objects hash slots) (Opsera Ltd)
    
    fixes #358

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=5bd896a5bced1aa68a7f2569f501f3f6c5e32af3
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Mar 16 00:26:08 2010 +0100

    fix spurious dollar signs added to command_lines
    
    e.g.
    
    define command{
    	command_name	check_bla
    	command_line	check_snmp_int!public!"^Intel\(R\) PRO/1000 MT Network Connection.$"
    	}
    
    gets added a secondary $ delimiter. this fix removes tha behavior.
    it's also one of the debian patches for packaging.
    
    check http://git.debian.org/?p=pkg-nagios/icinga.git;a=summary
    
    fixes #340

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=bb3d7ad7ddeb6ae2900590d7afb7add6b44eea04
Author: Christoph Maser <cmr at financial.com>
Date:   Mon Mar 15 10:39:34 2010 +0100

    remove @VERSION@ and "Last Modified" from sample configs
    This dynamic content in the sample files is very annoying for packaging
    and totally useles, meta info belongs into versioning system and
    changelog not in the config files

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=c828cf0e517e626aba62b5cbc1ed813e9487d746
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Mar 10 15:29:18 2010 +0100

    Revert "add state-based escalation ranges (Mark Gius)"
    
    This reverts commit 186370696e579cd371039dc3adbd9cab2b2acc90.
    
    note: users reporting segfaults, back to a clean master.

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=480949c6ca42990797bca72b6899dd7e2f6c9150
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Mar 10 15:28:30 2010 +0100

    Revert "restructured AUTHORS"
    
    This reverts commit ba4e9c53b2849220ba85297d67854352a2009df7.

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=c5b93a9b4e196b0effc3f6af3a565519192bec3b
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Mar 10 15:28:18 2010 +0100

    Revert "Update Changelog"
    
    This reverts commit d98aeffd20c9d893d06f1492815f679b7b925f40.

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=d98aeffd20c9d893d06f1492815f679b7b925f40
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Mar 8 16:37:15 2010 +0100

    Update Changelog

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=ba4e9c53b2849220ba85297d67854352a2009df7
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Mar 8 16:29:08 2010 +0100

    restructured AUTHORS

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=186370696e579cd371039dc3adbd9cab2b2acc90
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Sun Feb 28 01:08:13 2010 +0100

    add state-based escalation ranges (Mark Gius)
    
            The directives first_notification and last_notification apply to the
            total count of notifications on a particular service or host.  It is
            sometimes desirable to escalate after the Nth critical notification,
            rather than after a total number of N notifications have been sent.
            Service Escalation:
                    first/last_warning_notification
                    first/last_critical_notification
                    first/last_unknown_notification
            Host Escalation:
                    first/last_down_notification
                    first/last_unreachable_notification

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=6adf5098fddee2601960cc767fe8f550520cb77a
Author: Hendrik Baecker <andurin at process-zero.de>
Date:   Sun Mar 7 13:44:58 2010 +0100

    fix contacts name for 900 configparser test

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=d330a7c67ae175cfeee3c13cc1329440d286743e
Author: Hendrik Baecker <andurin at process-zero.de>
Date:   Sun Mar 7 09:21:29 2010 +0100

    Ignore MacOS *.dSYM files

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=8e576b026bb451251bdb4001afd932ab365c273d
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Mar 3 10:29:37 2010 +0100

    Prepare for new release

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=b155ed80c991ee99b4db98a92e0b3c85244d9f2f
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Mar 3 10:22:09 2010 +0100

    prepare docs & sql for 1.0.1

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=292724aed622199075a0cdb02e2ccb54bf6893cb
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Mar 3 09:05:42 2010 +0100

    update specfile for 1.0.1

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=edd71a9db9edbae1c583190085505a579d0d3ba3
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Sun Feb 28 01:36:59 2010 +0100

    add check for NULL for event_list_high
    
    fixes #308

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=eaba666be49950e3be13e55cc032556d4ee1de83
Author: Scott Evans <scott at vk7hse.hobby-site.org>
Date:   Sun Feb 28 12:27:58 2010 +1100

    Modified README

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=a498b1d9f2dcd34d92c38e09854df15e1275f95e
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Fri Feb 26 23:42:58 2010 +0100

    remove dead code

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=daaa98d403cdf0f884ce99aac99c40fa5f9d7a0d
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Feb 23 22:28:18 2010 +0100

    add max_logentries_age and max_acknowledgements_age to ido2db
    
    you can now set those two entries in ido2db.cfg to let ido2db
    clean those tables periodically. By default they are not set.
    
    refs #264
    fixes #296
    fixes #302

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=54defd103cb259f4078f6986152d33984110e7e7
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Feb 23 23:09:12 2010 +0100

    fix oracle sequence issues

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=41fedee925cd269820f29cc3bd3feaa39d021260
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Feb 23 16:55:46 2010 +0100

    fix hoststatatus_update for #300

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=1d25df0f85a76652749e52a5509599b740a09fe3
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Feb 23 16:48:13 2010 +0100

    fix some minor memory leaks
    
    fixes #174

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=beaa08bd64175edc4eaa9438a8fd41df379b6b75
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Feb 23 16:05:21 2010 +0100

    fix segmentation fault crash when a non-existant host or service is passed to the command pipe
    
    fixes #301

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=9a0d5baff02fd76f477d5634dccc2700a0c228a9
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Feb 23 15:14:24 2010 +0100

    fix sending two identical service_status events to neb module
    
    fixes #300

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=304316fb2f7490babf1b7fa14ba28a9dba1f70d9
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Feb 22 23:57:50 2010 +0100

    add --with-oracle-lib for exporting correct LD_LIBRARY_PATH
    
    ... if oracle libs are not within PATH you can use this option

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=ffb4466e58055a64820e62d5653a0d354657c5dd
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Feb 22 13:15:27 2010 +0100

    fix make fullinstall/idoutils, update changelog
    
    make fullinstall w/o enabled idoutils does not complain
    about that anymore. Furthermore make idoutils shows an
    error when trying to compile w/o enabled idoutils.

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=11c1cb106cdfd703eed49629a090d6b4f302f08d
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Feb 17 12:59:01 2010 +0100

    change mysql db engine to innodb
    
    fixes #229

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=8d7ba823176b66bf97ece31b1c760df553f4fe6f
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Feb 15 17:50:32 2010 +0100

    fix wrong brackets set in escalation_codition config check
    
    (did i already mention that i hate that \t coding style for
    ending brackets?)
    
    refs #270

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=7481e6dd4c0fa41fb222571a09697fbfed59306a
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Feb 15 17:12:20 2010 +0100

    change service_check_timeout_state to default unknown
    
    old default was critical, but unknown is a bit more telling,
    because you can't really tell if a timeout will be critical
    or not.
    
    fixes #275

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=ebf6b658a59b56eced8a30e11e9eac54c0349faa
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Fri Feb 12 03:08:33 2010 +0100

    add escalation_condition definition
    
    /*****************************************************************
    * This patch extends the nagios escalation functionality.
    * It is based on nagios release version 3.2.0, affected files are:
    *       base/config.c , base/notifications.c ,
    *       common/objects.c , include/objects.h ,
    *       xdata/xodtemplate.c , xdata/xodtemplate.h
    *
    * All changes are free to use under the GPL
    * 06.01.2010
    * Vitali Voroth, DECOIT GmbH, Germany
    * http://www.decoit.de
    *****************************************************************/
    
    // Introduction
    It is now possible to define an escalation_condition
    (similar to escalation_options [w,u,c,r]).
    
    An escalation with an defined condition will only be escalated if
    the current state of a particular host/service fits the condition.
    One possible usecase for this could be the folowing scenario:
    Think of two different escalations for the same service foo.
    One of them should only escalate when service bar is OK,
    the other should escalate if bar is CRITICAL or WARNING.
    Now think about foo being the main service offered by an company
    and the admin has to react instantly if it is down. Bar could
    be an service indicating if the admin is in the office or at home
    and the escalation would react as following:
    If the admin is in the office, send an email first, after 5 minutes
    send an SMS.
    If the admin is at home, send an SMS fist and after 30 minutes an second
    SMS to the admin and the head of department.
    
    This should be achieved without reloading or restarting the Nagios/Icinga
    service.
    
    // Syntax
    The escalation_condition option is completely optional and can be
    defined for host escalations as well as for service escalations.
    
    The syntax is:
    escalation_condition <condition> ( [ & / | ] <condition> )*
    where <condition> is either:
            host hostname = [u,d,o]
    or
            service hostname.service_description] = [w,u,c,o].
    
    As you can see, the escalation_condition  accepts a list of one or
    more conditions separated by & (logical AND) or | (logical OR).
    The meanings of [w,u,c,o,d] differ a bit from the ones used for
    escalation_options.
            w = WARNING
            u = UNKNOWN
            c = CRITICAL
            o = OK for services or UP for hosts (one could think of ONLINE)
            d = DOWN for hosts
    
    // Example
    define serviceescalation {
            host_name               localhost
            service_description     HTTP
            first_notification      5
            contact_groups          admins, managers
            escalation_condition    host linux=d | service linux.SSH=w,c
            }
    
    This example escalation would be escalated if the HOST 'linux' is DOWN or
    the Service 'linux.SSH' is WARNING or CRITICAL.
    
    --------------------------
    refs #270

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=885dc46a2620b25cc5aa5081d17934de26d58d3d
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Fri Feb 12 01:34:43 2010 +0100

    add service_check_timeout_state	configuration variable (Bill McGonigle)
    
    This patch adds a variable called 'service_check_timeout_state'
    which allows the admin to define the state that is returned
    when a service check times out.
    
    The #ifdef SERVICE_CHECK_TIMEOUTS_RETURN_UNKNOWN was available
    for re-compiling, which works, but then those users are unable
    to keep up with their distro's updates and it may be beyond
    the skill of many.
    
    This patch moves that idea into a variable, allows any of four
    states to be chosen ('critical' remaining the default), and does
    away with the #ifdef (which should be obsolete now).
    
    refs #275

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=36fcbeedbd892b81e9032bf2920c33a1833599ed
Author: Christoph Maser <cmr at financial.com>
Date:   Fri Feb 12 11:02:13 2010 +0100

    remove incorrect extra commas
    
    fixes #278

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=1ffe2495a58ec9dc1c0a1efd4192c9597a0e6e4e
Author: Christoph Maser <cmr at financial.com>
Date:   Fri Feb 5 13:49:26 2010 +0100

    redhat/fedora specific init script using the distro specific functions

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=fa1b85479e0a83c78778bb04d1347972f79560a3
Author: Christoph Maser <cmr at financial.com>
Date:   Fri Feb 5 13:46:49 2010 +0100

    move pid file to icinga specific localstatedir otherwise it can not be
    created if icinga is start as user

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=4657291079ab220ebe2dd61fa0534e6a78e4362c
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Fri Feb 12 00:52:17 2010 +0100

    postpone db connect of threaded housekeeper
    
    it might occur that main and housekeeping thread interfere while
    connect to database. housekeeper now sleeps a short while after startup
    and then does its initialization and working stuff.

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=35d2369bbbb10e07fcb00caf7f894e030719157c
Author: Ton Voon <ton.voon at opsera.com>
Date:   Mon Feb 1 15:37:03 2010 +0000

    Fix for template configurations which use negated wildcards (Tim Wilde)

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=e585d00ad5ade56030220bab09159a2e7d09f4f8
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Thu Feb 11 20:44:09 2010 +0100

    update changelog

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=225bc8b229506de0959a00f724e2029c1cb29b43
Merge: 4e92fa7569bd4ea0f64abd9a8800fc96b54ff0de 2b57e758d3be1cd1f37e906c5ae944e459597f54
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Thu Feb 11 17:45:06 2010 +0100

    Merge branch 'mfriedrich/oracle'
    
    Conflicts:
    
    	module/idoutils/db/mysql/mysql-upgrade-1.0.1.sql
    	module/idoutils/db/mysql/mysql.sql
    	module/idoutils/db/oracle/oracle-drop.sql
    	module/idoutils/db/oracle/oracle-upgrade-1.0.1.sql
    	module/idoutils/db/oracle/oracle.sql
    	module/idoutils/db/pgsql/pgsql-upgrade-1.0.1.sql
    	module/idoutils/db/pgsql/pgsql.sql
    	module/idoutils/include/ido2db.h
    	module/idoutils/src/db.c

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=2b57e758d3be1cd1f37e906c5ae944e459597f54
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Feb 10 19:02:51 2010 +0100

    oracle: add preapred dynamic delete procedures, add upgrade path for 1.0.1
    
    * added 2 procedures for cleaning (dynamic sql)
    	- by table, instance at startup
    	- by table, instance, field, timestamp for periodic
    * prepared statements, binding of key values at runtime
    
    * added upgrade procedure if someone wants to import old data
      into new sequences. check oracle-upgrade-1.0.1.sql for
      more information.
    
    * removed dead code, updated modified dates, name fixes

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=d2560c72a4b6ce90593805eef74aa2cb338bc108
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Feb 10 16:05:51 2010 +0100

    fix threaded cleaner, some oracle modifications
    
    * threaded cleaner gets own db_hello
    	- selects instance_name from database
    	- if not found, return error
    	- if found, insert conninfo and do the config stuff
              like normal db_hello
    * threaded cleaner waits until db_hello returns ok
      otherwise sleeps 5 seconds
    
    * fixed oracle instance_name insert into table instead of instance_id
    
    * added oracle truncate/delete all tables scripts
    
    refs #29,#31

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=c9985f59d3db30b54b6958b0bc04c8f4ea952e53
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Feb 8 21:07:28 2010 +0100

    fix oracle rewrites for other rdbms, add several fixes/features
    
    * add database name in connection msg to syslog
    * fix comment commentdata/downtimedata copypaste failures
    * fix object insert rewrite for mysql/pgsql
    * fix customvariablestatus timestamp
    
    fixes #252,#272

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=0bd29821316f1d758f42a8877b576b96ce1647c6
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Feb 8 03:30:07 2010 +0100

    oracle: fix open cursor bug
    
    anayszed open cursors and the seq.currval select
    statement was never freed. fixed and running fine.

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=cf6c291ca3508e5c06d5ab5d58b76fb39b92cb25
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Mon Feb 8 02:16:46 2010 +0100

    oracle: queries are now prepared and binded, using sequences
    
    There was a significant problem when using triggers on INSERT
    and then having only one sequence for emulated autoincrement.
    So each table has it's own sequence defined, and INSERT queries
    use seq_name.nextval to insert into id.
    
    All queries have been rewritten for Oracle and Prepared Statements
    (see db.c). Except 3 of them which are dynamically to bind (2x DELETE,
    1x SELECT by table_name and field_name).
    All prepared statements are being referenced and binded with values
    before they are executed. This matches for all queries in
    
    dbqueries.c
    dbhandler.c
    db.c
    
    which are SELECT, UPDATE, INSERT, DELETE, MERGE queries.
    
    All prepared statement handles are held in idi while initialialization
    happens in db_hello.
    
    save_customvariables has been modified to hand over normal unix timestamp
    instead of a preformatted query string. This hack was necessary to bind
    those queries too.
    
    Getting cached object ids when comparing name1, name2 was also rewritten
    in order to compare either IS NULL or =value.
    
    The threaded patch has been disabled currently to get Oracle done, will
    be reworked later on.
    
    Current problem to be fixed are too much open cursors originating from
    prepared statements and sequences probably.
    
    But code compiles and runs without exceptions but db errors.

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=4e92fa7569bd4ea0f64abd9a8800fc96b54ff0de
Author: Christoph Maser <cmr at financial.com>
Date:   Fri Feb 5 12:13:07 2010 +0100

    enable index on icinga_logentries.logentry_time so regular queries from
    icinga-web will not do full table scans regularly
    fixes #236

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=f0f84479a42f24d1b66c88dd93d797d9c6bcc4a5
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Fri Feb 5 15:21:34 2010 +0100

    oracle: first steps using sequences and returning into
    
    currently, there's only one autoincrement sequences depending
    on triggers. this performs not well and causes data import
    to be incorrect because the id will be written new.
    
    this attempt creates a sequence for each table, just like autoincrement
    a query needs to write the id with seq_tablename.nextval intsself, while
    returning the id into outside registered variable. this saves one round
    trip regarding the selection of the last inserted id from the sequence.
    
    refs #158

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=dbcfe71539e3638aa9b5f13c0591897fb7f7af94
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Thu Feb 4 16:47:16 2010 +0100

    change directory strcture in module/idoutils/db/
    
    - mysql
    - pgsql
    - oracle
    - scripts
    
    fixes #268

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=6baabcd7a7f3e23dceeeb8d454801d2807898d40
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Thu Feb 4 15:34:00 2010 +0100

    add more indexes for delete/select statements
    
    modified general index names for all 3 rdbms (oracle style
    aka max 30 chars)
    removed mysql-mods.sql since everything has been added

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=95876dd045bcd81849113df4a81b8541f15a0f16
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Thu Feb 4 12:59:13 2010 +0100

    modify index names for pgsql/oracle
    
    mysql takes index names for table, pgsql/oracle need unique names

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=1282d431e5159fd3f13d7167c6696c90d5309a6a
Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Feb 3 19:05:59 2010 +0100

    modify index for delete, change command_line to varchar(1024)
    
    * add proposed delete (startup, periodic) indexes to tables
    * add upgrade path to mysq, pgsql, oracle
    
    * modify command_line column to fit longer input (255 -> 1024)
    
    * add experimental oracle delete (not used this time)

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=16f39db4cce9f8e94c7bba25cd08161fd7ffd0d0
Author: Hendrik Baecker <andurin at process-zero.de>
Date:   Wed Jan 6 16:57:06 2010 +0100

    More cleanups against threaded trimming
    
    ToDo: thread_idi should be declared in handle_connection and provided to the thread
    
    with a data struct
    
    This gives us the possibility to say cleanly good bye for the second db connection

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=57f93b4cc7075ccfd97a2a2ac3299c2e8a691db6
Author: Hendrik Baecker <andurin at process-zero.de>
Date:   Tue Jan 5 16:30:16 2010 +0100

    Added pthread libs to idoutils Makefile

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=593d7360e38fad40f35decbd5653c24d364ad994
Author: Hendrik Baecker <andurin at process-zero.de>
Date:   Tue Jan 5 15:22:53 2010 +0100

    Testing pthread_exit to kill all subthreads

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=cf03973f37cdd46aa56dda2b7f4cb7176f66e90c
Author: Hendrik Baecker <andurin at process-zero.de>
Date:   Tue Nov 24 21:32:37 2009 +0100

    ido2db threaded housekeeping part II
    
    threaded db trimming works fine so far but the thread
    never exits.
    May be it's time to work with some mutexes or other IPC.

URL:    https://git.icinga.org/?p=icinga-core.git/commit/?id=515ec94d9ff8ad02e99a62950d57ed3d42e4f35e
Author: Hendrik Baecker <andurin at process-zero.de>
Date:   Thu Nov 19 22:56:28 2009 +0100

    First threaded steps
    
    Can someone please tell me how to copy this complete idi?!? *grml*





More information about the icinga-checkins mailing list