ayozone

DBdesigner is a tool to design models and database graphically with a nice feature that can draw the database schema from an existing database (reverse engineering.
There is no deb and the install may be a bit tricky due to depndencies to old libs and missing links.

Here we go.
First, we need the software package from fabforge
Now, we untar this in /opt :

cd /opt && sudo tar xzvf /path/where/is/DBDesigner4.0.5.4.tar.gz

;
Now download libborqt_6.9.0-3_i386.deb (that I’ve made with alien from a RPM since this package doesn’t exist for ubuntu.), and then install it with this command :

sudo dpkg -i /path/where/is/libborqt_6.9.0-3_i386.deb

Eventually, run this command :

sudo /opt/DBDesigner4/startdbd

Now you’re ready to laaunch DBdesigner with the following command (you also can put it in a shortcut in your panel or on your desktop) :

/opt/DBDesigner4/DBDesigner4

Issues and workarounds :

If you get the error message “Unable to load libsqlmy.so” when trying to connect to a mysql database, make a link like this :

sudo ln -sf /opt/DBDesigner4/Linuxlib/libsqlmy.so /usr/lib/

Retry to connect to your mysql database, you may get this error : “unable to load libmysqlclient.so”, download this libmysqlclient10.zip (I’ve extracted it from the rpm package MySQL-shared-compat-4.1.9-0.i386.rpm), extract it and made a link :

cd /usr/lib

sudo unzip /path/where/is/libmysqlclient10.zip

sudo ln -sf /usr/lib/libmysqlclient.so.10.0.0 /usr/lib/libmysqlclient.so

Now, if you try again to connect to your mysql database and DBdesigner complains about wrong username/password, do :

mysql -u your_mysql_username -p

And at mysql prompt type in :

mysql>SET PASSWORD FOR 'your_mysql_username'@'localhost' = OLD_PASSWORD('your_mysql_password');

Now DBdesigner should run and connect to your mysql database.

Have fun !