PoC of rainbow tables using PostgreSQL.
Caution: these commands will overwrite any database named rainbows, be careful !
cd sql/
vim roles.sql # create the user in psql, and add its password to your ~/.pgpass file
./drop_db.sh # if you have a previous rainbows database
./create_db.sh
cd ../
./import.py
After some time (OWASP SecLists took 27 minutes for 13M passwords), your database is ready.
Use ./query.py -v <<hash>> to find a password from its hash.
With the test sample, you can do this :
cat test.txt
echo -n 123123 | sha224sum -
./query.py -v 23d5c51afade7a8701186250777f3c055c94984ce3d4aaed11438c0c
This should give you 123123 back.
You might want to run this to get some useful (or not) messages :
export DEBUG=Y
ISC.