Posted by jpluimers on 2018/07/25
I needed the below links to get a feel on how much effort it would be to convert ABNAMRO transactions from MT940 into CSV or XLS extracting as many useful fields as possible.
Maybe it useful for other people as well.
I know there is CAMT.053 as well, but that puts every transaction into a separate XML file but still spreads the description over a multi-line structured field (like :86: below).
Posted in Development, Software Development | Leave a Comment »
Posted by jpluimers on 2018/07/25
Since Firebird 2.1, you can get the first 3 numbers of the version with this SQL statement:
SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION')
from rdb$database;
You get it in this format:
RDB$GET_CONTEXT --------------- 2.5.7
Which means you will not get the build number, which for most purposes is still quite OK.
–jeroen
via: [WayBack] How to detect the server version?
Posted in Database Development, Development, Firebird | Leave a Comment »
Posted by jpluimers on 2018/07/24
Does anybody know a shorter, more permanent solution for [WayBack] RAD Studio 10.2.2 Annoying New Features. Help? – Forum – Embarcadero Community.
Especially the first one is very important to me.
Ever since Delphi introduced IDE layouts, it would remember the last one selected. With Delphi 10.2.2 Tokyo not so any more: it ALWAYS starts with an imposed “Startup Layout”. If you delete it, it re-appears.
I have a carefully named set of layouts that depends on the monitors I am using.
The workaround – every time I switch monitors, at least a few times a day, especially when moving between places, for instance for meetings – is this:
Then each time I tweak a layout, I have to remember to save it both as “Startup layout” and as the actual named layout.
The really dumb thing is that RSP-20138 Can not define default Startup layout is classified as
“Jira-Quality Sync Service added a comment – 29/May/18 2:50 AM
Issue is reclassified as ‘New Feature'”
Via [WayBack1, WayBack2] So Embarcadero broke the “Default layout” (now always enforces a new “Standard Layout”) upon IDE startup in 10.2 Tokyo, and commented on the bug report … – Jeroen Wiert Pluimers – Google+ which has quite a few nice comments and links, including:
Posted in Delphi, Delphi 10.2 Tokyo (Godzilla), Development, Software Development | 3 Comments »
Posted by jpluimers on 2018/07/24
Problem (D2007 and up)
If you are starting your Delphi VCL app meanwhile your mouse is moving, no accelerators are shown (Menu, button, focus rect missing… etc.)
Something similar happens when you click on a button which opens a new form, somehow UI State becomes a state which is wrong.
Solution
In a detoured Form.DoShow(Or in every OnShow event) :Self.Perform(WM_CHANGEUISTATE, MakeLong(UIS_CLEAR, UISF_HIDEACCEL or UISF_HIDEFOCUS), 0);
- No repaint penalty
- no flicker
- accels
- focus rect are always shown
- system is not touched.
Source: [WayBack] So, here is the thing…If you are starting your Delphi VCL app meanwhile your mouse is moving, no accelerators are shown (Menu, button, focus rect mis… – Attila Kovacs – Google+
Related: [WayBack] c# – Show Hotkeys at All Times – Stack Overflow
–jeroen
Posted in Delphi, Development, Software Development | Leave a Comment »
Posted by jpluimers on 2018/07/24
I came across a nice tool that combines httpd.conf files:
python CombineApacheConfig.py /etc/apache2/httpd.conf /tmp/apache2.combined.conf
In case I ever need to fully port it to OpenSuSE, I’ve put it in the gist below.
For now it works fine on OpenSuSE when used with the above command. I might make the default depend on the kind of nx it runs on.
via:
–jeroen
Posted in *nix, *nix-tools, Apache2, Development, Linux, openSuSE, Power User, Python, Scripting, Software Development, SuSE Linux | Leave a Comment »
Posted by jpluimers on 2018/07/23
If you get an error like this in one of your tools
OpenSSL: error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version
it means you are using a tool not yet properly supporting TLS 1.2 or higher.
Or in other words: update your tool set.
The reason is that – after turning off TLS 1.0 a while ago – more and more sites do the same for TLS 1.1.
A prime example of a site that warned on this in a clear way very early on is github:
Others have done this too, for instance:
TLS 1.0 is vulnerable to many attacks, and certain configurations of TLS 1.1 as well (see for instance [WayBack] What are the main vulnerabilities of TLS v1.1? – Information Security Stack Exchange), which means that properly configuring the non-vulnerable TLS 1.1 over times gets more and more complex. An important reason to say goodbye to that as well, as TLS 1.2 (from 2008) is readily available for a long time. The much more recent TLS 1.3 (from 2018) will take a while to proliferate.
I ran in the above error because on one of my systems, an old version of wget was luring around, so I dug up the easiest place to download recent Windows binaries for both win32 (x86) and win64 (x86_64):
[WayBack] eternallybored.org: GNU Wget for Windows having a table indicating the OpenSSL version for each wget build.
–jeroen
Reference: Transport Layer Security – Wikipedia: History and development
Posted in *nix, https, HTTPS/TLS security, OpenSSL, Power User, Security, wget | Leave a Comment »
Posted by jpluimers on 2018/07/23
I need to dig a bit deeper into these links to see how easy it is to record calls made on a Fritz!Box then playing back the captured calls.
Note that in various countries you have to indicate to the calling parties that their calls can be recorded.
Posted in Fritz!, Fritz!Box, fritzcap, Internet, Power User | Leave a Comment »
Posted by jpluimers on 2018/07/23
One day you will do containers.
If you want to know how k8n (Kubernetes) can help you with Docker containers, then read [WayBack] The Illustrated Guide to Kubernetes – The Isoblog. and watch the video below.
Very well explained!
Via: [WayBack] The Illustrated Children’s Guide to Kubernetes http://blog.koehntopp.info/index.php/1450-the-illustrated-guide-to-kubernetes/ You can now stop recommending it to me. – Kristian Köhntopp – Google+
–jeroen
Posted in Cloud, Containers, Docker, Infrastructure, Kubernetes (k8n), Power User | Leave a Comment »
Posted by jpluimers on 2018/07/20
Lots of interesting information, especially these discussions where Alexander Graf chipped in:
The hand off of the boot loader to the actual OS payload. The payload and U-boot are in memory running at the same time. The payload can call back into U-boot through the uEFI API that U-boot implements so that the payload provides extra drivers enabling for instance a subsequent graphical stage (splash screen, menus, etc), more hardware access and so on. You even could pass ACPI tables through U-boot to the payload and help shooting yourself in the foot.
Important aspects for upstreaming:
–jeroen
Posted in *nix, Development, Hardware Development, Linux, Power User, Software Development, U-Boot | Leave a Comment »
Posted by jpluimers on 2018/07/20
via: [WayBack] Until recently I did not know that this was possible, but people are hacking the venerable Logitech C920 and C930e webcams. – Lars Fosdal – Google+
–jeroen
Some nice pictures of stereo camera configuration by Joe C Hecht at https://plus.google.com/+JeroenPluimers/posts/9T8u82E8rH2
Posted in Development, Hardware Development, LifeHacker, Power User | Leave a Comment »
The Wiert Corner - irregular stream of stuff 