Thanks to
Sunday, 9. February 2020
djanog settings

You may see this message if you have DEBUG = True in your Django settings file and you haven't configured any URLs. startproject todo

python runserver localhost:8000

$$ If you plan to use a database, edit the DATABASES setting in todo/
python startapp todoapp

$$ syncdb and flush are other 2 parameters accepted by

... Link (1 comment) ... Comment

Saturday, 8. February 2020
clear tmp folder

Here is following commands to clear unwanted stuff from the /tmp partition on the server?

tmpwatch –mtime –all 48 /tmp

The above command will remove all files and folders from the /tmp which have not been accessed in the last couple of days (24×2=48). You can modify the number of hours as required.

... Link (2 comments) ... Comment

change your server time to IST

If you need to change your server clock to another timezone for e.g. (Indian Standard Time), you can do so by modifying the /etc/localtime file:

mv /etc/localtime /etc/localtime.bak

ln -s /usr/share/zoneinfo/Asia/Calcutta /etc/localtime

... Link (1 comment) ... Comment

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 ##

... Link (1 comment) ... 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
@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 (1 comment) ... 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 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 (1 comment) ... 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 (1 comment) ... 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 (1 comment) ... 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 (2 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 (1 comment) ... Comment

Online for 6387 days
Last modified: 2/19/20 1:54 PM
Youre not logged in ... Login
... Home
... Tags

February 2020
Recent updates
About the sites Thanks for
sharing click here to see this site
by JamesWalk (2/19/20 1:54 PM)
comment to the blogs Hello
onpagetricks [url][/url]
by JamesWalk (2/19/20 12:48 PM)
log mysql output tee output.txt
show global variables; show engine innodb status\G show full processlist;...
by shantanuo (2/19/20 12:33 PM)
Super interesting! Will definitely
be checking out other pages on this website. Landscaping Frankston
by fencingtoowoomba (2/19/20 12:19 PM)
pinoy network replay pinoy network
replay. Thanks and Thumbs Up for great work
by PinoyTvTambayanReplay (2/19/20 11:53 AM)
Perks of Watching Online Movies
Perks Of Watching Online Movies. Thanks For this beautiful Post
by PinoyTvTambayanReplay (2/19/20 11:51 AM)
The Famous Actors of Philipines
Famous Serial Actors of Philipines. Thanks For the Post Admin......
by PinoyTvTambayanReplay (2/19/20 11:49 AM)
thefitnessidea Army Training Video
by lifestyle (2/19/20 5:23 AM)
stucco contractors Thank you so
much Antville for sharing this page. We stucco contractors are...
by joshuagibbs422 (2/18/20 11:11 AM)
Thank you a bunch for
sharing this code. Hope I can apply it to...
by casseverhart (2/18/20 11:06 AM) By activating NBC sports
activate, which can be accessible through a person as...
by annie liscon (2/18/20 8:04 AM)
Thank you! Check out our
site here: House painters Tumwater
by LP3 (2/17/20 11:07 PM)
SLC Tree Pros Check us
out for the best tree service Salt Lake City!
by natechas (2/17/20 10:00 PM)
Good steps here for
that MySQL. panel installation
by casseverhart (2/17/20 12:42 PM)
crackedera A malware refers to
a virus that can harm your computer. These malware are...
by crackedera (2/17/20 9:09 AM)
Nice immigration solicitors Dublin accounting
services Kent London music producer
by John1999 (2/16/20 4:09 PM)
Good Job roofer Newcastle chimney
sweep Reading real estate Budapest
by John1999 (2/16/20 4:07 PM)
Great writing pool leak detection
Los Angeles energy healing meditation London
by John1999 (2/16/20 4:01 PM)
Nice tree surgeon Edinburgh man
with a van Telford man with a van Oxford
by John1999 (2/16/20 3:57 PM)
access AWS API gateway using
python Amazon API gateway allows us to host server-less API's...
by shantanuo (2/16/20 11:41 AM)
Using boto In the bad
old days, the glacier class used to have different layers....
by shantanuo (2/15/20 12:28 PM)
Great solution for that
issues... Tree Solutions Waterford Lakes
by casseverhart13 (2/14/20 12:24 PM)
Mobile Dog Grooming Spectacular post!
Check us out for dog hair cutting in Utah County!
by natechas (2/14/20 1:23 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 3:49 PM)
Steps to be used for
generating AWS API gateway a) Method Execution - Get Method...
by shantanuo (2/13/20 3:30 PM)

RSS feed

Made with Antville
Helma Object Publisher