ettingshausen’s gists

ettingshausen / convert.sh

Created November 27, 2019 12:21

How to convert mov to mp4 on macOS

	brew install ffmpeg
	ffmpeg -i /path/to/input/file /path/to/output.mp4

ettingshausen / Dockerfile

Last active September 19, 2019 13:40

npc proxy client Docker image

	FROM alpine:3.8
	MAINTAINER ettingshausen <[email protected]>

	WORKDIR /
	ENV NPC_VERSION 0.23.1

	RUN set -x && \
	wget --no-check-certificate https://github.com/cnlh/nps/releases/download/v${NPC_VERSION}/linux_amd64_client.tar.gz && \
	mkdir \npc && \
	mv linux_amd64_client* /npc && \

ettingshausen / Office_kms

Created January 3, 2019 15:26 — forked from CHEF-KOCH/KMS_office.cmd

KMS server Windows

	cd\Program Files\Microsoft Office\Office16


	cd\Program Files (x86)\Microsoft Office\Office16

	cscript OSPP.VBS /sethst:kms.digiboy.ir
	cscript OSPP.VBS /actcscript OSPP.VBS /dstatus


	slmgr.vbs /ckms

ettingshausen / ssr.sh

Last active November 12, 2021 12:58

ssr docker install script

	# pull docker image
	docker pull breakwa11/shadowsocksr
	# run
	docker run -d --name ssr0 -p 1202:51348 -e METHOD="aes-256-cfb" -e PROTOCOL="auth_sha1_v4" -e OBFS="http_simple" -e PASSWORD="HelloWorld" breakwa11/shadowsocksr

	#ss
	docker pull mritd/shadowsocks

	docker run -d --name ss -p 6443:6443 mritd/shadowsocks -s "-s 0.0.0.0 -p 6443 -m chacha20 -k password --fast-open"

ettingshausen / OpenCmdHere.reg

Created November 20, 2018 11:49

add cmd in right click menu

	Windows Registry Editor Version 5.00

	[HKEY_CLASSES_ROOT\Directory\shell\OpenCmdHere]
	@="在此处打开命令提示符"
	"Icon"="cmd.exe"

	[HKEY_CLASSES_ROOT\Directory\shell\OpenCmdHere\command]
	@="cmd.exe /s /k pushd "%V""

	[HKEY_CLASSES_ROOT\Directory\Background\shell\OpenCmdHere]

ettingshausen / Dockerfile

Created September 6, 2018 03:30

Docker say Hello

	FROM alpine
	ENV user=ettingshausen
	ENTRYPOINT [ "sh", "-c", "echo Hello $user !" ]

	# build
	# docker build -t docker-greet .

	# run without env
	# docker run -it --rm docker-greet

ettingshausen / export_import_docker_image.sh

Last active September 5, 2018 05:33

export and import docker image

	#export image
	docker save raymondwong/idcardocr -o idcardocr.tar

	#import image
	docker load -i idcardocr.tar

ettingshausen / resize.cmd

Last active July 6, 2018 07:51 — forked from Starefossen/gist:319f36ff30694a775806

Resize VirtualBox .vmdk disk

	:: Clone the .vmdk image to a .vdi.
	vboxmanage clonehd "virtualdisk.vmdk" "new-virtualdisk.vdi" --format vdi
	:: Resize the new .vdi image (30720 == 30 GB).
	vboxmanage modifyhd "new-virtualdisk.vdi" --resize 30720
	:: Optional; switch back to a .vmdk.
	VBoxManage clonehd "cloned.vdi" "resized.vmdk" --format vmdk

ettingshausen / linked_server.sql

Created April 12, 2018 08:53

How To Create a SQL Server Linked Server

	EXEC sp_addlinkedserver
	@server='DBMES', --链接服务器别名
	@srvproduct='', -- 如果是SQL Server 可以不用指定@srvproduct
	@provider='SQLOLEDB',
	@datasrc='172.16.0.91' --要访问的的数据库所在的服务器的ip
	GO
	EXEC sp_addlinkedsrvlogin
	@rmtsrvname = 'DBMES', --链接服务器别名
	@useself = 'false', --是否使用当前账号登录
	@locallogin = NULL,

ettingshausen / sql_execute.cmd

Last active May 19, 2022 18:04

execute sql script via sqlcmd

	:: Name: sql_execute.cmd
	:: Purpose: execute script.sql via sqlcmd
	:: Author: ettingshausen
	:: Revision: 2018/3/1 - initial version
	::

	@ECHO OFF
	SETLOCAL ENABLEEXTENSIONS
	SET parent=%~dp0
	SET interactive=0

ettingshausen ettingshausen