Open-AudIT
https://www.open-audit.org/phpBB3/

Need the database structure altered?
https://www.open-audit.org/phpBB3/viewtopic.php?f=9&t=1274
Page 1 of 1

Author:  mikeyrb [ Sun Aug 20, 2006 12:54 pm ]
Post subject:  Need the database structure altered?

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!

Author:  mikeyrb [ Sun Aug 20, 2006 1:01 pm ]
Post subject: 

[quote="Brun"]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;[/code]

Suggestiong was offered that we change it to TEXT.

Author:  lorenz [ Fri Aug 25, 2006 7:49 am ]
Post subject: 

See this : http://www.open-audit.org/phpbb2/viewtopic.php?t=1332

The problem is the default configuration of MySQL 5.0

Author:  jsingh [ Fri Feb 13, 2009 6:25 am ]
Post subject:  Re: Need the database structure altered?

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
[/code]

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

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/