Etaoin shrdlu (/ˈɛtiˌɔɪnˈʃɜrdluː/)[1] … is the approximate order of frequency of the 12 most commonly used letters in the English language.
via 5 Hole Paper Tape – Computerphile
Source: Etaoin shrdlu – Wikipedia, the free encyclopedia
Author Archive
Etaoin shrdlu – via 5 Hole Paper Tape – Computerphile
Posted by jpluimers on 2018/01/29
Posted in Fun, History, Quotes, T-Shirt quotes | Leave a Comment »
foone on Twitter: I’m FINALLY ready to turn my old computer in to IT. They have to power on all turned in computers to make sure they’re functional before they recycle them, so they’re in for a small surprise. Windows 3.0 running on MS-DOS 6.22!…
Posted by jpluimers on 2018/01/26
This is tool funny, especially how he got it on the machine: [WayBack] foone on Twitter: I’m FINALLY ready to turn my old computer in to IT. They have to power on all turned in computers to make sure they’re functional before they recycle them, so they’re in for a small surprise. Windows 3.0 running on MS-DOS 6.22!…
–jeroen
Share this:
Posted in Fun | 2 Comments »
WhatsApp FAQ – Formatting your messages
Posted by jpluimers on 2018/01/26
Oh cool:
Formatting your messages –
WhatsApp allows you to format selected text inside your messages.
Italic
To italicize your message, place an underscore on both sides of the text, like so:
_text_Bold
To bold your message, place an asterisk on both sides of the text, like so:
*text*Strikethrough
To
strikethroughyour message, place a tilde on both sides of the text, like so:~text~Monospace
To
monospaceyour message, place three backticks on both sides of the text, like so:```text```Alternatively: On Android, you can tap and hold the text you’re typing > More …
Source: [WayBack] WhatsApp FAQ – Formatting your messages
–jeroen
Share this:
Posted in Android Devices, Power User, SocialMedia, WhatsApp, WhatsApp for Android | Leave a Comment »
Location, location
Posted by jpluimers on 2018/01/26
This is why I try to avoid doing web-development: [WayBack] Location, location: location = location … and a 534 other ways to reload the page with JavaScript.
Via [WayBack] location = location … and a 534 other ways to reload the page with JavaScript – ThisIsWhyICode – Google+
–jeroen
Share this:
Posted in Development, JavaScript/ECMAScript, Scripting, Software Development, Web Development | Leave a Comment »
Wat is het rekeningnummer van ICS – Mijn ICS
Posted by jpluimers on 2018/01/26
Voor als ik het een keer nodig heb: [WayBack] Wat is het rekeningnummer van ICS – Mijn ICS
Betalen aan ICS via internetbankieren
Benodigde gegevens
Wilt u een betaling doen aan ICS via internetbankieren? Gebruik één van onderstaande rekeningnummers:
- ABN AMRO: NL75 ABNA 0844 9970 56
- ING: NL43 INGB 0005 6353 34
- Rabobank: NL88 RABO 0187 4987 92
Vermeld in de omschrijving altijd uw ICS-klantnummer. U vindt dit nummer bovenaan de pagina als u bent ingelogd op Mijn ICS.
Betaalt u via een buitenlandse bank?
Dan kan u ook om de volgende gegevens van ICS gevraagd worden:
BIC: ABNANL2A Adres: ICS BV
Wisselwerking 32
1112 XP Diemen
The Netherlands
–jeroen
Share this:
Posted in LifeHacker, Power User | Leave a Comment »
Proxmox with Windows VMs and backups: why you want qemu-agent and how to install it
Posted by jpluimers on 2018/01/26
When running Windows VMs on Proxmox and you want to make snapshot backups you really want to run the qemu-agent inside the Windows VMs.
First of all you really want snapshot mode backups as of all backup modes they have the least downtime. By default they have a small inconsistency risk, but on Windows that can be alleviated by running qemu-agent as described in [WayBack] Backup and Restore – Proxmox VE: Backup Modes
More on snapshot backup mode
Backup modes for VMs:
- snapshot mode
- This mode provides the lowest operation downtime, at the cost of a small inconstancy risk. It works by performing a Proxmox VE live backup, in which data blocks are copied while the VM is running. If the guest agent is enabled (agent: 1) and running, it calls guest-fsfreeze-freeze and guest-fsfreeze-thaw to improve consistency.
A technical overview of the Proxmox VE live backup for QemuServer can be found online here (https://git.proxmox.com/?p=pve-qemu-kvm.git;a=blob;f=backup.txt -> https://git.proxmox.com/?p=pve-qemu-kvm.git;a=blob;f=vma_spec.txt;).
Proxmox VE live backup provides snapshot-like semantics on any storage type. It does not require that the underlying storage supports snapshots.
On Windows the trick is that qemu-agent can use VSS to get a frozen state of the filesystem as described in [WayBack] Qemu-guest-agent – Proxmox VE:
In Proxmox VE, the qemu-guest-agent is used for mainly two things:
- To properly shutdown the guest, instead of relying on ACPI commands or windows policies
- To freeze the guest file system when making a backup (on windows, use the volume shadow copy service VSS).
So: installing qemu-agent.
Start with the VM options
Don’t make the mistake to start at [WayBack] Qemu-guest-agent – Proxmox VE: Installation; guest; Windows as it will give you a hard time. Always use the full [WayBack] Qemu-guest-agent Installation steps beginning at the[WayBack] Host; these steps worked for me:
- Download a recent set of [WayBack] Windows VirtIO Drivers – Proxmox VE
- Ensure the ISO image is in
/var/lib/vz/template/isoon the Proxmox host so they show up as local:iso for mounting. - Shutdown the Windows VM
- [WayBack] Qemu-guest-agent – Proxmox VE: Host; enable guest for VM: on the “Options” page for a VM, ensure the “Qemu Agent” setting is set to “yes”
- This will add a PCI serial device to your computer that Windows – after a fresh boot – sees as “PCI Simple Communications Controller”
- Mount the ISO image to a CD/DVD drive
- Boot the Windows VM
- Start Device Manager (
devmgmt.msc) - In the Device Manager, observe a new device “PCI Simple Communications Controller” that doesn’t have drivers installed yet
- Right click the”PCI Simple Communications Controller” device and select “Update Driver Software…”
- Indicate you want to browser for the files (as opposed of Windows finding them on-line: they’re not on-line):
- On the CD/DVD drive letter you mounted the ISO image to, select
D:\vioserial\[OS-Version]\whereOS-Versionis your Windows Version and ensure “Include subfolder” has a checkmark so it will find the Win32 or Win64 drivers depending on your processor architecture.- I used
D:\vioserial\w7
- I used
- Finish the driver installation
- Observe it now has a driver installed
- From
D:\guest-agentinstall eitherqemu-ga-x64.msifor Win64 orqemu-ga-x86.msifor Win32. - During installation, confirm the UAC prompt for sofware by
Red Hat, Inc.:
- Start the Service Manager (
services.msc) and execute from any command promt the following statments to verify the check if these services are running:
- Now reboot the VM, logon and start the Service Manager again; now it should look like this
Note you can obtain the same information from the console by executing these commands.
sc queryex "QEMU-GA"sc queryex "QEMU Guest Agent VSS Provider"
Before the reboot, they should show output like this:
C:\Windows\system32>sc queryex "QEMU-GA"
SERVICE_NAME: QEMU-GA
TYPE : 10 WIN32_OWN_PROCESS
STATE : 4 RUNNING
(STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0
PID : 4444
FLAGS :
C:\Windows\system32>sc queryex "QEMU Guest Agent VSS Provider"
SERVICE_NAME: QEMU Guest Agent VSS Provider
TYPE : 10 WIN32_OWN_PROCESS
STATE : 1 STOPPED
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0
PID : 0
FLAGS :
After reboot it should have become this:
C:\Windows\system32>sc queryex "QEMU-GA"
SERVICE_NAME: QEMU-GA
TYPE : 10 WIN32_OWN_PROCESS
STATE : 4 RUNNING
(STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0
PID : 1680
FLAGS :
C:\Windows\system32>sc queryex "QEMU Guest Agent VSS Provider"
SERVICE_NAME: QEMU Guest Agent VSS Provider
TYPE : 10 WIN32_OWN_PROCESS
STATE : 4 RUNNING
(STOPPABLE, PAUSABLE, IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0
PID : 1624
FLAGS :
Verification
Verifying the qemu-agent is reachable from the Proxmox host:
- Note the VM ID of the VM as #
- Reboot the VM (for instance by typing this on the command prompt:
shutdown -r -t 0)- I’m not sure this step is needed under all circumstances; if the below steps don’t work then you definitely need it.
- Verify the Proxmox host can communicate with the qemu-agent on the VM:
On the Proxmox host, start a terminal session, then type these commands where # is the ID of the VM (I’ve used 112 as an example here):
# socat /var/run/qemu-server/112.qga -
{"execute":"guest-sync", "arguments":{"id":1234}}
It should get you this result:
{"return": 1234}
Note there’s all sorts of nice stuff you can do with socat /var/run/qemu-server so maybe I’ll put more about it in a future blog post.
–jeroen
Some more links with background information:
- [WayBack] git.proxmox.com Git – pve-qemu-kvm.git/blob – backup.txt
- [WayBack] [SOLVED] – Bug or feature? During backup with stop, VM wakes up? | Proxmox Support Forum
- [WayBack] [SOLVED] – Most reliable way to backup a Windows 7 guest? | Proxmox Support Forum
Easiest is to download the ISO image to /var/lib/vz/template/iso on the Proxmox host so they show up as local:iso for mounting.
Share this:
Posted in Power User, Proxmox, Virtualization, Windows | Leave a Comment »
mikrotik CRUD examples for all APIs · danikf/tik4net Wiki
Posted by jpluimers on 2018/01/25
tik4net – Connect from .NET C# application to mikrotik router via ADO.NET like API or enjoy O/R mapper like highlevel api.
Source: CRUD examples for all APIs · danikf/tik4net Wiki
[Archive.is] C# API – tik4net on GitHub – Page 2 – MikroTik RouterOS
–jeroen
Share this:
Posted in .NET, C#, Development, MikroTik, RouterOS, routers, Scripting, Software Development | Leave a Comment »
HTTP Protocol Related Improvements in Delphi 10.2.2
Posted by jpluimers on 2018/01/25
After years of (peer) pressure, Embarcadero finally did some client-side [WayBack] HTTP Protocol Related Improvements in Delphi 10.2.2.
The fixes add some features to THTTPClient that have been available in Indy since version 9 (which however requires 1.0.2 OpenSSL binaries support the required functionality):
We have added a new enumeration,
THTTPSecureProtocolwith the values (SSL2, SSL3, TLS1, TLS11, TLS12).THPPTClientand related classes have now aSecureProtocolsproperty which is a set based on that enumeration.
References:
- [WayBack] System.Net.HttpClient.THTTPSecureProtocol – RAD Studio API Documentation
- [WayBack] System.Net.HttpClient.THTTPSecureProtocols – RAD Studio API Documentation
- [WayBack] System.Net.HttpClient.THTTPClient Properties – RAD Studio API Documentation does not include
SecureProtocols(yet?) - RAD Studio/RSP-18713: Add a secure protocol options to THTTPClient (cannot be archived)
- RAD Studio/RSP-18104: THttpClient with TLS1.1 and TLS1.2 on older Windows systems (cannot be archived)
- [WayBack] Indy 9 with Delphi: How to enable TLS 1.0? – Stack Overflow
- [WayBack] Embarcadero Discussion Forums: Indy v10, TLS v1.2, and OpenSSL …
- [WayBack] delphi – Using Indy 10 IdHTTP with TLS 1.2 – Stack Overflow
- [WayBack] [SOLVED] Indy and SSL
- [WayBack] Indy 9
–jeroen
Share this:
Posted in Delphi, Development, Software Development | 2 Comments »
git repository by David Heffernan – sets environment variable DelphiProjectCompileMode to the build type
Posted by jpluimers on 2018/01/25
Interesting repository https://github.com/davidheff/DelphiProjectCompileMode in a response to
[WayBack] I’m trying to use Pre-/Post-Build-Events (Delphi 10.1 Berlin, if that matters). Is there a variable, parameter, option etc to distinguish between a “make” and a “build”… – Achim Kalwa – Google+
This requires an expert as Delphi doesn’t do it out of the box, so I was glad this expert solves that: davidheff/DelphiProjectCompileMode: Delphi IDE add in that sets an environment variable to indicate which compile mode (make, build, etc.) was used to start a compile action
It sets the DelphiProjectCompileMode variable to a value depending on the TOTACompileMode:
cmOTAMake -> Make
cmOTABuild -> Build
cmOTACheck -> Check
cmOTAMakeUnit -> MakeUnit
otherwise -> Unrecognised
–jeroen
Share this:
Posted in Delphi, Development, Software Development | Leave a Comment »
How to terminate sqlcmd immediately after execution completed? – Stack Overflow
Posted by jpluimers on 2018/01/24
The subtle difference between -q and -Q: the latter will exit after executing the command (regardless of the SQL server version; I think this was introduced in SQL Server 2005 or 2000).
Inside the command, you can use single ' quotes for strings.
C:\Users\jeroenp>sqlcmd /? Microsoft (R) SQL Server Command Line Tool Version 10.50.2500.0 NT x64 Copyright (c) Microsoft Corporation. All rights reserved. usage: Sqlcmd [-U login id] [-P password] [-S server] [-H hostname] [-E trusted connection] [-N Encrypt Connection][-C Trust Server Certificate] [-d use database name] [-l login timeout] [-t query timeout] [-h headers] [-s colseparator] [-w screen width] [-a packetsize] [-e echo input] [-I Enable Quoted Identifiers] [-c cmdend] [-L[c] list servers[clean output]] [-q "cmdline query"] [-Q "cmdline query" and exit] [-m errorlevel] [-V severitylevel] [-W remove trailing spaces] [-u unicode output] [-r[0|1] msgs to stderr] [-i inputfile] [-o outputfile] [-z new password] [-f | i:[,o:]] [-Z new password and exit] [-k[1|2] remove[replace] control characters] [-y variable length type display width] [-Y fixed length type display width] [-p[1] print statistics[colon format]] [-R use client regional setting] [-b On error batch abort] [-v var = "value"...] [-A dedicated admin connection] [-X[1] disable commands, startup script, enviroment variables [and exit]] [-x disable variable substitution] [-? show syntax summary]
–jeroen
via: [WayBack] c# – How to terminate sqlcmd immediately after execution completed? – Stack Overflow
Share this:
Posted in Database Development, Development, Software Development, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | 1 Comment »
The Wiert Corner - irregular stream of stuff 