Installing Lucid Lynx

For what its worth, Lucid Lynx didn’t generate positive initial buzz, and for the first time since Ubuntu 5.04, I didn’t download and install latest version of Ubuntu. I had read comments that there are problems with latest version (that too LTS – Long Term support) of Ubuntu, so I decided to hold back.

Then couple days ago, I got hold of an ISO someone had downloaded, and installed successfully. (They came to me asking about why ssh wouldn’t work for them – As you might already know, Desktop edition doesn’t ship ssh server by default. It was matter of minutes to download ssh via apt-get, and they were up and running – and now to your regularly scheduled program) So I decided to give it a shot. Soon I realized, my decision to hold off was correct.

Attempt to boot from LiveCD

First of all, it took really long time for LiveCD to boot. I mean it did show the GUI splash screen quite quickly, but then for a really long time, it kept showing Ubuntu, and a progress bar (as dots/circles) None of the terminals were accessible via Alt+Fn.

Unable to recognize the existing Partitions

When it did boot, it was unable to recognize the partition table. Further troubleshooting showed that “Disk Utility” program under System->Administrator was able to read the partition table correctly, and identified the partitions correctly, but GParted (and embedded Partition Manager for the installer) could not. They showed entire disk as available. But a picture is worth a thousand words. See this image (I’ve not captured this, several others are facing the same problem) .

To be fair, this issue is well documented in Release notes here. But it still doesn’t change the fact that there was no way to preserve existing partitions and install Lucid on existing empty partition.

Some link of the internet asked to uninstall “dmraid” package, but it didn’t help. I didn’t have RAID anyway.
Next, back to the person who had successfully installed it from the same ISO. Turns out he installed it via Wubi. So I decided to try that.

Wubi woes

Now I ran into “permission denied” issue. After copying the files in target folder from CD, it would exit. Unhiding AppData folder didn’t help. Finally I downloaded wubi.exe, and copied an ISO and Wubi.exe in same newly created empty folder. This seemed to have worked – but make sure that if you want Wubi to use local ISO – Disable the internet or better still, remove the ethernet cable (as I did) else Wubi will go out and try to download the entire image before it starts installing.

This time it went much further – installed Ubntu successfully (or so I thought) and provided me a choice to reboot now, or later. After I reboot, I selected Ubuntu from Windows Boot loader list. It “continued” the installation, but at he stage where it gets time from network time server, it was stuck in a loop “No root partition defined” there were no option other than OK. Interestingly, the installation progress bar showed 272% (Yes more than 100%)

Finally … Success (sort of)

Luckily I didn’t have a precious data, and machine was my secondary machine, so I could afford to repartition the entire disk. That is what I did. I already had brand new ISO, This time I booted from USB drive, so that I didn’t have to worry about bad CD. I selected to repartition the disk from the Lucid Installer. Rest of the install went very smooth.

Conclusion

It is really sad that all three issues (permission denied, unable to recognize partition table, and no root partition defined) are widely reported. Only the first one (permission denied) has a work around that worked.

Image courtesy : jeffpro57

Importing CSV file data into sqlite3

I was trying to import the data from CSV file into sqlite3 database. Ideally this should be very simple task, with following the steps given in the sqlite tutorial. It is a matter of calling the sqlite command with separator argument, followed by an import operation, as listed below.

sqlite3 test.db  "create table t1 (t1key INTEGER PRIMARY KEY,data TEXT);"
sqlite3 -separator , test.db ".import some.csv t1"

Except that main attribute of my CSV file was that it could contain single records with embedded comma. I was hoping that sqlite3 would be smart enough to detect that the fields were enclosed within double quotes and then separate by comma. But I soon realized that only a code specifically dealing with CSV would know about this.  As we can see in the example above, the import is a generic code and as a user I listed comma as a separator.

My Data looked something like this :

"1","data1"
"2","data2,data3"

So like any *nix geek would do, I tried providing double quote and comma as a separator. To my surprise it worked very well. I though separator would take only single character, and I had provided two (three?). Anyway, important thing to remember is to escape the single quote with a backslash (I didn’t try it without the backslash, may be that would work too)

So here is the syntax that worked :

sqlite3 -separator \", test.db ".import mydata.csv mytbl"

Update : Turns out SQLite Manager is much better solution after all.  It is an Extension for Firefox and other apps to manage any sqlite database. Not only it took care of above situation, it also handled empty cells as well where the command line failed with following error message :

line 4: expected 3 columns of data but found 2

Data with missing cells : Notice two successive commas :

"1","data1","data2"
"2","data3,data4","data5"
"3",,"data6"

How to Fix the look ‘n feel of GTK Apps in KDE

As all the Ubuntu users know, the default Ubuntu comes with Gnome. Kubuntu is a separate download, focused around K-apps. But I wanted best of both the worlds. It was easy to have both. I just followed the instructions from this page.

Personally, I think KDE 4.x is pretty nice. It comes with host of applications. I think KDE is cool (.. and acknowledge that cool is subjective – personal.)

Since I moved to KDE from Gnome,  I have become dependent on several GTK apps. (GTK is the cross platform widget library used to write the Gnome applications) But by default they don’t look good in KDE.

1. Firefox tabs would merge into each other, and visually I could not differentiate the boundaries.
2. Firefox scrollbars didn’t work correctly either
3. Gnome DO had weird problem, as is the drop-down list which allows me to select the theme went completely bonkers.
4. The Edit box in Autokey is completely Hidden (See the image Above)

Something had to be done. See the images below. Click on the images to see the details.

Follow these simple instructions to ensure that GTK apps “play well” with KDE

1. Go to System Settings ->Appearance
2. Click on “GTK Styles and fonts” from the left hand side panel
3. The very first (at the top) option is GTK Styles. The Default is use KDE Style. Select USe Another Style.
4. Select Clearlooks (For blue) or Human Clearlooks from the drop down.
5. You need to restart the GTK Apps.

Now all your KDE/QT apps as well as GTK apps would work well (in terms of display)

See the screen shots after the above fix is applied. Click on the images to see the details.

Related articles by Zemanta

• Chrome for Linux To Use GTK (ostatic.com)
• Google Chrome on KDE4.2 – Why not? (internetling.com)

Next Page »