Re: Issue with PgAdmin

From: Vivek Parmar <vp393001(at)gmail(dot)com>
To: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Issue with PgAdmin
Date: 2020-01-07 09:20:20
Message-ID: CADgxX4WTCOZJEFF_HE0NthFq0uZeVPC0q1j7JXqwt00ZbLKf=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

Hi Aditya,

Yes, you were right. Quick heal was blocking the port. Now it is working
after some configurations in quick heals. Thanks for you support.

On Tue, Jan 7, 2020 at 1:12 PM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:

> Hi Vivek,
>
> That's strange. It should not take that amount of time.
> Can you try disabling firewall once ? I suspect the port used by pgAdmin
> is blocked by firewall.
>
> On Tue, Jan 7, 2020 at 12:51 PM Vivek Parmar <vp393001(at)gmail(dot)com> wrote:
>
>> Hi Aditya,
>>
>> It is still not working. I tried with 3000 value too. Here are the logs:
>>
>> 07.01.2020 12:41:46 Checking for system tray...
>>> 07.01.2020 12:41:46 Starting pgAdmin4 server...
>>> 07.01.2020 12:41:46 Creating server object, port:53102,
>>> key:70fc2f32-3034-4b33-bf21-6c23cd3138b8,
>>> logfile:C:/Users/vivek/.pgAdmin4.4018626542.log
>>> 07.01.2020 12:41:46 Python Path: S:/Program Files/PostgreSQL/12/pgAdmin
>>> 4/venv/Lib/site-packages;S:/Program Files/PostgreSQL/12/pgAdmin
>>> 4/venv/DLLs;S:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib
>>> 07.01.2020 12:41:46 Python Home: S:/Program Files/PostgreSQL/12/pgAdmin
>>> 4/venv
>>> 07.01.2020 12:41:46 Initializing Python...
>>> 07.01.2020 12:41:46 Python initialized.
>>> 07.01.2020 12:41:46 Adding new additional path elements
>>> 07.01.2020 12:41:46 Redirecting stderr...
>>> 07.01.2020 12:41:46 stderr redirected successfully.
>>> 07.01.2020 12:41:46 Initializing server...
>>> 07.01.2020 12:41:46 Webapp Path: S:/Program Files/PostgreSQL/12/pgAdmin
>>> 4/web/pgAdmin4.py
>>> 07.01.2020 12:41:46 Server initialized.
>>> 07.01.2020 12:41:46 Starting Server Thread...
>>> 07.01.2020 12:41:46 Open the application code and run it.
>>> 07.01.2020 12:41:46 Set the port number, key and force SERVER_MODE off
>>> 07.01.2020 12:41:46 PyRun_SimpleFile launching application server...
>>> 07.01.2020 12:41:47 Application Server URL:
>>> http://127.0.0.1:53102/?key=70fc2f32-3034-4b33-bf21-6c23cd3138b8
>>> 07.01.2020 12:41:47 The server should be up, we'll attempt to connect
>>> and get a response. Ping the server
>>> 07.01.2020 12:47:19 Attempt to connect one more time in case of a long
>>> network timeout while looping
>>>
>>
>> On Tue, Jan 7, 2020 at 12:02 PM Aditya Toshniwal <
>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>
>>> [please do not remove pgadmin-hackers from cc]
>>>
>>> Hi Vivek,
>>>
>>> Seems like pgAdmin is timing out on your system. It is taking longer
>>> than 90 secs for server to start. It generally happens on windows systems
>>> where sqlite3 (which is used by pgAdmin config) takes a lot of time to
>>> initialize.
>>> Try the following:
>>> 1) Open regedit.
>>> 2) Go to HKEY_CURRENT_USER/Software/pgadmin/pgadmin4 and create a new
>>> string value - ConnectionTimeout. Set the value to 300.
>>> 3) Start pgAdmin.
>>> Try increasing timeout if it still fails.
>>>
>>>
>>> On Tue, Jan 7, 2020 at 10:49 AM Vivek Parmar <vp393001(at)gmail(dot)com> wrote:
>>>
>>>> I already checked that file but it is empty.
>>>>
>>>> On Tue, Jan 7, 2020 at 10:26 AM Aditya Toshniwal <
>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>
>>>>> Hi Vivek,
>>>>>
>>>>> Kindly also share - C:/Users/vivek/.pgAdmin4.4018626542.log
>>>>>
>>>>> On Mon, Jan 6, 2020 at 9:01 PM Vivek Parmar <vp393001(at)gmail(dot)com>
>>>>> wrote:
>>>>>
>>>>>> Hi Aditya,
>>>>>>
>>>>>> Here it is:
>>>>>>
>>>>>> 06.01.2020 16:47:22 Checking for system tray...
>>>>>>> 06.01.2020 16:47:22 Starting pgAdmin4 server...
>>>>>>> 06.01.2020 16:47:22 Creating server object, port:50920,
>>>>>>> key:8f41a047-ebc0-4ab4-a684-d2d8c1e1e819,
>>>>>>> logfile:C:/Users/vivek/.pgAdmin4.4018626542.log
>>>>>>> 06.01.2020 16:47:22 Python Path: S:/Program
>>>>>>> Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site-packages;S:/Program
>>>>>>> Files/PostgreSQL/12/pgAdmin 4/venv/DLLs;S:/Program
>>>>>>> Files/PostgreSQL/12/pgAdmin 4/venv/Lib
>>>>>>> 06.01.2020 16:47:22 Python Home: S:/Program
>>>>>>> Files/PostgreSQL/12/pgAdmin 4/venv
>>>>>>> 06.01.2020 16:47:22 Initializing Python...
>>>>>>> 06.01.2020 16:47:22 Python initialized.
>>>>>>> 06.01.2020 16:47:22 Adding new additional path elements
>>>>>>> 06.01.2020 16:47:22 Redirecting stderr...
>>>>>>> 06.01.2020 16:47:22 stderr redirected successfully.
>>>>>>> 06.01.2020 16:47:22 Initializing server...
>>>>>>> 06.01.2020 16:47:22 Webapp Path: S:/Program
>>>>>>> Files/PostgreSQL/12/pgAdmin 4/web/pgAdmin4.py
>>>>>>> 06.01.2020 16:47:22 Server initialized.
>>>>>>> 06.01.2020 16:47:22 Starting Server Thread...
>>>>>>> 06.01.2020 16:47:22 Open the application code and run it.
>>>>>>> 06.01.2020 16:47:22 Set the port number, key and force SERVER_MODE
>>>>>>> off
>>>>>>> 06.01.2020 16:47:22 PyRun_SimpleFile launching application server...
>>>>>>> 06.01.2020 16:47:23 Application Server URL:
>>>>>>> http://127.0.0.1:50920/?key=8f41a047-ebc0-4ab4-a684-d2d8c1e1e819
>>>>>>> 06.01.2020 16:47:23 The server should be up, we'll attempt to
>>>>>>> connect and get a response. Ping the server
>>>>>>> 06.01.2020 16:49:32 Attempt to connect one more time in case of a
>>>>>>> long network timeout while looping
>>>>>>>
>>>>>>
>>>>>> On Mon, Jan 6, 2020 at 4:58 PM Aditya Toshniwal <
>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>
>>>>>>> Hi Vivek,
>>>>>>>
>>>>>>> As I mentioned - you'll find the logs in the users home directory
>>>>>>> eg - "C:\Users\Aditya Toshniwal". Kindly send the logs.
>>>>>>>
>>>>>>> On Mon, Jan 6, 2020 at 4:54 PM Vivek Parmar <vp393001(at)gmail(dot)com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi Aditya,
>>>>>>>>
>>>>>>>> I am unable to find out the pgadmin logs file in the windows
>>>>>>>> system. I've attached the error screenshot.
>>>>>>>>
>>>>>>>> On Mon, Jan 6, 2020 at 3:57 PM Aditya Toshniwal <
>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>
>>>>>>>>> Hi Vivek,
>>>>>>>>>
>>>>>>>>> Since it is not able to start, kindly share .pgAdmin4* logs from
>>>>>>>>> your user home directory.
>>>>>>>>>
>>>>>>>>> On Mon, Jan 6, 2020 at 3:55 PM Janus <janus(dot)e(at)gmail(dot)com> wrote:
>>>>>>>>>
>>>>>>>>>> Hi Vivek
>>>>>>>>>>
>>>>>>>>>> Do you get the same error message using another browser, such as
>>>>>>>>>> Chrome?
>>>>>>>>>>
>>>>>>>>>> Best regards,
>>>>>>>>>> Janus
>>>>>>>>>>
>>>>>>>>>> On Mon, 6 Jan 2020 at 11:20, Vivek Parmar <vp393001(at)gmail(dot)com>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Dear PgAdmin Development Team,
>>>>>>>>>>>
>>>>>>>>>>> I am unable to run pgadmin on my windows 10 laptop. I am getting
>>>>>>>>>>> the below error.
>>>>>>>>>>>
>>>>>>>>>>> Fatal error:
>>>>>>>>>>> The application server could not be contacted.
>>>>>>>>>>>
>>>>>>>>>>> I tried reinstalling software and also cleared the session from
>>>>>>>>>>> the AppData folder.
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> *Regards,*
>>>>>>>>>>> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Thanks and Regards,
>>>>>>>>> Aditya Toshniwal
>>>>>>>>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> *Regards,*
>>>>>>>> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Thanks and Regards,
>>>>>>> Aditya Toshniwal
>>>>>>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *Regards,*
>>>>>> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Thanks and Regards,
>>>>> Aditya Toshniwal
>>>>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>
>>>>
>>>>
>>>> --
>>>> *Regards,*
>>>> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>>>>
>>>
>>>
>>> --
>>> Thanks and Regards,
>>> Aditya Toshniwal
>>> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>>> "Don't Complain about Heat, Plant a TREE"
>>>
>>
>>
>> --
>> *Regards,*
>> *Vivek Parmar <https://www.linkedin.com/in/vp393001/>*
>>
>
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
> "Don't Complain about Heat, Plant a TREE"
>

--
*Regards,*
*Vivek Parmar <https://www.linkedin.com/in/vp393001/>*

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Aditya Toshniwal 2020-01-07 09:30:41 Re: Issue with PgAdmin
Previous Message Aditya Toshniwal 2020-01-07 07:41:23 Re: Issue with PgAdmin

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2020-01-07 09:30:41 Re: Issue with PgAdmin
Previous Message Aditya Toshniwal 2020-01-07 07:41:23 Re: Issue with PgAdmin