NOTE - As of 2017-01-05 (at 1400 hours Brisbane, Australia time) an updated 1.12.10 has been released that contains the below fixes. The filename for this contains 1.12.10.1, but the version displayed in the application itself remains at 1.12.10.

Provide drop down org selection on device details screen.

A file has been patched since the release of Open-AudIT 1.12.10. These files will be incorporated into the next release but are available immediately for those affected.

To apply the patch, backup your current file (rename it .bak) and copy this file into place.

The default installation directory for Open-AudIT is:

Windows c:\xampplite\open-audit

Linux /usr/local/open-audit

Copy the below file to /open-audit/code_igniter/application/views/theme-bootstrap/v_devices_read.php

v_devices_read.php

Name Match / IP Match invalid value in Enterprise

There are a couple of false positive warnings on the Enterprise Dashboard. These are safe to ignore (I changed the config item name, hence these don't exist). You can comment out lines 333 ->339 in:

Windows - c:\omk\template\oae\dashboard.html.ep

Linux - /usr/local/omk/templates/oae/dashboard.html.ep

NOTE - If you do alter the template, upon upgrade the installer will warn about checksum's not matching. Just answer the affirmative to overwrite the file anyway.

<!--
							% if (!%$oac_config or ($oac_config->{discovery_name_match} ne "y" and $oac_config->{discovery_name_match} ne "n")) {
							<li>Name Match invalid value. <a style="color:#729FCF;" href="<%= url_for("index_oae") %>/oaconfig/advanced">Fix</a>.</li>
							% }
							% if (!%$oac_config or ($oac_config->{discovery_ip_match} ne "y" and $oac_config->{discovery_ip_match} ne "n")) {
							<li>IP Match invalid value. <a style="color:#729FCF;" href="<%= url_for("index_oae") %>/oaconfig/advanced">Fix</a>.</li>
							% }
-->

Fix for missing data in oa_user_org

Run the below command to fix this issue.

Windows - 

c:\xampplite\mysql\bin\mysql.exe -u openaudit -popenauditpassword -e "DELETE FROM openaudit.oa_user_org; INSERT INTO openaudit.oa_user_org (id, user_id, org_id, access_level, permissions) SELECT NULL, id, 0, 10, '' FROM openaudit.oa_user;"

Linux -

mysql -u openaudit -popenauditpassword -e "DELETE FROM openaudit.oa_user_org; INSERT INTO openaudit.oa_user_org (id, user_id, org_id, access_level, permissions) SELECT NULL, id, 0, 10, '' FROM openaudit.oa_user;"

Delete Devices not Seen for 30 Days

Modify the file open-audit/code_igniter/application/models/m_system.php and change line 1027 to the below. There is a missing right round bracket after DATE(last_seen.

        $sql = "DELETE FROM system WHERE DATE(last_seen) < DATE_SUB(curdate(), INTERVAL " . intval($days) . " day)";