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

Code Block
titleAlpine Linux
root@oom-rancher:~# kubectl -n onap exec -it dev-so-so-bpmn-infra-5887f8c6c8-xdvvj sh
/app # cat /etc/os-release
NAME="Alpine Linux"
ID=alpine
VERSION_ID=3.8.1
PRETTY_NAME="Alpine Linux v3.8"
HOME_URL="http://alpinelinux.org"
BUG_REPORT_URL="http://bugs.alpinelinux.org"
/app # cat
/etc/alpine-release
3.8.1/app # apk add tcpdump

Known issue

...


Enable debug log

Turn on debug by access http://{{so}}:8080/mso/logging/debug from browser. Also you need to add/change line like "log.debug.CustomE2EGetService=true" in /etc/mso/config.d/mso.bpmn.urn.properties to enable Groove file level debugging. Other debug flags are: 

...

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

MariabDB login


Code Block
root@db:~# mysql -uroot -ppasswordroot@staging-rancher:~# kubectl -n onap exec -it dev-mariadb-galera-mariadb-galera-0 bash
bash-4.2$ mysql -uroot -psecretpassword 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'


Important tables are vnf_resource and vnf_recipe

...