Add host failed

[Former Member]

Hi,

I tried to add host into my existing HANA system, but  received below errors:

Header 1

06:28:21.600 - INFO: ----------------------------------------------------------- 06:28:21.600 - INFO: Adding additional host to SAP HANA Database... 06:28:21.600 - INFO: ----------------------------------------------------------- 06:28:21.601 - INFO:   Starting external program /hana/shared/TDB/global/hdb/install/bin/hdbmodify 06:28:21.601 - INFO:     Command line is: /hana/shared/TDB/global/hdb/install/bin/hdbmodify -b --instlog_dir=/var/tmp/hdb_TDB_hdblcm_add_hosts_2016-05-30_06.27.42 --addhosts=c9t22875:role=worker:group=default --sid=TDB --nostart=0 --root_user=root --sapmnt=/hana/shared --install_ssh_key=1 --skip_hostagent_password=1 --remote_execution=ssh --install_hostagent=1 --read_password_from_stdin=xml 06:28:23.177 - INFO:     Output line 1: 06:28:23.177 - INFO:     Output line 2: 06:28:23.177 - INFO:     Output line 3: SAP HANA Lifecycle Management - hdbmodify_addhosts  1.00.102.02.1446663129 06:28:23.177 - INFO:     Output line 4: ************************************************************************** 06:28:23.177 - INFO:     Output line 5: 06:28:23.274 - INFO:     Output line 6: 06:28:23.274 - INFO:     Output line 7: System Properties: 06:28:23.274 - INFO:     Output line 8: TDB /hana/shared/TDB HDB_ALONE 06:28:23.274 - INFO:     Output line 9:         HDB01 06:28:23.274 - INFO:     Output line 10:        version: 1.00.102.02.1446663129 06:28:23.275 - INFO:     Output line 11:        host: c9t22874.ijsc.testcorp.net (Database Worker (worker)) 06:28:23.275 - INFO:     Output line 12: 06:28:23.804 - INFO:     Output line 13: Start reading from input channel... 06:28:23.810 - INFO:     Output line 14: ... Done. 06:28:23.847 - INFO:     Output line 15: Modifying configuration of SAP HANA System 'TDB'... 06:28:23.868 - INFO:     Output line 16: 06:28:23.869 - INFO:     Output line 17: Summary before execution: 06:28:23.869 - INFO:     Output line 18:    Installation Path: /hana/shared 06:28:23.869 - INFO:     Output line 19:    SAP HANA System ID: TDB 06:28:23.869 - INFO:     Output line 20:    Additional Hosts: c9t22875:role=worker:group=default 06:28:23.869 - INFO:     Output line 21:    Enable the installation or upgrade of the SAP Host Agent: Yes 06:28:23.869 - INFO:     Output line 22:    Remote Execution: ssh 06:28:23.869 - INFO:     Output line 23:    Root User Name: root 06:28:23.869 - INFO:     Output line 24: 06:28:23.873 - INFO:     Output line 25: Adding additional host... 06:28:23.895 - INFO:     Output line 26: Adding host 'c9t22875'... 06:28:26.616 - INFO:     Output line 27: Reconfiguring SAP HANA system failed! 06:28:26.617 - INFO:     Output line 28:   Add hosts: 06:28:26.617 - INFO:     Output line 29:     Creating a multiple host system failed 06:28:26.617 - INFO:     Output line 30:       Adding host 'c9t22875' failed! 06:28:26.618 - INFO:     Output line 31:         Add host failed 06:28:26.618 - INFO:     Output line 32:           Running in batch mode 06:28:26.618 - INFO:     Output line 33:             Wrong password 06:28:26.618 - INFO:     Output line 34:               AccessCheck request failed: Permission denied 06:28:26.619 - INFO:     Output line 35: 06:28:26.642 - INFO:     Output line 36: Log file written to '/var/tmp/hdb_TDB_hdblcm_add_hosts_2016-05-30_06.27.42/hdbmodify_addhosts.log' on host 'c9t22874.ijsc.testcorp.net'. 06:28:26.891 - INFO:     Program terminated with exit code 1 06:28:26.892 - INFO: ----------------------------------------------------------- 06:28:26.892 - INFO: END: End adding additional host to SAP HANA Database (start: 06:28:21.600 duration: 00:00:05.292) 06:28:26.892 - INFO: ----------------------------------------------------------- 06:28:27.886 - ERR : Addition of hosts to the SAP HANA system failed. 06:28:28.038 - INFO: Summary of critical errors 06:28:27.886 - ERR :   Addition of hosts to the SAP HANA system failed. 06:28:26.895 - ERR :     Error occurred while executing Add Additional Hosts to SAP HANA System. 06:28:26.893 - INFO:       Reconfiguring SAP HANA system failed! 06:28:26.893 - INFO:         Add hosts: 06:28:26.894 - INFO:           Creating a multiple host system failed 06:28:26.894 - INFO:             Adding host 'c9t22875' failed! 06:28:26.894 - INFO:               Add host failed 06:28:26.894 - INFO:                 Running in batch mode 06:28:26.894 - INFO:                   Wrong password 06:28:26.895 - INFO:                     AccessCheck request failed: Permission denied

