Re: Issue with PgAdmin

On Tue, Jan 7, 2020 at 2:50 PM Vivek Parmar <vp393001(at)gmail(dot)com> wrote:

> 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.
>
Glad it worked !!

>
> 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/>*
>

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"