Comodo Forums 2019
Sep 2019
Domain:
forums.comodo.com
Breach Count:
173,198
Region:
Global
News Report:
Leak from:
File Size:
14.52 MB
Uncompressed File Size:
69.45 MB
File Count:
1
A data breach occurred on Comodo Forums in 2019, which exposed approximately 173,198 records. The affected records pertained to users from the United States. The breach was reported in 2019
The leaked information includes\:
Usernames
Email addresses
IP addresses
Browser information
Operating system details
Other system-specific data
The breach highlights a common issue in online forums where user data is often stored in plaintext or in weakly encrypted formats, putting sensitive information at risk. It is crucial for online platforms to invest in robust security measures to protect user data and prevent such breaches from occurring.
Leaked Information:
Full Name
Email
User Name
Password
Address
Gender
Date Of Birth
IP Address
We have loaded this breach into our database.
File List:
forums.comodo.com_173198_MD5_smf_members.sql
File Content Sample:
CREATE TABLE `smf_members` (
`id_member` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`member_name` varchar(80) NOT NULL DEFAULT '',
`date_registered` int(10) unsigned NOT NULL DEFAULT '0',
`posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
`id_group` smallint(5) unsigned NOT NULL DEFAULT '0',
`lngfile` varchar(255) NOT NULL DEFAULT '',
`last_login` int(10) unsigned NOT NULL DEFAULT '0',
`real_name` varchar(255) NOT NULL DEFAULT '',
`instant_messages` smallint(5) NOT NULL DEFAULT '0',
`unread_messages` smallint(5) NOT NULL DEFAULT '0',
`pm_ignore_list` text NOT NULL,
`passwd` varchar(64) NOT NULL DEFAULT '',
`email_address` varchar(255) NOT NULL DEFAULT '',
`personal_text` varchar(255) NOT NULL DEFAULT '',
`gender` tinyint(4) unsigned NOT NULL DEFAULT '0',
`birthdate` date NOT NULL DEFAULT '0001-01-01',
`website_title` varchar(255) NOT NULL DEFAULT '',
`website_url` varchar(255) NOT NULL DEFAULT '',
`location` varchar(255) NOT NULL DEFAULT '',
`icq` varchar(255) NOT NULL DEFAULT '',
`aim` varchar(255) NOT NULL DEFAULT '',
`yim` varchar(32) NOT NULL DEFAULT '',
`msn` varchar(255) NOT NULL DEFAULT '',
`hide_email` tinyint(4) NOT NULL DEFAULT '0',
`show_online` tinyint(4) NOT NULL DEFAULT '1',
`time_format` varchar(80) NOT NULL DEFAULT '',
`signature` text NOT NULL,
`time_offset` float NOT NULL DEFAULT '0',
`avatar` varchar(255) NOT NULL DEFAULT '',
`pm_email_notify` tinyint(4) NOT NULL DEFAULT '0',
`karma_bad` smallint(5) unsigned NOT NULL DEFAULT '0',
`karma_good` smallint(5) unsigned NOT NULL DEFAULT '0',
`usertitle` varchar(255) NOT NULL DEFAULT '',
`notify_announcements` tinyint(4) NOT NULL DEFAULT '1',
`notify_regularity` tinyint(4) unsigned NOT NULL DEFAULT '1',
`member_ip` varchar(255) NOT NULL DEFAULT '',
`secret_question` varchar(255) NOT NULL DEFAULT '',
`secret_answer` varchar(64) NOT NULL DEFAULT '',
`id_theme` tinyint(4) unsigned NOT NULL DEFAULT '0',
`is_activated` tinyint(3) unsigned NOT NULL DEFAULT '1',
`is_spammer` tinyint(3) unsigned NOT NULL DEFAULT '0',
`validation_code` varchar(10) NOT NULL DEFAULT '',
`id_msg_last_visit` int(10) unsigned NOT NULL DEFAULT '0',
`additional_groups` varchar(255) NOT NULL DEFAULT '',
`smiley_set` varchar(48) NOT NULL DEFAULT '',
`id_post_group` smallint(5) unsigned NOT NULL DEFAULT '0',
`total_time_logged_in` int(10) unsigned NOT NULL DEFAULT '0',
`password_salt` varchar(255) NOT NULL DEFAULT '',
`message_labels` text NOT NULL,
`buddy_list` text NOT NULL,
`notify_send_body` tinyint(4) NOT NULL DEFAULT '0',
`notify_types` tinyint(4) NOT NULL DEFAULT '2',
`member_ip2` varchar(255) NOT NULL DEFAULT '',
`mod_prefs` varchar(20) NOT NULL DEFAULT '',
`warning` tinyint(4) NOT NULL DEFAULT '0',
`ignore_boards` text NOT NULL,
`passwd_flood` varchar(12) NOT NULL DEFAULT '',
`new_pm` tinyint(3) NOT NULL DEFAULT '0',
`pm_prefs` mediumint(8) NOT NULL DEFAULT '0',
`openid_uri` text NOT NULL,
`pm_receive_from` tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id_member`),
KEY `memberName` (`member_name`(30)),
KEY `dateRegistered` (`date_registered`),
KEY `ID_GROUP` (`id_group`),
KEY `birthdate` (`birthdate`),
KEY `posts` (`posts`),
KEY `lastLogin` (`last_login`),
KEY `ID_POST_GROUP` (`id_post_group`),
KEY `lngfile` (`lngfile`(24)),
KEY `warning` (`warning`),
KEY `total_time_logged_in` (`total_time_logged_in`),
KEY `id_theme` (`id_theme`),
KEY `real_name` (`real_name`),
KEY `member_name` (`member_name`),
KEY `idx_smf_members_email_address` (`email_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `smf_members` (`id_member`, `member_name`, `date_registered`, `posts`, `id_group`, `lngfile`, `last_login`, `real_name`, `instant_messages`, `unread_messages`, `pm_ignore_list`, `passwd`, `email_address`, `personal_text`, `gender`, `birthdate`, `website_title`, `website_url`, `location`, `icq`, `aim`, `yim`, `msn`, `hide_email`, `show_online`, `time_format`, `signature`, `time_offset`, `avatar`, `pm_email_notify`, `karma_bad`, `karma_good`, `usertitle`, `notify_announcements`, `notify_regularity`, `member_ip`, `secret_question`, `secret_answer`, `id_theme`, `is_activated`, `is_spammer`, `validation_code`, `id_msg_last_visit`, `additional_groups`, `smiley_set`, `id_post_group`, `total_time_logged_in`, `password_salt`, `message_labels`, `buddy_list`, `notify_send_body`, `notify_types`, `member_ip2`, `mod_prefs`, `warning`, `ignore_boards`, `passwd_flood`, `new_pm`, `pm_prefs`, `openid_uri`, `pm_receive_from`) VALUES
(1, 'admin', 1144118074, 54, 18, 'english-utf8', 1330685133, 'Admin[Nick]', 87, 72, '', '3e5c64e420a777b629783def1b9dec06fa757716', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 1, 1, '', '', 0, '', 0, 0, 0, '', 1, 1, '82.110.55.14', '', '', 34, 1, 0, 'fe9f0c730b', 589275, '18', '', 6, 327235, '848a', '', '', 0, 2, '82.110.55.14', '', 0, '', '1561065011|5', 1, 0, '', 1),
(2, 'garry', 1144118368, 410, 0, 'english-utf8', 1193415391, 'garry', 8, 8, '', 'a2527d9db04282d50d0dc13b036a6af0e99d78c3', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 0, 1, '', '', 0, '', 1, 0, 0, 'Retired Staff', 1, 1, '82.109.38.202', '', '', 34, 1, 0, '24c1873a51', 97863, '', '', 8, 571541, '06e4', '', '', 0, 2, '82.109.38.202', '', 0, '', '1525445816|3', 1, 0, '', 1),
(3, 'Melih', 1144139694, 14651, 1, 'english-utf8', 1562947600, 'Melih', 4335, 6, '', '98e5ecfd7a6a3afb65e636b31c3a380c5f48fc52', '[email protected]', '', 0, '0001-01-01', 'Video Blog', 'http://www.comodo.tv', '', '', '', '', '', 1, 1, '', '[url=https://www.comodo.com/news/melih-in-the-news.php] Melih in the News[/url]
[url=http://www.melih.com/about/]Who is Melih? [/url]
[url=https://twitter.com/melih_Comodo] Follow me on Twitter[/url]', -1, '', 1, 0, 0, 'CEO - Comodo', 1, 1, '10.104.69.74', '', '', 34, 1, 0, 'd41fed8ca3', 889994, '21', '', 8, 14603507, '9e72', '', '', 0, 2, '10.104.69.74', '', 0, '', '', 1, 0, '', 1),
(4, 'ully', 1144147774, 12, 0, '', 1157812294, 'ully', 7, 3, '', 'dbc83da4d178c6a3feda30916ab047451f8e2d6e', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 0, 1, '', '', 10, '', 1, 0, 0, '', 1, 1, '82.71.43.72', '', '', 34, 1, 0, '', 17783, '', '', 4, 26403, '1e1e', '', '', 0, 2, '', '', 0, '', '', 0, 0, '', 1),
(5, 'System', 1144163522, 54, 0, '', 1195689388, 'System', 10, 2, '', '0ab6d356dc1adede95f928d073aabc76b2c9e9d9', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 1, 1, '', '', 0, '', 1, 0, 0, '', 1, 1, '71.107.145.87', '', '', 34, 1, 0, '', 105359, '', '', 6, 37342, '9888', '', '', 0, 2, '71.107.145.87', '', 0, '', '', 0, 0, '', 1),
(9, 'Paulo', 1144217269, 391, 0, 'english-utf8', 1204511841, 'Paulo', 185, 18, '', '006b436df8f4d5480a457c7160e58d999a37fa0f', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 1, 1, '%B %d, %Y, %I:%M:%S %p', '', 1, '', 1, 0, 0, '', 1, 1, '66.108.25.177', 'Timao', '69b41e670fba8f9a807b6e6f250c9d7a', 34, 1, 0, 'a8e2d14ffc', 140275, '', '', 8, 632807, '21a1', '', '', 0, 2, '66.108.25.177', '', 0, '', '', 1, 0, '', 1),
(10, 'vladimir', 1144219303, 0, 0, '', 1144220016, 'vladimir', 0, 0, '', '5f1285eeeee3d5e844e152e3fc988b53', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 1, 1, '', '', 0, '', 1, 0, 0, '', 1, 1, '217.146.242.85', '', '', 34, 1, 0, 'd2ffdbcfd3', 6, '', '', 4, 0, '', '', '', 0, 2, '', '', 0, '', '1417610683|3', 0, 0, '', 1),
`id_member` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`member_name` varchar(80) NOT NULL DEFAULT '',
`date_registered` int(10) unsigned NOT NULL DEFAULT '0',
`posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
`id_group` smallint(5) unsigned NOT NULL DEFAULT '0',
`lngfile` varchar(255) NOT NULL DEFAULT '',
`last_login` int(10) unsigned NOT NULL DEFAULT '0',
`real_name` varchar(255) NOT NULL DEFAULT '',
`instant_messages` smallint(5) NOT NULL DEFAULT '0',
`unread_messages` smallint(5) NOT NULL DEFAULT '0',
`pm_ignore_list` text NOT NULL,
`passwd` varchar(64) NOT NULL DEFAULT '',
`email_address` varchar(255) NOT NULL DEFAULT '',
`personal_text` varchar(255) NOT NULL DEFAULT '',
`gender` tinyint(4) unsigned NOT NULL DEFAULT '0',
`birthdate` date NOT NULL DEFAULT '0001-01-01',
`website_title` varchar(255) NOT NULL DEFAULT '',
`website_url` varchar(255) NOT NULL DEFAULT '',
`location` varchar(255) NOT NULL DEFAULT '',
`icq` varchar(255) NOT NULL DEFAULT '',
`aim` varchar(255) NOT NULL DEFAULT '',
`yim` varchar(32) NOT NULL DEFAULT '',
`msn` varchar(255) NOT NULL DEFAULT '',
`hide_email` tinyint(4) NOT NULL DEFAULT '0',
`show_online` tinyint(4) NOT NULL DEFAULT '1',
`time_format` varchar(80) NOT NULL DEFAULT '',
`signature` text NOT NULL,
`time_offset` float NOT NULL DEFAULT '0',
`avatar` varchar(255) NOT NULL DEFAULT '',
`pm_email_notify` tinyint(4) NOT NULL DEFAULT '0',
`karma_bad` smallint(5) unsigned NOT NULL DEFAULT '0',
`karma_good` smallint(5) unsigned NOT NULL DEFAULT '0',
`usertitle` varchar(255) NOT NULL DEFAULT '',
`notify_announcements` tinyint(4) NOT NULL DEFAULT '1',
`notify_regularity` tinyint(4) unsigned NOT NULL DEFAULT '1',
`member_ip` varchar(255) NOT NULL DEFAULT '',
`secret_question` varchar(255) NOT NULL DEFAULT '',
`secret_answer` varchar(64) NOT NULL DEFAULT '',
`id_theme` tinyint(4) unsigned NOT NULL DEFAULT '0',
`is_activated` tinyint(3) unsigned NOT NULL DEFAULT '1',
`is_spammer` tinyint(3) unsigned NOT NULL DEFAULT '0',
`validation_code` varchar(10) NOT NULL DEFAULT '',
`id_msg_last_visit` int(10) unsigned NOT NULL DEFAULT '0',
`additional_groups` varchar(255) NOT NULL DEFAULT '',
`smiley_set` varchar(48) NOT NULL DEFAULT '',
`id_post_group` smallint(5) unsigned NOT NULL DEFAULT '0',
`total_time_logged_in` int(10) unsigned NOT NULL DEFAULT '0',
`password_salt` varchar(255) NOT NULL DEFAULT '',
`message_labels` text NOT NULL,
`buddy_list` text NOT NULL,
`notify_send_body` tinyint(4) NOT NULL DEFAULT '0',
`notify_types` tinyint(4) NOT NULL DEFAULT '2',
`member_ip2` varchar(255) NOT NULL DEFAULT '',
`mod_prefs` varchar(20) NOT NULL DEFAULT '',
`warning` tinyint(4) NOT NULL DEFAULT '0',
`ignore_boards` text NOT NULL,
`passwd_flood` varchar(12) NOT NULL DEFAULT '',
`new_pm` tinyint(3) NOT NULL DEFAULT '0',
`pm_prefs` mediumint(8) NOT NULL DEFAULT '0',
`openid_uri` text NOT NULL,
`pm_receive_from` tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id_member`),
KEY `memberName` (`member_name`(30)),
KEY `dateRegistered` (`date_registered`),
KEY `ID_GROUP` (`id_group`),
KEY `birthdate` (`birthdate`),
KEY `posts` (`posts`),
KEY `lastLogin` (`last_login`),
KEY `ID_POST_GROUP` (`id_post_group`),
KEY `lngfile` (`lngfile`(24)),
KEY `warning` (`warning`),
KEY `total_time_logged_in` (`total_time_logged_in`),
KEY `id_theme` (`id_theme`),
KEY `real_name` (`real_name`),
KEY `member_name` (`member_name`),
KEY `idx_smf_members_email_address` (`email_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `smf_members` (`id_member`, `member_name`, `date_registered`, `posts`, `id_group`, `lngfile`, `last_login`, `real_name`, `instant_messages`, `unread_messages`, `pm_ignore_list`, `passwd`, `email_address`, `personal_text`, `gender`, `birthdate`, `website_title`, `website_url`, `location`, `icq`, `aim`, `yim`, `msn`, `hide_email`, `show_online`, `time_format`, `signature`, `time_offset`, `avatar`, `pm_email_notify`, `karma_bad`, `karma_good`, `usertitle`, `notify_announcements`, `notify_regularity`, `member_ip`, `secret_question`, `secret_answer`, `id_theme`, `is_activated`, `is_spammer`, `validation_code`, `id_msg_last_visit`, `additional_groups`, `smiley_set`, `id_post_group`, `total_time_logged_in`, `password_salt`, `message_labels`, `buddy_list`, `notify_send_body`, `notify_types`, `member_ip2`, `mod_prefs`, `warning`, `ignore_boards`, `passwd_flood`, `new_pm`, `pm_prefs`, `openid_uri`, `pm_receive_from`) VALUES
(1, 'admin', 1144118074, 54, 18, 'english-utf8', 1330685133, 'Admin[Nick]', 87, 72, '', '3e5c64e420a777b629783def1b9dec06fa757716', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 1, 1, '', '', 0, '', 0, 0, 0, '', 1, 1, '82.110.55.14', '', '', 34, 1, 0, 'fe9f0c730b', 589275, '18', '', 6, 327235, '848a', '', '', 0, 2, '82.110.55.14', '', 0, '', '1561065011|5', 1, 0, '', 1),
(2, 'garry', 1144118368, 410, 0, 'english-utf8', 1193415391, 'garry', 8, 8, '', 'a2527d9db04282d50d0dc13b036a6af0e99d78c3', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 0, 1, '', '', 0, '', 1, 0, 0, 'Retired Staff', 1, 1, '82.109.38.202', '', '', 34, 1, 0, '24c1873a51', 97863, '', '', 8, 571541, '06e4', '', '', 0, 2, '82.109.38.202', '', 0, '', '1525445816|3', 1, 0, '', 1),
(3, 'Melih', 1144139694, 14651, 1, 'english-utf8', 1562947600, 'Melih', 4335, 6, '', '98e5ecfd7a6a3afb65e636b31c3a380c5f48fc52', '[email protected]', '', 0, '0001-01-01', 'Video Blog', 'http://www.comodo.tv', '', '', '', '', '', 1, 1, '', '[url=https://www.comodo.com/news/melih-in-the-news.php] Melih in the News[/url]
[url=http://www.melih.com/about/]Who is Melih? [/url]
[url=https://twitter.com/melih_Comodo] Follow me on Twitter[/url]', -1, '', 1, 0, 0, 'CEO - Comodo', 1, 1, '10.104.69.74', '', '', 34, 1, 0, 'd41fed8ca3', 889994, '21', '', 8, 14603507, '9e72', '', '', 0, 2, '10.104.69.74', '', 0, '', '', 1, 0, '', 1),
(4, 'ully', 1144147774, 12, 0, '', 1157812294, 'ully', 7, 3, '', 'dbc83da4d178c6a3feda30916ab047451f8e2d6e', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 0, 1, '', '', 10, '', 1, 0, 0, '', 1, 1, '82.71.43.72', '', '', 34, 1, 0, '', 17783, '', '', 4, 26403, '1e1e', '', '', 0, 2, '', '', 0, '', '', 0, 0, '', 1),
(5, 'System', 1144163522, 54, 0, '', 1195689388, 'System', 10, 2, '', '0ab6d356dc1adede95f928d073aabc76b2c9e9d9', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 1, 1, '', '', 0, '', 1, 0, 0, '', 1, 1, '71.107.145.87', '', '', 34, 1, 0, '', 105359, '', '', 6, 37342, '9888', '', '', 0, 2, '71.107.145.87', '', 0, '', '', 0, 0, '', 1),
(9, 'Paulo', 1144217269, 391, 0, 'english-utf8', 1204511841, 'Paulo', 185, 18, '', '006b436df8f4d5480a457c7160e58d999a37fa0f', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 1, 1, '%B %d, %Y, %I:%M:%S %p', '', 1, '', 1, 0, 0, '', 1, 1, '66.108.25.177', 'Timao', '69b41e670fba8f9a807b6e6f250c9d7a', 34, 1, 0, 'a8e2d14ffc', 140275, '', '', 8, 632807, '21a1', '', '', 0, 2, '66.108.25.177', '', 0, '', '', 1, 0, '', 1),
(10, 'vladimir', 1144219303, 0, 0, '', 1144220016, 'vladimir', 0, 0, '', '5f1285eeeee3d5e844e152e3fc988b53', '[email protected]', '', 0, '0001-01-01', '', '', '', '', '', '', '', 1, 1, '', '', 0, '', 1, 0, 0, '', 1, 1, '217.146.242.85', '', '', 34, 1, 0, 'd2ffdbcfd3', 6, '', '', 4, 0, '', '', '', 0, 2, '', '', 0, '', '1417610683|3', 0, 0, '', 1),