Where does saphostctrl get path to hdbuserstore?

[former_member284597]

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

[jgleichmann]

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

[former_member284597]

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

[jgleichmann]

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

[jgleichmann]

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

[former_member284597]

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

[jgleichmann]

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>

[former_member284597]

Hi, I found already a solution.

Thank you,

Günther