1. Turkish Citizenship Database
2. Who would have imagined that backwards ideologies, cronyism and rising religious extremism in Turkey would lead to a crumbling and vulnerable technical infrastructure?
3.  
4. This leak contains the following information for 49,611,709 Turkish citizens: (IN CLEARTEXT)
5. National Identifier (TC Kimlik No)
6. First Name
7. Last Name
8. Mother's First Name
9. Father's First Name
10. Gender
11. City of Birth
12. Date of Birth
13. ID Registration City and District
14. Full Address
15. Lesson to learn for Turkey:
16.  
17. Bit shifting isn't encryption.
18. Index your database. We had to fix your sloppy DB work.
19. Putting a hardcoded password on the UI hardly does anything for security.
20. Do something about Erdogan! He is destroying your country beyond recognition.
21. Lessons for the US? We really shouldn't elect Trump, that guy sounds like he knows even less about running a country than Erdogan does.
22.  
23. Let's take a look at the data:
24.  
25. mernis=# SELECT * FROM citizen WHERE last = 'ERDOGAN' AND \
26.                                      first = 'RECEP TAYYIP' AND \
27.                                      date_of_birth LIKE '%/%/1954';
28. -[ RECORD 1 ]------------+-------------------------
29. uid                      | 33693950
30. national_identifier      | 17291716060
31. first                    | RECEP TAYYIP
32. last                     | ERDOGAN
33. mother_first             | TENZILE
34. father_first             | AHMET
35. gender                   | E
36. birth_city               | ISTANBUL
37. date_of_birth            | 26/2/1954
38. id_registration_city     | RIZE
39. id_registration_district | GUNEYSU
40. address_city             | ANKARA
41. address_district         | KECIOREN
42. address_neighborhood     | KAVACIK SUBAYEVLERI MAH.
43. street_address           | KUSADASI SOKAK
44. door_or_entrance_number  | 26
45. misc                     |
46. mernis=# SELECT * FROM citizen WHERE last = 'DAVUTOGLU' AND \
47.                                      first = 'AHMET' AND \
48.                                      address_city = 'ISTANBUL' AND \
49.                                      date_of_birth LIKE '%/1959';
50. -[ RECORD 1 ]------------+------------------
51. uid                      | 12409622
52. national_identifier      | 51541376338
53. first                    | AHMET
54. last                     | DAVUTOGLU
55. mother_first             | MEMNUNE
56. father_first             | MEHMET DURAN
57. gender                   | E
58. birth_city               | TASKENT
59. date_of_birth            | 26/2/1959
60. id_registration_city     | KONYA
61. id_registration_district | TASKENT
62. address_city             | ISTANBUL
63. address_district         | BAHCELIEVLER
64. address_neighborhood     | BAHCELIEVLER MAH.
65. street_address           | ISMAILPASA SOKAK
66. door_or_entrance_number  | 25
67. misc                     |
68. mernis=# SELECT * FROM citizen WHERE last = 'GUL' AND \
69.                                      first = 'ABDULLAH' AND \
70.                                      mother_first = 'ADVIYE';
71. -[ RECORD 1 ]------------+--------------------
72. uid                      | 47612408
73. national_identifier      | 21353291242
74. first                    | ABDULLAH
75. last                     | GUL
76. mother_first             | ADVIYE
77. father_first             | AHMET HAMDI
78. gender                   | E
79. birth_city               | KAYSERI
80. date_of_birth            | 29/10/1950
81. id_registration_city     | KAYSERI
82. id_registration_district | KOCASINAN
83. address_city             | ANKARA
84. address_district         | CANKAYA
85. address_neighborhood     | CANKAYA MAH.
86. street_address           | SEHIT ERSAN CADDESI
87. door_or_entrance_number  | 3
88. misc                     |
89. Download
90.  
91. mernis.sql.tar.gz (1.5GB compressed - 6.6GB uncompressed)
92. hacker beyagu
93. Torrent | Magnet URL
94. magnet:?xt=urn:btih:92b8bc93eb3ac91a0c5da26a8bbd32c864e9b3e7&dn=mernis.tar.gz&tr=http%3A%2F%2F9.rarbg.com%3A2710%2Fannounce&tr=http%3A%2F%2Fannounce.torrentsmd.com%3A6969%2Fannounce&tr=http%3A%2F%2Fbt.careland.com.cn%3A6969%2Fannounce&tr=http%3A%2F%2Fexplodie.org%3A6969%2Fannounce&tr=http%3A%2F%2Fmgtracker.org%3A2710%2Fannounce&tr=http%3A%2F%2Ftracker.tfile.me%2Fannounce&tr=http%3A%2F%2Ftracker.torrenty.org%3A6969%2Fannounce&tr=http%3A%2F%2Ftracker.trackerfix.com%2Fannounce&tr=http%3A%2F%2Fwww.mvgroup.org%3A2710%2Fannounce&tr=udp%3A%2F%2F9.rarbg.com%3A2710%2Fannounce&tr=udp%3A%2F%2F9.rarbg.me%3A2710%2Fannounce&tr=udp%3A%2F%2F9.rarbg.to%3A2710%2Fannounce&tr=udp%3A%2F%2Fcoppersurfer.tk%3A6969%2Fannounce&tr=udp%3A%2F%2Fexodus.desync.com%3A6969%2Fannounce&tr=udp%3A%2F%2Fglotorrents.pw%3A6969%2Fannounce&tr=udp%3A%2F%2Fopen.demonii.com%3A1337%2Fannounce&tr=udp%3A%2F%2Ftracker.coppersurfer.tk%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.glotorrents.com%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.leechers-paradise.org%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.openbittorrent.com%3A80%2Fannounce&tr=udp%3A%2F%2Ftracker.opentrackr.org%3A1337%2Fannounce&tr=udp%3A%2F%2Ftracker.publicbt.com%3A80%2Fannounce&tr=udp%3A%2F%2Ftracker4.piratux.com%3A6969%2Fannounce
95.  
96. SHA512(mernis.sql): b1f61764c44117ae9d11e3a825b34b042e973797b94b29a5b4b65cfc009ea5b49
97. be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61feba