Setup
First make sure you have signed the Sleutelbeheer docs and that your public key is approved on the production and acceptance servers. Then ask one of the administrators to generate a password for your nltru account, for acceptance and production.
PhpStorm
Production
Add the value TLSv1.2
for enabledTLSProtocols
.
Acceptance
Kubernetes
First use one of the following commands to connect, don't close the terminal. You can then connect to the db.
Production
kubectl -n development-production port-forward mysql-pxc-db-proxysql-0 3300:3306
Acceptance
kubectl -n development-acceptance port-forward mysql-pxc-db-proxysql-0 3301:3306
Next up connect with localhost:3000 (prd) or localhost:3001 (acc) using the password that can be found here:
https://gitlab.true.nl/development/deploy/-/settings/ci_cd (expand variables, e.g. SSL_MYSQL_PASSWORD
).
If you don't have the kubectl config yet, download it from https://k8s.true.nl/, an account can be created by the infra department.
The config should be placed in ~/.kube/config
.
PhpStorm configuration example
Please note that to connect to a different microservice db you'll need to change the user to the name of the microservice. The passwords can be found in the link above.