In Region B, on a virtual machine with Ubuntu 14.04 Long Term Support (LTS) where you plan to install Update Manager Download Service (UMDS), install and configure a PostgreSQL database instance .
Prerequisites
Create a virtual machine for UMDS on the management cluster of Region B. See Virtual Machine Specifications from the Planning and Preparation documentation.
Verify you have PostgreSQL database user credentials.
Procedure
- Log in to vCenter Server by using the vSphere Web Client.
- Open a Web browser and go to https://mgmt01vc51.lax01.rainpole.local/vsphere-client.
- Log in using the following credentials.
Setting
Value
User name
administrator@vsphere.local
Password
vsphere_admin_password
- In the vSphere Web Client, right-click the mgmt01umds51.lax01.rainpole.local virtual machine and select Open Console to open the remote console to the virtual machine.
- At the command prompt, log in as the svc-umds user using svc-umds_password.
- Install VMtools and Secure Shell (SSH) server, and end the session.
sudo apt-get update sudo apt-get -y install SSH exit
- Log back into the UMDS virtual machine using SSH and the
svc-umds
service account credentials. - 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
- Log in as a PostgreSQL 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_user -P
- Enable password authentication for the database user.
- Navigate to the folder that contains the PostgreSQL configuration file pg_hba.conf.
Linux system
Default Location
Ubuntu 14.04
/etc/postgresql/postgres_version/main
cd /etc/postgresql/postgres_version/main
- 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_user
md5
- Log out as a PostgreSQL user by running the following command.
logout
- Navigate to the folder that contains the PostgreSQL configuration file pg_hba.conf.
- Configure the PostgreSQL driver and the data source name (DSN) for connection to the UMDS database.
- Edit the ODBC configuration file.
sudo vi /etc/odbcinst.ini
- Replace the file with the following content and save the change using :wq.
[PostgreSQL] Description=PostgreSQL ODBC driver (Unicode version) Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so Debug=0 CommLog=1 UsageCount=1
- Edit the system file /etc/odbc.ini.
sudo vi /etc/odbc.ini
- Replace the file with the following content and save the change using :wq,
[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_user User = umds_db_user Database = umds_db
- Edit the ODBC configuration file.
- 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
- Restart PostgreSQL.
sudo service postgresql restart