No Manual Entry

In case you have an Ubuntu Server as your Virtualbox Guest you won't be able to copy&paste from/to the Host. Even if you install the Guest Additions, due supposely to the fact that the Clipboard integration relies on having a running X server in the Guest.

Set up the Guest Network:

Go to menu Machine > Settings... > Network > button Advanced > button Port Forwarding

Specify a name, the Host address (ie 127.0.1.1) and port (2222), and the Guest address (ie 10.0.2.15, or whatever it is) (run ifconfig from a console in the Guest to know which one), and the port where the SSH server is running in the Guest (ie 22)

Then, from the Host, you can do:

Supose you want to rsync files to a server listening on port 2222. Then:

Install the UNIX-ODBC tools:

$ sudo apt-get install unixodbc unixodbc-dev freetds-dev tdsodbc freetds-bin

$ sudo vi /etc/freetds/freetds.conf

[ODBC_DSN] host = «THE IP OR THE SERVER NAME» port = 1433 tds version = 7.0 client charset = UTF-8

Test the connection works:

$ tsql -S ODBC_DSN -U «USER» -P «PASSWORD»

You will see a 1> prompt if the connection succeeded.

Define the driver:

$ sudo vi /etc/odbcinst.ini

[FREETDS_DRIVER] Description = "FreeTDS DRIVER" Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so

Define the Datasource name (DSN):

$ sudo vi /etc/odbc.ini

[ODBC_DSN] Description = "The description for your ODBC database connection" Driver = FREETDS_DRIVER Server = «THE IP OR THE SERVER NAME» Port = 1433 Database = «DATABASE»

Connect to the database and start querying:

Supose you want to reach the server on 199.199.199.199 at port 22 (the firewalled server) from your workplace where you don't have access to that server. On the other hand, you have access to 199.199.199.199 from the server at 200.200.200.200 which you can access from your workplace (the accessible server).

You can make a SSH tunnel so that you'll be able to access the server at 199.199.199.199 at port 22

Execute the command below in the accessible server:

ssh -f -L 0.0.0.0:3333:199.199.199.199:22 200.200.200.200 -N

-f Requests ssh to go to background just before command execution.

-L [bind_address:]port:host:hostport Specifies that connections to the given TCP port (3333) on the local host (accessible server) (0.0.0.0 tells ssh to bind to all interfaces) are to be forwarded to the given host and port (firewalled server) (199.199.199.199 and port 22), on the remote side.

-N Do not execute a remote command.

(I always forget the right syntax)

Use this from the command line:

-Dhttp.proxyHost=127.0.0.1 -Dhttp.proxyPort=8080 -Dhttps.proxyHost=127.0.0.1 -Dhttps.proxyPort=8080

Or programmatically:

Use this:

$ iwgetid -r

Or this:

Disable the account NOW (replace 1 with a YYYY-MM-DD date if you want to disable the account on a specific date)

# usermod --expiredate 1 USERNAME

Additionally, you can lock his password (note that this does not prevent the user to still login using SSH keys)

To allow the use of wget or other command line tools with Burp Proxy when calling SSL pages you have to trust the Burp certificate.

Proceed doing:

Go to   the Proxy tab in Burp   the subtab Options   click on the CA Certificate... button   and export Certificate in DER format

Then:

# In the Debian/Ubuntu local store $ openssl x509 -in burp.der -inform DER -out burp.pem -outform PEM $ sudo chown root:root burp.pem $ sudo chmod 644 burp.pem $ sudo cp burp.pem /usr/local/share/ca-certificates/ $ sudo c_rehash # In the system store $ cd /etc/ssl/certs/ $ sudo ln -s /usr/local/share/ca-certificates/burp.pem $ sudo c_rehash .

Create a $HOME/.pgpass file:

*:*:*:username:secret

Make it readable (400) or read-write (600) only for you:

$ chmod 400 $HOME/.pgpass

If you ever see this annying message:

perl: warning: Setting locale failed. perl: warning: Please check that your locale settings:     LANGUAGE = (unset),     LC_ALL = (unset),     LC_TIME = "en_GB.UTF-8",     LC_MONETARY = "en_GB.UTF-8",     LC_ADDRESS = "en_GB.UTF-8",     LC_TELEPHONE = "en_GB.UTF-8",     LC_NAME = "en_GB.UTF-8",     LC_MEASUREMENT = "en_GB.UTF-8",     LC_IDENTIFICATION = "en_GB.UTF-8",     LC_NUMERIC = "en_GB.UTF-8",     LC_PAPER = "en_GB.UTF-8",     LANG = "en_US.UTF-8"   are supported and installed on your system. perl: warning: Falling back to the standard locale ("C"). locale: Cannot set LC_ALL to default locale: No such file or directory

Fix it doing: