Thursday, March 12, 2009

在Ubuntu上面安装DBDesigner4

在windows上面用了DBDesigner4了以后,感觉很好用,于是今晚费了一些时间给我的Ubuntu也安装了一份,Ubuntu上面安装比较麻烦,根据不同的电脑,具体步骤可能不一样,这里把我做的步骤列下来供以后参考(我的机子上面已经安装了mysql server和mysql client)

第一部当然是让DBDesigner能够跑起来:
  1. Go to http://www.fabforce.net/downloads.php to download file DBDesigner4.0.5.4.tar.gz, unpack it.
  2. run ./stardb, then view log file at ~/.DBDesigner4/DBD4.log to check what are the library missing (libXft.so.1, libstdc++-libc6.2-2.so.3, libqt.so.2)
  3. libXft.so.1 : ln -s /usr/lib/libXft.so.2.1.2 /usr/lib/libXft.so.1
  4. libsdc++-libc6.2-2.so.3 : Go to http://packages.ubuntu.com/zh-cn/gutsy/libstdc++2.10-glibc2.2 to download the library  file and install
  5. libqt.so.2: Go to http://prdownloads.sourceforge.net/kylixlibs/kylixlibs3-borqt-3.0-2.tar.gz?download to download the package, then unpack, then

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

    • cd DBDesigner4/Linuxlib

    • sudo rm libqt.so.2

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


第二步就是让DBDesigner能够顺利连接MySQL

  1. Go to http://www.devart.com/dbx/download.html to download dbExpress MySQL driver for linux, unpack,  sudo cp libsqlmda.so.4.40 /usr/lib/
  2. Under folder DBDesigner4/Linuxlib, do

    • sudo rm libmysqlclient.soln -s /usr/lib/libmysqlclient.so.15 libmysqlclient.so

    • rm libsqlmy.so

    • ln -s /usr/lib/libsqlmda.so.4.40 libsqlmy.so
  3. Run ./startdb,
    ”Database”->”Connect to Database”->"New Database Connection"->"Advance"
     Set GetDriverFunc: getSQLDriverMySQL
接下来就是修改stardb.desktop,把里面的路径改一下,然后把startdb.desktop放到桌面就可以了

No comments: