Question Re: Where does saphostctrl get path to hdbuserstore? in Technology Q&A

Where does saphostctrl get path to hdbuserstore?

former_member284597 — Fri, 26 Feb 2021 15:43:03 GMT

Does anybody know, where saphostcontrol takes the path to the hdbuserstore File SSFS_HDB.DAT?

I have two identically installed+configured systems.

On one System the command

/usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseSystemStatus -dbname SYSTEMDB@<SID> -dbtype hdb

uses the hdbuserstore in /home/sidadm/.hdb/ <physicalhostname>/SSFS_HDB.DAT and one uses the userstore in /home/sidadm/.hdb/<virtualhostname>/SSFS_HDB.DAT

Where do I have to look for a possible difference in Config?

regards,

Günther

Re: Where does saphostctrl get path to hdbuserstore?

jgleichmann — Sun, 28 Feb 2021 16:58:42 GMT

Hello Günther,

the environment is the reason for this behaviour. Just check the documentation for details.

'Use the HDB_USE_IDENT environment variable to store your hdbuserstore in one environment so that users on all hosts can connect to the SAP HANA database using the same secure store information.'

If you have nothing defined the default is used => VTHOSTNAME. You can use different keys using the hdbuserstore -H <HOST> option

Check with user sidadm this:

cdhdb

grep VTHOSTNAME hdbenv*

The result is the defined environment of your HANA installation. The dbhostname is defined during the installation and can be changed via hdblcm and the rename option. Please note the possible changes to firewall rules, routing, network caching etc. can create possible side effects.

So, I don't believe that the systems configured identically.

Just check this commands:

chdhost

pwd

echo VTHOSTNAME

Regards,

Jens

Re: Where does saphostctrl get path to hdbuserstore?

former_member284597 — Mon, 01 Mar 2021 10:21:37 GMT

Hi Jens,

thank you for your answer. You might be right, that the systems are not identically configured. But i can not find the difference. That's the reason for my question. I already compared User Environment in home/sidadm , SAP Profiles, sapprofile.ini.... - no difference.

Concerning documentation: $HDB_USE_IDENT is not set; the flag -H was not used when installing Database or Clients nor when setting hdbuserstore Keys. When I execute echo $VTHOSTNAME it shows the virtual Hostname on both systems.

I am still curious where the saphostctrl takes its knowledge where to find the hdbuserstore.

Any other hints welcome.

Regards, Günther

Re: Where does saphostctrl get path to hdbuserstore?

jgleichmann — Mon, 01 Mar 2021 12:42:44 GMT

Hi Günter,

have you already compared the output of the following commands:

'sapcontrol -nr <xx> -function GetEnvironment' executed as <sapsid>adm

'ls -ltRa /var/opt/.hdb/'

cat /usr/sap/services

It's pretty hard to find out because I don't know how you setup your systems. Have you already tried to strace your OS command call?

Regards,

Jens

Re: Where does saphostctrl get path to hdbuserstore?

jgleichmann — Mon, 01 Mar 2021 12:46:02 GMT

Update: check you HostAgent version and note 2023587 may be it depends on how you have setup your DBs with saphostctrl

Re: Where does saphostctrl get path to hdbuserstore?

former_member284597 — Fri, 19 Mar 2021 14:15:20 GMT

Hi Jens,

all commands you named show identical outputs. I tried an strace and checked all the configfiles the command opens - again no difference between the two systems.

Regards, Günther

Re: Where does saphostctrl get path to hdbuserstore?

jgleichmann — Mon, 22 Mar 2021 09:30:09 GMT

Just reset your SAPDBCTRL setup.

Delete/clear:

saphostctrl -host <database_host_name> -user <user_name> 
<password> -dbname <TENANT-NAME>@<SID> -dbinstance 
HDB<instance_number> -dbtype hdb -function SetDatabaseProperty 
DBCredentials=CLEAR

Set it new with the correct server name:

saphostctrl -host <database_host_name> -user <user_name> 
<password> -dbname <TENANT-NAME>@<SID> -dbinstance 
HDB<instance_number> -dbtype hdb -dbuser <DBuser> -dbpass 
<DBpassword> -function SetDatabaseProperty DBCredentials=SET 
-dboption User=<dbuser> -dboption Password=<dbpassword>

Re: Where does saphostctrl get path to hdbuserstore?

former_member284597 — Thu, 31 Mar 2022 14:45:48 GMT

Hi, I found already a solution.

Thank you,

Günther