private cloud : error executing installation validation command,Error executing validation tests

[thibaulttigeon]

I installed apigee (5 nodes clustered) private cloud.

I execute the installation validation script:

/opt/apigee/apigee-service/bin/apigee-service apigee-validate setup -f  apigee-confi-file

And I have this error:

More than 2 Postgres servers, please see documentation to configure ax group
!!!! Error !!!!
HTTP STATUS CODE: 400

Checking for optional variables
Found optional variable APIGEE_ADMINPW...OK
Found optional variable APIGEE_PORT_HTTP_MS...OK
Found optional variable AXGROUP...OK
Found optional variable CONSUMER_GROUP...OK
Anaytics group alread created
Creating Consumer Group consumer-group-001
{
  "name" : "axgroup-001",
  "properties" : {
  },
  "scopes" : [ "VALIDATE~test" ],
  "uuids" : {
    "qpid-server" : [ "38fc7747-68f4-42cb-909b-38c5a6db7f9a", "cb6ad340-1ebd-4759-b14b-0c083b046565", "8c9f5428-83d1-4951-afcc-4ba8c3e1df8b" ],
    "aries-datastore" : [ ],
    "postgres-server" : [ "aff043cc-1a95-439f-b14e-08c09d7bdf36:1b49bba8-467d-4c00-80c6-99afeff8add3" ],
    "dw-server" : [ ]
  },
  "consumer-groups" : [ {
    "name" : "consumer-group-001",
    "consumers" : [ "38fc7747-68f4-42cb-909b-38c5a6db7f9a", "cb6ad340-1ebd-4759-b14b-0c083b046565", "8c9f5428-83d1-4951-afcc-4ba8c3e1df8b" ],
    "datastores" : [ "aff043cc-1a95-439f-b14e-08c09d7bdf36:1b49bba8-467d-4c00-80c6-99afeff8add3" ],
    "properties" : {
    }
  } ],
  "data-processors" : {
  }
}
More than 2 Postgres servers, please see documentation to configure ax group
!!!! Error !!!!
HTTP STATUS CODE: 400
{
  "code" : "dataapi.service.PGNotRegistered",
  "message" : "dataapi.service.PGNotRegistered",
  "contexts" : [ ]
}
{
  "name" : "axgroup-001",
  "properties" : {
  },
  "scopes" : [ "VALIDATE~test" ],
  "uuids" : {
    "qpid-server" : [ "38fc7747-68f4-42cb-909b-38c5a6db7f9a", "cb6ad340-1ebd-4759-b14b-0c083b046565", "8c9f5428-83d1-4951-afcc-4ba8c3e1df8b" ],
    "aries-datastore" : [ ],
    "postgres-server" : [ "aff043cc-1a95-439f-b14e-08c09d7bdf36:1b49bba8-467d-4c00-80c6-99afeff8add3" ],
    "dw-server" : [ ]
  },
  "consumer-groups" : [ {
    "name" : "consumer-group-001",
    "consumers" : [ "38fc7747-68f4-42cb-909b-38c5a6db7f9a", "cb6ad340-1ebd-4759-b14b-0c083b046565", "8c9f5428-83d1-4951-afcc-4ba8c3e1df8b" ],
    "datastores" : [ "aff043cc-1a95-439f-b14e-08c09d7bdf36:1b49bba8-467d-4c00-80c6-99afeff8add3" ],
    "properties" : {
    }
  } ],
  "data-processors" : {
  }
}

I do not understand because I installed prostgres only on 2 nodes...

I added my apigee configuration file (apigee-config.txt) in attachment.

Someone can help me ?

Rgds,

Thibault

