Open-AudIT

What's on your network?
It is currently Sun Jan 21, 2018 9:02 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: OAv2 Alpha 4 released
PostPosted: Tue Sep 21, 2010 9:22 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
Grab it from Launchpad.
http://open-audit.blogspot.com/

I got sick of not releasing, so here it is - warts and all...

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Wed Sep 22, 2010 7:11 am 
Offline
Newbie
User avatar

Joined: Mon Jun 21, 2010 11:39 pm
Posts: 13
Location: Iowa, USA
Some questions:
1) If I upgrade to OAv2 Alpha 4 from OAv2 RC, will it retain/pull previous data?
2) Does Windows 7 licensing work on Alpha 4?
3) I have to manually copy and schedule the script on every computer, I will need to keep the URL the same. Can I do that without messing anything else up?


Top
 Profile  
Reply with quote  
PostPosted: Wed Sep 22, 2010 9:42 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
Quote:
1) If I upgrade to OAv2 Alpha 4 from OAv2 RC, will it retain/pull previous data?

There is no upgrade from one version to another.
There are SQL differences.
If you REALLY need to keep your current data, I'd suggest a database definition dump, compare the differences and modify your existing database to suit.
Really though, unless you need historical information (say partition useage), I'd just wipe and install the new version. Run the VBscript and boom - done.

Quote:
2) Does Windows 7 licensing work on Alpha 4?

I don't have a Win7 box to test with, so I've done nothing here. I'll see if I can find code in the forums to add in, but I can't test it at all...

Quote:
3) I have to manually copy and schedule the script on every computer, I will need to keep the URL the same. Can I do that without messing anything else up?

If you copy the new script around and install the new version - yes, the URL (for submitting audit results) is the same.

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Wed Sep 22, 2010 11:30 pm 
Offline
Newbie
User avatar

Joined: Mon Jun 21, 2010 11:39 pm
Posts: 13
Location: Iowa, USA
Mark wrote:
If you copy the new script around and install the new version - yes, the URL (for submitting audit results) is the same.


I have it setup with a script that downloads the most recent audit script, then runs it, then cleans itself up. I got the download script from this post: viewtopic.php?f=9&t=3683

Code:
'Declare variables
Dim oXMLHTTP
Dim oStream
Dim WSHShell
Dim AuditFiles(1)
Dim objFile
Dim objRandom
Dim CleanupFiles(2)

'Input variables
OAURL = "https://audit.webserver.com"

AuditFiles(0)="audit.vbs"
AuditFiles(1)="list_export_config.php"

'Create Objects
Set WSHShell = WScript.CreateObject("WScript.Shell")
Set fso = CreateObject("Scripting.FileSystemObject")
Set objRandom = CreateObject( "System.Random" )

'Get Script folder
scriptFullName = WScript.ScriptFullName
TargetDir = Left ( scriptFullName, _
   InStrRev ( scriptFullName, WScript.ScriptName) - 1 )
   
'Retrieve Audit Files
For Each objFile in AuditFiles
   'Check if file exists and delete if possible
   If (fso.FileExists(TargetDir & objFile)) Then
      Set aFile = fso.GetFile(TargetDir & objFile)
      aFile.Delete
   End If
   Set oXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP")
   oXMLHTTP.Open "GET", OAURL & "/" & objFile, False
   oXMLHTTP.setOption 2, 13056
   oXMLHTTP.Send
   If oXMLHTTP.Status = 200 Then
         'Try to download from root
         Set oStream = CreateObject("ADODB.Stream")
         oStream.Open
         oStream.Type = 1
         oStream.Write oXMLHTTP.responseBody
         oStream.SaveToFile TargetDir & objFile
         oStream.Close
   Else
      oXMLHTTP.Open "GET", OAURL & "/scripts/" & objFile, False
      oXMLHTTP.Send
      If oXMLHTTP.Status = 200 Then
            'Try to download from scripts folder
            Set oStream = CreateObject("ADODB.Stream")
            oStream.Open
            oStream.Type = 1
            oStream.Write oXMLHTTP.responseBody
            oStream.SaveToFile TargetDir & objFile
            oStream.Close
            Else
               'Error downloading, exiting script
               WScript.Quit(2)
      End If   
   End If
Next

'Check if file exists and delete if possible
If (fso.FileExists(TargetDir & "audit.config")) Then
      Set aFile = fso.GetFile(TargetDir & "audit.config")
      aFile.Delete
End If

'Rename php file to config
fso.MoveFile TargetDir & AuditFiles(1), TargetDir & "audit.config"

