-
Calculating total value from InfluxDB streams
The energy data in my home is collected using Shelly devices. For the total power consumed in the house, I’m using the Shelly 3EM 3-Phase Energy Meter. Data points are pushed to a Mosquitto MQTT server and imported into InfluxDB using Telegraf. Finally, the data is displayed in a Grafana dashboard. The entire setup will…
-
Setting up a WIFI hotspot in Windows 7,8,10
netsh wlan set hostednetwork mode=allow ssid=yourssid key=YourWifiSecret netsh wlan start hostednetwork
-
Redirecting Apache HTTP to HTTPS
Now that everyone can enjoy and use free SSL certificates from Let’s Encrypt, let’s all encrypt! To forward HTTP requests to secure HTTPS, there are multiple options. If you’re using some kind of panel to edit Apache configuration (like ISPConfig) that does not allow to edit the virtual host for HTTP separate from the virtual…
-
Restore trashed mails from dovecot maildir
To remove the “T”rashed flag from mails in a maildir, the files need to be renamed. I have also created a script which can be executed in the Maildir, searching for files and renaming the files: https://gist.github.com/mattanja/1367bc04750dd105317f
-
automysqlbackup – Backup databases on server
The easiest way that I have found for an advanced backup of all databases on a web hosting server was using the automysqlbackup tool. By default the tool creates backups with automatic daily, weekly and monthly rotation. The backup files are being compressed and will be placed into your configured backup folder. Email notifications and a…
-
Must-have software tools (2014!)
I’m starting to build my list of software that is the first to install on a new system: Multi-platform: Sublime text – currently the best text editor around (multi selection editing, yay!) Synergy – using one mouse/keyboard for multiple systems/screens (Windows notebook next to Linux desktop) Git (git package, msysGit, Posh-Git, Github for Windows) Windows: Cmder – finally a really…
-
Don’t use magic numbers
Quick note to start a new category on this blog: Good practices/Training Everyone who doesn’t know what a “Magic number” in coding is, please quickly read this: http://stackoverflow.com/questions/47882/what-is-a-magic-number-and-why-is-it-bad In some rare cases it might be allowed to use magic numbers (like 0/1 or in a circles calculation you may use 90/180/270/360 if it is clear…
-
OpenWRT on TP-Link TL-WDR4900
My wifi connections at home have been really slow using a really old AVM Fritz!Box, so I decided to upgrade to a TL-WDR4900. (The only thing still missing is 802.11 ac but the cheapest router providing that would be the Asus RT-AC66U AC1750 for twice the price of the TL-WDR4900, so that wasn’t worth it for me.)…
-
Groupware options for small companies or organizations
(tbd – work in progress… Advice welcome…) Over the last weeks and months I’ve had multiple people asking for advice about groupware software. For me that is still kind of an open issue and I’m not sure what the best answer would be. These are the options I know and would consider using at this…
-
Install rails >=1.9.3 on Ubuntu 12.04 (for Redmine) with RVM
Quick reference on installing specific versions of rails on an “older” version of ubuntu without the need of having all packages in the ubuntu repositories. After doing so, you can continue to install redmine as described in http://www.redmine.org/projects/redmine/wiki/RedmineInstall This will fail if the environment is not set correctly – this helped me a lot: http://stackoverflow.com/questions/12127603/usr-bin-env-ruby-noexec-wrapper-fails-with-no-file-or-directory…