Been using OpenAudIT for a while now with no problems. I recently upgraded to Version 08.07.23. I started seeing weird things, error about missing memory tables, and such. I did a fresh, new install of 08.07.23 and am seeing some strange errors still.
When I try to get IE or Firefox version stats I see:
[code] Fatal Error:
SELECT DISTINCT software_name, software_version, COUNT( * ) AS count_item, round( 100 / ( SELECT count(software_uuid) FROM software, system WHERE software_name = 'Internet Explorer' AND software_timestamp=system_timestamp AND software_uuid=system_uuid ) * COUNT( * ) ,2) AS percentage FROM software, system WHERE software_name='Internet Explorer' AND software_timestamp=system_timestamp AND software_uuid=system_uuid GROUP BY software_version ORDER BY count_item DESC
Table 'openaudit.software' doesn't exist [/code]
Trying to get memory stats yields the following: [code]Fatal Error:
SELECT full_system_memory.system_memory, COUNT(*) count_item, round( 100 / ( SELECT count(*) FROM (select *, sum(memory_capacity) AS system_memory FROM memory GROUP BY memory_uuid ) as per_mem ) * COUNT( * ), 2 ) AS percentage FROM (select *, sum(memory_capacity) AS system_memory FROM memory GROUP BY memory_uuid, memory_timestamp) AS full_system_memory, system WHERE memory_timestamp = system_timestamp and system_uuid = memory_uuid GROUP BY full_system_memory.system_memory ORDER BY count_item DESC
Table 'openaudit.memory' doesn't exist[/code]
All this is after a clean install, new DB and everything. Seems like i messed up somewhere, but this is the third time I did a clean install. Any thoughts? Thanks very much
_________________ Server Info: OS : Windows 2003, Apache 2.0.59, PHP 5.2.5 Auditing: 250 machines, 7 servers LDAP: Active Directory
Last edited by pjcarmen on Thu Nov 20, 2008 3:31 am, edited 1 time in total.
|