Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-07-02 Thread Andreas Tille
On Mon, Jul 02, 2012 at 04:41:11PM +0200, Lucas Nussbaum wrote: > > > > It is very simple to s?/org?/srv?g and I could easily do so - I just > > wonder why other scripts should have worked and I would like to ask > > before I break something else in my attempt to fix something. > > The config fil

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-07-02 Thread Lucas Nussbaum
On 02/07/12 at 16:19 +0200, Andreas Tille wrote: > On Mon, Jul 02, 2012 at 04:15:02PM +0200, Martin Zobel-Helas wrote: > > Hi Andreas, > > > > On Mon Jul 02, 2012 at 16:09:26 +0200, Andreas Tille wrote: > > > $ ./update-and-run.sh ftpnew > > > sh: /org/udd.debian.org/udd/scripts/fetch_ftpnew.sh:

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-07-02 Thread Iain Lane
On Mon, Jul 02, 2012 at 04:19:50PM +0200, Andreas Tille wrote: > On Mon, Jul 02, 2012 at 04:15:02PM +0200, Martin Zobel-Helas wrote: > > Hi Andreas, > > > > On Mon Jul 02, 2012 at 16:09:26 +0200, Andreas Tille wrote: > > > $ ./update-and-run.sh ftpnew > > > sh: /org/udd.debian.org/udd/scripts/fet

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-07-02 Thread Andreas Tille
On Mon, Jul 02, 2012 at 04:15:02PM +0200, Martin Zobel-Helas wrote: > Hi Andreas, > > On Mon Jul 02, 2012 at 16:09:26 +0200, Andreas Tille wrote: > > $ ./update-and-run.sh ftpnew > > sh: /org/udd.debian.org/udd/scripts/fetch_ftpnew.sh: not found > > > > I'm afraid that this is due to the fact th

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-07-02 Thread Martin Zobel-Helas
Hi Andreas, On Mon Jul 02, 2012 at 16:09:26 +0200, Andreas Tille wrote: > $ ./update-and-run.sh ftpnew > sh: /org/udd.debian.org/udd/scripts/fetch_ftpnew.sh: not found > > I'm afraid that this is due to the fact that the install dir is now > /srv/udd.debian.org/udd and there is no such dir like

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-07-02 Thread Andreas Tille
Hi, On Sat, Jun 30, 2012 at 03:08:12PM +0200, Andreas Tille wrote: > On Sat, Jun 30, 2012 at 09:39:19AM +0200, Lucas Nussbaum wrote: > > > > > [tille] ddtp, ubuntu-ddtp ftpnew screenshots, bibref, blends-prospective, > > >removals, i18n-apps > > >please integrate the needed tables into sq

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-06-30 Thread Iain Lane
Hey, On Sat, Jun 30, 2012 at 03:22:53PM +0200, Andreas Tille wrote: > On Sat, Jun 30, 2012 at 03:21:56PM +0200, Lucas Nussbaum wrote: > > On 30/06/12 at 15:08 +0200, Andreas Tille wrote: > > > On Sat, Jun 30, 2012 at 09:39:19AM +0200, Lucas Nussbaum wrote: > > > > > > > > > [tille] ddtp, ubuntu-d

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-06-30 Thread Lucas Nussbaum
On 30/06/12 at 15:22 +0200, Andreas Tille wrote: > On Sat, Jun 30, 2012 at 03:21:56PM +0200, Lucas Nussbaum wrote: > > On 30/06/12 at 15:08 +0200, Andreas Tille wrote: > > > On Sat, Jun 30, 2012 at 09:39:19AM +0200, Lucas Nussbaum wrote: > > > > > > > > > [tille] ddtp, ubuntu-ddtp ftpnew screensho

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-06-30 Thread Andreas Tille
On Sat, Jun 30, 2012 at 03:21:56PM +0200, Lucas Nussbaum wrote: > On 30/06/12 at 15:08 +0200, Andreas Tille wrote: > > On Sat, Jun 30, 2012 at 09:39:19AM +0200, Lucas Nussbaum wrote: > > > > > > > [tille] ddtp, ubuntu-ddtp ftpnew screenshots, bibref, > > > > blends-prospective, > > > >removal

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-06-30 Thread Lucas Nussbaum
On 30/06/12 at 15:08 +0200, Andreas Tille wrote: > On Sat, Jun 30, 2012 at 09:39:19AM +0200, Lucas Nussbaum wrote: > > > > > [tille] ddtp, ubuntu-ddtp ftpnew screenshots, bibref, blends-prospective, > > >removals, i18n-apps > > >please integrate the needed tables into sql/setup.sql, I got

