<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article RCA: Unable to upgrade to 6.0 u1 from 5.5 U3 in VMware vCenter™ Documents</title>
    <link>https://communities.vmware.com/t5/VMware-vCenter-Documents/RCA-Unable-to-upgrade-to-6-0-u1-from-5-5-U3/ta-p/2771975</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Issue: Unable to upgrade to 6.0 u1 from 5.5 U3 version because of DB authentication issue.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;summary: While upgrading to 6.0 from 5.5 VCVA version. In step 4 when connect to source appliance&amp;nbsp; getting the following message after filling all the information and hitting next. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; vcdb Error while reading data from the vCenter Server database: psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres" &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Log analysis: &lt;/P&gt;&lt;P&gt;CollectRequirements_com.vmware.vcdb.log file &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.391Z INFO __main__ Set root upgrade folder to: /var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.466Z INFO __main__ Context file /var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/upgrade_working_directory/system-data/upgrade-com.vmware.vcdb-upgradeContext does not exist. Use default context &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.466Z INFO extensions Found upgrade phase &amp;lt;module 'vcdb' from '/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.pyc'&amp;gt;:CollectRequirements' &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.466Z INFO extensions Executing upgrade phase '&amp;lt;module 'vcdb' from '/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.pyc'&amp;gt;:CollectRequirements' with context {u'destinationVcPlatform': u'Linux', u'resourceDir': u'/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/upgrade_working_directory', u'locale': u'en', u'destinationPlatform': u'Linux', u'destinationVcVersion': u'6.0', u'sourceVcPlatform': u'Linux', u'sourcePlatform': u'Linux', 'logD &lt;/P&gt;&lt;P&gt;ir': '/var/log/vmware/upgrade', u'sourceSsoVersion': u'5.5', u'sourceVcVersion': u'5.5', u'destinationSsoVersion': u'6.0', u'systemExportDir': u'/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/upgrade_working_directory/system-data'}. &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.466Z INFO vcdb Configuring log folder paths in /var/log/vmware/upgrade &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.467Z INFO vcdb Retrieving DB type... &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.467Z INFO vcdb DB type retrieved: PostgreSQL &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.485Z INFO vcdb Retrieving DB user... &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.523Z INFO vcdb DB user retrieved: vc &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.540Z INFO vcdb Retrieving DB password... &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.590Z INFO vcdb DB password retrieved: **** &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.611Z INFO vcdb Validating source embedded schema... &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:45.571Z INFO vcdb Souce embedded schema validation completed. &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:45.583Z ERROR vcdb Error while reading data from the vCenter Server database: psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres" &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2015-10-22T15:38:45.584Z ERROR __main__ Upgrade Phase 'vcdb:CollectRequirements' failed. Exception: Error while reading data from the vCenter Server database: psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres"Traceback (most recent call last): &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/componentPhaseLauncher.py", line 379, in main &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; executionResult = systemExtension(exeContext) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/libs/sdk/extensions.py", line 94, in __call__ &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; result = self.extension(*args) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/libs/sdk/extensions.py", line 110, in _func &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; return func(*args) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 1667, in doCollectUpgradeRequirements &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; req = doLinuxCollectReq(context) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 1026, in doLinuxCollectReq &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; sizeCore, sizeSet = CoreSetSizeLinux() &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 503, in CoreSetSizeLinux &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; sizeCore = num(getPsqlQueryResult(sqlCore)) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 471, in getPsqlQueryResult &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; return read_db_value(cmd) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 211, in read_db_value &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; raise PermanentError(cause=error, resolution=suggAction) &lt;/P&gt;&lt;P&gt;PermanentError: Error while reading data from the vCenter Server database: psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres"&amp;nbsp; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;vcdb_req.err file&amp;nbsp; &lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_TABLE &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_INDEX_COLUMN &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_SCHEMA_HASH &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_TABLE &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_INDEX_COLUMN &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_SCHEMA_HASH &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres"&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Solution Sugguested: &lt;/P&gt;&lt;P&gt;The error is coming from Postgres, please check if the pg_hba.cfg file has the correct authentication method selected as documented in the text below &lt;/P&gt;&lt;P&gt;Edit the file /etc/postgresql/8.4/main/pg_hba.conf and replace ident or peer by either md5 or trust, depending on whether you want it to ask for a password on your own computer or not. (for VMware vpostgres, it should be md5) &lt;/P&gt;&lt;P&gt;To reload the configuration if it needs to be modified, please restart the appliance preferably. &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 22 Jun 2017 21:01:07 GMT</pubDate>
    <dc:creator>dekoshal</dc:creator>
    <dc:date>2017-06-22T21:01:07Z</dc:date>
    <item>
      <title>RCA: Unable to upgrade to 6.0 u1 from 5.5 U3</title>
      <link>https://communities.vmware.com/t5/VMware-vCenter-Documents/RCA-Unable-to-upgrade-to-6-0-u1-from-5-5-U3/ta-p/2771975</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Issue: Unable to upgrade to 6.0 u1 from 5.5 U3 version because of DB authentication issue.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;summary: While upgrading to 6.0 from 5.5 VCVA version. In step 4 when connect to source appliance&amp;nbsp; getting the following message after filling all the information and hitting next. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; vcdb Error while reading data from the vCenter Server database: psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres" &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Log analysis: &lt;/P&gt;&lt;P&gt;CollectRequirements_com.vmware.vcdb.log file &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.391Z INFO __main__ Set root upgrade folder to: /var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.466Z INFO __main__ Context file /var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/upgrade_working_directory/system-data/upgrade-com.vmware.vcdb-upgradeContext does not exist. Use default context &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.466Z INFO extensions Found upgrade phase &amp;lt;module 'vcdb' from '/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.pyc'&amp;gt;:CollectRequirements' &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.466Z INFO extensions Executing upgrade phase '&amp;lt;module 'vcdb' from '/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.pyc'&amp;gt;:CollectRequirements' with context {u'destinationVcPlatform': u'Linux', u'resourceDir': u'/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/upgrade_working_directory', u'locale': u'en', u'destinationPlatform': u'Linux', u'destinationVcVersion': u'6.0', u'sourceVcPlatform': u'Linux', u'sourcePlatform': u'Linux', 'logD &lt;/P&gt;&lt;P&gt;ir': '/var/log/vmware/upgrade', u'sourceSsoVersion': u'5.5', u'sourceVcVersion': u'5.5', u'destinationSsoVersion': u'6.0', u'systemExportDir': u'/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/upgrade_working_directory/system-data'}. &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.466Z INFO vcdb Configuring log folder paths in /var/log/vmware/upgrade &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.467Z INFO vcdb Retrieving DB type... &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.467Z INFO vcdb DB type retrieved: PostgreSQL &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.485Z INFO vcdb Retrieving DB user... &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.523Z INFO vcdb DB user retrieved: vc &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.540Z INFO vcdb Retrieving DB password... &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.590Z INFO vcdb DB password retrieved: **** &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:24.611Z INFO vcdb Validating source embedded schema... &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:45.571Z INFO vcdb Souce embedded schema validation completed. &lt;/P&gt;&lt;P&gt;2015-10-22T15:38:45.583Z ERROR vcdb Error while reading data from the vCenter Server database: psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres" &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2015-10-22T15:38:45.584Z ERROR __main__ Upgrade Phase 'vcdb:CollectRequirements' failed. Exception: Error while reading data from the vCenter Server database: psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres"Traceback (most recent call last): &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/componentPhaseLauncher.py", line 379, in main &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; executionResult = systemExtension(exeContext) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/libs/sdk/extensions.py", line 94, in __call__ &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; result = self.extension(*args) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/libs/sdk/extensions.py", line 110, in _func &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; return func(*args) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 1667, in doCollectUpgradeRequirements &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; req = doLinuxCollectReq(context) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 1026, in doLinuxCollectReq &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; sizeCore, sizeSet = CoreSetSizeLinux() &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 503, in CoreSetSizeLinux &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; sizeCore = num(getPsqlQueryResult(sqlCore)) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 471, in getPsqlQueryResult &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; return read_db_value(cmd) &lt;/P&gt;&lt;P&gt;&amp;nbsp; File "/var/tmp/vmware-upgrade-requirements/cis-upgrade-runner/payload/component-scripts/vcdb/__init__.py", line 211, in read_db_value &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; raise PermanentError(cause=error, resolution=suggAction) &lt;/P&gt;&lt;P&gt;PermanentError: Error while reading data from the vCenter Server database: psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres"&amp;nbsp; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;vcdb_req.err file&amp;nbsp; &lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_TABLE &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_INDEX_COLUMN &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_SCHEMA_HASH &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_TABLE &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_INDEX_COLUMN &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WARNING: Cannot execute statement(rc=100). &lt;/P&gt;&lt;P&gt;DELETE FROM VPX_SCHEMA_HASH &lt;/P&gt;&lt;P&gt;^^^^^^^^^^ &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;psql.bin: FATAL:&amp;nbsp; Ident authentication failed for user "postgres"&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Solution Sugguested: &lt;/P&gt;&lt;P&gt;The error is coming from Postgres, please check if the pg_hba.cfg file has the correct authentication method selected as documented in the text below &lt;/P&gt;&lt;P&gt;Edit the file /etc/postgresql/8.4/main/pg_hba.conf and replace ident or peer by either md5 or trust, depending on whether you want it to ask for a password on your own computer or not. (for VMware vpostgres, it should be md5) &lt;/P&gt;&lt;P&gt;To reload the configuration if it needs to be modified, please restart the appliance preferably. &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 22 Jun 2017 21:01:07 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-vCenter-Documents/RCA-Unable-to-upgrade-to-6-0-u1-from-5-5-U3/ta-p/2771975</guid>
      <dc:creator>dekoshal</dc:creator>
      <dc:date>2017-06-22T21:01:07Z</dc:date>
    </item>
  </channel>
</rss>

