Re: [codesprints] VSCode not showing connection under SQLTools

Nicolas Giard <nick@staff.ietf.org> Fri, 21 July 2023 22:50 UTC

Return-Path: <nick@staff.ietf.org>
X-Original-To: codesprints@ietfa.amsl.com
Delivered-To: codesprints@ietfa.amsl.com
Received: from localhost (localhost [127.0.0.1]) by ietfa.amsl.com (Postfix) with ESMTP id C3027C151084 for <codesprints@ietfa.amsl.com>; Fri, 21 Jul 2023 15:50:40 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -6.894
X-Spam-Level:
X-Spam-Status: No, score=-6.894 tagged_above=-999 required=5 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5, RCVD_IN_ZEN_BLOCKED_OPENDNS=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001, URIBL_DBL_BLOCKED_OPENDNS=0.001, URIBL_ZEN_BLOCKED_OPENDNS=0.001, WEIRD_PORT=0.001] autolearn=ham autolearn_force=no
Authentication-Results: ietfa.amsl.com (amavisd-new); dkim=pass (2048-bit key) header.d=staff-ietf-org.20221208.gappssmtp.com
Received: from mail.ietf.org ([50.223.129.194]) by localhost (ietfa.amsl.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id f1fwHhqdx3SZ for <codesprints@ietfa.amsl.com>; Fri, 21 Jul 2023 15:50:36 -0700 (PDT)
Received: from mail-lf1-x12f.google.com (mail-lf1-x12f.google.com [IPv6:2a00:1450:4864:20::12f]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by ietfa.amsl.com (Postfix) with ESMTPS id DFCC6C14CF13 for <codesprints@ietf.org>; Fri, 21 Jul 2023 15:50:35 -0700 (PDT)
Received: by mail-lf1-x12f.google.com with SMTP id 2adb3069b0e04-4fb96e2b573so3912893e87.3 for <codesprints@ietf.org>; Fri, 21 Jul 2023 15:50:35 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=staff-ietf-org.20221208.gappssmtp.com; s=20221208; t=1689979834; x=1690584634; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=d0xL5rpHKXxKyepMqua/oADx9AsZ0zjF/gX+TeVldtY=; b=zACdYiFXg1OMcTTJ00PkHbr4Qb9zy91Uxzh7MEQCjoPPfetI8/DEcjRctVE5SUMFIc d8PUy7F7zDwFtmQ+byLK1ohNXA0JL3/7hRt3UsUaB+PCLZ4Ock/P2OJZGAhXqKlzrhGS RIYRlQzqt1mG6vLZYYj9kuuAaNARYbEQPCxO9mG2YgtXK5XPlb7KUbxiq/IENJka9dRR 0eWmobxyv7vPbyQ60ILNR1vcusT9M8ZJzH5uRDlqLIBg5Pk+JTsYb/J943ODLpuBc9Jb xw4Xg+rv/xXTVL59l6joA4ni7LI3eNxiuh47NpxHaJ109xLsbNOrUIkIPUgSuZO3lRnD 0P1g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689979834; x=1690584634; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=d0xL5rpHKXxKyepMqua/oADx9AsZ0zjF/gX+TeVldtY=; b=QXHeHY7II22vhoxsA8Ws87xPKBDDCKL5+Qgnriyr8K86XayJkYT1QLRp9p8kUc94QX 6RkKM/dIZsAEt8fN929MRHqVrUlDY2mmgjXwfJV7FylkROOB08xDvODEj8UIE6g7G5K3 vJTRIlqhO3NbohhLX85THM8B9loIloNn4x6ZMmIHV0xHgqZcGdTuaZpoE4/kfV6cR4Bk tPn0VqKuJ+mRSAHkgod9EwaFFRxBMr6gMgFlFgm1fTqzLDoxnUKHtjyyFKSjSZl5j/WM Pn9n5ko+xgVK/yxEFwNpsbJRwd8uqz7QJAT1K+MKZf0y0k+EUn8SOa9KMlvZiKZdwXIz G7Og==
X-Gm-Message-State: ABy/qLbvQ5UE4zvxJ0NpH811VrLj1CieJolUBOnqNtFpfGIquOWUEAQs kXYA+h6+OYooDaokTfyTb2QThfGQNRLahynsmiIzpb9If0/VPjdibg/KkqcF
X-Google-Smtp-Source: APBJJlHtRZ6KdA5UPu2z5J5Uu6/gcuX+qDgS+fxrIGFJWYMX5UgcdEvtaet8rskVTzkTpp/WA1ug1v0nLkXBBMXjRhQ=
X-Received: by 2002:a2e:6a04:0:b0:2b6:f21a:3dae with SMTP id f4-20020a2e6a04000000b002b6f21a3daemr2535995ljc.44.1689979833771; Fri, 21 Jul 2023 15:50:33 -0700 (PDT)
MIME-Version: 1.0
References: <10D111AB-C378-4968-ADD9-28F84593364C@amsl.com>
In-Reply-To: <10D111AB-C378-4968-ADD9-28F84593364C@amsl.com>
From: Nicolas Giard <nick@staff.ietf.org>
Date: Fri, 21 Jul 2023 18:50:22 -0400
Message-ID: <CAL_px1O3NQk1rNpFhPS-dBFs6Baco8=_zNWrTKShNSWbo=+pKA@mail.gmail.com>
To: Priyanka Narkar <priyanka@amsl.com>
Cc: codesprints@ietf.org
Content-Type: multipart/related; boundary="000000000000ac331e06010717ab"
Archived-At: <https://mailarchive.ietf.org/arch/msg/codesprints/2eZ7XyHIM61o-ab7lh9Wna-3Tmw>
Subject: Re: [codesprints] VSCode not showing connection under SQLTools
X-BeenThere: codesprints@ietf.org
X-Mailman-Version: 2.1.39
Precedence: list
List-Id: "List for coordinating \(and following up on\) codesprint activities" <codesprints.ietf.org>
List-Unsubscribe: <https://www.ietf.org/mailman/options/codesprints>, <mailto:codesprints-request@ietf.org?subject=unsubscribe>
List-Archive: <https://mailarchive.ietf.org/arch/browse/codesprints/>
List-Post: <mailto:codesprints@ietf.org>
List-Help: <mailto:codesprints-request@ietf.org?subject=help>
List-Subscribe: <https://www.ietf.org/mailman/listinfo/codesprints>, <mailto:codesprints-request@ietf.org?subject=subscribe>
X-List-Received-Date: Fri, 21 Jul 2023 22:50:40 -0000

Hi Priyanka,

You should instead use pgAdmin, accessible via
http://localhost:8000/pgadmin/

The SQLTools VSCode extension was removed recently in favor of the pgAdmin
web interface.
You can however still use the extension if you prefer and create a new
connection using the settings found in
https://github.com/ietf-tools/datatracker/blob/main/docker/configs/settings_postgresqldb.py

I'll update the documentation to reflect these changes.

Nick

On Fri, Jul 21, 2023 at 6:44 PM Priyanka Narkar <priyanka@amsl.com> wrote:

> For preparation for tomorrows Codesprint I am using VSCode on my local
> machine and I have Docker desktop running.
> I am following instructions from
> [image: datatracker.png]
>
> datatracker/docker/README.md at main · ietf-tools/datatracker
> <https://github.com/ietf-tools/datatracker/blob/main/docker/README.md>
> github.com
> <https://github.com/ietf-tools/datatracker/blob/main/docker/README.md>
> <https://github.com/ietf-tools/datatracker/blob/main/docker/README.md>
>
> I am unable to see the preconfigured connection Local Dev under SQLTools
> and unable to connect to DB container.
>
>
> Any suggestions?
>
>
> Regards
> Priyanka.
>
>
>
>
>
>
>
>
> _______________________________________________
> codesprints mailing list
> codesprints@ietf.org
> https://www.ietf.org/mailman/listinfo/codesprints
>