Thanks to antville.org
Wednesday, 6. September 2017
percona utility

We can re-create mysql users using the percona utility.

wget percona.com/get/pt-show-grants

chmod 777 pt-show-grants

./pt-show-grants

... Link (0 comments) ... Comment


Thursday, 6. July 2017
mail merge separate file per record

Microsoft Word has an excellent feature called Mail-Merge. If the query returns more than one record (say 4 for the sake of the example), then the resulting Word file has multiple copies of the document merged together in one file. It is possible to have Word create a seperate file for each record using this add-on.

www.gmayor.com

... Link (0 comments) ... Comment


Sunday, 28. May 2017
find dead processes

The 8th column of ps aux command will list the status of the process.

ps aux | awk '{if ($8 ~ "D") print $0}'

Here is a list of the various process statuses and what they mean:

D – Uninterruptible sleep (usually a critical system process, a process that cannot be killed without rebooting)
R – Running
S – Interruptible sleep (waiting for an event to complete)
T – Stopped
Z – Defunct (“zombie”) process

... Link (0 comments) ... Comment


Wednesday, 10. May 2017
Amazon Web Services

Here are some of the important Amazon products to use.

cloudTrail + cloudWatch + ES
Image Recognition
DMS
Route53
EC2
Redshift + ElasticCache + Spectrum
S3 + Glacier / Athena
Lambda + API Gateway + dynamoDB

... Link (0 comments) ... Comment


Saturday, 14. January 2017
Self signed security certificate

www.thegeekstuff.com

openssl genrsa -out 34.195.94.88.key 1024

openssl req -new -key 34.195.94.88.key -out 34.195.94.88.csr

echo subjectAltName = IP:34.197.71.213 > extfile.cnf

openssl x509 -extfile extfile.cnf -req -days 365 -in 34.197.71.213.csr -signkey 34.197.71.213.key -out 34.197.71.213.crt

/srv/docker/gitlab/gitlab/certs

-rw-r--r-- 1 root root 749 Jan 14 11:05 34.195.94.88.crt
-rw-r--r-- 1 root root 599 Jan 14 11:05 34.195.94.88.csr
-rw-r--r-- 1 root root 887 Jan 14 11:04 34.195.94.88.key

... Link (0 comments) ... Comment


Wednesday, 23. November 2016
docker and aws

Before starting docker daemon, add the aws credentials.

vi /etc/init/docker.override

env AWS_ACCESS_KEY_ID=
env AWS_SECRET_ACCESS_KEY=

... Link (0 comments) ... Comment


Sunday, 30. October 2016
Turn off Windows Updates in Windows 10

There is no option to turn off Windows Updates in Windows 10, as it used to be with earlier versions of Windows. Here is work-around...
Control Panel > Administrative Tools, you can access Services. In the Services window, scroll down to Windows Update and turn off the process by right-clicking on the process, click on Properties and select Disabled.

... Link (0 comments) ... Comment


Saturday, 9. July 2016
RSS extension for chrome

RSS Subscription Extension (by Google) is a must have chrome extension if you read RSS feeds.
When you click on RSS feed icon, you will get only "Bloglines" and "My Yahoo" sites. But you can add more sites if you click on "Mange" option. For e.g. add feedspot with the following URL...

www.feedspot.com

... Link (0 comments) ... Comment


Monday, 23. May 2016
use putty for presentation

Config - Change settings... - Window - Colours - Use system colours
Config - Change settings... - Window - Appearance - Change... - 12 point

... Link (0 comments) ... Comment


Saturday, 21. May 2016
start with docker

create a docker file

vi dockerfile

COPY php.ini /usr/local/etc/php/

FROM php:5.6-apache
COPY adminer.php /var/www/html/
RUN chmod -R 777 /var/www/html/

build an image

docker build -t my-php-app .

run an image

docker run -d -p 80:80 --name myapp my-php-app

docker run -it --rm --name my-running-app my-php-app

