Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Dublin

Rollback SO to an older version

  1. Drop SO databases from shared mariadb-galera
Code Block
titleDrop SO databases
collapsetrue
root@release-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 -- mysql -uroot -psecretpassword -e "show databases"
+--------------------+
| Database           |
+--------------------+
| camundabpmn        |
| catalogdb          |
| information_schema |
| my-database        |
| mysql              |
| performance_schema |
| requestdb          |
| sdnctl             |
+--------------------+
root@release-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 -- mysql -uroot -psecretpassword -e "drop database camundabpmn"
root@release-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 -- mysql -uroot -psecretpassword -e "drop database catalogdb"
root@release-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 -- mysql -uroot -psecretpassword -e "drop database requestdb"
root@staging-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 -- mysql -uroot -psecretpassword -e "show databases"
+--------------------+
| Database           |
+--------------------+
| information_schema |
| my-database        |
| mysql              |
| performance_schema |
| sdnctl             |
+--------------------+

     

    2. Change SO image version in OOM charts

Code Block
titleChange image version in charts
collapsetrue
root@release-rancher:~/oom/kubernetes/so# find . -name 'values.yaml' -exec grep -Hn "image:" {} \;
./values.yaml:46:image: onap/so/api-handler-infra:1.4.1
./charts/so-monitoring/values.yaml:35:image: onap/so/so-monitoring:1.4.1
./charts/so-bpmn-infra/values.yaml:30:image: onap/so/bpmn-infra:1.4.1
./charts/so-openstack-adapter/values.yaml:29:image: onap/so/openstack-adapter:1.4.1
./charts/so-catalog-db-adapter/values.yaml:30:image: onap/so/catalog-db-adapter:1.4.1
./charts/so-mariadb/values.yaml:33:image: mariadb:10.1.38
./charts/so-vnfm-adapter/values.yaml:29:image: onap/so/vnfm-adapter:1.4.1
./charts/so-sdnc-adapter/values.yaml:30:image: onap/so/sdnc-adapter:1.4.1
./charts/so-vfc-adapter/values.yaml:30:image: onap/so/vfc-adapter:1.4.1
./charts/so-sdc-controller/values.yaml:30:image: onap/so/sdc-controller:1.4.1
./charts/so-request-db-adapter/values.yaml:30:image: onap/so/request-db-adapter:1.4.1
root@release-rancher:~/oom/kubernetes/so# find . -name 'values.yaml' -exec sed -i 's/1\.4\.1/1\.4\.0-20190425T1407/g' {} \;


    3. Redeploy SO and run healthcheck

Code Block
root@release-rancher:~# ./integration/deployment/heat/onap-rke/scripts/redeploy-module.sh so
root@release-rancher:~# oom/kubernetes/robot/ete-k8s.sh onap health-so


Casablanca

Alpine base image is used for SO in Casablanca

...

Request log under /var/log/ecomp/MSO/ApiHandlerInfra

MariabDB login


Code Block
root@db:~# root@staging-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 bash
bash-4.2$ mysql -uroot -ppasswordpsecretpassword catalogdb


To set Mariadb root password inside Mariadb container for the first time

Code Block
titleSet Mariadb root password
/usr/bin/mysqladmin -u root password 'password'

...