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/ |