Solved: File analytics installation NETAPP_XCP_1.9.1

Konstantin2

Hello,

I am trying to install XCP NETAPP_XCP_1.9.1 on a RHEL 8.6 system with root but while configuring it does not allow me to set password for admin:

Enter admin password for file analytics:
Retype same password :
# Updating database entries
(pg.InternalError) FATAL: Ident authentication failed for user "central"

(Background on this error at: https://sqlalche.me/e/14/2j85)
NOTE: Please make sure you are root user. File Analytics installation unsuccessful. Please refer the user guide.

Does anyone know what is the problem?

elementx

Make sure config creds from your XCP config file are valid.

View solution in original post

elementx

Make sure config creds from your XCP config file are valid.

Konstantin2

Can you please provide details which creds should be valid?

elementx

For PostgreSQL DB that is installed when you run configure.sh. In xcp.ini you may have something like this (account and credentials are for this specific database):

db_host = 127.0.0.1
db_port = 5432
db_user = central
...
db_name = xcp_cmdb

In order to verify that PostgreSQL is reachable, you could use psql client and DBA password for and then check that PostgreSQL is running, xcp_cmdb is present, etc.

There should be some logs in here, including error logs:

/opt/NetApp/xFiles/xcp/xcpfalogs/

Potential fixes include configure.sh -> Repair/ Manage which checks and restarts the DB.

elementx

I just tried to install XCP 1.9.1. on Rocky Linux 8.7; configure.sh installed PostgreSQL but it also recommended to set a password for my DB user

NOTE:
If you are running configuration for first time or upgrading, select option 1.
________________________________________________________________________________
Please choose the menu you want to start:
1. Configure client system
2. Reset admin password
3. Reset Postgres database password
4. Rebuild xcp.ini file
5. Delete database and reconfigure client system
6. Add/Modify/Delete custom security banner (To be used after configuring the client)

0. Quit
--------------------------------------------------------------------------------
Enter digit between [0-6] >> 1

# Postgres service is running 
Password must contain at least one numeral, one upper case, one lower case and a special character(! @ # $ % ^ & * - _).

Enter password for Postgres DB user:

I was prompted to enter 2 passwords, one for PostgreSQL DB user, and another for XCP admin.

# Postgres service is running 
Password must contain at least one numeral, one upper case, one lower case and a special character(! @ # $ % ^ & * - _).

Enter password for Postgres DB user:
Retype same password :
# Updating DB password

# Updating xcp.ini file
Password must contain at least one numeral, one upper case, one lower case and a special character(! @ # $ % ^ & * - _).

Enter admin password for file analytics:
Retype same password :
# Updating database entries


# A custom banner is a message displayed to someone who attempts to access XCP File Analytics web page before every authentication.
Example of banner message: Authorised users only! 
Do you wish to add a banner ? (yes/no): no
--------------------------------------------------------------------------------
Starting xcp service 
--------------------------------------------------------------------------------
# Creating XCP service ...

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
XCP File analytics configured and XCP service started successfully.

Use following link and login as 'admin' user for GUI access
https://192.168.1.198/xcp
--------------------------------------------------------------------------------
[root@s198 xcp]# cat /opt/NetApp/xFiles/xcp/xcp.ini
[xcp]
catalog = nfs_server:/export[:subdirectory]
db_password = BhRauqE6bjS/aTmkiKmtOQ==
db_host = 127.0.0.1
db_port = 5432
db_user = central
db_name = xcp_cmdb

Note that catalog is still not configured, but DB is: BhRauqE6bjS/aTmkiKmtOQ== is "NetApp123$".

Now I use these creds (central/NetApp123$) to check:

[root@s198 xcp]# psql -h 127.0.0.1 -U central -d xcp_cmdb -p 5432
Password for user central: 
psql (10.23)
Type "help" for help.

I rebooted the system and re-ran configure.sh which told me everything is OK:

[root@s198 xcp]# ./configure.sh 
--------------------------------------------------------------------------------
XCP CONFIGURATION SCRIPT 
--------------------------------------------------------------------------------
# Checking if XCP service is running
# WARNING: XCP process is already running on this system.
________________________________________________________________________________

root 932 1 0 16:19 ? 00:00:00 /usr/bin/xcp --listen
root 1110 932 0 16:19 ? 00:00:00 /usr/bin/xcp --listen
postgres 1487 1015 0 16:19 ? 00:00:00 postgres: central xcp_cmdb 127.0.0.1(35064) idle

Installer script did forget to add one dependency, which I installed manually. I think that's not related to the auth problem you had, it's related to the Web UI.

sudo yum install python3-xmlsec.x86_64 xmlsec1.x86_64 xmlsec1-openssl.x86_64