Open-AudIT
https://www.open-audit.org/phpBB3/

Bugs after update to 1.12.6
https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6538
Page 1 of 1

Author:  dersonf [ Tue Jul 26, 2016 3:22 am ]
Post subject:  Bugs after update to 1.12.6

Hi all.

After upgrade Open-Audit 1.8.2 to 1.12.6 some report error in some queries.

In system group device list when select Alert the report error are showed;

A Database Error Occurred
Error Number: 1146
Table 'openaudit.oa_alert_log' doesn't exist
/* M_oa_report::get_report */ SELECT oa_alert_log.alert_id, oa_alert_log.system_id, oa_alert_log.timestamp, system.man_ip_address, system.hostname, system.man_description, oa_alert_log.alert_details FROM system, oa_alert_log, oa_group_sys WHERE oa_alert_log.user_id is NULL AND oa_alert_log.system_id = system.system_id AND oa_alert_log.system_id = oa_group_sys.system_id AND oa_group_sys.group_id = @group GROUP BY oa_alert_log.alert_id ORDER BY oa_alert_log.timestamp DESC
Filename: models/m_oa_report.php
Line Number: 223

In system group device list when select Alerts-Software the report error are showed;

A Database Error Occurred
Error Number: 1146
Table 'openaudit.oa_alert_log' doesn't exist
/* M_oa_report::get_report */ SELECT oa_alert_log.alert_id, oa_alert_log.system_id, oa_alert_log.timestamp, system.man_ip_address, system.hostname, system.man_description, oa_alert_log.alert_details FROM system, oa_alert_log, oa_group_sys WHERE oa_alert_log.user_id is NULL AND oa_alert_log.system_id = system.system_id AND oa_alert_log.timestamp > DATE_SUB(NOW(),INTERVAL 100 DAY) AND oa_alert_log.system_id = oa_group_sys.system_id AND oa_alert_log.alert_details LIKE 'software%' AND oa_group_sys.group_id = @group GROUP BY oa_alert_log.alert_id ASC
Filename: models/m_oa_report.php
Line Number: 223

In system group device list Device Detais are duplicated, one option works, the other no, I drop in mysql the incorrect option.

When I choose Instaled - Software the error below are showed:

Error Number: 1146
Table 'openaudit.sys_sw_windows' doesn't exist
/* M_oa_report::get_report */ SELECT system.system_id, system.hostname, system.man_status, sys_sw_software.software_name, sys_sw_software.software_installed_by, date(sys_sw_software.software_installed_on) as software_installed_on, sys_sw_software.software_version, sys_sw_windows.windows_user_name, date(sys_sw_software.first_timestamp) as first_timestamp FROM system LEFT JOIN sys_sw_windows ON (system.system_id = sys_sw_windows.system_id AND system.timestamp = sys_sw_windows.timestamp) LEFT JOIN sys_sw_software ON (system.system_id = sys_sw_software.system_id and system.first_timestamp < sys_sw_software.first_timestamp) WHERE sys_sw_software.software_name = (SELECT software_name FROM sys_sw_software WHERE software_id = '157646' LIMIT 1) AND date(sys_sw_software.first_timestamp) = date('0') GROUP BY system.system_id
Filename: models/m_oa_report.php
Line Number: 223

Any idea how can I fix the errors?

Thanks. :D

Author:  dersonf [ Fri Jul 29, 2016 6:05 am ]
Post subject:  Re: Bugs after update to 1.12.6

Im trying to fix the problem, I made the update again in snapshot and get the renamed tables.

RENAME TABLE sys_hw_bios TO `bios`
RENAME TABLE sys_hw_hard_drive TO `disk`
RENAME TABLE sys_sw_dns TO `dns`
RENAME TABLE sys_sw_log TO `log`
RENAME TABLE sys_hw_memory TO `memory`
RENAME TABLE sys_hw_module TO `module`
RENAME TABLE sys_hw_monitor TO `monitor`
RENAME TABLE sys_hw_motherboard TO `motherboard`
RENAME TABLE sys_hw_optical_drive TO `optical`
RENAME TABLE sys_sw_netstat TO `netstat`
RENAME TABLE sys_hw_network_card TO `network`
RENAME TABLE sys_hw_partition TO `partition`
RENAME TABLE sys_hw_processor TO `processor`
RENAME TABLE sys_hw_scsi_controller TO `scsi`
RENAME TABLE sys_sw_group TO `user_group`
RENAME TABLE sys_sw_pagefile TO `pagefile`
RENAME TABLE sys_sw_print_queue TO `print_queue`
RENAME TABLE sys_sw_route TO `route`
RENAME TABLE sys_sw_service TO `service`
RENAME TABLE sys_sw_share TO `share`
RENAME TABLE sys_sw_software TO `software`
RENAME TABLE sys_sw_software_key TO `software_key`
RENAME TABLE sys_hw_sound TO `sound`
RENAME TABLE sys_sw_user TO `user`
RENAME TABLE sys_sw_variable TO `variable`
RENAME TABLE sys_hw_video TO `video`
RENAME TABLE sys_sw_virtual_machine TO `vm`
RENAME TABLE sys_hw_warranty TO `warranty`
RENAME TABLE sys_sw_windows TO `windows`
RENAME TABLE oa_alert_log TO `change_log`

I find where the report get the information of this option and made a update in MySQL table:

UPDATE oa_report SET report_sql='SELECT change_log.id, change_log.system_id, change_log.timestamp, system.man_ip_address, system.hostname, system.man_description, change_log.details FROM system, change_log, oa_group_sys WHERE change_log.user_id is NULL AND change_log.system_id = system.system_id AND change_log.system_id = oa_group_sys.system_id AND oa_group_sys.group_id = @group GROUP BY change_log.id ORDER BY change_log.timestamp DESC' WHERE report_id='42';

UPDATE oa_report SET report_sql="SELECT change_log.id, change_log.system_id, change_log.timestamp, system.man_ip_address, system.hostname, system.man_description, change_log.details FROM system, change_log, oa_group_sys WHERE change_log.user_id is NULL AND change_log.system_id = system.system_id AND change_log.timestamp > DATE_SUB(NOW(),INTERVAL 100 DAY) AND change_log.system_id = oa_group_sys.system_id AND change_log.details LIKE 'software%' AND oa_group_sys.group_id = @group GROUP BY change_log.id ASC" WHERE report_id='43';

The report back but some erros in php

Column Icon

A PHP Error was encountered
Severity: Notice
Message: Undefined property: stdClass::$icon
Filename: theme-tango/v_report_alerts.php
Line Number: 64
.png" style='border-width:0px;' title="" alt=""/>

Column DB Table

A PHP Error was encountered
Severity: Notice
Message: Undefined property: stdClass::$db_table
Filename: theme-tango/v_report_alerts.php
Line Number: 66

Column DB Action

A PHP Error was encountered
Severity: Notice
Message: Undefined property: stdClass::$db_action
Filename: theme-tango/v_report_alerts.php
Line Number: 67

Im keep going, if I find more I will report.

Tks.

Attachments:
File comment: Image of error
php-error.png
php-error.png [ 17.3 KiB | Viewed 6202 times ]

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/