search

salopensource / sal

Modular reporting for Endpoints
Apache License 2.0
213 stars 63 forks source link

Empty conditions seems to break the DB #55

Closed ygini closed 8 years ago

ygini commented 8 years ago

--- Too quick to hit enter, sorry ---

I've a munki condition who report the license version for Office, it test the existence of license v1 or v2 file and report 2011, 2016 or no value.

It's the only condition I use actually.

It seems to break SAL with the following error.

[30/May/2016 12:33:22] ERROR [django.request:256] Internal Server Error: /checkin/
Traceback (most recent call last):
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/core/handlers/base.py", line 132, in get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/views/decorators/csrf.py", line 58, in wrapped_view
    return view_func(*args, **kwargs)
  File "/mnt/data/www/sal_env/sal/server/views.py", line 1884, in checkin
    condition.save()
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/base.py", line 734, in save
    force_update=force_update, update_fields=update_fields)
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/base.py", line 762, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/base.py", line 846, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/base.py", line 885, in _do_insert
    using=using, raw=raw)
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/manager.py", line 127, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/query.py", line 920, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 974, in execute_sql
    cursor.execute(sql, params)
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 129, in execute
    six.reraise(utils.IntegrityError, utils.IntegrityError(*tuple(e.args)), sys.exc_info()[2])
  File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 124, in execute
    return self.cursor.execute(query, args)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
IntegrityError: (1048, "Column 'condition_data' cannot be null")
grahamgilbert commented 8 years ago

But is it not impossible for a Munki run to not produce conditions? There are several built in ones. 

Sent from my iPhone

On Mon, May 30, 2016 at 7:13 AM -0700, "Yoann Gini" notifications@github.com wrote:

[30/May/2016 12:33:22] ERROR [django.request:256] Internal Server Error: /checkin/ Traceback (most recent call last): File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/core/handlers/base.py", line 132, in get_response response = wrapped_callback(request, _callback_args, _callback_kwargs) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/views/decorators/csrf.py", line 58, in wrapped_view return view_func(_args, _kwargs) File "/mnt/data/www/sal_env/sal/server/views.py", line 1884, in checkin condition.save() File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/base.py", line 734, in save force_update=force_update, update_fields=update_fields) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/base.py", line 762, in save_base updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/base.py", line 846, in _save_table result = self._do_insert(cls._base_manager, using, fields, update_pk, raw) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/base.py", line 885, in _do_insert using=using, raw=raw) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/manager.py", line 127, in manager_method return getattr(self.get_queryset(), name)(_args, _kwargs) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/query.py", line 920, in _insert return query.get_compiler(using=using).execute_sql(return_id) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 974, in execute_sql cursor.execute(sql, params) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 129, in execute six.reraise(utils.IntegrityError, utils.IntegrityError(tuple(e.args)), sys.exc_info()[2]) File "/mnt/data/www/sal_env/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 124, in execute return self.cursor.execute(query, args) File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue IntegrityError: (1048, "Column 'condition_data' cannot be null")

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

ygini commented 8 years ago

I'm not sure to understand what you mean.

grahamgilbert commented 8 years ago

You need to share your managed installs plist so I can see what data you are sending to the server. 

Sent from my iPhone

On Mon, May 30, 2016 at 7:27 AM -0700, "Yoann Gini" notifications@github.com wrote:

I'm not sure to understand what you mean.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

gregneagle commented 8 years ago

Even if you provide no admin-provided scripts to generate additional conditions -- Munki itself has a bunch of built-in "facts" it generates/uses for conditional items. See https://github.com/munki/munki/wiki/Conditional-Items#built-in-conditions

ygini commented 8 years ago

Here is some sample from different workstation

    os_vers_patch = 5
    os_vers_minor = 11
    machine_type = laptop
    catalogs = Array {
        development
        testing
    }
    ipv4_address = Array {
        10.2.12.24
    }
    hostname = mac-010.local
    munki_version = 2.7.0.2753
    os_vers = 10.11.5
    machine_model = MacBookAir6,2
    date = Mon May 30 19:00:59 CET 2016
    arch = x86_64
    os_vers_major = 10
    OfficeLicenseVersion = 2011
    x86_64_capable = true
}

Dict {
    os_vers_patch = 5
    os_vers_minor = 11
    machine_type = desktop
    catalogs = Array {
        development
        testing
    }
    ipv4_address = Array {
        10.2.12.14
    }
    hostname = mac-012.local
    munki_version = 2.7.0.2753
    os_vers = 10.11.5
    machine_model = iMac12,1
    date = Mon May 30 19:19:09 CET 2016
    arch = x86_64
    os_vers_major = 10
    OfficeLicenseVersion = 2011
    x86_64_capable = true
}

Dict {
    os_vers_patch = 5
    os_vers_minor = 11
    machine_type = laptop
    catalogs = Array {
        development
        testing
    }
    ipv4_address = Array {
        10.2.12.149
    }
    hostname = mac-013.local
    munki_version = 2.7.0.2753
    os_vers = 10.11.5
    machine_model = MacBookPro9,2
    date = Mon May 30 19:40:46 CET 2016
    arch = x86_64
    os_vers_major = 10
    OfficeLicenseVersion = 2011
    x86_64_capable = true
}

Dict {
    os_vers_patch = 5
    os_vers_minor = 11
    machine_type = laptop
    catalogs = Array {
        development
        testing
    }
    ipv4_address = Array {
        10.2.12.19
    }
    hostname = mac-016.local
    munki_version = 2.7.0.2753
    os_vers = 10.11.5
    machine_model = MacBookPro8,2
    date = Mon May 30 19:34:26 CET 2016
    arch = x86_64
    os_vers_major = 10
    OfficeLicenseVersion = 2011
    x86_64_capable = true
}

Dict {
    os_vers_patch = 5
    os_vers_minor = 11
    machine_type = laptop
    catalogs = Array {
        development
        testing
    }
    ipv4_address = Array {
        10.2.12.70
    }
    hostname = mac-020.local
    munki_version = 2.7.0.2753
    os_vers = 10.11.5
    machine_model = MacBookAir6,2
    date = Mon May 30 19:30:13 CET 2016
    arch = x86_64
    os_vers_major = 10
    x86_64_capable = true
}

Dict {
    os_vers_patch = 5
    os_vers_minor = 11
    machine_type = laptop
    catalogs = Array {
        development
        testing
    }
    ipv4_address = Array {
        10.2.12.40
    }
    hostname = mac-025.local
    munki_version = 2.7.0.2753
    os_vers = 10.11.5
    machine_model = MacBookAir6,2
    date = Mon May 30 19:10:48 CET 2016
    arch = x86_64
    os_vers_major = 10
    OfficeLicenseVersion = 2011
    x86_64_capable = true
}
grahamgilbert commented 8 years ago

Please send the full unedited plist. 

Sent from my iPhone

On Mon, May 30, 2016 at 8:46 AM -0700, "Yoann Gini" notifications@github.com wrote:

Here is some sample from different workstation

os_vers_patch = 5
os_vers_minor = 11
machine_type = laptop
catalogs = Array {
    development
    testing
}
ipv4_address = Array {
    10.2.12.24
}
hostname = mac-010.local
munki_version = 2.7.0.2753
os_vers = 10.11.5
machine_model = MacBookAir6,2
date = Mon May 30 19:00:59 CET 2016
arch = x86_64
os_vers_major = 10
OfficeLicenseVersion = 2011
x86_64_capable = true

}

