Minimize the download size for updates.

2010-02-10 1 min read Fedora Linux

Fedora has rolled out presto repositories. What this means to the users is that the download size for the updates would be greatly reduced. To use the feature, first install the yum plugin:

sudo yum install yum-presto.noarch

Presto uses delta rpms. These delta rpms are quite small in size (eg few kbs instead of 15 MB for firefox 3.5). These delta rpms are used to re-create the original rpm and this is completely transparent to the end user. So, next time when you update with the plugin installed you will see the difference in the download size.

Top 10 most ridiculous Windows Vista error messages – priceless though!!!

2010-02-10 0 min read Linux

$\"Windows$: Image by Stijn Vogels via Flickr

Windows Vista is always in the news on the blogosphere about how effective it performs. No matter what version of Vista you may be running, it’s

possible that you may have already seen these error messages more than once and may well probably be fed up with them!

Openoffice.org and/or Excel useful tips.

2010-02-10 2 min read Fedora Learning Linux

Today I was working on Excel sheets and had to do quite a lot of manipulations. Here are some of those:

Find the value of the cell whose number is stored in another cell.

You can use the indirect function.

Here is example:

That’s cool and easy.

Indirect reference with some constant values.

You can add constant and cell id with ”&”

Annotating the photograph with comments.

2010-02-10 1 min read Fedora Linux Photo

There is a nice Linux command called convert. This command can be used in various ways to do image manipulation. One of them is to embark your image with some text. Here is how to do it.

**echo ”Annotating the image ”$2” with $1”
convert -font Verdana -pointsize 40 -fill red -draw ”text 100,100 ”$1”” ”$2” ”$2”
**

It will be good idea to save this as ”annotate” as we will use this later too.

Script to Watch for Ubuntu 9.10 Launch – can be used in other scenarios.

2010-02-10 1 min read Linux

I know ubuntu is out already but this is something that you can use to monitor a webpage.

This script will run check a for the Ubuntu 9.10 launch once every 5 mins and let you know when it’s available:

while [ 1 ]; do if [ -z \"`curl -I \"http://cdimage.ubuntu.com/releases/9.10/release/\"|grep \"404\"`\" ]; then kdialog --msgbox \"9.10 Released\"; exit; fi; sleep 300;  done

bash script with sql to get the number of records from multiple tables.

2010-02-10 1 min read Bash Database Learning Linux Solaris

Here is the bash script:

#!/bin/sh
names[1]=errorlog
names[2]=amit1log
names[3]=amit2log
names[4]=amit3log
names[5]=amit4log
j=1
echo $1
for i in $( sqlplus amit/passwd@tns @get_count.sql |sed -n ’/COUNT/,/Disconnected/p’|sed ’/COUNT/ d’|sed ’/—/ d’|sed ’/Disconnected/ d’|tr ’n’ ’ ’ )
do
temp=${names[$j]}
let count=30-${#temp}
for ((I=1; I <= $count ; I++))
do
printf ” ”
done
echo ”${names[$j]} : $i”
# echo $j
let j=j+1
done
echo
echo

and the required sql script:

select count() from errorlog;
select count() from amit1log;
select count() from amit2log;
select count() from amit3log;
select count(*) from amit4log;
quit;
Continue reading

How To Build A Self-hosted WordPress Blog For Free

2010-02-04 1 min read Linux

A blog is a layman-friendly variation of a website, and having a blog is one of the many ways to state your presence in the virtual world. While there are many hassle-free blog services out there that will take care of everything except automatically blog for you – like <a href="http://www.makeuseof.com/tags/blogger">Blogger and <a href="http://www.makeuseof.com/tags/wordpress">WordPress, nothing can beat a self-hosted blog in the terms of customization and self pride.

The problem is, the process of building your own self-hosted blog is (almost always) not free and is considered complicated. So most newbies will choose the easier path and never give themselves a chance to experiment.

Older posts Newer posts