Create a secure tunnelled connection for access to a remote MySQL database.

For example, connect with MySQL Workbench to root@127.0.0.1:13306.

newly downloaded videos

random

This command assumes you've already downloaded some YouTube .mp4 or .flv video files via other means. Requires 'shuf', or your own stdin shuffler.

This will print out the files and directories in a gzipped tarball.

find all computer connected to my host through TCP connection

With this you can unlock your KDE4 session via SSH, via mobile phone SSH or e. g. scheduled task in crontab (without asking password). Useful when you need to grant somebody access to your locked profile remotely.

Create an alias (e. g. as "unlock") and use with remote KDE4 lock.

This works only on KDE4 boxes because KDE 3 is using utility with another name.

Tested on Kubuntu 8.10.

Will create a graph of the results for "x bottles of beer on the wall".

Requires Gnuplot.

Inspired by an xkcd comic: http://xkcd.com/715/

For sample output see: http://tr.im/xbottlesofbeer

forces user to rw, group to r, and other to no access.

files will not be marked executable.

directories will be executable for users and groups only.

k add principle

This will list all symlinks that are directories under the current directory. This will help you distinguish them from regular files.

There's too many options to number,

My curiosity has forced me to make it using only sed.

Maybe useful... or not... :-S

Get Google Reader unread count from the command line.

You'll have to define your auth token with $auth

Or use:

20characters long alpahnumeric "password"

backup your files in tar archive + timestamp of backup

[root@dhcppc1 windows]# cat /var/log/honeylog.log

Connection from 192.168.1.71 port 21 [tcp/ftp] accepted

Connection from 192.168.1.65 port 21 [tcp/ftp] accepted

[root@dhcppc1 windows]# nc 192.168.1.65 21

220 ProFTPD 1.3.3c Server [ProFTPD]

FAILED FTP ATTEMPT - PORT 21

*You can not run it if you have activated the ftp server.

I have a custmer's Geovision DVR installed on a closed proxi (only logme-in reaches it).

I have to check for reliability but logmein hangs and is too slow a process

I made the Geovision software send e-mail every minute to the www.spam.la site.

All this script does is to retrieve the e-mail header from spam.la ( no login!), filtering sender, stopping at the first occurrence of the word "secs" ( the age of the last e-mail ).

The result is the age of the sender's last e-mail, tiny published on top of my screen once a minute.

I can refresh www.spam.la via web browser, but have other things to do.

I use it inside Kalarm ( kde task schedule ) set to 1 minute repeat.

It can be done without kalarm, using Watch outside the script.

Try it out now using my account = geo1 ( change sender by geo1 in this script)

Needs curl , osd-bin

I often find it useful to know what the exit status for a program was. This can be helpful when looking up errors by exit status or when scripting frequent commands.

Taken from http://www.faqs.org/docs/abs/HTML/exit-status.html

Assuming you have zenity installed, and assuming that you keep your backgrounds in ~/backgrounds, then this should work for you! :)