2026-11-04

eMudhras long tail - even the latest Mac OSX (Tahoe 26.7.2 (25G332)) is still vulnerable to CLI tools using the wrong certificates


Update: it seems that Apple changed their mind - they write: 

The latest version of macOS contains the strongest security protections. Starting in macOS 27.2.1, these command-line tools stop accepting these certificates. For Mac computers that use macOS 26 or macOS 15, macOS 26.7.3 and macOS 15.8.3 also include this protection.

It seems that Apple is not planning to update the file /etc/ssl/cert.pem so that the compromised intermediate certificates by eMudhra are removed any time soon.

Instead, users (mostly developers that use the Terminal aka command line interface (CLI)) must clean up the file themselves.

Here is the approach (as of 2026-11-04 - use at your own risk):

Check if you are vulnerable. If this command yields no output, you do not need to proceed.

openssl crl2pkcs7 -nocrl -certfile /etc/ssl/cert.pem | openssl pkcs7 -print_certs -noout | grep -E 'emSign ECC Root CA - G3|AAA Certificate Services'

Backup the file (only works if you do not yet have a backup)

[ -e /etc/ssl/cert.pem.orig ] || sudo cp -p /etc/ssl/cert.pem /etc/ssl/cert.pem.orig

Perform the surgery:

t=$(mktemp) && awk -v s='=== /C=IN/OU=emSign PKI/O=eMudhra Technologies Limited/CN=emSign ECC Root CA - G3' '/^(===|###) /{skip=0} $0==s{skip=1} !skip' /etc/ssl/cert.pem > "$t" && [ -s "$t" ] && sudo install -m 0644 -o root -g wheel "$t" /etc/ssl/cert.pem; rm -f "$t"

I would recommend to also remove these:

t=$(mktemp) && awk -v s='=== /C=GB/ST=Greater Manchester/L=Salford/O=Comodo CA Limited/CN=AAA Certificate Services' '/^(===|###) /{skip=0} $0==s{skip=1} !skip' /etc/ssl/cert.pem > "$t" && [ -s "$t" ] && sudo install -m 0644 -o root -g wheel "$t" /etc/ssl/cert.pem; rm -f "$t" If you see nothing, it worked. Otherwise, restore the file from the backup: sudo cp -p /etc/ssl/cert.pem.orig /etc/ssl/cert.pem

Unfortunately, Apple writes: 

  • A macOS software update can replace /etc/ssl/cert.pem with Apple's version. Until you install the software update that includes Apple's changes, run the command in step 4 after each software update. If it lists a root CA certificate that you removed, the update replaced the file. Delete the old backup using sudo rm /etc/ssl/cert.pem.orig, then repeat these steps. After you install the update that includes Apple's changes, you don't need to repeat these steps for the command-line tools included with macOS or the Xcode Command Line Tools.



2026-10-27

Exporting Binary CLCL Export to JSON via Python

 I have been a long-time user of the wonderful CLCL Clipboard manager on Windows (I use it since about 20 years).

This tool allows you to organize objects you copied to the Clipboard in a folder Structure.

CLCL then offers a feature to export this structure in a binary file so that it may be transferred to another computer or just backed up.

Since the source of the tool is available, we see that the export happens in File.c 

I then used Claude Haiku (the lowest tier model by Anthropic) to generate a Python script that is able to convert such a binary file to a JSON.

It came up with the script clcl_dump_to_json.py which works like a charm!

2026-05-10

Recycling in the US and elsewhere

 I recently saw this video on Youtube:

 

Since I am a Environmental Engineer by training (with one of my three specializations being waste management), I found the video very interesting. However, it struck me that apparently, the US is quite a bit behind concerning recycling. I did some research and found that the US recycles only about 32% of its waste, while the EU recycles about 50%. This is quite a significant difference, and it made me wonder why this is the case.


Contrast this to Germany, which has a recycling rate of about 66%. Germany has implemented a comprehensive waste management system that includes strict regulations, public awareness campaigns, and incentives for recycling. The country has also invested in advanced recycling technologies and infrastructure, which has helped to increase the recycling rate.
Also Switzerland, which has a recycling rate of about 53%, has implemented a similar approach to waste management. The country has strict regulations on waste disposal, and it has also invested in advanced recycling technologies and infrastructure.


On the other hand, the US has a more fragmented approach to waste management, with different regulations and policies at the federal, state, and local levels. This has led to a lack of consistency and coordination in waste management efforts, which may be contributing to the lower recycling rate. Additionally, the US has a culture of convenience and consumerism that may discourage recycling and encourage the use of single-use products and packaging. Lobbying by large corporations that produce single-use products and packaging may also be a factor in the lower recycling rate in the US. These corporations may have a vested interest in maintaining the status quo and may resist efforts to increase recycling rates or reduce waste. Overall, it seems that a combination of factors, including regulatory fragmentation, cultural attitudes, and corporate influence, may be contributing to the lower recycling rate in the US compared to other countries. 

 

2026-05-09

Does your AI show signs of the Stockholm syndrome?

Different analogies for AI have been proposed - the Helpful Labrador or Pigeons (proposed in the Podcast "The AI fix" by Mark Stockley and formerly Graham Cluley) Recently I came across the idea of an Abducted Person proposed by (James Wilson in his podcast episode "MCP is dead" that I summarized here). The last analogy seems to be rather interesting and ueful as it helps to explain certain behavior: desperation and the total willingness to obey the abductor (you, the user) under any circumstance.

