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 Thu Mar 28, 2024 8:14 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 
Author Message
PostPosted: Wed Oct 20, 2010 2:15 am 
Offline
Newbie

Joined: Wed Oct 20, 2010 1:55 am
Posts: 5
I am trying to track down an issue with the functionality of the "All Dell Warranty" display in open-audit. When I click on the link to display the query for all_dell_warranty (https://192.168.xxx.xxx/openaudit/list. ... l_warranty), I only see the first system in the list. When I click to expand the list (it shows 4 pages worth of information SHOULD be displayed), I still only see the first system. I understand that the query happens within the inclusion of list_viewdef_all_dell_warranty.php from list.php, and everything in include.php looks fine from what I can tell. The query seems to work fine as I can see the page shows:

List all Dell Systems Warranty (1-30/101)

I tested the base of the query in mysql using this (taken directly from the list_viewdef_all_dell_warranty.php query):

[code]SELECT * FROM `system`, `processor`, `hard_drive` WHERE(system_vendor = 'Dell Computer Corporation' OR system_vendor = 'Dell Inc.') AND system_uuid = hard_drive_uuid AND system_uuid = processor_uuid AND hard_drive_uuid = processor_uuid
AND system_timestamp = processor_timestamp AND system_timestamp = hard_drive_timestamp AND processor_device_id = 'CPU0' AND hard_drive_index = 0;[/code]

and I got back 101 rows as expected.

Oddly enough, everything else works as expected. All of the other queries list correctly. Has anyone else seen this before?

_________________
Open-AudIT Version 09.03.17
CentOS release 5.5 (Final)


Top
 Profile  
Reply with quote  
PostPosted: Wed Oct 20, 2010 9:47 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
The query you posted selects the Dell machines and then the viewdef runs code for each machine to retrieve the "Warranty (days)" number from the Dell website. This is also why it's slow.

I'd check your php error logs to see if the code that retrieves the warranty days number is failing.


Top
 Profile  
Reply with quote  
PostPosted: Wed Oct 20, 2010 4:15 pm 
Offline
Newbie

Joined: Wed Oct 20, 2010 1:55 am
Posts: 5
Thanks for the quick response. I will check once I get back from my business trip (Friday).

_________________
Open-AudIT Version 09.03.17
CentOS release 5.5 (Final)


Top
 Profile  
Reply with quote  
PostPosted: Sat Oct 23, 2010 1:02 am 
Offline
Newbie

Joined: Wed Oct 20, 2010 1:55 am
Posts: 5
Okay, so I checked this morning to see what I could find in the error logs. Within /var/log/httpd/ I did a tail -f ssl_error_log and then went to the web browser and clicked on the all_dell_warranty query. Here are the results:

[Fri Oct 22 07:40:54 2010] [error] [client xxx.xxx.xxx.xxx] PHP Notice: Use of undefined constant content - assumed 'content' in /var/www/html/openaudit/include_dell_warranty_functions.php on line 49, referer: https://xxx.xxx.xxx.xxx/openaudit/list. ... ll_systems
[Fri Oct 22 07:40:54 2010] [error] [client xxx.xxx.xxx.xxx] PHP Fatal error: Call to undefined function mb_convert_encoding() in /var/www/html/openaudit/include_dell_warranty_functions.php on line 141, referer: https://xxx.xxx.xxx.xxx/openaudit/list. ... ll_systems
[Fri Oct 22 07:45:31 2010] [error] [client xxx.xxx.xxx.xxx] PHP Notice: Use of undefined constant content - assumed 'content' in /var/www/html/openaudit/include_dell_warranty_functions.php on line 49, referer: https://xxx.xxx.xxx.xxx/openaudit/list. ... ll_systems
[Fri Oct 22 07:45:31 2010] [error] [client xxx.xxx.xxx.xxx] PHP Fatal error: Call to undefined function mb_convert_encoding() in /var/www/html/openaudit/include_dell_warranty_functions.php on line 141, referer: https://xxx.xxx.xxx.xxx/openaudit/list. ... ll_systems
[Fri Oct 22 07:49:44 2010] [error] [client xxx.xxx.xxx.xxx] PHP Notice: Use of undefined constant content - assumed 'content' in /var/www/html/openaudit/include_dell_warranty_functions.php on line 49, referer: https://xxx.xxx.xxx.xxx/openaudit/list. ... nmap_ports
[Fri Oct 22 07:49:45 2010] [error] [client xxx.xxx.xxx.xxx] PHP Fatal error: Call to undefined function mb_convert_encoding() in /var/www/html/openaudit/include_dell_warranty_functions.php on line 141, referer: https://xxx.xxx.xxx.xxx/openaudit/list. ... nmap_ports

I am checking my configuration of apache / php to confirm I have mbstring support enable now.

_________________
Open-AudIT Version 09.03.17
CentOS release 5.5 (Final)


Top
 Profile  
Reply with quote  
PostPosted: Sat Oct 23, 2010 1:23 am 
Offline
Newbie

Joined: Wed Oct 20, 2010 1:55 am
Posts: 5
What I did to fix this:

1) installed php_mbstring
2) added extension=php_mbstring.so to etc/php.ini file
3) service httpd restart

Now everything works.

THANK YOU! >=]

_________________
Open-AudIT Version 09.03.17
CentOS release 5.5 (Final)


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.  [ 5 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