Blog of a Fox

Home

To content | To menu | To search

Tag - Debian

Entries feed

Tuesday, June 7 2011

SSL Observatory how to load the db

By vbfox on Tuesday, June 7 2011, 21:14

The SSL Observatory is a great project from the EFF to gather all SSL certificates available on HTTPS websites and publish them for analysis. For more details see the SSL Observatory website.

The main problem if you don't want to analyse it using their pre-configured Amazon EC2 configuration is that the compressed .sql file is around 3 Go compressed using LZMA and 3 To uncompressed so you can't even un-compress the file and need to pipe directly from 7-Zip to mysql. To do it either on windows or linux :

7z e -so observatory-dec-2010.sql.lzma|mysql -u root --password=toto42sh observatory2

Note: The 7z tools is in the p7zip package on a debian system.

Sunday, September 6 2009

Things to do after formating a Sheevaplug

By vbfox on Sunday, September 6 2009, 16:28

Once a SheevaPlug is formated with sheevaplug-installer the minimum to do is :

  • Connect to the serial console, enter U-Boot and set the MAC address :

    setevn ethaddr 00:50:43:01:D2:94
saveenv
reset

  • Then login and :

    # Set the time-zone
dpkg-reconfigure tzdata
#Set the host name
echo plugfox.vbfox.local > /etc/hostname
/etc/init.d/hostname.sh