howto install dbdesigner4

[dave84]

hi everybody bothering about how to install dbdesigner!

currently i'm running mysql 5.0 on my notebook and i got dbdesigner working after solving quite a lot of problems.
what helped me a lot were the explanations from

http://wiki.splitbrain.org/dbdesigner

(you should do everything explained in the "It needs a shared library from Kylix:"-section.) and also do:

download the libborqt-6.9.0-2.i386.rpm from http://sourceforge.net/project/showf...ckage_id=68416

alien libborqt-6.9.0-2.i386.rpm
  dpkg -i libborqt_6.9.0-3_i386.deb

when you cannot go along after struggling through these instructions try this:

1. edit the last line of the startdbd script to:

$app_path/DBDesigner4 $* #2> ~/.DBDesigner4/DBD4.log

now try to start again and take care of the failure message:

when you get s.th. like

" symbol lookup error: blablabla/Linuxlib/libqt.so.2: undefined symbol: XftPatternGetString"

make a symbolic link with these command (from the dir where you extracted the tarball):

cd DBDesigner4/Linuxlib

sudo rm libqt.so.2

ln -s /usr/lib/usr/lib/kylix3/libborqt-6.9.0-qt2.3.so ./

2. now you should be able to start dbdesigner4
(maybe there is a missing symlink; try around a little bit)

3. when you try to connect to the mysql-database and you get an error that tells you something about "cannot load libmysqlclient.so" then again:

sudo rm libmysqlclient.so

ln -s /usr/lib/usr/lib/libmysqlclient.so.14.0.0 libmysqlclient.so

4. restart the dbdesigner4 and try to connect again. when an error message pops up and tells you about wrong username and password then enable the use of old passwords with your mysql-administrator and set up a new password with:

set password for 'mysql'@'localhost' = old_password('mysql');

flush privileges;

5. try it again, now it should work!

please correct this post, if I have messed s.th up and apologize my bad english

[drippy]

Dave: thanks a lot for this post, I finally got DBDesigner working after reading through your steps and doing some debugging along the way.

[sitedesign]

I have just tried these instruction and some others I found on the web but I get DBDesigner running, only I can't connect to the MySQL database.

The error is:
Unable to load libsqlmy.so

Any ideas.

Running Dapper.

[steparianwolf]

Hi:

I wrote a small guide to install and keep working DBDesigner in Ubuntu, in fact I'm using Ubuntu Dapper and DBDesigner without problems.. take a look at this: http://www.ubuntuforums.org/showthre...ght=dbdesigner

I hope it works for you

[devnulljp]

Hi:

I wrote a small guide to install and keep working DBDesigner in Ubuntu, in fact I'm using Ubuntu Dapper and DBDesigner without problems.. take a look at this: http://www.ubuntuforums.org/showthre...ght=dbdesigner

I hope it works for you

Link's dead - any ideas?

[talz13]

When I tried installing the kylix libs, it complains that xlibs is not installed. I found xlibs-dev in synaptic and installed that, but still the problem remains.

[dragomirov]

open a console and get/install xlibs

wget http://www.chorse.org/junkroom/xlibs...8.2-77_all.deb

sudo dpkg -i xlibs_6.8.2-77_all.deb

[Marco Modesto]

The Link for libborqt-6.9.0-2.i386.rpm is broken:
http://sourceforge.net/project/showf...ckage_id=68416


I found this package in RPM Find: http://www.rpmfind.net/

Working link:
ftp://fr2.rpmfind.net/linux/sourcefo...9.0-2.i386.rpm


[]s

Marco Modesto.

[21croissants]

In fact, I'd like to recommand strongly to use wine and the Windows installer. It will save you a lot of time with the configuration and the user interface will be nicer

I have put some details on my blog:
http://21croissants.blogspot.com/200...gner-4-on.html

[eracerbit]

Here's a condensed cut-n-paste version =) works great under Ubuntu 7.04 "Feisty"

sudo -s

enter your password

### setting up ###
mkdir ~/dbdesigner-install
cd ~/dbdesigner-install

### downloading rpm packages ###
wget http://213.115.162.124/external/DBDesigner4/DBDesigner4-0.5.4-0.i586.rpm
wget ftp://fr2.rpmfind.net/linux/sourceforge/s/sk/skychart/libborqt-6.9.0-1.i386.rpm
wget ftp://ftp.pbone.net/mirror/ftp.turbolinux.com/pub/TurboLinux/stable/tested/Workstation/7/i586/MySQL-shared-3.23.58-8.i586.rpm

### installing alien ###
apt-get install alien

### converting rpm packages to deb packages ###
alien *.rpm

### installing deb packages ###
dpkg -i *.deb

### creating links to libraries and executable ###
cd /usr/lib
ln -s DBDesigner4/libsqlmy.so
cd /usr/bin
ln -s /opt/DBDesigner4/DBDesigner4 dbdesigner

### exiting root and starting dbdesigner ###
exit
dbdesigner & sleep 5 && killall dbdesigner

### editing user config ###
cd ~/.DBDesigner4
sed s/libmysqlclient.so$/libmysqlclient.so.10/ DBConn_DefaultSettings.ini > temp
cp temp DBConn_DefaultSettings.ini && rm temp

### all done, running dbdesigner ###
dbdesigner

Here's whats going on: We download the dbdesigner rpm, the borland qt rpm, and the mysqlclient 10 rpm, use alien to convert them to deb packages, and install the deb packages. Then, we make some symlinks and run dbdesigner to let it set up some config files, kill it, and then edit the config files. Fun!