Dict { os_vers_patch = 5 os_vers_minor = 11 machine_type = desktop catalogs = Array { development testing } ipv4_address = Array { 10.2.12.14 } hostname = mac-012.local munki_version = 2.7.0.2753 os_vers = 10.11.5 machine_model = iMac12,1 date = Mon May 30 19:19:09 CET 2016 arch = x86_64 os_vers_major = 10 OfficeLicenseVersion = 2011 x86_64_capable = true }

Dict { os_vers_patch = 5 os_vers_minor = 11 machine_type = laptop catalogs = Array { development testing } ipv4_address = Array { 10.2.12.149 } hostname = mac-013.local munki_version = 2.7.0.2753 os_vers = 10.11.5 machine_model = MacBookPro9,2 date = Mon May 30 19:40:46 CET 2016 arch = x86_64 os_vers_major = 10 OfficeLicenseVersion = 2011 x86_64_capable = true }

Dict { os_vers_patch = 5 os_vers_minor = 11 machine_type = laptop catalogs = Array { development testing } ipv4_address = Array { 10.2.12.19 } hostname = mac-016.local munki_version = 2.7.0.2753 os_vers = 10.11.5 machine_model = MacBookPro8,2 date = Mon May 30 19:34:26 CET 2016 arch = x86_64 os_vers_major = 10 OfficeLicenseVersion = 2011 x86_64_capable = true }

Dict { os_vers_patch = 5 os_vers_minor = 11 machine_type = laptop catalogs = Array { development testing } ipv4_address = Array { 10.2.12.70 } hostname = mac-020.local munki_version = 2.7.0.2753 os_vers = 10.11.5 machine_model = MacBookAir6,2 date = Mon May 30 19:30:13 CET 2016 arch = x86_64 os_vers_major = 10 x86_64_capable = true }

Dict { os_vers_patch = 5 os_vers_minor = 11 machine_type = laptop catalogs = Array { development testing } ipv4_address = Array { 10.2.12.40 } hostname = mac-025.local munki_version = 2.7.0.2753 os_vers = 10.11.5 machine_model = MacBookAir6,2 date = Mon May 30 19:10:48 CET 2016 arch = x86_64 os_vers_major = 10 OfficeLicenseVersion = 2011 x86_64_capable = true }

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

ygini commented 8 years ago

Without 2011 or 2016 full time licence:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
    <key>AppleUpdates</key>
    <array>
        <dict>
            <key>apple_product_name</key>
            <string>Mise à jour des logiciels d’imprimantes Ricoh</string>
            <key>description</key>
            <string>&lt;!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"&gt;
&lt;html&gt;
&lt;head&gt;
  &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt;
  &lt;meta http-equiv="Content-Style-Type" content="text/css"&gt;
  &lt;title&gt;&lt;/title&gt;
  &lt;meta name="Generator" content="Cocoa HTML Writer"&gt;
  &lt;meta name="CocoaVersion" content="824.41"&gt;
  &lt;style type="text/css"&gt;
    p.p1 {font: 11.0px Lucida Grande;}
  &lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;p class="p1"&gt;Cette mise à jour installe les logiciels les plus récents pour votre scanneur ou imprimante Ricoh.&lt;/p&gt;
&lt;p class="p1"&gt;Pour en savoir plus sur les logiciels pour imprimantes et scanneurs, visitez &lt;a href="http://support.apple.com/kb/HT3669?viewlocale=fr_FR"&gt;http://support.apple.com/kb/HT3669?viewlocale=fr_FR&lt;/a&gt;&lt;/p&gt;
&lt;/body&gt;
&lt;/html&gt;
</string>
            <key>display_name</key>
            <string>Mise à jour des logiciels d’imprimantes Ricoh</string>
            <key>installed_size</key>
            <integer>27508</integer>
            <key>name</key>
            <string>031-06624</string>
            <key>productKey</key>
            <string>031-06624</string>
            <key>version_to_install</key>
            <string>2.5</string>
        </dict>
        <dict>
            <key>apple_product_name</key>
            <string>Mise à jour des logiciels d’imprimantes Ricoh</string>
            <key>description</key>
            <string>&lt;!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"&gt;
&lt;html&gt;
&lt;head&gt;
  &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt;
  &lt;meta http-equiv="Content-Style-Type" content="text/css"&gt;
  &lt;title&gt;&lt;/title&gt;
  &lt;meta name="Generator" content="Cocoa HTML Writer"&gt;
  &lt;meta name="CocoaVersion" content="824.41"&gt;
  &lt;style type="text/css"&gt;
    p.p1 {font: 11.0px Lucida Grande;}
  &lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;p class="p1"&gt;Cette mise à jour installe les logiciels les plus récents pour votre scanneur ou imprimante Ricoh.&lt;/p&gt;
