Thanks to
Wednesday, 29. January 2020
LibreOffice version conflict

I am not able to install latest version of Libre office. I get an error message for file LibreOffice_6.3.4_Win_x86.msi

LibreOffice can not be installed on this Windows version. Windows 7 SP1 or newer is required.

The fix is easy. Download earlier version for e.g. 6.2 version file:


This site is very slow and may take 10 or 20 times more time to download older version compared to the latest one!

If I try the 64 bit version file LibreOffice_6.3.4_Win_x64.msi then I get the processor error like this:

This installation package is not supported by this processor type. Contact your product vendor.

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

Sunday, 26. January 2020
while loop

This is a sample shell script while loop

while read mydb
echo "time scp /home/backup/mysql/$mydb/ticket.txt.gz$mydb.txt.gz "
done << dblist

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

compare mysql schema

And here is poor man's schema compare using good old diff command...

mysqldump nasik1 --no-data > nasik1.sql

mysqldump -h1.2.3.4 murtizapur --no-data > murtizapur.sql

diff murtizapur.sql nasik1.sql --side-by-side --suppress-common-lines | grep -v ENGINE | grep -v BTREE > to_study.txt

Or use one of the packages:

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

Selecting from error log

grep "error" error_log |awk -F[ {'print $4'} \
| sort | sed -e 's/]//g' | grep -v "/var/www/html/" \
| grep -v "/usr/local/src/code" | awk {'print $2'} \
| grep -v "" |uniq | awk -F. {'print $1"."$2"."$3"/24"'} |uniq


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

Rank mysql records using variables

SET @rank = 0, @prev_val = NULL;

SELECT rank, correct FROM (
SELECT @rank := IF(@prev_val=correct,@rank,@rank+1) AS rank,
@prev_val := correct AS correct, uid
FROM quiz_user ORDER BY correct DESC
)as result WHERE uid=xxxxxxxxxxxx

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

Tuesday, 14. January 2020
14 days ago

This is the python way of calculating the date that is 14 days ago.

import datetime
( - datetime.timedelta(days = 14)).date()

And this is pandas way of getting the same results:

import pandas as pd
( - pd.offsets.Day(14)).floor('D')

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

Thursday, 26. December 2019
docker on ARM

Here are 5 commands to run docker on ARM processors:

sudo apt-get update
sudo apt-get upgrade
curl -fsSL -o && sh
sudo usermod -aG docker $USER
sudo docker run --rm -it -p 80:80 jasonrandrews/php-example

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

Tuesday, 24. December 2019
Cloudmapper using docker

A docker wrapper for the Cloudmapper application, used for visualizing AWS infrastructure.

git clone
cd docker-cloudmapper
Edit .env file and add your AWS key, secret, region, and account name.
docker-compose build (go get a cup of coffee)
docker-compose up -d

Go to localhost:8000 and enjoy!

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

Wednesday, 16. October 2019
Weekly Email Notification

enable Weekly Email Notification from the Trusted Advisor.

1) Open the AWS Management Console.
2) Go to the Trusted Advisor service.
3) Select Preferences from the sub-navigation.
4) Enable weekly email notifications.

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

Thursday, 3. October 2019
Change default head rows from 5 to 3

from functools import partialmethod
pd.DataFrame.head = partialmethod(pd.DataFrame.head, n=3)

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

Online for 6553 days
Last modified: 4/12/20 2:01 PM
Youre not logged in ... Login
... Home
... Tags

August 2020
Recent updates
important leafy vegetables 1. Amaranthus
caudatus: rajgira. 2. Amaranthus tricolor: Math.  (Chhoti Chulai- Hindi, Cheera-...
by shantanuo (4/12/20 2:01 PM)
program creek program creek
seems to be a good site for handy references of python...
by shantanuo (4/11/20 11:24 AM)
Standard out to a file
This code will change the standard out to a file...
by shantanuo (4/11/20 11:18 AM)
Create config file for AWS
command line tool While creating amazon config file in a...
by shantanuo (2/20/20 6:00 AM)
setting colors in pandas This
is how to set the colors in pandas mapper =...
by shantanuo (2/20/20 5:53 AM)
log mysql output tee output.txt
show global variables; show engine innodb status\G show full processlist;...
by shantanuo (2/19/20 10:33 AM)
access AWS API gateway using
python Amazon API gateway allows us to host server-less API's...
by shantanuo (2/16/20 9:41 AM)
Using boto In the bad
old days, the glacier class used to have different layers....
by shantanuo (2/15/20 10:28 AM)
backup mysql users  3
steps to install perconal utility... yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL wget...
by shantanuo (2/13/20 1:49 PM)
Steps to be used for
generating AWS API gateway a) Method Execution - Get Method...
by shantanuo (2/13/20 1:30 PM)
apply colors to pandas Here
is how to change the color of negative values to...
by shantanuo (2/12/20 8:57 AM)
Holidays in India These are
the common holidays celebrated in India (Mumbai) during 2016 -...
by shantanuo (2/11/20 1:53 PM)
change log file size in
MySQL Here are the steps to be followed while changing...
by shantanuo (2/11/20 10:38 AM)
MySQL common error messages 1146
Table does not exist 1054 column does not exist 1062...
by shantanuo (2/11/20 10:13 AM)
ipython parallel demo First start
ipython in cluster mode ipcluster start -n 4 from IPython.parallel...
by shantanuo (2/9/20 9:02 AM)
djanog settings You may see
this message if you have DEBUG = True in your...
by shantanuo (2/9/20 4:07 AM)
clear tmp folder Here is
following commands to clear unwanted stuff from the /tmp partition...
by shantanuo (2/8/20 2:41 PM)
change your server time to
IST If you need to change your server clock to...
by shantanuo (2/8/20 2:39 PM)
Transfer root emails to another
email address If you have root access to the server...
by shantanuo (2/8/20 2:32 PM)
special strings in cron Instead
of the first five fields, you can use any one...
by shantanuo (2/8/20 2:30 PM)
LibreOffice version conflict I am
not able to install latest version of Libre office. I...
by shantanuo (1/29/20 9:15 AM)
while loop This is
a sample shell script while loop while read mydb do echo...
by shantanuo (1/26/20 12:24 PM)
compare mysql schema And here
is poor man's schema compare using good old diff command......
by shantanuo (1/26/20 11:49 AM)
Selecting from error log grep
"error" error_log |awk -F[ {'print $4'} \ | sort |...
by shantanuo (1/26/20 10:40 AM)
Rank mysql records using variables
SET @rank = 0, @prev_val = NULL; SELECT rank, correct...
by shantanuo (1/26/20 9:45 AM)

RSS feed

Made with Antville
Helma Object Publisher