<?xml version="1.0" encoding="utf-8"?>
<!-- generator="FeedCreator 1.8" -->
<?xml-stylesheet href="https://wiki.janforman.com/lib/exe/css.php?s=feed" type="text/css"?>
<feed xmlns="http://www.w3.org/2005/Atom">
    <title>wiki.janforman.com</title>
    <subtitle></subtitle>
    <link rel="alternate" type="text/html" href="https://wiki.janforman.com/"/>
    <id>https://wiki.janforman.com/</id>
    <updated>2026-04-14T14:27:53+00:00</updated>
    <generator>FeedCreator 1.8 (info@mypapit.net)</generator>
    <link rel="self" type="application/atom+xml" href="https://wiki.janforman.com/feed.php" />
    <entry>
        <title>3dmesh</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/3dmesh"/>
        <published>2017-03-17T21:50:32+00:00</published>
        <updated>2017-03-17T21:50:32+00:00</updated>
        <id>https://wiki.janforman.com/3dmesh</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Edit point of cloud

	*  File &gt; Open project… – select bundle.rd.out then the list.txt file when prompted
	*  Hit CTRL + L to show the layers panel
	*  Right click layer &gt; Delete current mesh
	*  Import mesh – import VirtualSFM point cloud (models/option-0000.ply)</content>
        <summary>Edit point of cloud

	*  File &gt; Open project… – select bundle.rd.out then the list.txt file when prompted
	*  Hit CTRL + L to show the layers panel
	*  Right click layer &gt; Delete current mesh
	*  Import mesh – import VirtualSFM point cloud (models/option-0000.ply)</summary>
    </entry>
    <entry>
        <title>4k</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/4k"/>
        <published>2021-12-29T12:31:12+00:00</published>
        <updated>2021-12-29T12:31:12+00:00</updated>
        <id>https://wiki.janforman.com/4k</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Convert MKV to MP4

For LG TV you may need convert Dolby Vision MKV to MP4

(mkv tool, dolby vision muxer and mp4box required)


mkvextract.exe input.mkv tracks 0:video.hevc 1:audio.ac3 3:en.srt 9:cs.srt
mp4muxer.exe --dv-profile 5 --input-file video.hevc --input-file audio.ac3 --output-file movie.mp4
mp4box.exe  -brand mp42isom -tight -itags cover=cover.jpg -ab dby1 -no-iod -add &quot;movie.mp4&quot; -add &quot;en.srt#subtitle:lang=en-EN:name=English&quot;  -add &quot;cs.srt#subtitle:lang=cs-CZ:name=Czech&quot; -new &quot;outfin…</content>
        <summary>Convert MKV to MP4

For LG TV you may need convert Dolby Vision MKV to MP4

(mkv tool, dolby vision muxer and mp4box required)


mkvextract.exe input.mkv tracks 0:video.hevc 1:audio.ac3 3:en.srt 9:cs.srt
mp4muxer.exe --dv-profile 5 --input-file video.hevc --input-file audio.ac3 --output-file movie.mp4
mp4box.exe  -brand mp42isom -tight -itags cover=cover.jpg -ab dby1 -no-iod -add &quot;movie.mp4&quot; -add &quot;en.srt#subtitle:lang=en-EN:name=English&quot;  -add &quot;cs.srt#subtitle:lang=cs-CZ:name=Czech&quot; -new &quot;outfin…</summary>
    </entry>
    <entry>
        <title>amd</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/amd"/>
        <published>2018-12-01T14:57:17+00:00</published>
        <updated>2018-12-01T14:57:17+00:00</updated>
        <id>https://wiki.janforman.com/amd</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>AMD AM3+ FX

BIOS Remarks

Best tradeoff (speed, low power)

HPC Mode Must be ON! If not CPU cannot reach full speed under load (bad multicore performance)

APM Must be ON! If not Turbo Boost won't work (bad singlecore performance)


Best multicore (high power)</content>
        <summary>AMD AM3+ FX

BIOS Remarks

Best tradeoff (speed, low power)

HPC Mode Must be ON! If not CPU cannot reach full speed under load (bad multicore performance)

APM Must be ON! If not Turbo Boost won't work (bad singlecore performance)


Best multicore (high power)</summary>
    </entry>
    <entry>
        <title>api</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/api"/>
        <published>2017-11-07T15:36:36+00:00</published>
        <updated>2017-11-07T15:36:36+00:00</updated>
        <id>https://wiki.janforman.com/api</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>API Catalog / Security

SSL Termination Point

QoS

Service concentration to one point

Storefront can be deployed in DMZ for external access with publisher inside the firewall for private control


Single API node can handle more than 100 million requests/day. Clusters can do billions.</content>
        <summary>API Catalog / Security

SSL Termination Point

QoS

Service concentration to one point

Storefront can be deployed in DMZ for external access with publisher inside the firewall for private control


Single API node can handle more than 100 million requests/day. Clusters can do billions.</summary>
    </entry>
    <entry>
        <title>arcgisserver</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/arcgisserver"/>
        <published>2025-04-05T08:27:18+00:00</published>
        <updated>2025-04-05T08:27:18+00:00</updated>
        <id>https://wiki.janforman.com/arcgisserver</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>&lt;https://koopjs.github.io&gt;

Cache Tiles job from Linux

Run cache tile job directly from server API


#!/bin/sh
USER=
PASSWORD=
HOST=https://IP:6443/arcgis
IP=`hostname -I`
LAYER=layer
TOKEN=`curl --insecure -X POST -d username=$USER -d password=$PASSWORD -d client=ip -d ip=$IP $HOST/tokens/generateToken`
LEVELS=&quot;2311162.217155;1155581.108577;577790.554289;288895.277144;144447.638572;72223.819286;36111.909643;18055.954822;9027.977411;4513.988705;2256.994353&quot;
EXTENT=&quot;1380000%206260000%201540000%2…</content>
        <summary>&lt;https://koopjs.github.io&gt;

Cache Tiles job from Linux

Run cache tile job directly from server API


#!/bin/sh
USER=
PASSWORD=
HOST=https://IP:6443/arcgis
IP=`hostname -I`
LAYER=layer
TOKEN=`curl --insecure -X POST -d username=$USER -d password=$PASSWORD -d client=ip -d ip=$IP $HOST/tokens/generateToken`
LEVELS=&quot;2311162.217155;1155581.108577;577790.554289;288895.277144;144447.638572;72223.819286;36111.909643;18055.954822;9027.977411;4513.988705;2256.994353&quot;
EXTENT=&quot;1380000%206260000%201540000%2…</summary>
    </entry>
    <entry>
        <title>architecture</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/architecture"/>
        <published>2018-09-21T17:22:44+00:00</published>
        <updated>2018-09-21T17:22:44+00:00</updated>
        <id>https://wiki.janforman.com/architecture</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Color   Yellow  Business logic  Blue  Application logic  Green  Technology  Violet  Money flow 
Business, Data, Application, Technical

&lt;https://en.wikipedia.org/wiki/Worse_is_better&gt;

&lt;https://en.wikipedia.org/wiki/Perfect_is_the_enemy_of_good&gt;

&lt;https://en.wikipedia.org/wiki/Pareto_principle&gt;

&lt;https://en.wikipedia.org/wiki/MoSCoW_method&gt;




&lt;https://www.openproject.org/download-and-installation/&gt;</content>
        <summary>Color   Yellow  Business logic  Blue  Application logic  Green  Technology  Violet  Money flow 
Business, Data, Application, Technical

&lt;https://en.wikipedia.org/wiki/Worse_is_better&gt;

&lt;https://en.wikipedia.org/wiki/Perfect_is_the_enemy_of_good&gt;

&lt;https://en.wikipedia.org/wiki/Pareto_principle&gt;

&lt;https://en.wikipedia.org/wiki/MoSCoW_method&gt;




&lt;https://www.openproject.org/download-and-installation/&gt;</summary>
    </entry>
    <entry>
        <title>arcmap</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/arcmap"/>
        <published>2024-06-20T14:02:17+00:00</published>
        <updated>2024-06-20T14:02:17+00:00</updated>
        <id>https://wiki.janforman.com/arcmap</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>OSM format for ArcGIS Pro URL

&lt;https://osm.xxx.cz/&gt;{z}/{x}/{y}.png

Filter Label Output

Visual Basic Script for Application


Function FindLabel ( [NAZ_CAST], [NAZ_OBEC]  )
If [NAZ_CAST] = [NAZ_OBEC] Then
  FindLabel = &quot;&quot;
 Else
 FindLabel = [NAZ_CAST]
End If

End Function</content>
        <summary>OSM format for ArcGIS Pro URL

&lt;https://osm.xxx.cz/&gt;{z}/{x}/{y}.png

Filter Label Output

Visual Basic Script for Application


Function FindLabel ( [NAZ_CAST], [NAZ_OBEC]  )
If [NAZ_CAST] = [NAZ_OBEC] Then
  FindLabel = &quot;&quot;
 Else
 FindLabel = [NAZ_CAST]
End If

End Function</summary>
    </entry>
    <entry>
        <title>arcsde</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/arcsde"/>
        <published>2023-07-13T15:24:27+00:00</published>
        <updated>2023-07-13T15:24:27+00:00</updated>
        <id>https://wiki.janforman.com/arcsde</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>ArcSDE + PostGIS on UBUNTU 20.04

* note &lt;= ArcGIS Pro 2.5 and Arcmap 10.8 cant connect to Postgres 12



wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
RELEASE=$(lsb_release -cs)
echo &quot;deb http://apt.postgresql.org/pub/repos/apt/ ${RELEASE}&quot;-pgdg main | sudo tee  /etc/apt/sources.list.d/pgdg.list

sudo apt update
sudo apt -y install postgresql-11</content>
        <summary>ArcSDE + PostGIS on UBUNTU 20.04

