Open-AudIT

What's on your network?
It is currently Mon Aug 20, 2018 3:37 pm

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: Sun Aug 20, 2006 12:54 pm 
So, there are many threads with requests for the DB being altered. This will be the thread to rule them all. I have no way of keeping up with all the requests, so if you could please write them here again, I can try and get them into the code. Please check to see if your specific change is not already listed before posting.

In the next week or two, I will be writing an upgrade script that should hopefully be easy to update, and will allow us to make changes when needed!


Top
  
Reply with quote  
 Post subject:
PostPosted: Sun Aug 20, 2006 1:01 pm 
Brun wrote:
Got that error while trying to create the db with latest trunk !

#1074 - 'software_uninstall' field too long (max = 255). Use a BLOB

Code:
DROP TABLE IF EXISTS `software`;
CREATE TABLE `software` (
  `software_id` int(10) unsigned NOT NULL auto_increment,
  `software_uuid` varchar(100) NOT NULL default '',
  `software_name` varchar(100) NOT NULL default '',
  `software_version` varchar(50) NOT NULL default '',
  `software_location` varchar(200) NOT NULL default '',
  `software_uninstall` varchar(300) NOT NULL default '',
  `software_install_date` varchar(100) NOT NULL default '',
  `software_publisher` varchar(100) NOT NULL default '',
  `software_install_source` varchar(200) NOT NULL default '',
  `software_system_component` varchar(2) NOT NULL default '',
  `software_url` varchar(100) NOT NULL default '',
  `software_comment` varchar(200) NOT NULL default '',
  `software_count` varchar(5) NOT NULL default '',
  `software_timestamp` bigint(20) unsigned NOT NULL default '0',
  `software_first_timestamp` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`software_id`),
  KEY `id` (`software_uuid`),
  KEY `id2` (`software_timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


Suggestiong was offered that we change it to TEXT.


Top
  
Reply with quote  
 Post subject:
PostPosted: Fri Aug 25, 2006 7:49 am 
Offline
Newbie
User avatar

Joined: Wed Aug 16, 2006 9:06 am
Posts: 45
Location: Rome - Italy - Europe (GMT +2)
See this : http://www.open-audit.org/phpbb2/viewtopic.php?t=1332

The problem is the default configuration of MySQL 5.0

_________________
Lorenz


Top
 Profile  
Reply with quote  
PostPosted: Fri Feb 13, 2009 6:25 am 
Offline
Contributor

Joined: Fri Sep 28, 2007 12:07 am
Posts: 189
Hi,

I need to get the database updated so we can begin uploading the ODBC data to the OA server:

Here is the thread with the dev:

viewtopic.php?f=9&t=2617

Here is the ODBC portion of the audit.vbs

Code:
'
'''''''''''''''''''''''''''
'ODBC Connections '
'''''''''''''''''''''''''''
if ((ServicePack = "2" AND SystemBuildNumber = "2600") OR (SystemBuildNumber = "3790" AND ServicePack = "1" OR ServicePack = "2") OR (SystemBuildNumber = "6000")) then
  comment = "ODBC Connections"
  if verbose = "y" then
    wscript.echo comment
  end if
  On Error Resume Next

  strKeyPath = "SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources"
  oReg.EnumValues HKEY_LOCAL_MACHINE,strKeyPath,arrSubKeys

  For Each subkey In arrSubKeys
    comment = subkey
    if verbose = "y" then
      wscript.echo "Name: " & comment
    end if
    On Error Resume Next
    odbc_name = subkey
    strKeyPath1 = "SOFTWARE\ODBC\ODBC.INI\" & subkey
    comment = strKeyPath1
    if verbose = "y" then
      wscript.echo comment
    end if
    On Error Resume Next
    oReg.EnumValues HKEY_LOCAL_MACHINE, strKeyPath1, arrValueNames, arrValueTypes
    For i=0 To UBound(arrValueNames)
        oReg.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath1,_
        arrValueNames(i),strValue
        if verbose = "y" then
          wscript.echo arrValueNames(i) & ": " & strValue     
        end if
        On Error Resume Next
    Next
  Next

end if


We need to upload to a new table maybe named ODBC the following values:

1. Each subkey/odbc_name from the array arrSubKeys - name of ODBC Connection
2. Each strKeyPath1 - ODBC path
3. Each value in the loop of the arrValueNames and their corresponding strValue

Can anyone help?

Thanks,

Jason




Thanks,

Jason

_________________
OA Deployment:
Windows 2003 with XAMPP install
80 Windows Servers
250 Windows workstations (mixed XP and 2000)
5 MACs
Multiple printers, switches, routers, firewalls, and other servers (ESX, AIX etc.)


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