Tunnel MySQL through SSH

Recently I had the challenge, that the MySQL database of one of the Magento shops I maintain wasn’t accessible directly through the Net. The access was restricted to the Webserver only. So I had to tunnel MySQL through SSH. And that worked like that: edit the ssh config (~/.ssh/config) on the remote Webserver

create  […]

Homefolder permissions bug ISPConfig

Today I ran into a still open bug of ISPConfig (ISPConfig 3.1.3 under Debian Jessie). The problem occurred, when I tried to clone a BitBucket repository with a non root SSH-user in his own website root (where permission rights generally should be no problem). Hence I wanted to use key-based authentication for BitBucket, I generated […]

SSH key authentication

Generate ssh key

Start ssh agent

Add ssh key

List all used ssh keys

Show public key

Copy key to remote host via ssh

If ssh-copy-id isn’t available on the respektive system, you can use the following snipped:

Add permanent usage of key (SSH Client Configuration) You can […]