So you have a setup where Nextcloud runs on a host with internal IP which is exposed to the public network using a reverse proxy like Nginx. Public URLs are not accessible from the internal network due to DNS resolution. Research shows that this setup seems to be quite common. Next you want to integrate …
„Integrating Nextcloud + Collabora behind reverse proxy“ weiterlesen
For device testing a client needed a solution to set devices reliably to a time in the future to trigger certificate renewal and similar processes. We agreed that providing a mock time via a NTP service would be a good solution. One requirement was to have the NTP service run in a Docker container. I …
If you’re using this recipe to run WordPress on a virtual machine on the Google Cloud Platform (GCP) chances are high you’re experiencing problems. Here’s how to solve them. My example is a customer’s website running on a small instance of type e2-small. This instance only has 2G of RAM and 2 vCPUs. Main problem …
„Improving the click to deploy solution for WordPress on Google Cloud Platform“ weiterlesen
I recently implemented JWT (JSON Web Token) based auth on an embedded device using nginx with embedded Lua. Following are implementation details. refresh and access token are created as JWT (signed with variable JWT_SECRET) refresh token is delivered as cookie and stored on the client. It is valid for 24hrs only for path /jwt/refresh. access …
Free repo for testing servers To get updates for your testing servers running ProxMox VE you can use following repo which is not meant for production use but works well for testing purposes. Just add the following lines to /etc/apt/sources.list: Uncomment the enterprise repo in /etc/apt/sources.list.d/pve-enterprise.list and run apt-get update afterwards. You can now run …
So you have been lured into storing attribute data as JSON in your MySQL to avoid defining a proper schema from the beginning. Well, now for some report you need a certain attribute as column. Here is how to solve this task. We have following simplified schema: With data as in following example: We may …
Recently i had to migrate some mailboxes from one imap server to the other. After a bit of research into tools for imap migration running on Linux i decided to use imapsync. It has all the relevant features and is maintained. Running it showed that it tries to do the right things by default. As …
Here you find a quick fix for a wordpress problem i found nowhere written: I have a wordpress instance running on shared hosting which requires having group read bit set in permissions of uploaded files to be readable by the web server. But uploaded files were set to 0600 instead of 0640 and were thus …
These days i have the pleasure to upgrade an application running on AWS Elastic Beanstalk from platform Multi-container Docker to new platform Docker. The former is based on Amazon Linux 1 (AL1) while the latter runs on Amazon Linux 2 (AL2). I follow this guide. I have encountered the following advantages so far: links between …
„Upgrading an application on Elastic Beanstalk from Amazon Linux 1 to 2“ weiterlesen
Today i had the issue that after dumping and importing a Magento Database from one instance of MySQL into another one the order dates got transported 2 hours into the future. How come?!? Investigation and testing showed that the source database was running with timezone „GMT“ aka „UTC“ aka +00. The target database was running …