> For the complete documentation index, see [llms.txt](https://lern.sunbird.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://lern.sunbird.org/use/release-notes/release-v-5.0.1.md).

# Release V 5.0.1

### Document Release Version <a href="#document-release-version" id="document-release-version"></a>

| Project | Release Date | Version |
| ------- | ------------ | ------- |
| Lern    | 29 Nov 22    | V 5.0.1 |

### Details of Released Tag

| Components        | Jenkins Job                          | Deploy Tags (Devops) | Build Tags (Github Repo Tags)                                                                                                                                                                                                 | Github Repository                                        | Comments                                                                                 |
| ----------------- | ------------------------------------ | -------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------- | ---------------------------------------------------------------------------------------- |
| Batch Service     | Build/Core/Lms                       | release-5.1.0\_RC1   | <p>sunbird-course-service : <a href="https://github.com/Sunbird-Lern/sunbird-course-service/releases/tag/release-5.0.1_RC3">release-5.0.1\_RC</a>3</p><p><br></p>                                                             | <https://github.com/Sunbird-Lern/sunbird-course-service> |                                                                                          |
| Batch Service     | Build/Core/Cert                      | release-5.1.0\_RC1   | cert-service : [release-5.0.1\_RC2](https://github.com/Sunbird-Lern/cert-service/releases/tag/release-5.0.1_RC2)                                                                                                              | <https://github.com/Sunbird-Lern/cert-service>           |                                                                                          |
| Batch Service     | Build/job/Lern/job/FlinkJobs         | release-5.0.1\_RC5   | <p>data-pipeline : <a href="https://github.com/Sunbird-Lern/data-pipeline/releases/tag/release-5.0.1_RC5">release-5.0.1\_RC5</a></p><p><br></p>                                                                               | <https://github.com/Sunbird-Lern/data-pipeline>          | Collection-cert-pre-processor, Collection-certificate-generator jobs need to be deployed |
| User\&Org Service | Build/Core/Learner                   | release-5.1.0\_RC1   | sunbird-lms-service : [\*\*\*\* ](https://github.com/Sunbird-Lern/sunbird-lms-service/releases/tag/release-5.0.0_RC1)[release-5.0.1\_RC2](https://github.com/Sunbird-Lern/sunbird-lms-service/releases/tag/release-5.0.1_RC2) | <https://github.com/Sunbird-Lern/sunbird-lms-service>    |                                                                                          |
| Data Products     | Build/job/Lern/job/LernDataProducts/ | release-5.0.1\_RC4   | <p>data-products : <a href="https://github.com/Sunbird-Lern/data-products/releases/tag/release-5.0.1_RC4">release-5.0.1\_RC4</a></p><p></p>                                                                                   | <https://github.com/Sunbird-Lern/data-products>          |                                                                                          |

### **Summary of the Changes** <a href="#id-1.-summary-of-the-changes" id="id-1.-summary-of-the-changes"></a>

* Making SB Lern Cloud agnostic

#### Affected Areas:

* Textbook upload and download
* QRCode list download from workspace
* Old certificate download
* New certificate generation and download
* Exhaust Reports - UserInfo, Progress and Reponse Exhausts
* OrgAdmin Reports - Org Consent Report and Geo Reports

### Details of the Changes

[LR-262 ](https://project-sunbird.atlassian.net/browse/LR-262)OCI and Open stack support analysis

[LR-263 ](https://project-sunbird.atlassian.net/browse/LR-263)CSP integration testing in Non-Ed env

[LR-254 ](https://project-sunbird.atlassian.net/browse/LR-254)BatchService: CSP Data migration for certificate obj data in RC

### Env Configurations (Needs to be done before service deployment):

The below environment variable needs to be configured in the devops repo.

| Variable Name              | Values                                     | Comments                          |
| -------------------------- | ------------------------------------------ | --------------------------------- |
| cloud\_storage\_base\_url  | <https://sunbirddev.blob.core.windows.net> | To store the CSP base path        |
| cloud\_storage\_cname\_url | <https://obj.dev.sunbirded.org>            | To store the cname url of the CSP |

<details>

<summary>Ansible Changes need to be updated in Common.yml, secrets.yml, hosts.yml</summary>

```
sunbird-devops-private/ansible/inventory/{{env}}/KnowledgePlatform

hosts:

## Lern dataproducts
[learning]

[raw-broker]

[report-cassandra]

[raw-coordinator]

[redis]

[raw-overlord]

[lp-cassandra]



common:

## Lern dataproducts
dp_vault_artifacts_container: 
db_admin_password: 
db_password: 
postgres:                                                                                         
  db_url:       #"{{ groups['postgres'][0] }}"
  db_username:  #analytics
  db_name: 
  db_password: 
  db_table_name: 
  db_port: 5432
  db_admin_user: 
  db_admin_password: 
data_exhaust_webhook_url: 
data_exhaust_Channel: 
data_exhaust_name:
user_port: 6379

secrets:

## Lern dataproducts
dp_vault_data_exhaust_token: 
dp_vault_pgdb_admin_password: 
dp_vault_pgdb_password: 
dp_vault_druid_postgress_pass: 
core_vault_sunbird_api_auth_token:
core_vault_sunbird_encryption_key:   ### This variable added for admin user reports which is bein used to encrypt and decrypt data in cassandra.
```

</details>

### Data Migrations: (Run these scripts after service deployment)

* **This script is to update the variable based relative url for cloud resources to course\_batch(cassandra) and job\_request(postgres) database tables.**

<https://project-sunbird.atlassian.net/wiki/spaces/UM/pages/3238723588/CSP+changes+in+Lern+related+tables>

Verification Steps after migration:

Check few records in course\_batch table to see whether the certificate template cloud url is changed to variable format and also check in job\_request table to see whether the report url is in relative path format.

* **Update blob URL or CNAME URL in ES ad RC DB**

To change actual URL to CNAME URL or In case of opting new CSP provider, to change to new blob URL execute below scripts :

RC PostgreSQL DB table V\_TrainingCertificate data migration: <https://project-sunbird.atlassian.net/wiki/spaces/UM/pages/3256877067/Training+certificate+migration>

ES Migrations(course-batch index, trainingcertificate index)[ : ](https://project-sunbird.atlassian.net/wiki/spaces/UM/pages/3231449089/CSP+Changes+for+Course+Batch+and+RC)[https://project-sunbird.atlassian.net/wiki/spaces/UM/pages/3231449089/CSP+Changes+for+Course+Batch+and+](https://project-sunbird.atlassian.net/wiki/spaces/UM/pages/3231449089/CSP+Changes+for+Course+Batch+and+RC)RC

Verification Steps after migration:

Check ES course\_batch index and TrainingCertificate index to see whether the certificate template cloud url is changed to new csp blob url or cname url.

Also check in postgres V\_TrainingCertificate table to see whether the certificate template url is changed to new csp blob url or cname url.

* **Update system settings values for sunbird**

Run the system-setting for setting the sunbird id value and the read the api

```
curl --location --request POST 'https://staging.sunbirded.org/api/data/v1/system/settings/set
' \
--header 'Authorization: Bearer {{authorization-key}}' \
--header 'Content-Type: application/json' \
--data-raw '{
	
	"request" :
		{
			 {
                "id": "sunbird",
                "field": "sunbird",
                "value": "{\\\"latestVersion\\\":\\\"v1\\\",\\\"v1\\\":{\\\"url\\\":\\\"https:\/\/obj.stage.sunbirded.org\/portal\/terms-and-conditions-v1.html\\\"}}"
            }
	}
}'





```


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://lern.sunbird.org/use/release-notes/release-v-5.0.1.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.