@lavamind figured out that we don't actually need to specify a SITE_URL at all: he put the wrong one in and things still worked.
hilarious!
we should probably tweak the template and docs to clarify that.