search cancel

Unable to install DR on new server - User's home directory is owned by some other user

book

Article ID: 216312

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration

Issue/Introduction

We are able to do validate command however installation command is failing.

===============================================================================

Installing Data Repository (Vertica)

===============================================================================

./resources/vertica-9.1.1-5.x86_64.RHEL6.rpm located. ...................[ OK ]

./resources/vlicense.dat located. .......................................[ OK ]

Checking to see if Vertica Installation Package already exists...

Found existing Vertica Installation Package...

Checking to see if a database is running...

 

Vertica Installation at vertica-9.1.1-5.x86_64 ..........................[ OK ]

===============================================================================

Invoking install_vertica...

===============================================================================

Vertica Analytic Database 9.1.1-5 Installation Tool

>> Validating options...

Mapping hostnames in --hosts (-s) to addresses...

        dbserver-new                  => 10.10.10.1

>> Starting installation tasks.

>> Getting system information for cluster (this may take a while)...

Default shell on nodes:

10.10.10.1 /bin/bash

>> Validating software versions (rpm or deb)...

>> Beginning new cluster creation...

successfully backed up admintools.conf on 10.10.10.1

>> Creating or validating DB Admin user/group...

Failed on hosts (1): 10.10.10.1

    Provided DB Admin account details: user = dradmin, group = verticadba, home = /export/home/dradmin

    Creating group... Group already exists

    Validating group... Okay

    Creating user... User already exists

    Validating user...

    Fail : User's home directory is owned by some other user

    Hint : Check ownership of /export/home/dradmin

    Help : https://my.vertica.com/docs/9.1.x/HTML/index.htm#cshid=S0270

 Unable to create or verify DB Admin user/group on some hosts.

See above for details.

Installation FAILED with errors.

Environment

Release : 3.7

Component : PERFORMANCE MANAGEMENT INSTALLATIONS/UPGRADES

Cause

The dradmin account is not owner of the /export/home/dradmin directory:

" ls -lar /export/home/dradmin", the dradmin is not the owner of the /export/home/dradmin directory (the current owner is: user01):

total 36
-rw-r--r-- 1 user01 verticadba  172 Feb 17  2020 .kshrc
drwxr-xr-x 3 user01 verticadba 4096 Jun  1 08:54 .config
drwxr-xr-x 3 user01 verticadba 4096 Jun  1 08:54 .cache
-rw-r--r-- 1 user01 verticadba  231 Aug 21  2019 .bashrc
-rw-r--r-- 1 user01 verticadba  193 Aug 21  2019 .bash_profile
-rw-r--r-- 1 user01 verticadba   18 Aug 21  2019 .bash_logout
-rw------- 1 user01 verticadba   61 Jun  1 08:58 .bash_history
drwxr-xr-x 4 root     root       4096 May 31 12:55 ..
drwx------ 4 user01 verticadba 4096 Jun  1 08:58 .

Resolution

In your drinstall.properties file there are the following entries:

# Linux user created to serve as the database administrator
DbAdminLinuxUser=dradmin
# Home directory for database administrator Linux user
# Make sure the parent directory of the home directory exists
# before running dr_install.sh
DbAdminLinuxUserHome=/export/home/dradmin

 

You will have to change the ownership of the directory and files on the /export/home/dradmin directory. The dradmin must the be the owner of the directory and files, instead of user01 account.

This is what you should have:

ls -lar /export/home/dradmin

total 36
-rw-r--r-- 1 dradmin verticadba  172 Feb 17  2020 .kshrc
drwxr-xr-x 3 dradmin verticadba 4096 Jun  1 08:54 .config
drwxr-xr-x 3 dradmin verticadba 4096 Jun  1 08:54 .cache
-rw-r--r-- 1 dradmin verticadba  231 Aug 21  2019 .bashrc
-rw-r--r-- 1 dradmin verticadba  193 Aug 21  2019 .bash_profile
-rw-r--r-- 1 dradmin verticadba   18 Aug 21  2019 .bash_logout
-rw------- 1 dradmin verticadba   61 Jun  1 08:58 .bash_history
drwxr-xr-x 4 root     root       4096 May 31 12:55 ..
drwx------ 4 dradmin verticadba 4096 Jun  1 08:58 .

Please change the ownership to dradmin account and try installing the DR (Data Repository)  - Vertica DB.

Additional Information

Also, ensure the dradmin account is a member of the verticadba group name, otherwise, you will get the following error message:

Provided DB Admin account details: user = dradmin, group = verticadba, home = /export/home/dradmin

    Fail : User is not a member of the group

    Hint : Compare user's groups to provided DB Admin details, above

 

a) id dradmin

This is an example of the output of "id dradmin":
uid=1002(dradmin) gid=1004(verticadba) groups=1004(verticadba)

b) groups dradmin

This is an example of the output of "groups dradmin":
dradmin : verticadba

c) lid -g verticadba

This is an example of the output of "lid -g verticadba":
 dradmin(uid=1002)

Please engage the Linux administrator to add the dradmin account as a member of verticadba group.