Theatons Blog

http://www.youtube.com/watch?v=AyqZyacTtcU  - check this out, 6mins 11 seconds

This is so funny

Warning, this post is not yet complete

How to install dbdesigner4 for ubuntu.

Firstly, thanks to the following sites for resources

• Fabfoce 4 download page
• Article on ubuntu forums
• DBDesigner on debian
• Running an application

I am running Ubuntu 7.x.

I am going to setup DBDesigner4.

Read the rest of this entry »

Just a quick tip. today i exported a load of a data from phpmyadmin to excell (excell 2007 in this case) and as usual all the data was as ‘text’ instead of being a ‘number’

Having had a detailed (45min) look around the interweb, i was struggeling, they all mentioned methods of converting text to number one cell at a time or using excell 2003-2006 which was useless really.

Anyway, heres how you do it:

Read the rest of this entry »

Book review of: Eye of the Storm - Twenty fiver years in action with the SAS - Peter Ratcliffe

Overview:
This book is the story of Peter Ratcliffs carrer in the SAS, covering everything from when he was a boy and first joined, Northern Ireland, Dhofar, Prison outbreak in scotland, Falklands, and finally in the Gulf

Read duration:
Somtimes 1 hour per day, somtimes 2, took 1.5 - 2 weeks 434 pages in my copy.

Read the rest of this entry »

Hello person viewing this page

I recently had to use curl on my local ubuntu dev machine and you maybe trying todo so yourself and have found this page by looking for some information on ubuntu, installing / configuring or seting up curl to handle your php requests.

Well heres how i setup curl for ubuntu, and i hope it works for you to:

Then restart apache2 and you should be away, hope this helps.

Book review of: The Infiltrators - Philip Etienne and Martin Maynard

Overview:
This book is the story of 2 undercover police officers and their experiences / stories during the years they worked for SO₁₀

Read duration:
I read about 1-2 hours a day and had it gone within a week

Read the rest of this entry »

Book review of: John Geddes - Highway to hell

Overview:
Book is a collection of John’s experiences during his time as a PMC (private military contractor) working in iraq

Read duration:
I read about 1-2 hours a day and had it gone within a week

Read the rest of this entry »

We set of up Meol Siabod near capel curig in snowdonia on Friday the 29th June 2007. The weather had predicted rain and some of the crew had previously expressed doubts as to weather we’d keep dry during the night. With my gortex bivvy bag, i didn’t care how much it slashed it down, and actually slightly hoped it did so i could enjoy watching the rest of them suffer

Having previously planned to go up on the saturday, we ended up going on the friday in a last minute thing to hopefully try and beat the rain. Tom Eaton was under the impression we were off camping in a car park, hence bringing his guitar…etc

Here is Tom Eaton carrying his monstrous load before we set off up the mountain.

Read the rest of this entry »

Having been trying to deal with icom web over at shrewsbury now for the past 3-4 weeks, i have found them highly unprofessional, disorganized and rude. Down with icom web in shrewsbury !
The story goes like this. .

Read the rest of this entry »

I recently tried SUSE enterprise 10 and although i found the GUI absoloutly excellent, wireless support and sound card support was such an effort to get working, i have come back to good ol’ ubuntu. The classic linux distro where stuff seems to ‘just work’.

The following is meant to be a tutorial for setting up a basic webserver on your ubuntu desktop.

Installation instructions / How to setup PHP5, Mysql, Apache2, SSL, Mod_rewrite, pdo and pdo_mysql

Overview / Index

The reason i have put this together, is so people don’t have to search for multiple things, and can find all the essentials here

• Install Apache2
• Install MySql 5
• Install PHP 5
• Install PHPmyadmin
• Install SSL certificate for apache
• Install PDO & PDO_Mysql

I am running Ubuntu 7.10 and fresh installation (about 10 mins ago).

I am going to setup Apache2, PHP5, MySQL, SSL, PDO loading the PDO_MySQL driver. This document is ment to help people who struggle with any of these and provide a bit more of a ‘one stop shop’ to anyone trying to set these services up.

Step 1 > Apache2

ntom@localhost:~$ sudo apt-get install apache2

Incase you need to, you can find how to add extra repositories here

Step 2 > MySQL 5

ntom@localhost:~$ sudo apt-get install mysql-server libmysqlclient15-dev

Step 3 > PHP5

