The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers

Archive for July, 2018

« Previous Entries
Next Entries »

Just I in case I need to port CombineApacheConfig.py to OpenSuSE properly

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

Read the rest of this entry »

Posted in *nix, *nix-tools, Apache2, Development, Linux, openSuSE, Power User, Python, Scripting, Software Development, SuSE Linux | Leave a Comment »

Use TLS 1.2 or higher, as TLS 1.1 is phased out on many sites, after TLS 1.0/SLL has been disabled by most for a while now

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 »

In case I ever need to record calls on my Fritz!Box devices

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.

Read the rest of this entry »

Posted in Fritz!, Fritz!Box, fritzcap, Internet, Power User | Leave a Comment »

The Illustrated Guide to Kubernetes – The Isoblog.

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

Read the rest of this entry »

Posted in Cloud, Containers, Docker, Infrastructure, Kubernetes (k8n), Power User | Leave a Comment »

(35) Enabling New Hardware in U-Boot – Jon Mason, Broadcom Ltd. – YouTube

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:

  • keep commits short so they are easy to review
  • make sure patches are always rebaseable for each and every commit set (so it compiles throughout)
  • this tremendously helps doing a git bisect
  • it makes adding features that other parts depend on hard: you need to think on chicken & egg situations in advance

–jeroen

 

Posted in *nix, Development, Hardware Development, Linux, Power User, Software Development, U-Boot | Leave a Comment »

Hacking the Logitech C920 & C930e Webcams – Graves On SOHO Technology

Posted by jpluimers on 2018/07/20

This could turn out in a way better quality and cheaper CCTV system than Ring offers: [WayBack] Hacking the Logitech C920 & C930e Webcams – Graves On SOHO Technology.

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

Read the rest of this entry »

Posted in Development, Hardware Development, LifeHacker, Power User | Leave a Comment »

/dev/lawyer Open Source License Business Perception Report

Posted by jpluimers on 2018/07/20

Looking at [WayBack] /dev/lawyer Open Source License Business Perception Report it seems that the [Archive.is] Apache License 2.0 causes the least pain and confusion for lawyers.

Via: [WayBack] Open Source License Business Perception Report: the pain and confusion of common open licenses, roughly quantified – This is why I Code – Google+

–jeroen

Posted in Development, Open Source, Software Development | Leave a Comment »

Some links for scaling and responsive resizing iframes

Posted by jpluimers on 2018/07/19

As I need both responsive resizing and zooming iframes one day:

–jeroen

Posted in CSS, Development, HTML, JavaScript/ECMAScript, JSFiddle, Scripting, Software Development, Web Development | Leave a Comment »

Delphi Community Edition available: good move for Embarcadero, but be careful how much revenue you make

Posted by jpluimers on 2018/07/19

On [WayBack] Delphi Community Edition available: – Uwe Raabe – Google+, the links to the [WayBack] EULA, [WayBack] FAQ and [WayBack] Feature Matrix were shared.

In summary (read the G+ thread for more), the Delphi Community Edition is a web-installer of version 10.2.3 feature equivalent to the Delphi Professional Edition.

I think it is a good move to make Delphi more accessible to many more people.

A few restrictions apply, for instance there is also a C++ Builder Community Edition equivalent to the C++ Builder Professional edition, but you cannot install them on the same system at the time time.

Also, you cannot move around the command-line compiler to a different system (for instance a build-machine for Continuous Integration purposes).

The financial restriction that applies can be summarised as this: When the revenue you make during the year exceeds USD 5000 you have to stop using the Community Edition license.

Note that this is about revenue, not about income (which many define as “net of revenues and expenses”), and does not mention the revenue source, so watch this during the years you use the Community Edition.

Furthermore, Embarcadero indicates they collect information about your use of the Community Edition, but the [WayBack] privacy statement is not clear how.

All in all I hope this move attracts fresh people into the Delphi community.

The heise – the German flagship IT journal – likes it too: [WayBack] Delphi und C ++ Builder als Community Edition | heise Developer (via [WayBack] Some nice PR … Embarcadero-konfektioniert-Delphi-und-C-Builder-als-Community-Edition-4115563… – Roland Kossow – Google+)

Edit 20180927

Yes, Embarcadero is going after your employer if you register Delphi Community with a corporate email address.

See [WayBack] Embarcadero wants me to pay for a download. : legaladvice – Joseph Mitzen – Google+ and [WayBack] Embarcadero wants me to pay for a download. : legaladvice

–jeroen

Posted in Delphi, Development, Software Development | 2 Comments »

Generating a million sequential numbers on the fly in a Firebird query – some solutions and speed measurements

Posted by jpluimers on 2018/07/19

The testing was done with Firebird 2.5.x x86 on Windows 7 x64.

Where other relational database platforms have plenty of opportunities to generate sequences (see for instance the below links on Oracle and SQL Server), with Firebird you can use a WITH RECURSIVE query construct that normally is being used to manage tree structures ([WayBack] PkLab – Firebird: Tree data mangement with recursive CTE).

However, that uses query stack which has a depth limit of 1024 levels. When you reach the limit, Firebird gives you an error like this:

with 
  recursive 
  sequence(n) as (        
    -- When you select more than 1024 values, this error occurs:
    -- Error while fetching data:  Too many concurrent executions of the same request    
    select 0 -- start
    from rdb$database
    union all
    select sequence.n + 1
    from sequence
    where sequence.n < 1023 -- finish
  )
select sequence.n 
from sequence
--where sequence.n in (24, 38) 
order by sequence.n

It however is a pretty quick and CU bound solution: on my system ([WayBack] AMD A8-7600 @ 3.1 Ghz), it runs 1000 records within ~0.1 seconds.

In such a short time, it’s hard to see how the speed is bound, so I wanted to go for some orders of magnitude more. In ~0.1 seconds, the processor executes about 0.3 * 10^9 cycles generating 1000 numbers which is ~ 300-thousand cycles per number. That sounds like a lot of cycles for so few numbers. Would this become a better ratio for more numbers?

Read the rest of this entry »

Posted in Database Development, Development, Firebird, IKEA hacks, OracleDB, SQL, SQL Server | Leave a Comment »

« Previous Entries
Next Entries »