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 …
Kategorie-Archive: Allgemein
Improving the click to deploy solution for WordPress on Google Cloud Platform
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
JWT implementation details
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 …
Tricks for ProxMox VE
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 …
Extract JSON attributes as columns in MySQL
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 …
Using imapsync to migrate mailboxes
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 …
WordPress upload permissions
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 …
Upgrading an application on Elastic Beanstalk from Amazon Linux 1 to 2
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
Magento and timezones
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 …
Today i corrupted MySQL…here’s how
If you want to change MySQL setting innodb_log_file_size to improve performance the top answer on stack overflow says you have to delete the redo log in /var/lib/mysql/ib_logfile* so that MySQL creates it with the new size. Before deleting you obviously shutdown mysql. But a normal shutdown of MySQL is a fast shutdown which might leave …