Who would attain got imagined that backwards ideologies, cronyism as well as rising religious extremism inward Turkey would Pb to a crumbling as well as vulnerable technical infrastructure? This came via a recent post service made inward Reddit. This listing includes information of the country’s president. The database, which comprises 49,611,709 documents, was posted on the website of an Icelandic grouping that specializes inward divulging leaks on Monday.
Turkish citizenship database leaked ? http://185.100.87.84/ pic.twitter.com/16pspqyr3S
— Dmitry Chestnykh (@dchest) April 4, 2016
This leak contains the next information for 49,611,709 Turkish citizens: (IN CLEARTEXT)
- National Identifier (TC Kimlik No)
- First Name
- Last Name
- Mother’s First Name
- Father’s First Name
- Gender
- City of Birth
- Date of Birth
- ID Registration City as well as District
- Full Address
Lesson to larn for Turkey:
- Bit shifting isn’t encryption.
- Index your database. We had to laid upwards your sloppy DB work.
- Putting a hardcoded password on the UI hardly does anything for security.
- Do something virtually ! He is destroying your province beyond recognition.
Lessons for the US? We actually shouldn’t elect Trump, that guy sounds similar he knows fifty-fifty less virtually running a province than does.
Let’s accept a hold off at the data:
mernis=# SELECT * FROM citizen WHERE final = ' SNIP ' AND \
outset = ' SNIP ' AND \
date_of_birth LIKE '%/%/ SNIP ';
-[ RECORD i ]------------+-------------------------
uid | SNIP
national_identifier | SNIP
first | SNIP
last | SNIP
mother_first | SNIP
father_first | SNIP
gender | E
birth_city | ISTANBUL
date_of_birth | SNIP
id_registration_city | RIZE
id_registration_district | SNIP
address_city | SNIP
address_district | SNIP
address_neighborhood | SNIP .
street_address | SNIP
door_or_entrance_number | 26
misc |
mernis=# SELECT * FROM citizen WHERE final = ' SNIP ' AND \
outset = ' SNIP ' AND \
address_city = 'ISTANBUL' AND \
date_of_birth LIKE '%/ SNIP ';
-[ RECORD i ]------------+------------------
uid | SNIP
national_identifier | SNIP
first | SNIP
last | SNIP
mother_first | SNIP
father_first | SNIP
gender | E
birth_city | SNIP
date_of_birth | SNIP
id_registration_city | SNIP
id_registration_district | SNIP
address_city | SNIP
address_district | SNIP
address_neighborhood | SNIP
street_address | SNIP
door_or_entrance_number | 25
misc |
mernis=# SELECT * FROM citizen WHERE final = ' SNIP ' AND \
outset = ' SNIP ' AND \
mother_first = ' SNIP ';
-[ RECORD i ]------------+--------------------
uid | SNIP
national_identifier | SNIP
first | SNIP
last | SNIP
mother_first | SNIP
father_first | SNIP SNIP
gender | E
birth_city | SNIP
date_of_birth | SNIP
id_registration_city | SNIP
id_registration_district | SNIP
address_city | SNIP
address_district | SNIP
address_neighborhood | SNIP SNIP .
street_address | SNIP
door_or_entrance_number | 3
misc |
Turkish users already confirmed that the information is Authentic though somewhat outdated. Influenza A virus subtype H5N1 post inward Reddit explains:
Just downloaded the information set, as well as tin give the axe confirm it’s real. I’m non inward there, simply my parents as well as blood brother are. The information on at that spot isn’t that critical, simply it’s yet real disconcerting.
However the database doesn’t incorporate entries of people born later march 1991.
Download
- mernis.sql.tar.gz (1.5GB compressed – 6.6GB uncompressed)
- Torrent | Magnet URL
- SHA512(mernis.sql): b1f61764c44117ae9d11e3a825b34b042e973797b94b29a5b4b65cfc009ea5b49
- be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61feba
Source
- https://www.reddit.com/r/security/comments/4d9f22/turkish_citizenship_database_dumped/
- http://185.100.87.84/
