online since 1994 https://heikkisiltala.net/wiki/ 2026-04-05T10:28:22+00:00 https://heikkisiltala.net/wiki/ https://heikkisiltala.net/wiki/_media/wiki/logo.png text/html 2023-02-17T21:33:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/dokuwiki_notes_and_tricks?rev=1676669608&do=diff Dokuwiki notes and tricks Latest update 2023-02-17. My preferred template My preferred DokuWiki template is Bootstrap3. This site is using theme Cosmo. I also like United theme a lot. Before switching to Bootstrap3 I used to use Typowiki template. Automatic UI language selection based on URL * Installed languages: en, fi text/html 2023-09-22T21:31:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/one_disk_nas?rev=1695418296&do=diff Creating a small NAS server based on OpenMediaVault The initial version written 2020-07-15. Latest update 2020-08-01. See a separate page for long-term impressions. My goal was to create a small and simple network attached storage (NAS) server to serve as a file sharing server between devices connected to home network. The performance requirements for this system were low. I wanted to file storage to be encrypted. text/html 2023-02-24T21:59:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/inside_sotkanet?rev=1677275965&do=diff Inside SOTKAnet This article was written in 2005. SOTKAnet indicator bank is a public accessible web information service that publishes detailed information on well-being and health in Finland. SOTKAnet was launched by STAKES, the National Research and Development Centre for Welfare and Health, on Monday 14th March 2005 at text/html 2023-10-11T17:51:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/mixing_static_and_dynamic?rev=1697046717&do=diff Building a website mixing static and dynamic techniques An ongoing writing process. Started 2021-07-12. Latest update 2023-10-11. From where do we start I'm a content creator, maintainer, developer and webmaster of a few websites purely as a hobby. text/html 2023-10-25T16:21:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_ax_41_2023?rev=1698250892&do=diff Server benchmark 2023: Hetzner AX41 Dedicated Server * 2023 * AMD Ryzen 5 3600 Hexa-Core “Matisse” (Zen2) * 64 GB DDR4 RAM * The specification is 2 * 2 TB SATA 6 Gb/s Enterprise HDD; 7200 rpm (Software-RAID 1) * Delivered with 2 * 6 TB SATA 6 Gb/s Enterprise HDD text/html 2023-02-22T22:37:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/dedicated_or_virtual_server?rev=1677105451&do=diff A dedicated server or a virtual server These are my notes on choosing between Hetzner's Dedicated Server EQ 4 and Virtual Private Server VQ 19. This was written in 2011 so this may not reflect the current similarities and differences between the two server types. text/html 2023-02-23T23:54:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/the_zeus_malware_incident?rev=1677196489&do=diff The ZeuS malware incident This report was written in 2014, latest update 2017-10-22. Summary in Finnish. My Windows 7 desktop computer was hit by ZeuS malware or some variant of it. It wasn't detected by virus scanners and so it lived on the computer at least over a month, maybe much longer. Here is the full story. text/html 2023-10-25T15:51:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_ax_41_2020?rev=1698249104&do=diff Server benchmark 2020: Hetzner AX41 Dedicated Server 2020 * 2020 * AMD Ryzen 5 3600 Hexa-Core Simultaneous Multithreading * 64 GB DDR4 RAM * 2 x 2 TB SATA Enterprise HDD (software-RAID 1) * Connection 1 Gbit/s-Port * Guaranteed Bandwidth 1 GBit/s text/html 2023-10-25T15:42:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_cpx_21_2020?rev=1698248555&do=diff Server benchmark 2020: Hetzner CPX21 Cloud Server * 2020 * 3 vCPU * 4 GB RAM * 80 GB Local NVMe SSD * 20 TB Traffic * 0.014 €/h * 8.56 €/mo * <https://www.hetzner.de/> * Debian 10.4 64 bit * Tests run 2020-05-27 Full test ======================================================================== BYTE UNIX Benchmarks (Version 5.1.3) System: ******: GNU/Linux OS: GNU/Linux -- 4.19.0-8-amd64 -- #1 SMP Debian 4.19.98-1+deb10u1 (2020-04-27) Machine: x86_64 (unknown)… text/html 2023-10-25T15:45:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_cx_21?rev=1698248747&do=diff Server benchmark 2019: Hetzner CX21 Cloud Server * 2019 * 2 vCPU * 4 GB RAM * 40 GB Local NVMe SSD * 20 TB Traffic * <https://www.hetzner.de/> * Debian 10.1 64 bit * Tests run 2019-09-22 Full test ======================================================================== BYTE UNIX Benchmarks (Version 5.1.3) System: *******: GNU/Linux OS: GNU/Linux -- 4.19.0-5-amd64 -- #1 SMP Debian 4.19.37-5+deb10u2 (2019-08-08) Machine: x86_64 (unknown) Language: en_US.utf8 (ch… text/html 2024-07-14T19:56:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_cx_32?rev=1720986985&do=diff Server benchmark 2024: Hetzner CX32 Cloud Server * 2024 * 4 vCPU Intel * 8 GB RAM * 80 GB * 20 TB Traffic * 7.81 €/mo * <https://www.hetzner.de/> * Ubuntu 24.04 64 bit * Tests run 2024-07-12 Full test ======================================================================== BYTE UNIX Benchmarks (Version 5.1.3) System: *********: GNU/Linux OS: GNU/Linux -- 6.8.0-38-generic -- #38-Ubuntu SMP PREEMPT_DYNAMIC Fri Jun 7 15:25:01 UTC 2024 Machine: x86_64 (x86_64) … text/html 2023-10-25T15:44:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_ex_40?rev=1698248656&do=diff Server benchmark 2014: Hetzner EX 40 Dedicated Server * 2014 * Intel® Core™ i7-4770 Quadcore Haswell incl. Hyper-Threading Technology * 32 GB DDR3 RAM * Hard Drives 2 x 2 TB SATA 6 Gb/s 7200 rpm (Software-RAID 1) Class Enterprise * Connection 1 Gbit/s-Port text/html 2023-10-25T15:44:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_ex_40_ssd?rev=1698248645&do=diff Server benchmark 2013: Hetzner EX 40 SSD Dedicated Server * 2013 * Intel® Core™ i7-4770 Quadcore Haswell incl. Hyper-Threading Technology * 32 GB DDR3 RAM * Hard Drives 2 x 240 GB SATA 6 Gb/s SSD (Software-RAID 1) * Connection 1 Gbit/s-Port text/html 2023-10-25T15:43:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_ex_41_ssd?rev=1698248627&do=diff Server benchmark 2018: Hetzner EX41-SSD Dedicated Server * 2018 * Intel® Core™ i7-7700 Quadcore Haswell incl. Hyper-Threading Technology * 32 GB RAM * Hard Drives 2 x 500 GB SSD (Software-RAID 1) * Backup Space 100 GB * <https://www.hetzner.de/> * Debian 9 64 bit text/html 2023-10-25T15:43:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_ex_42_nvme?rev=1698248616&do=diff Server benchmark 2019: Hetzner EX42-NVMe Dedicated Server * 2019 * Intel® Core™ i7-6700 Quad-Core incl. Hyper-Threading Technology * 64 GB DDR4 RAM * 2 x 512 GB NVMe SSD (software-RAID 1) * Connection 1 Gbit/s-Port * Guaranteed Bandwidth 1 GBit/s text/html 2023-10-25T15:42:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_vx_18_vps?rev=1698248528&do=diff Server benchmark 2014: Hetzner VX 18 VPS * 2014 * Hetzner VX 18 VPS * Dual Core * 4 GB RAM * 100 GB HD on some sort of RAID * no backup space * 6 TB traffic/mo * <https://www.hetzner.de/> * Debian 7.7 64 bit * Tests run 2014-12-10 UnixBench 5.1.3 ./Run ======================================================================== BYTE UNIX Benchmarks (Version 5.1.3) System: **********: GNU/Linux OS: GNU/Linux -- 3.2.0-4-amd64 -- #1 SMP Debian 3.2.63-2+deb7u1 Machin… text/html 2023-02-20T23:37:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/framework_comparison?rev=1676936233&do=diff Perl MVC frameworks: Catalyst, Dancer, Mojolicious Written in 2010. I used all the three Perl MVC frameworks (Catalyst, Dancer and Mojolicious) during this project. I started the project with Catalyst and implemented some of the core features and content pages with it. Then I started a side project to test Dancer framework. When the project started I found Mojolicious not to be mature enough for this system. But it developed a lot and later I decided to switch from Catalyst to Mojolicious. The… text/html 2023-10-25T15:44:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_eq_4?rev=1698248682&do=diff Server benchmark 2011: Hetzner EQ 4 Dedicated Server * 2011 * Hetzner EQ 4 Dedicated Server * i7-920 Quadcore * 8 GB RAM * 750 GB HD RAID1 * 100 GB backup space * 10 TB traffic/mo * <https://www.hetzner.de/> * Debian 6.0 64 bit * Tests run 2011-07-26 UnixBench 5.1.2 ./Run dhry2reg whetstone-double syscall pipe context1 spawn execl shell1 shell8 shell16 ======================================================================== BYTE UNIX Benchmarks (Version 5.1.2) Syst… text/html 2023-10-25T15:44:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_ex_4?rev=1698248669&do=diff Server benchmark 2011: Hetzner EX 4 Dedicated Server * 2011 * Hetzner EQ 4 Dedicated Server * i7-2600 Quadcore * 16 GB RAM * 3 TB SATA 6 Gb/s HDD RAID1 * 100 GB backup space * 10 TB traffic/mo * <https://www.hetzner.de/> * Debian 6.0 64 bit * Tests run 2011-10-04 text/html 2023-10-25T15:42:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/xencon_xpro_512_vps?rev=1698248520&do=diff Server benchmark 2011: Xencon x|pro 512 VPS * 2011 * Xencon x|pro 512 VPS * Dual CPU * 0.5 GB RAM * 40 GB HD (RAID 1/RAID 10) * with automated backups * 0.5 TB traffic/mo * <https://www.xencon.net/> * Debian 6.0 64 bit * Tests run 2011-07-26 UnixBench 5.1.2 ./Run dhry2reg whetstone-double syscall pipe context1 spawn execl shell1 shell8 shell16 ======================================================================== BYTE UNIX Benchmarks (Version 5.1.2) System: catz:… text/html 2023-02-23T23:55:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/opera_tor_malware?rev=1677196510&do=diff Opera browser wild on opening sockets and listening on port 9050 The strange behavior of Opera browser described in this text happened in 2013 and was caused by ZeuS malware that dynamically injected its code to Opera process. I might be that there was nothing wrong with Opera browser itself. text/html 2023-02-24T21:55:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/catz/service_management?rev=1677275704&do=diff Catz service management Latest update 2022-07-16. This page contains short process descriptions, notes and checks for Catz application engine management and for version upgrades. This page is provided as public to show an example how a Perl- and Mojolicious-based application can be managed. This also gives me online access to the notes. text/html 2023-10-25T15:45:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_cax_21?rev=1698248719&do=diff Server benchmark 2023: Hetzner CAX21 Cloud Server * 2023 * 4 vCPU Ampere * 8 GB RAM * 80 GB * 20 TB Traffic * 8.05 €/mo * <https://www.hetzner.de/> * Debian 11 64 bit * Tests run 2023-04-29 Full test ======================================================================== BYTE UNIX Benchmarks (Version 5.1.3) System: *******: GNU/Linux OS: GNU/Linux -- 5.10.0-21-arm64 -- #1 SMP Debian 5.10.162-1 (2023-01-21) Machine: aarch64 (unknown) Language: en_US.utf8 (ch… text/html 2023-10-25T15:45:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_cpx_21_2023?rev=1698248729&do=diff Server benchmark 2023: Hetzner CPX21 Cloud Server 2023 * 2023 * 3 vCPU AMD * 4 GB RAM * 80 GB * 20 TB Traffic * 9.36 €/mo * <https://www.hetzner.de/> * Debian 11 64 bit * Tests run 2023-04-29 Full test ======================================================================== BYTE UNIX Benchmarks (Version 5.1.3) System: *******: GNU/Linux OS: GNU/Linux -- 5.10.0-21-amd64 -- #1 SMP Debian 5.10.162-1 (2023-01-21) Machine: x86_64 (unknown) Language: en_US.utf8 (c… text/html 2023-02-22T22:37:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/cognos_bi?rev=1677105451&do=diff The automatic IBM Cognos BI Motto: Run your Business Intelligence, don't let your Business Intelligence run you! Written in 2013. I've been working with IBM Cognos BI (Business Intelligence) system for some years. Our application area for the BI system differs from typical application areas: we use it to provide public internet reporting and OLAP analysis tools. These are based on data extracted from our registers and other statistical data sources. text/html 2024-02-19T04:03:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/perl2python?rev=1708315431&do=diff Moving from Perl to Python Created 2021-04-27. Latest update 2024-02-19. The need for a general purpose programming language The programming languages that I've previously used include Java, JavaScript, PL/SQL, Ruby, Perl, C, C++, PHP, Pascal, Visual Basic, Lisp and Fortran (at least). text/html 2023-02-20T23:37:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/postgresql_vs_sqlite?rev=1676936233&do=diff PostgreSQL vs SQLite Written in 2011. If you need a very fast relational database for a limited amount of data (up to some gigabytes) and don't need scalability on concurrent writes then SQLite is for you. It is a cleverly designed ultra-lightweight ACID compliant relational database that requires no administration. text/html 2023-02-26T05:16:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/seagate_external_hardrive_issues?rev=1677388611&do=diff Seagate Expansion Desktop performance issues and fixes Page created 2018-01-04. Last updated 2018-01-05. I had some issues with a brand new Seagate Expansion Desktop 4TB USB 3 hard drive (STEB4000200). Here are the issues and how they were fixed. Issue 1: Drive is extremely slow right from the beginning text/html 2023-10-25T15:43:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_vq_12_vps?rev=1698248606&do=diff Server benchmark 2012: Hetzner VQ 12 VPS * 2012 * Hetzner VQ 12 VPS * Single Core * 1 GB RAM * 40 GB HD on some sort of RAID * no backup space * 2 TB traffic/mo * <https://www.hetzner.de/> * Debian 6.0 64 bit * Tests run 2012-01-31 UnixBench 5.1.2 ./Run dhry2reg whetstone-double syscall pipe context1 spawn execl shell1 shell8 shell16 ======================================================================== BYTE UNIX Benchmarks (Version 5.1.2) System: ********: GNU/L… text/html 2023-10-25T15:42:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_vq_19_vps?rev=1698248538&do=diff Server benchmark 2011: Hetzner VQ 19 VPS * 2011 * Hetzner VQ 19 VPS * Single Core * 2 GB RAM * 80 GB HD on some sort of RAID * no backup space * 4 TB traffic/mo * <https://www.hetzner.de/> * Debian 6.0 64 bit * Tests run 2011-07-26 UnixBench 5.1.2 ./Run dhry2reg whetstone-double syscall pipe context1 spawn execl shell1 shell8 shell16 ======================================================================== BYTE UNIX Benchmarks (Version 5.1.2) System: Debian-60-squee… text/html 2023-02-20T23:37:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/practical_linux?rev=1676936233&do=diff Practical Linux The year of origin of this page is 2007. Lue suomeksi. You have invested 300 000 € to new Linux servers and willing to set them up quickly? Here's a practical guide how you do it and enter production in no time! Unloading First step is to unload the cardboard boxes from the truck. There are plenty of them so take your time. text/html 2023-10-25T15:45:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/hetzner_cx_11?rev=1698248739&do=diff Server benchmark 2023: Hetzner CX11 Cloud Server * 2023 * 1 vCPU Intel * 2 GB RAM * 20 GB * 20 TB Traffic * 4.70 €/mo * <https://www.hetzner.de/> * Debian 11 64 bit * Tests run 2023-04-29 Full test ======================================================================== BYTE UNIX Benchmarks (Version 5.1.3) System: *******: GNU/Linux OS: GNU/Linux -- 5.10.0-21-amd64 -- #1 SMP Debian 5.10.162-1 (2023-01-21) Machine: x86_64 (unknown) Language: en_US.utf8 (charm… text/html 2023-09-22T21:33:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/the_nas_impressions?rev=1695418415&do=diff The small NAS server: long-term impressions 2023-09-23: Writing in progress... Impressions after six months Impressions after six months written in 2021-02-21. The system has been running for about six months now and I'm still very happy of this setup. text/html 2023-10-11T17:13:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/the_nas_power_consumption?rev=1697044405&do=diff The small NAS server: about power consumption The measurements were made and the writing started 2023-09-23. Writing completed 2023-10-11. Why measure the power consumption As power consumption of ICT equipment and power consumption in general have became popular subjects I decided to measure the power consumption of text/html 2023-02-20T23:37:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/catz/bulk_interface?rev=1676936233&do=diff Catz bulk intefrace 2021-04-25: This interface had its practical use until summer 2014. It is still available but considered deprecated. Listing the photos of an album The request is sent as HTTP GET and a plain text document is retured. The first line returned is an informational header. The following lines contain the data using the pipe character as a column separator. The fields retuned are text/html 2023-02-26T17:32:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/catz/system_description?rev=1677432730&do=diff About the design and implementation of Catz Written in 2011 so may contain outdated information. The key attributes * The service is stateless: the HTTP GET request's URL identifies the resource requested. There are no cookies nor sessions. * The public access is dynamic but read only. All data is loaded offline by a loader sumsystem. text/html 2024-07-14T19:57:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://heikkisiltala.net/wiki/en/information_technology/server_benchmarks/start?rev=1720987054&do=diff Server benchmarks Here are some benchmarks that I've run on small physical and virtual servers during the years. The benchmarking was typically done by running Byte UnixBench and then dd for disk speed. * Server benchmark 2024: Hetzner CX32 Cloud Server * Server benchmark 2023: Hetzner CX11 Cloud Server * Server benchmark 2023: Hetzner CPX21 Cloud Server 2023 * Server benchmark 2023: Hetzner CAX21 Cloud Server * Server benchmark 2023: Hetzner AX41 Dedicated Server * Server benchmark 202…