Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rBGOl-00A8I8-7j for pgsql-www@arkaria.postgresql.org; Thu, 07 Dec 2023 15:34:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rBGOj-0019oA-A8 for pgsql-www@arkaria.postgresql.org; Thu, 07 Dec 2023 15:34:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rBGOj-0019o2-0O for pgsql-www@lists.postgresql.org; Thu, 07 Dec 2023 15:34:45 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rBGOd-00Aa8Z-TO for pgsql-www@postgresql.org; Thu, 07 Dec 2023 15:34:42 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-50be24167efso1016735e87.3 for ; Thu, 07 Dec 2023 07:34:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1701963278; x=1702568078; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=q4JP3Ki/R+SRg1f9h0157FFrGMBRp3XNbgPjNmdQiTw=; b=cngiAgYkBh8hxSrOrt1pfdKLJKZfsi1VkuuD+xQ4TRDDNm0jw2hkRCTrxvqYhjX43+ 8Dl1k+3fSyMOAhaH1PwCUuz6jbesySBMJ0oUdZGIsfkrnibsjbKNHokgYvFSS8pA5RZw +u1Ff0f0yWVi+U+BvgC3BEkqqUnQ7+OAmXMEQUls6Nxypbhv8AUGji1szBsqWUXDxuPJ HBaMNn0nSh16IYkXRuLVav8ONusRI59O1PtuK4HL77bIXNfJnNjVIvaf9IK8uDUVic9B ll+0lXqW9VtAw9Mzq5zZNN9COyMvlo8wN7OksGGU0RriGMInpTZzM2qol6qON+B48CeM q0Eg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1701963278; x=1702568078; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=q4JP3Ki/R+SRg1f9h0157FFrGMBRp3XNbgPjNmdQiTw=; b=eAmblyeCFlhhORZ4tTBKZPwhP+m4XKKMSyEzNSC3a+FoySE9xcO/kclh4fwlllQBEw EFPuGeryEuHzj9gLDadeg+fm6q7QepwSPaw3Rt+ecA/KdWVuK1Mq8Zfr/qDLcbDk9ZJ9 IHQML6pEY6DdKG/xZuK09NcZijlDr/3g9xGbTVxH4Jj65CHkFEApbGsAj7TwfWyQbGr7 GHbSFgyx5fzDxML40H+rpqa1cnGGg2Q33xjOyJwMo5UsrCqJuMEkWedzej0hwSRKde+S y7s1+oYxUWW6YAvSJjd2CfbY4spzU+jiAP5qBOitf9GNr4UB8eBgTok/NCo5YBoTgJG1 bKJA== X-Gm-Message-State: AOJu0YwBKp825sTvaPf/DI2gvZl0ihJXFg9zsyJgji8sjun8VG3+X4jB 4MFP3dfvGG0DsSrFzl48YLUKBtodKrEXqLwV6GjBzQtuPiA= X-Google-Smtp-Source: AGHT+IFPi+BcXNQ7boZycyv/0lQA3rLZH+MGdv5+8y9qUfb7Ppmd8fyS8OBJH0qS87inZjz/E4OsjQeInr5anfNzuEM= X-Received: by 2002:a19:4358:0:b0:50b:e242:f506 with SMTP id m24-20020a194358000000b0050be242f506mr809548lfj.52.1701963277388; Thu, 07 Dec 2023 07:34:37 -0800 (PST) MIME-Version: 1.0 From: Pierre Forstmann Date: Thu, 7 Dec 2023 16:34:26 +0100 Message-ID: Subject: cannot download mbox with python To: pgsql-www@postgresql.org Content-Type: multipart/alternative; boundary="00000000000091d00f060bed3468" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000091d00f060bed3468 Content-Type: text/plain; charset="UTF-8" Hello, I'm trying to download https://www.postgresql.org/list/pgsql-bugs/mbox/pgsql-bugs.202312 with following code using my postgresql.org account: print(url + '... ') response = requests.get(url, auth=('xxx','yyy')) print('status: ' + str(response.status_code)) print('... done') print(response.text) But I get : https://www.postgresql.org/list/pgsql-bugs/mbox/pgsql-bugs.202312... status: 200 ... done PostgreSQL:
9th November 2023: PostgreSQL 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22 Released!

Sign in

The website you are trying to log in to (List archives) is using the postgresql.org community login system. In this system you create a central account that is used to log into most postgresql.org services. Once you are logged into this account, you will automatically be logged in to the associated postgresql.org services.

If you do not already have an account, you can either create a dedicated account, or use one of the third party sign-in systems below.