'Execute audit
WSHShell.Run "cscript """ & TargetDir & AuditFiles(0) & """", 2, true

'Cleanup
CleanupFiles(0)=TargetDir & "audit.config"
CleanupFiles(1)=TargetDir & AuditFiles(0)
CleanupFiles(2)=TargetDir & AuditFiles(1)
For Each objFile in CleanupFiles
   If (fso.FileExists(objFile)) Then
         Set aFile = fso.GetFile(objFile)
         aFile.Delete
   End If
Next


I set it up so that even if I upgrade to a newer version of OAv2, then it will still be downloading and running the most recent audit script (because manually updating the script on each of my 100+ computers would really suck). This is more of an FYI than a question. Would you consider including this script in with the others in the "scripts" folder? It would also be great to have a text doc in there that describes what each script in the scripts folder does, and when it makes the most sense to use them.

Thanks again for your work. I'm planning to upgrade to OAv2 Alpha 4 on Thursday. Will post results.


Top
 Profile  
Reply with quote  
PostPosted: Wed Sep 22, 2010 11:51 pm 
Offline
Newbie
User avatar

Joined: Mon Jun 21, 2010 11:39 pm
Posts: 13
Location: Iowa, USA
Mark wrote:
I don't have a Win7 box to test with, so I've done nothing here. I'll see if I can find code in the forums to add in, but I can't test it at all...


This may be the thread you need: viewtopic.php?f=10&t=3693


Top
 Profile  
Reply with quote  
PostPosted: Thu Sep 23, 2010 7:52 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
Quote:
Would you consider including this script in with the others in the "scripts" folder?

In OAv2 there is no "scripts" folder.
Having said that, I can see what you're doing and I'll give some thought to something similar in OAv2.

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Fri Sep 24, 2010 5:06 am 
Offline
Newbie
User avatar

Joined: Mon Jun 21, 2010 11:39 pm
Posts: 13
Location: Iowa, USA
Mark wrote:
In OAv2 there is no "scripts" folder.

Hmm... sorry I can't remember where I got that scripts folder then.

Mark wrote:
Having said that, I can see what you're doing and I'll give some thought to something similar in OAv2.

Thanks!


Top
 Profile  
Reply with quote  
PostPosted: Fri Sep 24, 2010 6:20 am 
Offline
Newbie
User avatar

Joined: Mon Jun 21, 2010 11:39 pm
Posts: 13
Location: Iowa, USA
I have it installed. Where do I find the new audit.vbs file? In the OAv2 RC there was an option under >Admin >Audit My Machine which would allow you to download the audit.vbs file.


Top
 Profile  
Reply with quote  
PostPosted: Fri Sep 24, 2010 8:14 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
My apologies, but I think you're confused.
OAv2 is completely different code to Open-AudIT.
OAv2 has had releases Alpha 1 through 4.
There has not been a release candidate for OAv2.
There is no upgrade path from Open-AudIT to OAv2.

Open-AudIT has a "scripts" folder - OAv2 does not.
OAv2 has no Admin >Audit My Machine menu option.

If you have overwritten an Open-AudIT installation with OAv2, you will need to revert. The databases are not compatible. The schema is loosely based on OAv2, but heavily changed to the point that converting would be a project within itself.

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Sat Sep 25, 2010 12:01 am 
Offline
Newbie
User avatar

Joined: Mon Jun 21, 2010 11:39 pm
Posts: 13
Location: Iowa, USA
Mark wrote:
My apologies, but I think you're confused.
OAv2 is completely different code to Open-AudIT.
OAv2 has had releases Alpha 1 through 4.
There has not been a release candidate for OAv2.
There is no upgrade path from Open-AudIT to OAv2.

Open-AudIT has a "scripts" folder - OAv2 does not.
OAv2 has no Admin >Audit My Machine menu option.

If you have overwritten an Open-AudIT installation with OAv2, you will need to revert. The databases are not compatible. The schema is loosely based on OAv2, but heavily changed to the point that converting would be a project within itself.


Wow I really look like a schmuck right about now. :? That makes sense. Sorry for all the hassle, for whatever reason I thought I was on OAv2.

I didn't wipe Open-AudIT from our server so I have all the data -- no problems there.

So how is OAv2 meant to function? What's the general idea behind it and how does it differ from Open-AudIT? (Not really looking for backend mechanics -- more asking about frontend usability).

Thanks for being patient with me and thanks for offering such awesome software for free.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 4 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