Wednesday, 24 March 2021

Connect Client systems to the “Solution Manager”: Easier, faster and better – Via Outside Discovery with saphostctrl

Introduction

Why should I configure the hostagent, secure and with Outside Discovery enabled?

Because it is easy and It only takes a little to connect correctly the satellite systems to the LMDB with all data suppliers.

And least but not last: to get better Landscape Data in your LMDB to make better Upgrades! (see further Information, at the bottom)

What do I have to do?

On SAP Host Agent folder /usr/sap/hostctrl/exe/ (UNIX) or C:\Program Files\SAP\hostctrl\exe\ (Windows), create some shell scripts or textfiles and run this commands:

1. Make hostagent secure

As root:

export password=secure

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/sap/hostctrl/exe/

export SECUDIR=/usr/sap/hostctrl/exe/sec

if [ ! -d “$SECUDIR” ]; then

mkdir /usr/sap/hostctrl/exe/sec

cd /usr/sap/hostctrl/exe/sec

/usr/sap/hostctrl/exe/sapgenpse get_pse -p SAPSSLS.pse -noreq -x $password CN=`hostname`

/usr/sap/hostctrl/exe/sapgenpse seclogin -p SAPSSLS.pse -x $password -O sapadm

chmod 640 /usr/sap/hostctrl/exe/sec/SAPSSLS.pse

fi

This will enable Port 1129 for hostagent

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Study

2. Configure Outside Discovery for hostagent


As root:

export fqhn=`hostname -f`
export port=50000
export user=SL_user_DS
export password=secure

/usr/sap/hostctrl/exe/saphostctrl -function ConfigureOutsideDiscovery -enable -sldhost $fqhn -sldport $port -sldusername $user -sldpassword $password

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Study

3. Connect to the SLD (Create “slddest.cfg” and “slddest.cfg.key Files)


As root:
/usr/sap/hostctrl/exe/sldreg -configure /usr/sap/hostctrl/exe/slddest.cfg -usekeyfile

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Study

older existing files will be renamed as backup

4. Sent Data to SLD


as root:

export sidadm=sitadm
export SID=SIT
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/sap/hostctrl/exe/

# for the hostagent
/usr/sap/hostctrl/exe/saposcol -b | /usr/sap/hostctrl/exe/sldreg -connectfile /usr/sap/hostctrl/exe/slddest.cfg -stdin -ol dtransferdtd

# for the <SID> (ABAP)
DIR=/sapmnt/$SID/global
if [ -d “$DIR” ]; then
cp /usr/sap/hostctrl/exe/slddest.cfg $DIR
cp /usr/sap/hostctrl/exe/slddest.cfg.key $DIR
fi
su – $sidadm -c “setenv LD_LIBRARY_PATH /usr/sap/hostctrl/exe; /usr/sap/hostctrl/exe/saposcol -b | /usr/sap/hostctrl/exe/sldreg -connectfile /usr/sap/hostctrl/exe/slddest.cfg -stdin -ol dtransferdtd”

# for the <SID> (HANA)
DIR=/hana/shared/$SID/global
if [ -d “$DIR” ]; then
cp /usr/sap/hostctrl/exe/slddest.cfg $DIR
cp /usr/sap/hostctrl/exe/slddest.cfg.key $DIR
fi
su – $sidadm -c “setenv LD_LIBRARY_PATH /usr/sap/hostctrl/exe; /usr/sap/hostctrl/exe/saposcol -b | /usr/sap/hostctrl/exe/sldreg -connectfile /usr/sap/hostctrl/exe/slddest.cfg -stdin -ol dtransferdtd”

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Study

5. Register Hana DB into the SLD


Create config.txt File

[General]

# SLD Host Name
sld_hostname=<hostname.domain>

# SLD Port
sld_port=<Port-Nr.>

# Remote Execution ( Default: ssh; Valid values: ssh | saphostagent )
remote_execution=ssh

# SLD User Name
sld_username=<USER>

# SLD Password
sld_password=<Password>

# Use HTTPS
https=n

[Action]

action=configure_sld

now execute

As root:

export SID=SIT

/hana/shared/$SID/hdblcm/hdblcm –configfile=/tmp/hostagent/config.txt

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Study

Bonus


Register SystemDB to saphostctrl Agent

as root:

export passwort=secret

SYSTEMDB

/usr/sap/hostctrl/exe/saphostctrl -host name -user sidadm $passwort -dbname SYSTEMDB@SID  -dbtype hdb -dbuser SYSTEM -dbpass $passwort -function SetDatabaseProperty DBCredentials=SET -dboption User=SAPDBCTRL -dboption Password=$passwort

TENANT

/usr/sap/hostctrl/exe/saphostctrl -host name -user sidadm $passwort -dbname TENANT@SID  -dbtype hdb -dbuser SYSTEM -dbpass $passwort -function SetDatabaseProperty DBCredentials=SET -dboption User=SAPDBCTRL -dboption Password=$passwort

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Study

That’s all, see the result:


Technical System Application Server ABAP

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Study

Technical System SAP Hana Database

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Study

Hosts

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Career, SAP HANA Study

that’s what I want !!!

Logfiles to check

under /usr/sap/hostctrl/work/

dev_saphostexec

outsidediscovery.log

dev_sapdbctrl

under /usr/sap/hostctrl/exe

sldreg.log

No comments:

Post a Comment