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









Nice article @xme, I created my own (derived) script and already had a small success with it. - https://isc.sans.edu/forums/diary/Tracking+Newly+Registered+Domains/23127/

Any BIND guru's? Why do the @OpenDNS server work in nslookup from CLI but not as forwarders in my bind.conf?

The City of @Marseille tests Auxylium, @Atos advanced military communication solution https://atos.net/en/2017/press-release/general-press-releases_2017_11_21/city-marseille-tests-auxyli...

Security Breach and Spilled Secrets Have Shaken the N.S.A. to Its Core - The New York Times https://www.nytimes.com/2017/11/12/us/nsa-shadow-brokers.html

HIDDEN COBRA – North Korean Remote Administration Tool: FALLCHILL | US-CERT https://www.us-cert.gov/ncas/alerts/TA17-318A

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'