Community account sign-in

If you have a postgresql.org community account with a password, please use the form below to sign in. If you have one but have lost your password, you can use the password reset form.

Third party sign in

Sign in with Facebook

Sign in with Github

Sign in with Google

Sign in with Microsoft

I don't understand what is wrong here: I get status 200 but the HTML response says that I must use the community account which I'm actually using ? Thanks --00000000000091d00f060bed3468 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

I'm trying to dow= nload=C2=A0
with following code using my postgresql.org account:

= =C2=A0=C2=A0=C2=A0 print(url + '... ')
=C2=A0 =C2=A0 response = =3D requests.get(url, auth=3D('xxx','yyy'))
=C2=A0 =C2= =A0 print('status: ' + str(response.status_code))
=C2=A0 =C2=A0 = print('... done')
=C2=A0 =C2=A0 print(response.text)
<= br>

But I get :

h= ttps://www.postgresql.org/list/pgsql-bugs/mbox/pgsql-bugs.202312... status: 200
... done
<!doctype html>
<html lang=3D"= en">
=C2=A0<head>
=C2=A0 <title>PostgreSQL: </= title>
=C2=A0 <meta name=3D"viewport" content=3D"wi= dth=3Ddevice-width, initial-scale=3D1, shrink-to-fit=3Dno">
=C2= =A0 <meta http-equiv=3D"Content-Type" content=3D"text/xht= ml; charset=3Dutf-8" />
=C2=A0 =C2=A0
=C2=A0 <meta name=3D= "theme-color" content=3D"#336791"/>
=C2=A0 <me= ta name=3D"copyright" content=3D"The PostgreSQL Global Devel= opment Group" />
=C2=A0 <link href=3D"/media/css/fontawe= some.css?97a426bd" rel=3D"stylesheet">
=C2=A0 <link= rel=3D"stylesheet" href=3D"/media/css/bootstrap-4.4.1.min.c= ss">
=C2=A0 <link rel=3D"shortcut icon" href=3D&quo= t;/favicon.ico" />
=C2=A0
=C2=A0 <link rel=3D"styles= heet" type=3D"text/css" href=3D"/dyncss/base.css?97a426= bd">

=C2=A0 <script src=3D"/media/js/theme.js?97a426= bd"></script>

=C2=A0
=C2=A0 </head>
=C2= =A0 <body>
=C2=A0 =C2=A0 <div class=3D"container-fluid&quo= t;>
=C2=A0 =C2=A0 =C2=A0 <div class=3D"row justify-content-md= -center">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <div class=3D"col&= quot;>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <!-- Header -->
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <nav class=3D"navbar navbar-expa= nd-lg navbar-light bg-light">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 <a class=3D"navbar-brand p-0" href=3D"/">=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <img class=3D"= logo" src=3D"/media/img/about/press/elephant.png" alt=3D&quo= t;PostgreSQL Elephant Logo">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 </a>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <button c= lass=3D"navbar-toggler" type=3D"button" data-toggle=3D&= quot;collapse" data-target=3D"#pgNavbar" aria-controls=3D&qu= ot;pgNavbar" aria-expanded=3D"false" aria-label=3D"Togg= le navigation">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= <span class=3D"navbar-toggler-icon"></span>
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </button>
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 <div class=3D"collapse navbar-collapse&quo= t; id=3D"pgNavbar">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 <ul class=3D"navbar-nav mr-auto">
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <li class=3D"nav-item= p-2"><a href=3D"/" title=3D"Home">Home&l= t;/a></li>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 <li class=3D"nav-item p-2"><a href=3D"/about/&q= uot; title=3D"About">About</a></li>
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <li class=3D"nav-item= p-2"><a href=3D"/download/" title=3D"Download&qu= ot;>Download</a></li>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 <li class=3D"nav-item p-2"><a href= =3D"/docs/" title=3D"Documentation">Documentation<= ;/a></li>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 <li class=3D"nav-item p-2"><a href=3D"/communit= y/" title=3D"Community">Community</a></li>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <li class=3D&qu= ot;nav-item p-2"><a href=3D"/developer/" title=3D"= ;Developers">Developers</a></li>
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <li class=3D"nav-item p-2&qu= ot;><a href=3D"/support/" title=3D"Support">Su= pport</a></li>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 <li class=3D"nav-item p-2"><a href=3D"/a= bout/donate/" title=3D"Donate">Donate</a></li>= ;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <li class= =3D"nav-item p-2"><a href=3D"/account/" title=3D&= quot;Your account">Your account</a></li>
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </ul>
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 <form role=3D"search" method=3D&qu= ot;get" action=3D"/search/">
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <div class=3D"input-group">=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <inpu= t id=3D"q" name=3D"q" type=3D"text" size=3D&q= uot;20" maxlength=3D"255" accesskey=3D"s" =C2=A0cl= ass=3D"form-control" placeholder=3D"Search for..."><= br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <span = class=3D"input-group-btn">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <button class=3D"btn btn-def= ault" type=3D"submit"><i class=3D"fas fa-search&q= uot;></i></button>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 </span>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 </div><!-- /input-group -->
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </form>
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <form id=3D"form-theme" cla= ss=3D"form-inline d-none">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 <button id=3D"btn-theme" class=3D&quo= t;btn btn-default ml-1" type=3D"button"></button>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </form>
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </div>
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 </nav>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 </div>
=C2= =A0 =C2=A0 =C2=A0 </div>
=C2=A0 =C2=A0 =C2=A0 <div class=3D&quo= t;row justify-content-center pg-shout-box">
=C2=A0 =C2=A0 =C2=A0= =C2=A0 <div class=3D"col text-white text-center">9th Novem= ber 2023: <a href=3D"/about/news/postgresql-161-155-1410-1313-1217-= and-1122-released-2749/">
=C2=A0 PostgreSQL 16.1, 15.5, 14.10, 1= 3.13, 12.17, and 11.22 Released!
</a>

