[R-pkg-team] Bug#976059: Migrate to udd-mirror.debian.net hostname

[Andreas Tille]

Hi Asheesh,

I admit I applied your patch while beeing on a very poor connection and
I thought this would be the reason for a failure.  But now beeing behind
a normal connection I get:

LC_ALL=C psql postgresql://udd-mirror:udd-mirror@udd-mirror.debian.net/udd -t udd -c "select version from packages where package = 'abacas' ; "
psql: error: could not connect to server: Connection timed out
        Is the server running on host "udd-mirror.debian.net" (147.75.35.146) and accepting
        TCP/IP connections on port 5452?

Is this a temporary issue or is something wrong with the query?

Kind regards

     Andreas.


On Sun, Nov 29, 2020 at 01:02:37AM -0500, Asheesh Laroia wrote:
> Package: dh-r
> Version: 20201117
> X-Debbugs-CC: mattia at debian.org
> 
> Hi there!
> 
> I looked through Debian for mentions of the
> public-udd-mirror.xvm.mit.edu hostname, which Mattias and I are
> deprecating in favor of udd-mirror.debian.net. See also
> https://lists.debian.org/debian-qa/2020/11/msg00011.html
> 
> I discovered it in dh-r via this search:
> https://codesearch.debian.net/search?q=public-udd-mirror
> 
> For many years, both hostnames have worked. We now expect the old
> hostname to stop working eventually.
> 
> I'm attaching a patch, which I have tested by manually running psql
> with similar flags as how the script would run it:
> 
> $ psql postgresql://udd-mirror:udd-mirror@udd-mirror.debian.net/udd -t
> udd -c "select version from new_packages where package =
> 'libnest2d-dev' ;"
>  0.4-26-g4d6fb4d-1
> 
> This matches what I see at https://ftp-master.debian.org/new.html .
> 
> In the patch, I chose to use a postgresql:// URL to specify how to
> access the mirror. In my opinion, this improves clarity
> by avoiding the need for the PGPASSWORD environment variable.
> 
> There's some chance the patch is mangled; if so, I apologize. The
> intent should be reasonably clear.
> 
> Best regards,
> 
> Asheesh.


> _______________________________________________
> R-pkg-team mailing list
> R-pkg-team at alioth-lists.debian.net
> https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/r-pkg-team


-- 
http://fam-tille.de