Navicat on Linux

I love using Navicat for MySQL. I've tried a lot of different UIs for MySQL administration and this one is worth the price.

And I applaud PremiumSoft for having a Linux version. Unfortunately, the Linux version is really the Windows version with an included version of Wine, tweaked to run Navicat. Seems kind of strange to have 2 versions of Wine on my system.

So I purchased a copy of the Windows version and set to work figuring out how to get all the features to work and how to make it look like a native app as well.

In order to do things like saving data transfer profiles, you'll need to do the following.

1. Use Google to find download links to Pgmr101.ocx, msxml3.dll and msxml3r.dll or get them from a Windows XP distribution. Copy these to Wine's system32 directory, overwrite as required (but backup any existing files just in case). In my case, I copied them to /home/omerk/.wine/drive_c/windows/system32/

2. Run a DOS (yes DOS) terminal:
env WINEPREFIX="/home/{your_home_dir}/.wine" wine "C:\windows\system32\cmd.exe"

3. Paste these DOS commands and hit enter for each:
regsvr32 msxml3.dll
regsvr32 /s msxml3.dll
regsvr32 msxml3r.dll
regsvr32 /s msxml3r.dll
regsvr32 Pgmr101.ocx
regsvr32 /s Pgmr101.ocx

You may need to cd into the system32 directory for this to work.

4. In Ubuntu, open Applications > Wine > Configure Wine.

5. In Libraries > Existing Overrides:
msxml3.dll(native, builtin)
Note that the order is important: native, then builtin.


6. Install the Windows version of Navicat via Wine and you should be good to go.

In terms of fonts, they can be tweaked either at the Wine level or in the application itself. Note that if you change fonts in the application, you must re-start it to see the changes.

Mine looks like this...


QuickFolders for Thunderbird

Just found a great extension to Thunderbird that has cut down on the amount of time I spend sorting through the daily email flood. QuickFolders is a project created by Alexander Malfait and Axel Grude. They've obviously put a lot of time, thought and care into crafting this very configurable add-on.

Here's a screen shot from their site:

As you can see, you create a tool bar of your most-used email folders for easy access. You can also drag emails onto these tabs for quick organization. And there are lots of settings to play around with until you get it looking just right.

I think this is such vital functionality that it should be part of the next version of Thunderbird.

The project home page is at quickfolders.mozdev.org.

If you're a Thunderbird user, this one's a must-have.

RabbitVCS == Tortoise SVN for Linux!

There's been an update to the old NautilusSVN project called RabbitVCS which finally gives Ubuntu/Gnome SVN users something on par with the venerable Tortoise for Windows.

I've been testing it for a couple of days and it's really good. The only bug I've found is that if a file is deleted from disk, a commit won't delete the file from Subversion. Guess I won't be able to "sudo apt-get purge kdesvn" just yet, but hopefully soon!

It also has one of the best Open Source project sites I've ever seen. Check it out (pun intended) at www.rabbitvcs.org.

Flex Development with Firefox

Does it drive you crazy that every time you run your Flex app it opens in a new Firefox tab or window? Here's the fix:

In the address bar, enter about:config

Search for or add the following two entries and set their values to 1:

browser.link.open_newwindow = 1
browser.link.open_external = 1

Now the same window will be used every time. No browser restart required. This works with 3.6.8 but future versions might change these keys.

Flash Builder 4 Linux Notes

OK, so there's no such (official) thing as Flash Builder 4 for Linux (unless you know how to use "the Internet" and something called "Google"). Despite Adobe's reluctance to give us the "choice" (ahem) of OS to use, some clever people have figured out how to get most of FB4 to work on, in my case, Ubuntu.

Here are some tricks I had to use to get it really humming:

Problem: Packages Missing
(OK, this one's just me being stupid)
Use View: Package Explorer, not Navigator

Restore Control-Shift-R
(Most annoying bug in FB4!)
Windows -> Customize Perspective -> Command Groups Availability:
De-select "Flash Navigation"
Restart Eclipse
If this doesn't fix the problem, go back into Command Groups Availability:
Select "Java Coding"
[You may need to re-save the Flash perspective to enable these]

Restore Flash Context Menu
(i.e. right-click on project and see Flex options)
Windows -> Customize Perspective -> Shortcuts
Add Flash Builder

Restore Context Menu Icons
(Actually turns out to be an Ubuntu thing:)
Issue these commands in your terminal:
gconftool-2 -s -t boolean /desktop/gnome/interface/buttons_have_icons true
gconftool-2 -s -t boolean /desktop/gnome/interface/menus_have_icons true

Let me know if you have any others...

BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.