Error message

Deprecated function: implode(): Passing glue string after array is deprecated. Swap the parameters in drupal_get_feeds() (line 394 of /home1/tylerfra/public_html/includes/common.inc).

Ubuntu Cheat Sheet

tyler's picture
Submitted by tyler on Thu, 04/28/2011 - 10:07
Updated: 2011-11-09
Category: 
Code
Tags: 
ubuntu

SSH TUNNEL

Example 1 - MYSQL Query Browser

# open up the local (L) port 4000 (this is just a random port, you can pick others) on localhost and
# tunnel it to port 3306 on 123.456.789.101, without an interactive terminal (-N)

ssh -L 4000:localhost:3306 123.456.789.101 -N

# then in 'mysql query browser' we are able to connect to localhost:4000 with the DB credentials
# required for 123.456.789.101 and it will make the connection to 123.456.789.101's sql server on port 3306

Example 2 - jEdit

ssh -L 12345:localhost:22 123.456.789.101 -N

# then in jEdit we can go to 'Plugins -> FTP -> Open From Secure FTP Server',
# use localhost:12345 as the 'remote host' with our credentials for 123.456.789.101

WGET & TAR

Example 1 - Connect to an SSH server, zip up a directory, download to localhost

# ssh into 123.456.789.101, tarball up the the /www/files directory and untar it to the directory where the terminal command was executed

ssh 123.456.789.101 -e none '(cd /www && tar czf - files)' | tar xzf -