def DiscoveryMain(Framework):
# General variables
OSHVResult = ObjectStateHolderVector()
properties = Properties()
protocol = Framework.getDestinationAttribute('Protocol')
processToPortDict = {} ## {PID:[processName, listeningPort, ipAddress, path, version, status, processCommandline]}
databaseDict = {} ## {instanceName/SID:[dbType, listeningPort, ipAddress, installPath, version, status]}
database_ip_service_endpoints ={} ## {instanceName:[ip_address:port]}
client = None
secondClient = None
isWindows = 'true'
# Attempt to create a client
try:
client = Framework.createClient()
## We have a client
## Get processes running on the box
if(client):
dbconnect_utils.debugPrint(3, '[' + SCRIPT_NAME + ':DiscoveryMain] Got client <%s>' % client.getClientType())
if client.getClientType() == 'wmi':
## Open a second client connection to the DEFAULT namespace for registry access
props = Properties()
props.setProperty(AgentConstants.PROP_WMI_NAMESPACE, 'root\\DEFAULT')
secondClient = Framework.createClient(props)
processToPortDict = dbconnect_agentutils.getProcListByWMI(client, secondClient)
# elif client.getClientType() == 'snmp':
# processToPortDict = dbconnect_agentutils.getProcListBySNMP(client)
else:
Framework.reportWarning('Unable to connect using WMI')
## We have process and port infromation
## Find databases, if any
if processToPortDict != None and len(processToPortDict) > 0:
for pid in processToPortDict.keys():
logger.debug('dddd: ', '[' + SCRIPT_NAME + ':DiscoveryMain] Got process/service/software <%s> listening on port <%s:%s>' % ((processToPortDict[pid])[dbconnect_utils.PROCESSNAME_INDEX], (processToPortDict[pid])[dbconnect_utils.IP_INDEX], (processToPortDict[pid])[dbconnect_utils.PORT_INDEX]))
if Framework.getParameter('discover_oracle').strip().lower() == 'true':
dbconnect_oracle.findDatabases(client, processToPortDict, databaseDict, isWindows, secondClient)
if Framework.getParameter('discover_mssql').strip().lower() == 'true':
dbconnect_mssql.findDatabases(client, processToPortDict, databaseDict, database_ip_service_endpoints, isWindows, secondClient)
if databaseDict != None and len(databaseDict) > 0:
for dbName in databaseDict.keys():
dbconnect_utils.debugPrint('Found <%s> instance <%s> (%s) with listener port <%s:%s> and installed in <%s>' % ((databaseDict[dbName])[dbconnect_utils.DBTYPE_INDEX], dbName, (databaseDict[dbName])[dbconnect_utils.STATUS_INDEX], (databaseDict[dbName])[dbconnect_utils.IP_INDEX], (databaseDict[dbName])[dbconnect_utils.PORT_INDEX], (databaseDict[dbName])[dbconnect_utils.PATH_INDEX]))
OSHVResult.addAll(dbconnect_utils.makeDbOSHs(databaseDict))
else:
Framework.reportWarning('No databases found')
else:
## If we're here, we couldn't find any processes, service, or software
## and we have no data to search for databases
Framework.reportWarning('Unable to get a list or processes, services, or installed software')
else:
dbconnect_utils.debugPrint('Unable to connect using WMI')
except Exception, ex:
exInfo = ex.getMessage()
errormessages.resolveAndReport(exInfo, protocol, Framework)
def DiscoveryMain(Framework):
OSHVResult = ObjectStateHolderVector()
discoverOracle = _getBoolJobParameter(Parameters.DISCOVER_ORACLE, Framework)
discoverMssql = _getBoolJobParameter(Parameters.DISCOVER_MSSQL, Framework)
useSudo = _getBoolJobParameter(Parameters.USE_SUDO, Framework)
useLsof = _getBoolJobParameter(Parameters.USE_LSOF, Framework)
protocol = Framework.getDestinationAttribute('Protocol')
protocolDisplay = errormessages.protocolNames.get(protocol) or protocol
if not discoverOracle and not discoverMssql:
parameterNames = ", ".join((Parameters.DISCOVER_MSSQL, Parameters.DISCOVER_ORACLE))
msg = "None of parameters [%s] are enabled. Set at least one to true to discover corresponding Database." % parameterNames
errorObject = errorobject.createError(errorcodes.INTERNAL_ERROR_WITH_PROTOCOL_DETAILS, [protocolDisplay, msg], msg)
logger.reportWarningObject(errorObject)
logger.warn(msg)
logger.warn("Note: support for DB2 in this job is deprecated since CP13.")
return OSHVResult
client = None
shell = None
osName = None
processToPortDict = {} ## {PID:[processName, listeningPort, ipAddress, path, version, status, processCommandline]}
databaseDict = {} ## {instanceName/SID:[dbType, listeningPort, ipAddress, installPath, version, status]}
database_ip_service_endpoints ={} ## {instanceName:[ip_address:port]}
try:
client = Framework.createClient()
shell = shellutils.ShellUtils(client)
isWindows = 'false'
dbconnect_utils.debugPrint(3, '[' + SCRIPT_NAME + ':DiscoveryMain] Got client!')
if shell.isWinOs():
osName = 'Windows'
isWindows = 'true'
dbconnect_utils.debugPrint(3, '[' + SCRIPT_NAME + ':DiscoveryMain] Client is Windows!')
else:
if shell.getClientType() == 'ssh':
osName = netutils.getOSName(client, 'uname -a')
else:
osName = netutils.getOSName(client, 'uname')
dbconnect_utils.debugPrint(3, '[' + SCRIPT_NAME + ':DiscoveryMain] Client OS is <%s>' % osName)
## We have a shell client
## Get processes running on the box and ports they're listening on
if(client and osName):
osNameLower = osName.lower()
if re.search("windows", osNameLower):
processToPortDict = dbconnect_win_shellutils.getProcToPortDictOnWindows(client, Framework)
elif re.search("aix", osNameLower):
processToPortDict = dbconnect_unix_shellutils.getProcToPortDictOnAIX(client, useSudo, useLsof)
elif re.search("linux", osNameLower):
processToPortDict = dbconnect_unix_shellutils.getProcToPortDictOnLinux(client, useSudo, useLsof)
elif re.search("sun", osNameLower):
processToPortDict = dbconnect_unix_shellutils.getProcToPortDictOnSolaris(client, useSudo, useLsof)
elif re.search("hp-ux", osNameLower):
processToPortDict = dbconnect_unix_shellutils.getProcToPortDictOnHPUX(client, useSudo, useLsof)
else:
dbconnect_utils.debugPrint('Unknown operating system')
## We have process and port infromation
## Find databases, if any
if processToPortDict != None and len(processToPortDict) > 0:
for pid in processToPortDict.keys():
dbconnect_utils.debugPrint(3, '[' + SCRIPT_NAME + ':DiscoveryMain] Got process/service/software <%s> listening on port <%s:%s>' % ((processToPortDict[pid])[dbconnect_utils.PROCESSNAME_INDEX], (processToPortDict[pid])[dbconnect_utils.IP_INDEX], (processToPortDict[pid])[dbconnect_utils.PORT_INDEX]))
if discoverOracle:
dbconnect_oracle.findDatabases(client, processToPortDict, databaseDict, isWindows)
if discoverMssql and re.search("windows", osNameLower):
dbconnect_mssql.findDatabases(client, processToPortDict, databaseDict, database_ip_service_endpoints)
if databaseDict != None and len(databaseDict) > 0:
for dbName in databaseDict.keys():
logger.debug('Found <%s> instance <%s> (%s) with listener port <%s:%s> and installed in <%s>' % ((databaseDict[dbName])[dbconnect_utils.DBTYPE_INDEX], dbName, (databaseDict[dbName])[dbconnect_utils.STATUS_INDEX], (databaseDict[dbName])[dbconnect_utils.IP_INDEX], (databaseDict[dbName])[dbconnect_utils.PORT_INDEX], (databaseDict[dbName])[dbconnect_utils.PATH_INDEX]))
if database_ip_service_endpoints and len(database_ip_service_endpoints) > 0:
OSHVResult.addAll(dbconnect_utils.makeDbOSHs(databaseDict, database_ip_service_endpoints))
else:
OSHVResult.addAll(dbconnect_utils.makeDbOSHs(databaseDict))
else:
Framework.reportWarning('No databases found')
else:
## If we're here, we couldn't find any processes, service, or software
## and we have no data to search for databases
Framework.reportWarning('Unable to get a list or processes, services, or installed software using <%s>' % shell.getClientType())
else:
logger.debug('Unable to connect using NTCMD, SSH , or Telnet')
except JException, ex:
exInfo = ex.getMessage()
errormessages.resolveAndReport(exInfo, protocolDisplay, Framework)
def DiscoveryMain(Framework):
OSHVResult = ObjectStateHolderVector()
discoverOracle = _getBoolJobParameter(Parameters.DISCOVER_ORACLE,
Framework)
discoverMssql = _getBoolJobParameter(Parameters.DISCOVER_MSSQL, Framework)
useSudo = _getBoolJobParameter(Parameters.USE_SUDO, Framework)
useLsof = _getBoolJobParameter(Parameters.USE_LSOF, Framework)
protocol = Framework.getDestinationAttribute('Protocol')
protocolDisplay = errormessages.protocolNames.get(protocol) or protocol
if not discoverOracle and not discoverMssql:
parameterNames = ", ".join(
(Parameters.DISCOVER_MSSQL, Parameters.DISCOVER_ORACLE))
msg = "None of parameters [%s] are enabled. Set at least one to true to discover corresponding Database." % parameterNames
errorObject = errorobject.createError(
errorcodes.INTERNAL_ERROR_WITH_PROTOCOL_DETAILS,
[protocolDisplay, msg], msg)
logger.reportWarningObject(errorObject)
logger.warn(msg)
logger.warn(
"Note: support for DB2 in this job is deprecated since CP13.")
return OSHVResult
client = None
shell = None
osName = None
processToPortDict = {
} ## {PID:[processName, listeningPort, ipAddress, path, version, status, processCommandline]}
databaseDict = {
} ## {instanceName/SID:[dbType, listeningPort, ipAddress, installPath, version, status]}
database_ip_service_endpoints = {} ## {instanceName:[ip_address:port]}
try:
client = Framework.createClient()
shell = shellutils.ShellUtils(client)
isWindows = 'false'
dbconnect_utils.debugPrint(
3, '[' + SCRIPT_NAME + ':DiscoveryMain] Got client!')
if shell.isWinOs():
osName = 'Windows'
isWindows = 'true'
dbconnect_utils.debugPrint(
3, '[' + SCRIPT_NAME + ':DiscoveryMain] Client is Windows!')
else:
if shell.getClientType() == 'ssh':
osName = netutils.getOSName(client, 'uname -a')
else:
osName = netutils.getOSName(client, 'uname')
dbconnect_utils.debugPrint(
3, '[' + SCRIPT_NAME +
':DiscoveryMain] Client OS is <%s>' % osName)
## We have a shell client
## Get processes running on the box and ports they're listening on
if (client and osName):
osNameLower = osName.lower()
if re.search("windows", osNameLower):
processToPortDict = dbconnect_win_shellutils.getProcToPortDictOnWindows(
client, Framework)
elif re.search("aix", osNameLower):
processToPortDict = dbconnect_unix_shellutils.getProcToPortDictOnAIX(
client, useSudo, useLsof)
elif re.search("linux", osNameLower):
processToPortDict = dbconnect_unix_shellutils.getProcToPortDictOnLinux(
client, useSudo, useLsof)
elif re.search("sun", osNameLower):
processToPortDict = dbconnect_unix_shellutils.getProcToPortDictOnSolaris(
client, useSudo, useLsof)
elif re.search("hp-ux", osNameLower):
processToPortDict = dbconnect_unix_shellutils.getProcToPortDictOnHPUX(
client, useSudo, useLsof)
else:
dbconnect_utils.debugPrint('Unknown operating system')
## We have process and port infromation
## Find databases, if any
if processToPortDict != None and len(processToPortDict) > 0:
for pid in processToPortDict.keys():
dbconnect_utils.debugPrint(
3, '[' + SCRIPT_NAME +
':DiscoveryMain] Got process/service/software <%s> listening on port <%s:%s>'
%
((processToPortDict[pid]
)[dbconnect_utils.PROCESSNAME_INDEX],
(processToPortDict[pid])[dbconnect_utils.IP_INDEX],
(processToPortDict[pid])[dbconnect_utils.PORT_INDEX]))
if discoverOracle:
dbconnect_oracle.findDatabases(client, processToPortDict,
databaseDict, isWindows)
if discoverMssql and re.search("windows", osNameLower):
dbconnect_mssql.findDatabases(
client, processToPortDict, databaseDict,
database_ip_service_endpoints)
if databaseDict != None and len(databaseDict) > 0:
for dbName in databaseDict.keys():
logger.debug(
'Found <%s> instance <%s> (%s) with listener port <%s:%s> and installed in <%s>'
%
((databaseDict[dbName]
)[dbconnect_utils.DBTYPE_INDEX], dbName,
(databaseDict[dbName]
)[dbconnect_utils.STATUS_INDEX],
(databaseDict[dbName])[dbconnect_utils.IP_INDEX],
(databaseDict[dbName]
)[dbconnect_utils.PORT_INDEX],
(databaseDict[dbName]
)[dbconnect_utils.PATH_INDEX]))
if database_ip_service_endpoints and len(
database_ip_service_endpoints) > 0:
OSHVResult.addAll(
dbconnect_utils.makeDbOSHs(
databaseDict, database_ip_service_endpoints))
else:
OSHVResult.addAll(
dbconnect_utils.makeDbOSHs(databaseDict))
else:
Framework.reportWarning('No databases found')
else:
## If we're here, we couldn't find any processes, service, or software
## and we have no data to search for databases
Framework.reportWarning(
'Unable to get a list or processes, services, or installed software using <%s>'
% shell.getClientType())
else:
logger.debug('Unable to connect using NTCMD, SSH , or Telnet')
except JException, ex:
exInfo = ex.getMessage()
errormessages.resolveAndReport(exInfo, protocolDisplay, Framework)