public inbox for [email protected]
help / color / mirror / Atom feedFrom: Nikhil Mohite <[email protected]>
To: Dave Page <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Cc: Akshay Joshi <[email protected]>
Subject: Re: [pgAdmin][RM-2341]: Add menu option for starting PSQL
Date: Thu, 10 Jun 2021 21:16:02 +0530
Message-ID: <CAOBg0APygWhqEzULTN8eA5-hSZ-uRP7=r2g9pmbrVP=CNrPvbw@mail.gmail.com> (raw)
In-Reply-To: <CA+OCxoyAd7TUNjs6xyUrDR32YKNhfJTzzzH4JP=StKw0PoVXVQ@mail.gmail.com>
References: <CAOBg0AO6Tjksb+EOA_-O13yRzdL_2d3y6G74m=GGQS+Ymjv=0g@mail.gmail.com>
<CA+OCxow9+UDMrsBBvJKW2AeAYaN4cO3w7kBGNKtsWhSM6_D7gQ@mail.gmail.com>
<CAOBg0AMVyLBma8wsbZ-VQWF4q3OAhqWeRLpmrxVcM_YOKH+MDQ@mail.gmail.com>
<CANxoLDd2xMu7ym9PFdhYUSy4ucNuPoZ2fvaRkuwyB+EqowLXwA@mail.gmail.com>
<CA+OCxowoz1oFE=eMKEnfFtf=oDrkPKHGfZpUGRW-sG_tpfMBTw@mail.gmail.com>
<CAOBg0ANFNvtD-LoFxXcLY5JJ4BVH5zNyrmdBED6B++-nKf012g@mail.gmail.com>
<CA+OCxowW7BEZzULbEpn73ygqWtWkUwdCAB3PMcHocUeQXcM3ow@mail.gmail.com>
<CAOBg0APGPTA4qNNryAXMwKP63uFLxQdQwnFdDXMjSr4OeH-HAg@mail.gmail.com>
<CA+OCxozYus58i3BhP37E-2Xc6Nq5zrJegcq+eANWpvN++_LtXw@mail.gmail.com>
<CAOBg0AO7NfJjLLFD8g5NkkbbnKiCSR5g9yshxc-65sWk2sFyBA@mail.gmail.com>
<CA+OCxoxdaBmh6e4Fo1F_+vZExq8SPUyGAByRzOPy2kz_vgRiSA@mail.gmail.com>
<CAOBg0AO6A10OHiQAOOguagW1mNzfK1oVPHG9W+JSCkYjR+xQkA@mail.gmail.com>
<CA+OCxoxpyfJabnycSGmtUK1-QEndNfZV3q2d1xP-oftDn-pGDw@mail.gmail.com>
<CANxoLDexHsJQcrd6ZrkjCub+xj_Ke+dDp_Av5no84MOJH1uC_g@mail.gmail.com>
<CAOBg0AN6Gb9gp1F=jKeefAz6d0U2GSjC40qAJ8i7psor2KmQLA@mail.gmail.com>
<CANxoLDd3QdOPY7Y6kDCSy99s3DFrbdhP9LNxphsEg9B5G14Dbg@mail.gmail.com>
<CAOBg0AN3eSLvS_cG7R3WiTpfBxiJfi2YB6sV8NBWiakioXRAsQ@mail.gmail.com>
<CANxoLDdGeNOBZJu-v9YaefKeTSGcCcU2DQic1MQU9jYYLJ6K_Q@mail.gmail.com>
<CAOBg0AO-gsDJSrLoGPJGKsq772Okgg3BWDuERaaGSDvoGbhQAA@mail.gmail.com>
<CA+OCxozEBo7-8hSeWo8K9mAL5E5MkeW3JG+JnjJXMEkT6q8SNg@mail.gmail.com>
<CANxoLDcfbqO5qYOV=LE8x1ocVEUoLD7bCm_UXYHmXL2=n9kX7A@mail.gmail.com>
<CAOBg0ANMJTzaEQdcEwUnLLGJXSbsT6=0L8Jvs_MTuBTfj0YtrQ@mail.gmail.com>
<CANxoLDcjno=sUmj11QSEv8OYCSoiOtMVvHjo=jrWjumBPtk6RA@mail.gmail.com>
<CAOBg0AMqZwQZoaxNHFn2cL0yHtfW04=RDYw-UqvjG-vA4KHmBA@mail.gmail.com>
<CA+OCxoypWKk=5uST1gQEyYpYfgiX4=_EVSpy6o+AF8LErMd3pA@mail.gmail.com>
<CAOBg0ANY6j0MHeSx0tOyrBz_+ZGH_zVYaB8+O0O6=qQ5f_BcVw@mail.gmail.com>
<CA+OCxoyqJeMUFU4bujdUM9kcjSGngENeD4DuvLHu7ks_EQGhHw@mail.gmail.com>
<CAOBg0ANz0XJ1j-YArXN6xUkbm2WhV0p-yX3Pw5emxk7EUpN4WA@mail.gmail.com>
<CA+OCxoyAd7TUNjs6xyUrDR32YKNhfJTzzzH4JP=StKw0PoVXVQ@mail.gmail.com>
Hi Dave,
On Thu, Jun 10, 2021 at 8:21 PM Dave Page <[email protected]> wrote:
>
>
> On Thu, Jun 10, 2021 at 2:22 PM Nikhil Mohite <
> [email protected]> wrote:
>
>> Hi Dave,
>>
>> On Thu, Jun 10, 2021 at 6:37 PM Dave Page <[email protected]> wrote:
>>
>>> Hi
>>>
>>> On Thu, Jun 10, 2021 at 2:00 PM Nikhil Mohite <
>>> [email protected]> wrote:
>>>
>>>> Hi Dave,
>>>>
>>>> On Thu, Jun 10, 2021 at 5:22 PM Dave Page <[email protected]> wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> On Thu, Jun 10, 2021 at 11:08 AM Nikhil Mohite <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Hi Dave/ Team,
>>>>>>
>>>>>> We are facing an issue with winpty.dll on Windows server 2016 and
>>>>>> Windows 7(these are platforms on which we have tested).
>>>>>> Files required for winpty are present in the site-packages but still,
>>>>>> it is unable to load the winpty.dll file on these specific platforms. We
>>>>>> have tested it on Windows 10 pro and Windows server 2019 and it is working
>>>>>> fine. (Also tried building the local pywinpty but unable to build it.) ref
>>>>>> link for winPty
>>>>>> https://github.com/rprichard/winpty#:~:text=winpty%20is%20a%20Windows%20software,in%20a%20Cygwin%2FM....
>>>>>>
>>>>>
>>>>> Does winpty.exe run, if executed from the command line instead of
>>>>> pgAdmin? If not, does dependency walker show any missing libraries that are
>>>>> required?
>>>>>
>>>> Not found the winpty.exe in site packages, but as per the winpty
>>>> documents "winpty-agent.exe" will start the process with a new, hidden
>>>> console window. It is not showing any error while installing the package. I
>>>> tried to use it outside the pgAdmin but still facing the same error
>>>> "Exception in import winpty DLL load failed while importing winpty: The
>>>> specified procedure could not be found."(created a separate python
>>>> environment for this)
>>>>
>>>> 1. if try to run winpty-agent.exe from the command line, it shows the
>>>> user entered inputs on the same terminal, not showing any errors.
>>>> [image: image.png]
>>>>
>>>> 2. I found winpty.exe in the other installed app (Git command line:
>>>> C:\Program Files (x86)\Git\usr\bin) if try to run it through the command
>>>> line not getting any error, it is showing user entered inputs on the same
>>>> terminal. (It is not related to pgAdmin but just tried to check winpty.exe
>>>> throwing any error or not)
>>>> [image: image.png]
>>>>
>>>
>>> Hmmm, that sounds oddly similar to an issue I had with Kerberos on
>>> Windows when I was mucking around with that. I can't remember the exact
>>> details, but as a test, does the problem go away if winpty.dll is copied
>>> into the Windows system32 directory?
>>>
>> Tried it but still facing the same issue.
>>
>
> OK, I had a fiddle around, and see the same thing. I can't do a simple
> import of winpty. On 2019 it's fine. I tried various tricks that I've used
> in the past to make sure libraries are found etc.
>
> Could this be because it's trying to use the conpty interface in Windows
> 10 and above?
>
Not sure about this, but as per the pywinpty it should select the API
(ConPty or WinPty ) which is available on the platform, but ConPty will
take precedence over WinPty.
>
> If we can't get this to work tomorrow, I think it's fine to simply hide
> the menu options and button if the server detects it's running on an
> unsupported version of Windows. Of course, this should be documented. We
> also need to make sure we know *exactly* what versions it does and does not
> work on.
>
Okay, I will check if required I will update the document accordingly.
>
> --
> Dave Page
> Blog: https://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: https://www.enterprisedb.com
>
> Regards,
Nikhil Mohite
Attachments:
[image/png] image.png (42.2K, 3-image.png)
download | view image
[image/png] image.png (26.6K, 4-image.png)
download | view image
view thread (54+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: [pgAdmin][RM-2341]: Add menu option for starting PSQL
In-Reply-To: <CAOBg0APygWhqEzULTN8eA5-hSZ-uRP7=r2g9pmbrVP=CNrPvbw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox