Complete implementation of UMDS on RHEL - Including Postgres installation
search cancel

Complete implementation of UMDS on RHEL - Including Postgres installation

book

Article ID: 311390

calendar_today

Updated On:

Products

VMware vCenter Server VMware vSphere ESXi

Issue/Introduction

Symptoms:

  • Unable to completely install UMDS on an RHEL based on the VMware Documentation.

  • During installation UMDS getting the error:
    • [28000][unixODBC]FATAL: Ident authentication failed for user "vcadmin"

Environment

VMware vSphere ESXi 6.5
VMware vCenter Server Appliance 6.5.x
VMware Update Manager 6.5
VMware vCenter Server 6.5.x

Resolution

Below is the whole installation process, including the deployment and configuration of Postgres, and testing of ODBC connection to it:

  1. Mount the VCSA ISO on the RHEL: mount /dev/cdrom /mnt/
  2. Copy the installer to the /tmp folder (or any other location if you want to persist it after a reboot): cp /mnt/umds/VMware-UMDS-6.5.0.-<build_number>.tar.gz /tmp
  3. Un-archive the files: tar -zxvf /tmp/VMware-UMDS-6.5.0-4540462.tar.gz -C /tmp
  4. We need to download the 9.2 PostgreSQL for the corresponding distribution, in this case RHEL 7.0, you have 2 options:
    • Use a browser and then move the file to the guest OS: https://yum.postgresql.org/repopackages.php#pg92
    • Or, download it directly from the shell: wget https://download.postgresql.org/pub/repos/yum/9.2/redhat/rhel-7-x86_64/pgdg-redhat92-9.2-3.noarch.rpm -P /tmp
  5. Install the repository: rpm -ivh /tmp/pgdg-redhat92-9.2-3.noarch.rpm
  6. Install the PostgreSQL: yum groupinstall "PostgreSQL Database Server 9.2 PGDG"
  7. Make sure the following packages are installed: perl, tar, sed, psmisc, unixODBC, postgresql, postgresql-contrib, and postgresql-odbc; you can do with: yum list installed | grep -i <package_name>
    • If not, you can install with: yum install <package-name>
  8. Let's enable the PostgreSQL service on the system: systemctl enable postgresql-9.2
  9. Initialize the PostgresSQL: su - postgres -c /usr/pgsql-9.2/bin/initdb
  10. Start the postgres service: systemctl start postgresql-9.2
  11. Check it's indeed running: systemctl status postgresql-9.2
  12. Let's create the UMDS database, and user:
    • su - postgres
    • createdb umdsdb
    • createuser -d -e -r vcadmin -P
  13. Confirm the db and user are indeed created:
    • psql
    • \l
    • \du
  14. Once confirmed, go back to the shell:
    • \q
    • exit
  15. Now let's configure the pg_hba.conf properly:
    • vi /var/lib/pgsql/9.2/data/pg_hba.conf
    • Add the line: local <database_name> <database_username> md5
      • *****Right above the line: local all all peer.
  16. Restart the PostgreSQL service for the changes to take effect: systemctl restart postgresql-9.2
  17. Modifying the odbcinst.ini file:
    • vi /etc/odbcinst.ini
    • I had to comment-out the "MySQL" section, and left only the Driver64 information. My file looks like the attachment: odbcinst.ini
  18. Create the odbc.ini file: touch /etc/odbc.ini
  19. Modifying the odbc.ini file:
    • vi /etc/odbc.ini
    • Make sure it looks like the attachment: odbc.ini
  20. Since the socket file is already in the /tmp directory there is NO need to create the symlink.
  21. Test the ODBC connection works:
    • isql -v UMDS_DSN vcadmin vcadmin
    • quit
    • If it fails with Ident error: [28000][unixODBC]FATAL: Ident authentication failed for user "vcadmin"
      • vi /var/lib/pgsql/9.2/data/pg_hba.conf
        • Make sure the IPv4 and IPv6 all connections Method is set to trust.
        • If the pg_hba.conf file is changed, then restart the postgres for it to take effect: systemctl restart postgresql-9.2
  22. Once the ODBC test works, run the installer:/tmp/vmware-umds-distrib/vmware-install.pl EULA_AGREED=yes

Referenced links:

 

Powered by Wolken Software