On a virtual machine with Ubuntu 14.04 Long Term Support (LTS) where you plan to install vSphere Update Manager Download Service, 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 documentation.

Procedure

  1. Log in to vCenter Server by using the vSphere Web Client.
    1. Open a Web browser and go to https://nyc01r01vc01.rainpole.local/vsphere-client.
    2. Log in using the following credentials.

      Setting

      Value

      User name

      administrator@vsphere.local

      Password

      vsphere_admin_password

  2. In the vSphere Web Client, right-click the nyc01umds01 virtual machine and select Open Console to open the remote console to the virtual machine.
  3. At the command prompt, log in using the following credentials.

    Setting

    Value

    User name

    svc-umds

    Password

    svc-umds_password

  4. Install Secure Shell (SSH) server, and end the session.
    sudo apt-get update
    sudo apt-get -y install SSH
    exit
  5. Log back in to the UMDS virtual machine using Secure Shell (SSH) client.
    1. Open an SSH connection to the virtual machine nyc01umds01.
    2. Log in using the following credentials.

      Setting

      Value

      User name

      svc-umds

      Password

      svc-umds_password

  6. 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.

  7. 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_admin_password password.

    sudo su - postgres
    createdb umds_db
    createuser -d -e -r umds_db_admin -P
  8. 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
  9. Configure the PostgreSQL driver and the data source name (DSN) for a 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
  10. Create a symbolic link between the UMDS and the PostgreSQL by running the following command.
    ln -s /var/run/postgresql/.s.PGSQL.5432 /tmp/.s.PGSQL.5432
  11. Restart PostgreSQL.
    sudo service postgresql restart