PostgreSQL converts all column and table names to lowercase in the SQL query. If the column or table name contains uppercase letters, we need to use double quotes to be able to reference them. When we get the error message ERROR: column “username” does not exist select * from public.”AspNetUsers” where UserName = ‘… ^ […]
Install postgresql The postgresql package contains the PostgreSQL utilities: psql, pg_dump On macOS Install pgAdmin pgAdmin is a browser based database management tool for PosgtreSQL databases. Download Download the installer from https://www.pgadmin.org/download/ Install On macOS Double click the downloaded file Accept the license agreement Drag the application into the Applications folder Start pgAdmin On macOS […]
During the test of a Chef recipe that contains a template we may encounter the error message syntax error, unexpected tLABEL MY_KEY: MY_VALUE Make sure there is no white space between the keyword variables and the opening parenthesis in the template definition:
Docker images are stored on the host to launch as fast as possible. The drawback is, Docker can fill the hard drive with unused images. A recent possible bug in Docker caused the accumulation of unused, unreferenced images on the host. To delete all Docker containers and images, use these commands in the terminal Get […]
We create a new AWS Application Load Balancer and get this error message when the second listener is created Error: Error creating LB Listener: ValidationError: ‘arn:aws:elasticloadbalancing:….’ must be in ARN format make sure the region and AWS profile are correctly set for the new listener config.
When we test a Chef cookbook in Chef Test Kitchen and get the error message TypeError ——— no implicit conversion of String into Integer Check if all attribute references have the “node” keyword in front of them.
In the previous post, Learn Kubernetes part 2 – NGINX Ingress Controller, we have deployed a web application and exposed it via the kubernetes/ingress-nginx ingress controller. In this exercise we will use Traefik, another popular proxy server. Traefik is widely used for multiple reasons: it is easier to configure, can automatically generate and renew SSL […]
Large organizations need to control the incoming traffic to the Kubernetes cluster. The most secure way is to use an ingress controller and create an ingress to channel all incoming traffic to the cluster. In Learn Kubernetes part 1 – Web application in a Kubernetes cluster we have created a simple web application pod and […]
This is the official Kubernetes dashboard, and for security reasons currently it is not recommended to use, but we can still use it in our local cluster to inspect the resources. The latest installation information is at https://kubernetes.io/docs/tasks/access-application-cluster/web-ui-dashboard/ Launch the Kubernetes Dashboard To launch the Kubernetes Dashboard in your cluster execute the command Create a […]
Use the ingress-nginx Kubernetes plugin to troubleshoot the Kubernetes Ingress-Nginx. Install krew, the Kubernetes plugin manager. See https://github.com/kubernetes-sigs/krew See Kubernetes Ingress-Nginx Troubleshooting made Easy with kubectl plugins Verify the cluster you are connected to To switch to another cluster Get the address of the cluster Get the list of pods Forward a port to the […]