This is the second article in a series about how to build-out a simple vCAC 6 installation to a distributed model.
The diagram below shows the deployment at the end of this part, with vPostgres deployed and the vCAC Appliance running from the remote database.
An overview of the steps required are below:
First of all, create DNS records for your vPostgres database server – you need both an A and PTR record. Most VMware appliances will check for a reverse DNS lookup when they boot and will set the hostname accordingly.
I’m calling mine vcac-pg-01:
Deploying the OVF is really very simple and really doesn’t take any explaining! vPostgres is free for non-production use so there’s no problem having a play in your lab.
Once the appliance has finished booting (wait for the below screen) log onto the web management console using the DNS FQDN on port 5480 – e.g. mine is on https://vcac-pg-01.definit.local:5480
Log on using the password you specified in the OVF deployment and check that the appliance has picked up the hostname correctly. There’s no need to change anything else here (though, if you’re reading VMware, an NTP section the same as the rest of your appliances would be nice!)
Open the VM console on the DB server and edit the NTP configuration using “vi /etc/ntp.conf” and insert the same NTP servers you’ve configured for your VCAC appliance – e.g.
server 0.uk.pool.ntp.org server 1.uk.pool.ntp.org server 2.uk.pool.ntp.org
Save and exit the vi editor, then start the NTP server using “rcntp start” (use reload if NTP is already running). Check the sync using “rcntp ntptimeset”, and “rcntp status”.
Log onto the vPostgres instance using https://vcac-pg-01.definit.local:8443 – use the password configured in the OVF deployment.
Once logged on, expand the Databases node and select the postgres database. In the top right, you can now click on the “Enter SQL” button:
First, we need to create a user for use with vcac:
CREATE USER vcac WITH NOCREATEDB NOCREATEROLE NOCREATEUSER INHERIT LOGIN ENCRYPTED password 'mypassword';
Then create a database with the new user as the owner:
CREATE DATABASE vcacdb WITH OWNER vcac;
Don’t worry if it doesn’t show up immediately, or with a refresh, I had to log out and log back in again.
Finally, select the vcacdb database, open the SQL window and create the extensions required for VCAC:
CREATE EXTENSION "hstore"; CREATE EXTENSION "uuid-ossp";
Open PuTTY and connect to the vCAC Appliance – log in using the root credentials.
Change to the user “vcac” which has permissions to the embedded PostgreSQL databse.
su – vcac
Move to the PostgreSQL install folder
Dump the database “vcac” and pipe it into a PSQL command to push it to the remote vPostgres server’s database – the –h parameter is the remote host and the final argument is the new DB name created earlier.
./pg_dump vcac | ./psql -h vcac-pg-01.definit.local vcacdb
Enter the password for the user “vcac” on the new server (the password from the query in the previous section). There will be a whole load of SQL commands on screen, including some warnings about “public” at the end – you can safely ignore those.
The database is now migrated, but vCAC needs to know where to look, so log into the management console (e.g. https://vcac-app-01.definit.local:5480) and go to the vCAC Settings > Database tab. Enter the details for the new instance and click “Save Settings” – you should see a message saying “Database configuration is updated, vCAC is restarted”
Since the embedded database is no longer required, we should now turn that off – as well as the embedded vCO services, which cannot be configured to run on an external database. Jump back on the SSH session to the vCAC Appliance and issue the following commands
service vpostgres stop service vco-server stop chkconfig vpostgres off chkconfig vco-server off
Just for peace of mind, I like to log in to my appliance at this point to ensure everything is as expected, and any configurations are carried across
That concludes part two of this series, stay tuned for part 3 which is all about the load balancing!