Posts By: jonny

SSH Socks Proxy for Web Browsing Private Network

We were configuring OpenStack on a private 192.168 network and needed to use a web browser to browse to the OpenStack dashboard. The quickest easiest way to do that is by:

From the ssh manpage: -D Specifies a local “dynamic” application-level port forwarding.  This works by allocating a socket to listen to port on… Read more »

SSH config for SSH Proxy Hopping

I regularly need to connect to SSH hosts behind a firewall via a single SSH host with SSH access enabled. Since I am connecting to many hosts through this proxy SSH host I can make my life a little easier by adding some entries to my ~/.ssh/config file: If I add the following:

I… Read more »

MySQL: Give a User Grant Permissions

I needed to create a new MySQL user that would be able to create new users itself and grant permissions to the accounts that it creates. To do so I used the following:

   

Linux Mint 64-bit and Steam

I had the following error message on Linux Mint when trying to play a new game:

Solved by installing the 32-bit libtxc as follows:

 

Linux GPS Logging Data

I took part in a swim this weekend – The Battle of Carlingford Lough. My friend Cormac gave his Panasonic Lumix camera to Mary in the kayak and set the camera to log GPS data. He sent me the GPS log file and I opened the log file with BT747 – a Java application that… Read more »

1and1 Overcharging for Backups

So back in November 2013 1and 1 contacted me to tell me they would be physically moving my server from one data centre to another: In the email on the 3rd November they advised signing up for 1and1 Professional Backup. They advised that the backup service would be free for two months and would automatically… Read more »

Browsing the GitLab Omnibus Postgres Database

phpPgAdmin

After installing GitLab Omnibus edition I wanted to take a look at the database tables. To do so I installed phpPgAdmin (available in the EPEL repo):

I created a user in Postgres for use with phpPgAdmin:

If you have problems running the psql command you may want to specify the the unix socket… Read more »

Restricting SSH Logins to LDAP Group

The are multiple methods of doing this including using pam but I settled for the following: In the /etc/ssh/sshd_config file I currently have:

to check for ssh keys for the user logging in and I also have password authentication disallowed. The content of the file /usr/libexec/openssh/ssh-ldap-wrapper was simply:

I amended it to:

Read more »