Download stuff from Safari

For Quicktime movies and MP3 files, open up the Activity Window and locate the file. It should be a relatively large file with something like a .mov, .mpg or .mp3 file extension. Once you have found it, simply hold Option and double-click on it. Alternatively, pressing Option-Return will download whatever item is selected in the list.

For flash videos, you will want the .flv file. It’s not always obvious which file this is. It should be the largest file on the page, and may still be loading. For YouTube videos, it is called get_video and doesn’t have the .flv extension. Double-clicking this file will start it downloading. If the file doesn’t have the .flv extension, you will have to add it on after the download has finished. To watch these movies you will need either the Perian Quicktime plugin or a player such as VLC.

Linux User’s Guide to Mac: Terminal

Few things in Unix match the importance of the terminal emulator.  Having a nice GUI is fine, but nothing beats the command line, which some have said is the “front line” of computing. As an official member of the Brotherhood of the Commandline, I have always kept at least one terminal window open at all times, and often three or more.

In Mac Land, that’s Terminal. Yes, I could run the X server and use Xterm, but that would be a step backward from the one thing which drove me away from Unix in the first place. I came to Mac because I didn’t have to use the X server to get a GUI, since Mac has the best one out there. Whatever I needed to do on the command line requires making Terminal do it right. By default, Terminal has some rather odd behavior for someone coming from Unix, and more if your Unix is Linux. Most of it can be changed. One thing you will not get is the mouse-paste. That’s unique to the X server. Sure, you can get a mouse driver for Logitech or Intellimouse which will let you alter the wheel button behavior, but it breaks other, more versatile and useful behavior, so you might as well get used to Cmd+C and Cmd+V. But most other things can be adjusted to behave as we Unix people have come to expect.

For this demonstration, I’m using Joe as the application which will most readily lend itself to explaining what we need to do. Joe’s Own Editor offers a quick and easy method to editing the configuration file to add non-default keystrokes. A couple of years ago I wrote a HOWTO on customizing Joe’s keystrokes based on work by Anne Baretta and a few tips garnered here and there. In our last installment, we covered installing Joe and Aspell, so I’m assuming you either have them already, or can grasp what follows without them.

First, grab a copy of your system joerc for your $HOME folder (using the command line, of course):

cp /usr/local/etc/joe/joerc ~/

cp /usr/local/etc/joe/ftyperc ~/

If you have the latest version of Joe, you’ll probably want to modify the ftyperc for your own use, as I do. But first, we have to understand the fundamental difference between Mac’s Terminal and your generic Xterm. Terminal has some different default actions assigned to some of the keystrokes. More, as my HOWTO encourages assigning F-keys to Joe actions, you’ll need to consider doing something I did: turn them off in the Mac GUI.

For serious Mac users, this is probably anathema. For Unix users, having all or most of the F-keys available for the applications is pretty important. In Mac’s System Preferences, go to Keyboard & Mouse, and open Keyboard Shortcuts. For me, the simplest answer was to en masse turn off “Keyboard Navigation” shortcuts because I use the mouse for those things, if at all. Then I added “Dock, Expose and Dashboard” because I can’t imagine why I would want them. Your mileage may vary, but if you want the F-keys for Terminal, consider it.

