| # Run this query | |
| SELECT pg_terminate_backend(pg_stat_activity.pid) | |
| FROM pg_stat_activity | |
| WHERE pg_stat_activity.datname = 'target_db' | |
| AND pid <> pg_backend_pid(); | |
| DROP DATABASE target_db; |
| java -Djavax.net.ssl.trustStore=frontend_epsKeystore_fugazi.jks -jar java-keystore-test-0.0.1.jar https://ecinventqark1v.wsgc.com:49184/loyalty/v1/loyaltyAccounts?phone=19164754536 | |
| EPS: /apps/tomcat/conf/frontend_epsKeystore_fugazi.jks | |
| Loyalty: /apps/tomcat/conf/frontend_keystore.jks | |
| password | |
| ecinvent-qa-rk1v.wsgc.com |
| kubectl get pods --all-namespaces -o json | jq -r '.items[] | select(.status.qosClass == "BestEffort") ' | jq -r '.spec.containers[].name' |
| # Download ca from | |
| openssl x509 -in ~/Downloads/COMODORSAAddTrustCA.crt -inform DER -out hostname.crt.pem -outform PE | |
| openssl x509 -inform DER -in comodo.crt -out comodo.pem -text |
| wrk -c 20 -t 4 -d 600s https://acob-service-staging.avenuecode.com/api/v1/thirdpartyservices |
| # Base64 | |
| :.!base64 | |
| # Decode | |
| :.!base64 -D | |
| # . = line | |
| # % = file | |
| # Enter mode visual, select and :!base64 |
State, due to a bug Kubernetes lost the state of a persistent volume. The volume existed in AWS, so I've decided to recover the state.
PVC existed but with state Lost:
kubectl -n acdc-legacy get pvc
NAME STATUS VOLUME CAPACITY ACCESSMODES STORAGECLASS AGE
acdclegacy-staging-data-acdclegacy-postgres-0 Lost pvc-dbd2ac08-f32e-11e7-b70d-1212ccc85de2 0 default 10d
| pg_dump -h 54.162.150.192 -d alpha-quester -U aquser -W > alpha.dmp | |
| psql -h 127.0.0.1 -U aquser -W alpha-quester < alpha.dmp |
| # Copy file from pod to my host | |
| kubectl cp kube-system/nginx-ingress-controller-3224139886-92k85:/etc/nginx/nginx.conf nginx.conf |
| from flask import Flask | |
| from flask_sqlalchemy import SQLAlchemy | |
| app = Flask(__name__) | |
| app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://flask:flask@127.0.0.1/flask' | |
| db = SQLAlchemy(app) | |
| class Example(db.Model): | |
| __tablename__ = 'example' |