Skip to main content


Showing posts from September, 2018

Secure nginx with Let's Encrypt on Ubuntu 18.04

Create Cockroach DB database and user

Cockroach DB useful commands.
Here are some useful cockroach DB commands and steps to create a cockroach DB database and uses of cockroach DB database.
Create CockroachDB database :CREATE DATABASE cockroachdb; Create CockroachDB Database User :CREATE USER cockroachdb WITH PASSWORD 'vishal'; Grant Privileges on CockroachDB Databases :GRANT ALL ON DATABASE cockroachdb TO cockroachuser; GRANT ALL ON TABLE cockroachdb.* TO cockroachuser; Change cockroach db user password :ALTER USER vishal WITH PASSWORD 'newpassword'; Login to kubernetes deploy cockroach :psql 'postgresql://username@ip:26257?sslmode=allow' Import Cockroach db Dump :psql -p 26257 -h host -d database -U vishal < database.sql

Install Helm On Ubuntu

Helm is a tool for managing Kubernetes charts. Charts are packages of pre-configured Kubernetes resources.

Here is the steps to install helm in Ubuntu 16.04 machine.

Download helm : 
$ wget

Untar the package : 
$ tar -xvf helm-v2.11.0-linux-amd64.tar.gz

Find "helm" from the directory and move it to given path.
$ mv linux-amd64/helm /usr/local/bin/helm

Verify helm version : 
$ helm version
Client: &version.Version{SemVer:"v2.11.0", GitCommit:"2e55dbe1fdb5fdb96b75ff144a339489417b146b", GitTreeState:"clean"}