&lt;p class="p1"&gt;Pour en savoir plus sur les logiciels pour imprimantes et scanneurs, visitez &lt;a href="http://support.apple.com/kb/HT3669?viewlocale=fr_FR"&gt;http://support.apple.com/kb/HT3669?viewlocale=fr_FR&lt;/a&gt;&lt;/p&gt;
&lt;/body&gt;
&lt;/html&gt;
</string>
            <key>display_name</key>
            <string>Mise à jour des logiciels d’imprimantes Ricoh</string>
            <key>installed_size</key>
            <integer>34092</integer>
            <key>name</key>
            <string>031-07834</string>
            <key>productKey</key>
            <string>031-07834</string>
            <key>version_to_install</key>
            <string>3.0</string>
        </dict>
    </array>
    <key>AvailableDiskSpace</key>
    <integer>217601860</integer>
    <key>Conditions</key>
    <dict>
        <key>arch</key>
        <string>x86_64</string>
        <key>catalogs</key>
        <array>
            <string>development</string>
            <string>testing</string>
        </array>
        <key>date</key>
        <date>2016-05-30T16:29:02Z</date>
        <key>hostname</key>
        <string>mac-006.local</string>
        <key>ipv4_address</key>
        <array>
            <string>10.2.12.165</string>
        </array>
        <key>machine_model</key>
        <string>MacBookAir7,2</string>
        <key>machine_type</key>
        <string>laptop</string>
        <key>munki_version</key>
        <string>2.7.0.2753</string>
        <key>os_vers</key>
        <string>10.11.5</string>
        <key>os_vers_major</key>
        <integer>10</integer>
        <key>os_vers_minor</key>
        <integer>11</integer>
        <key>os_vers_patch</key>
        <integer>5</integer>
        <key>serial_number</key>
        <string>C1XXXX0WG944</string>
        <key>x86_64_capable</key>
        <true/>
    </dict>
    <key>ConsoleUser</key>
    <string>test</string>
    <key>EndTime</key>
    <string>2016-05-30 14:32:29 +0000</string>
    <key>Errors</key>
    <array/>
    <key>InstallResults</key>
    <array>
        <dict>
            <key>applesus</key>
            <false/>
            <key>display_name</key>
            <string>Microsoft Office 2016 pour Mac</string>
            <key>download_kbytes_per_sec</key>
            <integer>54844</integer>
            <key>duration_seconds</key>
            <integer>146</integer>
            <key>name</key>
            <string>Office2016Suite</string>
            <key>status</key>
            <integer>0</integer>
            <key>time</key>
            <date>2016-05-30T14:32:18Z</date>
            <key>unattended</key>
            <false/>
            <key>version</key>
            <string>15.22.0</string>
        </dict>
        <dict>
            <key>applesus</key>
            <true/>
            <key>name</key>
            <string>Mise à jour des logiciels d’imprimantes Ricoh</string>
            <key>productKey</key>
            <string>031-06624</string>
            <key>status</key>
            <integer>0</integer>
            <key>time</key>
            <date>2016-05-30T14:32:29Z</date>
            <key>version</key>
            <string>2.5</string>
        </dict>
        <dict>
            <key>applesus</key>
            <true/>
            <key>name</key>
            <string>Mise à jour des logiciels d’imprimantes Ricoh</string>
            <key>productKey</key>
            <string>031-07834</string>
            <key>status</key>
            <integer>0</integer>
            <key>time</key>
            <date>2016-05-30T14:32:29Z</date>
            <key>version</key>
            <string>3.0</string>
        </dict>
    </array>
    <key>InstalledItems</key>
    <array>
        <string>FusionInventory_CORP</string>
        <string>RootCert AD</string>
        <string>sal_scripts</string>
        <string>AdobeFlashPlayer</string>
        <string>Firefox</string>
        <string>GoogleChrome</string>
        <string>GoToMeeting</string>
        <string>Hello IT</string>
        <string>HelloITResetScriptForOffice</string>
        <string>munkitools_launchd</string>
        <string>munkitools_core</string>
        <string>munkitools_admin</string>
        <string>munkitools</string>
        <string>OfficeLicenseVersionMunkiCondition</string>
        <string>OracleJava8</string>
        <string>Ricoh_PS_Printers_Vol1_EXP_LIO_Driver</string>
        <string>Ricoh_Open_Space</string>
        <string>Silverlight</string>
        <string>Skype</string>
        <string>StuffItExpander</string>
        <string>TheUnarchiver</string>
        <string>UnRarX</string>
        <string>VLC</string>
        <string>Prism</string>
    </array>
    <key>ItemsToInstall</key>
    <array>
        <dict>
            <key>blocking_applications</key>
            <array>
                <string>Microsoft Autoupdate</string>
                <string>Microsoft Outlook</string>
                <string>Microsoft Excel</string>
                <string>Microsoft PowerPoint</string>
                <string>Microsoft Word</string>
                <string>Microsoft OneNote</string>
            </array>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>Microsoft Office 2016 pour Mac</string>
            <key>download_kbytes_per_sec</key>
            <integer>54844</integer>
            <key>installed</key>
            <false/>
            <key>installed_size</key>
            <integer>7105368</integer>
            <key>installer_item</key>
            <string>Office2016Suite-15.22.0.pkg</string>
            <key>installer_item_size</key>
            <integer>1480809</integer>
            <key>name</key>
            <string>Office2016Suite</string>
            <key>version_to_install</key>
            <string>15.22.0</string>
        </dict>
    </array>
    <key>ItemsToRemove</key>
    <array/>
    <key>MachineInfo</key>
    <dict>
        <key>arch</key>
        <string>x86_64</string>
        <key>hostname</key>
        <string>mac-006.local</string>
        <key>ipv4_address</key>
        <array>
            <string>10.2.12.165</string>
        </array>
        <key>machine_model</key>
        <string>MacBookAir7,2</string>
        <key>munki_version</key>
        <string>2.7.0.2753</string>
        <key>os_vers</key>
        <string>10.11.5</string>
        <key>serial_number</key>
        <string>C1XXXX0WG944</string>
        <key>x86_64_capable</key>
        <true/>
    </dict>
    <key>ManagedInstallVersion</key>
    <string>2.7.0.2753</string>
    <key>ManagedInstalls</key>
    <array>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>Agent Fusion Inventory</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>54752</integer>
            <key>installed_version</key>
            <string>2.3.17</string>
            <key>name</key>
            <string>FusionInventory_CORP</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>RootCert AD</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>2</integer>
            <key>installed_version</key>
            <string>1.0</string>
            <key>name</key>
            <string>RootCert AD</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Client side scripts for Sal.</string>
            <key>display_name</key>
            <string>sal_scripts</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>246</integer>
            <key>installed_version</key>
            <string>1.0.2</string>
            <key>name</key>
            <string>sal_scripts</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Adobe® Flash® Player is a cross-platform browser-based application runtime that delivers uncompromised viewing of expressive applications, content, and videos across screens and browsers.</string>
            <key>display_name</key>
            <string>Adobe Flash Player</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>18096</integer>
            <key>installed_version</key>
            <string>21.0.0.242</string>
            <key>name</key>
            <string>AdobeFlashPlayer</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Mozilla Firefox is a free and open source web browser.</string>
            <key>display_name</key>
            <string>Mozilla Firefox</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>85047</integer>
            <key>installed_version</key>
            <string>46.0.1</string>
            <key>name</key>
            <string>Firefox</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Chrome is a fast, simple, and secure web browser, built for the modern web.</string>
            <key>display_name</key>
            <string>Google Chrome</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>66156</integer>
            <key>installed_version</key>
            <string>50.0.2661.102</string>
            <key>name</key>
            <string>GoogleChrome</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Online meeting, desktop sharing, and video conferencing software.</string>
            <key>display_name</key>
            <string>GoToMeeting</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>21564</integer>
            <key>installed_version</key>
            <string>7.18.0.4962</string>
            <key>name</key>
            <string>GoToMeeting</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Self support apps provided by IT services to end users.</string>
            <key>display_name</key>
            <string>Hello-IT</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>1417</integer>
            <key>installed_version</key>
            <string>1.2.1</string>
            <key>name</key>
            <string>Hello IT</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>HelloITResetScriptForOffice</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>4</integer>
            <key>installed_version</key>
            <string>1.0</string>
            <key>name</key>
            <string>HelloITResetScriptForOffice</string>
        </dict>
        <dict>
            <key>description</key>
            <string>launchd configuration files for use by Managed Software Center.</string>
            <key>display_name</key>
            <string>Managed Software Center launchd files</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>9</integer>
            <key>installed_version</key>
            <string>2.0.0.1969</string>
            <key>name</key>
            <string>munkitools_launchd</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Core command-line tools used by Managed Software Center.</string>
            <key>display_name</key>
            <string>Managed Software Center core tools</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>658</integer>
            <key>installed_version</key>
            <string>2.7.0.2753</string>
            <key>name</key>
            <string>munkitools_core</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Command-line Managed Software Center admin tools.</string>
            <key>display_name</key>
            <string>Managed Software Center admin tools</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>154</integer>
            <key>installed_version</key>
            <string>2.7.0.2753</string>
            <key>name</key>
            <string>munkitools_admin</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Managed Software Center application.</string>
            <key>display_name</key>
            <string>Managed Software Center</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>4449</integer>
            <key>installed_version</key>
            <string>4.2.2751</string>
            <key>name</key>
            <string>munkitools</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>OfficeLicenseVersionMunkiCondition</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>4</integer>
            <key>installed_version</key>
            <string>1.0</string>
            <key>name</key>
            <string>OfficeLicenseVersionMunkiCondition</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Java SE Runtime Environment 8 enables support for running Java-powered applets and applications.</string>
            <key>display_name</key>
            <string>Oracle Java 8</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>175048</integer>
            <key>installed_version</key>
            <string>1.8.91.14</string>
            <key>name</key>
            <string>OracleJava8</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>Ricoh_PS_Printers_Vol1_EXP_LIO Driver</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>6317</integer>
            <key>installed_version</key>
            <string>2.2.0</string>
            <key>name</key>
            <string>Ricoh_PS_Printers_Vol1_EXP_LIO_Driver</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>Ricoh_Open_Space</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>0</integer>
            <key>installed_version</key>
            <string>1.0</string>
            <key>name</key>
            <string>Ricoh_Open_Space</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Microsoft Silverlight is a free web-browser plug-in that enables interactive media experiences, rich business applications and immersive mobile apps.</string>
            <key>display_name</key>
            <string>Microsoft Silverlight</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>35673</integer>
            <key>installed_version</key>
            <string>5.1.41212.0</string>
            <key>name</key>
            <string>Silverlight</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Calling, seeing, messaging and sharing with others – wherever they are.</string>
            <key>display_name</key>
            <string>Skype</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>44776</integer>
            <key>installed_version</key>
            <string>7.28.0.316</string>
            <key>name</key>
            <string>Skype</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Decompression utility for OS X.</string>
            <key>display_name</key>
            <string>StuffIt Expander</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>12537</integer>
            <key>installed_version</key>
            <string>16.0.5</string>
            <key>name</key>
            <string>StuffItExpander</string>
        </dict>
        <dict>
            <key>description</key>
            <string>The Unarchiver is a much more capable replacement for "Archive Utility.app", the built-in archive unpacker program on Mac OS X. The Unarchiver is designed to handle many more formats than Archive Utility, and to better fit in with the design of the Finder.</string>
            <key>display_name</key>
            <string>The Unarchiver</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>6932</integer>
            <key>installed_version</key>
            <string>3.11.1</string>
            <key>name</key>
            <string>TheUnarchiver</string>
        </dict>
        <dict>
            <key>description</key>
            <string>GUI front-end for unrar.</string>
            <key>display_name</key>
            <string>UnRarX</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>715</integer>
            <key>installed_version</key>
            <string>2.2b2</string>
            <key>name</key>
            <string>UnRarX</string>
        </dict>
        <dict>
            <key>description</key>
            <string>VLC is a free and open source cross-platform multimedia player and framework that plays most multimedia files as well as DVD, Audio CD, VCD, and various streaming protocols.</string>
            <key>display_name</key>
            <string>VLC Media Player</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>35577</integer>
            <key>installed_version</key>
            <string>2.2.3</string>
            <key>name</key>
            <string>VLC</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Scientific graphing and nonlinear curve regression tool.</string>
            <key>display_name</key>
            <string>Prism</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>76630</integer>
            <key>installed_version</key>
            <string>70118</string>
            <key>name</key>
            <string>Prism</string>
        </dict>
        <dict>
            <key>blocking_applications</key>
            <array>
                <string>Microsoft Autoupdate</string>
                <string>Microsoft Outlook</string>
                <string>Microsoft Excel</string>
                <string>Microsoft PowerPoint</string>
                <string>Microsoft Word</string>
                <string>Microsoft OneNote</string>
            </array>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>Microsoft Office 2016 pour Mac</string>
            <key>download_kbytes_per_sec</key>
            <integer>54844</integer>
            <key>installed</key>
            <false/>
            <key>installed_size</key>
            <integer>7105368</integer>
            <key>installer_item</key>
            <string>Office2016Suite-15.22.0.pkg</string>
            <key>installer_item_size</key>
            <integer>1480809</integer>
            <key>name</key>
            <string>Office2016Suite</string>
            <key>version_to_install</key>
            <string>15.22.0</string>
        </dict>
    </array>
    <key>ManifestName</key>
    <string>workstation</string>
    <key>ProblemInstalls</key>
    <array/>
    <key>RemovalResults</key>
    <array/>
    <key>RemovedItems</key>
    <array/>
    <key>RunType</key>
    <string>installwithnologout</string>
    <key>StartTime</key>
    <string>2016-05-30 14:29:48 +0000</string>
    <key>Warnings</key>
    <array/>
    <key>managed_installs_list</key>
    <array>
        <string>FusionInventory_CORP</string>
        <string>RootCert AD</string>
        <string>sal_scripts</string>
        <string>AdobeFlashPlayer</string>
        <string>Firefox</string>
        <string>GoogleChrome</string>
        <string>GoToMeeting</string>
        <string>Hello IT</string>
        <string>HelloITResetScriptForOffice</string>
        <string>munkitools</string>
        <string>munkitools_core</string>
        <string>munkitools_launchd</string>
        <string>munkitools_admin</string>
        <string>OfficeLicenseVersionMunkiCondition</string>
        <string>OracleJava8</string>
        <string>Ricoh_Open_Space</string>
        <string>Ricoh_PS_Printers_Vol1_EXP_LIO_Driver</string>
        <string>Silverlight</string>
        <string>Skype</string>
        <string>StuffItExpander</string>
        <string>TheUnarchiver</string>
        <string>UnRarX</string>
        <string>VLC</string>
        <string>Prism</string>
        <string>Office2016Suite</string>
    </array>
    <key>managed_uninstalls_list</key>
    <array/>
    <key>managed_updates_list</key>
    <array/>