It seems like failed with wrong password, I tried so many ways including configure root ssh equivalent, changing root password, setup saphostagent in the new node and install with --remote_execution=saphostagent, but nothing work, appreciate if anyone can help here.

Thanks

regards

[Former Member]

Thanks for all the replies, I have tested all as suggested, but no luck I'm still not able to add host, same error message, below are few tries i performed:

Header 1

=========== 1st Tried: =========== /hana/shared/TDB/hdblcm/hdblcm SAP HANA Lifecycle Management - SAP HANA 1.00.102.02.1446663129 *************************************************************** Choose an action to perform   Index | Action to be performed     | Description   --------------------------------------------------------------------------------------   1     | add_hosts                  | Add Additional Hosts to the SAP HANA System   2     | configure_internal_network | Configure Inter-Service Communication   3     | configure_sld              | Configure System Landscape Directory Registration   4     | print_component_list       | Print Component List   5     | rename_system              | Rename the SAP HANA System   6     | uninstall                  | Uninstall SAP HANA Components   7     | unregister_system          | Unregister the SAP HANA System   8     | update_component_list      | Update Component List   9     | update_components          | Install or Update Additional Components   10    | update_host                | Update the SAP HANA Instance Host integration   11    | exit                       | Exit (do nothing) Enter selected action index [11]: 1 System Properties: TDB /hana/shared/TDB HDB_ALONE         HDB01         version: 1.00.102.02.1446663129         host: c9t22874.ijsc.testcorp.net (Database Worker (worker)) Enter comma-separated host names to add: c9t22875 Enter Root User Name [root]: Collecting information from host 'c9t22875'... Information collected from host 'c9t22875'. Select roles for host 'c9t22875':   Index | Host Role                | Description   -------------------------------------------------------------------   1     | worker                   | Database Worker   2     | standby                  | Database Standby   3     | extended_storage_worker  | Dynamic Tiering Worker   4     | extended_storage_standby | Dynamic Tiering Standby   5     | streaming                | Smart Data Streaming   6     | rdsync                   | Remote Data Sync   7     | ets_worker               | Accelerator for SAP ASE Worker   8     | ets_standby              | Accelerator for SAP ASE Standby Enter comma-separated list of selected indices [1]: Enter Host Failover Group for host 'c9t22875' [default]: Enter Storage Partition Number for host 'c9t22875' [<<assign automatically>>]: Enter System Administrator (tdbadm) Password: Unknown user password combination Enter System Administrator (tdbadm) Password: Enter SAP Host Agent User (sapadm) Password: Confirm SAP Host Agent User (sapadm) Password: Enter Certificate Host Name For Host 'c9t22875' [c9t22875]: Summary before execution: ========================= Add Additional Hosts to SAP HANA System    Add Hosts Parameters       Remote Execution: ssh       Enable the installation or upgrade of the SAP Host Agent: Yes       Install SSH Key: Yes       Root User Name: root       Do not start added hosts and do not start SAP HANA System: No       Certificate Host Names: c9t22875 -> c9t22875    Additional Hosts       c9t22875          Role: Database Worker (worker)          High-Availability Group: default          Storage Partition: <<assign automatically>> Do you want to continue? (y/n): y Adding additional host to SAP HANA Database...   Adding additional host...   Adding host 'c9t22875'...       Creating a multiple host system failed         Adding host 'c9t22875' failed! Addition of hosts to the SAP HANA system failed.   Error occurred while executing Add Additional Hosts to SAP HANA System.     Reconfiguring SAP HANA system failed!       Add hosts:         Creating a multiple host system failed           Adding host 'c9t22875' failed!             Add host failed               Running in batch mode                 Wrong password                   AccessCheck request failed: Permission denied You can send feedback to SAP with this form: https://c9t22874.ijsc.testcorp.net:1129/lmsl/HDBLCM/TDB/feedback/feedback.html Log file written to '/var/tmp/hdb_TDB_hdblcm_add_hosts_2016-05-30_23.29.08/hdblcm.log' on host 'c9t22874.ijsc.testcorp.net'. =========== 2nd Tried: =========== ./hana/shared/TDB/global/hdb/install/bin/hdbaddhost Enter Local Host Name [c9t22874.ijsc.testcorp.net]: c9t22875.ijsc.testcorp.net IP address '16.250.26.51' (host 'c9t22875.ijsc.testcorp.net') is not assigned to a local network interface I can't proceed further as i have above errors. =========== 3rd Tried: =========== I follow SPS12 administration guide by adding the host with SAP host agent, I follow below steps: - I downloaded the agent file - SAPHOSTAGENT10_10-20009394.SAR - successfully extract it with SAPCAR - installed agent - saphostexec -status shows the agent running - I have complete the configuration of SSL certificate and the HTTPS port is accessible - run ./hdblcm --remote_execution=saphostagent The same errors: Summary before execution: ========================= Add Additional Hosts to SAP HANA System    Add Hosts Parameters       Remote Execution: saphostagent       Enable the installation or upgrade of the SAP Host Agent: Yes       Do not start added hosts and do not start SAP HANA System: No       Certificate Host Names: c9t22875.ijsc.testcorp.net -> c9t22875.ijsc.testcorp.net    Additional Hosts       c9t22875.ijsc.testcorp.net          Role: Database Worker (worker)          High-Availability Group: default          Storage Partition: <<assign automatically>> Do you want to continue? (y/n): y Adding additional host to SAP HANA Database...   Adding additional host...   Adding host 'c9t22875.ijsc.testcorp.net'...       Creating a multiple host system failed         Adding host 'c9t22875.ijsc.testcorp.net' failed! Addition of hosts to the SAP HANA system failed.   Error occurred while executing Add Additional Hosts to SAP HANA System.     Reconfiguring SAP HANA system failed!       Add hosts:         Creating a multiple host system failed           Adding host 'c9t22875.ijsc.testcorp.net' failed!             Add host failed               Configuration error (batch mode):                 Wrong password                   AccessCheck request failed: Permission denied =========== 4th Tried: =========== I'm also checked note 927637, my file has the correct permission and owner set, nosuid is not set on mount point layer: ls -l /usr/sap/hostctrl/exe/sapuxuserchk -rwsr-x--- 1 root sapsys 722030 May 20 03:03 /usr/sap/hostctrl/exe/sapuxuserchk df -h /usr/sap/hostctrl/exe Filesystem            Size  Used Avail Use% Mounted on /dev/mapper/vg00-usr  4.9G  3.8G  918M  81% /usr /dev/mapper/vg00-usr on /usr type ext4 (rw)