In my HOWTO on Joe’s keystrokes, I point out the method of determining what keycodes are output by your terminal emulator of choice, by hitting CTRL+V, followed by any other key or combination with modifiers. This works in Terminal. However, you’ll notice they all include the “escape sequence” of ^[ which represents hitting the ESC, but forms a part of what Joe needs to interpret custom keystrokes. However, when you open the Preferences dialog in Terminal, choose a profile (I set Pro as my default), and click on the “Keyboard” setting page, you’ll see most of them are in the pattern of 33xxxx. If you understand that 33 is equivalent to ^[, you can do this.

Now, scanning down through the list of default keystrokes in this dialog, we see why the “gray keys” won’t work without holding down the SHIFT key. Change those assignments. You’ll need to assign them to a “string” instead of any of the optional actions. Just select any of the gray key names and then click “Edit” and select the option to send a string. Below are various strings as they are output in most Xterms, which is what most command line applications are expecting, even when compiled on Mac. I have broken down the spacing as Joe uses the Xterm output, according to the instructions in my HOWTO.


Joe format

Mac label

Terminal format


^[ [ C

cursor right




^[ [ 1 ; 5 C

control cursor right



^[ [ 1 ; 3 C

option cursor right


In order to tell Terminal to output that second command as I wished, I had to remove the default and tell it to send the string in the last column of the second row above. Furthermore, I have to warn you the dialog will attempt to interpret any deleting keystrokes, so neither DEL nor BKSP can be used to clear a string in that dialog. You’ll need to highlight with the mouse, then either overtype or paste what you want there.

Below are all the arrow keys and gray keys except the HELP and DEL keys on Mac keyboards. Use those you need. In some cases, you’ll have to use the + button the dialog interface to add the keystrokes not included by default, along with any modifiers.


Joe format

Mac label

Terminal format


^[ [ D

cursor left



^[ [ 1 ; 5 D

control cursor left



^[ [ 1 ; 3 D

option cursor left



^[ [ A

cursor up



^[ [ 1 ; 5 A

control cursor up



^[ [ 1 ; 3 A

option cursor up



^[ [ B

cursor down



^[ [ 1 ; 5 B

control cursor down



^[ [ 1 ; 3 B

option cursor down



^[ [ H




^[ [ 1 ; 5 H

control home



^[ [ 1 ; 3 H

option home



^[ [ F




^[ [ 1 ; 5 F

control end



^[ [ 1 ; 3 F

option end



^[ [ 5 ~

page up



^[ [ 5 ; 5 ~

control page up



^[ [ 5 ; 3 ~

option page up



^[ [ 6 ~

page down



^[ [ 6 ; 5 ~

control page down



^[ [ 6 ; 3 ~

option page down


Once you have told Terminal what keystrokes you want added and the strings to send, you are ready to edit your joerc according to the HOWTO linked above. Note that the ftyperc is where you put your specific options regarding various filetypes. For plain text (.txt), I use the following format options:

Text file. *.txt


-tab 3

-indentc 32

-istep 1



-rmargin 72


I use the same for HTML files. The explantion for each one can be found in the joerc file.

There is one more peculiarity I’ve found in Terminal. For some strange reason, F1-F3 tend to output something different than what Joe expects, and probably most other command line programs from Unix. In my joerc, instead of using the standard .k1, I had to pickup the code output from Terminal as revealed by the command CTRL+V: ^[OP. Then, I placed this in my joerc where I wanted to use F1, after spacing it out properly. I did the same for F2 and F3.

After you’ve added your custom keystrokes and commands to joerc, make sure to change the “include” statement for your ftyperc (approximately line 360). It must be the full path. Mine says this:

:include /Users/edhurst/.ftyperc

Which brings up the last point of renaming them both by adding a period to the front of the file so they are read as configuration files:

mv joerc .joerc

mv ftyperc .ftyperc

After modifying the Terminal profile keystrokes, I tested a few other applications and they seemed to work okay. Enjoy.


Taken from: Open For Business

HowTo reinstall – restore GRUB in UBUNTU

After a windows fresh install, the windows setup decided to drop MBR to put its stuff in. 
This is an old trick, but udev added a little complexity, so let’s give it a try. First boot on a Ubuntu CD, open a console and run:
(here linux partition is sda2, second partition on a sata disk)
mkdir /media/mnt mount /dev/sda2 /media/mnt/ mount -o bind /dev/ /media/mnt/dev chroot /media/mnt => now you are on the destination disk, so you can install grub. grub-install /dev/sda
Of course you can do a lot more stuff, like changing fstab etc etc .. but the trick is to mount + mount bind + chroot

Ignore duplicate entries in MySQL select using DISTINCT keyword

Sometimes every occurance of a value which may be duplicated multiple times in a result set is not needed. For example, if making a pulldown menu list of options, each option should be seen only once. The DISTINCT keyword in a select statement eliminates duplication in the result set.

The column party from the presidents sample table has many repeats in it. To select a list of the parties from the table, use:

SELECT DISTINCT party FROM presidents;

This returns a result set that looks like:

| party |
| no party |
| Federalist |
| Democratic-Republican |
| Democratic |
| Whig |
| Republican |

Using the DISTINCT keyword on queries with multiple columns will return unique combinations of values on all of the columns. For example, the query

SELECT DISTINCT givenname, party FROM presidents;

returns 36 out of a possible 43 rows. Each row is a unique combination of first name and political party.

Rename or change name of MySQL table

If you change your mind and want to rename an existing MySQL table, with or without data in it, it is no problem. One simple command will change the table’s name.

To change the name of an existing table old to new, use this command as a user with adequate privileges:


It is good DBA manners to make sure that no one and no program are using this table before making the name change.

MWC 2008: Nokia

Market leaders Nokia were naturally among the key news makers at the Mobile World Congress (formerly known as 3GSM). The Finnish company revealed four new high-end devices today, including the dual slider Nokia N96, Nokia N78, Nokia 6210 Navigator and Nokia 6220 classic.

Nokia N96
Nokia N96 is a quad-band handset with dual-band HSDPA support for worldwide coverage. It runs on S60 3rd edition, FP2 and has a 2.8″ QVGA (240 x 320 pixels) TFT display with 16M colors. Other features of this true powerhouse include GPS with A-GPS support and geo-tagging for photos, Wi-Fi, the stunning 16GB of onboard memory, plus a microSD slot. If that feature pack doesn’t grab your attention, hardly anything will.
Nokia N96 has a 5 megapixel autofocus camera with Carl Zeiss optics and powerful dual LED flash. It also records video in VGA resolution at 30 fps.The connectivity set sports Wi-Fi b/g with UPnP support, microUSB v2.0, DVB-H class C, a 3.5mm stereo headphone plug and Bluetooth v2.0 with A2DP stereo audio.

Nokia N78
Another very interesting handset joining the Nseries, Nokia N78 comes in the bar form factor. Both Nokia N96 and N78 have a few design elements in common, starting with the underlying resemblance to Nokia N81. This means that they will see little appreciation among the GSMArena team, as we aren’t the greatest fans of that design, to say the least.
Nokia N78 is a quad-band phone with dual-band HSDPA support. The novelties are geotagging and the integrated FM transmitter, allowing music to be played on any FM radio. Also to mention is the multimedia menu with Navi wheel.
Nokia N78 also uses S60 3rd edition, FP2 and has a 2.4″ QVGA (240 x 320 pixels) TFT display with 16M colors. Nokia N78 offers A-GPS support, Wi-Fi, 70MB on-board memory, expandable via microSD.
Nokia N78 has a 3.2 megapixel autofocus camera with Carl Zeiss optics. It also records video in VGA resolution at 15fps but is still capable of playing VGA video clips at 30 fps.

Some more Nokia N78 live photos
The connectivity options include Wi-Fi b/g with UPnP, microUSB v2.0, a 3.5mm stereo headphone plug and Bluetooth v2.0 with A2DP stereo audio. Another especially interesting feature is the built-in FM transmitter that allows you to enjoy the music stored in your device on any FM radio.

MWC 2008: Mobile TV Services at Reduced Costs from Orange and T-Mobile

Orange and T-Mobile UK announced, at the Mobile World Congress in Barcelona, Spain, their intention to try a new mobile TV and multimedia broadcast service using a UMTS MBMS based TDtv solution from NextWave Wireless, a mobile/multimedia products and technology provider. The service pilot is planned for the second half of 2008 and will involve consumers living or working in West London.

It will demonstrate that the costs of offering high-quality, mass market mobile TV and multimedia broadcast services can be considerably reduced if mobile operators share a standards-based TDtv broadcast network and broadly-available unpaired 3G spectrum. The pilot will also showcase an ingenious consortium model that can be conveniently replicated by mobile operators in over 50 other countries.

During the pilot (that lasts for six months), T-Mobile and Orange subscribers will use TDtv-enabled WCDMA mobile phones to receive different high-resolution television channels (up to 24) as well as 10 digital radio stations, all for a significantly lower delivery cost than ever before. The pilot service will include important broadcast and premium television channels and should prove that there is a customer demand for mobile broadcast TV and radio services.

Network operators from both Europe and Asia Pacific that own unpaired UMTS spectrum, as well as handset producers who can make TDtv a standard feature in their phones, will be invited to observe the future pilot.

“Orange was the first UK network operator to introduce a mobile TV service in May 2005, and is continually looking for unique insights and innovative content to ensure that Orange Mobile TV continues to grow and develop in a way that offers the best available standard of service for our customers,” said Paul Jevons, Product and Innovation Director at Orange. “The results from the technical trial of TDtv in Bristol last year were extremely encouraging, and this joint pilot of the service in London is an excellent opportunity for us to properly explore the great potential available to our customers from the technology. Orange Mobile TV already offers a broad range of content including the major terrestrial channels BBC, ITV, Channel 4 and Channel 5, as well as Sky and most recently Setanta allowing Orange mobile TV customers to see live coverage of every televised match from the Barclays Premier League.”

“We are committed to widening the appeal of our Mobile TV offering, from the point of view content and user experience,” said T-Mobile UK Technical Director, Emin Gurdenli. “Last year, we revamped our offering with the addition of three Sky Mobile TV packages and eight BBC TV and radio channels to provide customers with more choice. On a technical level, our involvement with this TDtv pilot is intended to raise awareness of the potential of broadcast mobile TV and help stimulate the development of an industry-wide ecosystem in which operators, handset manufacturers and content providers collaborate to realize a robust commercial proposition. TDtv uses part of the licensed 3G spectrum which is unused at the moment and is a technology that can scale to support high simultaneous usage levels without any degradation in quality. This solution would be ideal for broadcasting live, large sporting events such as the 2012 Olympic Games to high population densities.”

The mobile TV pilot will be powered by a full NextWave Wireless mobile broadcast solution that includes TDtv network infrastructure based on the 3GPP UMTS TDD MBMS standard. Moreover, NextWave will provide a TDtv Device Integration Pack (enabling handset vendors to easily add TDtv to any multimedia enabled WCDMA phone) and a complete Electronics Programming Guide to integrate the TDtv service with the operators’ 3G services.

“We are rapidly moving into a new and exciting wireless era, the era of mobile multimedia where your favorite movies, television shows, and music will be accessible everywhere you go, in the palm of your hand. It’s why we developed our innovative TDtv mobile broadcast solution,” said Allen Salmasi, CEO of NextWave Wireless. “We believe today’s announcement of a joint TDtv initiative by two of the world’s largest mobile network operators represents an important milestone in the evolution of mobile multimedia and will clearly demonstrate the compelling economics of marrying our innovative TDtv technology with underutilized 3G spectrum to deliver high-quality mobile television services to the mass market.”

The MWC 2008 – Sony Ericsson XPERIA X1

Sony Ericsson XPERIA X1

Considering Sony Ericsson’s history with Symbian, and the UIQ interface, it is sure they surprised us with the announcement of the new XPERIA X1. The X-series device is Windows Mobile 6 Professional smartphone with high-end functionality. It is the first of the brand to use this operating system, but will most probably the start of a line of such devices. Unlike Cyber-shot and Walkman series, the XPERIA is a name that is not coming from Sony, but is a brand of the phone manufacturer (Sony Ericsson) only. XPERIA stands for ‘ultimate user experience’ and will consists of PREMIUM converged devices, not ones targeted to only camera, music, etc.

The phone is scheduled for release in the second half of the year, and the units that were showcased are prototypes, which were kept away from the press. We were able only to take pictures and (don’t tell anyone) hold it only for a second. However, there were a few things that were shown: the design of the device itself, and a part of its personalization. Although its specifications are top-notch, the design is stylish: it will be available in two color variants, brushed aluminum and piano black. The few keys below the huge display are with triangular form, reminding of the PRISM Nokia phones and the Z555. The D-pad in the middle reacts to touch; called “Optical joystick” and can be used for scrolling – just sweep your finger from top to bottom or vice verse.

The operating system is Windows Mobile 6 (not 6.1) but it seems that Sony Ericsson will heavily personalized it. Unfortunately, at this stage only a few screens were shown, as the manufacturer is keeping the rest a secret. Once a shortcut is pressed, a menu with what is called ‘panels’ appears. It shows differently personalized environments, suitable for different tastes. The way the icons are scrolled and shown, reminds of the iPhone – everybody nowadays is inspired by the popular phone. These panels offer different interfaces as a whole, however, some menues will remain the standard Windows Mobile.

Similar to many high-end devices with this OS, the XPERIA is a side-opening slider, with QWERTY keyboard. However, it has ‘arc slider design’, which situates the display at a slight angle and according to Sony Ericsson leaves more space for the QWERTY keyboard.
As we said earlier, we were not really able to use the phone, so our impressions are limited. However, the features on paper look very nice: quad-band GSM and quad-band UMTS/HSDPA, 3-inch 480×800 pixels display, 3.2-megapixel camera, and all the bells and whistles of the WM6 Pro OS. Untypically for the manufacturer, the phone doesn’t use the proprietary connector (but miniUSB) and has standard microSD slot in the place of the M2 one.

Install or Enable the Telnet Client or Server and many more in VISTA

Vista comes with a telnet client and server. They are not enabled by default. If you would like to use either of these features, just follow these steps…

1. Click the Start Orb
2. Click Control Panel
3. Select Programs
4. Select Turn Windows Features on or off
5. May need to confirm the UAC
6. Wait…
7. Click the checkboxes beside the telnet client or server         

8. Click OK

You can find many other usefull features in this menu.

Vista small tips

Faster indexing:

Start –> Write indexing options and enter

Click modify and then show all locations

uncheck from tree all except start menu and click ok

You can change from here the type of files that you want to index.


How to make faster the search from start menu:

Right click start button and choose properties at the tab start menu, then click customize and uncheck search communications. Then put radio button search files to Don’t Search for files and click ok.


How to make your SATA disk faster:

Click on start and write device manager, hit enter. Choose disk drives and click + to expand. Right click in your disk and in tab policies check enable advanced performance. Experience it…


Vista have readyboost

They let you use a usb flash disk for paging file instead of hard disk when you do not have many free RAM.

Find a USB 2.0 flash. It is good to write more than 3 MB/s and read at least 4 MB/s

Plug usb disk in your pc and right click at removable storage device and then properties. You will see a tab readyboost, chek at use this device and insert the size you want to use from the usb disk and then click OK.