. Skip to main content

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

srcr.nl

twitter.com/srcr

instagram.com/srcr/

reddit.com/u/srcr/

paypal.me/srcr

snapchat.com/add/srcr

keybase.io/srcr

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...

Bad Rabbit: what we know https://atos.net/en/blog/bad-rabbit-know

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

https://github.com/mihailShumilov/mysql2postgresql


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