MySQL Admin via SSH Tunnel

Lets create a ssh tunnel into our remote server so that we can connect MySQL Administrator.  This will trick MySQL Administrator into thinking that it has a local connection to the remote machine when it doesn’t.  This is great for getting around having only local MySQL access rights while trying to login from a remote […]

Posted on March 18, 2010 at 8:30 pm by Jordan Carter · Permalink · Leave a comment
In: Server Config, Ubuntu Tricks, Web Development · Tagged with: ,

Can’t Access Github behind proxy or Firewall

Use corkscrew to get through the firewall. You will have to install it from source. website: http://www.agroman.net/corkscrew/ Now edit your ~/.ssh/config file, create it if you haven’t got one. > cat ~/.ssh/config Host gitproxy User git Hostname ssh.github.com Port 443 ProxyCommand /usr/local/bin/corkscrew proxy.example.com 3128 %h %p IdentityFile /home/jordan/.ssh/id_rsa Now use this proxy when cloning git

Posted on March 17, 2010 at 9:45 pm by Jordan Carter · Permalink · 5 Comments
In: Server Config, Ubuntu Tricks, Web Development · Tagged with: , , , ,

Open remote application window over ssh – X11

You left the office but forgot to leave an application running.  An application that requires it’s GUI, you try to open it via ssh but “Error: Can’t open display” prevents you. Simple fix here, you will kick yourself. DISPLAY=:0 <command> for me this translated into DISPLAY=:0 transmission What this does is instruct the application to […]

Posted on December 29, 2009 at 8:18 am by Jordan Carter · Permalink · 2 Comments
In: Ubuntu Tricks · Tagged with: , , ,