Unable to start vCenter services

[slewy]

Hi,

I have quite big problem with vCenter server installed on Windows 2012 R2. All was working fine, there was no software updates, but now since few days most of the VMware services can not be started at all:

Services status:

Name                                                        StartType  Status

----                                                        -     --------  ------

VMWareAfdService                                  Automatic Stopped

VMwareCAFManagementAgentHost       Automatic Running

VMWareCertificateService                       Automatic Stopped

vmware-cis-config                                    Automatic Stopped

VMwareDirectoryService                         Automatic Stopped

VMwareDNSService                                Automatic Stopped

VMwareIdentityMgmtService                   Automatic Stopped

vmware-psc-client                                   Automatic Stopped

VMwareSTS                                            Automatic Stopped

vmware-ufad-vci                                      Automatic Running

When trying to connect to the DB:

C:\Program Files\VMware\vCenter Server\vPostgres\bin>psql -d VCDB -U vc

psql: could not connect to server: Connection refused (0x0000274D/10061)

        Is the server running on host "localhost" (127.0.0.1) and accepting

        TCP/IP connections on port 5432?

could not connect to server: Connection refused (0x0000274D/10061)

        Is the server running on host "localhost" (::1) and accepting

        TCP/IP connections on port 5432?

or when trying to list all services:

C:\Program Files\VMware\vCenter Server\bin>service-control --list

Traceback (most recent call last):

  File "C:\Program Files\VMware\vCenter Server\bin\\service-control", line 14, in <module>

    from cis.svcscfg import (platform, isCorePnidService, loadServicesFile,

ImportError: cannot import name platform

Additionally vpdx.log has been attached.

Any advice what is wrong and how to fix it?

BR

Szczepan

[rchaubey]

I have seen below error message in vpxd log .

error vpxd[06524] [Originator@6876 sub=Default] Vdb::Connection::TestConnection SQLExecute failed: 08S01:34

2018-06-20T10:09:07.320+02:00 error vpxd[06524] [Originator@6876 sub=Default] Vdb::Connection::TestConnection SQLExecute failed: 08S01:34

please see this KB Article----VMware Knowledge Base 

[slewy]

Hi,

it is not the case as this instance is configured with postresql:

driver = org.postgresql.Driver

dbtype = PostgreSQL

[Aidan_Charapiye]

Hi, have you found a solution? I am facing the same issue now with my vCenter

[bryanvaneeden]

It looks like there is an issue with your postgresql database. You might want to check the following:

• Is the ODBC connection working and configured correctly?
• Is the psql service running?
• Is the postgresql database running on the default port 5432? You can check this in the postgresql.conf configuration file.
• Does the vc user have enough permissions? It should because it was running before right?
• Turn off the Antivirus and/or Window Firewall and try connecting to the psql database gain.

One of the above steps might be able to help solve the issue at hand. 

Please let me know if you have any other questions.

[Aidan_Charapiye]

Hi , 

• Is the ODBC connection working and configured correctly?

If I check connection under "ODBC Data Source Administrator" -> "System DSN" -> Configure, Test - it gives me the same error: "could not connect to server: Connection refused (0x0000274D/10061)......."

• Is the psql service running?

I couldn't find individual service "psql" , as I think it should run under VMware Postgres (or I am wrong?). Which is not running.

• Is the postgresql database running on the default port 5432? You can check this in the postgresql.conf configuration file?

Yes, checked.

• Does the vc user have enough permissions? It should because it was running before right?

Yes, previously was running fine. All VMware service are stopped at sudden. 

• Turn off the Antivirus and/or Window Firewall and try connecting to the psql database gain.

Tried, no luck.

Tried to connect to DB via pgAdmin - same error.

I also tried to backup embedded database, to reinstall vCenter. However, I found that the .bak file is empty after doing python.exe backup. Now I am stuck.

Regards

[bryanvaneeden]

Since the VMware Postgres service is not running it seems obvious that you cannot connect to it. Please start this service.