Category Archives: Uncategorized

Uncategorized

Extracting/converting old chats from Signal/ICQ/google

ICQ

For ICQ i only could find one that worked for me.
Search for the below file on the internet

IcqHR 1.8f (http://soft.softoogle.com/ap/icqhr-get-4581.shtml)

This will convert XXXXXmsg.dat to a html file.

SIGNAL

I’ve got signal on my linux workstation, so my encryption key lives in
~/.config/Signal/config.json

Install sqlcipher from (https://github.com/sqlcipher/sqlcipher)

And use below script (change paths/keys accordingly)

#!/bin/bash
#set -x
# Get your key from
#cat ~/.config/Signal/config.json
SIGNAL_KEY=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

/Projects/sqlcipher/sqlcipher -list -noheader /home/${USER}/.config/Signal/sql/db.sqlite "PRAGMA key = \"x'"${SIGNAL_KEY}"'\";select json from messages;" > /tmp/clear_text_msgs;
cd /tmp 
tail -n +2 clear_text_msgs > without_ok
sed '$!s/$/,/' without_ok > with_commas
sed '1 s/^/[\n/' with_commas > with_leading_bracket
echo "]" >> with_leading_bracket
rm without_ok
rm with_commas
mv with_leading_bracket valid.json
cp valid.json /home/%{USER}/signal.$(date +%Y%m%d)
cd -

Google Chat/Talk/Hangouts

Just search for google takeout!

After that convert Hangouts.json to text using
https://github.com/baldybeardedguy/hangouts-json-parser/blob/master/Hangouts_json.py

Uncategorized

Where have we been map

Generated a world map where we’ve been … biggest red part .. seen the least of it 🙂
Vacation or work
A small part of the US, and a small corner from the westcoast of Canada.

Countries/places on our todo list:

  • Mongolia
  • Japan
  • Cuba
  • Greece
  • …
  • …
  • America : Coline
  • Austria : Coline, Monique
  • Belgium : Monique, Coline
  • Bolivia : Coline, Arja
  • Cambodia : Coline, Monique
  • Canada : Monique, Coline
  • Canary islands : Coline
  • Czechia : Coline, Monique
  • Denmark : Coline
  • Egypt : Monique, Coline
  • England : Monique, Coline
  • France : Monique, Coline
  • Germany : Monique, Coline
  • Hungary : Monique, Coline
  • Iceland : Arja, Coline, Monique
  • Ireland : Coline, Monique
  • Italy : Monique, Coline
  • Laos : Monique, Coline
  • Malta : Coline
  • New Zealand: Coline
  • Peru : Arja, Coline
  • Romenia : Monique, Coline
  • Scotland : Monique, Coline (Many many times)
  • Spain : Coline
  • Sweden : Coline
  • Switzerland : Coline, Monique
  • Vietnam : Coline, Monique
Uncategorized

My computer Lab

Our servers came in! (20200612)

Bought some large servers with Vincent.
3 ProLiant ML350 G6 with loads of memory and cores.
My 2 nodes are running Ovirt Virtualisation, connected to a qnap iscsi host using 10gbps SFPs. Vincents server is running Proxmox.

Uncategorized

Domoticz age checker

A script to check the age of sensors.
Sometimes you don’t have a good 433Mhz connection.
Or the battery has died of your sensor.

This script will warn you.

sensoragescript.sh (for cron)

#!/bin/bash
#Call as follows
#sensoragescript.sh <ipdomoticz> <idx-of-sensor> <age-to-test-in-seconds>

now=$(date +%s)
lastupdate=$(curl -s -i -H "Accept: application/json" "http://$1:8080/json.htm?type=devices&rid=$2" |  grep LastUpdate | cut -f4 -d\" )
#echo $lastupdate
seen=$(date -d "$lastupdate" +%s)
#echo $seen
#echo "$(( $now - $seen))"
difftime="$(( $now - $seen))"
if [ $difftime -gt $3 ] ; then
  echo "WARN : too old - $difftime seconds"
  exit 1
else
  echo "OK : $difftime seconds"
  exit 0
fi

Outputs:

./new.sh 192.168.1.1 123 60
OK : 22 seconds

./new.sh 192.168.1.1 123 60
WARN : too old - 69 seconds

check_mk / icinga check

#!/bin/bash
IPDOMO=192.168.1.1
IDX=123
agewarn=300
now=$(date +%s)
lastupdate=$(curl -s -i -H "Accept: application/json" "http://$IPDOMO:8080/json.htm?type=devices&rid=$IDX" |  grep LastUpdate | cut -f4 -d\" )
seen=$(date -d "$lastupdate" +%s)
difftime="$(( $now - $seen))"
if [ $difftime -gt $agewarn ] ; then
  echo "1 \"WARN - Age check Fridge\" realage=$difftime|age=$agewarn Age of fridge"
  exit 1
else
  echo "0 \"OK - Age check Fridge\" realage=$difftime|age=$agewarn Age of fridge"
  exit 0
fi
Uncategorized

Fireworks disaster Enschede

I lived in Enschede at that moment.

A book about the disaster

It was a beautiful day in May, and a lot of people were outside enjoying themselves.

Monique was working in the garden, and i was sitting in the living room.

We heard some commotion and saw the smoke.
Some people said that the Chinese restaurant in that neighbourhood (containing illegal fireworks) was burning.

We heard a big explosion and Monique was blown off her feet, and sat down in the garden.

I saw the large livingroom window bulging to the inside and moving outside again. (This had loosen the mortar around the window)

When seeing the now black smoke, we went inside, to the opposite site of our home, and turned on the news/checked websites.

We were lucky that there was a large factory between us and the blast (Polaroid factory)

Large pieces of cement where found 100m further than our house was.

Below some of my own media, for a better understanding of the destruction and aftermath of the disaster check the divers websites.

A scary time.

Uncategorized

Discman hack

Leave a comment

I bought a Discman, the cheapest in the series (Don´t know the brand any more)

So it didn´t had all the functions of his bigger brother.
Like fast forward and some other things i can´t remember.
Opened it up and checked the chips on the board.

Soldering some wires (on smd chips! .. so very small) and some buttons, i’ve got the extra functions!
While adding these functions, i had an idea. How to connect this Discman to my Amiga!

I’ll post more info when i find these!
I found some binaries and source:
cdplay.s – source

Binaries for following functions:
fwd
mem
pause
play
remain
repeat
rev
stop

Years later i removed the cover completely and made a floating disc player.
(The lid had a magnetic part which could hold the disc in place.
So i ended up having only a PCB motor and a magnet to hold the disc attached to the motor.