Cannabis.com
Feb 5, 2014
Domain:
cannabis.com
Breach Count:
227,746
Region:
Global
Source:
-
File Size:
672.67 MB
Uncompressed File Size:
3.27 GB
File Count:
1
In 2014, the online cannabis magazine Cannabis.com suffered a major data breach, exposing the personal information of over 227,000 users. The leaked data included email addresses, usernames, passwords, IP addresses, and other sensitive information.
The breach was discovered by security researcher Chris Vickery, who found an exposed database on the magazines website. The database contained the user information in plain text, making it easy for attackers to access. Vickery notified Cannabis.com of the breach, and the magazine quickly took down the database and reset all user passwords.
The Cannabis.com breach was a significant reminder of the importance of data security. The magazines failure to adequately protect its users personal information put them at risk of identity theft, fraud, and other cybercrimes.
Leaked Information:
Date Of Birth
Email
Address
Historical passwords
Instant messenger identities
IP Address
Password
Private messages
User Name
Website activity
We have loaded this breach into our database.
File List:
cannabisforum.sql
File Content Sample:
CREATE TABLE `vb4_user` (
`userid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`membergroupids` varchar(250) NOT NULL default '',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
`email` varchar(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`parentemail` varchar(50) NOT NULL default '',
`homepage` varchar(100) NOT NULL default '',
`icq` varchar(20) NOT NULL default '',
`aim` varchar(20) NOT NULL default '',
`yahoo` varchar(32) NOT NULL default '',
`showvbcode` smallint(5) unsigned NOT NULL default '0',
`usertitle` varchar(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`joindate` int(10) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`lastvisit` int(10) unsigned NOT NULL default '0',
`lastactivity` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '10',
`reputationlevelid` int(10) unsigned NOT NULL default '1',
`timezoneoffset` varchar(4) NOT NULL default '',
`pmpopup` smallint(6) NOT NULL default '0',
`avatarid` smallint(6) NOT NULL default '0',
`avatarrevision` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '33570831',
`birthday` varchar(10) NOT NULL default '',
`maxposts` smallint(6) NOT NULL default '-1',
`startofweek` smallint(6) NOT NULL default '1',
`ipaddress` varchar(15) NOT NULL default '',
`referrerid` int(10) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`msn` varchar(100) NOT NULL default '',
`emailstamp` int(10) unsigned NOT NULL default '0',
`threadedmode` smallint(5) unsigned NOT NULL default '0',
`autosubscribe` smallint(6) NOT NULL default '-1',
`pmtotal` smallint(5) unsigned NOT NULL default '0',
`pmunread` smallint(5) unsigned NOT NULL default '0',
`salt` char(30) NOT NULL default '',
`birthday_search` date NOT NULL default '0000-00-00',
`profilepicrevision` int(10) unsigned NOT NULL default '0',
`showbirthday` smallint(5) unsigned NOT NULL default '2',
`skype` varchar(32) NOT NULL default '',
`favcache` text NOT NULL,
`adminoptions` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`sigpicrevision` int(10) unsigned NOT NULL default '0',
`ipoints` int(10) unsigned NOT NULL default '0',
`infractions` int(10) unsigned NOT NULL default '0',
`warnings` int(10) unsigned NOT NULL default '0',
`infractiongroupids` varchar(255) NOT NULL default '',
`infractiongroupid` smallint(5) unsigned NOT NULL default '0',
`nr_thread_threshold` int(11) NOT NULL default '-2000',
`nr_post_threshold` int(11) NOT NULL default '-2000',
`nr_votes` int(10) unsigned NOT NULL default '0',
`nr_rating` int(11) NOT NULL default '0',
`nr_posts_votes` int(10) unsigned NOT NULL default '0',
`nr_posts_rating` int(11) NOT NULL default '0',
`nr_threads_votes` int(10) unsigned NOT NULL default '0',
`nr_threads_rating` int(11) NOT NULL default '0',
`ppicount` int(10) NOT NULL,
`pppcount` int(10) NOT NULL,
`profilevisits` int(10) unsigned NOT NULL default '0',
`friendcount` int(10) unsigned NOT NULL default '0',
`friendreqcount` int(10) unsigned NOT NULL default '0',
`vmunreadcount` int(10) unsigned NOT NULL default '0',
`vmmoderatedcount` int(10) unsigned NOT NULL default '0',
`socgroupinvitecount` int(10) unsigned NOT NULL default '0',
`socgroupreqcount` int(10) unsigned NOT NULL default '0',
`pcunreadcount` int(10) unsigned NOT NULL default '0',
`pcmoderatedcount` int(10) unsigned NOT NULL default '0',
`gmmoderatedcount` int(10) unsigned NOT NULL default '0',
`assetposthash` varchar(32) NOT NULL default '',
`fbuserid` varchar(255) NOT NULL,
`fbjoindate` int(10) unsigned NOT NULL default '0',
`fbname` varchar(255) NOT NULL,
`logintype` enum('vb','fb') NOT NULL default 'vb',
`fbaccesstoken` varchar(255) NOT NULL,
`bloggroupreqcount` int(10) unsigned NOT NULL default '0',
`showblogcss` int(11) NOT NULL default '1',
`vbseo_likes_in` int(10) unsigned NOT NULL default '0',
`vbseo_likes_out` int(10) unsigned NOT NULL default '0',
`vbseo_likes_unread` int(10) unsigned NOT NULL default '0',
`newrepcount` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday_search` (`birthday_search`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `posts` (`posts`),
KEY `nr_user_rating` (`nr_rating`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`),
KEY `email` (`email`),
KEY `lastactivity` (`lastactivity`)
) ENGINE=MyISAM AUTO_INCREMENT=247310 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vb4_user`
--
LOCK TABLES `vb4_user` WRITE;
/*!40000 ALTER TABLE `vb4_user` DISABLE KEYS */;
INSERT INTO `vb4_user` VALUES (1,6,'',6,'Cannabis.com','b3ddcf56733279fe1102efb0b92974ff','2011-07-18','[email protected]',0,'','http://www.cannabis.com/','','','',2,'Administrator',2,1074186000,0,1391656736,1391656751,1201434360,620,-44,2,'-8',1,0,5,45107415,'07-14-1920',-1,1,'',0,0,'',0,0,-1,6,0,'6iMI4b-?1b*~z)
`userid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`membergroupids` varchar(250) NOT NULL default '',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
`email` varchar(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`parentemail` varchar(50) NOT NULL default '',
`homepage` varchar(100) NOT NULL default '',
`icq` varchar(20) NOT NULL default '',
`aim` varchar(20) NOT NULL default '',
`yahoo` varchar(32) NOT NULL default '',
`showvbcode` smallint(5) unsigned NOT NULL default '0',
`usertitle` varchar(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`joindate` int(10) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`lastvisit` int(10) unsigned NOT NULL default '0',
`lastactivity` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '10',
`reputationlevelid` int(10) unsigned NOT NULL default '1',
`timezoneoffset` varchar(4) NOT NULL default '',
`pmpopup` smallint(6) NOT NULL default '0',
`avatarid` smallint(6) NOT NULL default '0',
`avatarrevision` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '33570831',
`birthday` varchar(10) NOT NULL default '',
`maxposts` smallint(6) NOT NULL default '-1',
`startofweek` smallint(6) NOT NULL default '1',
`ipaddress` varchar(15) NOT NULL default '',
`referrerid` int(10) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`msn` varchar(100) NOT NULL default '',
`emailstamp` int(10) unsigned NOT NULL default '0',
`threadedmode` smallint(5) unsigned NOT NULL default '0',
`autosubscribe` smallint(6) NOT NULL default '-1',
`pmtotal` smallint(5) unsigned NOT NULL default '0',
`pmunread` smallint(5) unsigned NOT NULL default '0',
`salt` char(30) NOT NULL default '',
`birthday_search` date NOT NULL default '0000-00-00',
`profilepicrevision` int(10) unsigned NOT NULL default '0',
`showbirthday` smallint(5) unsigned NOT NULL default '2',
`skype` varchar(32) NOT NULL default '',
`favcache` text NOT NULL,
`adminoptions` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`sigpicrevision` int(10) unsigned NOT NULL default '0',
`ipoints` int(10) unsigned NOT NULL default '0',
`infractions` int(10) unsigned NOT NULL default '0',
`warnings` int(10) unsigned NOT NULL default '0',
`infractiongroupids` varchar(255) NOT NULL default '',
`infractiongroupid` smallint(5) unsigned NOT NULL default '0',
`nr_thread_threshold` int(11) NOT NULL default '-2000',
`nr_post_threshold` int(11) NOT NULL default '-2000',
`nr_votes` int(10) unsigned NOT NULL default '0',
`nr_rating` int(11) NOT NULL default '0',
`nr_posts_votes` int(10) unsigned NOT NULL default '0',
`nr_posts_rating` int(11) NOT NULL default '0',
`nr_threads_votes` int(10) unsigned NOT NULL default '0',
`nr_threads_rating` int(11) NOT NULL default '0',
`ppicount` int(10) NOT NULL,
`pppcount` int(10) NOT NULL,
`profilevisits` int(10) unsigned NOT NULL default '0',
`friendcount` int(10) unsigned NOT NULL default '0',
`friendreqcount` int(10) unsigned NOT NULL default '0',
`vmunreadcount` int(10) unsigned NOT NULL default '0',
`vmmoderatedcount` int(10) unsigned NOT NULL default '0',
`socgroupinvitecount` int(10) unsigned NOT NULL default '0',
`socgroupreqcount` int(10) unsigned NOT NULL default '0',
`pcunreadcount` int(10) unsigned NOT NULL default '0',
`pcmoderatedcount` int(10) unsigned NOT NULL default '0',
`gmmoderatedcount` int(10) unsigned NOT NULL default '0',
`assetposthash` varchar(32) NOT NULL default '',
`fbuserid` varchar(255) NOT NULL,
`fbjoindate` int(10) unsigned NOT NULL default '0',
`fbname` varchar(255) NOT NULL,
`logintype` enum('vb','fb') NOT NULL default 'vb',
`fbaccesstoken` varchar(255) NOT NULL,
`bloggroupreqcount` int(10) unsigned NOT NULL default '0',
`showblogcss` int(11) NOT NULL default '1',
`vbseo_likes_in` int(10) unsigned NOT NULL default '0',
`vbseo_likes_out` int(10) unsigned NOT NULL default '0',
`vbseo_likes_unread` int(10) unsigned NOT NULL default '0',
`newrepcount` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday_search` (`birthday_search`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `posts` (`posts`),
KEY `nr_user_rating` (`nr_rating`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`),
KEY `email` (`email`),
KEY `lastactivity` (`lastactivity`)
) ENGINE=MyISAM AUTO_INCREMENT=247310 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vb4_user`
--
LOCK TABLES `vb4_user` WRITE;
/*!40000 ALTER TABLE `vb4_user` DISABLE KEYS */;
INSERT INTO `vb4_user` VALUES (1,6,'',6,'Cannabis.com','b3ddcf56733279fe1102efb0b92974ff','2011-07-18','[email protected]',0,'','http://www.cannabis.com/','','','',2,'Administrator',2,1074186000,0,1391656736,1391656751,1201434360,620,-44,2,'-8',1,0,5,45107415,'07-14-1920',-1,1,'',0,0,'',0,0,-1,6,0,'6iMI4b-?1b*~z)