</dict>
</plist>

With 2011 perpetual licence

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
    <key>AvailableDiskSpace</key>
    <integer>469121676</integer>
    <key>Conditions</key>
    <dict>
        <key>OfficeLicenseVersion</key>
        <string>2011</string>
        <key>arch</key>
        <string>x86_64</string>
        <key>catalogs</key>
        <array>
            <string>development</string>
            <string>testing</string>
        </array>
        <key>date</key>
        <date>2016-05-30T17:19:09Z</date>
        <key>hostname</key>
        <string>mac-012.local</string>
        <key>ipv4_address</key>
        <array>
            <string>10.2.12.14</string>
        </array>
        <key>machine_model</key>
        <string>iMac12,1</string>
        <key>machine_type</key>
        <string>desktop</string>
        <key>munki_version</key>
        <string>2.7.0.2753</string>
        <key>os_vers</key>
        <string>10.11.5</string>
        <key>os_vers_major</key>
        <integer>10</integer>
        <key>os_vers_minor</key>
        <integer>11</integer>
        <key>os_vers_patch</key>
        <integer>5</integer>
        <key>serial_number</key>
        <string>C02XXXX5DHJF</string>
        <key>x86_64_capable</key>
        <true/>
    </dict>
    <key>ConsoleUser</key>
    <string>test</string>
    <key>EndTime</key>
    <string>2016-05-30 15:19:24 +0000</string>
    <key>Errors</key>
    <array/>
    <key>InstallResults</key>
    <array/>
    <key>InstalledItems</key>
    <array>
        <string>FusionInventory_CORP</string>
        <string>RootCert AD</string>
        <string>sal_scripts</string>
        <string>AdobeFlashPlayer</string>
        <string>Firefox</string>
        <string>GoogleChrome</string>
        <string>GoToMeeting</string>
        <string>Hello IT</string>
        <string>HelloITResetScriptForOffice</string>
        <string>munkitools_launchd</string>
        <string>munkitools_core</string>
        <string>munkitools_admin</string>
        <string>munkitools</string>
        <string>OfficeLicenseVersionMunkiCondition</string>
        <string>OracleJava8</string>
        <string>Ricoh_PS_Printers_Vol1_EXP_LIO_Driver</string>
        <string>Ricoh_Open_Space</string>
        <string>Silverlight</string>
        <string>Skype</string>
        <string>StuffItExpander</string>
        <string>TheUnarchiver</string>
        <string>UnRarX</string>
        <string>VLC</string>
        <string>Prism</string>
    </array>
    <key>ItemsToInstall</key>
    <array/>
    <key>ItemsToRemove</key>
    <array/>
    <key>MachineInfo</key>
    <dict>
        <key>arch</key>
        <string>x86_64</string>
        <key>hostname</key>
        <string>mac-012.local</string>
        <key>ipv4_address</key>
        <array>
            <string>10.2.12.14</string>
        </array>
        <key>machine_model</key>
        <string>iMac12,1</string>
        <key>munki_version</key>
        <string>2.7.0.2753</string>
        <key>os_vers</key>
        <string>10.11.5</string>
        <key>serial_number</key>
        <string>C02XXXX5DHJF</string>
        <key>x86_64_capable</key>
        <true/>
    </dict>
    <key>ManagedInstallVersion</key>
    <string>2.7.0.2753</string>
    <key>ManagedInstalls</key>
    <array>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>Agent Fusion Inventory</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>54752</integer>
            <key>installed_version</key>
            <string>2.3.17</string>
            <key>name</key>
            <string>FusionInventory_CORP</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>RootCert AD</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>2</integer>
            <key>installed_version</key>
            <string>1.0</string>
            <key>name</key>
            <string>RootCert AD</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Client side scripts for Sal.</string>
            <key>display_name</key>
            <string>sal_scripts</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>246</integer>
            <key>installed_version</key>
            <string>1.0.2</string>
            <key>name</key>
            <string>sal_scripts</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Adobe® Flash® Player is a cross-platform browser-based application runtime that delivers uncompromised viewing of expressive applications, content, and videos across screens and browsers.</string>
            <key>display_name</key>
            <string>Adobe Flash Player</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>18096</integer>
            <key>installed_version</key>
            <string>21.0.0.242</string>
            <key>name</key>
            <string>AdobeFlashPlayer</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Mozilla Firefox is a free and open source web browser.</string>
            <key>display_name</key>
            <string>Mozilla Firefox</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>85047</integer>
            <key>installed_version</key>
            <string>46.0.1</string>
            <key>name</key>
            <string>Firefox</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Chrome is a fast, simple, and secure web browser, built for the modern web.</string>
            <key>display_name</key>
            <string>Google Chrome</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>66156</integer>
            <key>installed_version</key>
            <string>50.0.2661.102</string>
            <key>name</key>
            <string>GoogleChrome</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Online meeting, desktop sharing, and video conferencing software.</string>
            <key>display_name</key>
            <string>GoToMeeting</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>21564</integer>
            <key>installed_version</key>
            <string>7.18.0.4962</string>
            <key>name</key>
            <string>GoToMeeting</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Self support apps provided by IT services to end users.</string>
            <key>display_name</key>
            <string>Hello-IT</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>1417</integer>
            <key>installed_version</key>
            <string>1.2.1</string>
            <key>name</key>
            <string>Hello IT</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>HelloITResetScriptForOffice</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>4</integer>
            <key>installed_version</key>
            <string>1.0</string>
            <key>name</key>
            <string>HelloITResetScriptForOffice</string>
        </dict>
        <dict>
            <key>description</key>
            <string>launchd configuration files for use by Managed Software Center.</string>
            <key>display_name</key>
            <string>Managed Software Center launchd files</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>9</integer>
            <key>installed_version</key>
            <string>2.0.0.1969</string>
            <key>name</key>
            <string>munkitools_launchd</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Core command-line tools used by Managed Software Center.</string>
            <key>display_name</key>
            <string>Managed Software Center core tools</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>658</integer>
            <key>installed_version</key>
            <string>2.7.0.2753</string>
            <key>name</key>
            <string>munkitools_core</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Command-line Managed Software Center admin tools.</string>
            <key>display_name</key>
            <string>Managed Software Center admin tools</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>154</integer>
            <key>installed_version</key>
            <string>2.7.0.2753</string>
            <key>name</key>
            <string>munkitools_admin</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Managed Software Center application.</string>
            <key>display_name</key>
            <string>Managed Software Center</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>4449</integer>
            <key>installed_version</key>
            <string>4.2.2751</string>
            <key>name</key>
            <string>munkitools</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>OfficeLicenseVersionMunkiCondition</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>4</integer>
            <key>installed_version</key>
            <string>1.0</string>
            <key>name</key>
            <string>OfficeLicenseVersionMunkiCondition</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Java SE Runtime Environment 8 enables support for running Java-powered applets and applications.</string>
            <key>display_name</key>
            <string>Oracle Java 8</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>175048</integer>
            <key>installed_version</key>
            <string>1.8.91.14</string>
            <key>name</key>
            <string>OracleJava8</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>Ricoh_PS_Printers_Vol1_EXP_LIO Driver</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>6317</integer>
            <key>installed_version</key>
            <string>2.2.0</string>
            <key>name</key>
            <string>Ricoh_PS_Printers_Vol1_EXP_LIO_Driver</string>
        </dict>
        <dict>
            <key>description</key>
            <string></string>
            <key>display_name</key>
            <string>Ricoh_Open_Space</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>0</integer>
            <key>installed_version</key>
            <string>1.0</string>
            <key>name</key>
            <string>Ricoh_Open_Space</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Microsoft Silverlight is a free web-browser plug-in that enables interactive media experiences, rich business applications and immersive mobile apps.</string>
            <key>display_name</key>
            <string>Microsoft Silverlight</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>35673</integer>
            <key>installed_version</key>
            <string>5.1.41212.0</string>
            <key>name</key>
            <string>Silverlight</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Calling, seeing, messaging and sharing with others – wherever they are.</string>
            <key>display_name</key>
            <string>Skype</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>44776</integer>
            <key>installed_version</key>
            <string>7.28.0.316</string>
            <key>name</key>
            <string>Skype</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Decompression utility for OS X.</string>
            <key>display_name</key>
            <string>StuffIt Expander</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>12537</integer>
            <key>installed_version</key>
            <string>16.0.5</string>
            <key>name</key>
            <string>StuffItExpander</string>
        </dict>
        <dict>
            <key>description</key>
            <string>The Unarchiver is a much more capable replacement for "Archive Utility.app", the built-in archive unpacker program on Mac OS X. The Unarchiver is designed to handle many more formats than Archive Utility, and to better fit in with the design of the Finder.</string>
            <key>display_name</key>
            <string>The Unarchiver</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>6932</integer>
            <key>installed_version</key>
            <string>3.11.1</string>
            <key>name</key>
            <string>TheUnarchiver</string>
        </dict>
        <dict>
            <key>description</key>
            <string>GUI front-end for unrar.</string>
            <key>display_name</key>
            <string>UnRarX</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>715</integer>
            <key>installed_version</key>
            <string>2.2b2</string>
            <key>name</key>
            <string>UnRarX</string>
        </dict>
        <dict>
            <key>description</key>
            <string>VLC is a free and open source cross-platform multimedia player and framework that plays most multimedia files as well as DVD, Audio CD, VCD, and various streaming protocols.</string>
            <key>display_name</key>
            <string>VLC Media Player</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>35577</integer>
            <key>installed_version</key>
            <string>2.2.3</string>
            <key>name</key>
            <string>VLC</string>
        </dict>
        <dict>
            <key>description</key>
            <string>Scientific graphing and nonlinear curve regression tool.</string>
            <key>display_name</key>
            <string>Prism</string>
            <key>installed</key>
            <true/>
            <key>installed_size</key>
            <integer>76630</integer>
            <key>installed_version</key>
            <string>70118</string>
            <key>name</key>
            <string>Prism</string>
        </dict>
    </array>
    <key>ManifestName</key>
    <string>workstation</string>
    <key>ProblemInstalls</key>
    <array/>
    <key>RemovalResults</key>
    <array/>
    <key>RemovedItems</key>
    <array/>
    <key>RunType</key>
    <string>auto</string>
    <key>StartTime</key>
    <string>2016-05-30 15:19:09 +0000</string>
    <key>Warnings</key>
    <array/>
    <key>managed_installs_list</key>
    <array>
        <string>FusionInventory_CORP</string>
        <string>RootCert AD</string>
        <string>sal_scripts</string>
        <string>AdobeFlashPlayer</string>
        <string>Firefox</string>
        <string>GoogleChrome</string>
        <string>GoToMeeting</string>
        <string>Hello IT</string>
        <string>HelloITResetScriptForOffice</string>
        <string>munkitools</string>
        <string>munkitools_core</string>
        <string>munkitools_launchd</string>
        <string>munkitools_admin</string>
        <string>OfficeLicenseVersionMunkiCondition</string>
        <string>OracleJava8</string>
        <string>Ricoh_Open_Space</string>
        <string>Ricoh_PS_Printers_Vol1_EXP_LIO_Driver</string>
        <string>Silverlight</string>
        <string>Skype</string>
        <string>StuffItExpander</string>
        <string>TheUnarchiver</string>
        <string>UnRarX</string>
        <string>VLC</string>
        <string>Prism</string>
    </array>
    <key>managed_uninstalls_list</key>
    <array/>
    <key>managed_updates_list</key>
    <array/>
