Re: [pgAdmin][RM-2341]: Add menu option for starting PSQL

Sure Dave, I will create a new VM with the latest iso.
Nikhil is not able to reproduce the issue on Windows 10 with the latest
version. So the issue is reproducible with older versions.

Kind Regards,
On Fri, Jun 11, 2021 at 1:28 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:

>
>
> On Fri, Jun 11, 2021 at 9:25 AM Fahar Abbas <fahar(dot)abbas(at)enterprisedb(dot)com>
> wrote:
>
>> Windows 10 Enterprise 2016 LTSB.
>>
>
> Hmm, I assume that is version 1607. Can you test with 1809 please? And if
> that doesn't work, try 1909.
>
>
>>
>> On Fri, Jun 11, 2021 at 1:12 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>>> Hi
>>>
>>> On Fri, Jun 11, 2021 at 7:44 AM Fahar Abbas <
>>> fahar(dot)abbas(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi,
>>>>
>>>> pgadmin4 is failing on following operating systems :
>>>> Windows 2016
>>>> Windows 2012
>>>> Windows 07
>>>> Windows 2008R2
>>>> Windows 10 64
>>>>
>>>
>>> What version of Windows 10? I *think* conpty was introduced in 1809.
>>>
>>>
>>>>
>>>> pgadmin4 is working fine in following operating system:
>>>> Windows 2019
>>>>
>>>> On Thu, Jun 10, 2021 at 7:51 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>
>>>>>
>>>>>
>>>>> On Thu, Jun 10, 2021 at 2:22 PM Nikhil Mohite <
>>>>> nikhil(dot)mohite(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> Hi Dave,
>>>>>>
>>>>>> On Thu, Jun 10, 2021 at 6:37 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>>>
>>>>>>> Hi
>>>>>>>
>>>>>>> On Thu, Jun 10, 2021 at 2:00 PM Nikhil Mohite <
>>>>>>> nikhil(dot)mohite(at)enterprisedb(dot)com> wrote:
>>>>>>>
>>>>>>>> Hi Dave,
>>>>>>>>
>>>>>>>> On Thu, Jun 10, 2021 at 5:22 PM Dave Page <dpage(at)pgadmin(dot)org>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi
>>>>>>>>>
>>>>>>>>> On Thu, Jun 10, 2021 at 11:08 AM Nikhil Mohite <
>>>>>>>>> nikhil(dot)mohite(at)enterprisedb(dot)com> 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%2FMSYS%20pty.
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> 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?
>>>>>
>>>>> 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.
>>>>>
>>>>> --
>>>>> Dave Page
>>>>> Blog: https://pgsnake.blogspot.com
>>>>> Twitter: @pgsnake
>>>>>
>>>>> EDB: https://www.enterprisedb.com
>>>>>
>>>>>
>>>>
>>>> --
>>>> Fahar Abbas
>>>> EnterpriseDB Corporation
>>>> Phone Office: +92-51-835-8874
>>>> Phone Direct: +92-51-8466803
>>>> Mobile: +92-333-5409707
>>>> Skype ID: *live:fahar.abbas*
>>>> Website: www.enterprisedb.com
>>>>
>>>
>>>
>>> --
>>> Dave Page
>>> Blog: https://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EDB: https://www.enterprisedb.com
>>>
>>>
>>
>> --
>> Fahar Abbas
>> EnterpriseDB Corporation
>> Phone Office: +92-51-835-8874
>> Phone Direct: +92-51-8466803
>> Mobile: +92-333-5409707
>> Skype ID: *live:fahar.abbas*
>> Website: www.enterprisedb.com
>>
>
>
> --
> Dave Page
> Blog: https://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: https://www.enterprisedb.com
>
>

--
Fahar Abbas
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com