Installation of Sunbird-Lern User&Org service

[devaj04]

Trying to get health API - http://localhost:9000/health
In response getting, Elasticsearch CONNECTION_ERROR

I have followed the below steps still facing the issue.

{
"id": "api.all.health",
"ver": "health",
"ts": "2023-03-23 15:11:09:408+0530",
"params": {
"resmsgid": "2bbb0165-bfb7-4361-9228-0cd8473d489b",
"msgid": "2bbb0165-bfb7-4361-9228-0cd8473d489b",
"err": null,
"status": "SUCCESS",
"errmsg": null
},
"responseCode": "OK",
"result": {
"response": {
"checks": [
{
"err": "",
"healthy": true,
"name": "Learner service",
"errmsg": ""
},
{
"err": "",
"healthy": true,
"name": "Actor service",
"errmsg": ""
},
{
"err": "",
"healthy": true,
"name": "Cassandra service",
"errmsg": ""
},
{
"err": "CONNECTION_ERROR",
"healthy": false,
"name": "Elastic search service",
"errmsg": "Connection error"
}
],
"healthy": false,
"name": "Complete health check api"
}
}
}

[BharathwajShankar]

@devaj04 Kindly please check if the elastic search docker container is up and running on your local machine. Also please check all elastic search-related environment variables got settled up correctly in your local machine. If you still face the issue, run the application in the debug mode and keep breakpoints in the initialiseRestClientConnection() method of ConnectionManager.java and see whether the values of cluster, hostname and port get set up correctly.

[devaj04]

@BharathwajShankar
Could you please help with this
I am doing Cassandra migration, and follow the below step and getting error
https://lern.sunbird.org/use/developer-installation/user-and-org-service/installation-guide

[BharathwajShankar]

@devaj04

1. Kindly checkout to release-5.2.0 branch in sunbird-utils
2. Go to the path /sunbird-utils/sunbird-cassandra-migration/cassandra-migration and then run,
   java -jar
   -Dcassandra.migration.scripts.locations=filesystem:/sunbird-utils/sunbird-cassandra-migration/cassandra-migration/db/migration/cassandra
   -Dcassandra.migration.cluster.contactpoints=localhost
   -Dcassandra.migration.cluster.port=9042
   -Dcassandra.migration.cluster.username=username
   -Dcassandra.migration.cluster.password=password
   -Dcassandra.migration.keyspace.name=keyspace_name
   target/*-jar-with-dependencies.jar migrate

(you have to replace respective keyspace,filepath in the above command)

[devaj04]

@BharathwajShankar now got another issue
java -jar -Dcassandra.migration.scripts.locations=D:/Workspace/Sunbird-Lern/UserOrg-Service/sunbird-utils/sunbird-cassandra-migration/cassandra-migration/src/main/resources/db/migration/cassandra -Dcassandra.migration.cluster.contactpoints=localhost -Dcassandra.migration.cluster.port=9042 -Dcassandra.migration.cluster.username=username -Dcassandra.migration.cluster.password=password -Dcassandra.migration.keyspace.name=sunbird cassandra-migration-0.0.1-SNAPSHOT.jar migrate

no main manifest attribute, in cassandra-migration-0.0.1-SNAPSHOT.jar

[BharathwajShankar]

@devaj04 please keep this as it it is and don't change it. I think that should fix this issue.

target/*-jar-with-dependencies.jar migrate

[devaj04]

@BharathwajShankar

[BharathwajShankar]

@devaj04 please run mvn clean install -DskipTests before running the migration command

[devaj04]

@BharathwajShankar

[AmiableAnil]

@devaj04
Please follow the following steps:

1. Go to cassandra-migration
2. Run mvn clean install -DskipTests
3. Run java -jar \ -Dcassandra.migration.scripts.locations=filesystem:src/main/resources/db/migration/cassandra/sunbird \ -Dcassandra.migration.cluster.contactpoints=localhost \ -Dcassandra.migration.cluster.port=9042 \ -Dcassandra.migration.cluster.username=<username>\ -Dcassandra.migration.cluster.password=<password>\ -Dcassandra.migration.keyspace.name=sunbird \ target/*-jar-with-dependencies.jar migrate

cc: @BharathwajShankar @reshmi-nair
Note: set your cassandra username and password.

[devaj04]

@BharathwajShankar

After successful of the Cassandra migration, now i am trying to check the Health API of the User and Org service following the below link
https://lern.sunbird.org/use/developer-installation/user-and-org-service/installation-guide

and getting issues in Elasticsearch

{
"id": "api.all.health",
"ver": "health",
"ts": "2023-04-17 14:57:47:554+0530",
"params": {
"resmsgid": "d2ed5903-42c4-4764-8b97-aa1610d538f7",
"msgid": "d2ed5903-42c4-4764-8b97-aa1610d538f7",
"err": null,
"status": "SUCCESS",
"errmsg": null
},
"responseCode": "OK",
"result": {
"response": {
"checks": [
{
"err": "",
"healthy": true,
"name": "Learner service",
"errmsg": ""
},
{
"err": "",
"healthy": true,
"name": "Actor service",
"errmsg": ""
},
{
"err": "",
"healthy": true,
"name": "Cassandra service",
"errmsg": ""
},
{
"err": "CONNECTION_ERROR",
"healthy": false,
"name": "Elastic search service",
"errmsg": "Connection error"
}
],
"healthy": false,
"name": "Complete health check api"
}
}
}

[BharathwajShankar]

@devaj04 please make sure the environment variables are settled properly for elastic search-related configurations in bashrc file and environment variables.

export sunbird_es_host=localhost
export sunbird_es_port=9200
export sunbird_es_cluster=docker-cluster //replace with your cluster
export user_index_alias=user
export org_index_alias=org

[devaj04]

Thank you now we got elasticsearch healthy true
@AmiableAnil @BharathwajShankar