UDD migration to ullmann.debian.org

[Lucas Nussbaum <lucas@lucas-nussbaum.net>]

Hi,

So, thanks to DSA, we got a brand new machine for UDD, called
ullmann.debian.org. :-)

I've started working on the migration. I took the opportunity to switch
to git, so UDD now lives at
   http://anonscm.debian.org/gitweb/?p=collab-qa/udd.git;a=summary

Here are the missing bits:

[dsa] setup password-less guest access on ullmann (currently broken, asks
  for password)
[dsa] add service=udd entry on ullmann
[dsa] tune PG (with pgtune?)
  Benchmark 1: (squeeze-security import)
  udd@ullmann:/srv/udd.debian.org/udd$ time ./update-and-run.sh debian-squeeze-security
  ullmann: real	0m55.363s user	0m10.285s sys	0m0.476s
  my laptop (with SSD): real	0m17.079s user	0m9.229s sys	0m0.196s
  samosa: real	9m48.011s user	0m26.834s sys	0m1.116s

  Benchmark 2: (bugs import)
  udd@ullmann:/srv/udd.debian.org/udd$ time ./update-and-run.sh bugs
  ullmann: real	33m12.664s user	26m44.580s sys	1m31.834s
  my laptop (with SSD): real	17m37.500s user	16m4.344s sys	0m25.270s
  samosa: hours
  (the numbers for samosa are particularly bad, but that could be because 
  the cron'ed manual vacuuming happens at the beginning of each month)

[lucas] check CGI scripts (need guest access)

[lucas/mirroradm] setup mirror push notifications

[laney] reconfigure ubuntu-upload-history

[tille] ddtp, ubuntu-ddtp ftpnew screenshots, bibref, blends-prospective,
   removals, i18n-apps
   please integrate the needed tables into sql/setup.sql, I got lost in all 
   your .sql files and moved them to sql/Attic/
   those importers are disabled in cron currently

[dsa] (when everything else is done) change ssh tunnels or allow direct SSLed
      connections to udd from alioth and quantz. kill current tunnels to 
      samosa.

[someone] document access to the new UDD on
  http://wiki.debian.org/UltimateDebianDatabase.
  announce on debian-infrastructure-announce


 Lucas