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

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 $> ssh-keygen Start ssh agent $> ssh-agent /bin/bash Add ssh key $> ssh-add ~/.ssh/id_rsa List all used ssh keys $> ssh-add -l Show public key $> cat ~/.ssh/id_rsa.pub Copy key to remote host via ssh $> ssh-copy-id -i id_rsa.pub ssh-user@host.domain If ssh-copy-id isn’t available on the respektive system, you can use the […]