Recovery script to generate QR codes for Google Auth Accounts

auth_qrcode_generator.py

#!/usr/bin/env python
#
# Note: First, pull the Google Auth database locally, which requires root access
# Then, run this, which assumes you have a databases file in the current directory
# It also assumes you have the qrencode package installed locally

import subprocess
import urllib
import sqlite3

conn = sqlite3.connect('databases')
c = conn.cursor()
urls = []
for r in c.execute('select email, secret, issuer  from accounts'):
  urls.append('otpauth://totp/' + urllib.quote(r[0]) + '?secret=' + urllib.quote(r[1]) + ('&issuer=' + urllib.quote(r[2]) if r[2] else ''))
for i in range(len(urls)):
  subprocess.call(['qrencode', '-o', 'google-auth-%s.png' % i, '-d', '300', '-s', '10', urls[i]])
# This leaves a set of google-auth-NN.png files in your current directory, which you can scan and import as you normally would.