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  […]

Mount ssh filesystems under Linux or how I mounted my webspace into my root server

Today I had to mount a ssh filesystem under Linux. The reason was, that I had the perception that I would be a very cool idea, to use my old webspace package from all-inkl.com, that I only kept because of the 10 included domains, as a backup storage for my root server.The plan was to […]

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 […]