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 Fri Mar 29, 2024 10:58 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: Sun Feb 03, 2013 12:21 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1964
Location: Brisbane, Australia
Both source and XAMPP versions available.
Grab it from the [url=http://www.open-audit.org/downloads.php]downloads[/url] page.

NOTE - Make sure to use the new audit_windows.vbs

Processor Description fixed.
Active Directory authentication for users.
Basic Software Licensing.
Create audit scripts (audit_windows only at this stage) from the web interface.
Upload attachments (documents, invoice scans, etc) per device.

_________________
Support and Development hours available from [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
 Post subject: Re: Beta 9 released
PostPosted: Mon Feb 04, 2013 8:12 pm 
Offline
Newbie

Joined: Wed Jun 15, 2011 1:12 am
Posts: 30
When I tried to upgrade my database from beta 8.5 to beta 9 I got an error saying table OA_asset_line did not exist.

I created the missing table using the OAv2_mysql script and then dropped the allocate_type and allocate_next columns, as I got an error about adding them when running the upgrade script a second time.

After dropping the 2 columns the upgrade script then ran OK.

I understand that the OAv2_mysql script has all the changes up to and including the changes needed to create a beta 9 database hence my having to remove the columns just so the script could add them again. I wanted to ensure that it ran OK otherwise and change the database version via the script.


Top
 Profile  
Reply with quote  
 Post subject: Re: Beta 9 released
PostPosted: Mon Feb 04, 2013 10:52 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1964
Location: Brisbane, Australia
Do you have a table in your running database called oa_asset_order?

_________________
Support and Development hours available from [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
 Post subject: Re: Beta 9 released
PostPosted: Tue Feb 05, 2013 12:14 am 
Offline
Newbie

Joined: Wed Jun 15, 2011 1:12 am
Posts: 30
No I don't. I only have
oa_asset_line and
oa_asset_select

Shall I just create it using the OAv2_mySQL?

I have not created a new database since one of the early alpha builds, I have been continually upgrading the same one.

If it helps, below is the output from the show tables command

"Tables_in_OAv2"
"oa_alert_log"
"oa_asset_line"
"oa_asset_select"
"oa_audit_log"
"oa_change"
"oa_change_log"
"oa_config"
"oa_connection"
"oa_contact"
"oa_device"
"oa_device_col"
"oa_graph"
"oa_group"
"oa_group_column"
"oa_group_sys"
"oa_group_user"
"oa_location"
"oa_location_org"
"oa_net_nmap_ports"
"oa_net_scan_latest"
"oa_net_scan_log"
"oa_net_scan_type"
"oa_org"
"oa_report"
"oa_report_column"
"oa_switch_ports"
"oa_user"
"oa_user_sessions"
"system"
"sys_hw_battery"
"sys_hw_bios"
"sys_hw_graphs_disk"
"sys_hw_hard_drive"
"sys_hw_memory"
"sys_hw_modem"
"sys_hw_monitor"
"sys_hw_motherboard"
"sys_hw_network_card"
"sys_hw_network_card_ip"
"sys_hw_optical_drive"
"sys_hw_partition"
"sys_hw_processor"
"sys_hw_scsi_controller"
"sys_hw_sound"
"sys_hw_video"
"sys_hw_warranty"
"sys_man_additional_fields"
"sys_man_additional_fields_data"
"sys_man_attachment"
"sys_man_audits"
"sys_man_invoice"
"sys_man_invoice_line"
"sys_man_notes"
"sys_sw_antivirus"
"sys_sw_database"
"sys_sw_database_details"
"sys_sw_database_log"
"sys_sw_dns"
"sys_sw_firewall"
"sys_sw_firewall_auth_app"
"sys_sw_firewall_ports"
"sys_sw_group"
"sys_sw_log"
"sys_sw_pagefile"
"sys_sw_print_queue"
"sys_sw_route"
"sys_sw_scheduled_task"
"sys_sw_service"
"sys_sw_share"
"sys_sw_share_perms"
"sys_sw_software"
"sys_sw_software_key"
"sys_sw_startup"
"sys_sw_user"
"sys_sw_variable"
"sys_sw_web_server"
"sys_sw_web_server_ext"
"sys_sw_web_site"
"sys_sw_web_site_header"
"sys_sw_web_site_virtual"
"sys_sw_windows"


Top
 Profile  
Reply with quote  
 Post subject: Re: Beta 9 released
PostPosted: Tue Feb 05, 2013 12:51 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1964
Location: Brisbane, Australia
[quote="aylnews"]Shall I just create it using the OAv2_mySQL?

No - 9.2 will create it for you.

_________________
Support and Development hours available from [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.


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