[#2]

I see 3 Qpids and 2 Postgres on the output. Is that correct based on your installation?, typically a 5 nodes installation will have 2 Qpids.

Run status in all nodes and share the output:

/opt/apigee/apigee-service/bin/apigee-all status

Execute the following APIs and share the output:

curl -v -u <sysAdminEmail> "http://<ms-ip>:8080/v1/servers?pod=analytics&region=dc-1" 

curl -u <sysAdminEmail> "http://<ms_IP>:8080/v1/analytics/groups/ax" 

curl -v -u <sysAdminEmail> http://<ms-ip>:8080/v1/o/<orgname>/e/<envname>/provisioning/axstatus

[thibaulttigeon]

Hello Maudrit,

Thank you for you answer !

Here my architecture (hostName = ip):

Node1and5 = X.X.X.33

ds,ms,sax

Node2 = X.X.X.34

ds,rmp

Node3 = X.X.X.35

ds,rmp

Node4 = X.X.X.36

sax

I only 4 machines, so I installed sax on node 1 instead of node5.

I installed only 2 sax, so 2 postgress (1 master and 1 standby) and 2 qpid. I do not know where is the 3rd ghost qpid installtion 😞

I past the result of these commands on this file : apigee-support.txt

For your information, I replace your command :

curl -v -u <sysAdminEmail>"http://<ms-ip>:8080/v1/servers?pod=analytics®ion=dc-1"

by

curl -v -u <sysAdminEmail>"http://<ms-ip>:8080/v1/servers?pod=analytics

Because I do not understand the special caracter ® before ion=dc-1"

Thanks in advance,

Thibault

[mpurwar]

@TIGEON Thibault - Restart the Postgres nodes when you provision a new environment and that error should go away.

[thibaulttigeon]

Hello @Mudit,

I restarted my two postgress nodes but I have the same problème.

Rgds,

Thibault

[thibaulttigeon · Accepted solution]

I found the solution to my problem.

When I run the command

# List postgres server 
apigee-adminapi.sh servers list -r dc-1 -p analytics -t postgres-server --admin admi@dress --pwd MyP@ssword --host localhost

I have this result:

[ {
  "externalHostName" : "localhost",
  "externalIP" : "X.X.X.33",
  "internalHostName" : "localhost",
  "internalIP" : "X.X.X.33",
  "isUp" : true,
  "pod" : "analytics",
  "reachable" : true,
  "region" : "dc-1",
  "tags" : {
    "property" : [ {
      "name" : "started.at",
      "value" : "1493304609874"
    }, {
      "name" : "startup.time",
      "value" : "30 seconds "
    }, {
      "name" : "Profile",
      "value" : "AXPlatformAgentService"
    }, {
      "name" : "rpc.port",
      "value" : "4530"
    }, {
      "name" : "dp.color",
      "value" : "green"
    }, {
      "name" : "http.management.port",
      "value" : "8084"
    }, {
      "name" : "startup.interval",
      "value" : "30124"
    }, {
      "name" : "up.time",
      "value" : "1 week 6 days 1 hour 48 minutes 32 seconds"
    } ]
  },
  "type" : [ "postgres-server" ],
  "uUID" : "250b26d4-eedc-4092-9bea-29b783b29799"
}, {
  "buildInfo" : {
    "buildNumber" : "jenkins-5G_Release_Sanity-967",
    "buildTimestamp" : "1484808641662",
    "rPMName" : "apigee-rpm-1.0.0.967.30ab7d8.1701190636-160921_09",
    "releaseID" : "160921_09",
    "sCMBranch" : "origin/OPDK_1701",
    "sCMRevision" : "30ab7d87f9b887d912e08d88a86294e6e4d9b659"
  },
  "externalHostName" : "localhost",
  "externalIP" : "X.X.X.36",
  "internalHostName" : "localhost",
  "internalIP" : "X.X.X.36",
  "isUp" : false,
  "pod" : "analytics",
  "reachable" : true,
  "region" : "dc-1",
  "tags" : {
    "property" : [ {
      "name" : "started.at",
      "value" : "1493211149942"
    }, {
      "name" : "startup.time",
      "value" : "8 seconds "
    }, {
      "name" : "Profile",
      "value" : "AXPlatformAgentService"
    }, {
      "name" : "rpc.port",
      "value" : "4530"
    }, {
      "name" : "dp.color",
      "value" : "green"
    }, {
      "name" : "http.management.port",
      "value" : "8084"
    }, {
      "name" : "startup.interval",
      "value" : "8795"
    }, {
      "name" : "up.time",
      "value" : "NA"
    } ]
  },
  "type" : [ "postgres-server" ],
  "uUID" : "aff043cc-1a95-439f-b14e-08c09d7bdf36"
}, {
  "buildInfo" : {
    "buildNumber" : "jenkins-5G_Release_Sanity-967",
    "buildTimestamp" : "1484808641662",
    "rPMName" : "apigee-rpm-1.0.0.967.30ab7d8.1701190636-160921_09",
    "releaseID" : "160921_09",
    "sCMBranch" : "origin/OPDK_1701",
    "sCMRevision" : "30ab7d87f9b887d912e08d88a86294e6e4d9b659"
  },
  "externalHostName" : "localhost",
  "externalIP" : "X.X.X.33",
  "internalHostName" : "localhost",
  "internalIP" : "X.X.X.33",
  "isUp" : false,
  "pod" : "analytics",
  "reachable" : true,
  "region" : "dc-1",
  "tags" : {
    "property" : [ {
      "name" : "started.at",
      "value" : "1493135784666"
    }, {
      "name" : "startup.time",
      "value" : "8 seconds "
    }, {
      "name" : "Profile",
      "value" : "AXPlatformAgentService"
    }, {
      "name" : "rpc.port",
      "value" : "4530"
    }, {
      "name" : "dp.color",
      "value" : "green"
    }, {
      "name" : "http.management.port",
      "value" : "8084"
    }, {
      "name" : "startup.interval",
      "value" : "8183"
    }, {
      "name" : "up.time",
      "value" : "NA"
    } ]
  },
  "type" : [ "postgres-server" ],
  "uUID" : "1b49bba8-467d-4c00-80c6-99afeff8add3"
}, {
  "externalHostName" : "localhost",
  "externalIP" : "X.X.X.36",
  "internalHostName" : "localhost",
  "internalIP" : "X.X.X.36",
  "isUp" : true,
  "pod" : "analytics",
  "reachable" : true,
  "region" : "dc-1",
  "tags" : {
    "property" : [ {
      "name" : "started.at",
      "value" : "1493304635561"
    }, {
      "name" : "startup.time",
      "value" : "9 seconds "
    }, {
      "name" : "Profile",
      "value" : "AXPlatformAgentService"
    }, {
      "name" : "rpc.port",
      "value" : "4530"
    }, {
      "name" : "dp.color",
      "value" : "green"
    }, {
      "name" : "http.management.port",
      "value" : "8084"
    }, {
      "name" : "startup.interval",
      "value" : "9887"
    }, {
      "name" : "up.time",
      "value" : "1 week 6 days 1 hour 48 minutes 27 seconds"
    } ]
  },
  "type" : [ "postgres-server" ],
  "uUID" : "e2b7d58c-9af3-4ca6-bed8-23f7bf00cf49"
}, {
  "buildInfo" : {
    "buildNumber" : "jenkins-5G_Release_Sanity-967",
    "buildTimestamp" : "1484808641662",
    "rPMName" : "apigee-rpm-1.0.0.967.30ab7d8.1701190636-160921_09",
    "releaseID" : "160921_09",
    "sCMBranch" : "origin/OPDK_1701",
    "sCMRevision" : "30ab7d87f9b887d912e08d88a86294e6e4d9b659"
  },
  "externalHostName" : "localhost",
  "externalIP" : "X.X.X.36",
  "internalHostName" : "localhost",
  "internalIP" : "X.X.X.36",
  "isUp" : false,
  "pod" : "analytics",
  "reachable" : true,
  "region" : "dc-1",
  "tags" : {
    "property" : [ {
      "name" : "started.at",
      "value" : "1493211789987"
    }, {
      "name" : "startup.time",
      "value" : "12 seconds "
    }, {
      "name" : "Profile",
      "value" : "AXPlatformAgentService"
    }, {
      "name" : "rpc.port",
      "value" : "4530"
    }, {
      "name" : "dp.color",
      "value" : "green"
    }, {
      "name" : "http.management.port",
      "value" : "8084"
    }, {
      "name" : "startup.interval",
      "value" : "12355"
    }, {
      "name" : "up.time",
      "value" : "NA"
    } ]
  },
  "type" : [ "postgres-server" ],
  "uUID" : "17f9c700-c600-4af4-83fd-24b55d3c5139"
}, {
  "buildInfo" : {
    "buildNumber" : "jenkins-5G_Release_Sanity-967",
    "buildTimestamp" : "1484808641662",
    "rPMName" : "apigee-rpm-1.0.0.967.30ab7d8.1701190636-160921_09",
    "releaseID" : "160921_09",
    "sCMBranch" : "origin/OPDK_1701",
    "sCMRevision" : "30ab7d87f9b887d912e08d88a86294e6e4d9b659"
  },
  "externalHostName" : "localhost",
  "externalIP" : "X.X.X.33",
  "internalHostName" : "localhost",
  "internalIP" : "X.X.X.33",
  "isUp" : false,
  "pod" : "analytics",
  "reachable" : true,
  "region" : "dc-1",
  "tags" : {
    "property" : [ {
      "name" : "started.at",
      "value" : "1493195130419"
    }, {
      "name" : "startup.time",
      "value" : "11 seconds "
    }, {
      "name" : "Profile",
      "value" : "AXPlatformAgentService"
    }, {
      "name" : "rpc.port",
      "value" : "4530"
    }, {
      "name" : "dp.color",
      "value" : "green"
    }, {
      "name" : "http.management.port",
      "value" : "8084"
    }, {
      "name" : "startup.interval",
      "value" : "11174"
    }, {
      "name" : "up.time",
      "value" : "NA"
    } ]
  },
  "type" : [ "postgres-server" ],
  "uUID" : "5d50d7b6-2289-4502-a6fd-2129e644e572"
} ]

And I see 4 "isUp" : false, postgres servers.

So, I removed these 4 servers with there uuid with these commands:

apigee-adminapi.sh servers deregister -u UUID -r dc-1 -p analytics -t postgres-server -Y --admin admin@dress --pwd P@ssword --host localhost

and

apigee-adminapi.sh servers delete -u UUID --admin admin@dress --pwd P@ssword --host localhost

Thank you for your help,

Thibault