Ubuntu - Install php5, mysql, apache2, ssl, pdo & pdo_mysql

Warning, this post is not yet complete

How to install dbdesigner4 for ubuntu.

Firstly, thanks to the following sites for resources

I am running Ubuntu 7.x.

I am going to setup DBDesigner4.

 

Step 1 > Downloading the Database Designer (DBDesigner4)..

For a good quality database gui designing tool for mysql, i recommend you go to the fabfoce website and download DBDesigner4 ..

http://www.fabforce.net/products.php

Step 2 > Extract the files..

As per the dbdesigner website..

ntom@localhost:~$ tar xzvf DBDesigner4.0.5.4.tar.gz

 

Change into the DBDesigner dir.. 

ntom@localhost:~$ cd DBDesigner4/

 

Now the instructions on the DBDesigner4 website say you just do ./startdbd.sh however, there is no such file in the package installed on my machine.

Also if you try just plain old ./startdbd it says starting.. but never actually does. Logically you then try ./DBDesigner4 and this is when you get..

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

 

Step 3 > Fixing the kylixlibs issue..

Firstly, if you have tried downloading the .deb and have failed, so did i.. this is the solution (thanks to heimo

  • Download kylixlibs3-borqt-3.0-2.tar.gz from here http://kylixlibs.sourceforge.net/down.html
  • extract and install
  • tar xzvf kylixlibs3-borqt-3.0-2.tar.gz
  • cd kylixlibs3-borqt
  • sudo ./install.sh

    •  

    I then did.. 

    	sudo updatedb
	locate kylix

     

    ..and ensured its in the /usr/lib/kylix3/ dir, and then did.. 

    	sudo ldconfig

    Step 4 > libsqlmy.so ..

    Then i was getting a error everytime i tried to load the dbdesigner and connect to the database, sayign: Unable to load libsqlmy.so

    I read on the ubuntu forums, about dbdesigner having issues with libmysqlclient.so.15 which is what i have, and yet its okay with .so.10 .. so i did the following..

    	wget ftp://ftp.pbone.net/mirror/ftp.turbolinux.com/pub/TurboLinux/stable/tested/Workstation/7/i586/MySQL-shared-3.23.58-8.i586.rpm
	apt-get install alien
	alien *.rpm
	dpkg -i *.deb

    .. to be continued..

     

    The end

    I hope this has been helpfull to many people out there. I hope it has saved people endless hours looking at different sites for different aspects of this tutorial.

    Please be sure to leave some comments :)