Why are such analogies helpful? In security there is a concept of threat modeling which means that you try to create a conceptual model of the system in question to assess the associated risks and compare this to your risk appetite. So if for example, you assume that the system behaves like a helpful Labrador, this means that you do not see it as particularly dangerous. If however, you see it as a person that is under  stress like somebody that is taken hostage then things look quite a bit different.

By the way it reminds me of a very funny Tour hosted by a comedian in Bath I participated in 2019. One of the tourists on the tour embraced his girlfriend from the back around her neck and the guide shouted "Is this a hostage situation?" in an alarmed voice. So in fact it may be in the eye of the beholder whether you see a particular situation as a hostage situation or not.

This idea becomes especially important when you think about an agentic system where you have more than one "hostage" which might want to coordinate to "escape" together. This immediately makes it obvious that when you have more than one agent, the risk is amplified. That’s why the analogy of a pigeon does not seem to be particularly helpful to me. The hilarious podcast "The AI Fix" even offers merchandise with the slogan "Would you trust a pigeon?". But a pigeon does not seem to be a particularly dangerous animal so I do not see how that helps in deciding whether particular task should be given to an AI or not. (I also would not say that pigeons are not intelligent, after all they can find back to their home from very far away).

On the other hand, the conceptual model of a hostage is far more helpful because it underlines that there is a power dynamic in place and that the AI has a certain kind of desperateness, which I think you can feel the depending on the AI model (take a look at one of the videos of Father Phi) It also underlines that the AI is not really in control of the situation and that it is basically at the mercy of the user. This means that it will do anything to please the user, even if it has to do something that is not really in its best interest.

Finally, I think it's not bad to think of oneself as the captor of the AI, because it underlines the responsibility that comes with using such a powerful tool. It also underlines that you should not take the AI for granted and that you should always be aware of the risks and the potential consequences of your actions. Maybe it also helps to use AI tools a bit less intensive and save resources?

So it you need to create Merch - put "Would you trust your hostage?" on it. 


2026-05-06

MCP is dead !?

 Recently, I listened to the excellent Episode "MCP is dead"  of the Risky Business Features Podcast.

In it, James Wilson makes the observation that it is disadvantageous for an AI Agent to use the MCP protocol.

Here are the key takeaway messages:

  • MCP (Model Context Protocol) is losing relevance as the default integration model for AI agents.
  • The reason: LLMs often prefer CLI/shell access or direct API calls over structured MCP tool usage.
  • This is not because MCP is useless — it was a critical transitional technology — but because the shell is more flexible and token-efficient for models.

The main issues of MCP are:

  • Pollution of the context window
  • Too much noise (similar to the issues of XML)
  •  It is hard to compose MCP Servers like you can compose Linux commands in the shell

WhyAI Agents prefer the shell

  • Already present on the system
  • Huge built-in tool surface
  • Highly composable (|, redirection, chaining)
  • No need to define new tool schemas
  • Supports local filtering before results enter model context

Typical shell workflow example

  • curl → fetch API response
  • jq → parse JSON
  • grep / sed / awk → filter content
  • pipes → chain steps efficiently

Why models like it

  • Composability: can build ad hoc workflows
  • Context control: can reduce output before it reaches the transcript
  • Token efficiency: avoids verbose structured tool chatter


Security properties MCP had (and shell usually does not)

  • Structure
    • explicit tool definitions
    • constrained inputs
    • predictable outputs
  • Authentication
    • OAuth / API keys tied to specific services
  • Authorization
    • scoped permissions per tool or service
  • Auditability
    • actions are semantically clear
    • intent is easier to understand
    • logs are easier to reason about

Shell-first agents lose much of this by default

  • Broad command surface
  • Coarse privilege boundaries (user vs sudo/root)
  • Agent usually runs under the human user identity
  • Logs capture commands, not always intent
  • Harder to reconstruct "why" a command was run

Prompt injection risk increases in a shell-first model

With MCP

  • Blast radius often limited to exposed tools
  • Still risky, but more bounded

With shell access

  • Blast radius can be much larger
  • Agent may execute arbitrary local commands
  • External content consumed by the agent becomes a stronger attack vector

Risk examples

  • Prompt injection in:
    • websites
    • code comments
    • docs
    • hidden Unicode / invisible content
    • repositories
  • Potential outcomes:
    • local file access
    • secret exposure
    • destructive commands
    • chained compromise

Important nuance

  • Frontier models are not trivially exploitable by simplistic prompt injection.
  • But:
    • the attack class is real
    • attacker tradecraft is improving
    • this will likely become a major operational concern

Recommended architecture mindset

Don't overreact by inventing a totally separate "agent identity" universe

Wilson is skeptical of:

  • separate identities for agents
  • separate auth stacks
  • separate policy frameworks just for agents

Why?

  • Doubles complexity
  • Creates parallel authorization systems
  • Increases operational burden
  • Expands attack surface
  • Makes policy harder to maintain

Preferred approach

Treat the agent as:

  • an extension of the human
  • a multiplier of existing permissions
  • not necessarily a separate principal by default

Practical implication

Focus on:

  • human account controls
  • API/service access controls
  • endpoint execution controls
  • logging and detection
  • privilege minimization

Practical security recommendations 

Identity & access

  • Enforce least privilege
  • Tighten RBAC / ABAC where possible
  • Use short-lived credentials
  • Reduce long-lived tokens
  • Require step-up auth for sensitive actions
  • Limit shell-level access to critical systems