I have the SSH equivalent setup for root on the existing system and new server, i can ssh back and forth between servers without needed password.

I got strong feel this is due to the sticky bit on sapuxuserchk though I'm still try to figure out how to get around it.

Any suggestion would highly appreciate.

Thanks

Chong

[Former Member]

Hi,

As was already suggested by Michael, have you followed the pre reqs ?

When adding hosts you should make sure the following files are aligned on all hosts.

/etc/hosts

/etc/passwd

/etc/shadow

/etc/services.

Have you tried to logon as "root" , "sapadm" and "tdbadm" on both hosts with the password you are using ? By this I mean you ssh directly to both hosts and logon with each of the users with the password you are proving hdblcm/hdbaddhost.

Please eliminate that first and then look at "not assigned to a local network interface" you encountered in attempt #2.

KR,

Amerjit

[Former Member]

Hi Chong,

This is permission issue. .Try using sidadm userid and password

[Former Member]

Hi,

I'm on RHEL 6.7, with HANA SPS10 installation, i will try the above as suggested and update.

Thanks.

[anandtigadikar]

Even check this note- 927637, it worked for me in the past.

Execute the following commands: chown root:sapsys sapuxuserchk chmod u+s,o-rwx sapuxuserchk

[Former Member]

Hello Kok Hoo,

Just for further analysis could you upload your: /var/tmp/hdb_TDB_hdblcm_add_hosts_2016-05-30_06.27.42/hdbmodify_addhosts.log.

The reason I asked your RHEL version was I had a problem on RHEL6.6 which meant I also had to do it with hdbaddhost as opposed to hdblcm and I also had no luck getting it to work with saphostagent.

See: SAP HANA Multi host install fails with the message "LIBSSH2_ERROR_KEY_EXCHANGE_FAILURE , un...

As already suggested by Williams please execute hdbaddhost on the host where you want to install the worker node.

Let us know how you get on.

KR,

Amerjit

[anandtigadikar]

HDBLCM uses ssh between 2 nodes, if it's not set for your root user, then this error occurs.

I had this too in past, once ssh keys between 2 nodes were set, i did not had any issues.

Please get it done with your OS team, if you don't have authorizations of doing it.

Did you tried above SAP note ? If you are using hdbaddhost, that note should resolve your issue?

[Former Member]

Anand,

If you read the thread you will find I am *not* the person who asked the question. I am replying to Kok Hoo.

If you have suggestions for him could you kindly reply to him as opposed to me.

KR,

A.

[Former Member]

Hello Kok Hoo,

Are you on SUSE or on RHEL ?

KR,

A.

[anandtigadikar]

On which DB version you are?

Why don't you use hdblcm tool?

Irrespective of OS version, above tasks mentioned by Micheal, should work.

Please try and update...

[williams_ruter3]

Hello Kok,

The OS user are manage locally i presume, please remove the saphostagent on the host that you want to add, clean up the the /usr/sap/hostagent folder.

Also check if the <sidadm> exist on the additional host, if yes remove it.

Once the check done, from the host you wants to add go to the /hana/shared/TDB/global/hdb/install/bin and run the ./hdbaddhost script with the root user.

Please let know the result

Williams

[former_member183326]

Hello,

Please make sure you have met the pre reqs from

http://help.sap.com/hana/SAP_HANA_Administration_Guide_en.pdf

Page 512.