xsqian’s gists

xsqian / sed for file manipulation

Created September 11, 2020 19:58

delete a line from a file with a pattern

sed -i '' '/charset=latin1/d' ./not-appliable.sql

xsqian / gist:d26eeda3da9ce2035010e6ad83a00346

Last active February 26, 2021 18:43

get the kubernetes secret and print on terminal

	kubectl -n kube-system describe secret $(kubectl -n kube-system get secret \| grep admin-user \| awk '{print $1}')

	export CLUSTER_IP=$(kubectl get services/webapp1-clusterip-svc -o go-template='{{(index .spec.clusterIP)}}')
	echo CLUSTER_IP=$CLUSTER_IP
	curl $CLUSTER_IP:80

	sed -i 's/HOSTIP/172.17.0.16/g' externalip.yaml

	export LoadBalancerIP=$(kubectl get services/webapp1-loadbalancer-svc -o go-template='{{(index .status.loadBalancer.ingress 0).ip}}')
	echo LoadBalancerIP=$LoadBalancerIP

xsqian / change a kubernetes object on the fly

Created February 26, 2021 18:40

	kubectl -n kube-system get deployment coredns -o yaml \| \
	sed 's/allowPrivilegeEscalation: false/allowPrivilegeEscalation: true/g' \| \
	kubectl apply -f -

xsqian / kompose-convert-docker-compose-to-kubernetes.sh

Created February 27, 2021 00:03

kompose convert docker-compose to kubernetes

	1 launch.sh
	2 curl -L https://github.com/kubernetes/kompose/releases/download/v1.9.0/kompose-linux-amd64 -o /usr/bin/kompose && chmod +x /usr/bin/kompose
	3 kompose up
	4 kubectl get deployment,svc,pods,pvc
	5 kompose convert
	6 ls
	7 kubectl apply -f frontend-service.yaml,redis-master-service.yaml,redis-slave-service.yaml,frontend-deployment.yaml,redis-master-deployment.yaml,redis-slave-deployment.yaml
	8 kompose --provider openshift convert
	9 kompose convert -j
	10 ls -l

xsqian / sed_snippets.sh

Created May 5, 2021 16:35 — forked from lamb-mei/sed_snippets.sh

sed examples

	##FILE SPACING:

	# double space a file
	sed G

	# double space a file which already has blank lines in it. Output file
	# should contain no more than one blank line between lines of text.
	sed '/^$/d;G'

	# triple space a file

xsqian / grafana-api-to-export-import-datasource.sh

Created May 7, 2021 05:01

how to export and import datasource from Grafana using Grafana API

	mkdir -p data_sources && curl -s "http://localhost:3000/api/datasources" -u admin:admin\|jq -c -M '.[]'\|split -l 1 - data_sources/

	for i in data_sources/*; do \
	curl -X "POST" "http://localhost:3000/api/datasources" \
	-H "Content-Type: application/json" \
	--user admin:admin \
	--data-binary @$i
	done

xsqian / git-pre-commit-for-yapf

Created May 20, 2021 04:07

create a pre-commit yapf

	cd .git/hooks
	curl -o pre-commit.sh https://raw.githubusercontent.com/google/yapf/main/plugins/pre-commit.sh
	chmod a+x pre-commit.sh

xsqian / docker-compose-on-linux

Created August 4, 2021 00:03

Install Docker and Docker Compose on linux (Ubuntu)

xsqian / docker-compose-on-redhat-kafka.sh

Last active March 10, 2022 23:20

Install Docker, Docker Compose and Kafka on RedHat

	sudo dnf config-manager --add-repo=https://download.docker.com/linux/centos/docker-ce.repo

	sudo dnf repolist -v

	dnf list docker-ce --showduplicates \| sort -r

	sudo dnf install --nobest docker-ce

	sudo systemctl disable firewalld

xsqian / docker-default-data-directory.sh

Created August 11, 2021 19:27

config docker default data directory to another location than /var/lib

	sudo service docker stop

	sudo vi /etc/docker/daemon.json

	{
	"data-root": "/path/to/your/docker"
	}

	sudo service docker start