Krishna Sheth ilovechai

## mssql_ssl_conf.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                ilovechai
                / mssql_ssl_conf.md
            
            
              Last active
              January 27, 2022 19:03
            
              
                Configure SSL certificates MS SQL server on Windows Server
              
          
    Enable SSL connection MSSQL


Search Windows Feature in Start
Enable IIS - Followed https://stackoverflow.com/questions/30901434/iis-manager-in-windows-10
Open IIS and create self signed certificate
Open Sql Server Configuration Manager 2016 (apparently this shows the 64bit mssql instance)
Click on MSSQL instance > Properties > Force Encryption to yes > Go to certificate tab > select certificate that was created in IIS
Give full permission to paths mentioned here - https://stackoverflow.com/questions/36817627/ssl-certificate-missing-from-dropdown-in-sql-server-configuration-manager
Restart MSSQL instance in SQL Server Configuration Manager
Run mmc


## gitbot.py
## Install PyGithub
!pip install PyGithub

from github import Github
import os
import sys

docker_image = 'Some docker build image with url'
build_url = os.environ.get('BUILD_URL')
git_commit = os.environ.get('GIT_COMMIT')

## docker.md

      
              1 file
            
          
              141 forks
            
          
              222 comments
            
          
              1183 stars
            
          
                FreddieOliveira
                / docker.md
            
            
              Last active
              June 25, 2024 12:35
            
              
                This tutorial shows how to run docker natively on Android, without VMs and chroot.
              
          
    Docker on Android 🐋📱

Edit 🎉

All packages, except for Tini have been added to termux-root. To install them, simply pkg install root-repo && pkg install docker. This will install the whole docker suite, left only Tini to be compiled manually.

Summary


## get_tds_cert.py
import sys
import pprint
import struct
import socket
import ssl
from time import sleep

# Standard "HELLO" message for TDS
prelogin_msg = bytearray([      0x12, 0x01, 0x00, 0x2f, 0x00, 0x00, 0x01, 0x00, 0x00, 0x00, 0x1a, 0x00, 0x06, 0x01, 0x00, 0x20,
                                0x00, 0x01, 0x02, 0x00, 0x21, 0x00, 0x01, 0x03, 0x00, 0x22, 0x00, 0x04, 0x04, 0x00, 0x26, 0x00,

## github_comment_on_commit.py
// Using the Jenkins Groovy Post build plugin to execute the following after every build
// https://wiki.jenkins-ci.org/display/JENKINS/Groovy+Postbuild+Plugin


// It would be nice not to have to specify these here... the repo name should be available within the hudson
// api somehow, but I didn't know how to get it. The access token should maybe be saved in a config file, and
// read in at runtime?
GITHUB_REPO_NAME = 'myusername/myreponame'
GITHUB_ACCESS_TOKEN = 'my_github_api_v3_access_token'
	## Install PyGithub
	!pip install PyGithub

	from github import Github
	import os
	import sys

	docker_image = 'Some docker build image with url'
	build_url = os.environ.get('BUILD_URL')
	git_commit = os.environ.get('GIT_COMMIT')
	import sys
	import pprint
	import struct
	import socket
	import ssl
	from time import sleep

	# Standard "HELLO" message for TDS
	prelogin_msg = bytearray([ 0x12, 0x01, 0x00, 0x2f, 0x00, 0x00, 0x01, 0x00, 0x00, 0x00, 0x1a, 0x00, 0x06, 0x01, 0x00, 0x20,
	0x00, 0x01, 0x02, 0x00, 0x21, 0x00, 0x01, 0x03, 0x00, 0x22, 0x00, 0x04, 0x04, 0x00, 0x26, 0x00,
	// Using the Jenkins Groovy Post build plugin to execute the following after every build
	// https://wiki.jenkins-ci.org/display/JENKINS/Groovy+Postbuild+Plugin


	// It would be nice not to have to specify these here... the repo name should be available within the hudson
	// api somehow, but I didn't know how to get it. The access token should maybe be saved in a config file, and
	// read in at runtime?
	GITHUB_REPO_NAME = 'myusername/myreponame'
	GITHUB_ACCESS_TOKEN = 'my_github_api_v3_access_token'