SQLite Browser

I have been looking for a good SQLite Browser and came across this firefox plugin. Makes creating and viewing your SQLite databases straightforward enough

https://addons.mozilla.org/en-US/firefox/addon/5817

Create a Virtual Server with Apache, VMWare and Blue Dragon

This is a brief guide to creating a VMWare Server that runs Centos Linux, PHP, MySQL, BlueDragon on Apache. It also briefly shows how you can run this so that the files being served in apache are running from a windows machine, which makes it perfect for a testing environment.

To begin

Download Centos5 from ThoughtPolice (www.thoughtpolice.co.uk) and unzip the VMWare image file

Load the file in VMWare Player

Once loaded log in username:root password:thoughtpolice
enter 'yum install apache2' (installs apache)
enter 'yum install mysql-server' (installs mysql server)
enter 'yum install php-mysql' (installs the plug ins for php and mysql'
enter 'system-config-securitylevel' (open port for apache www)

Create and share a windows directory called www and create a user on the windows machine called 'linux' with a password of 'linux'

On the virtual server enter 'mkdir /mnt/www' (creates a directory which you will mount the windows share on)

Then enter 'vi /etc/fstab' and add the line at the bottom of the file by pressing '*' then 'a' and adding //192.168.79.1/www /mnt/www rw,user=linux,password=linux 0 0 (the ip address at the front of this line is the ipaddress of the windows computer)

after this enter 'mount /mnt/www' this should mount successfully, if not you may want to check any firewall settings on the windows machine to make sure it will allow access from the ip address of the vmware server. You can check the ip address on a linux computer by entering (ifconfig)

Download the BlueDragon Script from www.newatlanta.com

Copy in the BlueDragon script to install into the windows shared directory you created
browse to the directory you created earlier on the linux machine 'cd /mnt/www' then copy the Blue Dragon script onto the Linux Machine 'cp bluedragonscript /home' make sure the blue dragon script has execute rights 'chmod +x bluedragonscriptname'

Browse to the home directory 'cd /home' and run the script 'sh bluedragonscript'

Accept all the defaults and make sure you select Apache as the option of webserver

Automatic Startup of BlueDragon 'ln -s /etc/rc.d/init.d/BlueDragon_Server /etc/rc.d/rc3.d/K95bluedragon' and 'ln -s /etc/rc.d/init.d/BlueDragon_Server /etc/rc.d/rc3.d/S95bluedragon'

Create a directory for apache conf files 'mkdir /mnt/www/conf' this is where we will hold .conf files for virtual hosting

Give apache access to your folder 'chgrp -R apache /mnt/www'

Start mysql /etc/init.d/mysqld restart

Set a password for mysql '/usr/bin/mysqladmin -u root password 'password'

Make sure mysql starts on bootup 'chkconfig mysqld on'

Make sure apache starts on bootup 'chkconfig httpd on'

Make sure you download the mysql jar odbc connector file from the mysql website. This needs to be copied into the bluedragon lib directory (/usr/local/NewAtlanata/BlueDragon_Server_70/lib) (make sure the correct permissions exist for this file), you can download it into the windows directory and copy it across from the virtual server.

Download phpMyAdmin from http://www.phpmyadmin.net/home_page/downloads.php copy it across into the directory /var/www/html on the virtual server. Then rename the folder to phpMyAdmin.

Should then be able to browse to this at http://ipaddressofvmaware/phpMyAdmin

The username should be root and the password as password as we set above.

Guide : Mount a linux directory from windows

From windows right click on the folder you want to share with your VMWare Web Server and share this as 'www' you will want to create a user and password within windows, I normally run with the username as 'linux' and password as 'linux'

NOTE: NTFS drives are only read only when mounted from Linux, alternatively create a FAT partition and use this so that you can write files to your windows machine from Linux.

Open up your fstab file in linux

'vi /etc/fstab'

then press '*' then 'a' to start editing

add a line at the bottom as follows

share a directory including a username and password for the user

//192.168.79.1/www /mnt/www cifs rw,user=linux,password=linux 0 0

Guide : Change hosts file in windows

Browse to

c:/windows/system32/drivers/etc

open in notepad/wordpad

hosts

add under 127.0.0.1 localhost

ipaddressofvmwareserver webserver(or name of development domain)

reboot windows for changes to take affect

T3G Sierra 580 Wireless Card connecting with Ubuntu 7.04

This guide is for users of Ubuntu Feisty Fawn 7.04 on the Telecom New Zealand network

first plug in your Sierra Wireless 580 T3G Data Card
then install kppp

sudo apt-get install kppp

then start kppp

kppp

click on configure and add a new account call it 'telecom', add the phone number as '#777' and the authentication as 'PAP'.

Then add a new modem call it 'telecom' and select '/dev/tty/USB0'.
You are now ready to connect the username is 'mobile@jamamobile' (same for all users) and the password is 'telecom'(same for all users) and click on connect

Connect to a remote NFS Server

Enter the following commands on the server you want to share

sudo gedit /etc/exports

Then enter the following replacing the ipaddress I have below with your own, you can remove the last digits of your ipadress an replace with a 0 for anyone to access from that ip range

/pathtoshare 172.16.197.0/255.255.255.0(ro,sync)

Reload the Exports File

sudo exportfs -r

On the client machine set up a directory up to mount to

sudo mkdir /mnt/www

Then edit your fstab file

sudo gedit /etc/fstab

and add

172.16.197.1:/pathtoshareremote /pathtosharelocal nfs rsize=8192,wsize=8192,timeo=14,intr

Guide : Installing Skype on Ubuntu Feisty

sudo gedit /etc/apt/sources.list

add the following line

deb http://download.skype.com/linux/repos/debian/ stable non-free

sudo apt-get update

sudo apt-get install skype