segunda-feira, julho 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!

28 comentários:

Erik Weibust disse...

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?

Anônimo disse...

I've got exactly the same issue.

Renaud disse...

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

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

Merci

Anônimo disse...

brilliant, excellent

Renato Lima disse...

Great! It's work perfectly!
Thanks.

Jean-Michel disse...

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

Anônimo disse...

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 disse...

thanks for the tip..

AMD disse...

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'.

Anônimo disse...

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

Anônimo disse...

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 disse...

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.

Anônimo disse...

Thanks a lot, helped immediatly ^^

Anônimo disse...

Thx for your explanations. It helped me a lot.

Nick disse...

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 disse...

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 disse...

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

D3NNIS disse...

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

Anônimo disse...

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 disse...

Thanks!

Anônimo disse...

thx - i love you!

Marcio disse...

Perfeito também no Ubuntu 10.04! Parabéns meu caro.

Mathankumar disse...
Este comentário foi removido pelo autor.
Mathankumar disse...

Got the following error

"Unable to load libsqlmy.so"

while trying to connect mysql.....

Thanks in advance.

Leonardo disse...

Thanks a lot, exactly what I was looking for!!!

Joe La Frite disse...

Hi folks!

If you encounter the error:
libborqt-6.9-qt2.3.so: cannot open shared object file: No such file or directory

when running a 64bits distro despite you followed the last step of the installation, it's because DBD4 runs in 32bits mode.

I tried:
$ strace DBDesigner4 2> strace.log

And found where it was looking up the libborqt-6.9-qt2.3.so file.

In my case, I just created a symbolic link in /lib32/ to sort it out.

Anônimo disse...

TKS !!!

хэлэх үг, өчих талбар disse...

great. worked :)