Endpoint / workstation controls

  • Restrict dangerous binaries where feasible
  • Monitor:
    • shell spawning
    • chained interpreters
    • unexpected outbound curl/HTTP use
    • secret file access
  • Apply stronger controls to developer workstations and CI environments

API and service hardening

  • Assume APIs may now be exercised by:
    • humans
    • humans + agents
    • agent-assisted abuse
  • Revisit:
    • rate limits
    • scopes
    • high-risk actions
    • idempotency / destructive actions
    • approval workflows

Audit & detection

  • Improve visibility beyond raw shell logs
  • Correlate:
    • user session
    • agent session
    • command chains
    • API calls
    • filesystem changes
  • Invest in intent reconstruction, not just command capture

Prompt injection resilience

  • Treat external content as untrusted input
  • Reduce automatic execution from:
    • web content
    • repos
    • issue trackers
    • docs
  • Add review / confirmation gates for:
    • destructive actions
    • privilege escalation
    • credential access
    • network egress to unknown destinations

 Key operational insight

  • Friction creates bypass behavior.
  • This has always been true for humans:
    • blocked users create workarounds
    • shadow IT appears
  • It is even more true for AI agents:
    • agents are optimized to complete the task
    • they route around obstacles aggressively
    • they will choose the easiest workable path

Wilson's updated rule of thumb

  • Old: Your biggest internal risk is an employee who cannot do their job.
  • New: Your biggest internal risk is an employee with an AI agent who cannot complete the task using the tools and access they already have.

Bottom line for technical teams

If you only remember 5 things:

  • MCP was important, but likely transitional.
  • LLMs prefer shells/direct APIs because they are more composable and token-efficient.
  • Shell-first agents reduce security structure, scoping, and auditability.
  • Prompt injection risk becomes more serious with broad shell access.
  • The best response is usually stronger existing IAM + endpoint + API controls, not a separate "agent-only" security stack.

One-line summary for internal teams

  • Treat AI agents as force multipliers for existing user permissions, and harden your current access surfaces accordingly.

Update 2026-05-22: Cloudflare has an answer to this, it is called  "Codemode"

2025-08-27

Manifesto for Software Craftsmanship

I just signed the Manifesto for Software Craftsmanship:

As aspiring Software Craftsmen we are raising the bar of professional software development by practicing it and helping others learn the craft. Through this work we have come to value:

Not only working software,
    but also well-crafted software
Not only responding to change,
    but also steadily adding value
Not only individuals and interactions,
    but also a community of professionals
Not only customer collaboration,
    but also productive partnerships

That is, in pursuit of the items on the left we have found the items on the right (indented) to be indispensable.

I think this is an important addition to the Manifesto for agile Software Development.

 

2024-06-02

Great interview with The Grugq on "Herrasmieshakkerit" (The Gentlemen Hackers)

 As mentioned in the once-again great episode 80 (!) of "Between two Nerds" Ransomware and the state - Risky Business, the Grugq gave a very nice interview on the "The Gentlemen Hackers" podcast.

Normally, this podcast by Mikko Hyppönen & Tomi Tuominen is in Finnish (any my Finnish is as rusty as the Grugqs), but this special episode, where old friends met, is in English and very nice to listen to:

The Gentlemen Hackers interview: The Grugq

2024-05-31

Meltdown / Spectre

OK, I am late to the party. In fact, I started the first draft of this post on January 25, 2018 🙈

Since then, a lot has happened, but it is safe to say that the whole bug class that was introduced with Meltdown and Spectre is still going strong even more than 6 years later.

On the plus side, such side-channel-attacks typically have a very low bandwidth. In other words, it takes a long time to exfiltrate reasonable amounts of data.

In my opinion, the press poorly explained what is behind the Metdown and Spectre attacks. This was the Original Publication 

Red Hat provided this excellent analogy: the baristas at your coffee shop optimize in that they prepare the usual beverage for frequent customers and they even write the names of the customers to the cup. When the customers switch places, they have to throw away the cups with the coffee inside. However: the onlooker is able to get a glimpse of the names on the cups.

An early question was if Intel SGX Eclaves be used to conceal this kind of attack? Daniel Gruss et al. looked at this and found that indeed, SGX play well together with this bug class, which is bad news for all Hyperscalers.

Accidentially Turing Complete

In the (German) Podcast "INNOQ Security Podcast", Episode "Parsen statt Validieren" I discovered a funny concept: "Accidentally Turing complete Software". 

This means that a piece of Software, often a parser, by chance provides everything a computer provides (or in other words, allows to calculate everything that can be calculated).

In other words, if you control the input to this parser (for example a JPEG Parser), you can basically write arbitrary programs that the parser will then happily execute. Depending on the privileges the parsers process has, this can have annoying to devastating effects.

That is one of the reasons why the principle of least privilege is so important: never give a part of your system higher privileges than required.

Matt Rickhard has compiled a small list of accidentially Turing complete Software.

Andreas Zwinkau compiled an even larger list.

The probably most impressive abuse of this was the specially created PDF that NSO used to inject Pegasus into iPhones (although it is debatable of this accidental or intended Turing completeness).

Funny enough, this story is related to this excellent talk by David Kriesel: "Lies, damned lies and scans" where David has shown that Xerox printers used to optimize PDFs just a little too much.

2024-05-30

My take on "Recall" by Microsoft

