[tor-bugs] #2392 [Torflow]: Support PostGre/mysql backend

Tor Bug Tracker & Wiki torproject-admin at torproject.org
Mon Aug 1 23:01:06 UTC 2011

#2392: Support PostGre/mysql backend
 Reporter:  mikeperry    |          Owner:  mikeperry
     Type:  enhancement  |         Status:  new      
 Priority:  normal       |      Milestone:           
Component:  Torflow      |        Version:           
 Keywords:               |         Parent:           
   Points:               |   Actualpoints:           

Comment(by aagbsn):

 This fix lived here https://github.com/aagbsn/torflow/tree/ticket2392. It
 has since been merged into master.
 The changes consist of:

 1. rewriting queries so that UPDATE target and source tables are not the
    (this is achieved by using nested SELECT which cause MySQL to generate
 temporary tables)
 2. rewriting queries to avoid divide-by-zeros.

 3. adding a new configuration parameter, db_url, to bwauthority.cfg which
 specifies the database type:

 # if db_url is unset bwauthority will default to sqlite
 #db_url =
 #db_url = mysql+mysqldb://bwscanner:password@
 db_url = postgresql://bwscanner:password@

Ticket URL: <https://trac.torproject.org/projects/tor/ticket/2392#comment:2>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online

More information about the tor-bugs mailing list