tag:blogger.com,1999:blog-51466069619390829322024-03-19T03:49:33.630+01:00Run like HellDietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.comBlogger594125tag:blogger.com,1999:blog-5146606961939082932.post-47309576864212492902024-02-03T19:24:00.009+01:002024-02-03T20:58:13.372+01:00Flashing Tasmota onto a Wifi sensor controller (MHCOZY TH1CH-B1RF)<p>Today i got a <a href="https://www.amazon.de/dp/B0CN54Z6H8" target="_blank">MHCOZY TH1CH-B1RF</a> and installed <a href="https://tasmota.github.io/docs/">tasmota</a>:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNTmjIf1fN6ZiHmKjnj_YEMU6rzSA12-BE__TkdMVgdz5eRDgwGqICvyFcpxEdvHED2gaqaORSHnfG-Fi6_SiSDLxSclIJnWWLhszcsmvuCt5FYVJKsDM3u4_cD_ipm7KCXEDwhRd9KSjTuN6XqAAvy4LHD96P6mAZcHqJagiuw4cTtq80LazFwC1Ng1bb/s507/Screenshot%20from%202024-02-03%2020-56-30.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="294" data-original-width="507" height="186" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNTmjIf1fN6ZiHmKjnj_YEMU6rzSA12-BE__TkdMVgdz5eRDgwGqICvyFcpxEdvHED2gaqaORSHnfG-Fi6_SiSDLxSclIJnWWLhszcsmvuCt5FYVJKsDM3u4_cD_ipm7KCXEDwhRd9KSjTuN6XqAAvy4LHD96P6mAZcHqJagiuw4cTtq80LazFwC1Ng1bb/s320/Screenshot%20from%202024-02-03%2020-56-30.png" width="320" /></a></div><p></p>MHCOZY TH1CH-B1RF is a Wifi temperature and humidity controller:<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiucaFPEhY1nUVSLsSQSdN6sau08fWEu_3-P2fDnfu3BCE6gieGB2h5ZkQsQ_REGtPya1ui-ewkWQ7IJXzdV3iSsRWCD8j5NEkLqX1RFb89fhOoikyHOoGKgC4kixnkavIexmqcezBlN2JtSH6zSmTFIR0wiHAlCw3dSHGMUtYfmKjRdRhXEgu48_dW92J_/s1711/20240203_184637.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1404" data-original-width="1711" height="263" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiucaFPEhY1nUVSLsSQSdN6sau08fWEu_3-P2fDnfu3BCE6gieGB2h5ZkQsQ_REGtPya1ui-ewkWQ7IJXzdV3iSsRWCD8j5NEkLqX1RFb89fhOoikyHOoGKgC4kixnkavIexmqcezBlN2JtSH6zSmTFIR0wiHAlCw3dSHGMUtYfmKjRdRhXEgu48_dW92J_/s320/20240203_184637.jpg" width="320" /></a></div>Product details say:<br /><blockquote><p>Users can add the device to the APP eWeLink in order to remotely control
connected home appliances or devices. In self-locking mode, customers
can remotely turn on/off connected devices immediately. When in inching
mode, customers can have two wiring ways to select: * Turn on 1s and
then auto-off,* Turn off 1s and then auto-on.</p></blockquote><p>Of course you can stay with the original software, but then you have to
integrate EWELINK to you enviroment (which uses port 5353 with some
strange multicast mechanism). I want to get the values via HTTP. So the questions is: Can this hardware run tasmota? <br /></p><p>If you open this device, you see, that the chip is a PSF-Bxx:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgs2cnBZZO3fonv6xEi0ZE-VprjtlwAythnz7lTIFXbuF9TDa9V8rn62y4cIqFOefqLi93yNj199M_ccRSOfd8-Py-GHoxVx4ZW1-_MGmOYpNgMlmFHr-7GE9IrfuRH7CIsdIe2q__A9SKU8xtM3oqfFuHLAAcfaLcb9MSTH8NnrfwgytpSR1dyaPrXmhAD/s609/Screenshot%20from%202024-02-03%2018-49-35.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="532" data-original-width="609" height="280" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgs2cnBZZO3fonv6xEi0ZE-VprjtlwAythnz7lTIFXbuF9TDa9V8rn62y4cIqFOefqLi93yNj199M_ccRSOfd8-Py-GHoxVx4ZW1-_MGmOYpNgMlmFHr-7GE9IrfuRH7CIsdIe2q__A9SKU8xtM3oqfFuHLAAcfaLcb9MSTH8NnrfwgytpSR1dyaPrXmhAD/s320/Screenshot%20from%202024-02-03%2018-49-35.png" width="320" /></a></div><div style="text-align: center;">(picture is a screenshot from here: <a href="https://templates.blakadder.com/PSF-B.html">https://templates.blakadder.com/PSF-B.html</a>)<br /></div><div><br /><p></p><p>With knowing that, Tasmota can be flashed onto this device:<br />(all the connects are a little bit tricky, because there are no plugs and <span class="HwtZe" lang="en"><span class="jCAhz ChMk0b"><span class="ryNqvb">you have to constantly touch the contacts with the pins)</span></span></span> </p><ol style="text-align: left;"><li>Connect GPIO0 with ground (you can use the shielding of the USB connector on the board) </li><li>Insert power via the USB connector</li><li>after 5 seconds remove the connection from GPIO0 to ground</li><li>connect your <a href="https://tasmota.github.io/docs/Getting-Started/">serial programmer</a> TX --> chip RX</li><li>connect your serial programmer RX --> chip TX <br />(i always start with TX --> TX and RX --> RX, which is wrong đ¤ ) <br /></li><li>open tasmotizer.py<br />(for installation look <a href="https://github.com/tasmota/tasmotizer?tab=readme-ov-file#installation-and-how-to-run">here</a> - i chose option 2)</li><li>if you choose "backup - save original firmware", then you have to start after the backup with step 1 again.</li><li>choose "release" and "tasmota.bin"<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ7BigLcKiYixv5zEHkJvHmtNQEOti5c1VBu3dgtO81Bv4E7Ttm7_ge_0FPZ0KEG6HPZwapU75IUU8UYukv1SLNEblj6fJZsm6UGVqAFdRCRvK5LNqXGQ-p6hkZCD6ojL0qmoghmGcyRo7Bthg4Zcaixw_xswDDI9He8o11xnknZsn58A8aOgZ4Vdsp4Bh/s505/Screenshot%20from%202024-02-03%2019-02-21.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="500" data-original-width="505" height="317" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ7BigLcKiYixv5zEHkJvHmtNQEOti5c1VBu3dgtO81Bv4E7Ttm7_ge_0FPZ0KEG6HPZwapU75IUU8UYukv1SLNEblj6fJZsm6UGVqAFdRCRvK5LNqXGQ-p6hkZCD6ojL0qmoghmGcyRo7Bthg4Zcaixw_xswDDI9He8o11xnknZsn58A8aOgZ4Vdsp4Bh/s320/Screenshot%20from%202024-02-03%2019-02-21.png" width="320" /></a></div></li><li>click "Tasmotize!"</li></ol><p>After a reboot change to the new Wifi "tasmota....XXXX" and enter your Wifi credentials there on 192.168.4.1. And after a reboot you can open the web GUI like this here:</p><p> </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh80SWktRWO6hv7IKtf2AcdSb3Oc5kJbT1U2vjxfhyphenhyphen0hB6EP3MDM_VIKvy4LiwTE5prKtLNtMOL9UFEtVF4sig2xIQP0zEjFm9I8bTO8oPpe0rDCp7q4u_aNFkKogJjxM3djJOU9SV3nA7tzmUAHQuXNK3ei-3tixd2KJTmfZ31gojElMIdxrv8lKAlc2-_/s504/Screenshot%20from%202024-02-03%2019-16-47.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="504" data-original-width="422" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh80SWktRWO6hv7IKtf2AcdSb3Oc5kJbT1U2vjxfhyphenhyphen0hB6EP3MDM_VIKvy4LiwTE5prKtLNtMOL9UFEtVF4sig2xIQP0zEjFm9I8bTO8oPpe0rDCp7q4u_aNFkKogJjxM3djJOU9SV3nA7tzmUAHQuXNK3ei-3tixd2KJTmfZ31gojElMIdxrv8lKAlc2-_/s320/Screenshot%20from%202024-02-03%2019-16-47.png" width="268" /></a></div>(the DHT11 sensor has to be selected for GPIO14)<p></p><p>Now i can get the values via</p><blockquote><p>curl 'http://192.168.178.107/cm?cmnd=status%2010&user=admin&password=XXXX'<br /><br />"StatusSNS":{"Time":"2024-02-03T19:19:29","DHT11":{"Temperature":24.3,"Humidity":50.0,"DewPoint":13.2},"TempUnit":"C"}}<br /></p></blockquote></div>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-56364471299433166002024-01-10T21:04:00.002+01:002024-01-10T21:04:18.324+01:00Review@amazon: AWS for Solutions Architects<p> Beginning of 2024 i read the book "AWS for Solutions Architects: The definitive guide to AWS Solutions Architecture for migrating to, building, scaling, and succeeding in the cloud":</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9ho-Y5_4bvYZoCzLx-wL-LJyXm1GEy2ET04cmxu4vqf0CM01JgjPdScR2Y1ug7QIsMp1p7240FjWv2WQYkaJ2XQDGT5H9zdC1iR1k5qwy1M0cWdxfp5F1k2xkYuKMABt5yIY0vusjZCLTj3YQ5XVunlzlDkwYB-VKkRrQdv_m6DMfA-RZ_11AjGK8yXEk/s761/Screenshot%20from%202024-01-10%2020-52-31.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="761" data-original-width="641" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9ho-Y5_4bvYZoCzLx-wL-LJyXm1GEy2ET04cmxu4vqf0CM01JgjPdScR2Y1ug7QIsMp1p7240FjWv2WQYkaJ2XQDGT5H9zdC1iR1k5qwy1M0cWdxfp5F1k2xkYuKMABt5yIY0vusjZCLTj3YQ5XVunlzlDkwYB-VKkRrQdv_m6DMfA-RZ_11AjGK8yXEk/w338-h400/Screenshot%20from%202024-01-10%2020-52-31.png" width="338" /></a></div><br /><p><span class="HwtZe" lang="en"><span class="jCAhz ChMk0b"><span class="ryNqvb">The book has 627 pages and consists of 16 chapters.</span></span></span></p><p><span class="HwtZe" lang="en"><span class="jCAhz ChMk0b"><span class="ryNqvb">Due to the number of topics, the author wants to cover (and has to!) the book cannot really go into detail about all the services - but in my opinion that is not necessary.</span></span><span class="jCAhz"><span class="ryNqvb">
</span></span><span class="jCAhz ChMk0b"><span class="ryNqvb">I really liked the network sketches in Chapter 4 and the 6 Pillars in chapter 9.</span></span> <span class="jCAhz ChMk0b"><span class="ryNqvb">But the rest also fits - there are various keywords or links for each area that provide a good introduction.</span></span> <span class="jCAhz ChMk0b"><span class="ryNqvb"> </span></span></span></p><p><span class="HwtZe" lang="en"><span class="jCAhz ChMk0b"><span class="ryNqvb">For anyone who knows other hyperscalers and is moving to AWS or is having their first contact with the cloud with AWS, this book should be a must-read.</span></span><span class="jCAhz"><span class="ryNqvb">
</span></span><span class="jCAhz ChMk0b"><span class="ryNqvb">I really liked chapters 9, 14, 15, 16 because they deal with the general topics.</span></span> <span class="jCAhz ChMk0b"><span class="ryNqvb">Here the author cares more about the reader's knowledge base than about the specific implementation in AWS (and he doesn't leave this out).</span></span><span class="jCAhz"><span class="ryNqvb">
</span></span><span class="jCAhz ChMk0b"><span class="ryNqvb">Absolute reading recommendation!</span></span></span> <br /></p><p>For more details please read <a href="https://www.amazon.de/gp/customer-reviews/R2TM7TIHQ5KIZG/ref=cm_cr_dp_d_rvw_ttl?ie=UTF8&ASIN=180323895X " target="_blank">my review at amazon</a> (this time in german only) :)</p><p>(But maybe copilot or any other ChatGPT/OpenAI can translate that.<br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-54190423152824786042024-01-06T11:55:00.002+01:002024-01-06T11:55:23.581+01:001 million visitors reached!<p>After 17 years (!) this blog reached 1.000.000 visitors. <br /></p><p> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCJJwsG1bFSjXc7dVxAc35f1aPCyO3Lztrw1UyTrERi7rgMOlDfXmKKCrBbUmwbDlcuLSsaa1tNkQL3mqswXq91c-3LhQRVGhvgh1b5zTogrMTZxy-pfsrZ0vNHXMF6mMrJvpeFrxdofAwXEGySabJZTxBGP7NVsYF8X34rbcuj7o4jDyl7XOedHQvevNN/s1024/_5acb3ec9-00a7-452e-af6d-350f5b939b5f.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1024" data-original-width="1024" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCJJwsG1bFSjXc7dVxAc35f1aPCyO3Lztrw1UyTrERi7rgMOlDfXmKKCrBbUmwbDlcuLSsaa1tNkQL3mqswXq91c-3LhQRVGhvgh1b5zTogrMTZxy-pfsrZ0vNHXMF6mMrJvpeFrxdofAwXEGySabJZTxBGP7NVsYF8X34rbcuj7o4jDyl7XOedHQvevNN/w640-h640/_5acb3ec9-00a7-452e-af6d-350f5b939b5f.jpeg" width="640" /></a></p><p>Some more numbers: 591 articles written, 2.200 comments which where
spam, 360 published comments, nearly 200 posts about Linux, 180 posts
about Oracle, nearly 50 reviews on books... <br /></p><p></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTRjIMBoDk6Ymrkh4poAwR1uz4XJpIB1KRrF7JkGLWuFt1R581C51uSL7yzQjsIUnRcnhvP5sV86bXGLh1favSduF_QoGOdyseKZyuo3dG6XW4atFo3EHcACrMwB0zr3BNdrE5R3Ea3sXxLheyryf5oXP5WmeDBnjT6GOXANr_GVROiqMwnUIJxiimsVxA/s1179/Screenshot%20from%202024-01-06%2011-48-19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="361" data-original-width="1179" height="196" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTRjIMBoDk6Ymrkh4poAwR1uz4XJpIB1KRrF7JkGLWuFt1R581C51uSL7yzQjsIUnRcnhvP5sV86bXGLh1favSduF_QoGOdyseKZyuo3dG6XW4atFo3EHcACrMwB0zr3BNdrE5R3Ea3sXxLheyryf5oXP5WmeDBnjT6GOXANr_GVROiqMwnUIJxiimsVxA/w640-h196/Screenshot%20from%202024-01-06%2011-48-19.png" width="640" /></a></div><br /><p></p><p>Let's see if the 2mio will be reached in 2040 (omg).<br /></p><p> </p><p> </p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com1tag:blogger.com,1999:blog-5146606961939082932.post-78985818438868298812023-12-30T18:45:00.005+01:002024-01-06T12:06:37.324+01:00LinkedIn: Lakehouse Analytics - with Microsoft Fabric and Azure Databricks<p>Today i came across a posting in <a href="http://linkedin.com">linkedin.com</a> which points to this nice booklet:</p><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh18-6w-HgHjZhv_ghVVA60-ms_DgR3trPmbvSXZXg_jR9XzjfNcE8hx-0fNmU_SwpTLvqB8APk0-xp6HOe6Vg-P1UDFPYY_Vwu4REcJPzmEvV7Qi3E6pWCCDiL9MyayUP9a4Ay6X9WvUR5msrzG2lX9ISPpmuSN4-yLsg8WiwJ3glDu2lg0XPt-Y5BTX5g/s666/Screenshot%20from%202024-01-06%2011-58-06.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="666" data-original-width="524" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh18-6w-HgHjZhv_ghVVA60-ms_DgR3trPmbvSXZXg_jR9XzjfNcE8hx-0fNmU_SwpTLvqB8APk0-xp6HOe6Vg-P1UDFPYY_Vwu4REcJPzmEvV7Qi3E6pWCCDiL9MyayUP9a4Ay6X9WvUR5msrzG2lX9ISPpmuSN4-yLsg8WiwJ3glDu2lg0XPt-Y5BTX5g/s320/Screenshot%20from%202024-01-06%2011-58-06.png" width="252" /></a> <br /></p><p>The linkedin posting pointed to <a href="https://info.microsoft.com/ww-landing-lakehouse-analytics-with-microsoft-fabric-and-azure-databricks.html?lcid=en-us" target="_blank">site</a>, where you can register for the a PDF, which contains 20 pages and 7 chapters.</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV1wpo2sP6y42NFYqaNbJHVJaWgVxd5cgh-PXEGGJIDWLiAoVDxQPUc-hqH6XLbFkkX6dKkUvlpPuykLD6_TdoFrqJ4Y-JYUO35cd8FeXpgZSGfNw2BPIC9zUrNCVTPPKZuyZiCuqKP61apRw-FKqehdLemPvKZ3SjcD_DuLeCr6r7KOR_jrcB48DHeeEg/s1085/Screenshot_20231230_132535_LinkedIn.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1085" data-original-width="1080" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV1wpo2sP6y42NFYqaNbJHVJaWgVxd5cgh-PXEGGJIDWLiAoVDxQPUc-hqH6XLbFkkX6dKkUvlpPuykLD6_TdoFrqJ4Y-JYUO35cd8FeXpgZSGfNw2BPIC9zUrNCVTPPKZuyZiCuqKP61apRw-FKqehdLemPvKZ3SjcD_DuLeCr6r7KOR_jrcB48DHeeEg/s320/Screenshot_20231230_132535_LinkedIn.jpg" width="319" /></a></div><p>Chapter one is a very short one (only half of a page): A typical introduction about data, information, analytics and why this is important :)</p><p>In chapter 2 the lakehouse architecture is explained. I liked the phrase "It combines [...] traditional data warehouse with the massive scale and flexibility of a data lake". This phrase combined with a very good table of the differences between a data warehouse and a data lake is from my point of view an excellent definition.</p><p>"Data management and analytics with Microsoft Fabric and Azure Databricks" is the title of the third chapter. This chapter only emphasizes that Fabris and Databricks can work seamlessly together and Microsoft introduces a OneLake to simplify the integration of these tools.</p><p>Chapter 4 i can not really summarize here. But there is really a cool figure in that chapter. Here only a part of that:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpbHNt3s1mY69k_hY6GUwkrd_uy2KNJTb5yVrbKmyc_5aRnYDCKxotV1J9wjanKMFXwUm5iHvcDHWal-kdcHCv18p3uM4T2JaJd9t7ySzqW2DdZSb8Cx9O7xY1rWb1H4j41qgRlbhij4-pwLSqDKCDRWirxR1O5NGAoccrVt8wdSW9jv6Cq2C5o_1mHkSO/s658/Screenshot%20from%202023-12-30%2018-32-29.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="406" data-original-width="658" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpbHNt3s1mY69k_hY6GUwkrd_uy2KNJTb5yVrbKmyc_5aRnYDCKxotV1J9wjanKMFXwUm5iHvcDHWal-kdcHCv18p3uM4T2JaJd9t7ySzqW2DdZSb8Cx9O7xY1rWb1H4j41qgRlbhij4-pwLSqDKCDRWirxR1O5NGAoccrVt8wdSW9jv6Cq2C5o_1mHkSO/w400-h246/Screenshot%20from%202023-12-30%2018-32-29.png" width="400" /></a></div><p>The Databricks part is missing and some other parts as well, but in the new Microsoft approach Fabric consists not only of storage - even PowerBI is a part of that new powerful tool. (one subsection is about AI integration)<br /></p><p>The next chapter "Code faster with GitHub Copilot, Visual Studio Code, and Azure Databricks" is about the demonstrating "the power of Azure Databricks as a leading platform for data and AI when combined with developer tools such as Visual Studio Code and GitHub Copilot". This is like a small walkthrough how to configure Visual Studio Code.</p><p>In the seventh chapter a step by step guide is provided for integrating Databricks with OneLake. </p><p>In my eyes chapter 4 is the key of that booklet, for everyone who wants to know, how the terms Fabric, OneLake, Databricks, Lakehouse are related and how the big picture looks like. Anyone who analyzes data with Microsoft should have read this.<br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-49901719032100628312023-09-06T21:40:00.002+02:002023-09-06T21:40:23.041+02:00Review@amazon: Microsoft Power Platform Enterprise Architecture<p> This weekend i read the book "Microsoft Power Platform Enterprise Architecture"</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsq2UbEfi3JlIvOORlKAPzY-Ww_V478Gm9mFBDvaPihXhLwTDORnCj6d-xXG9L2NeAkQq-jlDjakqW2jn4y1U5a5oaseyqAXOyt0SJvXDBF_AxvvAQFTRTmDMcV6ecJd0dSB1meV76r4lkPVyDv2IJDIRfRBUK4pn1PTowGdeYpvhGilC2XI5Mf8bxG_BA/s796/Screenshot%20from%202023-09-03%2020-40-56.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="796" data-original-width="720" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsq2UbEfi3JlIvOORlKAPzY-Ww_V478Gm9mFBDvaPihXhLwTDORnCj6d-xXG9L2NeAkQq-jlDjakqW2jn4y1U5a5oaseyqAXOyt0SJvXDBF_AxvvAQFTRTmDMcV6ecJd0dSB1meV76r4lkPVyDv2IJDIRfRBUK4pn1PTowGdeYpvhGilC2XI5Mf8bxG_BA/s320/Screenshot%20from%202023-09-03%2020-40-56.png" width="289" /></a></div><a href="https://www.packtpub.com/product/microsoft-power-platform-enterprise-architecture/9781800204577">https://www.packtpub.com/product/microsoft-power-platform-enterprise-architecture/9781800204577</a><br /><p>Packt.com says about the book:</p><p></p><blockquote>For forward-looking architects and decision makers who want to craft
complex solutions to serve growing business needs, Microsoft Power
Platform Enterprise Architecture offers an array of architectural best
practices and techniques.
With this book, youâll learn how to design robust software using the
tools available in the Power Platform suite and be able to integrate
them seamlessly with various Microsoft 365 and Azure components. Unlike
most other resources that are overwhelmingly long and unstructured, this
book covers essential concepts using concise yet practical examples to
help you save time.[...]</blockquote><p></p><p>This is something i fully agree with. </p><p>For more details please read <a href="https://www.amazon.de/gp/customer-reviews/R3JCXXYUWIMRY9/ref=cm_cr_dp_d_rvw_ttl?ie=UTF8&ASIN=1804612634" target="_blank">my review at amazon</a> :).<br /></p><p><br /></p><p><br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-41792174191524488232023-07-30T12:00:00.001+02:002023-07-30T12:00:32.360+02:00Postman: Scratchpad is end of life - Only cloud based workspaces possible --> How to keep the passwords/secrets secure?Postman is the swiss army knife tool for dealing with HTTP(S) requests. You want to test anything with an GET, PUT, POST, OPTION call? Postman is the way to go.<div class="separator" style="clear: both; text-align: center;"><a href="https://postman.com" imageanchor="1" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" data-original-height="344" data-original-width="204" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8KlXJw7jFVo-NHxTTNRsdA8qgE84hDkztQWVfobQcrtQHYTpuocnK8VDXIQeIomiv3GhXL8vYwoj6BsA2PS7YL-KSx8X7Fg5Vm4OWhGyhHlVymNM4UDda30EBJUPpWdBx4FFsHPzk9N7HPcftAYz51IkrG-6aP4wxPVPffHSThGqtqvIP4u2pPFtIbLVb/s320/postman00.PNG" width="190" /></a></div><div style="text-align: center;"><a href="https://postman.com">https://postman.com</a></div><div><br /></div><div><br /></div>But some months ago postman announced the following:<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKKRtV1szNR5BNgJRIL1Oysx74Mg3iHB-dv_3Ug1D702kHzzM8pknas79svQKDyALbK17NnwvLip_YHIszKiXw1WUe3Kyp7DeQ86LCe7d9YfshErMXVajYCTtXYHC-WpOPtyE8S6Idx2xBxD8T-eW3gqbka4i6Xqphp8ly0iEJxvm6AWPmwcybeyt119-y/s1134/Postman01.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="121" data-original-width="1134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKKRtV1szNR5BNgJRIL1Oysx74Mg3iHB-dv_3Ug1D702kHzzM8pknas79svQKDyALbK17NnwvLip_YHIszKiXw1WUe3Kyp7DeQ86LCe7d9YfshErMXVajYCTtXYHC-WpOPtyE8S6Idx2xBxD8T-eW3gqbka4i6Xqphp8ly0iEJxvm6AWPmwcybeyt119-y/s16000/Postman01.PNG" /></a></div><br /><div>Scratchpad was the option to work locally on your PC with postman and nothing was synced to the cloud. That was really cool, because most of the HTTPS requests have to be authenticated in some way (basic auth, secrets for oauth, api-keys, etc...)</div><div>From my perspective cloud is a very cool thing, but moving all the sensitive parameters into the postman cloud is not really an option.</div><div>So what to do? </div><div><ol style="text-align: left;"><li>Check alternatives....<br />But there is nothing like postman. e.g. the possibility to render the request to a curl, powershell, NodeJS axios, ... call and use this anywhere else....</li><li>Remove all sensitive data from your request<br />A good step (and just to note: it is bad design, if you ever stored secrets inside the calls :) )</li><li>Now the calls do not work anymore....<br />:(</li></ol><div>But this problem was addressed really a long time ago (more than 4 years ago):</div></div><div><a href="https://github.com/postmanlabs/postman-app-support/issues/6796">Prevent sync of passwords, api keys, and sensitive variables ¡ Issue #6796 ¡ postmanlabs/postman-app-support (github.com)</a></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1uCNxyHo6TPTr6zbI9O1DQl9wOUNYAudU-SXj-1Xpgm86ToaI2qm3_nG-zjK8X3-qsHgK_anEXx42EY6I5_mg5DKIvh5GPxjdFao9rp_VsroDAbmyu5HxxzYJla-b3mq5PPqrh1mNTtnXFwOkIz8Glok0O8d9tR2n6CssuJdoMWEgbYNXOLW5QgH94I3y/s932/postman02.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="806" data-original-width="932" height="554" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1uCNxyHo6TPTr6zbI9O1DQl9wOUNYAudU-SXj-1Xpgm86ToaI2qm3_nG-zjK8X3-qsHgK_anEXx42EY6I5_mg5DKIvh5GPxjdFao9rp_VsroDAbmyu5HxxzYJla-b3mq5PPqrh1mNTtnXFwOkIz8Glok0O8d9tR2n6CssuJdoMWEgbYNXOLW5QgH94I3y/w640-h554/postman02.PNG" width="640" /></a></div><br /><div>So here the link to the solution:</div><div><a href="https://learning.postman.com/docs/sending-requests/variables/" target="_blank">https://learning.postman.com/docs/sending-requests/variables/</a></div><div><br /></div><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><div style="text-align: left;">It is just this easy:use variables and do not fill the initial value!</div></blockquote><div style="text-align: left;"></div><div style="text-align: left;"><br /></div><div style="text-align: left;">Here the tests: </div><div style="text-align: left;">First the local postman:</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxvitBai3DKKW1G0tGk8fkYcP0gYE0XR4-Fx8RfyEAJVgaBPqfqn-5UDhLSMHzw8y1eH2bi1n21HjXzGZ2yG3kyhPqQXRQdlVRAfmVY51lLBVMAPGGDFdyxwo6Oj6yLDbH_8xN01dMht8MX_RKfm7xNHSGZ67Kin_syJi3Wc-bfyb0fMe5rmhJCxsAKjlt/s1152/postman03.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="392" data-original-width="1152" height="218" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxvitBai3DKKW1G0tGk8fkYcP0gYE0XR4-Fx8RfyEAJVgaBPqfqn-5UDhLSMHzw8y1eH2bi1n21HjXzGZ2yG3kyhPqQXRQdlVRAfmVY51lLBVMAPGGDFdyxwo6Oj6yLDbH_8xN01dMht8MX_RKfm7xNHSGZ67Kin_syJi3Wc-bfyb0fMe5rmhJCxsAKjlt/w640-h218/postman03.PNG" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div>Second the browser postman:<br /><br /><div style="text-align: left;"><br /></div><div style="text-align: left;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjh5xZEFdJEzFUeAHxOEqGUZrZGgRoTUJUhK_ywFqY1J78A8MO31mGwIoDtRjJ8WbDgWbiTJoVdYiAbWERVC0LmeXsn4FNIWuZh6qO_eekLKuuhe1bpjH0INNlcOignfZFwXJe0_EcILqDnhjVZQUbfU8EdRWEHqLWnsz_NeKrYQxdzEPd6IdpmzxtTtcsn/s1144/postman04.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="437" data-original-width="1144" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjh5xZEFdJEzFUeAHxOEqGUZrZGgRoTUJUhK_ywFqY1J78A8MO31mGwIoDtRjJ8WbDgWbiTJoVdYiAbWERVC0LmeXsn4FNIWuZh6qO_eekLKuuhe1bpjH0INNlcOignfZFwXJe0_EcILqDnhjVZQUbfU8EdRWEHqLWnsz_NeKrYQxdzEPd6IdpmzxtTtcsn/w640-h244/postman04.PNG" width="640" /></a></div><br /></div><div style="text-align: left;">As you can see: the current values are empty inside the cloud for all entries, which have the inital value not filled...</div><div style="text-align: left;">(By the way: the current value is always a copy of the inital value. If you put there something like test11 and test22, only test1 and test2 will show up in the cloud version).</div>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-46644213860704292622023-04-09T22:03:00.004+02:002023-04-21T07:06:51.155+02:00LinkedIn: Microsoft 365 Backup for Dummies sponsored by Veeam<p> This week Veeam published this booklet on <a href="https://linkedin.com">linkedin.com</a> for download:<br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQI84lMPuWEuiJsJ4fqdaWnIUiXjpRMoPcG6hfZhxR35txSBCvtMIebvYxCwAMsuf3cwcWRw1RGAwknANBrsnEenVv88fetgcppXF8WH5Ux-wQEQniUtVfKa6t58XmisaiS01qMlL-4QHjhVV8UFE6X7N0ITp2CVh1XmjPNh9AkBoPqpBx_HAV_oe_4Q/s1698/Screenshot_20230409_163835_LinkedIn.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1698" data-original-width="1080" data-yxo0wp8yx="" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQI84lMPuWEuiJsJ4fqdaWnIUiXjpRMoPcG6hfZhxR35txSBCvtMIebvYxCwAMsuf3cwcWRw1RGAwknANBrsnEenVv88fetgcppXF8WH5Ux-wQEQniUtVfKa6t58XmisaiS01qMlL-4QHjhVV8UFE6X7N0ITp2CVh1XmjPNh9AkBoPqpBx_HAV_oe_4Q/w408-h640/Screenshot_20230409_163835_LinkedIn.jpg" width="408" /></a></div><p><br />The booklet contains 6 chapter - the last one is a summary "Six takeaways" like always in such "for dummies" books.</p><p>From my point of view chapter 1 & 2 can be skipped - this you should really know, if running M365 (motivation for M365 backup). </p><p>Chapter 3 is about how the loss of files can be prevented with M365 mechanisms. This is about compliance center, retention policies and labels. But only the keywords are mentioned and no deeper insights are provided.</p><p>In chapter 4 many scenarios are described, how you can loose your data on M365. Here a quote: <br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8aMuqxZvE6EfPY78O4SOszDAIeig3QEe8074psHgDIlhpEPI_3Fd9oE96HoZK5HqGvJmCR1nT0XVVLcvDRqG7yuy9Zw1ertv-lI5mAcz9LOzqANtr2p4_lFfcGzmktBbcaR1keKGLmQpNuqcnuO77JG2jwrV50JztFJ5icPdiNqj4SB4iyt42ZXDDZg/s759/Screenshot%20from%202023-04-09%2021-25-09.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="138" data-original-width="759" height="117" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8aMuqxZvE6EfPY78O4SOszDAIeig3QEe8074psHgDIlhpEPI_3Fd9oE96HoZK5HqGvJmCR1nT0XVVLcvDRqG7yuy9Zw1ertv-lI5mAcz9LOzqANtr2p4_lFfcGzmktBbcaR1keKGLmQpNuqcnuO77JG2jwrV50JztFJ5icPdiNqj4SB4iyt42ZXDDZg/w640-h117/Screenshot%20from%202023-04-09%2021-25-09.png" width="640" /></a></div>I think this chapter can be skipped like chapter 1 & 2. <p></p><p>Chapter 5 opens with a nice term which was new to me: BaaS - Backup as a Service. Never thought about this acronym. Completely clear, that some backups in cloud are done without having purchased storage or servers on premises. Nice thing inside this chapter: a checklist about data source, data properties and some others. Really nice.</p><p>Chapter 6 comes up with the takeaways. These are really worth reading.<br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-83353558264653245562023-02-20T11:19:00.003+01:002023-02-20T11:19:16.843+01:00LinkedIn: A Guide to Data Governance - Building a roadmap for trusted data<p>On linkedin from "The Cyber Security Hub" <a href="https://www.linkedin.com/posts/the-cyber-security-hub_a-guide-to-data-governance-activity-7032736574865833984-EHEJ?utm_source=share&utm_medium=member_desktop" target="_blank">shared a nice booklet</a> about data governance:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://www.linkedin.com/posts/the-cyber-security-hub_a-guide-to-data-governance-activity-7032736574865833984-EHEJ?utm_source=share&utm_medium=member_desktop" imageanchor="1" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" data-original-height="565" data-original-width="593" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPnYEO9zCQ9dChRzY1ksTOckv_4aivA4p6F9NRQ2TfHMcUJlyT6MkJCgW6mLSOzWZLtUncU3fdEOw-VKzuxiKazBUY1Y0fnL3g3kBNjFYLkew0Hec8_mAyvRz4RaDmroH5XqHLYdf77a5rSTODnk590JyA3-wYir-tCWg9Ablm6kj0OutGTGQke9rclg/s320/Screenshot%20from%202023-02-20%2011-04-06.png" width="320" /></a></div><br /><p>An like always: It is only a booklet with about 25 pages - so this is not really a deep dive into this topic, but it gives you a good overview and of course a good motivation:</p><p><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 13.59%; transform: scaleX(0.86978);"></span></p><blockquote><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 13.59%; transform: scaleX(0.86978);">These include the need to govern</span><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 15.35%; transform: scaleX(0.867512);">data to maintain its quality as well as the need to protect it. This entails the prerequisite </span><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 17.12%; transform: scaleX(0.874328);">need to discover data in your organization with cataloguing, scanning, and classifying your </span><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 18.89%; transform: scaleX(0.881754);">data to support this protection.</span></blockquote><p>and if this is to abstract, you should consider the following use case (and i think this use case has to be considered):</p><p><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 29.22%; transform: scaleX(0.875998);"></span></p><blockquote><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 29.22%; transform: scaleX(0.875998);">However, for AI </span><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 30.99%; transform: scaleX(0.865876);">to become effective, the data it is using must be trusted. Otherwise decision accuracy may </span><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 32.75%; transform: scaleX(0.875725);">be compromised, decisions may be delayed, or actions missed which impacts on the bottom </span><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 34.52%; transform: scaleX(0.869486);">line. Companies do not want âgarbage in, garbage outâ. </span></blockquote><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 34.52%; transform: scaleX(0.869486);"></span><p></p><p>The booklet contains the sections "Requirements for governing data in a modern enterprise", "components needed for data governance", "technology needed for end-to-end data governance" and "managing master data". All sections do not provide a walk through for achieving a good data governance, but there are many questions listed, which you should answer for your company and then move forward. </p><p>If you already have a data governance in place: This book is a good challenge for your solution. And for sure you will find some points, which are missing :)<br /></p><p><br /></p><span dir="ltr" role="presentation" style="font-family: sans-serif; font-size: calc(var(--scale-factor)*10.50px); left: 24.12%; top: 18.89%; transform: scaleX(0.881754);"></span><p></p><p></p>
Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-31224332735187154152023-02-19T10:49:00.003+01:002023-02-19T10:49:19.755+01:00LinkedIn Topcs: Why dataverse is for everyone...<p>Today i got a notification from a Microsoft colleague about the following <a href="https://linkedin.com" target="_blank">linkedin</a> <a href="https://www.linkedin.com/feed/update/urn:li:activity:7030212398204510208/?commentUrn=urn%3Ali%3Acomment%3A(ugcPost%3A7030212397223047168%2C7032971699906076672)&dashCommentUrn=urn%3Ali%3Afsd_comment%3A(7032971699906076672%2Curn%3Ali%3AugcPost%3A7030212397223047168)" target="_blank">posting</a>:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://www.linkedin.com/feed/update/urn:li:activity:7030212398204510208/?commentUrn=urn%3Ali%3Acomment%3A(ugcPost%3A7030212397223047168%2C7032971699906076672)&dashCommentUrn=urn%3Ali%3Afsd_comment%3A(7032971699906076672%2Curn%3Ali%3AugcPost%3A7030212397223047168)" imageanchor="1" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img border="0" data-original-height="754" data-original-width="567" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7TxWMkd6SZY6E4Yagv6fQP6Gfi5zdnXp_UjHCpPn7Ugk7VpXPka8wVvILCzEZTa8vnu7ODk9UyaL27GonvESmYjUXhgsKwnS6oQjtr2eY4lxg2XMTP6ySiei6NFg0hfIVcjLLBvv4o6iL7Sar01yRgUW4p0mJGl-YoN3ADg1sbHsmJh8oAJ2GrhxYEw/w482-h640/Screenshot%20from%202023-02-19%2010-26-01.png" width="482" /></a></div><br /><p>Some weeks ago i started with <a href="https://powerapps.microsoft.com/en-ie/" target="_blank">PowerApps</a> - and there this "dataverse" was mentionend as well. </p><p>If you walk through the presentation in this linkedin post, you get an idea what this dataverse can do. I found the following picture @Microsoft learn:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuYF0uWP96d4keX1zkS7_1SYmCV8Wpu1u6x62J-_6jm7_12MXbeKR2t88vJ-fvEV55uuk5j5jMrzQ-lAPLj6R_cBc08v-jJwPosQwbNtFN7tHRwD481JvGe1jtbpCrNOzd5f6ZXcAbneCXVhv7BjcSUpZHoDdX_XxNNQMGyr0i9MlcianoxMVSxpjvAw/s1280/platform.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="720" data-original-width="1280" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuYF0uWP96d4keX1zkS7_1SYmCV8Wpu1u6x62J-_6jm7_12MXbeKR2t88vJ-fvEV55uuk5j5jMrzQ-lAPLj6R_cBc08v-jJwPosQwbNtFN7tHRwD481JvGe1jtbpCrNOzd5f6ZXcAbneCXVhv7BjcSUpZHoDdX_XxNNQMGyr0i9MlcianoxMVSxpjvAw/w640-h360/platform.png" width="640" /></a></div><p>And there are more details, why and how dataverse can be used: <a href="https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-intro#why-use-dataverse">https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-intro#why-use-dataverse</a></p><p>Sounds like a kind of datawarehouse centrally in the cloud. The most interesting point (like always): How to maintain this data, so that it is really usable...<br /></p><p><br /></p><p><br /></p><p><br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-50202671556534076032023-02-12T21:33:00.004+01:002023-02-19T10:30:28.853+01:00Review: "Cloud Native Infrastructure with Azure" provided by Microsoft <p>Last week Microsoft published the following <a href="https://www.linkedin.com/" target="_blank">linkedin</a> post:<br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlCrTOvWkvERW_nBx1K4urGqij5X2BP98BQ7GeAX66ZlC23ljQVgLzCqpOOoSDq2iGMauQy7tSGX-16_Xp9YBC9rFsd_yQEtOYWltvhFmnJ-3IBj67cD5ZWgSWmp6mP8R-K8jT3KS5nd11eOw2woWNl8mOIbMMRvl9NgvZycdly85_99rNowEyGqXgfA/s1397/Screenshot_20230208_070659_LinkedIn.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1397" data-original-width="1080" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlCrTOvWkvERW_nBx1K4urGqij5X2BP98BQ7GeAX66ZlC23ljQVgLzCqpOOoSDq2iGMauQy7tSGX-16_Xp9YBC9rFsd_yQEtOYWltvhFmnJ-3IBj67cD5ZWgSWmp6mP8R-K8jT3KS5nd11eOw2woWNl8mOIbMMRvl9NgvZycdly85_99rNowEyGqXgfA/w494-h640/Screenshot_20230208_070659_LinkedIn.jpg" width="494" /></a></div>On linkedin often tiny booklets are offered with around 10 up to 30 pages. But this offer from Microsoft is a book with 11 section and 289 pages.<br />If you are interested you can get it via this link (today this is still working, 12.2.2023): <a href="https://azure.microsoft.com/en-us/resources/cloud-native-infrastructure-with-microsoft-azure/">https://azure.microsoft.com/en-us/resources/cloud-native-infrastructure-with-microsoft-azure/</a><br /><p></p><p>If you are not convinced: Here the table of contents:</p><ol style="text-align: left;"><li>Introduction: Why Cloud Native?</li><li>Infrastructure as Code: Setting Up the Gateway</li><li>Containerizing Your Application: More Than Boxes</li><li>Kubernetes: The Grand Orchestrator</li><li>Creating a Kubernetes Cluster in Azure</li><li>Oberservability: Following the Breadcrumbs</li><li>Service Discovery and Service Mesh: Finding New Territories and Crossing Borders</li><li>Networking and Policy Management: Behold the Gatekeepers</li><li>Distributed Databases and Storage: The Central Bank</li><li>Getting the Message</li><li>Serverless</li><li>Conclusion</li></ol><p>Sounds like many topics i want to read about... :) <br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-72110141357127996732023-01-22T17:19:00.000+01:002023-01-22T17:19:01.145+01:00Openssl: How to automate (without hitting the carriage return many times)<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhADT50tJ7bTNEfo74FbXa2AIVf-tect9NGJUzwrdSoQZGvxcvlEOr1I4SQaN2ezVcY4WW5S-4688iKCn2TkDAED1JrrKASVy9u17O-kNA2ors10PA6-MTHkMAtPih9TF20ROlJj7-wuJklXWVKPlwgOuHkAxp6M89YPGVxhUYMNeOFUi8eJqvXKAYESA/s447/Screenshot%20from%202023-01-22%2016-52-08.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="132" data-original-width="447" height="94" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhADT50tJ7bTNEfo74FbXa2AIVf-tect9NGJUzwrdSoQZGvxcvlEOr1I4SQaN2ezVcY4WW5S-4688iKCn2TkDAED1JrrKASVy9u17O-kNA2ors10PA6-MTHkMAtPih9TF20ROlJj7-wuJklXWVKPlwgOuHkAxp6M89YPGVxhUYMNeOFUi8eJqvXKAYESA/s320/Screenshot%20from%202023-01-22%2016-52-08.png" width="320" /></a></div><p>I think nearly everyone, who administers some PCs or servers has used <a href="https://www.openssl.org/" target="_blank">openssl</a>. And almost everything there is straight forward.</p><p></p><p>To create your own key and certificate, just run:</p><p></p><blockquote><pre style="background: black; color: silver;">openssl req -x509 -sha256 -nodes -days 365 -newkey rsa:2048 \<br /> -keyout privateKey.key -out certificate.crt<br /></pre></blockquote><p> </p><blockquote><pre style="background: black; color: silver;">............+..+.+.................+............+.+......+........+.+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.+....................+......+.+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.......+.+.....+...+..........+...............+....................+.+...+..+..........+........+......+.+...+.....+...+.......+..+.+...+...........+....+..+.......+.....+...............+................+......+......+...+......+...+...+..+......+......+.........+....+........+............+..........+.....+...+.......+..+...+.............+...+......+..............+....+...........+....+..+.+..+...+.............+............+...+..+.........+...+...............+...+..........+.........+...+...+...+...............+.........+..+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++<br />..........+.....+.......+.........+..+.............+.....+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.......+.............+.........+..+....+..+...+.+......+...+.....+.........+.+.....+.+.....+...+.+.....+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*..+......+............................+.....+....+..+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++<br />-----<br />You are about to be asked to enter information that will be incorporated<br />into your certificate request.<br />What you are about to enter is what is called a Distinguished Name or a DN.<br />There are quite a few fields but you can leave some blank<br />For some fields there will be a default value,<br />If you enter '.', the field will be left blank.<br />-----<br />Country Name (2 letter code) [AU]:<br />State or Province Name (full name) [Some-State]:<br />Locality Name (eg, city) []:<br />Organization Name (eg, company) [Internet Widgits Pty Ltd]:<br />Organizational Unit Name (eg, section) []:<br />Common Name (e.g. server FQDN or YOUR name) []:<br />Email Address []:</pre></blockquote>But the problem with that approach:<p></p><p>You have to add the carriage returns for every line after the 5 dashes and then your certificate looks quite ugly (see red colored text):</p><p></p><blockquote><pre style="background: black; color: silver;">openssl x509 -text -in certificate.crt -noout<br /></pre></blockquote><p> </p><blockquote><pre style="background: black; color: silver;">Certificate:<br /> Data:<br /> Version: 3 (0x2)<br /> Serial Number:<br /> 0b:01:9a:aa:f1:59:69:33:84:7e:cf:89:69:0c:d5:80:61:82:b5:28<br /> Signature Algorithm: sha256WithRSAEncryption<br /> <span style="color: red;">Issuer: C = AU, ST = Some-State, O = Internet Widgits Pty Ltd</span><br /> Validity<br /> Not Before: Jan 22 15:54:43 2023 GMT<br /> Not After : Jan 22 15:54:43 2024 GMT<br /> <span style="color: red;">Subject: C = AU, ST = Some-State, O = Internet Widgits Pty Ltd</span><br /> Subject Public Key Info:<br /> Public Key Algorithm: rsaEncryption<br /> Public-Key: (2048 bit)<br /> Modulus:<br /> 00:c6:7d:5a:9f:97:3d:43:9b:e0:19:2f:46:31:5c:<br /> 82:f0:42:ac:da:a9:e8:d0:91:e0:01:98:05:52:cf:<br /> 1c:4e:77:53:1a:96:5c:6a:6f:ca:5c:61:a4:5f:14:<br /> 12:ed:69:ae:50:bb:99:28:48:df:bc:f6:76:c1:63:<br /> 2b:51:55:ad:bb:62:9f:3a:2b:1f:e7:c3:fd:bb:45:<br /> 04:c3:88:ee:b1:ba:c6:e2:f7:f1:80:5b:ef:eb:04:<br /> fb:ec:82:89:39:c6:33:68:0d:3e:36:62:36:e0:a0:<br /> ff:21:5f:74:ad:d2:4b:d4:5d:c4:67:6b:90:a0:8f:<br /> 1e:4c:80:31:30:2e:8e:5e:9d:62:8a:1d:45:84:5f:<br /> d3:09:46:fe:4f:8d:68:c6:54:e4:51:da:e0:64:f8:<br /> 5d:af:01:2e:79:0c:fe:0b:0f:d6:2e:1b:e6:eb:09:<br /> ca:cc:16:3d:92:53:ae:3b:ad:da:67:a5:ef:69:30:<br /> 7f:e7:53:7c:dd:23:59:c8:8c:6b:b0:a9:fa:fc:4c:<br /> c1:44:cf:3f:2f:91:f4:8c:b6:7c:d9:ae:82:6d:96:<br /> aa:bb:51:07:3c:2b:12:24:e4:a3:7d:9b:ee:4b:7e:<br /> f4:02:0e:bc:b4:35:bd:73:dc:6b:b4:34:36:57:48:<br /> 72:f2:91:60:2d:79:d9:44:3c:77:76:eb:c7:8a:00:<br /> 5f:75<br /> Exponent: 65537 (0x10001)<br /> X509v3 extensions:<br /> X509v3 Subject Key Identifier: <br /> F1:77:6C:19:76:FB:E4:DD:50:2A:1E:01:BE:A1:5C:48:3D:5A:40:68<br /> X509v3 Authority Key Identifier: <br /> F1:77:6C:19:76:FB:E4:DD:50:2A:1E:01:BE:A1:5C:48:3D:5A:40:68<br /> X509v3 Basic Constraints: critical<br /> CA:TRUE<br /> Signature Algorithm: sha256WithRSAEncryption<br /> Signature Value:<br /> 8a:28:28:12:6c:1e:e5:54:86:9b:6e:90:7a:ca:aa:a7:a1:b3:<br /> b1:43:02:44:e8:9a:59:b2:d6:6e:36:c6:51:3b:9b:f4:91:47:<br /> 40:6f:cf:6d:de:86:8d:dd:2f:9e:44:4c:f8:d3:5a:d3:3a:ef:<br /> d5:0d:e1:10:b6:64:34:ee:03:4a:f2:de:ff:da:db:a3:93:20:<br /> 13:85:2a:d6:9b:b2:0e:2c:2e:9c:f9:71:ff:32:3b:c3:6b:0a:<br /> e7:98:2d:30:c9:a6:47:b7:72:84:bb:52:23:11:d6:b7:90:cb:<br /> 98:cd:59:16:b5:8f:70:46:c1:95:90:01:2f:7f:9c:22:ac:29:<br /> 8d:14:97:76:dd:06:56:f8:22:9d:f4:00:9f:40:3c:fb:c2:95:<br /> 63:48:50:ee:ad:17:1b:54:6b:60:0c:d5:3e:66:3b:00:0e:7a:<br /> 33:99:cc:4a:f6:dc:d1:e3:40:ea:8c:66:df:7e:92:e1:a5:e5:<br /> 72:0e:89:ba:87:43:0c:56:70:8c:f2:9b:77:dd:ca:03:8e:24:<br /> fd:6b:51:d2:3b:b2:df:e4:ff:c2:3c:cb:ab:2e:cd:82:f4:69:<br /> ad:a3:81:d7:95:d0:68:e1:3f:fc:50:4d:8b:14:b2:82:8c:19:<br /> 2b:06:8a:0e:ef:21:4b:68:4f:e3:1d:53:64:62:97:c8:35:45:<br /> 01:54:d9:10</pre></blockquote><p><br />To avoid that you have just to expand your command with the following parameters:</p><blockquote><pre style="background: black; color: silver;"><p>openssl req -x509 -sha256 -nodes -days 365 -newkey rsa:2048 \<br /> -keyout privateKey.key -out certificate.crt \<br /> -subj "/C=de/CN=schroff.special/OU=MyDepartment" <br /></p></pre></blockquote><p></p><p>Typical attributes can be found <a href="https://de.wikipedia.org/wiki/X.509#Struktur_eines_X.509-v3-Zertifikats" target="_blank">here</a>:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKqouATXeuS5pGi0MZHSJ0SL1bXK0oGD7QEOPE-d8hd3Zt0bGrqbq6ZgIIhMBdndTQqz0QFaOFzZYT-lPjRvLT3YicboYWkRLvcJuQ83Lpyg8KL4o8yjjWkoYQ3mpt3H097wX8gc5iW2AQH-sAWeXljhf6SJ4A6yNcxaRFkUh7W02ckm-hbFOKzHspjQ/s296/Screenshot%20from%202023-01-22%2017-14-55.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="166" data-original-width="296" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKqouATXeuS5pGi0MZHSJ0SL1bXK0oGD7QEOPE-d8hd3Zt0bGrqbq6ZgIIhMBdndTQqz0QFaOFzZYT-lPjRvLT3YicboYWkRLvcJuQ83Lpyg8KL4o8yjjWkoYQ3mpt3H097wX8gc5iW2AQH-sAWeXljhf6SJ4A6yNcxaRFkUh7W02ckm-hbFOKzHspjQ/s1600/Screenshot%20from%202023-01-22%2017-14-55.png" width="296" /></a></div>(Common Name, Organization, Organizational Unit, Country, Location)<p></p><br />Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-51120514712121366382022-11-09T22:01:00.001+01:002022-11-09T22:02:22.199+01:00FritzBox monitoring with telegraf, influx and grafana<p>On year ago i wrote about adding a FritzBox to my monitoring with grafana and influxdb: <a href="https://dietrichschroff.blogspot.com/2021/11/fritzbox-monitoring-with-grafana-influx.html">https://dietrichschroff.blogspot.com/2021/11/fritzbox-monitoring-with-grafana-influx.html</a> </p><p>This was done with collectd.</p><p>As i wrote in <a href="https://dietrichschroff.blogspot.com/2022/09/ubuntu-raspberry-pi-upgrade-to-2204.html">https://dietrichschroff.blogspot.com/2022/09/ubuntu-raspberry-pi-upgrade-to-2204.html</a> i upgraded my raspberry to 22.04 and along with many minor problems, collectd was gone. (and i think it will not be added anymore.)</p><p>All other monitorings use telegraf to get the data.</p><p>And there is a solution, which provides that:</p><p><a href="https://github.com/Schmidsfeld/TelegrafFritzBox/">https://github.com/Schmidsfeld/TelegrafFritzBox/</a></p><p>You can follow the steps on this page. If you get no data - here is the commandline which you should use to test the connection:<br /></p><blockquote><p>python3 ./TelegrafFritzBox/telegrafFritzBox.py -p xxxxxx -i 192.168.178.1 -u fritz8490<br /></p></blockquote><p>And this should be the command, which you use in </p><blockquote><p>/etc/telegraf/telegraf.d$ cat telegrafFritzBox.conf <br /></p></blockquote><p>The reward is really a very nice dashboard:</p><p> <br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6DNJPnBC3NR3Wz_8t711a2fzrFcfbWDlptAnJ8d91dqn21FBkVgXNGVMxkg5f-cjthmlSeoKkwsc7eHCgWZR5Iy9hvHwdd5jCtam7h1dHYjADla8HAEtr5BRihFQ0lb19CzBoegQv2ljBm0fcAbBUfu3FL661sU8fjp5ptZyO-plKOjcuzOpyrVDIDw/s1491/Screenshot%20from%202022-11-09%2021-56-00.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="981" data-original-width="1491" height="422" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6DNJPnBC3NR3Wz_8t711a2fzrFcfbWDlptAnJ8d91dqn21FBkVgXNGVMxkg5f-cjthmlSeoKkwsc7eHCgWZR5Iy9hvHwdd5jCtam7h1dHYjADla8HAEtr5BRihFQ0lb19CzBoegQv2ljBm0fcAbBUfu3FL661sU8fjp5ptZyO-plKOjcuzOpyrVDIDw/w640-h422/Screenshot%20from%202022-11-09%2021-56-00.png" width="640" /></a></div><br />Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-9797718934251473092022-11-05T18:54:00.003+01:002022-11-05T18:54:25.708+01:00Installation and running RaceResult Presenter.exe on Ubuntu<p>For all who are active in sports and want to run a event with <a href="http://www.raceresult.com">www.raceresult.com</a>:<br /></p><p>In our case we have some Linux laptops which we want to use (Windows OS licenses missing).</p><p>RaceResult consists some some components</p><ul style="text-align: left;"><li>SEServer2.exe</li><li>Presenter.exe</li><li>CameraServer.exe</li><li>Transponder.exe</li><li>Moderator.exe</li><li>RRWS.exe</li></ul><p>We want to run the Presenter.exe on a Linux box. So first step:</p><p>Install raceresult software with wine.</p><p>Preinstallation step:</p><blockquote><pre style="background: black none repeat scroll 0% 0%; color: silver;"><p>winetricks vb6run<br /></p></pre></blockquote><p>Installation step:</p><blockquote><pre style="background: black; color: silver;"><p>wine raceresult_12.4.25.0_386_stable.exe<br /></p></pre></blockquote><p>(the exe is provided by raceresult)</p><p>Important thing: to run the Presenter.exe you need the SEServer2.exe running as well. Because RaceResult decided to let this server listen on port 1023, the installation has to be done twice. One with sudo and one without.</p><p>For the sudo installation please select all components. For the user installation only the presenter is needed (but you can go with all as well): <br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg16kI7rbZkpK2laWs7vhJrK_p_84A6_f9CSp6zDfZqlWiuHCEbfk7vqHAPSHSvY-Rs1E8xP0j3K_H7A_yFSA969p-9D8h3S2E3PZGhfsFlbdUHcvf_GkAjQ6okd3Vq4a_aRX90M1y1b_QlAJEqqtdljypkg3VRdTU2S7bxG7YKQcrcjOleR4llGvcbzA/s507/Bildschirmfoto_2022-11-05_09-34-24.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="398" data-original-width="507" height="314" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg16kI7rbZkpK2laWs7vhJrK_p_84A6_f9CSp6zDfZqlWiuHCEbfk7vqHAPSHSvY-Rs1E8xP0j3K_H7A_yFSA969p-9D8h3S2E3PZGhfsFlbdUHcvf_GkAjQ6okd3Vq4a_aRX90M1y1b_QlAJEqqtdljypkg3VRdTU2S7bxG7YKQcrcjOleR4llGvcbzA/w400-h314/Bildschirmfoto_2022-11-05_09-34-24.png" width="400" /></a></div><p></p><p>Then: start the SEServer </p><blockquote><pre style="background: black; color: silver;"><p>sudo bash<br />cd /root/.wine/drive_c/Program Files (x86)/race result/race result 11/SEServer2<br />wine SEServer2.exe<br /></p></pre></blockquote><p>Startup the presenter as well</p><blockquote><pre style="background: black; color: silver;"><p>cd ~/.wine/drive_c/Program Files (x86)/race result/race result 11/Presenter <br />wine Presenter.exe<br /></p></pre></blockquote><p>Now the next tricky thing: You got a ses file from raceresult (rot.ses). Copy this in both .wine directories to ./wine/drive_c and the open this ses file in the presenter:<br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtCRpYRssaf8P2Xf-VlGQ1FSDnZwaw9iZpCM1pqPFJ6EQP2rSXqbTla2pK_S8FiKQtzR7esdSyFJv82ykNRm4UHXu89YTrWm7D7ENkobq5r9blp3w6cxrPbepbdl7KSREapPF3ntB3YvIRUQRaO5kzQQRSvorMJs1AiJ-AKdYGpY0_1JtSa-QBiFhjHw/s590/Screenshot%20from%202022-11-05%2008-51-06.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="590" data-original-width="437" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtCRpYRssaf8P2Xf-VlGQ1FSDnZwaw9iZpCM1pqPFJ6EQP2rSXqbTla2pK_S8FiKQtzR7esdSyFJv82ykNRm4UHXu89YTrWm7D7ENkobq5r9blp3w6cxrPbepbdl7KSREapPF3ntB3YvIRUQRaO5kzQQRSvorMJs1AiJ-AKdYGpY0_1JtSa-QBiFhjHw/w296-h400/Screenshot%20from%202022-11-05%2008-51-06.png" width="296" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnGoBpRSBwsvTFwJvI07Csc17bvcm5NfQ4iQw1xnEVD_EKSD_zA5KfmaQJjVBJ_dWM1Rn_irt_NNip87_oI9I-zdf3MogIShqP3QQ-wsLaYKbjox--vdqwFuO7M8mqVL8a-oop7lqH99EA8iBRzKt3c_8FYI-kZVug4N5h7Xy81DZAchy8QSws2h7RIA/s596/Screenshot%20from%202022-11-05%2015-10-43.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="596" data-original-width="441" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnGoBpRSBwsvTFwJvI07Csc17bvcm5NfQ4iQw1xnEVD_EKSD_zA5KfmaQJjVBJ_dWM1Rn_irt_NNip87_oI9I-zdf3MogIShqP3QQ-wsLaYKbjox--vdqwFuO7M8mqVL8a-oop7lqH99EA8iBRzKt3c_8FYI-kZVug4N5h7Xy81DZAchy8QSws2h7RIA/w296-h400/Screenshot%20from%202022-11-05%2015-10-43.png" width="296" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCpdiNjya-mg5K6x1WMJYv1-06NGwbVwNS6Zp5n4oWbNsyaUjpgaiOvZ5_pyRtBH3eXewMrDTVVknVZxkWKykUJ6b5ZgvZzZAPnDlevkxqpmas3TU11zZq6FissxkShJYPn-M6NEN91am3wdgTjey0Qj2Yg-u_khzvpSBtGZL0z4X5iHpISH4QVawGjA/s1920/Screenshot%20from%202022-11-05%2015-11-00.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1080" data-original-width="1920" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCpdiNjya-mg5K6x1WMJYv1-06NGwbVwNS6Zp5n4oWbNsyaUjpgaiOvZ5_pyRtBH3eXewMrDTVVknVZxkWKykUJ6b5ZgvZzZAPnDlevkxqpmas3TU11zZq6FissxkShJYPn-M6NEN91am3wdgTjey0Qj2Yg-u_khzvpSBtGZL0z4X5iHpISH4QVawGjA/s320/Screenshot%20from%202022-11-05%2015-11-00.png" width="320" /></a></div><br /><p>Bam done. :)<br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-16567981345749274172022-09-28T21:13:00.002+02:002022-09-28T21:13:39.658+02:00Ubuntu raspberry pi: upgrade to 22.04...<p>Ubuntu released version 22.04 so i decided to make an update from</p><p style="text-align: left;"><span style="font-family: courier;">Ubuntu 21.04 (GNU/Linux 5.11.0-1027-raspi aarch64)</span></p><p>to</p><p><span style="font-family: courier;">Ubuntu 22.04.1 LTS (GNU/Linux 5.15.0-1015-raspi aarch64)</span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKxE0Ynsjdo4pZOy8pKEbe9uRTj_aGHiN2UM7YjJ1wVSMnPIeLtGPHuAvRJoc6Wif55oIcpTE1gQJalulyzJcIiGNlFmt1YaGnfDO9NTWxYcpIEqFwsr5uhBiw-z80wu06rmqesEGQykwn_wplVTx7ehkKUR2ySxDupxA4BUJ2_1gk9x6Ugq4Tn3iEBQ/s648/Screenshot%20from%202022-09-28%2021-04-44.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="307" data-original-width="648" height="152" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKxE0Ynsjdo4pZOy8pKEbe9uRTj_aGHiN2UM7YjJ1wVSMnPIeLtGPHuAvRJoc6Wif55oIcpTE1gQJalulyzJcIiGNlFmt1YaGnfDO9NTWxYcpIEqFwsr5uhBiw-z80wu06rmqesEGQykwn_wplVTx7ehkKUR2ySxDupxA4BUJ2_1gk9x6Ugq4Tn3iEBQ/s320/Screenshot%20from%202022-09-28%2021-04-44.png" width="320" /></a></div><p>But this was not so easy as i thought. Running on my raspberry pi the following services were running:</p><ul style="text-align: left;"><li>influxdb</li><li>collectd</li><li>telegraf</li><li>mosquitto</li><li>zigbee2mqtt</li><li>grafana</li></ul><p>Without any problem only grafana was updated.</p><p>Collectd failed with this message:</p><p></p><blockquote><p>Package 'collectd' has no installation candidate <br /></p><p></p></blockquote><p>no chance to fix that :(</p><p>With that i had to disable the collectd section in influxdb - with that session it failed with </p><blockquote><p>influxd-systemd-start.sh[2293]: run: open server: open service: Stat(): stat /usr/share/collectd/types.db: no such file or directory</p></blockquote><p>Then zigbee2mqtt was not able to write to mosquitto. This is due a change of the default settings of mosquitto. allow_anonymous false is now default, so i had to add</p><blockquote><p>allow_anonymous true</p></blockquote><p>After that zigbee2mqtt was able to write data to mqtt again.</p><p>Last thing: restart of telegraf, because just did not start properly after the first reboot after the upgrade.</p><p>Not really a good update - my other raspberry pi will stay on 21.04 for some more months...<br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-43740746154633412072022-07-10T20:55:00.006+02:002022-07-10T22:09:40.929+02:00Elster.de: To many request for german government portal...<p>In Germany, the property tax had to be reformed due to a ruling by the Federal Constitutional Court. So this year everybody got a mail with the request to register his property from july 1st up to the end of the year.</p><p>This should be done via ELSTER = electronic tax declaration (explanation of the acronym can be found <a href="https://de.wikipedia.org/wiki/Elster_(Software)">here</a>) <br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_uINyo_5hCxizEPhE04zwDwfdXk9bERGgl3SGLTMgHFwttQKxwsDLCSrhxHrTCiieVpKIh-D3t0bPWqBqLJcJWwDu2wd41tWL2YdSkLeYPIKHEcRn6uCjdgx5NO8vXBpnn8DeQR4Ph-ISexEoWUCGZqriVZ0NTgNUkNa4ZEslBH5juItmqL5MKY0B5w/s836/Screenshot%20from%202022-07-10%2022-08-19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="615" data-original-width="836" height="470" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_uINyo_5hCxizEPhE04zwDwfdXk9bERGgl3SGLTMgHFwttQKxwsDLCSrhxHrTCiieVpKIh-D3t0bPWqBqLJcJWwDu2wd41tWL2YdSkLeYPIKHEcRn6uCjdgx5NO8vXBpnn8DeQR4Ph-ISexEoWUCGZqriVZ0NTgNUkNa4ZEslBH5juItmqL5MKY0B5w/w640-h470/Screenshot%20from%202022-07-10%2022-08-19.png" width="640" /></a></div><p></p><p>I tried this yesterday and today, but the login page does not respond at all.</p><p>Today a message was posted on their website (orange box on the screenshot)</p><blockquote><p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="de" data-number-of-phrases="4" data-phrase-index="0"><span class="Q4iAWc">Restrictions when using the ElsterSmart app</span></span><span class="JLqJ4b" data-language-for-alternatives="en" data-language-to-translate-into="de" data-number-of-phrases="4" data-phrase-index="1"><span class="Q4iAWc">
</span></span><span class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="de" data-number-of-phrases="4" data-phrase-index="2"><span class="Q4iAWc"><br />It is currently not possible to use Mein ELSTER using the ElsterSmart app if the ElsterSmart app and Mein ELSTER are used on different devices (e.g. if you have installed ElsterSmart on your smartphone or tablet, but Mein ELSTER in the browser on your</span></span> <span class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="de" data-number-of-phrases="4" data-phrase-index="3"><span class="Q4iAWc">use PC).</span></span></span></p></blockquote><p>and <br /></p><blockquote><p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="de" data-number-of-phrases="4" data-phrase-index="0"><span class="Q4iAWc">Availability Limitations</span></span><span class="JLqJ4b" data-language-for-alternatives="en" data-language-to-translate-into="de" data-number-of-phrases="4" data-phrase-index="1"><span class="Q4iAWc">
<br /></span></span><span class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="de" data-number-of-phrases="4" data-phrase-index="2"><span class="Q4iAWc">Due to the enormous interest in the forms for the property tax reform, there are currently restrictions on availability.</span></span> <span class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="de" data-number-of-phrases="4" data-phrase-index="3"><span class="Q4iAWc">We are already working intensively on being able to provide you with the usual quality as quickly as possible.</span></span></span></p></blockquote><p>I think just at least 10 million citizens try to follow the request and the on datacenter the servers are on their limit:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi16rv_J5Y2FA8yyeyB494vD2nCz0FzWfsO8A1XWaEBL6V8-ufQje6aKiPqNqEBTtKd1d7WrOlLzqHCal-__o1qhdM5xtl2PnQ11_H3fBjNnL_-Skp7STWBhP9XkIZcyGxlmG3ZrSZAMfmdZPwFjvOIHozuPQbsVtNxN5YFZI4ZLBJM_lqoUdiZmMwPYA/s798/Screenshot%20from%202022-07-10%2020-51-33.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="98" data-original-width="798" height="78" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi16rv_J5Y2FA8yyeyB494vD2nCz0FzWfsO8A1XWaEBL6V8-ufQje6aKiPqNqEBTtKd1d7WrOlLzqHCal-__o1qhdM5xtl2PnQ11_H3fBjNnL_-Skp7STWBhP9XkIZcyGxlmG3ZrSZAMfmdZPwFjvOIHozuPQbsVtNxN5YFZI4ZLBJM_lqoUdiZmMwPYA/w640-h78/Screenshot%20from%202022-07-10%2020-51-33.png" width="640" /></a></div><p>Even the status page shows a 404: <a href="https://www.elster.de/elsterweb/svs">https://www.elster.de/elsterweb/svs</a></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgSGtUhAWLgv15Y3iNm9HwU0Fqeo-UK4tb_Tb0e5xH1pDZbs58y0C_Ef3cs6kzfqJbR82tipP4wL6MVRi8Pfi69N54jLJ8uemvopDj-tG0R58gI0dMXzp855wcWB2fFSIJcduxcc_3plmiMEYkRA5VgKTRKXmwDmcGqr5vReDNK7SXo1o1RnJt22poxw/s817/Screenshot%20from%202022-07-10%2021-02-11.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="321" data-original-width="817" height="126" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgSGtUhAWLgv15Y3iNm9HwU0Fqeo-UK4tb_Tb0e5xH1pDZbs58y0C_Ef3cs6kzfqJbR82tipP4wL6MVRi8Pfi69N54jLJ8uemvopDj-tG0R58gI0dMXzp855wcWB2fFSIJcduxcc_3plmiMEYkRA5VgKTRKXmwDmcGqr5vReDNK7SXo1o1RnJt22poxw/s320/Screenshot%20from%202022-07-10%2021-02-11.png" width="320" /></a></div><p></p><p>So let's see if it is possible to follow the request until end of the year or if this deadline gets extended for some years :).<br /> <br /></p><p></p><p> </p><br />Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-90401393569554479092022-05-26T11:26:00.001+02:002022-05-26T11:27:54.597+02:00Review: Securing containers & cloud for dummies<p>Securing containers & cloud (provided by <a href="https://sysdig.com/">sysdig</a>) is a booklet with 42 pages and 7 chapters. Like most of the "for dummies" series the last chapter is a summary with ten considerations.</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCgb1aB33q0pZp00dl4wEWesgW0A6Fat-ANWgq4pvh06cfY49d7oVwgDQg3aZm3UApvCGfibimAlQxFudR8Mh11wWTzA978mf5jm3OR8JBBD_gMabvG-wjiHoqjI3pdhbEk24f8utaYJIW7gfY_NPLQ-xuGuZ3fLaDs8vf6ljNS2Z9h6SXHPr_Hj_Qnw/s930/Screenshot%20from%202022-05-26%2010-44-20.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="930" data-original-width="615" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCgb1aB33q0pZp00dl4wEWesgW0A6Fat-ANWgq4pvh06cfY49d7oVwgDQg3aZm3UApvCGfibimAlQxFudR8Mh11wWTzA978mf5jm3OR8JBBD_gMabvG-wjiHoqjI3pdhbEk24f8utaYJIW7gfY_NPLQ-xuGuZ3fLaDs8vf6ljNS2Z9h6SXHPr_Hj_Qnw/w265-h400/Screenshot%20from%202022-05-26%2010-44-20.png" width="265" /></a></div><p></p><p>But let's start from the beginning:<br />Chapter one "understanding cloud security" is a really nice abstract. Here some of the topic, which you should be aware of: "overprivileged identites", "visibility over cloud assets", "leaving out IT", "former employees, one-time users and guest accounts that are left active", ... With knowing that the following proposal is made: "to dectect and stop cyber threats [..] first step is to see them". Therefore a singe event store should be used and a open-source validation because of validation an transparency.<br />The second chapter is named "securing infrastructure as code (IaC). The typical arguments for IaC are speed, scalabilty, resilience, reproducibility but what about security? IaC is created by the developers and this code has to be checked as well as the application sources. And even if IaC is checked, configuration templates in a CI/CD pipeline will suffer from drift. "Policy as code PaC allows you to leverage a shared policy model across multiple IaC, cloud, and Kubernetes environments. Not only does PaC provide consistency and strengthen security, but also it saves time and allows you to scale faster."<br />"Preventing Vulnerabilites" is the third chapter. Many images in production contain patchable vulnerabilites, which should be patched. So the selecting of container images from every source (including DockerHub) without scanning them is not a good idea. One subsection here is "Automate vulnerability scanning in the CI/CD pipeline". I think this is something you should read in the booklet in detail.<br />After scanning for threats, the next chapter is about detecting and responding to threats. This chapter is only about 3 pages and it is more an appetizer for Falco, which is a solution from sysdig.<br />The sixth chapter is named "Targeting monitoring and troubleshooting issues" is is plea for open source. "Avoiding Vendor Lock-In" is key to success at least from the perspective of the authors.<br />As in the beginning mentioned the last chapter is a ten point summary of the topic. This is a fast checklist, you can use.<br /> </p><p>All in all a very good high level introduction into "Securing Containers & Cloud". I recommend all DevOps engineers and developers to spend half an hour to read this booklet.<br /><br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-53745667677273717502021-12-27T09:56:00.000+01:002021-12-27T09:56:00.163+01:00Running a movie on an external DVD drive on a Chromebook (like HP x360) <div><p>In a first step this task sounds very easy:</p><ul style="text-align: left;"><li>watch a DVD on a chromebook</li></ul><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEj5PTBYVtRm60lz52rz5xiC47ZuZpOGLHLNPIaHLCthoJdbdygnsN9C0-72lDkLgjKX7bPzwl4GuT1as79b5wjcAX9ZDsk9rzEgTJyMHkNrMGwM7OtCP7fud7Wp1wd5WhyTfm6nBus27ZyJjfFu-C9VUdSxxD-ruyeTGuIVlSo8bY3RYZfHjPhOEs708Q=s568" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="159" data-original-width="568" height="90" src="https://blogger.googleusercontent.com/img/a/AVvXsEj5PTBYVtRm60lz52rz5xiC47ZuZpOGLHLNPIaHLCthoJdbdygnsN9C0-72lDkLgjKX7bPzwl4GuT1as79b5wjcAX9ZDsk9rzEgTJyMHkNrMGwM7OtCP7fud7Wp1wd5WhyTfm6nBus27ZyJjfFu-C9VUdSxxD-ruyeTGuIVlSo8bY3RYZfHjPhOEs708Q=s320" width="320" /></a></div><p></p><p>But...</p><p>What are the problems?</p><ol style="text-align: left;"><li>Using an external drive to access the dvd</li><li>No appropriate app available in play store or chrome web store</li></ol><p>There are different solutions out there. </p><ol style="text-align: left;"><li>Convert the DVD to a mp4 and watch this</li><li>Use VLC from play store --> does not recognize the DVD</li><li>Use VLC from chrome web store --> does not start at all</li><li>Use linux development environment </li></ol></div><p>Option 4 seemed to me as the most promising way to go.</p><p>Setting up linux is very easy:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiSjA5t39fW7lFX2SCSRPr3RSUNx4eSLZvsM2WH3QSn48i99tfzPtxP81MaWruaQgYuZCTPF1ttHmfGSsi4S8RBC9KTbjZa_GZ0YNsC7bkQW4ew1pFRyI3BlhEP1or1O6H40XKuZsmS3DtoHqCo0_H2ptJTdt9889N9dkRtFlsIkUrt8UsKby4WNLMczQ=s963" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="613" data-original-width="963" height="408" src="https://blogger.googleusercontent.com/img/a/AVvXsEiSjA5t39fW7lFX2SCSRPr3RSUNx4eSLZvsM2WH3QSn48i99tfzPtxP81MaWruaQgYuZCTPF1ttHmfGSsi4S8RBC9KTbjZa_GZ0YNsC7bkQW4ew1pFRyI3BlhEP1or1O6H40XKuZsmS3DtoHqCo0_H2ptJTdt9889N9dkRtFlsIkUrt8UsKby4WNLMczQ=w640-h408" width="640" /></a></div><p> After that you have a debian bullseye running inside a container. Go to /etc/apt/sources.list and add "contrib" after "deb https://debian.org/debian bullseye main " ("sudo bash" to get root). Then <br /></p><blockquote><p>apt update<br />apt upgrade<br />apt install vlc libdvd-pkg<br />dpkg-reconfigure libdvd-pkg</p><p></p></blockquote><p>After that vlc is configured including the libdvdcss for the DVD region codes.</p><p>One last problem is to access the DVD inside this linux container. This can be done via a double tap inside the file-manager on the chromebook and then you can choose inside the context menu "share with linux (Mit Linux teilen)".</p><p>This last step has to be done each time a DVD is inserted. </p><p>So watching DVDs on a chromebook is not impossible, but it is not really user friendly...<br /></p><p><br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-29252146082412835342021-12-04T10:17:00.004+01:002021-12-04T10:18:30.909+01:00influxdb: copying data with SELECT INTO - pay attention to the TAGS (or they are transformed to fields)<p> If you are using influxdb, one usecase could be, copy the data from a measurement ("table") to another.</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOuiluVOtIWxCZQX7_13hu_yfZYafTDD4WUBJAI7r8budcMBOEUzUk7-_vwgcgY_8BrAhX6WM87u8jMMUkBce3W-6TR8Kxxd01ImTylVUgcifL6FF8hz5NtyYTiukHNfgRLv7O4yNNmXYE/s221/Screenshot+from+2021-11-06+17-19-19.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="72" data-original-width="221" height="72" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOuiluVOtIWxCZQX7_13hu_yfZYafTDD4WUBJAI7r8budcMBOEUzUk7-_vwgcgY_8BrAhX6WM87u8jMMUkBce3W-6TR8Kxxd01ImTylVUgcifL6FF8hz5NtyYTiukHNfgRLv7O4yNNmXYE/s0/Screenshot+from+2021-11-06+17-19-19.png" width="221" /></a></div><p>This can be done with this statement:</p><blockquote><p><span style="font-family: courier;">select * into testtable2 from testtable1</span><br /></p></blockquote><p>By the way: the CLI is opened with <br /></p><p></p><blockquote><span style="font-family: courier;">/usr/bin/influx -unsafeSsl -ssl -database telegraf</span></blockquote>(if your database is named telegraf)<p></p><p>In my case (<a href="http://dietrichschroff.blogspot.com/2021/11/zigbee-setup-zigbee2mqtt-with-usbstick.html">zigbee / mqtt / telegraf</a>) the layout of mqtt_consumer measurement was like this:</p><p></p><blockquote><span style="font-family: courier;">> show tag keys from mqtt_consumer<br />name: mqtt_consumer<br />tagKey<br />------<br />host<br />topic<br />> show field keys from mqtt_consumer<br />name: mqtt_consumer<br />fieldKey fieldType<br />-------- ---------<br />battery float<br />contact boolean<br />current float<br />...</span></blockquote>But after copying this to a testtable, the tags where gone and everything was a field. <p></p><p>This is not a big problem - you can work with that data without a problem. BUT if you want to copy it back or merge it to the original table, you will get a table with the additional columns host_1 and topic_1.</p><p>This is because for influx you already had a column host. So it added a column field host_1. </p><p>If a query in this new table (with host + host_1) spans over a time where both of this columns are in, you only select the data, with the entry host. If the time spans only entries with host_1, it is shown as host and you get your data. Really a unpredictable way to get data.</p><p>What is the solution? Easy:</p><p></p><blockquote><span style="font-family: courier;">select * into table1 from mqtt_consumer group by host,topic </span></blockquote>The "group by" does not group anything. It just tells influx: host & topic are tags and not fields. Please do not transform them...<br /><p></p><p><br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com1tag:blogger.com,1999:blog-5146606961939082932.post-69132213006332937782021-11-26T19:54:00.002+01:002021-11-26T19:54:16.061+01:00Raspberry PI on Ubuntu: yarn: Cannot find module 'worker_threads' <p>This evening i tried to install a nodejs application with yarn on my raspberry pi. This failed with:</p><p></p><p></p><blockquote><span style="font-size: x-small;"><span style="font-family: courier;">/usr/local/bin/yarn install<br />internal/modules/cjs/loader.js:638<br /> throw err;<br /> ^<br />Error: Cannot find module 'worker_threads'<br /> at Function.Module._resolveFilename (internal/modules/cjs/loader.js:636:15)<br /> at Function.Module._load (internal/modules/cjs/loader.js:562:25)<br /> at Module.require (internal/modules/cjs/loader.js:692:17)<br /> at require (internal/modules/cjs/helpers.js:25:18)<br /> at /opt/zwavejs2mqtt/.yarn/releases/yarn-3.1.0-rc.8.cjs:287:2642<br /> at Object.<anonymous> (/opt/zwavejs2mqtt/.yarn/releases/yarn-3.1.0-rc.8.cjs:585:7786)<br /> at Module._compile (internal/modules/cjs/loader.js:778:30)<br /> at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)<br /> at Module.load (internal/modules/cjs/loader.js:653:32)<br /> at tryModuleLoad (internal/modules/cjs/loader.js:593:12)</span></span></blockquote><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL6grA73mDABK2jPCCLw3V_4_Tqsm_GgSoTYQWqdZqqjcDhFKsRH18tEHbpNQ8vlJlkMfaTgOJg-C1Hpnnzy92-jm2blBKeYMNS2zDWlPibjJCKAMUsuHQaMgFlQI58qH5Nkk8xqT9kH5V/s179/Screenshot+from+2021-11-26+19-49-56.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="97" data-original-width="179" height="97" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL6grA73mDABK2jPCCLw3V_4_Tqsm_GgSoTYQWqdZqqjcDhFKsRH18tEHbpNQ8vlJlkMfaTgOJg-C1Hpnnzy92-jm2blBKeYMNS2zDWlPibjJCKAMUsuHQaMgFlQI58qH5Nkk8xqT9kH5V/s0/Screenshot+from+2021-11-26+19-49-56.png" width="179" /></a></div><p></p><p>This error occurs because the nodejs version which is delivered by ubuntu is version v.10.19.0.<br /></p><p>You have to download the armv8 package from <a href="https://nodejs.org/en/download/">https://nodejs.org/en/download/</a></p><p>With version v16.13.0 the error was gone...<br /></p><p> </p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-14694928982562680932021-11-20T09:30:00.004+01:002021-11-20T09:30:35.344+01:00AZ-900 achieved: Microsoft Azure Fundamentals<p>Yesterday evening i passed <a href="https://docs.microsoft.com/en-us/learn/certifications/exams/az-900" target="_blank">Microsofts AZ-900 exam</a>:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7EMPm24eRtzZ9A5vjr2WxPOgLhtZlherrbfQnZAi66LtvaqWvNKjopdTCTOA-f3GbilSY0bW_9k-1sVCQnx4roL-4K1ogvJDGXu7_ovNxtm5Hb6lB7hke6UYFcrgoe5FpspFbHkLVSGaP/s1162/Screenshot+from+2021-11-20+09-16-24.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="541" data-original-width="1162" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7EMPm24eRtzZ9A5vjr2WxPOgLhtZlherrbfQnZAi66LtvaqWvNKjopdTCTOA-f3GbilSY0bW_9k-1sVCQnx4roL-4K1ogvJDGXu7_ovNxtm5Hb6lB7hke6UYFcrgoe5FpspFbHkLVSGaP/w640-h298/Screenshot+from+2021-11-20+09-16-24.png" width="640" /></a></div>Taking the exam on site was no option because of COVID-19, so tried the first time the online option. Nice thing: Many schedules and i chose 20:45. <p></p><p>As examinee you have to start your online session half an hour earlier and this time you really need for the onboarding: </p><ol style="text-align: left;"><li>Download the software to your PC and do some checks (audio, network, ...)<br />This is an .exe - so only windows PCs are possible</li><li>Install the app "Pearson VUE" on your smartphone to provide</li><ol><li>selfie</li><li>passport/driver license/...</li><li>photos of your room</li></ol><li>Talking to an instructor<br />You are not allowed to wear a headset - even a watch is not allowed</li></ol><p> After that the exam is about 40 questions in 45 minutes - quite fair.</p><p> The questions are about these topics:</p><ul class="margin-xs"><li class="font-size-sm">
Describe cloud concepts (20-25%)
</li><li class="font-size-sm">
Describe core Azure services (15-20%)
</li><li class="font-size-sm">
Describe core solutions and management tools on Azure (10-15%)
</li><li class="font-size-sm">
Describe general security and network security features (10-15%)
</li><li class="font-size-sm">
Describe identity, governance, privacy, and compliance features (15-20%)
</li><li class="font-size-sm">
Describe Azure cost management and Service Level Agreements (10-15%)
</li></ul><p>More information can be found here: <a href="https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE3VwUY">https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE3VwUY</a></p><p>If you want to do this exam, start <a href="https://docs.microsoft.com/en-us/learn/paths/az-900-describe-cloud-concepts/" target="_blank">here</a>:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYQlSm9Gv7rS3NKe1uMK7PaccyZbSd1r1qGKfR5kf48Hd_aphHap75_2DwEhPyWVQdOL2sCjDXFrxacPui9FQEIcBIeFbC5q4w6f4RwOQJqFXz9Ymp42a36UvxbZUVeHcOXeVY5N1mtdkm/s1526/Screenshot+from+2021-11-20+09-29-26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="965" data-original-width="1526" height="404" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYQlSm9Gv7rS3NKe1uMK7PaccyZbSd1r1qGKfR5kf48Hd_aphHap75_2DwEhPyWVQdOL2sCjDXFrxacPui9FQEIcBIeFbC5q4w6f4RwOQJqFXz9Ymp42a36UvxbZUVeHcOXeVY5N1mtdkm/w640-h404/Screenshot+from+2021-11-20+09-29-26.png" width="640" /></a></div><br /><p><br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com2tag:blogger.com,1999:blog-5146606961939082932.post-69595365293459905052021-11-06T22:56:00.002+01:002021-11-06T22:56:20.912+01:00Fritz!Box monitoring with grafana, influx, collectd and fritzcollectd<p> A nice way to monitor your Fritz!Box is this here:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzVx1Mbdh65PwSppOVDMc27NiSgwh9GPzxU5KSq-KKMYjVW4ZuSi5jhyt-Zwv2g8W2haD2kla8MGMm9oBSGSP4RrluTNavaOaS_EXbFQwofmhMQQ-0dXvBZBp0l1etouCgTJEmn-UTygG9/s1534/Screenshot+from+2021-11-06+22-43-28.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="991" data-original-width="1534" height="414" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzVx1Mbdh65PwSppOVDMc27NiSgwh9GPzxU5KSq-KKMYjVW4ZuSi5jhyt-Zwv2g8W2haD2kla8MGMm9oBSGSP4RrluTNavaOaS_EXbFQwofmhMQQ-0dXvBZBp0l1etouCgTJEmn-UTygG9/w640-h414/Screenshot+from+2021-11-06+22-43-28.png" width="640" /></a></div><br /><p>How can you achieve this:</p><p><a href="https://fetzerch.github.io/2014/08/23/fritzcollectd/">https://fetzerch.github.io/2014/08/23/fritzcollectd/</a></p><p>and </p><p><a href="https://github.com/fetzerch/fritzcollectd">https://github.com/fetzerch/fritzcollectd</a></p><p>Here a list of the software packages you have to install</p><p>apt install -y collectd python3-pip libxml2 libxml2-dev libxslt1-dev influxdb nodejs git make g++ gcc npm net-tools certbot mosquitto mosquitto-clients grafana-server</p><p>for grafana-server and influxdb you have to add new repositories, because they are still not included in ubuntu.</p><p>To tell collectd, that it shoud write to influxdb, you have to uncomment the following in collectd.conf:</p><p><Plugin network><br /> Server "localhost" "25826"<br /></Plugin><br /></p><p>and in influxdb.conf:</p><p>[[collectd]]<br /> enabled = true<br /> bind-address = "localhost:25826"<br /> database = "collectd"<br /> retention-policy = ""<br /> typesdb = "/usr/share/collectd/types.db"<br /> parse-multivalue-plugin = "split"<br /></p><p>and of course inside collectd.conf you have to add the fritzcollectd config from the github link above.</p><p>But with starting collectd you might get the error:</p><p>dlopen("/usr/lib/collectd/python.so") failed: /usr/lib/collectd/python.so: undefined symbol: PyFloat_Type</p><p>This can be solved with adding into /etc/default/collectd:<br /><br />LD_PRELOAD=/usr/lib/python3.8/config-3.8-aarch64-linux-gnu/libpython3.8.so<br /><br /></p><p><br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-57654503205369080682021-11-06T17:20:00.003+01:002021-11-06T23:00:50.593+01:00Zigbee: Setup zigbee2mqtt with usbstick conbee II & influxdb on a raspberry pi<p></p><p>Just a short walkthrough of all steps which are necessary:</p><p>1.) insert the usbstick and check if this special device is there: /dev/ttyACM0 </p><p>if this device is not showing up, it might be, that your kernel does not support usbserial. In my case i had to downgrade from ubuntu server 21.10 to 21.04.<br /></p><p>2.) follow these steps: <a href="https://www.zigbee2mqtt.io/guide/installation/01_linux.html#installing">https://www.zigbee2mqtt.io/guide/installation/01_linux.html#installing</a></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOVLfqnmUkz56hHRebzBXHpoCgvUxXvSC18RDfqfqIjTjB5LcVs6ivLldEBxIR0mh5dvSHJFSQ_D967EuAYfS8OFnzzkdRUJBtuxmC_ZqbFV_mweK9wKkEhj-vdyX7gFCMCPVLy0nfmnqU/s467/Screenshot+from+2021-11-06+17-17-40.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="342" data-original-width="467" height="234" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOVLfqnmUkz56hHRebzBXHpoCgvUxXvSC18RDfqfqIjTjB5LcVs6ivLldEBxIR0mh5dvSHJFSQ_D967EuAYfS8OFnzzkdRUJBtuxmC_ZqbFV_mweK9wKkEhj-vdyX7gFCMCPVLy0nfmnqU/s320/Screenshot+from+2021-11-06+17-17-40.png" width="320" /></a></div><br /> <p></p><blockquote><pre style="background: black none repeat scroll 0% 0%; color: silver;"><p><br />apt-get install -y nodejs git make g++ gcc npm<br />git clone https://github.com/Koenkk/zigbee2mqtt.git /opt/zigbee2mqtt<br />cd /opt/zigbee2mqtt<br />
npm ci</p></pre></blockquote><p>if you get </p><blockquote><p>prebuild-install WARN install EACCES: permission denied, access '/root/.npm/_cacache' <br /></p></blockquote><p>then you should not use root for running this command.</p><blockquote><pre style="background: black none repeat scroll 0% 0%; color: silver;"><p>cd /opt/zigbee2mqtt<br />chown -R ubuntu node_modules<br />rm node_modules/*<br />npm ci<br /></p></pre></blockquote><p>3.) install mqtt </p><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhreq69tYNEcwmCUn5sFtmlQkjaRYCuHaZA-wkcm4dcr73atiPXAt8PSFt83MYJOITL9IYBMG7VkVQw2-uENbYafj_fZ1jR6PtH5F96FZ7d_XyidwiEJxgwdU49cJqmSFhdDoFfS1dQu8tg/s318/index.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="159" data-original-width="318" height="159" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhreq69tYNEcwmCUn5sFtmlQkjaRYCuHaZA-wkcm4dcr73atiPXAt8PSFt83MYJOITL9IYBMG7VkVQw2-uENbYafj_fZ1jR6PtH5F96FZ7d_XyidwiEJxgwdU49cJqmSFhdDoFfS1dQu8tg/s0/index.png" width="318" /></a> <br /></p><blockquote><pre style="background: black none repeat scroll 0% 0%; color: silver;">apt install mosquitto mosquitto-clients</pre></blockquote><p>4.) add to /etc/mosquitto/mosqitto.conf the line</p><blockquote><p>listener 1883 127.0.0.1</p></blockquote>and restart mosquitto (systemctl restart mosquitto) <p> </p><p>5.) then start the zigbee2mqtt:</p><blockquote><pre style="background: black; color: silver;"><p>cd /opt/zigbee2mqtt<br />npm start<br /></p></pre></blockquote><p> if you get</p><p><b></b></p><blockquote><b>Zigbee2MQTT:error 2021-11-06 09:05:23: Error: Error while opening serialport 'Error: Error: No such device or address, cannot open /dev/ttyACM0' </b></blockquote><p></p><p>then you did not really check step 1.): please check that /dev/ttyACM0 is missing - if yes: for me the kernel module (to list: lsmod) usbserial was missing. It seems, that ubuntu missed that on 21.10 - so i reinstalled 21.04....</p><p>if you get</p><blockquote><p><b>zigbee2MQTT:error 2021-11-06 14:54:11: MQTT failed to connect: connect ECONNREFUSED 127.0.0.1:1883</b><br /></p></blockquote><p> then you did not get mosquitto running. Check with systemctl status mosquitto and follow step 3 and 4.</p><p>6.) configure telegraf, so that the data from mosquitto is transferred to influxdb. So you have to add to telegraf.conf:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3rsOIWHyeq5Yx10DGpSzYX2Y72Hzyc2Uz9va2_Klz9ST_UOkNXIX7-TyjRrs2pXAPOo_vqNKpdMCZmzCpPw5T7gucTVwtOXO39kCBMj4JDmec8omVIZE7WxSivnvF1NwouqT7G1mLI1ZQ/s1313/Screenshot+from+2021-11-06+17-18-31.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="416" data-original-width="1313" height="126" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3rsOIWHyeq5Yx10DGpSzYX2Y72Hzyc2Uz9va2_Klz9ST_UOkNXIX7-TyjRrs2pXAPOo_vqNKpdMCZmzCpPw5T7gucTVwtOXO39kCBMj4JDmec8omVIZE7WxSivnvF1NwouqT7G1mLI1ZQ/w400-h126/Screenshot+from+2021-11-06+17-18-31.png" width="400" /></a></div><br /> <p></p><p></p><blockquote><span style="font-family: courier;">[[inputs.mqtt_consumer]]<br /> servers = ["tcp://127.0.0.1:1883"]<br /> topics = [<br /> "zigbee2mqtt/sensor/#",<br /> ]<br /> data_format = "json"<br /><br />[[outputs.influxdb]]<br /> urls = ["unix:///var/run/influxdb/influxdb.sock"]<br /> username = "admin"<br /> password = "XXXXX"</span></blockquote><p></p><p>7.) add this user to influxdb:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi44le7magzVBzm8qhSkxdG_vNougPgPzamj9bfD66SkraGRffKEPb9AvsFUsmRZcHiQpvw8EHWKRl-JqmjDAL2trRcbiNZO6za3-kMyc-X43Od2T7P3hxKJQErdjSQJ1UFe5nFm-Pox3jR/s221/Screenshot+from+2021-11-06+17-19-19.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="72" data-original-width="221" height="72" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi44le7magzVBzm8qhSkxdG_vNougPgPzamj9bfD66SkraGRffKEPb9AvsFUsmRZcHiQpvw8EHWKRl-JqmjDAL2trRcbiNZO6za3-kMyc-X43Od2T7P3hxKJQErdjSQJ1UFe5nFm-Pox3jR/s0/Screenshot+from+2021-11-06+17-19-19.png" width="221" /></a></div><br /> <p></p><p></p><blockquote><p>influx -ssl -unsafeSsl (<a href="https://dietrichschroff.blogspot.com/2020/12/securing-influxdb.html">only influx if you have not enabled SSL</a>)</p><p>create user admin with password 'XXXXXXX' with all privileges</p><p></p></blockquote><p>8.) if you have joined a device this the zigbee2mqtt, then you have to give a friendy name inside /opt/zigbee2mqtt/data/configuration.yaml</p><blockquote><p><span style="font-family: courier;"> friendly_name: 'sensor/t1'</span><br /></p></blockquote>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-693461062125570392021-10-30T19:51:00.002+02:002021-10-31T18:39:03.559+01:00Review: Mastering Azure Machine Learning<p>Last week i stumbled upon this book and this weekend there was enough time to walk through it:</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0g1dxRUqEfdG1ki2Y3BElU9D7uZa-09drAufgYfpBi6pyFIQ_C0UdPYFqjr2y-dEE19uDKQFk3y3kPt3kdxnpTd7p70IuzbC9FDf6-BOHOGptS1JLp0_lw8X3ekCMxWCXzacJeGbIkFZj/s991/Screenshot+from+2021-10-29+19-50-29.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="991" data-original-width="801" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0g1dxRUqEfdG1ki2Y3BElU9D7uZa-09drAufgYfpBi6pyFIQ_C0UdPYFqjr2y-dEE19uDKQFk3y3kPt3kdxnpTd7p70IuzbC9FDf6-BOHOGptS1JLp0_lw8X3ekCMxWCXzacJeGbIkFZj/s320/Screenshot+from+2021-10-29+19-50-29.png" width="259" /></a></div> <p></p><p>The book contains 14 chapters on 409 pages - but due to the layout, i think it can fit on 200 pages on a book with "default rendering".<br />The book is in addition divided in 4 sections: 1 - Azure Machine Learning / 2 - Experimentation and Data Preperation / 3 - Training Machine Learning Models / 4 Optimization and Deployment of Machine Learning Models<br /><br />Chapter 1 is named "Building an end-to-end machine learning pipeline in Azure". I struggled with this title, but in the first section it is explained: "You can see it as an overview of the book". The subsections cover data exploration, data preparation, choosing the model, optimization and deploying/operating models. The chapter is a teaser with many graphs, examples, stragetgies - a fast end-to-end walk through.<br /><br />"Choosing a machine learning service in Azure" is the title of the second chapter. Here is everything discussed about ML vs. AI and the Azure services, which provide these techniques (e.g. Data Science Virtual Machine, Azure Batch, Azure Databricks, Azure Functions, Azure IoT Edge, Custom Vision, Azure Machine Learning Designer, Machine Learning Studio, ...). This chapter contains many screenshots and code snippets - from my point of view to much at this point.<br /><br />In chapter three (Data experimentation and visualization using Azure) it is shown how to setup your environment via Azure CLI, so that you are able to perform these steps again and again for new projects. In addition it is presented how to run everything on the local machine and track the metrics and artifacts to the Azure workspace. After that visualization is explained including code examples. Pairplots, principal component analysis, quadratic discriminant analysis, stochastic neighbor embedding - Really cool.<br /><br />Chapter 4 is about "ELT, data preparation and feature extraction". Here are some nice commands with Azure CLI provided: How to batch upload data up to the Azure storage accounts and attaching them to the ML workspace. And how to access this data via python.<br /><br />Chapter 5 "Azure Machine Learning Pipelines" is about to make the content of chapter 4 reusable. I think nothing to note here - a nice reference for the python code which is needed.<br /><br />"Advanced feature extraction with NLP" is chapter 6. NLP = natural language processing. Nothing more to say here.<br /><br />The chaper 7 to 9 are about training machine learning models. I think i will not describe each of them. But here a short summary: It starts with decision trees as explanation and then does a deep dive in how to use LightGBM including the python code. Then the same for convolutional neural networks (CNN): explanation/motivation + coding. This is followed by the description of Azure Hyperdrive: tuning and optimizing the machine learning process. The concept of hyperparameters (e.g. number of neurons in a layer) is introduced and how to choose them with grid sampling on an elastic cloud infrastructure. And last but not least: it is described how Azure provides "a service to users that automatically preprocesses your data, selects an ML model, and trains and optimizes the model to optimally fit your training data [...]".<br /><br />Chapter 10 is about using clusters. This is a nice introduction about partitioning data, workloads and synchronizing worker nodes.<br />"Building a recommendation engine in Azure" is the title of chapter 11. Just some catchwords from the content: non-personalized, contentbased, rating-based, hybrid recommendations. After this chapter you will know, why amazons recommendations are like they are ;-)<br /><br />In chapter 11 & 12 it is described, how to register, deploy and operate a recommendation engine or machine learning model up to MLOps.<br /><br />The book closes with chapter 14 "What's next?". Most important point like everywhere: Automation...<br /><br />Summary: I liked this book very much, because every topic starts with an excellent introduction and there are many code examples, so that you can us this book as reference as well. The basic understanding of the author is best described with the following quote:<br />"the most important tasks [are]: Data acquisition, Data cleansing, Data labeling, Selecting an error metric. We don't want to blame anyone, but some machine learning engineers love to simply skip these topics and dive right into the fun parts, namely feature engineering, model selection, parameterization, and tuning." </p><p>That hits the bull's eye. <br /></p><p>(<a href="https://www.amazon.de/review/R1Z9BYI3XT2NI1/ref=cm_cr_srp_d_rdp_perm?ie=UTF8&ASIN=1789807557">The review can be found on amazon as well</a>)<br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-80812876748737272412021-09-11T23:38:00.002+02:002023-02-19T10:31:09.334+01:00Review: Intent based networking for dummies<p>I found the book intent-based networking on linkedin posted by juniper:<br /></p><p style="text-align: center;"></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiV9KkH2rFsFHFEpzwpnk7nOXlH4hdxHfByCo3EA7MAbaPYC46csw8_uV1MT-jZGlfaK3N2liQwefq2sVdQX_UkX9B1L_Pc0HMHX9VLC94j1Sqq_I1oOMHVyVFptvl8wCky70E7gwinZ8Mx/s616/Screenshot+from+2021-09-12+20-19-34.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="616" data-original-width="467" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiV9KkH2rFsFHFEpzwpnk7nOXlH4hdxHfByCo3EA7MAbaPYC46csw8_uV1MT-jZGlfaK3N2liQwefq2sVdQX_UkX9B1L_Pc0HMHX9VLC94j1Sqq_I1oOMHVyVFptvl8wCky70E7gwinZ8Mx/s320/Screenshot+from+2021-09-12+20-19-34.png" width="243" /></a></div><p></p><p>The book contains 5 chapters on 44 pages.</p><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSEDSSQAIQ2aFHWJH9jxCs0hAdrBQZ6zDLrE3n0woDywJpZEaubUugsfoswx3O-3qqqB2EbqMR3a5xWuTK1E1ZobdlfxMy5popIc8Uvov3-gaIWo22fgSCbY0jxlo36JSttHX4KxS82Nug/s639/Screenshot+from+2021-09-11+23-34-43.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="639" data-original-width="519" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSEDSSQAIQ2aFHWJH9jxCs0hAdrBQZ6zDLrE3n0woDywJpZEaubUugsfoswx3O-3qqqB2EbqMR3a5xWuTK1E1ZobdlfxMy5popIc8Uvov3-gaIWo22fgSCbY0jxlo36JSttHX4KxS82Nug/w325-h400/Screenshot+from+2021-09-11+23-34-43.png" width="325" /></a> <br /></p><p></p><p></p><p></p><p></p><p></p><p><br />Chapter one (expressing intent and seeing the basics of IBN) tries to give a motivation for intent based networking. And the story goes like this: "humans are slow, expensive, error prone, and inconsistent. [...] the systems are vulerable to small mistakes that can have enormous costs to business."<br />In addition we have "inadequate automation", "data overload", and "stale documentation". (At this point i think we are generally doomed and should stop networking at all).<br />BUT with IBN "you can manage what requires auto- mation, make your system standardized and reliable, and ensure youâre free to move and adjust heading into the future." The promise of IBN is to do a change from node-to-node management to an autonomic system. "The sys tem self-operates, self-adjusts, and self-corrects within the parameters of your expressed technical objectives."<br />So everthing should work like this: you express your intent - this intent is translated and then orchestration configuration will roll out the changes onto your network.<br />I think on good phrase for IBN is: "<b>You say what, it says how</b>"</p><p><br />The second chapter is named "Looking at the characteristics of IBN. This chapter does not give any helpful information at all. One nice concept is mentionend here: "Simple Pane of Glass": "tâs an important concept and a valuable benefit of having a single source of truth: You can see your entire network from a single, consistent perspective." But is think this is not possible for networks. Depending on your perspective (ethernet, vlans, ips, mpls, ...) the view is completely different. Just think about hardware ports vs virtual ports...<br /> </p><p>"Detailing the IBN architecture" is the titel of chapter 3. This chapter is with 9 pages the biggest chapter inside the booklet. In this chapter an example is drilled through: The intent "I want a VLAN connecting servers A, B, C, and D." is analyzed and the steps from define, translate, verify, deploy and monitor are shown.<br />In addition there are some subsection where the reference design, abstractions, inventory are put into relation to each other. This is illustrated with very nice figures. Really a good chapter!<br /> </p><p>In chapter four the book moves forward from fulfillment to assurance. "This chapter shows you why your IBN system (IBNS) requires sophisticated, deep analytics that can detect when a deployed service is drifting out of spec and either automatically make the adjustments to bring it back into compliance or alert you to the problem."<br />It starts with differentiating uncontrolled changes from controlled changes. This is nothing special to IBN. I think this is useful for any kind of operation in IT.<br /> </p><p>Chapter 5 is as always in this "dummmies" series a recap of the chapters before.<br /><br /><br />All in all a nice booklet which introduces very well in this new kind of network management system. But if IBN can keep the promises - let's see...<br /> </p><br /><br /><br />Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0tag:blogger.com,1999:blog-5146606961939082932.post-76282543634018372072021-05-19T19:01:00.001+02:002021-05-19T19:01:00.207+02:00Microsoft Teams: How to prevent Teams echo bot from constantly disturbing phone conferences<p>Some people have found a new hobby: Blowing up Teams meetings.</p><p>How do they achieve this?</p><p>Very easy. If you are inside a Teams meeting just go to "add members" and type in "Teams echo":</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZknicO_OT-bkfeJ0iPwtBWHfuzPzfj0iYEcL4OsnhAWWc7wnxbapFIs2liqNUvVaWkeqYP7RCL5EDGOnVbNo4Lokyq3KolqSGUSEDojIzUEK-K2a13u4g-68oRQoPRglrOhGpD5NjUb1W/s351/teamsecho.PNG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="173" data-original-width="351" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZknicO_OT-bkfeJ0iPwtBWHfuzPzfj0iYEcL4OsnhAWWc7wnxbapFIs2liqNUvVaWkeqYP7RCL5EDGOnVbNo4Lokyq3KolqSGUSEDojIzUEK-K2a13u4g-68oRQoPRglrOhGpD5NjUb1W/s320/teamsecho.PNG" width="320" /></a></div><p></p><p>The annoying things about this: </p><ul style="text-align: left;"><li>This can be done by anyone who was invited and is not limited to your organzation</li><li>On Linux you are not able to invite the Team Echo</li><li>The lobby does not work for Teams Echo - that means he will join you and you have to chance to get rid of that.</li><li>You can not mute Teams Echo<br /></li></ul><p>Then click on this and you will get the following experience:</p><p></p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="266" src="https://www.youtube.com/embed/XPRBRTgpDFs" width="320" youtube-src-id="XPRBRTgpDFs"></iframe></div> <p></p><p>There is one hint i found:</p><p><span face=""Arial",sans-serif" style="font-size: 10pt;"><a data-saferedirecturl="https://www.google.com/url?q=https://docs.microsoft.com/en-us/answers/questions/284720/can-we-block-or-remove-39teams-echo39-bot-from-ent.html&source=gmail&ust=1614363132313000&usg=AFQjCNEYA7LsEvyPsfnTOn0FS-LnIJCsIg" href="https://docs.microsoft.com/en-us/answers/questions/284720/can-we-block-or-remove-39teams-echo39-bot-from-ent.html" target="_blank">https://docs.microsoft.com/en-<wbr></wbr>us/answers/questions/284720/<wbr></wbr>can-we-block-or-remove-<wbr></wbr>39teams-echo39-bot-from-ent.<wbr></wbr>html</a> <br /></span></p><p>Microsoft itself does not really understand the issue:</p><p><a href="https://answers.microsoft.com/en-us/msteams/forum/all/teams-echo-entering-into-meetings/3418d131-8619-4785-9ab4-0aed6acbb8c2?auth=1">https://answers.microsoft.com/en-us/msteams/forum/all/teams-echo-entering-into-meetings/3418d131-8619-4785-9ab4-0aed6acbb8c2?auth=1</a> <br /></p><p>But this does not work, because you do not find a "Teams echo app" inside <a href="https://admin.teams.microsoft.com/policies/manage-apps">https://admin.teams.microsoft.com/policies/manage-apps</a> </p><p>The problem is known:</p><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="266" src="https://www.youtube.com/embed/LJKLtABu_V8" width="320" youtube-src-id="LJKLtABu_V8"></iframe></div><br /><p>If you know how to prevent this: Please leave a comment...<br /></p>Dietrich Schroffhttp://www.blogger.com/profile/18397485256708620180noreply@blogger.com0