MYSQL Unixtime to US Date Format

MySQL Unixtime to US Date Format
You can format your Unix formatted date straight from the MySQL database and here is the query that will allow you to do so:

select FROM_UNIXTIME(U.signup_date, '%m/%d/%Y %h:%i:%s') as time  from YCSOFTWARE_TBL

Server refused our key UBUNTU Solution

Server refused our key UBUNTU

After spending the last two hours working on this issue, I though it would be a good idea to post a solution.

Most online tutorials only refer to ssh_config instead of sshd_config.
Ubuntu SSH has two config files: ssh_config and sshd_config
#cd /etc/ssh/ reveals the following:

SOLUTION

I was making my changes to ssh_config but the active config file is sshd_config.

Do not forget to reload ssh after changing the sshd_config file.

sudo service reload ssh

If it is still not working :

Move your key to a different location.

Now why in the blue world do we have two SSH config files in UBUNTU.
Any idea?

Useful references
http://www.howtoforge.com/ssh_key_based_logins_putty
http://adamwright.wordpress.com/2011/05/16/ssh-error-server-refused-our-key-and-how-to-fix-it/

Learning GIT Useful Sites

Pro Git Book 
http://progit.org/book/ 

Set up Git 
http://help.github.com/win-set-up-git/

Git tutorials
http://www.vogella.de/articles/Git/article.html
http://schacon.github.com/git/gittutorial.html
http://learn.github.com/p/intro.html

Git Cheat Sheet
http://byte.kde.org/~zrusin/git/git-cheat-sheet-medium.png

Git Reference
http://gitref.org/

SSH and Git
http://inchoo.net/tools-frameworks/how-to-generate-ssh-keys-for-git-authorization/

Setup Git Server
http://fclose.com/b/linux/366/set-up-git-server-through-ssh-connection/

Install Git on Eclipse
http://www.vogella.de/articles/EGit/article.html

Remote repos
http://wiki.eclipse.org/EGit/User_Guide/Remote

Multiple ssh key (authorized_keys)
http://ycsoftware.net/ssh-using-public-key-useful-sites/


key Passphrases
http://help.github.com/ssh-key-passphrases/

Msgit Illustrated guide
http://nathanj.github.com/gitguide/tour.html