... Link (0 comments) ... Comment


Online for 5752 days
Last modified: 5/20/18 3:42 PM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
May 2018
SunMonTueWedThuFriSat
12345
6789101112
13141516171819
20212223242526
2728293031
April
Recent updates
backup mysql users It is
easy to backup mysql users - wget percona.com/get/pt-show-grants; perl pt-show-grants
by shantanuo (5/20/18 3:42 PM)
About python 1 everything is
an object (class instances) 2 methods depends upon class of...
by shantanuo (5/20/18 2:52 PM)
mysql and shell command date
-d"-1 day ago" +'%b%d' equals to mysql -Bse"select date_format(date(date_add(now() ,...
by shantanuo (5/16/18 7:47 AM)
Preserving comments in Stored Procedure
You can write multi line comments in a stored procedure...
by shantanuo (5/12/18 12:56 PM)
Custom slack command Here are
5 steps to add any API to your slack channel....
by shantanuo (4/25/18 6:59 AM)
stack bookmarklet This bookmarklet will
help to quickly access stack pages linking to current page...
by shantanuo (1/10/18 10:47 AM)
Manage S3 like rsync ####
create bucket aws s3 mb s3://johntest123/ #### rsync all files...
by shantanuo (12/22/17 12:04 PM)
apache docker container issues If
apache docker container does not start then make these changes......
by shantanuo (11/10/17 3:00 PM)
Install aws client on centos
If pip is not installed, then the following command will...
by shantanuo (10/26/17 9:51 AM)
Managing Amazon keys Use this
command to convert private key to public key. ssh-keygen -y...
by shantanuo (10/9/17 7:04 AM)
percona utility We can re-create
mysql users using the percona utility. wget percona.com/get/pt-show-grants chmod 777...
by shantanuo (9/6/17 8:22 AM)
mail merge separate file per
record Microsoft Word has an excellent feature called Mail-Merge. If...
by shantanuo (7/6/17 12:09 PM)
find dead processes The 8th
column of ps aux command will list the status of...
by shantanuo (5/28/17 7:39 AM)
Amazon Web Services Here are
some of the important Amazon products to use. cloudTrail...
by shantanuo (5/10/17 11:35 AM)
Self signed security certificate http://www.thegeekstuff.com/2009/07/linux-apache-mod-ssl-generate-key-csr-crt-file/
openssl genrsa -out 34.195.94.88.key 1024 openssl req -new -key 34.195.94.88.key...
by shantanuo (1/16/17 8:02 AM)
docker and aws Before starting
docker daemon, add the aws credentials. vi /etc/init/docker.override env AWS_ACCESS_KEY_ID=...
by shantanuo (11/23/16 3:01 PM)
Turn off Windows Updates in
Windows 10 There is no option to turn off Windows...
by shantanuo (10/30/16 2:43 PM)
RSS extension for chrome RSS
Subscription Extension (by Google) is a must have chrome extension...
by shantanuo (7/9/16 7:28 AM)
use putty for presentation Config
- Change settings... - Window - Colours - Use system...
by shantanuo (5/23/16 1:26 PM)
docker command examples # options
for running docker docker run -d --name abcd2 -p 23:23...
by shantanuo (5/21/16 11:04 AM)
start with docker # create
a docker file vi dockerfile COPY php.ini /usr/local/etc/php/ FROM php:5.6-apache...
by shantanuo (5/21/16 8:10 AM)
Start 2 containers at once
Here is how you can start neo4j as well as...
by shantanuo (5/21/16 7:29 AM)
linguistics using Python These are
the 4 libraries apart from standard library nltk are useful...
by shantanuo (2/9/16 4:46 PM)
Aurora Amazon rates The cost
of Aurora hosting per hour. db.r3.large $0.290 (0.24 mysql) db.r3.xlarge...
by shantanuo (1/26/16 3:06 PM)

RSS feed

Made with Antville
Helma Object Publisher