Thanks to antville.org
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 6.3.4.2 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:
LibreOffice_6.2.0.1_Win_x64.msi

From:

downloadarchive.documentfoundation.org

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
do
echo "time scp /home/backup/mysql/$mydb/ticket.txt.gz 1.2.3.4:/tmp/$mydb.txt.gz "
done << dblist
akolaII
akol
ako
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:

code.google.com

www.red-gate.com

www.devart.com

... 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 "75.142.246.205" |uniq | awk -F. {'print $1"."$2"."$3"/24"'} |uniq

114.80.93/24
119.63.193/24
124.115.0/24
205.234.253/24

... 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.datetime.now() - datetime.timedelta(days = 14)).date()

And this is pandas way of getting the same results:

import pandas as pd
(pd.datetime.today() - 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 get.docker.com -o get-docker.sh && sh get-docker.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 github.com
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
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
August 2020
SunMonTueWedThuFriSat
1
2345678
9101112131415
16171819202122
23242526272829
3031
April
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