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 (marked FIXED). The filename for this contains 1.12.10.1, but the version displayed in the application itself remains at 1.12.10. There are three further fixes below that have not been included in a newly released package as yet.

FIXED - 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

FIXED - 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>
							% }
-->

FIXED - 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;"

FIXED - 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)";

NOTE - new patches below are not included in 1.12.10.1 patched release.

NOT FIXED - Fix for deleting items from list pages.

There is an issue in the templates for collection pages. The data-id attribute is assigned to the child element of the delete_link class assigned element. Consequently when the delete link is clicked, javascript doesn't have a valid item id for the request. The fix is to correctly place the data-id assignment on the correct element. The fix can be found in the attached file. Replace the files:

Windows - in c:\xampplite\open-audit\code_igniter\application\views\theme-bootstrap

Linux - /usr/local/open-audit/code_igniter/application/views/theme-bootstrap/

The files are the v_X_collection.php (where X is the type of collection - credentials, networks, orgs, etc) and the template file (v_template.php).

The files are below:

v_template.php, v_connections_collection.php, v_credentials_collection.php, v_fields_collection.php, v_locations_collection.php, v_networks_collection.php, v_orgs_collection.php, v_scripts_collection.php.

NOT FIXED - Fix for Device Attachments (2017-02-23)

There are bugs when creating, reading, updating and deleting attachments in 1.12.10.1. Add the files as below into the correct directories to fix this issue.

/open-audit/code_igniter/application/controllers/devices.php

/open-audit/code_igniter/application/controllers/main.php

/open-audit/code_igniter/application/models/m_devices.php

/open-audit/code_igniter/application/views/theme-bootstrap/v_devices_create_form_attachment.php

/open-audit/code_igniter/application/views/theme-bootstrap/v_devices_read.php

/open-audit/code_igniter/application/views/theme-tango/v_display_inc_summary.php

The files are below:

devices.php, main.php, m_devices.php, v_devices_create_form_attachment.php, v_devices_read.php, v_display_inc_summary.php.

NOT FIXED - Snmp other than v2 not working

There is a bug in the file open-audit/code_igniter/application/helpers/snmp_helper.php that set's SNMP version always to v2.

At line 159, change the condition test from:

    if (empty($credentials->credentials->version) or $credentials->credentials->version != 1 or $credentials->credentials->version != 2 or $credentials->credentials->version !=3) {

to

    if (empty($credentials->credentials->version) or ($credentials->credentials->version != 1 and $credentials->credentials->version != 2 and $credentials->credentials->version !=3)) {

NOT FIXED - Bulk Update form (class attribute) (2017-04-27)

We missed populating the drop down on the bulk update form for the 'Class' attribute. The file below contains this patch, along with another bug fix for an undefined variable that was used.

Copy the file to:

Windows - c:\xampplite\open-audit\code_igniter\application\views\theme-bootstrap\v_devices_bulk_update_form.php

Linux - /usr/local/open-audit/code_igniter/application/views/theme-bootstrap/v_devies_bulk_update_form.php

v_devices_bulk_update_form.php

NOT FIXED - Domain not populating on group page (2017-04-27)

We selected dns_domain instead of domain and hence did not match the domain column on the group device list page. The patched file is below.

Copy the file to:

Windows - c:\xampplite\open-audit\code_igniter\application\models\m_systems.php

Linux - /usr/local/open-audit/code_igniter/application/models/m_systems.php

m_systems.php

NOT FIXED - Maps API Key (2017-06-08)

Depending on the number of uses, Google Maps API can restrict use. To work around this you must use an API key. We have generated a key for Open-AudIT. To use it, edit the file:

Windows - c:\omk\templates\oae\map.html.ep

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

Find the below line

<script src="https://maps.googleapis.com/maps/api/js?v=3.exp&sensor=false"></script>

and replace it with the below line

<script src="//maps.google.com/maps/api/js?key=AIzaSyAhAUqssRASeC0Pfyx1TW1DXRmboG5bdG0"></script>

Errata - 1.12.10