* note &lt;= ArcGIS Pro 2.5 and Arcmap 10.8 cant connect to Postgres 12



wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
RELEASE=$(lsb_release -cs)
echo &quot;deb http://apt.postgresql.org/pub/repos/apt/ ${RELEASE}&quot;-pgdg main | sudo tee  /etc/apt/sources.list.d/pgdg.list

sudo apt update
sudo apt -y install postgresql-11</summary>
    </entry>
    <entry>
        <title>atxpower</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/atxpower"/>
        <published>2016-11-18T02:02:33+00:00</published>
        <updated>2016-11-18T02:02:33+00:00</updated>
        <id>https://wiki.janforman.com/atxpower</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>ATX Specification
 Voltage  Tolerance    Minimum Voltage  Maximum Voltage  +3.3VDC  ± 5%   +3.135 VDC   +3.465 VDC   +5VDC	   ± 5%   +4.750 VDC   +5.250 VDC   +5VSB    ± 5%   +4.750 VDC   +5.250 VDC   -5VDC    ± 10%  -4.500 VDC   -5.500 VDC   +12VDC</content>
        <summary>ATX Specification
 Voltage  Tolerance    Minimum Voltage  Maximum Voltage  +3.3VDC  ± 5%   +3.135 VDC   +3.465 VDC   +5VDC	   ± 5%   +4.750 VDC   +5.250 VDC   +5VSB    ± 5%   +4.750 VDC   +5.250 VDC   -5VDC    ± 10%  -4.500 VDC   -5.500 VDC   +12VDC</summary>
    </entry>
    <entry>
        <title>audigy2zs</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/audigy2zs"/>
        <published>2016-03-06T14:37:28+00:00</published>
        <updated>2016-03-06T14:37:28+00:00</updated>
        <id>https://wiki.janforman.com/audigy2zs</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Creative Audigy2 ZS

This is my configuration for Audigy EMU10K2 processor. Left, Right, Center, Rear Right, Rear Left (50%) mixed -&gt; Cross over filter where is limited to 0-120Hz and mixed to 0.1 (Basswoofer)


Microphone must be enabled in AC97 tab.</content>
        <summary>Creative Audigy2 ZS

This is my configuration for Audigy EMU10K2 processor. Left, Right, Center, Rear Right, Rear Left (50%) mixed -&gt; Cross over filter where is limited to 0-120Hz and mixed to 0.1 (Basswoofer)


Microphone must be enabled in AC97 tab.</summary>
    </entry>
    <entry>
        <title>batteries</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/batteries"/>
        <published>2018-02-10T13:16:56+00:00</published>
        <updated>2018-02-10T13:16:56+00:00</updated>
        <id>https://wiki.janforman.com/batteries</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Image  Type  Voltage  Typical Capacity  Cutoff Voltage    6LR61, 6LF22  9V  500mAh  4.8V    CR2032  3V  225mAh  2V 
Discharge

Lion / LiPol can be deeply discharged, but must me charged separately (each cell) - affect lifespan little
NiMH / NiCD this won't matter it can be flat.</content>
        <summary>Image  Type  Voltage  Typical Capacity  Cutoff Voltage    6LR61, 6LF22  9V  500mAh  4.8V    CR2032  3V  225mAh  2V 
Discharge

Lion / LiPol can be deeply discharged, but must me charged separately (each cell) - affect lifespan little
NiMH / NiCD this won't matter it can be flat.</summary>
    </entry>
    <entry>
        <title>bpmn</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/bpmn"/>
        <published>2019-07-09T15:36:12+00:00</published>
        <updated>2019-07-09T15:36:12+00:00</updated>
        <id>https://wiki.janforman.com/bpmn</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>&lt;a2s&gt;
    .----------.            .-.
input |          | &lt;--------- | | --&gt; out
    '----------'            .-.
       |
       |
    .----------.            .-.
    |          | &lt;--------- | | --&gt;
    '----------'            .-.
&lt;/a2s&gt;

&lt;bpmnio&gt;
&lt;?xml version=</content>
        <summary>&lt;a2s&gt;
    .----------.            .-.
input |          | &lt;--------- | | --&gt; out
    '----------'            .-.
       |
       |
    .----------.            .-.
    |          | &lt;--------- | | --&gt;
    '----------'            .-.
&lt;/a2s&gt;

&lt;bpmnio&gt;
&lt;?xml version=</summary>
    </entry>
    <entry>
        <title>capacitors</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/capacitors"/>
        <published>2022-10-13T09:30:36+00:00</published>
        <updated>2022-10-13T09:30:36+00:00</updated>
        <id>https://wiki.janforman.com/capacitors</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Japanese Manufacturers

Very good, but can be faked.
 Marking  Brand  Empty rectangle  Chemi-Con  KZE, KZJ, KZG  Chemi-Con  [M]  Panasonic  Rubycon  Rubycon  Sanyo  Sanyo  Nichicon  Nichicon 
Taiwan Manufacturers
 Marking  Brand  Teapo  Teapo 
Lifespan</content>
        <summary>Japanese Manufacturers

Very good, but can be faked.
 Marking  Brand  Empty rectangle  Chemi-Con  KZE, KZJ, KZG  Chemi-Con  [M]  Panasonic  Rubycon  Rubycon  Sanyo  Sanyo  Nichicon  Nichicon 
Taiwan Manufacturers
 Marking  Brand  Teapo  Teapo 
Lifespan</summary>
    </entry>
    <entry>
        <title>cassandra</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/cassandra"/>
        <published>2018-06-19T10:15:02+00:00</published>
        <updated>2018-06-19T10:15:02+00:00</updated>
        <id>https://wiki.janforman.com/cassandra</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Cassandra / ScyllaDB Basics

CLUSTER -&gt; KEYSPACE -&gt; TABLE -&gt; DATA

Minimum number of running nodes are 2 (otherwise writes are not possible), so 3 or more nodes total is absolutely minimal deployment.

“Cassandra timeout during read query at consistency TWO (2 responses were required but only 1 replica responded)</content>
        <summary>Cassandra / ScyllaDB Basics

CLUSTER -&gt; KEYSPACE -&gt; TABLE -&gt; DATA

Minimum number of running nodes are 2 (otherwise writes are not possible), so 3 or more nodes total is absolutely minimal deployment.

“Cassandra timeout during read query at consistency TWO (2 responses were required but only 1 replica responded)</summary>
    </entry>
    <entry>
        <title>citus</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/citus"/>
        <published>2021-05-25T12:35:47+00:00</published>
        <updated>2021-05-25T12:35:47+00:00</updated>
        <id>https://wiki.janforman.com/citus</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Coordinator node may be replicated using STREAMING REPLICATION

Start replication

Set replication factor before start

SET citus.shard_replication_factor = 2;
SET citus.shard_count = 2;

Set shard distributed table

SELECT create_distributed_table('tablename', 'id');
SELECT truncate_local_data_after_distributing_table($$public.tablename$$);</content>
        <summary>Coordinator node may be replicated using STREAMING REPLICATION

Start replication

Set replication factor before start

SET citus.shard_replication_factor = 2;
SET citus.shard_count = 2;

Set shard distributed table

SELECT create_distributed_table('tablename', 'id');
SELECT truncate_local_data_after_distributing_table($$public.tablename$$);</summary>
    </entry>
    <entry>
        <title>colorcalibration</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/colorcalibration"/>
        <published>2023-04-23T20:43:55+00:00</published>
        <updated>2023-04-23T20:43:55+00:00</updated>
        <id>https://wiki.janforman.com/colorcalibration</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Color Calibration

&lt;https://www.panelook.com&gt;

CIE Color Calculator

&lt;https://www.avsforum.com/threads/avs-hd-709-blu-ray-mp4-calibration.948496/&gt;

&lt;https://github.com/arthur-liberman/hcfr-code/releases&gt;

Saturation

	*  Point the color analyzer or light meter towards the screen and display a 100% white test pattern.
	*  Measure the Y value (luminance) of white.
	*  Display a 100% Red test pattern, and measure the Y value here as well.</content>
        <summary>Color Calibration

&lt;https://www.panelook.com&gt;

CIE Color Calculator

&lt;https://www.avsforum.com/threads/avs-hd-709-blu-ray-mp4-calibration.948496/&gt;

&lt;https://github.com/arthur-liberman/hcfr-code/releases&gt;

Saturation

	*  Point the color analyzer or light meter towards the screen and display a 100% white test pattern.
	*  Measure the Y value (luminance) of white.
	*  Display a 100% Red test pattern, and measure the Y value here as well.</summary>
    </entry>
    <entry>
        <title>cryptography</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/cryptography"/>
        <published>2023-07-02T10:48:29+00:00</published>
        <updated>2023-07-02T10:48:29+00:00</updated>
        <id>https://wiki.janforman.com/cryptography</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Generate CA + certificate


openssl genrsa -out rootCAKey.pem 2048
openssl req -x509 -sha256 -new -nodes -key rootCAKey.pem -days 7300 -out rootCACert.pem
openssl x509 -in rootCACert.pem -text
openssl x509 -outform der -in rootCACert.pem -out rootCACert.crt