</div>
=C2= =A0 =C2=A0 =C2=A0 </div>
=C2=A0 =C2=A0 </div>
=C2=A0 =C2= =A0
<div class=3D"container-fluid margin">
=C2=A0 &l= t;div class=3D"row">
=C2=A0 =C2=A0 <div class=3D"co= l-lg-2">
=C2=A0 =C2=A0 =C2=A0 <div id=3D"pgSideWrap"= ;>
=C2=A0 =C2=A0 =C2=A0 =C2=A0
=C2=A0 =C2=A0 =C2=A0 </div> &= lt;!-- pgSideWrap -->
=C2=A0 =C2=A0 </div>
=C2=A0 =C2=A0 <= ;div class=3D"col-lg-10">
=C2=A0 =C2=A0 =C2=A0 <div id= =3D"pgContentWrap">
=C2=A0 =C2=A0 =C2=A0 =C2=A0
<h1&= gt;Sign in <i class=3D"fas fa-sign-in-alt"></i></h= 1>
<p>

The website you are trying to log in to (List arc= hives) is using the
postgresql.org= community login system. In this system you create a
central account tha= t is used to log into most postgresql.org= services.
Once you are logged into this account, you will automatic= ally be
logged in to the associated po= stgresql.org services.

</p>
<p>
If you do not = already have an account,
you can either <a href=3D"/account/sign= up/">create</a>
a dedicated account, or use one of the thi= rd party sign-in systems below.
</p>

<h2>Community ac= count sign-in</h2>
<p>
If you have a postgresql.org community account with a password, please<= br>use the form below to sign in. If you have one but have lost your
pas= sword, you can use the <a href=3D"/account/reset/">password= reset</a> form.
</p>


<form action=3D".&q= uot; method=3D"post" id=3D"login-form"><input typ= e=3D"hidden" name=3D"csrfmiddlewaretoken" value=3D"= ;ZbN9nbSTSpSGxNueOJvp06wbuCTIVUeJuQfvb2e5VdjrhTZg6TZa1O7Atsd1a3vr">=
=C2=A0 <div class=3D"form-group">
=C2=A0 =C2=A0 <= input type=3D"text" class=3D"form-control" name=3D"= ;username" id=3D"id_username" placeholder=3D"Username o= r email address" autofocus />
=C2=A0 </div>
=C2=A0 <= div class=3D"form-group">
=C2=A0 =C2=A0 <input type=3D&q= uot;password" class=3D"form-control" name=3D"password&q= uot; id=3D"id_password" placeholder=3D"Password"/>=C2=A0 =C2=A0 <input type=3D"hidden" name=3D"this_is_th= e_login_form" value=3D"1" />
=C2=A0 =C2=A0 <input t= ype=3D"hidden" name=3D"next" value=3D"/account/aut= h/21/?d=3D0KoEb9W1FaSjHeKQ643Htw=3D=3D$Y4_M5XrobAlSIRZiHNqXOdS6ELWZdvdkgSBE= EImQ70RTp41NCqkB68suwxlddO27rD1jjNiolGg-U172YeyXEw=3D=3D" />
=C2= =A0 </div>
=C2=A0 <div class=3D"submit-row">
= =C2=A0 =C2=A0 <input class=3D"btn btn-primary" type=3D"su= bmit" value=3D"Community Sign-In">
=C2=A0 </div>=
</form>


