You can also perform the following steps manually to configure HPCA full-service Satellite server to enable direct posting to the SQL/Oracle reporting database.
RMS.cfg
file and add the following section after the line "proc ServerType { } { return "satellite" }
":proc ServerType { } { return "satellite" }
#Add the following section( between" proc ServerType { } { return "satellite" } and atexit add log.flush" )
proc ServerEnabled { mode } { return [string match -nocase $mode [ServerType]] }
proc ForwardEnabled { option } {
#Compatibility for auto-selection based on server type, forward is only available on SATELLITE
if {[string equal -nocase $option "auto"]} {
return [string equal -nocase [ServerType] "satellite"]
}
# Additional option processing
if {[string equal -nocase $option "upstream"] || [string equal -nocase $option "both"]} {
return true
}
return false
}
proc LocalEnabled { option } {
#Compatibility for auto-selection based on server type, local is only available on CORE
if {[string equal -nocase $option "auto"]} {
return [string equal -nocase [ServerType] "core"]
}
# Additional option processing
if {[string equal -nocase $option "local"] || [string equal -nocase $option "both"]} {
return true
}
return false
}
Overrides Config
section as follows:Overrides Config {
CORE.ODBC local
PATCH.ODBC local
USAGE.ODBC core
RMP auto
DTM auto
OPE none
DIAG none
USAGE satellite
RRS core
}
if { [ServerType] != "core" } {
#--------------------------------------------------------------
# Satellite RMS Configuration - forward everything
#--------------------------------------------------------------
msg::router::add router {
TO *
USE forward
}
}
serverEnabled
with LocalEnabled
in the DIAG
section as follows:if { [ServerEnabled $Config(DIAG)] } {
with
if { [LocalEnabled $Config(DIAG)] } {
ForwardEnabled
section in the DIAG section as follows:if { [ForwardEnabled $Config(DIAG)] } {
#--------------------------------------------------------------
# Forwarding Upstream
#--------------------------------------------------------------
msg::router::add router {
TO *
USE forward
}
}
serverEnabled
with LocalEnabled
in the RMP section as follows:if { [ServerEnabled $Config(RMP)] } {
with
if { [LocalEnabled $Config(RMP)] } {
ForwardEnabled
section to the RMP section as follows:if { [ForwardEnabled $Config(RMP)] } {
#--------------------------------------------------------------
# Forwarding Upstream
#--------------------------------------------------------------
msg::router::add router {
TO CORE.RMP
USE forward
}
}
serverEnabled
to LocalEnabled
in the DTM section as follows:if { [ServerEnabled $Config(DTM)] } {
with
if { [LocalEnabled $Config(DTM)] } {
ForwardEnabled
section in the DTM section as follows:if { [ForwardEnabled $Config(DTM)] } {
#--------------------------------------------------------------
# Forwarding Upstream
#--------------------------------------------------------------
msg::router::add router {
TO DTM
USE forward
}
}
serverEnabled
with LocalEnabled
in the OPE section as follows.if { [ServerEnabled $Config(OPE)] } {
with
if { [LocalEnabled $Config(OPE)] } {
ForwardEnabled
section in the OPE section as follows:if { [ForwardEnabled $Config(OPE)] && ![ForwardEnabled $Config(RMP)] } {
#--------------------------------------------------------------
# Forwarding Upstream
#--------------------------------------------------------------
msg::router::add router {
TO CORE.RMP
USE forward
}
}
serverEnabled
to LocalEnabled
in the CORE.ODBC
section as follows: if { [ServerEnabled $Config(CORE.ODBC)] } {
with
if { [LocalEnabled $Config(CORE.ODBC)] } {
ForwardEnabled
section to the CORE.ODBC
section as follows:if { [ForwardEnabled $Config(CORE.ODBC)] } {
#--------------------------------------------------------------
# Forwarding Upstream
#--------------------------------------------------------------
msg::router::add router {
TO {CORE.RIM CORE.ODBC WBEM.ODBC INVENTORY.ODBC SECURITY VM}
USE forward
}
}
serverEnabled
with LocalEnabled
for PATCH.ODBC
section as follows:if { [ServerEnabled $Config(PATCH.ODBC)] } {
with
if { [LocalEnabled $Config(PATCH.ODBC)] } {
ForwardEnabled
section to the PATCH.ODBC
section as follows:if { [ForwardEnabled $Config(PATCH.ODBC)] } {
#--------------------------------------------------------------
# Forwarding Upstream
#--------------------------------------------------------------
msg::router::add router {
TO {PATCH PATCH5}
USE forward
}
}
Core.DDA.cfg
file as follows:msg::register core.odbc {
TYPE SQL
DSN "Core_Prod"
SERVER ""
USER "hpcacore_prod"
PASS "{AES256}UtmWvG+rnMl//K+bSCpbdg=="
USE ""
AUTOCOMMIT off
DSN_DELAY 30
DSN_PING 120
ENABLE-CORE true
ENABLE-WBEM true
ENABLE-INVENTORY true
ENABLE-VM true
AUTOCREATE true
AUTOLOAD true
STARTUPLOAD true
REJECTS rejects
}
PATCH.DDA.cfg
file.