</dict>
</plist>
grahamgilbert commented 8 years ago

I'm not seeing any blank conditions. What install method and database backend are you using?

Sent from my iPhone

On Mon, May 30, 2016 at 9:20 AM -0700, "Yoann Gini" notifications@github.com wrote:

Without 2011 or 2016 full time licence:

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">

AppleUpdates apple_product_name Mise à jour des logiciels d’imprimantes Ricoh description <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta http-equiv="Content-Style-Type" content="text/css"> <title></title> <meta name="Generator" content="Cocoa HTML Writer"> <meta name="CocoaVersion" content="824.41"> <style type="text/css"> p.p1 {font: 11.0px Lucida Grande;} </style> </head> <body> <p class="p1">Cette mise à jour installe les logiciels les plus récents pour votre scanneur ou imprimante Ricoh.</p> <p class="p1">Pour en savoir plus sur les logiciels pour imprimantes et scanneurs, visitez <a href="http://support.apple.com/kb/HT3669?viewlocale=fr_FR">http://support.apple.com/kb/HT3669?viewlocale=fr_FR</a></p> </body> </html> display_name Mise à jour des logiciels d’imprimantes Ricoh installed_size 27508 name 031-06624 productKey 031-06624 version_to_install 2.5 apple_product_name Mise à jour des logiciels d’imprimantes Ricoh description <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta http-equiv="Content-Style-Type" content="text/css"> <title></title> <meta name="Generator" content="Cocoa HTML Writer"> <meta name="CocoaVersion" content="824.41"> <style type="text/css"> p.p1 {font: 11.0px Lucida Grande;} </style> </head> <body> <p class="p1">Cette mise à jour installe les logiciels les plus récents pour votre scanneur ou imprimante Ricoh.</p> <p class="p1">Pour en savoir plus sur les logiciels pour imprimantes et scanneurs, visitez <a href="http://support.apple.com/kb/HT3669?viewlocale=fr_FR">http://support.apple.com/kb/HT3669?viewlocale=fr_FR</a></p> </body> </html> display_name Mise à jour des logiciels d’imprimantes Ricoh installed_size 34092 name 031-07834 productKey 031-07834 version_to_install 3.0 AvailableDiskSpace 217601860 Conditions arch x86_64 catalogs development testing date 2016-05-30T16:29:02Z hostname mac-006.local ipv4_address 10.2.12.165 machine_model MacBookAir7,2 machine_type laptop munki_version 2.7.0.2753 os_vers 10.11.5 os_vers_major 10 os_vers_minor 11 os_vers_patch 5 serial_number C1XXXX0WG944 x86_64_capable ConsoleUser test EndTime 2016-05-30 14:32:29 +0000 Errors InstallResults applesus display_name Microsoft Office 2016 pour Mac download_kbytes_per_sec 54844 duration_seconds 146 name Office2016Suite status 0 time 2016-05-30T14:32:18Z unattended version 15.22.0 applesus name Mise à jour des logiciels d’imprimantes Ricoh productKey 031-06624 status 0 time 2016-05-30T14:32:29Z version 2.5 applesus name Mise à jour des logiciels d’imprimantes Ricoh productKey 031-07834 status 0 time 2016-05-30T14:32:29Z version 3.0 InstalledItems FusionInventory_CORP RootCert AD sal_scripts AdobeFlashPlayer Firefox GoogleChrome GoToMeeting Hello IT HelloITResetScriptForOffice munkitools_launchd munkitools_core munkitools_admin munkitools OfficeLicenseVersionMunkiCondition OracleJava8 Ricoh_PS_Printers_Vol1_EXP_LIO_Driver Ricoh_Open_Space Silverlight Skype StuffItExpander TheUnarchiver UnRarX VLC Prism ItemsToInstall blocking_applications Microsoft Autoupdate Microsoft Outlook Microsoft Excel Microsoft PowerPoint Microsoft Word Microsoft OneNote description display_name Microsoft Office 2016 pour Mac download_kbytes_per_sec 54844 installed installed_size 7105368 installer_item Office2016Suite-15.22.0.pkg installer_item_size 1480809 name Office2016Suite version_to_install 15.22.0 ItemsToRemove MachineInfo arch x86_64 hostname mac-006.local ipv4_address 10.2.12.165 machine_model MacBookAir7,2 munki_version 2.7.0.2753 os_vers 10.11.5 serial_number C1XXXX0WG944 x86_64_capable ManagedInstallVersion 2.7.0.2753 ManagedInstalls description display_name Agent Fusion Inventory installed installed_size 54752 installed_version 2.3.17 name FusionInventory_CORP description display_name RootCert AD installed installed_size 2 installed_version 1.0 name RootCert AD description Client side scripts for Sal. display_name sal_scripts installed installed_size 246 installed_version 1.0.2 name sal_scripts description Adobe® Flash® Player is a cross-platform browser-based application runtime that delivers uncompromised viewing of expressive applications, content, and videos across screens and browsers. display_name Adobe Flash Player installed installed_size 18096 installed_version 21.0.0.242 name AdobeFlashPlayer description Mozilla Firefox is a free and open source web browser. display_name Mozilla Firefox installed installed_size 85047 installed_version 46.0.1 name Firefox description Chrome is a fast, simple, and secure web browser, built for the modern web. display_name Google Chrome installed installed_size 66156 installed_version 50.0.2661.102 name GoogleChrome description Online meeting, desktop sharing, and video conferencing software. display_name GoToMeeting installed installed_size 21564 installed_version 7.18.0.4962 name GoToMeeting description Self support apps provided by IT services to end users. display_name Hello-IT installed installed_size 1417 installed_version 1.2.1 name Hello IT description display_name HelloITResetScriptForOffice installed installed_size 4 installed_version 1.0 name HelloITResetScriptForOffice description launchd configuration files for use by Managed Software Center. display_name Managed Software Center launchd files installed installed_size 9 installed_version 2.0.0.1969 name munkitools_launchd description Core command-line tools used by Managed Software Center. display_name Managed Software Center core tools installed installed_size 658 installed_version 2.7.0.2753 name munkitools_core description Command-line Managed Software Center admin tools. display_name Managed Software Center admin tools installed installed_size 154 installed_version 2.7.0.2753 name munkitools_admin description Managed Software Center application. display_name Managed Software Center installed installed_size 4449 installed_version 4.2.2751 name munkitools description display_name OfficeLicenseVersionMunkiCondition installed installed_size 4 installed_version 1.0 name OfficeLicenseVersionMunkiCondition description Java SE Runtime Environment 8 enables support for running Java-powered applets and applications. display_name Oracle Java 8 installed installed_size 175048 installed_version 1.8.91.14 name OracleJava8 description display_name Ricoh_PS_Printers_Vol1_EXP_LIO Driver installed installed_size 6317 installed_version 2.2.0 name Ricoh_PS_Printers_Vol1_EXP_LIO_Driver description display_name Ricoh_Open_Space installed installed_size 0 installed_version 1.0 name Ricoh_Open_Space description Microsoft Silverlight is a free web-browser plug-in that enables interactive media experiences, rich business applications and immersive mobile apps. display_name Microsoft Silverlight installed installed_size 35673 installed_version 5.1.41212.0 name Silverlight description Calling, seeing, messaging and sharing with others – wherever they are. display_name Skype installed installed_size 44776 installed_version 7.28.0.316 name Skype description Decompression utility for OS X. display_name StuffIt Expander installed installed_size 12537 installed_version 16.0.5 name StuffItExpander description The Unarchiver is a much more capable replacement for "Archive Utility.app", the built-in archive unpacker program on Mac OS X. The Unarchiver is designed to handle many more formats than Archive Utility, and to better fit in with the design of the Finder. display_name The Unarchiver installed installed_size 6932 installed_version 3.11.1 name TheUnarchiver description GUI front-end for unrar. display_name UnRarX installed installed_size 715 installed_version 2.2b2 name UnRarX description VLC is a free and open source cross-platform multimedia player and framework that plays most multimedia files as well as DVD, Audio CD, VCD, and various streaming protocols. display_name VLC Media Player installed installed_size 35577 installed_version 2.2.3 name VLC description Scientific graphing and nonlinear curve regression tool. display_name Prism installed installed_size 76630 installed_version 70118 name Prism blocking_applications Microsoft Autoupdate Microsoft Outlook Microsoft Excel Microsoft PowerPoint Microsoft Word Microsoft OneNote description display_name Microsoft Office 2016 pour Mac download_kbytes_per_sec 54844 installed installed_size 7105368 installer_item Office2016Suite-15.22.0.pkg installer_item_size 1480809 name Office2016Suite version_to_install 15.22.0 ManifestName workstation ProblemInstalls RemovalResults RemovedItems RunType installwithnologout StartTime 2016-05-30 14:29:48 +0000 Warnings managed_installs_list FusionInventory_CORP RootCert AD sal_scripts AdobeFlashPlayer Firefox GoogleChrome GoToMeeting Hello IT HelloITResetScriptForOffice munkitools munkitools_core munkitools_launchd munkitools_admin OfficeLicenseVersionMunkiCondition OracleJava8 Ricoh_Open_Space Ricoh_PS_Printers_Vol1_EXP_LIO_Driver Silverlight Skype StuffItExpander TheUnarchiver UnRarX VLC Prism Office2016Suite managed_uninstalls_list managed_updates_list

