Monday, July 03, 2006

HOWTO: Install DBDesigner 4 on Ubuntu Linux

Its very simple to install this great application on Ubuntu, i m using the 6.06 Dapper Drake version of Ubuntu, but it should work on any other version, so lets see how to install it:

First of all you need to download the DBDesigner package, you can get it from here:

http://fabforce.net/downloads.php

Grab the rpm version.

After downloading this file you will need alien to convert it to .deb, if you don't have it installed, just type this on a terminal:

sudo apt-get install alien


Now, go to where you downloaded the rpm package and install it using:

sudo alien -i   DBDesigner4-0.5.4-0.i586.rpm


And now the trick to get it working, if you try to open the DBDesigner it will give you an error saying that it cant open the shared library libborqt-6.9-qt2.3.so, to fix it do the following:

First Download the library package and extract it using:

tar xzvf kylixlibs3-borqt-3.0-2.tar.gz


After extracting it do the following:

sudo cp kylixlibs3-borqt/libborqt-6.9.0-qt2.3.so /lib/libborqt-6.9-qt2.3.so


Now your DBDesigner should be working, the executable file DBDesigner4 can be found at /opt/DBDesigner

Hope it helps!

21 Comments:

Erik Weibust said...

I got installed by the gui looks a bit off. Like some of the tabs aren't big enough for the text on them. It's almost like it's using a wrong gui lib or something. Any ideas?

Anonymous said...

I've got exactly the same issue.

Renaud said...

Excellent
It's Alive, Alive...
Thanks for this quick and easy setup.

J'adore quand un plan se déroule sans accrocs !

Merci

Anonymous said...

brilliant, excellent

Renato Lima said...

Great! It's work perfectly!
Thanks.

Jean-Michel said...

Hi, Thanks for the explqnations. Actually; I think it's easier to use wine and the windows installer, see the details on my blog
http://21croissants.blogspot.com/2006/12/dbdesigner-4-on-ubuntu-dbdesigner-4-on.html

Anonymous said...

Thank's !
works great :-)
I try to use MySQL Workbench - i get install it, but too many problems after.
So finding your howto I try .. and now all works great :-)

Grande, funziona benissimo!
Decisamente meglio DBDesigner che MySQL Workbench.
Howto semplicissimo.
Grazie ;-)

charan said...

thanks for the tip..

AMD said...

Thanx, for your help
but, just one small thing if you want to make a shortcut right clic on the descktop
create a launcher and add '/opt/DBDesigner4/DBDesigner4'.

Anonymous said...

just change the font to verdana 6, looks good to me
option - dbdesigner option- visual option

Anonymous said...

To change the font to Verdana you need to install Microsoft Fonts (sudo apt-get install msttcorefonts).
Or you can use Helvetica 10 (looks better to me)

privateer said...

Some more problems on UBUNTU gutsy gibbon ...

After successful running App by this howto I spotted this while connecting DB:
"unable to load libmysqlclient.so"

Not to mention I have the lib. It's incompatibility issue. Symlink /usr/lib/libmysqlclient.so points to so.15 and DBDesigner ships with so.10. It can be solved by replacing library name in:

~/.DBDesigner4/DBConn_DefaultSettings.ini
~/.DBDesigner4/DBConn.ini

FROM VendorLibLinux=libmysqlclient.so
TO VendorLibLinux=libmysqlclient.so.10



The problem remains unfortunately. The libmysqlclient.so.10.0.0 privided with DBDesigner is somehow incompatible with the app (?!).

The version downloaded from :
http://www.wesmo.com/rpm2html/contributed/RPMS/MySQL-shared-compat-4.1.9-0.i386.html
finally did the trick. I extracted 'libmysqlclient.so.10.0.0' from RPM , copied to /usr/lib, created a symlink /usr/lib/libmysqlclient.so.10 pointing to it and then it started.

Anonymous said...

Thanks a lot, helped immediatly ^^

Anonymous said...

Thx for your explanations. It helped me a lot.

Nick said...

Fantastic. Got it up and running on Ubuntu Gutsy. FYI: the libborqt-6.9-qt2.3.so file DBDesigner looks for, comes out of the zip file now as libborqt-6.9.0-qt2.3.so

I just had to remove the (.0) and all was well.

Thanks!
nick

Diego said...

Hello,
I followed the steps, but qhen I tried to execute DBDesigner, i get this error message:

libborqt-6.9-qt2.3.so: cannot open shared object file: No such file or directory

Any ideas of what could be wrong? Thanks!

Dhiraj Patra said...

Thanks for your valuable help. It worked perfectly.
Regards-
dhirajpatra.blogspot.com

D3NNIS said...

THX A LOT !
i almost went mad with this on ubuntu gutsy, but i finally managed it with the old version of libmysqlclient.so like you described.

Last Step is setting Password the old style in mysql console.

mysql>SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('something');

THx for your help

Anonymous said...

Hi folks,
anyone has tested this howto on amd64 systems? j'm tryed and dbDesigners doesn't work...

libborqt-6.9-qt2.3.so: cannot open shared object file: No such file or directory

j think that the KylixLibs doesn't run in amd64 system.

Thank you in advance

Andy Beaumont said...

Thanks!

Anonymous said...

thx - i love you!