. Skip to main content

(ˈpiːtə(r)), n, Dutch Computer geek, Father of 3 boys, Living together with @Chrizzzz. Working as a security consultant at @Atos, CISSP certified, Opinions are my own.








Nearly half of companies have suffered a data breach in the past year: Survey https://www.cisomag.com/nearly-half-companies-suffered-data-breach-past-year-survey

Russian 'Fancy Bear' Hackers Using (Unpatched) Microsoft Office DDE Exploit https://thehackernews.com/2017/11/apt28-office-dde-malware.html

"Terwijl internet toch een voorwaarde is om te hacken!", Blijkbaar heeft @keesdellebeke Stuxnet niet mee gekregen. https://www.volkskrant.nl/opinie/-sleepwet-is-echt-noodzakelijk-om-digitale-ontwikkeling-bij-te-bene...

Technical write up about that is sweeping through Russia, Ukraine and others http://blog.talosintelligence.com/2017/10/bad-rabbit.html

Our distopian future? "Big data meets Big Brother as China moves to rate its citizens" https://www.wired.co.uk/article/chinese-government-social-credit-score-privacy-invasion

“Cyber Conflict” Decoy Document Used In Real Cyber Conflict http://blog.talosintelligence.com/2017/10/cyber-conflict-decoy-document.html

Back from vacation reading up on . Can someone help me with the infection vector of this malware?

A ransomware attack without a possible means to get your files back is a wiper attack

Meisjes bouwen eigen app tijdens Girlsday bij Atos https://www.emerce.nl/wire/meisjes-bouwen-eigen-app-girlsday-atos via @Emerce

"Every contact leaves a trace." - E. Locard

Migrating Known from MySQL to PostgreSQL

1 min read

Below are the steps I've taken to finally migrate my self hosted Known site from MySQL to PostgreSQL.

Currently the website install routine only supports MySQL so there is no need to go to either the /warmup or /begin folders on your site. You need to build that database manually.

createuser withknown

createdb -T template1 -O withknown withknown

psql -f /schema/postgres/postgres.sql withknown

To migrate the data from MySQL to PostgreSQL I use the mysql2postgresql tool from Mihail Shumilov


mysqldump --xml -u root withknown > withknown.xml

php convertor.php -i withknown.xml -o withknown.sql

Edit the file withknown.sql and remove all the DROP, CREATE, ALTER lines so you are left with only the INSERT lines, which hold the actual site data. (perhaps there is a option in mysqldump to do this directly)

To get rid of the over escaping from MySQL run the below sed line.

cat withknown.sql | sed -e 's/\\\\/\\/g' > withknown-final.sql

As last phase import the data in PostgreSQL

sql -U withknown -f withknown-final.sql withknown

Make sure you update the config.ini and change the connection info

database = 'Postgres'

dbname = 'withknown'

dbpass = 'XXX'

dbuser = 'withknown'

dbhost = 'localhost'

Bij @Pathe Groningen wachten tot "Fantastic Beasts and Where to Find Them" begint.

.@IAmMandatory checking your NorthKoreaDNSLeak repo I noticed the latest SOA serial is 2013112203. Would that mean no update last 3 years?

Just preformed my first payment with @bunq, great experience! but , next to printing receipt could I get it via mail?

Ingeschreven voor "Verborgen verhalen binnen de MH17 onderzoeksraad" van @UID_ tijdens

When you
have a need,
you go somewhere,
search for it,
find it,
take it,
then return
and change things.

If anyone needs a @KeybaseIO invite, here you go https://keybase.io/inv/e61ccfb654