With 2011 perpetual licence

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">

AvailableDiskSpace 469121676 Conditions OfficeLicenseVersion 2011 arch x86_64 catalogs development testing date 2016-05-30T17:19:09Z hostname mac-012.local ipv4_address 10.2.12.14 machine_model iMac12,1 machine_type desktop munki_version 2.7.0.2753 os_vers 10.11.5 os_vers_major 10 os_vers_minor 11 os_vers_patch 5 serial_number C02XXXX5DHJF x86_64_capable ConsoleUser test EndTime 2016-05-30 15:19:24 +0000 Errors InstallResults InstalledItems FusionInventory_CORP RootCert AD sal_scripts AdobeFlashPlayer Firefox GoogleChrome GoToMeeting Hello IT HelloITResetScriptForOffice munkitools_launchd munkitools_core munkitools_admin munkitools OfficeLicenseVersionMunkiCondition OracleJava8 Ricoh_PS_Printers_Vol1_EXP_LIO_Driver Ricoh_Open_Space Silverlight Skype StuffItExpander TheUnarchiver UnRarX VLC Prism ItemsToInstall ItemsToRemove MachineInfo arch x86_64 hostname mac-012.local ipv4_address 10.2.12.14 machine_model iMac12,1 munki_version 2.7.0.2753 os_vers 10.11.5 serial_number C02XXXX5DHJF x86_64_capable ManagedInstallVersion 2.7.0.2753 ManagedInstalls description display_name Agent Fusion Inventory installed installed_size 54752 installed_version 2.3.17 name FusionInventory_CORP description display_name RootCert AD installed installed_size 2 installed_version 1.0 name RootCert AD description Client side scripts for Sal. display_name sal_scripts installed installed_size 246 installed_version 1.0.2 name sal_scripts description Adobe® Flash® Player is a cross-platform browser-based application runtime that delivers uncompromised viewing of expressive applications, content, and videos across screens and browsers. display_name Adobe Flash Player installed installed_size 18096 installed_version 21.0.0.242 name AdobeFlashPlayer description Mozilla Firefox is a free and open source web browser. display_name Mozilla Firefox installed installed_size 85047 installed_version 46.0.1 name Firefox description Chrome is a fast, simple, and secure web browser, built for the modern web. display_name Google Chrome installed installed_size 66156 installed_version 50.0.2661.102 name GoogleChrome description Online meeting, desktop sharing, and video conferencing software. display_name GoToMeeting installed installed_size 21564 installed_version 7.18.0.4962 name GoToMeeting description Self support apps provided by IT services to end users. display_name Hello-IT installed installed_size 1417 installed_version 1.2.1 name Hello IT description display_name HelloITResetScriptForOffice installed installed_size 4 installed_version 1.0 name HelloITResetScriptForOffice description launchd configuration files for use by Managed Software Center. display_name Managed Software Center launchd files installed installed_size 9 installed_version 2.0.0.1969 name munkitools_launchd description Core command-line tools used by Managed Software Center. display_name Managed Software Center core tools installed installed_size 658 installed_version 2.7.0.2753 name munkitools_core description Command-line Managed Software Center admin tools. display_name Managed Software Center admin tools installed installed_size 154 installed_version 2.7.0.2753 name munkitools_admin description Managed Software Center application. display_name Managed Software Center installed installed_size 4449 installed_version 4.2.2751 name munkitools description display_name OfficeLicenseVersionMunkiCondition installed installed_size 4 installed_version 1.0 name OfficeLicenseVersionMunkiCondition description Java SE Runtime Environment 8 enables support for running Java-powered applets and applications. display_name Oracle Java 8 installed installed_size 175048 installed_version 1.8.91.14 name OracleJava8 description display_name Ricoh_PS_Printers_Vol1_EXP_LIO Driver installed installed_size 6317 installed_version 2.2.0 name Ricoh_PS_Printers_Vol1_EXP_LIO_Driver description display_name Ricoh_Open_Space installed installed_size 0 installed_version 1.0 name Ricoh_Open_Space description Microsoft Silverlight is a free web-browser plug-in that enables interactive media experiences, rich business applications and immersive mobile apps. display_name Microsoft Silverlight installed installed_size 35673 installed_version 5.1.41212.0 name Silverlight description Calling, seeing, messaging and sharing with others – wherever they are. display_name Skype installed installed_size 44776 installed_version 7.28.0.316 name Skype description Decompression utility for OS X. display_name StuffIt Expander installed installed_size 12537 installed_version 16.0.5 name StuffItExpander description The Unarchiver is a much more capable replacement for "Archive Utility.app", the built-in archive unpacker program on Mac OS X. The Unarchiver is designed to handle many more formats than Archive Utility, and to better fit in with the design of the Finder. display_name The Unarchiver installed installed_size 6932 installed_version 3.11.1 name TheUnarchiver description GUI front-end for unrar. display_name UnRarX installed installed_size 715 installed_version 2.2b2 name UnRarX description VLC is a free and open source cross-platform multimedia player and framework that plays most multimedia files as well as DVD, Audio CD, VCD, and various streaming protocols. display_name VLC Media Player installed installed_size 35577 installed_version 2.2.3 name VLC description Scientific graphing and nonlinear curve regression tool. display_name Prism installed installed_size 76630 installed_version 70118 name Prism ManifestName workstation ProblemInstalls RemovalResults RemovedItems RunType auto StartTime 2016-05-30 15:19:09 +0000 Warnings managed_installs_list FusionInventory_CORP RootCert AD sal_scripts AdobeFlashPlayer Firefox GoogleChrome GoToMeeting Hello IT HelloITResetScriptForOffice munkitools munkitools_core munkitools_launchd munkitools_admin OfficeLicenseVersionMunkiCondition OracleJava8 Ricoh_Open_Space Ricoh_PS_Printers_Vol1_EXP_LIO_Driver Silverlight Skype StuffItExpander TheUnarchiver UnRarX VLC Prism managed_uninstalls_list managed_updates_list

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

