Kchibo KK-9803 old & new version

Kchibo KK9803 is known to be an unexpectedly good radio. However, now here is a new DSP ( kt0936 ) version, that is known to be as shitty as shit.

Here are old version an a new one. Almost impossible to guess which is which. However, the old version has a variable capacitor tuning, the new one has a resitor tuning -- and here they are (top photo: top is old; bottom photo: top is new):

Even more, new version has POWER led, but the old version has TUNE led. Be warned! PS. Unclear why DSP radio is such a shit -- it even has a quartz there.

Basic HTTP auth with lighttpd, mod_authn_dbi and stored PLAIN PASSWORDS

First, if you can avoid storing PLAIN PASSWORDS - avoid them and do not read this at all!

Next,

auth.backend = "dbi"
auth.backend.dbi += (
  "sql" => "select md5(concat(username,':MyRealm:',password)) where username = '?'" ,
  "dbtype" => "mysql",
  "dbname" => "mymydb",
  "username" => "mymylogin",
  "password" => "mymypassword"
)
auth.require = (
  "/" => 
  (
   "method" => "basic",
   "realm" => "MyRealm", # The same realm as in sql statement!
   "require" => "valid-user"
  )
)

Generally speaking, I do not understand the authors of lighttpd (which is my web-server of choice for around 10 years) in this exact logic and their love of Digest auth (I prefer Basic+https).
This works at least for lighttpd 1.4.65
Crossposted to linkedin

Ikea Tradfri hub loosing connectivity

Ikea Tradfri Zigbee controllers are known sometimes to get offline, a lot of people over inet complaining on that. In case it is rebooted, it is working. The less known thing is the network disconnect also restores availability. However, disabling/enabling port on switch does not work, because some of the devices just stops transmission over ethernet port. The thing that helps is speed changing to 10mbps and back! I have my Ikea Tradfri hubs running for several months. The server pings them and if it loses connectivity, I just change the speed of the ethernet ports -- and viola! - my Tradfri hub is back online. The other problem is when devices goes offline, I have no solution -- and I do not even know how to detect that via COAPS....