ntom@localhost:~$ sudo apt-get install php5 php5-common libapache2-mod-php5 php5-gd php5-dev curl libcurl3 libcurl3-dev php5-curl

Step 4 > PHPMyAdmin

ntom@localhost:~$ sudo aptitude install phpmyadmin

At this point, you should be able to go to http://localhost/ and see your webserver is now up and running.
You should also now see a folder called ‘phpmyadmin‘ which if you click on, and enter ‘root’ as the username, leave the password blank, and login, will give you access to your mysql db’s.

Step 5 > SSL certificate for Apache2

ntom@localhost:~$ sudo apache2-ssl-certificate

If you get back that it can’t find apache2-ssl-certificate .. then not to worry, this is a known bug, and please read my comment at the bottom.. direct link to the comment click here

Answer the questions

ntom@localhost:~$ sudo a2enmod ssl

This enables the ssl mod for apache2

ntom@localhost:~$ echo "Listen 443" | sudo tee -a /etc/apache2/ports.conf

ntom@localhost:~$ sudo ln -s /etc/apache2/sites-available/ssl /etc/apache2/sites-enabled/ssl 

ntom@localhost:~$ sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/ssl

To understand more about sites-enabled, sites-available click here

ntom@localhost:~$ sudo gedit /etc/apache2/sites-available/ssl

Select All (crt+a), delete, then paste in this:

NameVirtualHost *:443

<virtualhost *:443>
        ServerAdmin webmaster@localhost

        SSLEngine On
        SSLCertificateFile /etc/apache2/ssl/apache.pem

        DocumentRoot /var/www/
        <directory />
                Options FollowSymLinks
                AllowOverride None
        </directory>

        <directory /var/www/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
                # This directive allows us to have apache2's default start page
                # in /apache2-default/, but still have / go to the right place
                # Commented out for Ubuntu
                #RedirectMatch ^/$ /apache2-default/
        </directory>

        ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
        <directory "/usr/lib/cgi-bin">
                AllowOverride None
                Options ExecCGI -MultiViews +SymLinksIfOwnerMatch
                Order allow,deny
                Allow from all
        </directory>

        ErrorLog /var/log/apache2/error.log

        # Possible values include: debug, info, notice, warn, error, crit,
        # alert, emerg.
        LogLevel warn

        CustomLog /var/log/apache2/access.log combined
        ServerSignature On

    Alias /doc/ "/usr/share/doc/"
    <directory "/usr/share/doc/">
        Options Indexes MultiViews FollowSymLinks
        AllowOverride None
        Order deny,allow
        Deny from all
        Allow from 127.0.0.0/255.0.0.0 ::1/128
    </directory>

</virtualhost>

Then we need to change the default file, so…

ntom@localhost:~$ sudo gedit /etc/apache2/sites-available/default

and make sure the following lines say this:

NameVirtualHost *:80
<virtualhost *:80>

&nbsp

You may also want to enable mod_rewrite.. todo so, follow the following steps:

ntom@localhost:~$ sudo a2enmod rewrite

You will also need to edit sites-available default, and ssl:

sudo gedit /etc/apache2/sites-available/default

And the same again for the ssl file.
Here you will need to change the section which says ‘AllowOverride None’ to:

AllowOverride All

Now restart apache

ntom@localhost~: sudo apache2 -k restart

Step 6 > PDO & PDO_MySql

First, we need to install PEAR, so…

sudo apt-get install php-pear

If you get anything about warning, ‘phpize’, this means you need php-dev, or if your using sypantic package manager, ‘php5-dev’.

sudo pecl install pdo

This installs pdo.

The next thing you want todo is install the pdo_mysql drivers. Do this by doing the following:

sudo pecl install pdo_mysql

If however you get a error somthing along the lines of:

checking for MySQL support for PDO... yes, shared
checking for mysql_config... not found
configure: error: Cannot find MySQL header files under
ERROR: `/tmp/tmpRiQ5ax/PDO_MYSQL-1.0.2/configure' failed

Then you should download and install the following packages:

sudo apt-get install libmysqlclient15-dev

and then try to re-install pdo_mysql.

Once this is finished and sucessful (it was for me), its best to then run the following code:

sudo updatedb
sudo gedit /etc/php5/apache2/php.ini

Inside the php.ini, at the bottom, add the following lines:

extension=pdo.so
extension=pdo_mysql.so

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