In Region B, on a virtual machine with Ubuntu 14.04 Long Term Support (LTS) where you plan to install vSphere Update Manager Download Service, install, and configure a PostgreSQL database instance.

Prerequisites

Create a virtual machine for vSphere Update Manager Download Service (UMDS). See Virtual Machine Specifications from the Planning and Preparation document.

Procedure

  1. Log in to vCenter Server by using the vSphere Web Client.
    1. Open a Web browser and go to https://lax01m01vc01.lax01.rainpole.local/vsphere-client.
    2. Log in using the following credentials.
      Setting Value
      User name administrator@vsphere.local
      Password vsphere_admin_password
  2. Log in to the remote console of the UMDS virtual machine.
    1. In the vSphere Web Client, right-click the lax01umds01 virtual machine and select Open Console to open the remote console to the virtual machine.
    2. Log in using the following credentials.
      Setting Value
      User name svc-umds
      Password svc-umds_password
  3. Install Secure Shell (SSH) server, and end the session.
    sudo apt-get update
    sudo apt-get -y install SSH
    exit
  4. Log in to the UMDS virtual machine by using a Secure Shell (SSH) client.
    1. Open an SSH connection to lax01umds01.lax01.rainpole.local.
    2. Log in using the following credentials.
      Setting Value
      User name svc-umds
      Password svc-umds_password
  5. Install and start PostgreSQL and its dependencies:
    sudo apt-get -y install vim perl tar sed psmisc unixodbc postgresql postgresql-contrib odbc-postgresql
    sudo service postgresql start
    The installation operation creates a user account called postgres that is associated with the default Postgres role. The postgres account is used to establish a service account for the Update Manager Download Service.
  6. Log in as postgres user, and create a database instance and a database user, by running the following commands.
    When prompted, enter and confirm the umds_db_user_password password.
    sudo su - postgres
    createdb umds_db
    createuser -d -e -r umds_db_admin -P
  7. Enable password authentication for the database user.
    1. Navigate to the folder that contains the PostgreSQL configuration file pg_hba.conf and edit the file.
      Linux system Default Location
      Ubuntu 14.04 /etc/postgresql/postgres_version/main
      cd /etc/postgresql/postgres_version/main
      vi pg_hba.conf
    2. In the PostgreSQL configuration file, enable password authentication for the database user by inserting the following line right above local all all peer.
      You can use the vi editor to make and save the changes.
      #TYPE DATABASE USER ADDRESS METHOD
      local umds_db umds_db_admin md5
    3. Log out as a PostgreSQL user by running the following command.
      logout
  8. Configure the PostgreSQL driver and the data source name (DSN) for connection to the UMDS database.
    1. Edit the ODBC configuration file.
      sudo vi /etc/odbcinst.ini
    2. Replace the file content with the following content and save the changes using :wq command.
      [PostgreSQL]
      Description=PostgreSQL ODBC driver (Unicode version)
      Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
      Debug=0
      CommLog=1
      UsageCount=1
    3. Edit the system file /etc/odbc.ini.
      sudo vi /etc/odbc.ini
    4. Replace the file content with the following content and save the changes using :wq command.
      [UMDS_DSN]
      ;DB_TYPE = PostgreSQL
      ;SERVER_NAME = localhost
      ;SERVER_PORT = 5432
      ;TNS_SERVICE = <database_name>
      ;USER_ID = <database_username>
      Driver = PostgreSQL
      DSN = UMDS_DSN
      ServerName = localhost
      PortNumber = 5432
      Server = localhost
      Port = 5432
      UserID = umds_db_admin
      User = umds_db_admin
      Database = umds_db
  9. Create a symbolic link between UMDS and PostgreSQL by running the following command.
    ln -s /var/run/postgresql/.s.PGSQL.5432 /tmp/.s.PGSQL.5432
  10. Restart PostgreSQL.
    sudo service postgresql restart