From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id mCv9NDqykF/WHgAA0tVLHw (envelope-from ) for ; Wed, 21 Oct 2020 22:12:10 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id aC2ZMDqykF83GwAAB5/wlQ (envelope-from ) for ; Wed, 21 Oct 2020 22:12:10 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 761FC9403C9 for ; Wed, 21 Oct 2020 22:12:10 +0000 (UTC) Received: from localhost ([::1]:52472 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kVML3-0005KB-0I for larch@yhetil.org; Wed, 21 Oct 2020 18:12:09 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:58346) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kVMKb-0005Jx-9W for emacs-orgmode@gnu.org; Wed, 21 Oct 2020 18:11:41 -0400 Received: from mail-io1-xd31.google.com ([2607:f8b0:4864:20::d31]:43413) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kVMKZ-0007un-Ig for emacs-orgmode@gnu.org; Wed, 21 Oct 2020 18:11:40 -0400 Received: by mail-io1-xd31.google.com with SMTP id h21so4824740iob.10 for ; Wed, 21 Oct 2020 15:11:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=UKy4eIDQiOOQqkXJkYcHP9n7+PCeD10m6EjrrL8FtIs=; b=jdvh1NQrF5U7+geehhARtfsXTjXG7pFKSIUvi4TO0G2LGMgX0YKtDWNxjE+JKusAwA ZOug9G+5Uy7SN4Cfu3w+i1UfTkyVvTWzoZbcuk9VAV+GW9fCjH7tIUcDXqzeEKDt/ET1 SGu/ZEP+Lh666FJ69AYbxaI0f4YJLU1/7PdKuOf1N51RYVEsdN+hLHMq4I5gd0uKZWXr 4ZAxV9rPDrPoLK0I5bEIirTdL7u3L+5svENxBBecwrernPDA8thc6a9YGKVegu2vj4Q1 7ahdBdeIdSktrbI8HkxpEuofloUJfBq9HoXDhyj7PjP9U6LpMxPmNSisDR1lZbPJfn4O S1qA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=UKy4eIDQiOOQqkXJkYcHP9n7+PCeD10m6EjrrL8FtIs=; b=qLoAOSASof3FGid1LPgsQ9eOO01R7abF4ngTSdIvVYQsfxmyz2ys2VzITEr51OiCUj EoigjKarskAwXgrDbBirE+Qwaw0ECATciFeqZPnmKkZKYPjPersWUjTKQzAADAPZNc5K 4nfWLvl0GUhwUOUTj9tG5btnfz6BfkOnt7iBQSbKHMTxHkTy8c4xGEs55qajKEfekF6Z VaFu+NK4UK0IpShnk29g71k/fATpfeidD+Geb93jJCZm5EBFSOrwQbQhKFkgcYBdbWPe S/eTXa47G9VYfpitRt/Zqfjnr+VwrprTF0qBA8d+qx4wwGKHKpItFDmkHCOMHdiOfaJa loKQ== X-Gm-Message-State: AOAM533avQG+MaKJT4zZ7NCeKk8s3patVal27gSUII7kJ1ranvVk47vy JtFnc07FYfGsrwMa9B6GRxvUitK/Jmk6VGnDqv9/tU73 X-Google-Smtp-Source: ABdhPJzJjUV1mURA/EGpljXeQpr3P99dkb1ynFij9oYoYKOvQEpYkjcUAciU4Tv7EPJzFXmFKdaX0FgxHBAQjMuPm4g= X-Received: by 2002:a6b:f416:: with SMTP id i22mr4376534iog.161.1603318297722; Wed, 21 Oct 2020 15:11:37 -0700 (PDT) MIME-Version: 1.0 From: Jay Zawrotny Date: Wed, 21 Oct 2020 18:11:27 -0400 Message-ID: Subject: Combining ob-sql, docker-tramp, and tramp ssh? To: "emacs-orgmode@gnu.org" Content-Type: multipart/alternative; boundary="00000000000099056605b235a104" Received-SPF: pass client-ip=2607:f8b0:4864:20::d31; envelope-from=jayzawrotny@gmail.com; helo=mail-io1-xd31.google.com X-detected-operating-system: by eggs.gnu.org: No matching host in p0f cache. That's all we know. X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=jdvh1NQr; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: 0.29 X-TUID: FH3BLFbqXnoe --00000000000099056605b235a104 Content-Type: text/plain; charset="UTF-8" I've been using ob-sql to document & prune our dev db and it's been amazing. https://media.discordapp.net/attachments/428916969861808130/768589313964507166/image0.gif The only rough edge has been that I have to expose the SQL ports to my host, forward it over ssh (I'm using a remote machine to offload docker resources), then install a version of psql required to connect. Lastly I then need to symlink psql to point to the targeted version of psql I need. This means I can only match one setup at a time. A preferred route would be to use the :dir property to eval over tramp like: #+begin_src sql :dir "/sshx:user@devbox|docker:user@vm:/src" SELECT count(id) from accounts; #+end_src If I use Python it works, but something specific about this combo is not working. Any suggestions to fix this, personal config, docs, or debugging steps one could point me to? --00000000000099056605b235a104 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I've been using ob-sql to document & prune our dev db and it's = been amazing.=C2=A0


<= /div>
The only rough edge has been that I have to expose t= he SQL ports to my host, forward it over ssh (I'm using a remote machin= e to offload docker resources), then install a version of psql required to = connect. Lastly I then need to symlink psql to point to the targeted versio= n of psql I need.

This means I= can only match one setup at a time. A preferred route would be to use the = :dir property to eval over tramp like:

#+begin_src sql :dir "/sshx:user@devbox|docker:user@vm:= /src"
SELECT count(id) from accounts;
#+end_src

= If I use Python it works, but something specific about this combo is not wo= rking. Any suggestions to fix this, personal config, docs, or debugging ste= ps one could point me to?
--00000000000099056605b235a104--