Known issue and fix
Known issues:
Migration script race condition operation app startup and work around (This issue has been fixed in version 1.11.1, and future versions)
Port forward ops-mysql -3307
Connect the mysql with root username and password (Get the credentials from mysql pod)
Delete the tenants from tenant server connections table
Run the SQL scripts which didn't run successfully
SQL script:-
Copy
CREATE DATABASE `tenants`;
GRANT ALL PRIVILEGES ON `tenants`.* TO 'mifos';
CREATE DATABASE `tn01`;
CREATE DATABASE `tn02`;
GRANT ALL PRIVILEGES ON `tn01`.* TO 'mifos';
GRANT ALL PRIVILEGES ON `tn02`.* TO 'mifos';
GRANT ALL ON *.* TO 'root'@'%';
Restart ops-app pod
Deletion of cluster roles and bindings
kubectl delete clusterroles
kubectl get clusterroles |grep c-role|cut -d ’ ' -f1
|| echo ' 'kubectl delete clusterrolebinding
kubectl get clusterrolebinding |grep c-role|cut -d ’ ' -f1
|| echo ' '