Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

Cannot connect to the VMware vCenter Server Appliance 5.x (2035070)

Symptoms

  • You cannot connect to the VMware vCenter Server Appliance (VCSA) using the vSphere Client.
  • In the VCSA console, you see the error:

    waiting for the embedded database to start up.............. failed

  • In the /var/log/vmware/vpx/vpxd.log file, you see entries similar to:
[VpxdVdb::SetDBType] Logging in to DSN: VMware VirtualCenter with username vc
[VpxdVdb::SetDBType] Logging in to DSN: VMware VirtualCenter with username vc
[VpxdVdb::SetDBType] Logging in to DSN: VMware VirtualCenter with username vc
[VpxdVdb::SetDBType] Logging in to DSN: VMware VirtualCenter with username vc
[VpxdVdb::SetDBType] Logging in to DSN: VMware VirtualCenter with username vc
[VpxdVdb::SetDBType] Logging in to DSN: VMware VirtualCenter with username vc
[VpxdVdb::SetDBType] Failed to connect to database: ODBC error: (08001) - [unixODBC]could not connect to server: Connection refused
-->     Is the server running on host "127.0.0.1" and accepting
--> .  Retry attempt: 193 ...
-->     TCP/IP connections on port 5432?

Cause

This issue occurs if the vCenter Server Appliance has lost its ODBC configuration and is unable to start the embedded DB2 database.

Resolution

To resolve this issue, reconfigure the ODBC connection.
 
To reconfigure the ODBC connection:
  1. Connect to the vCenter Server Appliance via SSH as the root user. The default password is vmware.

    Note: To enable SSH on the vCenter Server Appliance 5.x, see the Enable or Disable SSH Administrator Login on the VMware vCenter Server Appliance section of the vCenter Server and Host Management Guide.

  2. Run this command to stop the vpxd service:

    service vmware-vpxd stop

  3. Run this command:

    /usr/sbin/vpxd_odbcconfig

    You see output similar to:

    VMware vCenter Server Appliance ODBC Configuration

    Choose a database to use with VMware vCenter Server

    1) oracle
    2) embedded

  4. Enter 2.

    You see output similar to:


    Configuring ODBC for embedded
    Operation was successful.
    Database already populated with version VirtualCenter Database 5.0
    Reinitialize database? (WARNING: WILL DELETE ALL RECORDS) [y(es)|N(O)]: OK, preserving the database. (select No to preserve the database)
    Restart vCenter Server now to activate the database changes [y/N]:y
    Successfully restarted vCenter Server

Additional Information

To be alerted when this article is updated, click Subscribe to Document in the Actions box.

See Also

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 25 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 25 Ratings
Actions
KB: