Aman Khandelwal khandelwal-aman

khandelwal-aman / bot.js

Created March 4, 2020 11:12

	const { ActivityHandler } = require('botbuilder');
	var sql = require("mssql");
	var config = {user: 'Bi_Auto',
	password: '',
	server: '',
	database: 'edw_prod',
	encrypt: true
	};

	class EchoBot extends ActivityHandler {

khandelwal-aman / Mysql_restart_change_config.md

Last active January 24, 2020 08:58

MySQL Restart

command to restart MySQL

sudo /etc/init.d/mysql restart

cd /etc/mysql cd mysql.conf.d/

khandelwal-aman / ubuntu_mssql_driver_install_steps.txt

Last active January 22, 2020 10:18

Commands to enable mssql on Ubuntu



	sudo apt-get install unixodbc

	curl https://packages.microsoft.com/config/ubuntu/18.10/prod.list > /etc/apt/sources.list.d/mssql-release.list

	curl https://packages.microsoft.com/keys/microsoft.asc \| apt-key add -

	sudo ACCEPT_EULA=Y apt-get install msodbcsql17

khandelwal-aman / python_cron.sh

Created January 21, 2020 09:40

Cron file example for python script alongwith crontab entry

	#!/bin/bash

	cd /home/administrator/projects/ctim
	#source bin/activate
	/home/administrator/projects/ctim/bin/python program.py


	#Crontab command
	#0 13 * * * /home/administrator/projects/ctim/run.sh >> /home/administrator/projects/ctim/py.log

khandelwal-aman / swap_size_change.txt

Last active January 21, 2020 09:22

Swap memory size change in ubuntu

	1. Turn off all swap processes
	sudo swapoff -a

	2. Resize the swap
	sudo dd if=/dev/zero of=/swapfile bs=1G count=8

	if = input file
	of = output file
	bs = block size
	count = multiplier of blocks

khandelwal-aman / charts_code.txt

Created January 10, 2020 07:12

	https://phpchart.com/examples/complete-phpchart-examples/#!prettyPhoto

	https://www.rgraph.net/demos/bar-segmented.html

khandelwal-aman / docker_cleaner.sh

Created January 9, 2020 11:48

	#removes all exited docker containers and clears memory

	docker rm -v $(docker ps -a -q -f status=exited)

khandelwal-aman / docker_debug.txt

Created January 9, 2020 08:50

	Was getting:
	docker: Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?.

	I ran sudo dockerd --debug and got:
	failed to start daemon: mkdir /var/lib/docker/runtimes: not a directory

	Solution:

	sudo rm /var/lib/docker/runtimes

khandelwal-aman / jsonstream.py

Created November 6, 2019 07:09

json stream reader to read one row from json stream at a time. Useful for large json data