Manually Configuring the Satellite Servers

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.

  1. Install ODBC DSNs (type SYSTEM) on the full-service Satellite for HPCA matching the names defined on the Core server (for Inventory and PATCH databases).
  2. Stop the Messaging Server service on each Satellite server and delete the log files.
  3. Open the 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

    }

  4. Modify the 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

    }

  5. Delete the following section:

    if { [ServerType] != "core" } {

    #--------------------------------------------------------------

    # Satellite RMS Configuration - forward everything

    #--------------------------------------------------------------

    msg::router::add router {

    TO *

    USE forward

    }

    }

  6. Replace serverEnabled with LocalEnabled in the DIAG section as follows:

    if { [ServerEnabled $Config(DIAG)] } {

    with

    if { [LocalEnabled $Config(DIAG)] } {

  7. Add the ForwardEnabled section in the DIAG section as follows:

    if { [ForwardEnabled $Config(DIAG)] } {

    #--------------------------------------------------------------

    # Forwarding Upstream

    #--------------------------------------------------------------

    msg::router::add router {

    TO *

    USE forward

    }

    }

  8. Replace serverEnabled with LocalEnabled in the RMP section as follows:

    if { [ServerEnabled $Config(RMP)] } {

    with

    if { [LocalEnabled $Config(RMP)] } {

  9. Add the ForwardEnabled section to the RMP section as follows:

    if { [ForwardEnabled $Config(RMP)] } {

    #--------------------------------------------------------------

    # Forwarding Upstream

    #--------------------------------------------------------------

    msg::router::add router {

    TO CORE.RMP

    USE forward

    }

    }

  10. Replace serverEnabled to LocalEnabled in the DTM section as follows:

    if { [ServerEnabled $Config(DTM)] } {

    with

    if { [LocalEnabled $Config(DTM)] } {

  11. Add the ForwardEnabled section in the DTM section as follows:

    if { [ForwardEnabled $Config(DTM)] } {

    #--------------------------------------------------------------

    # Forwarding Upstream

    #--------------------------------------------------------------

    msg::router::add router {

    TO DTM

    USE forward

    }

    }

  12. Replace serverEnabled with LocalEnabled in the OPE section as follows.

    if { [ServerEnabled $Config(OPE)] } {

    with

    if { [LocalEnabled $Config(OPE)] } {

  13. Add the 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

    }

    }

  14. Replace serverEnabled to LocalEnabled in the CORE.ODBC section as follows:

    if { [ServerEnabled $Config(CORE.ODBC)] } {

    with

    if { [LocalEnabled $Config(CORE.ODBC)] } {

  15. Add the 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

    }

    }

  16. Replace serverEnabled with LocalEnabled for PATCH.ODBC section as follows:

    if { [ServerEnabled $Config(PATCH.ODBC)] } {

    with

    if { [LocalEnabled $Config(PATCH.ODBC)] } {

  17. Add the 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

    }

    }

  18. Add your DSN information created in step 1 in the 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

    }

  19. Apply the DSN information in PATCH.DDA.cfg file.


© 2003 - 2012 Hewlett-Packard Development Company, L.P.