ygini commented 8 years ago

Manual install on CentOS with MySQL database (too much problems with Postgres dependencies on CentOS)

grahamgilbert commented 8 years ago

Potentially a MySQL bug. Is there anyone else using that db? I'm using Postgres via RDS at the moment. 

Sent from my iPhone

On Mon, May 30, 2016 at 9:29 AM -0700, "Yoann Gini" notifications@github.com wrote:

Manual install on CentOS with MySQL database (too much problems with Postgres dependencies on CentOS)

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

groob commented 8 years ago

Could this be an issue with the condition script instead? Looking at the trace, the crash happens because it tries to enter a null value in the column.

Could you post the conditional script? Instead of reporting a null value, could it be changed to report NO_LICENSE_FOUND or something like that?

grahamgilbert commented 8 years ago

Yes, that. Trust me to respond to issues on my day off. Can a plist have a null value? If so, this is probably a bug (albeit one that won't be patched anytime soon as there is probably more than one place I'd need to update). It should probably report a Boolean of false instead.

gregneagle commented 8 years ago

Plists cannot have null values, and nothing Yoann has posted looks odd. There's no key or value for "OfficeLicenseVersion" when it doesn't exist. I don't understand how the absence of "OfficeLicenseVersion" in the Conditions dict can cause a crash -- "FooBarBaz" doesn't exist within that dict, either and hasn't caused any crashes that we're aware of...

