• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

virtuallyGhetto

  • About
  • Privacy
  • VMware Cloud
  • Home Lab
  • Nested Virtualization
  • Automation
    • VMware Kickstart
    • VMware API/SDK/CLI
    • VMware vMA/VIMA
    • VMware OVF / OVFTOOL
  • Apple Mac
  • VCSA
  • VSAN
You are here: Home / VCSA (vCenter Server Appliance) 5.1 VCDB & SSODB Password

VCSA (vCenter Server Appliance) 5.1 VCDB & SSODB Password

11/19/2012 by William Lam 2 Comments

I recently helped answer a question internally about the default credentials to the VCSA 5.1 (vCenter Server Appliance) vCenter Server and SSO (Single-Sign On) Database for troubleshooting purposes. I thought I share the details in case this might help others.

With the release of the vSphere 5.1, the VCSA now runs VMware's vPostgres database for both the VCDB and SSODB. You should also know there is no default credentials for the database as the passwords are automatically generated during the initial application install and the database password will be unique on every VCSA.

However, you can still retrieve the password for both the VCDB as well as SSODB (this took a bit of digging in the appliance).

Disclaimer: You should not have any reason to go into the actual DB of either vCenter Server or SSO other than potential troubleshooting with VMware Support. Please use caution if you do choose to connect to the DB, as you can potentially impact your system.

VCDB Credentials:
You can view the credentials for the VCDB in the following file: /etc/vmware-vpx/vcdb.properties

Here is a screenshot of the file content as well as using psql client located on the VCSA (/opt/vmware/vpostgres/1.0/bin/psql) to connect to the VCDB:

SSODB Credentials:
You can view the credentials for the SSODB in the following file: /usr/lib/vmware-sso/webapps/lookupservice/WEB-INF/classes/config.properties

Here is a screenshot of the file content as well as using psql client located on the VCSA to connect to the SSODB:

More from my site

  • Dude, Where’s My vCenter Server 5.1 Components Installed At?
  • Monitoring vCenter SSO User Account Expiration
  • Configuring Additional VCSA 5.1 as vSphere Web Client Servers
  • Default Password for vCenter SSO Admin Account on VCSA
  • VCSA alarm for VCDB space utilization in vSphere 6.5
Share this...
  • Twitter
  • Facebook
  • Linkedin
  • Reddit
  • Pinterest

Filed Under: Uncategorized Tagged With: postgres, psql, sso, ssodb, vcdb, vcsa, vcva, vpostgres, vSphere 5.1

Reader Interactions

Trackbacks

  1. Monitoring vCenter SSO User Account Expiration | virtuallyGhetto says:
    02/28/2014 at 9:08 pm

    […] SSO DB. If you need help in identifying the vCenter SSO DB credentials, please refer to this article for the […]

    Reply
  2. How to Hack vCenter Database in vCSA Appliance | DoubleCloud => Private Cloud + Public Cloud says:
    07/16/2014 at 5:02 am

    […] @lamw documented in his blog, you can access the database in the vCenter software appliance (vCSA). In the first appliance of […]

    Reply

Thanks for the comment! Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Author

William Lam is a Senior Staff Solution Architect working in the VMware Cloud team within the Cloud Services Business Unit (CSBU) at VMware. He focuses on Automation, Integration and Operation for the VMware Cloud Software Defined Datacenters (SDDC)

  • Email
  • GitHub
  • LinkedIn
  • RSS
  • Twitter
  • Vimeo

Sponsors

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy