Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Sat Mar 30, 2024 1:30 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
PostPosted: Fri Apr 17, 2009 1:29 am 
Offline
Helper

Joined: Wed Sep 05, 2007 1:43 am
Posts: 55
Actually it is not a bug. I install new server and openaudit on them, and found that audits incompletely loaded to database.
Here is break point:

[quote]Memory

SELECT MAX(memory_timestamp) FROM memory WHERE memory_uuid = 'BC651250-6709-E055-105F-82E2B370C49E'
SELECT count(memory_bank) as count FROM memory WHERE memory_bank = 'RAM slot #0' AND memory_type = 'DRAM' AND memory_form_factor = 'DIMM' AND memory_detail = 'EDO' AND memory_capacity = '1024' AND memory_speed = '' AND memory_tag = 'Physical Memory 0' AND memory_uuid = 'BC651250-6709-E055-105F-82E2B370C49E' AND (memory_timestamp = '' OR memory_timestamp = '20090416171827')
Insert Failed: Unknown column 'memory_tag' in 'where clause'
SELECT count(memory_bank) as count FROM memory WHERE memory_bank = 'RAM slot #0' AND memory_type = 'DRAM' AND memory_form_factor = 'DIMM' AND memory_detail = 'EDO' AND memory_capacity = '1024' AND memory_speed = '' AND memory_tag = 'Physical Memory 0' AND memory_uuid = 'BC651250-6709-E055-105F-82E2B370C49E' AND (memory_timestamp = '' OR memory_timestamp = '20090416171827')


If i copy SQL query manually - there is no errors. But i have no idea, what is the reason of failure?

Top
 Profile  
Reply with quote  
PostPosted: Sat Apr 18, 2009 5:24 pm 
Offline
Open-AudIT Fellow

Joined: Thu May 17, 2007 5:47 pm
Posts: 568
Location: Italy
It seems that your OA database is missing the "memory_tag" field in the "memory" table.
If this is confirmed, run the following SQL command against your OA DB:
[code]
ALTER TABLE `memory` ADD COLUMN `memory_tag` varchar(255) NOT NULL default '' AFTER `memory_speed`;
[/code]

_________________
Edoardo


Top
 Profile  
Reply with quote  
PostPosted: Tue Apr 21, 2009 5:29 pm 
Offline
Helper

Joined: Wed Sep 05, 2007 1:43 am
Posts: 55
It is my inattention. I manually check query in wrong database. :( Don`t debug at evening, guys ;)


Top
 Profile  
Reply with quote  
PostPosted: Tue Apr 21, 2009 9:34 pm 
Offline
Helper

Joined: Wed Sep 05, 2007 1:43 am
Posts: 55
But now cant reproduce situation with error in database. Strange.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group