<h2>Third party sign in</h2>
<p><a href=3D"/account/login/facebook/?next=3D/account/auth= /21/?d=3D0KoEb9W1FaSjHeKQ643Htw=3D=3D$Y4_M5XrobAlSIRZiHNqXOdS6ELWZdvdkgSBEE= ImQ70RTp41NCqkB68suwxlddO27rD1jjNiolGg-U172YeyXEw=3D=3D"><img sr= c=3D"/media/img/misc/btn_login_facebook.png" alt=3D"Sign in = with Facebook" /></a></p>

<p><a href=3D= "/account/login/github/?next=3D/account/auth/21/?d=3D0KoEb9W1FaSjHeKQ6= 43Htw=3D=3D$Y4_M5XrobAlSIRZiHNqXOdS6ELWZdvdkgSBEEImQ70RTp41NCqkB68suwxlddO2= 7rD1jjNiolGg-U172YeyXEw=3D=3D"><img src=3D"/media/img/misc/= btn_login_github.png" alt=3D"Sign in with Github" /></= a></p>

<p><a href=3D"/account/login/google/?n= ext=3D/account/auth/21/?d=3D0KoEb9W1FaSjHeKQ643Htw=3D=3D$Y4_M5XrobAlSIRZiHN= qXOdS6ELWZdvdkgSBEEImQ70RTp41NCqkB68suwxlddO27rD1jjNiolGg-U172YeyXEw=3D=3D&= quot;><img src=3D"/media/img/misc/btn_login_google.png" alt= =3D"Sign in with Google" /></a></p>

<p&g= t;<a href=3D"/account/login/microsoft/?next=3D/account/auth/21/?d= =3D0KoEb9W1FaSjHeKQ643Htw=3D=3D$Y4_M5XrobAlSIRZiHNqXOdS6ELWZdvdkgSBEEImQ70R= Tp41NCqkB68suwxlddO27rD1jjNiolGg-U172YeyXEw=3D=3D"><img src=3D&q= uot;/media/img/misc/btn_login_microsoft.png" alt=3D"Sign in with = Microsoft" /></a></p>




=C2=A0 =C2=A0 = =C2=A0 </div> <!-- pgContentWrap -->
=C2=A0 =C2=A0 </div&= gt;
=C2=A0 </div>
</div>

=C2=A0 =C2=A0 <!-- Foo= ter -->
=C2=A0 =C2=A0 <footer id=3D"footer">
=C2= =A0 =C2=A0 =C2=A0 <div class=3D"container">
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 <div class=3D"row">
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 <div class=3D"col-md-12">
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <ul>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 <li><a href=3D"https://twitter.com/postgresql"><img src= =3D"/media/img/atpostgresql.png" alt=3D"@postgresql">= ;</a></li>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = <li><a href=3D"https://git.postgresql.org/gitweb/?p=3Dpostgresql.git"><img src=3D"/media/img/git.png" alt=3D"Git&qu= ot;></a></li>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 &= lt;/ul>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 </div>
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 </div>
=C2=A0 =C2=A0 =C2=A0 </div>
=C2= =A0 =C2=A0 =C2=A0 <!-- Copyright -->
=C2=A0 =C2=A0 =C2=A0 <div = class=3D"container">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href= =3D"/about/policies/">Policies</a> |
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 <a href=3D"/about/policies/coc/">Code of Cond= uct</a> |
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"/about/&q= uot;>About PostgreSQL</a> |
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <a h= ref=3D"/about/contact/">Contact</a><br/>
=C2=A0= =C2=A0 =C2=A0 =C2=A0 <p>Copyright &copy; 1996-2023 The PostgreSQ= L Global Development Group</p>
=C2=A0 =C2=A0 =C2=A0 </div>=C2=A0 =C2=A0 </footer>
=C2=A0 =C2=A0 <script src=3D"/me= dia/js/jquery-3.4.1.slim.min.js"></script>
=C2=A0 =C2=A0 &= lt;script src=3D"/media/js/popper-1.16.0.min.js"></script&g= t;
=C2=A0 =C2=A0 <script src=3D"/media/js/bootstrap-4.4.1.min.js= "></script>
=C2=A0 =C2=A0 <script src=3D"/media/js= /main.js?97a426bd"></script>

=C2=A0 </body>
&= lt;/html>




--00000000000091d00f060bed3468--