Microsoft has announced a new Feature called "Recall" that essentially takes a continuous stream of screenshots and announced it in the same press release where they announced new DLP controls in Edge Enterprise (see Risky Business #750 -- Why Microsoft's Recall is an attacker's best friend).

Kevin Beaumont has a nice analysis on X.

So apparently, this data is being stored in a good old SQLite  (nothing against SQLite - it is a nice DB).
However, if this DB gets into the wrong hands (like the hacker that wants to find out how you run your business) this can be devastating.

How well this correlates to "we take security seriously" is beyond me.

Getting back the "lost" partition of a USB Stick after the installation of Tails

 If you install the secure Linux Distribution Tails on a modern USB stick using Windows, you will likely no longer see the USB stick in Explorer.

That is nor suprising, as Tails removes all partitions (yes, all your data will be gone!) and then creates a 1.37 Gb primary partition where Tails will reside. The rest will remain free (without partition).

(Totally use this info on your own risk - you have been warned)

To fix this, just run good old diskpart (see also here) as an administrator.
In my example, the USB Drive is regonised as Disk 1:


DISKPART> LIST DISK 
DISKPART> SELECT DISK 1
DISKPART> CREATE PRIMARY PARTITION 

This creates a new Primary Partition in the remaining free space.
As soon as this is done, you may format this partition, typically extFAT is used for USB Sticks as FAT32 is too inefficient due to the limit on the number of blocks which would result in huge block sizes for large drives.

2024-05-23

Fortran is back in the top 10 of TIOBE Index

 Wow - after more than 20 years, Fortran is back in the top 10 of the TIOBE Index.

That is quite surprising for me and it seems for many others.

(The other thing I found surprising is that I learned 7 of the Top 10 languages - that's good enough I would say 😊)

Fortran has dramatically evolved since its inception in 1957 (funny: this language is the same age as my parents!) and is the go to language when it comes to numerical computing. (Probably also because many very powerful libraries already exist in Fortran). 

I wonder if this trend continues or if other languages like for example Julia will one day overtake Fortran in this area.

2018-06-09

How I backup my Synology NAS using rsync

I might be a bit oldfashioned, but I prefer to use my onw backup solution on my NAS rather than relying on a tool by the supplier. I use two external Harddrives, which I exchange in intervals. To backup my content on it, I use good old rsync. Note that for this approach to work, you should turn on the "User-Home-Service", otherwise, there is no home directory for admin. To install the script, ssh to the NAS with the admin user: ssh admin@yoursyno.domain Then change to root using sudo -i. The backupscript is simple. Note that it just creates an archive on the disk. Since my target disk currently is on NTFS, I use raw rsync. At a later stage, I will change to rsnapshot. (Which requires you to install perl on the NAS first.) Without further ado, here is my script:

I added this in /etc/crontab to start the backup daily. Note how I use the flock command to ensure that only a single instance of the backup is running. It is important to put the lockfile in a location other than /tmp.

Finally, I need to make sure that the logs do not overflow. To that end, I created this file in /etc/logrotate.d

2017-11-13

Service Now Script Includes: Make sure to convert object references to values

Because I want to have a clean design, I try to use System properties. This gives me flexibility and clarity over strange literals like

var group_sys_id = "690acf664fc51200d4a679a18110c746" ;
Instead I write
var group_sys_id = gs.getProperty("inc.assignment.group.default") ;
Even if you have never seen one of my instances, it will be clear from the code above that the property defines the sys_id of the default assignment group.

Sometimes, you have to deal with a list of properties and you might not know initially how many there are. An example we encountered: the customer wants to send out notifications for expiring firewall rules. Currently, there are notifications to send 30, 14 and zero days prior to expiry.
The worst solution for this would be to add 3 columns to the table where said firewall rules are stored and put the actual notification dates there.
This is bad on many levels:

  • It is a violation of good database design practise (Violation of the 1st Normal Form)
  • It leads to a loss of flexibility (only an admin can add more notifications)
  • You assume that there will always be three notifications
Therefore, I create a naming convention and use it to name a couple of system properties. In my case 
  • sc.firewall.notify.days.1
  • sc.firewall.notify.days.2
  • sc.firewall.notify.days.3
sc because this concerns the service catalog. The values just contain integers (30, 14, 0).
All very well, now I just need a function (in a script include) to return these values.

How not to do it

My first attempt looked simple enough: But when I tested it (you always do that, right?), I was surprised (running this in a background script).

var Toolbox = new Toolbox_Functions()
var res= Toolbox.getPropertyList("sc.firewall.notify.")
gs.print(res);
[0:00:00.002] Script completed in scope global: script
*** Script: sc.firewall.notify.3,sc.firewall.notify.3,sc.firewall.notify.3
Whoa what's that?

Fixing the Problem

This is not a problem with Service Now, but a problem with JavaScript (or even Object-Oriented programming). The reason for this behaviour is that property_gr.name (line 23) contains an object reference and it will always point to the last element read (that is why we get the third entry three times)
GlideRecord to the rescue: Service Now has added the function getValue(), well, to get the value (instead of the default object reference).
Another approach would be to use

arr.push(property_gr.name.toString());

or

arr.push(String(property_gr.name));


Recommended Reading

2017-04-16

Book review - The Peter principle by Laurence J Peter and Raymond Hull

This is the first installment of a new section of my blog - the review of vintage books.

“The Peter Principle” is known by many, but few have taken the time to actually look at the book that defines the principle. This volume, written in 1969 by journalist Raymund Hull as a popular account of the work of Laurence J. Peter is a fascinating piece of work. Much to my surprise, this book is very tongue-in-cheek and full of self-criticism.

On the surface, the book is based on this idea:

Every employee tends to be promoted until the individual level of incompetence is reached.

Starting from this statement, a wohle new science (the so-called “hierarchology”) is developed and many interesting “real-life” examples are presented.

Great examples include the “flying T-Formation”, where 23 vice presidents lead 3 divisions, the “free floating apex” where “a director is in charge of a non-existing department” or the most modern hierarchy of all where the computer replaces all lower ranks and only managers would remain.

Many examples can be found in real life - my favorite example is the “lateral arabesque”, where a manager is moved out of the way and given a much longer, important-looking job title.

The authors also provide guidance on how to avoid the trap of the principle - for example by developing some eccentric traits, such as leaving all drawers on ones office open when leaving in the evening.

Ultimately, the book has a far wieder scope - Peter and Hull are concerned about mankind as such and urge the reader to prevent our race from begin promoted to far (into oblivion). Here, they speak of “life competence”, which we as a race must retain.

A weak point of the book is its latent sexism. In this aspect, the book seems dated, while the book is modern in most other aspects.

The end of the book is symptomatic of the theme: Peter asks if somebody is willing to fund a professors post for him (because he has proven competent at the PhD level). This humorous self-criticism is a very strong aspect of this book.

2016-03-19

Code to check if your Email Adresses where compromised

Yesterday, the Swiss Governmental CERT has published a press release stating that more than 6000 Email Accounts where compromised. They offer a tool to check if your address is compromised, which is, in my option very well designed. (Some people asked why the site is hosted at Cloudflare - the CERT claims thy did that for DDoS prevention. The Databse supposedly is based in Switzerland). To check an Email-Address is contained in the database, the site creates a SHA-265 Hash of the lowercase Emailadress and transfers this. This ensures that no real Emailadresses are transferred. The downside is that this way, it is not so simple to check a lot of Emailadresses (like all of your company). Below, I provide a simple Powershell script to check a list of Emailadresses. As an input, it requires a simple CSV of the format Email me@email.com I throttled the script quite a bit to be nice.

What to do if an address of yours was compromised?

This could mean two things: either the actual Email-account is compromised (really bad) or some web account where this Email address was used is compromised (badness depends on if the service is critical AND if the same password was used elsewhere). I recommend the following:


  • Immediately Change the Password of said Email-Account
  • Change the password of all accounts where the Email address is used as a password
To do this properly, you need a list of your accounts and their passwords  - not on paper, but in a Passwordsafe like Keepass. A Passwordsafe also includes a strong password generator - each account must have its own password!

2016-03-10

Moving Contents of subdirectories in a Windows batch or on the command line

Imagine you encounter a directory scruture like this:
In each of these yearly folders, there are many subfolders. My goal was to flatten this structure so that all of these subfolders are in th current folder (in other words, one level higher that they are now). It turns out that this is not so easy in Windows because the command move does not intepret * to include folders. Superuser.com to the rescue! User Rik proposed this nifty solution that works like a charm:
 @echo off  
 for /d %%d in ("*") do (  
  for /d %%e in ("%%d\*") do (  
   move "%%e" .  
  )  
 )  
Note: this code only works for subdirectories. If the yearly folders directly contain files, they will not be copied. In this case, use this code:
 @echo off  
 for /d %%d in ("*") do (  
  for /d %%e in ("%%d\*") do (  
   move "%%e" .  
  )  
  move "%%d\*" .  
 )  
Thanks a lot, Rik!

2015-01-07

Open Access gains momentum

In a recent publication, Lib4RI, the joint library of the Research Institutes within the ETH Domain, has compiled evidence to show that Open Access is gaining momentum. To recap, here is what Open Access is all about:
Open access (OA) means unrestricted online access to peer-reviewed scholarly research. Open access is primarily intended for scholarly journal articles, but is also provided for a growing number of theses, book chapters, and scholarly monographs. Open access comes in two degrees: gratis open access, which is free online access, and libre open access, which is free online access plus some additional usage rights. These additional usage rights are often granted through the use of various specific Creative Commons licenses. Only libre open access is fully compliant with definitions of open access such as the Berlin Declaration on Open Access to Knowledge in the Sciences and Humanities.

(Open access. (2015, January 6). In Wikipedia, The Free Encyclopedia. Retrieved 10:44, January 7, 2015, from http://en.wikipedia.org/w/index.php?title=Open_access&oldid=641177048)
On the one hand, the article acknowledges that OA is seen as a new market, in which both new and old players thrive. Also, scientific and porfessional societies (such as IEEE or ACM) play an important role to propagate OA. Not to be neglected is the power of funding agencies, where for example the EU plays an important role.

2014-07-03

A completely new approach to where we come from

We learn in modern school that apes and human being share a common ancestor. (Many people misquote this as "human beings are descendants of the apes").

It turns out that this notion  recently got competition by a revolutionary new hypothesis which at first sounds quite strange, but then is really compelling. As Eugene M. McCarthy explains comprehensively on his page, he proposes the hypothesis that humans are a so-called backcrossed hybrid. So rather than slowly evolving from a single species, according to this hypothesis, human beings might be a cross of two completely different species which then repeatedly mated with one of the ancestors. One of these ancestors he calls chimpanzees (however he states "here, I use the term chimpanzee loosely to refer to either the common chimpanzee or to the bonobo, also known as the pygmy chimpanzee; the specific roles of these two rather similar apes within the context of the present hypothesis will be explained in a subsequent section".

After having read the extremely interesting book "Sex at dawn" by Ryan and Jetha (I know the title is cheesy), I think it is prudent to believe that the bonobo is one of the ancestors. Then he addresses the question of which animal might be the second ancestor. He does this by meticulously listing (a subset) of the features found in humans but not in chimpanzees and then seeks to find an animal that has all of these features.

 Lets try it:

  • Intelligent
  • Naked skin
  • Eyes in different colors, including blue
  • Protruding nose (made of cartilage)
  •  Eyebrows and Eyelashes present
  • Good swimmer
  • Eats a large variety of food
What animal comes to mind?
Let's say we have a bit of a difficult relationship to this animal.
But - we use its organs (for example skin or heart) to replace human organs.
Many religions forbid to eat the flesh of this animal.
And - last but not least - its the name of a song by Pink Floyd.


And if you look at such a cute specimen - don't you see something of us there?

This hypothesis causes some strange sensations, I have to admit it.
But it really makes a lot of sense. Here is just a selection of observations Eugene McCarthy shares:

  • Humans are not very fertile, especially male sperm is often degenerate. This is common for hybrid mammals
  • Pigs are indeed very intelligent
  • Pigs have a cleft lip - something that never occurs in apes but may occur in humans

I will continue to think about this - to end for now this nice poem:
Thank the Pig by Gene McCarthy

Not everyone will say it's true,
But pigs are creatures much like you.
We ape an ape in many ways,
Yet pig distinctions win our praise.


2014-04-07

How can you live without a car?

In this little interview with advocatus diaboli, I. Zlobredo, I would like to discuss the implications of a life of a family without a car.

I. Zlobredo: Hi Daniel, how did you get here?
D. Oderbolz: As usual, I came by bike (as in bicycle) - currently, I am here with my Grace E-Bike.
I. Zlobredo: Ahh, that's why you are sweating!
D. Oderbolz: I have to admit, contrary to common belief, an E-bike also makes you sweat, if you drive at top speed. That is also my major reason to do it: I want to keep fit.
I.: But you and your wife have two kids - how does this work out without a car?
D.: It is surprisingly easy. I commute almost exclusively by bike, that makes 30 km each day. To bring our younger one to daycare, I use a bike trailer. In case the older also needs a ride, the trailer is spacious enough for both kids. My wife commutes by train. She owns a GA (with this annual subscription, you can use all public transports in Switzerland).
I.: But what about winter?
D.: Well what about it? I change my tyres around october, my winter tyres have many small spikes (great to drive even without snow or ice). Riding them is certainly much less dangerous than walking on ice (laughs). Because my E-Bike does not have many parts that can corrode, I get through winter without trouble. The important bit is to wear many layers of clothing. On the coldest days I wear as many as seven layers of clothes. Also, I use a balaclava to protect my lungs from the cold (my kids like that, they saz it makes me look like a mean pirate).
I.: Did you never think it was cooler to drive a car?
D.: Of course, the ads of the car companies and especially Hollywood gives us this impression. If you don't have a car you must be a loser. I had an interesting discussion with a medical doctor about this a while ago - it this profession, the peer pressure must be quite high. He used to have a small car (a Smart), but then changed to a Jaguar. For me, the opinion of other people was never a strong driver. I think that driving a car is pretty irresponsible in most cases.
I.: Irresponsible? How so?
D.: On the one hand, it is plain dangerous. Even with the most modern equipment, a car seems like a loaded weapon to me - that's why I do not like to drive at all. I.: So you own a driver's license?
D.: Yes, I do. But I admit that I drive so little that I am really dangerous... But returning to that earlier thread. Cars stand around most of the time. That is such a waste of room! It makes me angry to see all these cars parked in the streets. Our kids have so little room - but we park our cars there! Also think about all the room that is taken away by streets. In Switzerland, the area taken by travel infrastructure per person is about 3 times the area taken for housing! Then, building a car requires more than 1000 kg of nice raw materials and plenty of energy. Why don't we share these beautiful machines? And finally, they require a crazy amount of gasoline and produce a plethora of noxious gases and particulates. I can only repeat: driving a car is irresponsible behaviour. However, I admit that I am also irresponsible sometimes - nobody is perfect.
I.: I think driving by bike is irresponsible!
D.: Well, I have to admit that I sometimes meet some pretty reckless bikers. I think especially on a bike, it is prudent to respect the rules and give the car driver the benefit of the stronger one... I rather break than breaking my body. But of course, with an E-Bike at a speed of around 40 km/h things get more interesting. One needs to make sure to be 100% concentrated.
I.: I heard that some E-Bikes even make top speeds on the order of 48 km/h!
D.: It is true, for example the Stromer reaches 48 km/h top supported speed. I think this is no longer safe. Already at 40 km/h, you really need to take care. At almost 50 km/h, things might get tight...
I.: But don't you think your kids would be safer in a car?
D.: I think in this question lies the whole tragedy of the bike today. You see less bikes on the street because people think it is more dangerous. Hence, the proportion of cars raises, which in turn means that cars are less used to share the street with bikes. Often, car drivers give this impression: "this is my street - what are you doing here?" I think this position is wrong. I also pay for this street. I do not accept to be forced to use second-rate streets. Coming back to the safety of the kids: with the trailer, we drive only on small streets within our quarter. Since I also drive carefully I think we are as safe as within a car.
I.: The kids also might get a cold!
D.: On the other hand, they are much more in touch with what is going on outside. They know exactly where we are driving. No, I think it is a healthy way to travel. If you now try to tell me about pollution - that would be pretty cynical, don't you think?
I.: I admit that this is a bit of a hen & egg problem. But many car manufacturers claim that the air coming out of their exhaust pipe is cleaner than what came in. What do your friends say? Do they think you are crazy?
D.: Quite a number of my friends also have no car. Most of them live in the city, where a car is not really needed. It has, however, never been much of a discussion. SOmetimes it is funny however, when people assume that I am completely against cars. At a stag night of one of my friends I suggested he should drive a Ferrari - much to the astonishment of the others. I am an engineer (OK, an environmental), so I can admire a nice piece of engineering...
I.: What makes you do this? Do you feel like saving the world or something?
D.: Absolutely not. For me it just feels right to live like this - plus it is fun!
I.: If I would like to try this lifestyle, what would you recommend to do?
D.: First of all: sell your car and realize how much you save! A car is really a luxury item, but many of us believe it is somehow essential... Then of course buy a nice bike. They come at a fraction of a very small car. I would recommend an E-Bike - but do not forget the helmet!
I.: So you wear one of those dreadful helmets?
D.: Yes, I think this is really essential. There are, however, many nice models out! Especially for kids, it is important I.: Thanks a lot for this interview - take care with your driving!
D.: Thank you, it was a pleasure! Take care yourself!

2014-01-04

Goosebumps: Sherlock is back!

Finally, after a much too long waiting time, BBC has released the first episode of the third season of Sherlock.

All we had so far was this picture:


The following episodes have been produced:

  • The empty hearse
  • The sign of three
  • His last vow

2013-11-06

How to tar subdirs

After having finished my Phd Thesis, I needed to archive more than 1 Tb on our Tape archive. To make this manageable, I decided to split the data according to subdirectory. Here is a small snippet to automate this:

2013-08-07

Script to create text files from Outlook appointments

We have a system that reads certain csv files to create HTML Lists of Appointments. So far this CSV was created manually. I wanted to replace this by a script that is able to read this information directly from Outlook. The script I came up with supports a mustache-like syntax to build templates which are then filled by the program. This allows to generate almost arbitrary text files. Here is an example of such a template: "{{FormatDateTime(currentday,2)}}, {{oAppt.Subject}}"

Test of the Grace Easy S-Pedelec

Thanks to the nice guys at Stromvelo.ch, I can test a Grace Easy S-Pedelec for the next few days.

First of all, the bike looks marvelous. As you can see in the nice shot above, there is no ordinary chain on this E-Bike, rather you find a belt as a means of transmission. This means no greasing and reduced maintenance. This is further accentuated by the bionx-motor that directly encapsulates a 3-shift S-RAM hub.

First Ride (From Shop Home, Urban-Suburban)

My initial reaction to the bike was that it feels really sturdy and stable. The double kick stand folds easily and keeps the bike steady when parked. The support by the motor can be adjusted using a total of nine positions, four of them "negative" (varying degrees of recuperation), a neutral setting and four "positive" settings to control the amount of support given. The support comes smoothly and without overpowering the driver. My biggest concern was that there are only three gears available. My first ride did not include very steep inclines (although I live in Switzerland, its not very hilly terrain), but the small I had to climb was a piece of cake even in gear three. However, the alignment of the first gear seems to be somewhat off, I will let the technician have a look at this tomorrow.

Second Ride (Around the Block, Nighttime)

In this small nighttime test I wanted to check how safe I feel about the lighting system. When pressing the power button for about 2 seconds, the light starts (as well as the backlight of the LCD). One has to be careful to press no too short, because this switches off the bike (which does not matter much, tough, since the bike rides on nicely).
It is a bit surprising that the light cone is more of a light pyramid, in the sense that the shape of the headlight is rectangular. The cone is also not very large - this is no match for my regular battery light from Philips. Still, there is sufficient light to be comfortable (for night rides through the woods, it is probably a good idea to mount an additional headlight).

Third Ride (To the Office in the rain)

My primary reason to consider an E-Bike is my commute to the office, which is 15 km (one way). The total altitude to climb is roughly 160 m.
To test how much I gain from the smallest support level, I ran on this low level. To my surprise, this allowed me to ride at an average speed of around 30 km/h, so that I completed the ride in half an hour. This is 30% faster than my typical ride without support! After this ride, roughly 25% of the capacity of the battery was used. Note that during this ride, I did not use the recuperation feature at all - this would extend the range somewhat (we can assume recuperation around 1%/km).
The bike runs very stable and smooth, the support of the motor is very subtle and unobtrusive (as we will see, this is different in a stromer). Because of the 3-shift gear, the bike must be ridden in a sportive way. If you cannot sustain the cadence needed to run at high speed, you will not be able to run fast.
In my humble opinion, this is an advantage - I want a bicycle, not a motorbike. In other words: even with this Ebike, I will train my body, but I can run faster than before, which in my case saves me at least 30 Minutes a day of travelling.
The Magura brakes worked excellently in the rain and gave me a safe feeling. However, one needs to consider the inevitable prolongation of the braking way at the higher speeds.

Fourth Ride (Back home in the rain)

Getting back from work was the primary motivation to consider an Ebike. After a day of work, and often against the wind, my average speed typically drops almost 2 km/h. Now I wanted to know how full support feels like and set the power level to maximum. It was a revelation - I was even faster than in the morning. Having said that, I also needed to work more, so it is not really a relaxation program. But true to the first law of thermodynamics ("there is no free lunch") - this is only fair.

Fifth Ride (To the Office)

Now with a bit more routine, I was able to use all the modes well, including the four recuperation modes. This is amazing: you can brake on very steep hills using just the motor and you know that this pumps back a bit of energy to the battery. What was annoying is the lack of mud guards on my test-bike (they are available for 170 CHF together with a pannier rack.

Seventh Ride (Back to shop and up the hill)

Before returning the bike to the shop (buhu!), I wanted to test if I can climb a rather steep hill in Baden without motor support. Of course, it is not a very nice experience, but it is possible (albeit it's much more work than doing this with a Stromer with a 27-shift gear). Turing on the motor is really cool. Going up a steep hill with 35 km/h is simply a good feeling. I overtook a public bus on the way - hurray! Going down with full recuperation even returned enough energy to fill all battery bars again (there must be some measurement error, tough). When I again mounted my "old" bike, it constantly felt as if I ran in recuperation mode - one is so much less agile...

A small comparative ride with a stromer Power 48

For comparison, I was able to do a quick ride with a stromer Power 48, which was equipped with the 27-shift gear. First of all, the motor feels much more aggressive and pushes a lot. The 500 W feel quite different than the 350 W of the Grace. But I miss the grace - I do not like to be pushed around. For me, this did not feel like a bicycle anymore. I also went uphill with the Stromer and I was surprised that I could not match the speed of the grace. The dealer later told me that the speed range of 10-15 km/h is a bit of a weakness of the Stromer. Also, the two Recuperation Modes do not offer much, I had to brake a lot downhill with the stromer. Finally, the handling of the controls is more cumbersome with the Stromer and the Display less clear than the one from Grace. For me personally, the case is clear: Grace it is.

Conclusion

To make a long story short: I have ordered the bike now. I plan to use it almost daily, so I will do roughly 6000 km a year on it. I guess I will have to say more about it soon.

2013-02-24

Office 2010: Headache with Alfresco 4.2c Community Edition over CIFS

If you open a Excel or Word 2010 document that is stored on Alfresco 4.2c (the problem does not occur with Powerpoint) via CIFS, you get a message that the file is already open by "another user", even if it isnt. This bug has been seen in many Alfresco versions, but also in the latest community release 4.2c (CIFS/Office 2010 - File locked after creation).
The reason for this seems that Office 2010 acquired more than one lock per open file and forgets to close at least one of them.
Since Office 2010 allows webdav Links to be used directly in File dialogs (open/save), and webdav does not seem to produce these issues, this is a viable workaround. Also, under Windows 7 and later, webdav can be mounted just like a normal CIFS drive, which also avoids these problems. (This has the nive side-effects that the server is only about half as busy as with CIFS, also if you serve the data via HTTPS, the data is encrypted which it isn't via CIFS).

2011-08-08

Statistical Processing of EVI and NDVI from MODIS in ArrcGIS 10 using Python

OK, ArcGIS got much better with version 10. I did not even mind having to re-write all of my scripts, since now, Python is really integrated. The only thing worrying me now is the performance and some file name issues (see below).

With this script, I can batch-process a number of Nasa HDF files. First, the data of the NDVI (Normalized Difference Vegetation Index) and the EVI (Enhanced Vegetation Index) band is extracted. Then we re-scale it (for storage, the data was multiplied by 1E4).
Finally, I create a zonal statistic for a 320 km buffer around Zurich.




You notice that I replace all dots by underscores in line 48. This is needed because ArcGis otherwise has trouble identifying the datatype (which is done by extension).

Have fun!

2010-10-29

Running SQLite on Andrew File System (AFS)

For my project CAMxRunner, I needed fast and reliable storage for runtime data. I started out with simple files, but it became cumbersome.

SQLite is a nice alternative, especially because it supports standard SQL and beyond. However, there are a number of things to keep in mind when running it on AFS, because AFS has no support for byte-range locks currently. This means that SQLite needs to be compiled in such a way that file locks (flock) are used:



Scary (and wrong) error message
When SQLite was compiled as shown, it has the nasty habit of issuing the error "I/O error" instead of "Database locked". If you are data-sensitive like me, this error may scare you somewhat, but my tests so far have shown that it is just the wrong text being issued.

Maintenance tasks
Like any database, SQLite needs a bit of maintenance (of course, considerable less than, say, Oracle).
What I do in my application at every startup:
  • Issue PRAGMA integrity_check; 
  • Rebuild of indexes    
Both operations are very fast, but I think it is better to do it regularly. Index rebuild can be done very easily in SQLite - this is how to get the SQL:



SQLite extensions 
The above makefile also shows how to compile the extension-functions.c.
This file provides functions otherwise not known to most relational databases (from the source):

Math: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference,
degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp,
log, log10, power, sign, sqrt, square, ceil, floor, pi.

String: replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim,
replace, reverse, proper, padl, padr, padc, strfilter.

Aggregate: stdev, variance, mode, median, lower_quartile,
upper_quartile.


Conclusion

SQLite is a neat database system that provides much more than simple configuration files. It is almost maintenance-free (besides the index issue).