Re: UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-06-30 Thread Andreas Tille
On Sat, Jun 30, 2012 at 09:39:19AM +0200, Lucas Nussbaum wrote: > > > [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/A

UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

2012-06-30 Thread Lucas Nussbaum
TL;DR: The UDD (Ultimate Debian Database) migration to ullmann.debian.org is finished. Please update your scripts to connect to the new instance. See http://wiki.debian.org/UltimateDebianDatabase for up-to-date information on how to connect. Some details below: On 25/06/12 at 09:54 +0200, Lucas N

Re: UDD migration to ullmann.debian.org

2012-06-27 Thread Lucas Nussbaum
On 27/06/12 at 17:47 +0100, Stephen Gran wrote: > Maybe if you ask lucas nicely, he can dump tables one at a time for you > so you have what you need? At any rate, the problem of copying data > over http from a debian machine to a non-debian machine probably doesn't > need DSA to do very much, so

Re: UDD migration to ullmann.debian.org

2012-06-27 Thread Lucas Nussbaum
On 25/06/12 at 09:54 +0200, Lucas Nussbaum wrote: > [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 importer

Re: UDD migration to ullmann.debian.org

2012-06-27 Thread Stephen Gran
This one time, at band camp, Andreas Tille said: > On Wed, Jun 27, 2012 at 07:33:29AM +0100, Stephen Gran wrote: > > > I wonder whether we could now find a way to export the UDD bugs > > > tables as I have suggested and which was confirmed by Lucas: > > > > > >http://lists.debian.org/debian-qa

Re: UDD migration to ullmann.debian.org

2012-06-27 Thread Andreas Tille
On Wed, Jun 27, 2012 at 07:33:29AM +0100, Stephen Gran wrote: > > I wonder whether we could now find a way to export the UDD bugs > > tables as I have suggested and which was confirmed by Lucas: > > > >http://lists.debian.org/debian-qa/2012/05/msg00023.html > > I see the advantage of having a

Re: UDD migration to ullmann.debian.org

2012-06-27 Thread Stephen Gran
This one time, at band camp, Paul Wise said: > On Wed, Jun 27, 2012 at 3:33 PM, Stephen Gran wrote: > > > I see the advantage of having a udd replica set somewhere, if > > latency and read performance on ullmann is problematic. > ... > > postgres has native replication support.  I don't see a need

Re: UDD migration to ullmann.debian.org

2012-06-27 Thread Paul Wise
On Wed, Jun 27, 2012 at 3:33 PM, Stephen Gran wrote: > I see the advantage of having a udd replica set somewhere, if > latency and read performance on ullmann is problematic. ... > postgres has native replication support.  I don't see a need to reinvent > the wheel here, do you? For some reason I

Re: UDD migration to ullmann.debian.org

2012-06-26 Thread Stephen Gran
This one time, at band camp, Andreas Tille said: > Hi ullmann admins, > > thanks a lot for this very good news! This helps a lot. > > I wonder whether we could now find a way to export the UDD bugs > tables as I have suggested and which was confirmed by Lucas: > >http://lists.debian.org/deb

Re: UDD migration to ullmann.debian.org

2012-06-26 Thread Peter Palfrader
On Mon, 25 Jun 2012, Lucas Nussbaum wrote: > [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

Re: UDD migration to ullmann.debian.org

2012-06-26 Thread Faidon Liambotis
On Mon, Jun 25, 2012 at 10:18:57PM +0200, Lucas Nussbaum wrote: > Any ideas? What kind of disks is ullmann running on? We were discussing SSDs > at > some point, but I don't know what actually happened. It's two SSDs in RAID1 but over (non-shared) virtualization. > Don't get me wrong: the improv

Re: UDD migration to ullmann.debian.org

2012-06-25 Thread Lucas Nussbaum
On 25/06/12 at 23:52 +0100, Iain Lane wrote: > Hi, > > On Mon, Jun 25, 2012 at 09:54:18AM +0200, Lucas Nussbaum wrote: > > Hi, > > > > So, thanks to DSA, we got a brand new machine for UDD, called > > ullmann.debian.org. :-) > > Nice :-) > > > > > I've started working on the migration. I took

Re: UDD migration to ullmann.debian.org

2012-06-25 Thread Lucas Nussbaum
On 25/06/12 at 23:24 +0200, Andreas Tille wrote: > Hi ullmann admins, > > thanks a lot for this very good news! This helps a lot. > > I wonder whether we could now find a way to export the UDD bugs > tables as I have suggested and which was confirmed by Lucas: > >http://lists.debian.org/deb

Re: UDD migration to ullmann.debian.org

2012-06-25 Thread Iain Lane
Hi, On Mon, Jun 25, 2012 at 09:54:18AM +0200, Lucas Nussbaum wrote: > Hi, > > So, thanks to DSA, we got a brand new machine for UDD, called > ullmann.debian.org. :-) Nice :-) > > I've started working on the migration. I took the opportunity to switch > to git, so UDD now lives at >http://a

Re: UDD migration to ullmann.debian.org

2012-06-25 Thread Andreas Tille
Hi ullmann admins, thanks a lot for this very good news! This helps a lot. I wonder whether we could now find a way to export the UDD bugs tables as I have suggested and which was confirmed by Lucas: http://lists.debian.org/debian-qa/2012/05/msg00023.html I do see two options: 1. Either

Re: UDD migration to ullmann.debian.org

2012-06-25 Thread Lucas Nussbaum
On 25/06/12 at 20:07 +0100, Stephen Gran wrote: > > [dsa] tune PG (with pgtune?) > > Done. Thanks! The performance is a bit disappointing though: > Benchmark 1: (squeeze-security import) > udd@ullmann:/srv/udd.debian.org/udd$ time ./update-and-run.sh > debian-squeeze-security > ullmann: r

Re: UDD migration to ullmann.debian.org

2012-06-25 Thread Stephen Gran
This one time, at band camp, Lucas Nussbaum said: > [dsa] setup password-less guest access on ullmann (currently broken, asks > for password) > [dsa] add service=udd entry on ullmann sgran@ullmann:~$ psql -U guest 'service=udd' psql (9.1.4) SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)

UDD migration to ullmann.debian.org

2012-06-25 Thread Lucas Nussbaum
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