All of a sudden 3G connection is gone for 3 days straight now… currently connecting via EDGE reliable but slow, and manage to update this site and side notes.

We can do this using OpenSSH if you have a Linux machine or Mac then by no means you already have it in your system. This article focus primarily in using OpenSSH via Windows machine, I just included the Cygwin to do this but it can also be done by using Putty alone.

So to start with, lets define what do we mean:

* Client: the system one types directly on, such as a laptop or desktop system.

* Server: anything connected to from the client.

Some precautions don’t allow your root account to do this, you can always run sudo command to perform administrative task. To do this of just add a user to the wheel group in Linux system to allow them to become
sudoers.

Let’s begin:

1. Run Cygwin in your command prompt then check the version of OpenSSH installed in your system:
by by typing $ ssh -V

2. Run ssh-keygen to generate the private/public key pair if you are in Windows then it will save the copy of the keys under the account you are using in C:/Documents and Settings/Your_Account/.ssh/id_rsa (for the private key file) and id_rsa.pub (for the public key file)

3. Upload your public key in the server by typing $ scp ~/.ssh/id_rsa.pub server.example.org
then set up the public key in your server

4. To do this create an .ssh directory in your folder in the server. This ~ symbol is an alias for your home directory

4.1 – server$ mkdir ~/.ssh >>> this creates a hidden .ssh directory in your home folder

4.2 – server$ chmod 700 ~/.ssh >>> make sure to set the file permission to 700

4.3 – server$ cat ~/id_rsa.pub >> ~/.ssh/authorized_keys >>> authorized your keys

4.4 – server$ chmod 600 ~/.ssh/authorized_keys >>> then set the file permission to 600 sometimes ssh will refuse connection if the file permission is too loose this is also useful to make sure to make sure that you are the only one who have access to your keys.

4.5 – server$ rm ~/id_rsa.pub >>> remove the copy of your public key from your home folder.

Then everything is ready lets test our connection if you do it correctly:
in cygwin type $ ssh username@example.com -p 22 then it will prompt for your pass phrase. You can put a blank pass phrase but that is not advisable.

If that is working let’s setup putty to login automatically

1. Open Puttygen then load your private key file it will prompt you for your pass phrase save this as id_rsa.ppk, ppk us the default filename for putty’s private key file.

Loading Private key

2. Next Open Putty pageant and load your private key file to achieve automatic login via putty.

Load Key

3. In putty set up your session by typing the details of your server then go to SSH and select Auth browse for your private key file generated by puttygen and load it save this session profile before connecting.

Putty Profle

4. If you do it correctly then you will get this login prompt when connecting to your server:
First it will ask you of your username, and after typing it will automatically log you in using your generated keys for authentication.

For the back office users it provides them of automatic alert notification that a transaction has been requested by a user and an action is required for them to process the users request by assigning the type of vehicle requested and the driver assigned to fetch the user. A copy of the vehicle assignments is sent to the user including the type vehicle requested, the color of the vehicle, the plate number and the name of the driver assigned which makes all transaction fully automated.

If you are interested in the product you may contact them for your orders and they are very willing to discuss how your company will greatly benefit from an online presence provided by them. You may find the demo here: http://www.cabsites.co.uk and the actual booking system here: http://booking.cabsites.co.uk

Here’s what I did to connect successfully to TheChaw repository, I use the GIT Extensions which can be found here: GIT EXTENSIONS I also use putty from the putty project download the complete package.

Create an SSH Key using Puttygen I use SSH-2 RSA 1024, save your private and public key to any directory. Make sure to enter a key phrase if you want to change it and also to secure it.

Copy your OpenSSH key (its the key that says: Public key for pasting into OpenSSH authorized key files) from your puttygen screen logged in to your account at the chaw repository http://thechaw.com and paste your SSH key in the field for the GIT in your account.

To register your public key open pageant and select add key. Browse for your private key file that you generated using puttygen. Install your GIT Extensions and put this in the path in your environment variables by selecting the control panel >>> system >> advanced>>>path>>> selecte edit and add it as your last entry then save GIT_SSH=C:\Program Files\PuTTY\plink.exe.

To register thechaw.com in your registry open putty and type in the hostname as thechaw.com port 22 select SSH and click open. It will now prompt you to save the server fingerprint in your registry just go ahead and accept it.

Now you’re ready to clone the repository, open GIT EXTENSIONS and click clone existing repository make sure that you load your private key file again in putty pageant supply your local directory and hit clone and you’re good to go.

If something else is wrong just trace your steps again and it should work.

Look for this line : #Comment the following if you are using InnoDB tables
skip-innodb >>> change this line to this #skip-innodb and uncomment all that pertains to innodb. See the code below. Restart your MySQL and you are set to go.

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = “D:/xampp/mysql/”
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = “D:/xampp/mysql/”
innodb_log_arch_dir = “D:/xampp/mysql/”
## You can set .._buffer_pool_size up to 50 – 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50