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 a ssh filesystem 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 […]

GIT – reconnect remote branch

Sometimes it is necessary to remap a local git  branch to a remote one (reconnect remote branch). For me it was the case, because I accidentally removed all origins in a multi-origin setup. Hence I got the following error message when trying to pull without naming remote and branch, although I re-added and fetched all […]

Save The Day for Magento Functional Testing Framework Webinar

Yes! A new webinar about the new release of the Magento Functional Testing Framework for Magento2 is coming up. So you should register yourself right now, save the date and join the session on Tuesday, February 27, 2018 – 6:00 p.m. (Europe/Berlin). Further information can be found here: https://magento.com/resources/magento-functional-testing-framework

All-inkl.com DDNS for Synology NAS

Recently I had to setup DDNS for my parents DS212+ DiskStation from Synology. I have an all-inkl.com hosting package including a dynamic DNS feature (DDNS under tools): The problem was to get the right settings for the Synology box. Solution for the DDNS problem I found the solution in this blog article: http://www.pflipsen.net/2015/12/21/all-inkl-com-ddns-auf-der-synology-diskstation-einrichten/ I saved […]

Plesk – get information about aliases

To get a list of all existing aliases defined for the respective system, you can connect to the MySQL database of Plesk as admin via key file:

Afterwards you can get a list of all aliases by the following select statement:

This will give you something like that:

To get more information about […]

OpenSource file sharing with pydio dataware

Just discovered pydio (https://pydio.com). I didn’t now this nice little file sharing tool before. A partner of my agency uses this OpenSource application to share files with customers and partners. It looks very nice, is responsive, provides native apps for iOS and Android, file synchronization over all platforms, flexible access control list (ACL) and is […]