[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
same
(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@127.0.0.1/BwScan1
db_url = postgresql://bwscanner:password@127.0.0.1/BwScan1
--
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