Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fAVZV-0007C2-A9 for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 23 Apr 2018 07:07:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fAVZT-0003YO-Ls for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 23 Apr 2018 07:07:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fAKWQ-0006vr-Pk for pgsql-pkg-debian@lists.postgresql.org; Sun, 22 Apr 2018 19:19:38 +0000 Received: from mail-qt0-x22e.google.com ([2607:f8b0:400d:c0d::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fAKWK-0007xt-5E for pgsql-pkg-debian@postgresql.org; Sun, 22 Apr 2018 19:19:38 +0000 Received: by mail-qt0-x22e.google.com with SMTP id l11-v6so15353713qtj.10 for ; Sun, 22 Apr 2018 12:19:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-language; bh=bCYIOvCn9r3MfFJGH2aRAzc9HqhqFYr/EeLS7VJ57Ws=; b=ScNh9VEvo5RYZ61jUkdE4HpqbsBa/yvzNW5ZMIZc9VEVJunnnjcFRED9Zajs624D7k eoYVcqlcmbXKojltvsggZXzDK1HhiCK9amprvj1K/cvH0il2Wz/yCeJ3uXi/r1wSQwle ZhYwQK3skv+dg8auU9GMI8xYJuzhAwfQcPeUeiAU/RVI3b5AFv8e0NOh8TzxpkhoLHZ1 F/c6zJX1k1IiwiZNnzIkUtq41UFNJzebLcIL3SVfBMRXzc9ZBiQ9HfoiTfHJo6VN/Gf/ ZLoGzFbyvcD9lEHgcwLRxSNK+rLPlpE0SECQ1V6X9QE8znXgZYk21SrpBfct2mghFwsl cE5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-language; bh=bCYIOvCn9r3MfFJGH2aRAzc9HqhqFYr/EeLS7VJ57Ws=; b=cLYCiEXjC7HA1L4REE9NH8U2bq3fCbGPDAb3WBeHURSInYIDqVQRF1ecCnoh0J6a9t hL810uGD9/jhClKrnKX2rudz348qZGqetECVBFiqQyO9diHY3kCXswFfDDGIA+++CeR6 khVm3hTMbWp6Cs4WlhNo1YDnxpGmy93bYhT8lpf1veF97f4j+D+CbhRas2loJ4fiEW5/ 30S/qKmk5++kHVNWCDU1h0cqKtO0wAzKyEkeOje5VZT8mUhJvv/1b8TJyhJD7eSLYZvz OZIgKNnpJmnNmKKPZY4OTthHcy4fCpgF66c+q0pKzvnUwztUjNRfNB64XOllaAFFfsAa gbWw== X-Gm-Message-State: ALQs6tAJDVoiRKwSJ9U7fFTc63jhgJr3/YqxPGcqijgtBOIWagk1lsPr FlJ7/QGSdO6UfMV5ymV9lCcD6w== X-Google-Smtp-Source: AB8JxZps3nyKtii85WQtsZAHsoJ3SeicvYofbe+lesISBMF2gwAdv+WmFyHJC061tf6yCPoi72mgaw== X-Received: by 2002:aed:3edd:: with SMTP id o29-v6mr20365534qtf.248.1524424768938; Sun, 22 Apr 2018 12:19:28 -0700 (PDT) Received: from [192.168.2.115] (pool-173-69-157-211.bltmmd.fios.verizon.net. [173.69.157.211]) by smtp.googlemail.com with ESMTPSA id b76sm9989938qka.3.2018.04.22.12.19.27 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 22 Apr 2018 12:19:28 -0700 (PDT) To: pgsql-pkg-debian@postgresql.org From: tikkoneus Subject: pgadmin4 client bug report Message-ID: Date: Sun, 22 Apr 2018 15:19:27 -0400 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------572A102FF6DF89AAD03178F8" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------572A102FF6DF89AAD03178F8 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Hello, I have not used pgadmin before. After following these instructions I ran `pgadmin4` (e.g. DESKTOP/client mode) and was presented with a splash screen and then a browser window at http://127.0.0.1:/browser/ that said: Unauthorized The server could not verify that you are authorized to access the URL requested. You either supplied the wrong credentials (e.g. a bad password), or your browser doesn't understand how to supply the credentials required. I discovered that ~/.pgAdmin4.xxx.addr contained the correct URL in the form     http://127.0.0.1:/?key= After copy/pasting that URL manually into the browser pgAdmin4 accepted it and immediately redirected to the http://127.0.0.1:/browser/ location and from there works beautifully. It appears that a recent change added session keys for authenticating the browser to the client. The authentication URL is correctly written to the logs but then the wrong (old) URL is actually sent to the system to pop up in the default browser. OS: Ubuntu 16.04 Version screen: Version 3.0 Copyright Copyright 2013 - 2018, The pgAdmin Development Team Python Version 3.5.2 (default, Nov 23 2017, 16:37:01) [GCC 5.4.0 20160609] Flask Version 0.10.1 Application Mode Desktop Current User pgadmin4@pgadmin.org Cheers, tikkoneus --------------572A102FF6DF89AAD03178F8 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit Hello,

I have not used pgadmin before. After following these instructions I ran `pgadmin4` (e.g. DESKTOP/client mode) and was presented with a splash screen and then a browser window at http://127.0.0.1:<port>/browser/ that said:

Unauthorized

The server could not verify that you are authorized to access the URL requested. You either supplied the wrong credentials (e.g. a bad password), or your browser doesn't understand how to supply the credentials required.


I discovered that ~/.pgAdmin4.xxx.addr contained the correct URL in the form
    http://127.0.0.1:<port>/?key=<uuid>

After copy/pasting that URL manually into the browser pgAdmin4 accepted it and immediately redirected to the http://127.0.0.1:<port>/browser/ location and from there works beautifully.

It appears that a recent change added session keys for authenticating the browser to the client. The authentication URL is correctly written to the logs but then the wrong (old) URL is actually sent to the system to pop up in the default browser.

OS: Ubuntu 16.04
Version screen:
Version
3.0
Copyright
Copyright 2013 - 2018, The pgAdmin Development Team
Python Version
3.5.2 (default, Nov 23 2017, 16:37:01) [GCC 5.4.0 20160609]
Flask Version
0.10.1
Application Mode
Desktop
Current User
pgadmin4@pgadmin.org

Cheers,

tikkoneus
--------------572A102FF6DF89AAD03178F8--