groob commented 8 years ago

condition_name and condirion_data are two fields of the condition model, and condition data is not allowed to be null, so If the condition OfficeLicenseVersion already exists, it will always expect a value.

https://github.com/salopensource/sal/blob/6588d820bff301e3c7ea349baf7cedec74817215/server/migrations/0001_squashed_0023_auto_20151130_1036.py#L54

I'm not sure how this problem happens because the condition is completely omitted in the plist...

grahamgilbert commented 8 years ago

No, conditions that aren't marked as historical are wiped during every checkin. 

Sent from my iPhone

On Mon, May 30, 2016 at 10:36 AM -0700, "Victor" notifications@github.com wrote:

condition_name and condirion_data are two fields of the condition model, and condition data is not allowed to be null, so If the condition OfficeLicenseVersion already exists, it will always expect a value.

https://github.com/salopensource/sal/blob/6588d820bff301e3c7ea349baf7cedec74817215/server/migrations/0001_squashed_0023_auto_20151130_1036.py#L54

I'm not sure this problem happens because the condition is completely omitted in the plist...

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

grahamgilbert commented 8 years ago

Closing this since it seems impossible for a plist for have a none or null value.

ygini commented 8 years ago

Even if it's impossible for a plist for have a none or null value, I still have an error here… How could I troubleshoot this?

arubdesu commented 8 years ago

More like can you just make sure you don't set the key if the value is none/null?

grahamgilbert commented 8 years ago

Yes, this is a problem with your condition script (guessing since you've not posted it). I wouldn't set the key if the value isn't present.

ygini commented 8 years ago

Here is the script I use:

#!/bin/sh

managedinstalldir="$(defaults read /Library/Preferences/ManagedInstalls ManagedInstallDir)"
plist_loc="$managedinstalldir/ConditionalItems"

if [ -f /Library/Preferences/com.microsoft.office.licensingV2.plist ]
then
    defaults write "$plist_loc" "OfficeLicenseVersion" 2016
elif [ -f /Library/Preferences/com.microsoft.office.licensing.plist ]
then
    defaults write "$plist_loc" "OfficeLicenseVersion" "2011" 
else
    defaults delete "$plist_loc" "OfficeLicenseVersion"
fi 

plutil -convert xml1 "$plist_loc".plist

exit 0
groob commented 8 years ago

@ygini there are a couple things you could do that can help narrow this down.

a) try to duplicate this error with a fresh installation of mysql. Does it happen when a client reports fresh instance of the database. b) can you replicate the error with postgres? c) not sure if this could be a possible reason but you're writing 2016 as an int and 2011 as a string.

groob commented 8 years ago

setting condition_data to accept null values would potentially fix this, but I'm not sure what other effects it could have https://github.com/salopensource/sal/blob/6588d820bff301e3c7ea349baf7cedec74817215/server/migrations/0001_initial.py#L45

grahamgilbert commented 8 years ago

But a condition shouldn't ever be null. Munki doesn't like this. If a condition isn't set, it is deleted (actually, they're all deleted when the machine checks in https://github.com/salopensource/sal/blob/master/server/views.py#L1868-L1869).

ygini commented 8 years ago

@groob, I agree with @grahamgilbert, the fix isn't to allow null value but to understand from where this null value is coming here.

I've talked about my Office condition because it's the only condition I've used in all my setup, but maybe it's an other one.

I've got one Mac without serial number (hardware replacement without re serializing the logic board), can it be the source?

grahamgilbert commented 8 years ago

Almost definitely. That field is the unique identifier for the machine. That definitely can't be empty.

ygini commented 8 years ago

So that might be a problem, don't forget that until the ~2010 if my memory is good, APR was able to replace logic board without having to put a serial number.

It was even part of the OS X Server manual (the root password during the install process was the first 8 char of the SN unless the logic board was replaced, then it was 12345678).

I will try to reset my DB since I've removed this computer from production (it was failing too with Profile Manager)