-- generate server cert
openssl genrsa -out ServerKey.pem 2048
openssl req -new -sha256 -nodes \
  -key ServerKey.pem -out ServerRequest.csr -reqexts san -config \
  &lt;(echo &quot;[req]&quot;; 
    echo distinguished_name=req; 
    echo &quot;[san]&quot;; 
    e…</content>
        <summary>Generate CA + certificate


openssl genrsa -out rootCAKey.pem 2048
openssl req -x509 -sha256 -new -nodes -key rootCAKey.pem -days 7300 -out rootCACert.pem
openssl x509 -in rootCACert.pem -text
openssl x509 -outform der -in rootCACert.pem -out rootCACert.crt

-- generate server cert
openssl genrsa -out ServerKey.pem 2048
openssl req -new -sha256 -nodes \
  -key ServerKey.pem -out ServerRequest.csr -reqexts san -config \
  &lt;(echo &quot;[req]&quot;; 
    echo distinguished_name=req; 
    echo &quot;[san]&quot;; 
    e…</summary>
    </entry>
    <entry>
        <title>etrs89</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/etrs89"/>
        <published>2018-03-30T11:57:04+00:00</published>
        <updated>2018-03-30T11:57:04+00:00</updated>
        <id>https://wiki.janforman.com/etrs89</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>&lt;http://tool-online.com/en/coordinate-converter.php&gt;

Funkce v jazyku C pro výpočet transformace mezi WGS-84 a ETRS-89


void ITRF05tc_ETRS89tc(long double *x, long double *y, long double *z, long double *xE, long double *yE, long double *zE) 
{ 
 long double T1, T2, T3, R1, R2, R3;

 T1 = 5.6*0.01; 
 T2 = 4.8*0.01; 
 T3 = -3.7*0.01; 
 R1 = (0.054*0.001)/3600*M_PI/180; 
 R2 = (0.518*0.001)/3600*M_PI/180; 
 R3 = (-0.781*0.001)/3600*M_PI/180;

 *xE = *x + T1 + ((0 - R3 * *y + R2 * *z)*(tc - 1989))…</content>
        <summary>&lt;http://tool-online.com/en/coordinate-converter.php&gt;

Funkce v jazyku C pro výpočet transformace mezi WGS-84 a ETRS-89


void ITRF05tc_ETRS89tc(long double *x, long double *y, long double *z, long double *xE, long double *yE, long double *zE) 
{ 
 long double T1, T2, T3, R1, R2, R3;

 T1 = 5.6*0.01; 
 T2 = 4.8*0.01; 
 T3 = -3.7*0.01; 
 R1 = (0.054*0.001)/3600*M_PI/180; 
 R2 = (0.518*0.001)/3600*M_PI/180; 
 R3 = (-0.781*0.001)/3600*M_PI/180;

 *xE = *x + T1 + ((0 - R3 * *y + R2 * *z)*(tc - 1989))…</summary>
    </entry>
    <entry>
        <title>euproblems</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/euproblems"/>
        <published>2025-01-18T14:12:05+00:00</published>
        <updated>2025-01-18T14:12:05+00:00</updated>
        <id>https://wiki.janforman.com/euproblems</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Biggest EU problems

Neo-socialism

Bureaucracy

Central Planning

Deindustrialization

Driven by poorly minded

Extreme energy prices

Can't accept risks

Sponsoring international terorism

People with bad impact on EU

Weak, destructive poor decisions and analytics skills</content>
        <summary>Biggest EU problems

Neo-socialism

Bureaucracy

Central Planning

Deindustrialization

Driven by poorly minded

Extreme energy prices

Can't accept risks

Sponsoring international terorism

People with bad impact on EU

Weak, destructive poor decisions and analytics skills</summary>
    </entry>
    <entry>
        <title>gdpr</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/gdpr"/>
        <published>2018-05-21T15:55:56+00:00</published>
        <updated>2018-05-21T15:55:56+00:00</updated>
        <id>https://wiki.janforman.com/gdpr</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>GDPR

	*  omezení uchovávání dat (identifikování obsahu pro případný výmaz)
	*  integrita a zabezpečení dat
	*  kdo k datům přistupuje
	*  na co se data používají
	*  minimalizace rozsahu
	*  přesnost dat
	*  oddělení dat
	*  anonymizace dat smazaného uživatele</content>
        <summary>GDPR

	*  omezení uchovávání dat (identifikování obsahu pro případný výmaz)
	*  integrita a zabezpečení dat
	*  kdo k datům přistupuje
	*  na co se data používají
	*  minimalizace rozsahu
	*  přesnost dat
	*  oddělení dat
	*  anonymizace dat smazaného uživatele</summary>
    </entry>
    <entry>
        <title>geoserver</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/geoserver"/>
        <published>2018-10-02T14:12:38+00:00</published>
        <updated>2018-10-02T14:12:38+00:00</updated>
        <id>https://wiki.janforman.com/geoserver</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>GEOSERVER S-JTSK Support

/data_dir/user_projections

5514=PROJCS[&quot;S-JTSK / Krovak East North&quot;,GEOGCS[&quot;S-JTSK&quot;,DATUM[&quot;System Jednotne Trigonometricke Site Katastralni&quot;,SPHEROID[&quot;Bessel 1841&quot;,6377397.155,299.1528128,AUTHORITY[&quot;EPSG&quot;,&quot;7004&quot;]],TOWGS84[572.213,85.334,461.94,4.9732,-1.529,-5.2484,3.5378],AUTHORITY[&quot;EPSG&quot;,&quot;6156&quot;]],PRIMEM[&quot;Greenwich&quot;,0.0,AUTHORITY[&quot;EPSG&quot;,&quot;8901&quot;]],UNIT[&quot;degree&quot;,0.017453292519943295],AXIS[&quot;Geodetic longitude&quot;,EAST],AXIS[&quot;Geodetic latitude&quot;, NORTH],AUTHORITY[&quot;EPSG&quot;,&quot;4156&quot;…</content>
        <summary>GEOSERVER S-JTSK Support

/data_dir/user_projections

5514=PROJCS[&quot;S-JTSK / Krovak East North&quot;,GEOGCS[&quot;S-JTSK&quot;,DATUM[&quot;System Jednotne Trigonometricke Site Katastralni&quot;,SPHEROID[&quot;Bessel 1841&quot;,6377397.155,299.1528128,AUTHORITY[&quot;EPSG&quot;,&quot;7004&quot;]],TOWGS84[572.213,85.334,461.94,4.9732,-1.529,-5.2484,3.5378],AUTHORITY[&quot;EPSG&quot;,&quot;6156&quot;]],PRIMEM[&quot;Greenwich&quot;,0.0,AUTHORITY[&quot;EPSG&quot;,&quot;8901&quot;]],UNIT[&quot;degree&quot;,0.017453292519943295],AXIS[&quot;Geodetic longitude&quot;,EAST],AXIS[&quot;Geodetic latitude&quot;, NORTH],AUTHORITY[&quot;EPSG&quot;,&quot;4156&quot;…</summary>
    </entry>
    <entry>
        <title>gpslogger</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/gpslogger"/>
        <published>2019-07-30T13:06:33+00:00</published>
        <updated>2019-07-30T13:06:33+00:00</updated>
        <id>https://wiki.janforman.com/gpslogger</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>GPS Logger

GPS Logger
Interval 5 seconds

Precision filter 5 meters

Keep GPS On

Endpoint

/hzs-data?file=upload&amp;token=token&amp;start=%STARTTIMESTAMP&amp;time=%TIMESTAMP&amp;lat=%LAT&amp;lon=%lon</content>
        <summary>GPS Logger

GPS Logger
Interval 5 seconds

Precision filter 5 meters

Keep GPS On

Endpoint

/hzs-data?file=upload&amp;token=token&amp;start=%STARTTIMESTAMP&amp;time=%TIMESTAMP&amp;lat=%LAT&amp;lon=%lon</summary>
    </entry>
    <entry>
        <title>hdaudiorush</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/hdaudiorush"/>
        <published>2021-11-09T09:43:02+00:00</published>
        <updated>2021-11-09T09:43:02+00:00</updated>
        <id>https://wiki.janforman.com/hdaudiorush</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>HD Audio Rush

2018 version

Dolby Digital AC3 or DTS decoder with SPDIF and optical inputs that can output surround sound to analog 5.1


This is hybrid Analog - Digital SoC running Linux with Dolby Digital AC3 / DTS Decoder.

There's no bass management so DTS/AC3 tracks have only LFE (no other channels mixed)</content>
        <summary>HD Audio Rush

2018 version

Dolby Digital AC3 or DTS decoder with SPDIF and optical inputs that can output surround sound to analog 5.1


This is hybrid Analog - Digital SoC running Linux with Dolby Digital AC3 / DTS Decoder.

There's no bass management so DTS/AC3 tracks have only LFE (no other channels mixed)</summary>
    </entry>
    <entry>
        <title>hepa</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/hepa"/>
        <published>2018-11-15T12:16:09+00:00</published>
        <updated>2018-11-15T12:16:09+00:00</updated>
        <id>https://wiki.janforman.com/hepa</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Celková hodnota pro MPPS částice (0.1–0.3 μm)	Integrální hodnota pro MPPS částice (0.1–0.3 μm)
 Skupina filtrů  Třída filtrace  Účinnost v %  Průnik v %  Účinnost v %  Průnik v %  E – EPA	 E 10	 ≥ 85	 ≤ 15  –  –   E 11</content>
        <summary>Celková hodnota pro MPPS částice (0.1–0.3 μm)	Integrální hodnota pro MPPS částice (0.1–0.3 μm)
 Skupina filtrů  Třída filtrace  Účinnost v %  Průnik v %  Účinnost v %  Průnik v %  E – EPA	 E 10	 ≥ 85	 ≤ 15  –  –   E 11</summary>
    </entry>
    <entry>
        <title>iot</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/iot"/>
        <published>2021-05-10T22:26:14+00:00</published>
        <updated>2021-05-10T22:26:14+00:00</updated>
        <id>https://wiki.janforman.com/iot</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Custom NodeMCU Builder

nodemcu-build.com

Tasmota

&lt;https://tasmota.github.io&gt;

Basic Info
 Type  Arduino Uno WiFi  ESP8266 NodeMCU  ESP 32  Digital I/O  13  11   Analog I/O  6  1   PWM  6  10   Frequency  16MHz  80MHz or 160MHz  160MHz or 240MHz  I/O Voltage  5V  3,3V  3,3V  Flash size  32kB (-0,5kB bootloader)</content>
        <summary>Custom NodeMCU Builder

nodemcu-build.com

Tasmota

&lt;https://tasmota.github.io&gt;

Basic Info
 Type  Arduino Uno WiFi  ESP8266 NodeMCU  ESP 32  Digital I/O  13  11   Analog I/O  6  1   PWM  6  10   Frequency  16MHz  80MHz or 160MHz  160MHz or 240MHz  I/O Voltage  5V  3,3V  3,3V  Flash size  32kB (-0,5kB bootloader)</summary>
    </entry>
    <entry>
        <title>java</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/java"/>
        <published>2019-11-29T10:21:33+00:00</published>
        <updated>2019-11-29T10:21:33+00:00</updated>
        <id>https://wiki.janforman.com/java</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Create new JAVA Keystore and import KEY A CERT

Generate binary PKCS12 bundle (PEM, KEY, CHAIN) -&gt; PKCS12

openssl pkcs12 -export -in MY.CRT -inkey MY.KEY -chain -CAfile CA-FILE.CRT -name &quot;MY-DOMAIN.COM&quot; -out my.p12

keytool -importkeystore -deststorepass CHANGEIT -destkeystore KEYSTORE.JKS -srckeystore my.p12 -srcstoretype PKCS12</content>
        <summary>Create new JAVA Keystore and import KEY A CERT

Generate binary PKCS12 bundle (PEM, KEY, CHAIN) -&gt; PKCS12

openssl pkcs12 -export -in MY.CRT -inkey MY.KEY -chain -CAfile CA-FILE.CRT -name &quot;MY-DOMAIN.COM&quot; -out my.p12

keytool -importkeystore -deststorepass CHANGEIT -destkeystore KEYSTORE.JKS -srckeystore my.p12 -srcstoretype PKCS12</summary>
    </entry>
    <entry>
        <title>kml</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/kml"/>
        <published>2017-03-27T16:34:03+00:00</published>
        <updated>2017-03-27T16:34:03+00:00</updated>
        <id>https://wiki.janforman.com/kml</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Set initial view to Czech Republic - Plzensky kraj


 &lt;LookAt&gt;
        &lt;longitude&gt;13.246&lt;/longitude&gt;
        &lt;latitude&gt;49.664&lt;/latitude&gt;
        &lt;altitude&gt;0&lt;/altitude&gt;
        &lt;heading&gt;0&lt;/heading&gt;
        &lt;tilt&gt;25&lt;/tilt&gt;
        &lt;range&gt;100000&lt;/range&gt;
        &lt;gx:altitudeMode&gt;relativeToSeaFloor&lt;/gx:altitudeMode&gt;
        &lt;TimeSpan&gt;
        &lt;begin&gt;2017-01&lt;/begin&gt;
        &lt;end&gt;2020-01&lt;/end&gt;
        &lt;/TimeSpan&gt;
 &lt;/LookAt&gt;</content>
        <summary>Set initial view to Czech Republic - Plzensky kraj


 &lt;LookAt&gt;
        &lt;longitude&gt;13.246&lt;/longitude&gt;
        &lt;latitude&gt;49.664&lt;/latitude&gt;
        &lt;altitude&gt;0&lt;/altitude&gt;
        &lt;heading&gt;0&lt;/heading&gt;
        &lt;tilt&gt;25&lt;/tilt&gt;
        &lt;range&gt;100000&lt;/range&gt;
        &lt;gx:altitudeMode&gt;relativeToSeaFloor&lt;/gx:altitudeMode&gt;
        &lt;TimeSpan&gt;
        &lt;begin&gt;2017-01&lt;/begin&gt;
        &lt;end&gt;2020-01&lt;/end&gt;
        &lt;/TimeSpan&gt;
 &lt;/LookAt&gt;</summary>
    </entry>
    <entry>
        <title>kubernetes</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/kubernetes"/>
        <published>2025-03-15T18:40:29+00:00</published>
        <updated>2025-03-15T18:40:29+00:00</updated>
        <id>https://wiki.janforman.com/kubernetes</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>&lt;https://K3S.io&gt;

kubectl alias to microk8s

sudo snap alias microk8s.kubectl kubectl
sudo usermod -aG microk8s $(whoami)
sudo microk8s enable dashboard
sudo microk8s enable dns
sudo microk8s enable registry
sudo microk8s enable ingress


access dashboard

microk8s dashboard-proxy</content>
        <summary>&lt;https://K3S.io&gt;

kubectl alias to microk8s

sudo snap alias microk8s.kubectl kubectl
sudo usermod -aG microk8s $(whoami)
sudo microk8s enable dashboard
sudo microk8s enable dns
sudo microk8s enable registry
sudo microk8s enable ingress


access dashboard

microk8s dashboard-proxy</summary>
    </entry>
    <entry>
        <title>linux</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/linux"/>
        <published>2025-10-29T11:27:12+00:00</published>
        <updated>2025-10-29T11:27:12+00:00</updated>
        <id>https://wiki.janforman.com/linux</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>LINUX Index
 Unsorted  Check storage speed  Erase single bad block  Find samples  Simple init.d script  Systemd Control  Top Command  PID Memory Map  Mail  Rsync  Security hints  Send basic status  Count Lines of code  Linux commands  nginx web server  Check REST Services  SSHD  Time chrony     GENTOO  Gentoo  REDHAT  Redhat / Centos  DEBIAN  Debian  Kernel  Kernel  System Informations 
Install in CHROOT

LACP benchmark

iperf3 -c 172.24.16.1 -i 1 -t 3000 -P 16</content>
        <summary>LINUX Index
 Unsorted  Check storage speed  Erase single bad block  Find samples  Simple init.d script  Systemd Control  Top Command  PID Memory Map  Mail  Rsync  Security hints  Send basic status  Count Lines of code  Linux commands  nginx web server  Check REST Services  SSHD  Time chrony     GENTOO  Gentoo  REDHAT  Redhat / Centos  DEBIAN  Debian  Kernel  Kernel  System Informations 
Install in CHROOT

LACP benchmark

iperf3 -c 172.24.16.1 -i 1 -t 3000 -P 16</summary>
    </entry>
    <entry>
        <title>loadbalancing</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/loadbalancing"/>
        <published>2018-11-14T00:19:02+00:00</published>
        <updated>2018-11-14T00:19:02+00:00</updated>
        <id>https://wiki.janforman.com/loadbalancing</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Layer 4

A layer 4 load-balancer takes routing decision based on IPs and TCP or UDP ports.

Layer 7

NGINX / Healthcheck

&lt;https://github.com/yaoweibin/nginx_upstream_check_module&gt;


Full implementation needs NGINX Plus.

Protocols

Load balancing of HTTP / TCP connections


	*  HTTP/1.1, HTTP/2
	*  HTTPS
	*</content>
        <summary>Layer 4

A layer 4 load-balancer takes routing decision based on IPs and TCP or UDP ports.

Layer 7

NGINX / Healthcheck

&lt;https://github.com/yaoweibin/nginx_upstream_check_module&gt;


Full implementation needs NGINX Plus.

Protocols

Load balancing of HTTP / TCP connections


	*  HTTP/1.1, HTTP/2
	*  HTTPS
	*</summary>
    </entry>
    <entry>
        <title>lte</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/lte"/>
        <published>2022-11-20T10:34:09+00:00</published>
        <updated>2022-11-20T10:34:09+00:00</updated>
        <id>https://wiki.janforman.com/lte</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Czech LTE - Vodafone
FrequencyBandwithDownlinkUplinkBand    800 MHz2 x 10 MHz 75 Mbit/s  25 Mbit/s 20    1800 MHz2 x 20 MHz 150 Mbit/s  50 Mbit/s 3    2100 MHz2 x 10 MHz 75 Mbit/s  25 Mbit/s 1    2600 MHz2 x 20 MHz 150 Mbit/s  50 Mbit/s 7</content>
        <summary>Czech LTE - Vodafone
FrequencyBandwithDownlinkUplinkBand    800 MHz2 x 10 MHz 75 Mbit/s  25 Mbit/s 20    1800 MHz2 x 20 MHz 150 Mbit/s  50 Mbit/s 3    2100 MHz2 x 10 MHz 75 Mbit/s  25 Mbit/s 1    2600 MHz2 x 20 MHz 150 Mbit/s  50 Mbit/s 7</summary>
    </entry>
    <entry>
        <title>lxc</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/lxc"/>
        <published>2023-05-03T22:54:55+00:00</published>
        <updated>2023-05-03T22:54:55+00:00</updated>
        <id>https://wiki.janforman.com/lxc</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>LXC Images

&lt;https://images.linuxcontainers.org/images/&gt;

LXC in Proxmox

/usr/share/perl5/PVE/LXC/Setup

Restore unmanaged LXC container

working with any linux distro

cmode shell (no login)

pct restore 100 vzdump-openvz-100-xxx.tar.gz -storage=local-lvm -ostype=unmanaged -cmode shell

Mount LXC container for maintenance</content>
        <summary>LXC Images

&lt;https://images.linuxcontainers.org/images/&gt;

LXC in Proxmox

/usr/share/perl5/PVE/LXC/Setup

Restore unmanaged LXC container

working with any linux distro

cmode shell (no login)

pct restore 100 vzdump-openvz-100-xxx.tar.gz -storage=local-lvm -ostype=unmanaged -cmode shell

Mount LXC container for maintenance</summary>
    </entry>
    <entry>
        <title>mariadb</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/mariadb"/>
        <published>2025-04-22T10:58:31+00:00</published>
        <updated>2025-04-22T10:58:31+00:00</updated>
        <id>https://wiki.janforman.com/mariadb</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>System variables

&lt;https://mariadb.com/kb/en/mariadb/server-system-variables/&gt;

Performance report

wget mysqltuner.pl

Find duplicates

SELECT evcj, udalostid FROM log
GROUP BY udalostid,evcj HAVING count(udalostid) &gt; 1

Remove duplicates by index

ALTER IGNORE TABLE nazev ADD UNIQUE INDEX (a,b)

CVE-2016-6662</content>
        <summary>System variables

&lt;https://mariadb.com/kb/en/mariadb/server-system-variables/&gt;

Performance report

wget mysqltuner.pl

Find duplicates

SELECT evcj, udalostid FROM log
GROUP BY udalostid,evcj HAVING count(udalostid) &gt; 1

Remove duplicates by index

ALTER IGNORE TABLE nazev ADD UNIQUE INDEX (a,b)

CVE-2016-6662</summary>
    </entry>
    <entry>
        <title>meterprecision</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/meterprecision"/>
        <published>2018-07-08T19:07:54+00:00</published>
        <updated>2018-07-08T19:07:54+00:00</updated>
        <id>https://wiki.janforman.com/meterprecision</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>UNI-T 890C+

Datasheet values - compared to Fluke 87V isn't that bad
 Basic functions  Range  Basic accuracy  DC voltage V  600.0mV  (0.5% + 4)  DC voltage V  6.000V / 60.00V / 600.0V  (0.5% + 2)  DC voltage V  1000V  (0.7% + 10)  AC voltage V  6.000V / 60.00V / 600.0V</content>
        <summary>UNI-T 890C+

Datasheet values - compared to Fluke 87V isn't that bad
 Basic functions  Range  Basic accuracy  DC voltage V  600.0mV  (0.5% + 4)  DC voltage V  6.000V / 60.00V / 600.0V  (0.5% + 2)  DC voltage V  1000V  (0.7% + 10)  AC voltage V  6.000V / 60.00V / 600.0V</summary>
    </entry>
    <entry>
        <title>microcloud</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/microcloud"/>
        <published>2026-04-08T20:31:48+00:00</published>
        <updated>2026-04-08T20:31:48+00:00</updated>
        <id>https://wiki.janforman.com/microcloud</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Micro Cloud (Hybrid) Architecture DRAFT

Disposable HW and SW architecture requied! Vendor-lock-in may be kept at minimum levels.
SDDC (Software-Defined Data Center): A data storage facility where networking, storage, CPU and security are virtualized and delivered as a service. Stable, cheap, good enough.</content>
        <summary>Micro Cloud (Hybrid) Architecture DRAFT

Disposable HW and SW architecture requied! Vendor-lock-in may be kept at minimum levels.
SDDC (Software-Defined Data Center): A data storage facility where networking, storage, CPU and security are virtualized and delivered as a service. Stable, cheap, good enough.</summary>
    </entry>
    <entry>
        <title>microservices</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/microservices"/>
        <published>2019-06-27T11:39:45+00:00</published>
        <updated>2019-06-27T11:39:45+00:00</updated>
        <id>https://wiki.janforman.com/microservices</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Service Decomposition  -&gt;  -&gt;  -&gt;  Monolithic  SOA  Microservices  No granularity o  Some granularity oo  Fine granularity ooooo 
Benefits

	*  The services are easy to replace
	*  Not dependent on programming language
	*  Best / finest granularity
	*</content>
        <summary>Service Decomposition  -&gt;  -&gt;  -&gt;  Monolithic  SOA  Microservices  No granularity o  Some granularity oo  Fine granularity ooooo 
Benefits

	*  The services are easy to replace
	*  Not dependent on programming language
	*  Best / finest granularity
	*</summary>
    </entry>
    <entry>
        <title>modsecurity</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/modsecurity"/>
        <published>2022-03-22T14:34:18+00:00</published>
        <updated>2022-03-22T14:34:18+00:00</updated>
        <id>https://wiki.janforman.com/modsecurity</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>modsecurity

Whitelist


SecRuleRemoveById 952100 959100
SecRule REQUEST_URI &quot;@beginsWith /url&quot; &quot;phase:1,nolog,allow,ctl:ruleRemoveById=949100,id:1&quot;</content>
        <summary>modsecurity

Whitelist


SecRuleRemoveById 952100 959100
SecRule REQUEST_URI &quot;@beginsWith /url&quot; &quot;phase:1,nolog,allow,ctl:ruleRemoveById=949100,id:1&quot;</summary>
    </entry>
    <entry>
        <title>mqtt</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/mqtt"/>
        <published>2022-02-15T14:57:26+00:00</published>
        <updated>2022-02-15T14:57:26+00:00</updated>
        <id>https://wiki.janforman.com/mqtt</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>MQTT

Mosquitto


mosquitto_passwd -c /etc/mosquitto/pwdfile user



allow_anonymous false
password_file /etc/mosquitto/pwdfile


...

configure websocket


listener 8083
protocol websockets
certfile /etc/letsencrypt/live/mqtt.example.com/cert.pem
cafile /etc/letsencrypt/live/mqtt.example.com/chain.pem
keyfile /etc/letsencrypt/live/mqtt.example.com/privkey.pem</content>
        <summary>MQTT

Mosquitto


mosquitto_passwd -c /etc/mosquitto/pwdfile user



allow_anonymous false
password_file /etc/mosquitto/pwdfile


...

configure websocket


listener 8083
protocol websockets
certfile /etc/letsencrypt/live/mqtt.example.com/cert.pem
cafile /etc/letsencrypt/live/mqtt.example.com/chain.pem
keyfile /etc/letsencrypt/live/mqtt.example.com/privkey.pem</summary>
    </entry>
    <entry>
        <title>netxms</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/netxms"/>
        <published>2018-12-04T14:39:56+00:00</published>
        <updated>2018-12-04T14:39:56+00:00</updated>
        <id>https://wiki.janforman.com/netxms</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Download static archive from
&lt;http://www.netxms.org/download/&gt;


/opt/netxms/bin/nxagentd


/etc/nxagentd.conf

MasterServers have full access to the node! Servers read-only

Encryption se to AES128 only (for performance)


MasterServers = IPs
Servers = IPs
LogFile = /dev/null
FileStore = /tmp
EnabledCiphers = 16
ExternalParameterShellExec=CEPH_Health:/opt/netxms/bin/ceph-status.sh</content>
        <summary>Download static archive from
&lt;http://www.netxms.org/download/&gt;


/opt/netxms/bin/nxagentd


/etc/nxagentd.conf

MasterServers have full access to the node! Servers read-only

Encryption se to AES128 only (for performance)


MasterServers = IPs
Servers = IPs
LogFile = /dev/null
FileStore = /tmp
EnabledCiphers = 16
ExternalParameterShellExec=CEPH_Health:/opt/netxms/bin/ceph-status.sh</summary>
    </entry>
    <entry>
        <title>openstack</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/openstack"/>
        <published>2024-09-04T15:47:13+00:00</published>
        <updated>2024-09-04T15:47:13+00:00</updated>
        <id>https://wiki.janforman.com/openstack</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Minimum nodes = 5

Install OpenStack in LXC on CentOS 7

Base


yum install centos-release-openstack-newton
yum upgrade
yum install python-openstackclient memcached


Dashboard


yum install openstack-dashboard


/etc/openstack-dashboard/local_settings</content>
        <summary>Minimum nodes = 5

Install OpenStack in LXC on CentOS 7

Base


yum install centos-release-openstack-newton
yum upgrade
yum install python-openstackclient memcached


Dashboard


yum install openstack-dashboard


/etc/openstack-dashboard/local_settings</summary>
    </entry>
    <entry>
        <title>openstreetmap</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/openstreetmap"/>
        <published>2020-08-11T15:46:53+00:00</published>
        <updated>2020-08-11T15:46:53+00:00</updated>
        <id>https://wiki.janforman.com/openstreetmap</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Cache


proxy_cache_path  /tmp/cache levels=1:2 keys_zone=openstreetmap-backend-cache:8$
proxy_temp_path   /tmp/cache/tmp;

upstream openstreetmap_backend {
  server  a.tile.openstreetmap.org;
  server  b.tile.openstreetmap.org;
  server  c.tile.openstreetmap.org;
}</content>
        <summary>Cache


proxy_cache_path  /tmp/cache levels=1:2 keys_zone=openstreetmap-backend-cache:8$
proxy_temp_path   /tmp/cache/tmp;

upstream openstreetmap_backend {
  server  a.tile.openstreetmap.org;
  server  b.tile.openstreetmap.org;
  server  c.tile.openstreetmap.org;
}</summary>
    </entry>
    <entry>
        <title>openvpn</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/openvpn"/>
        <published>2016-12-13T20:39:22+00:00</published>
        <updated>2016-12-13T20:39:22+00:00</updated>
        <id>https://wiki.janforman.com/openvpn</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>TUN - Route

TAP - Bridge

Server custom


sndbuf 225280
rcvbuf 225280
txqueuelen 486
fast-io
nice -5


Tested on MIPS 533Mhz

Static key client sample


proto udp
remote ip.janforman.com
dev tun
ifconfig 10.8.0.2 10.8.0.1
route 172.24.16.0 255.255.255.0 10.8.0.1
secret static.key
cipher AES-128-CBC
verb 0
mute 20
mssfix 1432
keepalive 10 60
ping-timer-rem
persist-tun
persist-key
sndbuf 393216
rcvbuf 393216
fast-io</content>
        <summary>TUN - Route

TAP - Bridge

Server custom


sndbuf 225280
rcvbuf 225280
txqueuelen 486
fast-io
nice -5


Tested on MIPS 533Mhz

Static key client sample


proto udp
remote ip.janforman.com
dev tun
ifconfig 10.8.0.2 10.8.0.1
route 172.24.16.0 255.255.255.0 10.8.0.1
secret static.key
cipher AES-128-CBC
verb 0
mute 20
mssfix 1432
keepalive 10 60
ping-timer-rem
persist-tun
persist-key
sndbuf 393216
rcvbuf 393216
fast-io</summary>
    </entry>
    <entry>
        <title>openvz</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/openvz"/>
        <published>2016-09-06T20:18:52+00:00</published>
        <updated>2016-09-06T20:18:52+00:00</updated>
        <id>https://wiki.janforman.com/openvz</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>ORACLE JAVA

JAVA VM Out of Memory - be careful with UBC

Proxmox UBC file location is


/etc/vz/conf/xxx.conf

Notice: Proxmox can rewrite this file when you are changing configuration from web interface!


kmemsize        5125208    5128321   40098656   44108521          0
privvmpages       77431      77666     750000     825000          0
physpages         44243      44371          0 2147483647          0</content>
        <summary>ORACLE JAVA

JAVA VM Out of Memory - be careful with UBC

Proxmox UBC file location is


/etc/vz/conf/xxx.conf

Notice: Proxmox can rewrite this file when you are changing configuration from web interface!


kmemsize        5125208    5128321   40098656   44108521          0
privvmpages       77431      77666     750000     825000          0
physpages         44243      44371          0 2147483647          0</summary>
    </entry>
    <entry>
        <title>oracle</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/oracle"/>
        <published>2021-02-22T09:52:12+00:00</published>
        <updated>2021-02-22T09:52:12+00:00</updated>
        <id>https://wiki.janforman.com/oracle</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>ORACLE Index

Backup

Archive Mode

Startup scripts

Install

List Tablespaces

select tablespace_name, file_name, bytes, autoextensible from dba_data_files;

Show ASM

SELECT name, free_mb, total_mb, free_mb/total_mb*100 as percentage FROM v$asm_diskgroup;

Add More Space

alter database datafile '/full/path/to/system01.dbf' autoextend on next 128m maxsize 8192m;
alter tablespace SYSTEM add datafile '/full/path/to/system02.dbf' size 512m;</content>
        <summary>ORACLE Index

Backup

Archive Mode

Startup scripts

Install

List Tablespaces

select tablespace_name, file_name, bytes, autoextensible from dba_data_files;

Show ASM

SELECT name, free_mb, total_mb, free_mb/total_mb*100 as percentage FROM v$asm_diskgroup;

Add More Space

alter database datafile '/full/path/to/system01.dbf' autoextend on next 128m maxsize 8192m;
alter tablespace SYSTEM add datafile '/full/path/to/system02.dbf' size 512m;</summary>
    </entry>
    <entry>
        <title>postgresql</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/postgresql"/>
        <published>2025-08-19T16:32:30+00:00</published>
        <updated>2025-08-19T16:32:30+00:00</updated>
        <id>https://wiki.janforman.com/postgresql</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Postgresql

Duplicate Layer

CREATE TABLE new_table AS SELECT * FROM old_table

effective_io_concurrency = X

Can be raised for SSDs


for I in `/usr/bin/psql -d template1 -q -t -c &quot;SELECT datname FROM pg_database WHERE datname NOT IN ('template0') ORDER BY datname;&quot;`; do
        /usr/bin/pg_dump -F t ${I} | /usr/bin/lzop -1 &gt; ${TEMPDIR}/${DATE}${I}.tar.lzo
done</content>
        <summary>Postgresql

Duplicate Layer

CREATE TABLE new_table AS SELECT * FROM old_table

effective_io_concurrency = X

Can be raised for SSDs


for I in `/usr/bin/psql -d template1 -q -t -c &quot;SELECT datname FROM pg_database WHERE datname NOT IN ('template0') ORDER BY datname;&quot;`; do
        /usr/bin/pg_dump -F t ${I} | /usr/bin/lzop -1 &gt; ${TEMPDIR}/${DATE}${I}.tar.lzo
done</summary>
    </entry>
    <entry>
        <title>proxmox</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/proxmox"/>
        <published>2023-12-29T18:30:15+00:00</published>
        <updated>2023-12-29T18:30:15+00:00</updated>
        <id>https://wiki.janforman.com/proxmox</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Remove subscription dialog

sed -Ezi.bak &quot;s/(Ext.Msg.show\(\{\s+title: gettext\('No valid sub)/void\(\{ \/\/\1/g&quot; /usr/share/javascript/proxmox-widget-toolkit/proxmoxlib.js &amp;&amp; systemctl restart pveproxy.service

BIOS Tweaking
 I/OAT DMA Engine  ?  &lt;https://en.wikipedia.org/wiki/I/O_Acceleration_Technology&gt;  SRV/IOV Global Enable</content>
        <summary>Remove subscription dialog

sed -Ezi.bak &quot;s/(Ext.Msg.show\(\{\s+title: gettext\('No valid sub)/void\(\{ \/\/\1/g&quot; /usr/share/javascript/proxmox-widget-toolkit/proxmoxlib.js &amp;&amp; systemctl restart pveproxy.service

BIOS Tweaking
 I/OAT DMA Engine  ?  &lt;https://en.wikipedia.org/wiki/I/O_Acceleration_Technology&gt;  SRV/IOV Global Enable</summary>
    </entry>
    <entry>
        <title>proxmoxgpu</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/proxmoxgpu"/>
        <published>2017-06-16T20:58:31+00:00</published>
        <updated>2017-06-16T20:58:31+00:00</updated>
        <id>https://wiki.janforman.com/proxmoxgpu</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Prepare Server

/etc/apt/sources.list


# jessie-backports
deb http://httpredir.debian.org/debian jessie-backports main contrib non-free


apt-cache search pve-header

apt-get install pve-headers-4.4.67-1-pve



apt-get install -t jessie-backports nvidia-driver</content>
        <summary>Prepare Server

/etc/apt/sources.list


# jessie-backports
deb http://httpredir.debian.org/debian jessie-backports main contrib non-free


apt-cache search pve-header

apt-get install pve-headers-4.4.67-1-pve



apt-get install -t jessie-backports nvidia-driver</summary>
    </entry>
    <entry>
        <title>raspberrypi</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/raspberrypi"/>
        <published>2025-11-01T11:41:54+00:00</published>
        <updated>2025-11-01T11:41:54+00:00</updated>
        <id>https://wiki.janforman.com/raspberrypi</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Raspberry PI 5 as Server

&lt;https://browser.geekbench.com/v6/cpu/4184440&gt; 2.4Ghz

&lt;https://browser.geekbench.com/v6/cpu/4185322&gt; 2.8Ghz



Only HEVC/H265 8/10bit decoding supported (HDMI is HDR10 capable)


Storage Peformance

USB/SATA - VIA VL716 FW:85.43.1.8 UASP (raw read/write 578/212 MB/s)

SD Card Verbatim 64GB A1 V30 U3 (raw read/write 85/54</content>
        <summary>Raspberry PI 5 as Server

&lt;https://browser.geekbench.com/v6/cpu/4184440&gt; 2.4Ghz

&lt;https://browser.geekbench.com/v6/cpu/4185322&gt; 2.8Ghz



Only HEVC/H265 8/10bit decoding supported (HDMI is HDR10 capable)


Storage Peformance

USB/SATA - VIA VL716 FW:85.43.1.8 UASP (raw read/write 578/212 MB/s)

SD Card Verbatim 64GB A1 V30 U3 (raw read/write 85/54</summary>
    </entry>
    <entry>
        <title>rsync</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/rsync"/>
        <published>2023-02-23T11:25:33+00:00</published>
        <updated>2023-02-23T11:25:33+00:00</updated>
        <id>https://wiki.janforman.com/rsync</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>RSYNC

/etc/rsyncd.conf


use chroot = yes

[documents]
    path = /storage/public
    comment = Public
    uid = nobody
    gid = nobody
    read only = no
    list = yes
    auth users = rsyncclient
    secrets file = /etc/rsyncd.secrets
    hosts allow = 10.0.0.0/255.0.0.0</content>
        <summary>RSYNC

/etc/rsyncd.conf


use chroot = yes

[documents]
    path = /storage/public
    comment = Public
    uid = nobody
    gid = nobody
    read only = no
    list = yes
    auth users = rsyncclient
    secrets file = /etc/rsyncd.secrets
    hosts allow = 10.0.0.0/255.0.0.0</summary>
    </entry>
    <entry>
        <title>scylladb</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/scylladb"/>
        <published>2023-02-06T13:36:31+00:00</published>
        <updated>2023-02-06T13:36:31+00:00</updated>
        <id>https://wiki.janforman.com/scylladb</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Consistency Levels
 ANY  A write is written to at least one node in the cluster. Provides the highest availability with the lowest consistency.  QUORUM  When a majority of the replicas respond, the request is honored. If RF=3, then 2 replicas respond. QUORUM can be calculated using the formula (n/2 +1) where n is the Replication Factor.</content>
        <summary>Consistency Levels
 ANY  A write is written to at least one node in the cluster. Provides the highest availability with the lowest consistency.  QUORUM  When a majority of the replicas respond, the request is honored. If RF=3, then 2 replicas respond. QUORUM can be calculated using the formula (n/2 +1) where n is the Replication Factor.</summary>
    </entry>
    <entry>
        <title>sdcards</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/sdcards"/>
        <published>2016-02-26T16:33:09+00:00</published>
        <updated>2016-02-26T16:33:09+00:00</updated>
        <id>https://wiki.janforman.com/sdcards</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>! for internal use !
Size   Name  Class  Write  READ  8GB  Pretec  6  6MB/s  15MB/s  16GB  Kingston  4  11MB/s  18MB/s  4GB  Integral  4  7MB/s  17MB/s  8GB  Samsung   6  10MB/s  17MB/s  32GB  Transcend  10-U1  45MB/s  85MB/s</content>
        <summary>! for internal use !
Size   Name  Class  Write  READ  8GB  Pretec  6  6MB/s  15MB/s  16GB  Kingston  4  11MB/s  18MB/s  4GB  Integral  4  7MB/s  17MB/s  8GB  Samsung   6  10MB/s  17MB/s  32GB  Transcend  10-U1  45MB/s  85MB/s</summary>
    </entry>
    <entry>
        <title>sdr</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/sdr"/>
        <published>2018-02-22T13:04:09+00:00</published>
        <updated>2018-02-22T13:04:09+00:00</updated>
        <id>https://wiki.janforman.com/sdr</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Frequency List Plzeň
 Frequency  Bandwidth  Modulation  Description  172.760500 MHz  6 KHz  Narrow FM  TAXI  448.515600 MHz  8 kHz  Narrow FM   137.100000 MHz         RAW        Meteor-M2 LRPT  137.620000 MHz         RAW        NOAA 15  137.912500 MHz</content>
        <summary>Frequency List Plzeň
 Frequency  Bandwidth  Modulation  Description  172.760500 MHz  6 KHz  Narrow FM  TAXI  448.515600 MHz  8 kHz  Narrow FM   137.100000 MHz         RAW        Meteor-M2 LRPT  137.620000 MHz         RAW        NOAA 15  137.912500 MHz</summary>
    </entry>
    <entry>
        <title>snmp</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/snmp"/>
        <published>2016-11-29T11:06:20+00:00</published>
        <updated>2016-11-29T11:06:20+00:00</updated>
        <id>https://wiki.janforman.com/snmp</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Synology NAS
 Type  OID  CPU  1.3.6.1.4.1.2021.10.1.5.1  Memory Size  1.3.6.1.2.1.25.2.2.0  Used Storage  1.3.6.1.2.1.25.2.3.1.5.36  CPU Load / minute  1.3.6.1.4.1.2021.10.1.3.1  CPU Load Percent  1.3.6.1.4.1.2021.10.1.5.1  OS Version  .1.3.6.1.4.1.6574.1.5.3.0</content>
        <summary>Synology NAS
 Type  OID  CPU  1.3.6.1.4.1.2021.10.1.5.1  Memory Size  1.3.6.1.2.1.25.2.2.0  Used Storage  1.3.6.1.2.1.25.2.3.1.5.36  CPU Load / minute  1.3.6.1.4.1.2021.10.1.3.1  CPU Load Percent  1.3.6.1.4.1.2021.10.1.5.1  OS Version  .1.3.6.1.4.1.6574.1.5.3.0</summary>
    </entry>
    <entry>
        <title>softskills</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/softskills"/>
        <published>2017-04-14T21:49:45+00:00</published>
        <updated>2017-04-14T21:49:45+00:00</updated>
        <id>https://wiki.janforman.com/softskills</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Jak poznat psychopata

	*  Neschopnost sestavit fungující tým, protože je individualista a nerozumí skupinové dynamice.
	*  Rovněž se bude snažit narušit správné fungování týmu svým chováním. Nicméně bude tvrdit, že dělá vše pro to, aby byly tým i organizace úspěšné.</content>
        <summary>Jak poznat psychopata

	*  Neschopnost sestavit fungující tým, protože je individualista a nerozumí skupinové dynamice.
	*  Rovněž se bude snažit narušit správné fungování týmu svým chováním. Nicméně bude tvrdit, že dělá vše pro to, aby byly tým i organizace úspěšné.</summary>
    </entry>
    <entry>
        <title>sql</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/sql"/>
        <published>2018-06-08T15:35:48+00:00</published>
        <updated>2018-06-08T15:35:48+00:00</updated>
        <id>https://wiki.janforman.com/sql</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>DB Fiddle

DB Fiddle

Update string


UPDATE data SET VALUE = REPLACE(VALUE, '123', '') WHERE ID &lt;= 4 AND Value LIKE '%123%'



SELECT CASE &lt;variable&gt; WHEN &lt;value&gt;      THEN &lt;returnvalue&gt;
                       WHEN &lt;othervalue&gt; THEN &lt;returnthis&gt;
                                         ELSE &lt;returndefaultcase&gt;
       END AS &lt;newcolumnname&gt;
FROM &lt;table&gt;</content>
        <summary>DB Fiddle

DB Fiddle

Update string


UPDATE data SET VALUE = REPLACE(VALUE, '123', '') WHERE ID &lt;= 4 AND Value LIKE '%123%'



SELECT CASE &lt;variable&gt; WHEN &lt;value&gt;      THEN &lt;returnvalue&gt;
                       WHEN &lt;othervalue&gt; THEN &lt;returnthis&gt;
                                         ELSE &lt;returndefaultcase&gt;
       END AS &lt;newcolumnname&gt;
FROM &lt;table&gt;</summary>
    </entry>
    <entry>
        <title>sqlite</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/sqlite"/>
        <published>2019-01-04T12:10:20+00:00</published>
        <updated>2019-01-04T12:10:20+00:00</updated>
        <id>https://wiki.janforman.com/sqlite</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Create node from node to

Create temporary roads


CREATE VIEW tmp_roads AS
SELECT *, STARTPOINT(geometry) AS startp, ENDPOINT(geometry) AS endp
FROM roads


Create nodes

CREATE TABLE nodes AS
SELECT '' AS ID, a.p AS Geometry FROM (SELECT DISTINCT tmp_roads.startp AS p FROM tmp_roads UNION SELECT DISTINCT tmp_roads.endp AS p FROM tmp_roads) a GROUP BY a.p;
UPDATE nodes SET ID = ROWID;</content>
        <summary>Create node from node to

Create temporary roads


CREATE VIEW tmp_roads AS
SELECT *, STARTPOINT(geometry) AS startp, ENDPOINT(geometry) AS endp
FROM roads


Create nodes

CREATE TABLE nodes AS
SELECT '' AS ID, a.p AS Geometry FROM (SELECT DISTINCT tmp_roads.startp AS p FROM tmp_roads UNION SELECT DISTINCT tmp_roads.endp AS p FROM tmp_roads) a GROUP BY a.p;
UPDATE nodes SET ID = ROWID;</summary>
    </entry>
    <entry>
        <title>ssd</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/ssd"/>
        <published>2022-04-19T14:05:01+00:00</published>
        <updated>2022-04-19T14:05:01+00:00</updated>
        <id>https://wiki.janforman.com/ssd</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>SSD lifespan (TBW value)

TBW rating for client SSDs is based on 1-year data retention at 30C as per JEDEC#218 specifications
Usage  Power-on  Power-off (retention)  Client  40°C 8hrs/day  30°C 1year  Enterprise  55°C 24hrs/day  40°C 3mon 
Datacenter specifications for NVMe</content>
        <summary>SSD lifespan (TBW value)

TBW rating for client SSDs is based on 1-year data retention at 30C as per JEDEC#218 specifications
Usage  Power-on  Power-off (retention)  Client  40°C 8hrs/day  30°C 1year  Enterprise  55°C 24hrs/day  40°C 3mon 
Datacenter specifications for NVMe</summary>
    </entry>
    <entry>
        <title>start</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/start"/>
        <published>2025-07-29T09:38:46+00:00</published>
        <updated>2025-07-29T09:38:46+00:00</updated>
        <id>https://wiki.janforman.com/start</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>IT UNSORTED    Micro Cloud   Microsoft Windows hints  -&gt; Linux hints  Cryptography  DNS  ISPConfig  JAVA  Critical Bugs / Exploits  WIFI  OpenVPN  Linux under Windows  Gamepad   Neural Networks   Basic  Prompts  Keywords    DATABASES   Oracle hints  MariaDB / MySQL hints  PostgreSQL  Cassandra  ScyllaDB  Simple Query Language  SQLite + Spatialite  CitusData   INTEGRATION   WSO2 Hints  Loadbalancing  API  Microservices  WSO2 IoT  XSLT  Synapse ESB  Enterprise Architecture  MQTT     STORAGE   LVM …</content>
        <summary>IT UNSORTED    Micro Cloud   Microsoft Windows hints  -&gt; Linux hints  Cryptography  DNS  ISPConfig  JAVA  Critical Bugs / Exploits  WIFI  OpenVPN  Linux under Windows  Gamepad   Neural Networks   Basic  Prompts  Keywords    DATABASES   Oracle hints  MariaDB / MySQL hints  PostgreSQL  Cassandra  ScyllaDB  Simple Query Language  SQLite + Spatialite  CitusData   INTEGRATION   WSO2 Hints  Loadbalancing  API  Microservices  WSO2 IoT  XSLT  Synapse ESB  Enterprise Architecture  MQTT     STORAGE   LVM …</summary>
    </entry>
    <entry>
        <title>streaming</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/streaming"/>
        <published>2022-07-10T14:53:23+00:00</published>
        <updated>2022-07-10T14:53:23+00:00</updated>
        <id>https://wiki.janforman.com/streaming</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Possible ways to stream video to janforman.com

Anyway you can use these with Youtube Live because it's same technology.
HTML5 player is available here janforman.com/j-live

FFMPEG Stream file to RTMP

X264

c:\programs\stream\ffmpeg -i stream.mp4 --keyint 10 -codec:v libx264 -b:v 3000k -maxrate 4000k -preset slow -r 23 -s 1920x1080 -codec:a aac -ab 128k -ac 2 -ar 44100 -f flv &quot;rtmp://janforman.com/live/tv?token=Br7dYCHR&quot;</content>
        <summary>Possible ways to stream video to janforman.com

Anyway you can use these with Youtube Live because it's same technology.
HTML5 player is available here janforman.com/j-live

FFMPEG Stream file to RTMP

X264

c:\programs\stream\ffmpeg -i stream.mp4 --keyint 10 -codec:v libx264 -b:v 3000k -maxrate 4000k -preset slow -r 23 -s 1920x1080 -codec:a aac -ab 128k -ac 2 -ar 44100 -f flv &quot;rtmp://janforman.com/live/tv?token=Br7dYCHR&quot;</summary>
    </entry>
    <entry>
        <title>synapse</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/synapse"/>
        <published>2019-06-25T12:24:26+00:00</published>
        <updated>2019-06-25T12:24:26+00:00</updated>
        <id>https://wiki.janforman.com/synapse</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Send Mail with XML

Dataservice / proxy (real endpoint)


&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
&lt;proxy xmlns=&quot;http://ws.apache.org/ns/synapse&quot;
       name=&quot;proxy&quot;
       startOnLoad=&quot;true&quot;
       statistics=&quot;disable&quot;
       trace=&quot;disable&quot;
       transports=&quot;http,https&quot;&gt;
   &lt;target endpoint=&quot;endpoint&quot;
           inSequence=&quot;cache&quot;
           outSequence=&quot;sendMailSequence&quot;/&gt;
   &lt;description/&gt;
&lt;/proxy&gt;</content>
        <summary>Send Mail with XML

Dataservice / proxy (real endpoint)


&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
&lt;proxy xmlns=&quot;http://ws.apache.org/ns/synapse&quot;
       name=&quot;proxy&quot;
       startOnLoad=&quot;true&quot;
       statistics=&quot;disable&quot;
       trace=&quot;disable&quot;
       transports=&quot;http,https&quot;&gt;
   &lt;target endpoint=&quot;endpoint&quot;
           inSequence=&quot;cache&quot;
           outSequence=&quot;sendMailSequence&quot;/&gt;
   &lt;description/&gt;
&lt;/proxy&gt;</summary>
    </entry>
    <entry>
        <title>synology</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/synology"/>
        <published>2018-07-05T19:54:04+00:00</published>
        <updated>2018-07-05T19:54:04+00:00</updated>
        <id>https://wiki.janforman.com/synology</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Connect LDAP Directory

BaseDN -&gt; CN=users,DC=corp,DC=janforman,DC=com

BindDN -&gt; CN=administrator,CN=Users,DC=corp,DC=janforman,DC=com


You can't join Windows AD by this sample, because proper attributes must be mapped.

Join Windows Active Directory Domain</content>
        <summary>Connect LDAP Directory

BaseDN -&gt; CN=users,DC=corp,DC=janforman,DC=com

BindDN -&gt; CN=administrator,CN=Users,DC=corp,DC=janforman,DC=com


You can't join Windows AD by this sample, because proper attributes must be mapped.

Join Windows Active Directory Domain</summary>
    </entry>
    <entry>
        <title>virtualization</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/virtualization"/>
        <published>2019-07-09T12:42:08+00:00</published>
        <updated>2019-07-09T12:42:08+00:00</updated>
        <id>https://wiki.janforman.com/virtualization</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>OpenVZ / LXC / Zones  KVM  CPU Performance  native  high (with CPU support)  CPU Allocation  flexible (FSS + “bursting”)  fixed to VCPU limit  I/O Throughput  high (no overhead)  low or medium (with virtio)  I/O Latency  low (native)  some (I/O proxy overhead)</content>
        <summary>OpenVZ / LXC / Zones  KVM  CPU Performance  native  high (with CPU support)  CPU Allocation  flexible (FSS + “bursting”)  fixed to VCPU limit  I/O Throughput  high (no overhead)  low or medium (with virtio)  I/O Latency  low (native)  some (I/O proxy overhead)</summary>
    </entry>
    <entry>
        <title>virtualreality</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/virtualreality"/>
        <published>2016-12-31T04:12:48+00:00</published>
        <updated>2016-12-31T04:12:48+00:00</updated>
        <id>https://wiki.janforman.com/virtualreality</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Ritech RIEM III Mobile VR / AR Headset

Google Cardboard QR Profile
Name in QR Value  Button type  Indirect Touch  Screen to lens distance  64mm  Interlens distance  54mm  Screen Vertical Alignment  Center  Disortion Coefficient  k1=0,140 k2=0,010  Field of view</content>
        <summary>Ritech RIEM III Mobile VR / AR Headset

Google Cardboard QR Profile
Name in QR Value  Button type  Indirect Touch  Screen to lens distance  64mm  Interlens distance  54mm  Screen Vertical Alignment  Center  Disortion Coefficient  k1=0,140 k2=0,010  Field of view</summary>
    </entry>
    <entry>
        <title>wifi</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/wifi"/>
        <published>2020-06-09T22:05:13+00:00</published>
        <updated>2020-06-09T22:05:13+00:00</updated>
        <id>https://wiki.janforman.com/wifi</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Standard  Frequency  Theoretical Speed  Real-World Speed  802.11a  5Ghz  6-54 Mbit/s  3 - 32 Mbit/s  802.11b  2.4Ghz  11 Mbit/s  2 - 3 Mbit/s  802.11g  2.4Ghz  54 Mbit/s  10 - 29 Mbit/s  802.11n  2.4Ghz  72,150,300 Mbit/s  48,96,200 Mbit/s  802.11n  5Ghz</content>
        <summary>Standard  Frequency  Theoretical Speed  Real-World Speed  802.11a  5Ghz  6-54 Mbit/s  3 - 32 Mbit/s  802.11b  2.4Ghz  11 Mbit/s  2 - 3 Mbit/s  802.11g  2.4Ghz  54 Mbit/s  10 - 29 Mbit/s  802.11n  2.4Ghz  72,150,300 Mbit/s  48,96,200 Mbit/s  802.11n  5Ghz</summary>
    </entry>
    <entry>
        <title>windows</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/windows"/>
        <published>2026-03-19T19:13:43+00:00</published>
        <updated>2026-03-19T19:13:43+00:00</updated>
        <id>https://wiki.janforman.com/windows</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Windows God Mode

Rename empty folder to

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

Windows 10 Pro Disable thumbs.db

Disable thumbs.db generation in Microsoft Windows. Import this key into system registry.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Advanced]
&quot;DisableThumbnailCache&quot;=dword:00000001</content>
        <summary>Windows God Mode

Rename empty folder to

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

Windows 10 Pro Disable thumbs.db

Disable thumbs.db generation in Microsoft Windows. Import this key into system registry.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Advanced]
&quot;DisableThumbnailCache&quot;=dword:00000001</summary>
    </entry>
    <entry>
        <title>wso2</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/wso2"/>
        <published>2022-05-16T10:34:29+00:00</published>
        <updated>2022-05-16T10:34:29+00:00</updated>
        <id>https://wiki.janforman.com/wso2</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>WSO2 Microintegrator

Unable to find axis service for service name

Disable error message by adding this to deployment.toml


[transport.http]
reverseProxyMode=true


Copy data from one DB to another by dataservice


&lt;data enableBatchRequests=&quot;true&quot; name=&quot;transferMAIL&quot; transports=&quot;http https local&quot;&gt;
&lt;!-- define source and destination --&gt;
   &lt;config enableOData=&quot;false&quot; id=&quot;DataSource&quot;&gt;
      &lt;property name=&quot;driverClassName&quot;&gt;org.mariadb.jdbc.Driver&lt;/property&gt;
      &lt;property name=&quot;url&quot;&gt;jdbc:mariad…</content>
        <summary>WSO2 Microintegrator

Unable to find axis service for service name

Disable error message by adding this to deployment.toml


[transport.http]
reverseProxyMode=true


Copy data from one DB to another by dataservice


&lt;data enableBatchRequests=&quot;true&quot; name=&quot;transferMAIL&quot; transports=&quot;http https local&quot;&gt;
&lt;!-- define source and destination --&gt;
   &lt;config enableOData=&quot;false&quot; id=&quot;DataSource&quot;&gt;
      &lt;property name=&quot;driverClassName&quot;&gt;org.mariadb.jdbc.Driver&lt;/property&gt;
      &lt;property name=&quot;url&quot;&gt;jdbc:mariad…</summary>
    </entry>
    <entry>
        <title>xslt</title>
        <link rel="alternate" type="text/html" href="https://wiki.janforman.com/xslt"/>
        <published>2017-11-08T13:52:49+00:00</published>
        <updated>2017-11-08T13:52:49+00:00</updated>
        <id>https://wiki.janforman.com/xslt</id>
        <author>
            <name>Anonymous</name>
            <email>anonymous@undisclosed.example.com</email>
        </author>
        <content>Header


&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
&lt;xsl:stylesheet xmlns:xsl=&quot;http://www.w3.org/1999/XSL/Transform&quot; version=&quot;1.0&quot;&gt;

&lt;/xsl&gt;                


Change atribute value


&lt;xsl:template match=&quot;@*|node()&quot;&gt;
  &lt;xsl:copy&gt;
    &lt;xsl:apply-templates select=&quot;@*|node()&quot;/&gt;
  &lt;/xsl:copy&gt;
&lt;/xsl:template&gt;
&lt;xsl:template match=&quot;@type[parent::property]&quot;&gt;
  &lt;xsl:attribute name=&quot;type&quot;&gt;
    &lt;xsl:value-of select=&quot;'your value here'&quot;/&gt;
  &lt;/xsl:attribute&gt;
&lt;/xsl:template&gt;</content>
        <summary>Header


&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
&lt;xsl:stylesheet xmlns:xsl=&quot;http://www.w3.org/1999/XSL/Transform&quot; version=&quot;1.0&quot;&gt;

&lt;/xsl&gt;                


Change atribute value


&lt;xsl:template match=&quot;@*|node()&quot;&gt;
  &lt;xsl:copy&gt;
    &lt;xsl:apply-templates select=&quot;@*|node()&quot;/&gt;
  &lt;/xsl:copy&gt;
&lt;/xsl:template&gt;
&lt;xsl:template match=&quot;@type[parent::property]&quot;&gt;
  &lt;xsl:attribute name=&quot;type&quot;&gt;
    &lt;xsl:value-of select=&quot;'your value here'&quot;/&gt;
  &lt;/xsl:attribute&gt;
&lt;/xsl:template&gt;</summary>
    </entry>
</feed>
