Thanks to antville.org
Saturday, 8. February 2020
Transfer root emails to another email address

If you have root access to the server then open the file /etc/aliases in your favorite editor. Look for the section Person who should get root mail and make the change as required.

vim /etc/aliases

Person who should get root’s mail  ##
root:   info@unixserveradmin.com

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


special strings in cron

Instead of the first five fields, you can use any one of eight special strings. It will not just save your time but it will improve readability.

Special string    Meaning
@reboot ——> Run once, at startup.
@yearly ——> Run once a year, “0 0 1 1 *”.
@annually –> (same as @yearly)
@monthly —> Run once a month, “0 0 1 * *”.
@weekly —–> Run once a week, “0 0 * * 0″.
@daily ——–> Run once a day, “0 0 * * *”.
@midnight –> (same as @daily)
@hourly —–> Run once an hour, “0 * * * *”.

For e.g. run ntpdate every hour:
@hourly /path/to/ntpdatevim /etc/ssh/sshd_config

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


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:

https://downloadarchive.documentfoundation.org/libreoffice/old/6.2.0.1/win/x86_64/

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:

https://code.google.com/archive/p/phpmydiff/downloads

https://www.red-gate.com/products/mysql/mysql-comparison-bundle/

https://www.devart.com/dbforge/mysql/schemacompare/download.html

... 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 https://github.com/sebastientaggart/docker-cloudmapper.git
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 http://localhost:8000 and enjoy!

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


Online for 6873 days
Last modified: 5/7/21, 5:46 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
June 2021
SunMonTueWedThuFriSat
12345
6789101112
13141516171819
20212223242526
27282930
December
Recent updates
Preserve seeds 6 types of
seeds to be preserved for next season. 1) laal Mula...
by shantanuo (5/7/21, 5:46 AM)
Why do I care for
Linux? I don't care that much for other software. Linux...
by shantanuo (12/17/20, 9:27 AM)
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 serverless 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 percona 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)

RSS feed

Made with Antville
Helma Object Publisher