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 Thu Mar 28, 2024 10:26 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 
[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.

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

_________________
[color=blue]Lorenz[/color]


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

_________________
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