• Access to UDD seems to have changed since 2021-06-01

    From Andreas Tille@21:1/5 to All on Wed Jun 16 11:30:02 2021
    Hi,

    the Blends web sentinel (running in dillon.d.o) can't connect to UDD any
    more since 2021-06-01. I'm using a Python script for the connection but
    even the simple access via psql (described in Wiki[1]) fails:

    $ LANG=C psql -U guest -h udd.debian.org -p 5452 udd
    psql: could not connect to server: Connection refused
    Is the server running on host "udd.debian.org" (2607:f8f0:614:1::1274:38) and accepting
    TCP/IP connections on port 5452?
    could not connect to server: Connection refused
    Is the server running on host "udd.debian.org" (209.87.16.38) and accepting
    TCP/IP connections on port 5452?

    Did anything changed at beginning of June? Is the Wiki outdated?

    Kind regards

    Andreas.


    [1] https://wiki.debian.org/UltimateDebianDatabase

    --
    http://fam-tille.de

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mattia Rizzolo@21:1/5 to Andreas Tille on Wed Jun 16 15:40:01 2021
    Hi Andreas!

    On Wed, Jun 16, 2021 at 11:22:22AM +0200, Andreas Tille wrote:
    the Blends web sentinel (running in dillon.d.o) can't connect to UDD any
    more since 2021-06-01. I'm using a Python script for the connection but
    even the simple access via psql (described in Wiki[1]) fails:

    This is definitely not something within UDD people's scope, but I
    forwarded it to DSA on IRC, thanks for reporting.

    $ LANG=C psql -U guest -h udd.debian.org -p 5452 udd

    I recommend you use the "psql service=udd" syntax instead, so that you
    are more reliant in case something did change in the connection details.

    --
    regards,
    Mattia Rizzolo

    GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
    More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'`
    Debian QA page: https://qa.debian.org/developer.php?login=mattia `-

    -----BEGIN PGP SIGNATURE-----

    iQIzBAEBCgAdFiEEi3hoeGwz5cZMTQpICBa54Yx2K60FAmDJ/MYACgkQCBa54Yx2 K63FEw//fkXXWzrSEHz/p3j5N18J4PC/gxGTdYfd7r8uNuAJfGhr3vY/g8hEzqSc mAJoSwJiwagcUBaPuDIL8jYhOu9NAs22/Z+LleFZ9CyP2CuYY3tvXzCcKrLc0SoO kFL3yM0jB/jcrsXvCjwaca0LgpdpehBi8Njljit5U0zBcZiZoq9tY3do8kTiQ/oA prIBXQXOVEEfBocX4FmIP9i7zkWHH4ZmIuXGXEL1ZlMxmPNGrxj93PoYHnsoniG+ jESGdOHA/MGTEFKpYuMogn1sfsbDHA6J1LtAN/DUM5JgIGWo+9SfRGl2YARCy/mm +GMn7IDwl3IP1NrqBspjNYfWjMDAAC32iulZKhnuDzgS+sEVH3WkF+w4lBxRVBee Ydl6LcDS3FaOfxpzO4hy/fBYOSB1IXuD/MSeu4SU+FNElzJoTX/OOkYtnP9vk/Nl ggjsT9GleSBLc0vzI4/LT76AI+TZExVUaf238cVZQB2WUMXjKox6yqM5ub0Vh/DR YIUzkzyF4DdK8figtch8/fvS6OXIWvegfxip+CMyT61dAwI1ZWu
  • From Andreas Tille@21:1/5 to Mattia Rizzolo on Thu Jun 17 10:50:01 2021
    Hi Mattia,

    On Wed, Jun 16, 2021 at 03:29:45PM +0200, Mattia Rizzolo wrote:
    the Blends web sentinel (running in dillon.d.o) can't connect to UDD any more since 2021-06-01. I'm using a Python script for the connection but even the simple access via psql (described in Wiki[1]) fails:

    This is definitely not something within UDD people's scope, but I
    forwarded it to DSA on IRC, thanks for reporting.

    Thanks. Are you able to reproduce the issue in some way (from another
    host may be)?

    $ LANG=C psql -U guest -h udd.debian.org -p 5452 udd

    I recommend you use the "psql service=udd" syntax instead, so that you
    are more reliant in case something did change in the connection details.

    Same result here:

    $ LANG=C psql service=udd
    psql: could not connect to server: Connection refused
    Is the server running on host "ullmann.debian.org" (2607:f8f0:614:1::1274:38) and accepting
    TCP/IP connections on port 5452?
    could not connect to server: Connection refused
    Is the server running on host "ullmann.debian.org" (209.87.16.38) and accepting
    TCP/IP connections on port 5452?

    Kind regards

    Andreas.

    --
    http://fam-tille.de

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mattia Rizzolo@21:1/5 to Andreas Tille on Thu Jun 24 17:30:01 2021
    On Thu, Jun 17, 2021 at 10:39:53AM +0200, Andreas Tille wrote:
    On Wed, Jun 16, 2021 at 03:29:45PM +0200, Mattia Rizzolo wrote:
    the Blends web sentinel (running in dillon.d.o) can't connect to UDD any more since 2021-06-01. I'm using a Python script for the connection but even the simple access via psql (described in Wiki[1]) fails:

    This is definitely not something within UDD people's scope, but I
    forwarded it to DSA on IRC, thanks for reporting.

    Thanks. Are you able to reproduce the issue in some way (from another
    host may be)?

    The other hosts I usually access UDD from (quantz, master) seem to work
    just fine.

    What DSA told me is that they don't think it ever worked:

    [16 03:25:40 PM] <mapreri> dillon% psql service=udd
    [16 03:25:40 PM] <mapreri> psql: could not connect to server: Connection refused
    [16 03:25:40 PM] <mapreri> Is the server running on host "ullmann.debian.org" (2607:f8f0:614:1::1274:38) and accepting
    [16 03:25:40 PM] <mapreri> TCP/IP connections on port 5452?
    [16 03:25:40 PM] <mapreri> could not connect to server: Connection refused
    [16 03:25:40 PM] <mapreri> Is the server running on host "ullmann.debian.org" (209.87.16.38) and accepting
    [16 03:25:40 PM] <mapreri> TCP/IP connections on port 5452?
    [16 03:25:51 PM] <mapreri> this used to work apparently :)
    [16 03:26:50 PM] <@jcristau> do you have any evidence for that claim?
    [16 03:27:42 PM] <mapreri> well, it being mentioned in the host's pg_service.conf should say that at least it ought to
    [16 03:28:25 PM] <mapreri> plus yes, blends.d.n always used udd for things, so I'm positive it used to work even without Andreas' claim on debian-qa@
    [16 03:29:10 PM] <mapreri> https://lists.debian.org/debian-qa/2021/06/msg00006.html
    [16 03:30:28 PM] <@jcristau> i can't find any trace of that having changed in recent months/years
    [16 03:35:29 PM] <@adsb> even before it moved to managed hba the hard-coded list doesn't appear to have contained dillon
    [16 03:35:55 PM] <@adsb> (hard-coded for ferm, that is)

    So, could you maybe take it to them? It's very likely ullmann's
    firewall not allowing dillon, which is their territory.

    $ LANG=C psql -U guest -h udd.debian.org -p 5452 udd

    I recommend you use the "psql service=udd" syntax instead, so that you
    are more reliant in case something did change in the connection details.

    Same result here:

    Yeah, sure, I expect the same result. I was just saying that it might
    nicer since it allows you to run the same line regardless of the host
    you are in (which might have different configuration needs). :)

    --
    regards,
    Mattia Rizzolo

    GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
    More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'`
    Debian QA page: https://qa.debian.org/developer.php?login=mattia `-

    -----BEGIN PGP SIGNATURE-----

    iQIzBAEBCgAdFiEEi3hoeGwz5cZMTQpICBa54Yx2K60FAmDUpJgACgkQCBa54Yx2 K60NiA//UOzLf0Hre7FnWqVsbGmtEXncLd1qiudtbBzr4gpML89Fhu3Jk9NX/U0s G2qAJTkA7YZ2VkdMhYKw8dNm5WDqeM3GIQhwNkx00uOPvRFeH+dug/+RZlv3UcWb ctlgTuItDbfdGzIbx4wa0dcb2O4QGIVeCKNMgqRvfnM8QVkbcEJHkZyem99aKWC1 jcaGVlTRLoJJg/3ROAmjz5+z5OOeUijJIqze37BxwuNFrc5IiTCF2gwjB2FgS8Ij +a9vgPiU4cOepZ/h+WrWpl0Ujo8dlPabnEautUoBpGCooU1MN26zOYZKnIY9BLqe k/cTJokE71RSPwkGJS+9nf4LZJYztmcnGFYON8BNwJ+8CdTZKx2QtE6OuFT5JhYH 0kyVbU3q0UIEraJW7HFB/LGnL5UybnGewcbIxca4U4RwPpR6e8FH2aB/H0Lbmj79 5qef6rBa6Ba2g1u/gvrF4oQQ33Ljg0GGeBQtiQvzphz28yvpiSJSMUOdROUrFG+N NDpb1tZ79M7DRd5lGYpbGf/aMj30Gn/goQPyOovsSxL7mpQHJQg
  • From Andreas Tille@21:1/5 to Mattia Rizzolo on Thu Jun 24 20:10:01 2021
    Hi Mattia,

    what channel did you used to enable me continuing the discussion?

    Kind regards and thanks a lot for your investigation
    Andreas.

    On Thu, Jun 24, 2021 at 05:28:27PM +0200, Mattia Rizzolo wrote:
    On Thu, Jun 17, 2021 at 10:39:53AM +0200, Andreas Tille wrote:
    On Wed, Jun 16, 2021 at 03:29:45PM +0200, Mattia Rizzolo wrote:
    the Blends web sentinel (running in dillon.d.o) can't connect to UDD any
    more since 2021-06-01. I'm using a Python script for the connection but
    even the simple access via psql (described in Wiki[1]) fails:

    This is definitely not something within UDD people's scope, but I forwarded it to DSA on IRC, thanks for reporting.

    Thanks. Are you able to reproduce the issue in some way (from another
    host may be)?

    The other hosts I usually access UDD from (quantz, master) seem to work
    just fine.

    What DSA told me is that they don't think it ever worked:

    [16 03:25:40 PM] <mapreri> dillon% psql service=udd
    [16 03:25:40 PM] <mapreri> psql: could not connect to server: Connection refused
    [16 03:25:40 PM] <mapreri> Is the server running on host "ullmann.debian.org" (2607:f8f0:614:1::1274:38) and accepting
    [16 03:25:40 PM] <mapreri> TCP/IP connections on port 5452?
    [16 03:25:40 PM] <mapreri> could not connect to server: Connection refused [16 03:25:40 PM] <mapreri> Is the server running on host "ullmann.debian.org" (209.87.16.38) and accepting
    [16 03:25:40 PM] <mapreri> TCP/IP connections on port 5452?
    [16 03:25:51 PM] <mapreri> this used to work apparently :)
    [16 03:26:50 PM] <@jcristau> do you have any evidence for that claim?
    [16 03:27:42 PM] <mapreri> well, it being mentioned in the host's pg_service.conf should say that at least it ought to
    [16 03:28:25 PM] <mapreri> plus yes, blends.d.n always used udd for things, so I'm positive it used to work even without Andreas' claim on debian-qa@
    [16 03:29:10 PM] <mapreri> https://lists.debian.org/debian-qa/2021/06/msg00006.html
    [16 03:30:28 PM] <@jcristau> i can't find any trace of that having changed in recent months/years
    [16 03:35:29 PM] <@adsb> even before it moved to managed hba the hard-coded list doesn't appear to have contained dillon
    [16 03:35:55 PM] <@adsb> (hard-coded for ferm, that is)

    So, could you maybe take it to them? It's very likely ullmann's
    firewall not allowing dillon, which is their territory.

    $ LANG=C psql -U guest -h udd.debian.org -p 5452 udd

    I recommend you use the "psql service=udd" syntax instead, so that you are more reliant in case something did change in the connection details.

    Same result here:

    Yeah, sure, I expect the same result. I was just saying that it might
    nicer since it allows you to run the same line regardless of the host
    you are in (which might have different configuration needs). :)

    --
    regards,
    Mattia Rizzolo

    GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`.
    More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'`
    Debian QA page: https://qa.debian.org/developer.php?login=mattia `-



    --
    http://fam-tille.de

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)