Subject: Running pgAdmin4

From: "Prasad Somwanshi" <[email-masked]>
Date: Wed, 30 Sep 2015 22:49:00 +0200

Hi,

I'm trying to pgAdmin4. I'm able to run pgAdmin4.py in python shell. And server runs.And able to access using browser.
Then I tried running desktop application, it throws following error,

Traceback (most recent call last):
  File "/home/prasad/Development/pgadmin4/web/pgAdmin4.py", line 73, in <module>
    app.run(port=server_port)
  File "/usr/lib/python2.7/dist-packages/flask/app.py", line 772, in run
    run_simple(host, port, self, **options)
  File "/usr/local/lib/python2.7/dist-packages/Werkzeug-0.10.1-py2.7.egg/werkzeug/serving.py", line 622, in run_simple
    reloader_type)
  File "/usr/local/lib/python2.7/dist-packages/Werkzeug-0.10.1-py2.7.egg/werkzeug/_reloader.py", line 263, in run_with_reloader
    signal.signal(signal.SIGTERM, lambda *args: sys.exit(0))
ValueError: signal only works in main thread
Initial connection failed. Retrying in 2 seconds.
Initial connection failed. Retrying in 3 seconds.
Initial connection failed. Retrying in 4 seconds.
Initial connection failed after multiple attempts. Aborting.

I can see what error says. As Qt application spawns separate thread to run server, which apparently is not allowed.
Am I missing something ?

regards,
Prasad 

-- 
Sent via pgadmin-hackers mailing list ([email-masked])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

---

From: Ashesh Vashi <[email-masked]>
Date: Thu, 1 Oct 2015 11:04:07 +0530

On Thu, Oct 1, 2015 at 2:19 AM, Prasad Somwanshi <[email-masked]> wrote:

> Hi,
>
> I'm trying to pgAdmin4. I'm able to run pgAdmin4.py in python shell. And
> server runs.And able to access using browser.
>   File
> "/usr/local/lib/python2.7/dist-packages/Werkzeug-0.10.1-py2.7.egg/werkzeug/serving.py",
> line 622, in run_simple
>     reloader_type)
>   File
> "/usr/local/lib/python2.7/dist-packages/Werkzeug-0.10.1-py2.7.egg/werkzeug/_reloader.py",
> line 263, in run_with_reloader
Have you created config_local.py?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com>

*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>

---

From: "Prasad Somwanshi" <[email-masked]>
Date: Thu, 1 Oct 2015 11:09:05 +0200

I think, I did. Is there any specific settings I might have missed there ?

regards,
Prasad

Sent: Thursday, October 01, 2015 at 6:34 AM
From: "Ashesh Vashi" <[email-masked]>
To: "Prasad Somwanshi" <[email-masked]>
Cc: pgadmin-hackers <[email-masked]>
Subject: Re: [pgadmin-hackers] Running pgAdmin4

Hi,

--
Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company[http://www.enterprisedb.com]
 
http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]
regards,
Prasad

--
Sent via pgadmin-hackers mailing list ([email-masked][[email-masked]])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]

---

From: "Prasad Somwanshi" <[email-masked]>
Date: Fri, 2 Oct 2015 08:25:00 +0200

Has anybody encountered this ? Or it's just me ?

regards,
Prasad

Sent: Thursday, October 01, 2015 at 10:09 AM
From: "Prasad Somwanshi" <[email-masked]>
To: pgadmin-hackers <[email-masked]>
Subject: Re: [pgadmin-hackers] Running pgAdmin4
I think, I did. Is there any specific settings I might have missed there ?

regards,
Prasad

Hi,

--
Thanks & Regards,

Ashesh Vashi
 
http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]]
regards,
Prasad

--
Sent via pgadmin-hackers mailing list ([email-masked][[email-masked]])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]]

---

From: Dave Page <[email-masked]>
Date: Fri, 2 Oct 2015 07:54:09 +0100

The desktop runtime hasn't been tested in months afaik, so it's entirely possible something is broken at the moment. It is only PoC code right now.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK:http://www.enterprisedb.com
The Enterprise PostgreSQL Company

> On 2 Oct 2015, at 07:25, Prasad Somwanshi <[email-masked]> wrote:
>

---

From: "Prasad Somwanshi" <[email-masked]>
Date: Fri, 2 Oct 2015 09:13:21 +0200

Ok, in that case, probably it's broken. Error mean, it doesn't like running python code in separate thread.

regards,
Prasad

Sent: Friday, October 02, 2015 at 7:54 AM
From: "Dave Page" <[email-masked]>'t 
To: "Prasad Somwanshi" <[email-masked]>
Cc: pgadmin-hackers <[email-masked]>
Subject: Re: [pgadmin-hackers] Running pgAdmin4

-- 
Dave Page
Blog: http://pgsnake.blogspot.com[http://pgsnake.blogspot.com/]
Twitter: @pgsnake

EnterpriseDB UK:http://www.enterprisedb.com[http://www.enterprisedb.com/]
The Enterprise PostgreSQL Company
On 2 Oct 2015, at 07:25, Prasad Somwanshi <[email-masked][[email-masked]]> wrote:

regards,
Prasad

Sent: Thursday, October 01, 2015 at 10:09 AM
From: "Prasad Somwanshi" <[email-masked][[email-masked]]>
To: pgadmin-hackers <[email-masked][[email-masked]]>
Subject: Re: [pgadmin-hackers] Running pgAdmin4
I think, I did. Is there any specific settings I might have missed there ?

regards,
Prasad

Sent: Thursday, October 01, 2015 at 6:34 AM
From: "Ashesh Vashi" <[email-masked][[email-masked]]>
To: "Prasad Somwanshi" <[email-masked][[email-masked]]>
Cc: pgadmin-hackers <[email-masked][[email-masked]]>
Subject: Re: [pgadmin-hackers] Running pgAdmin4

On Thu, Oct 1, 2015 at 2:19 AM, Prasad Somwanshi <[email-masked][[email-masked]]> wrote:

Hi,

--
Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company[http://www.enterprisedb.com[http://www.enterprisedb.com]]
 
http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]]]
regards,
Prasad

--
Sent via pgadmin-hackers mailing list ([email-masked][[email-masked]][[email-masked][[email-masked]]])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]]]

---

From: "Prasad Somwanshi" <[email-masked]>
Date: Sat, 24 Oct 2015 01:17:37 +0200

It seems , Debug mode and running server in separate thread are not compatible in Flask. And for Debug mode reloader need to be disabled for such case. Othewise it give error. I've modified code to disable reloader in debug mode.

This problem only affects desktop runtime.

thanks and regards,

Prasad Somwanshi

Sent: Friday, October 02, 2015 at 8:13 AM

regards,

Prasad

--

Dave Page

Blog: http://pgsnake.blogspot.com[http://pgsnake.blogspot.com/[http://pgsnake.blogspot.com/]]

Twitter: @pgsnake

EnterpriseDB UK:http://www.enterprisedb.com[http://www.enterprisedb.com][http://www.enterprisedb.com/[http://www.enterprisedb.com/]]

regards,

Prasad

regards,

Prasad

Hi,

reloader_type)

Am I missing something ?

--

Thanks & Regards,

Ashesh Vashi

EnterpriseDB INDIA: Enterprise PostgreSQL Company[http://www.enterprisedb.com[http://www.enterprisedb.com][http://www.enterprisedb.com[http://www.enterprisedb.com]]]

http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]]]]

regards,

Prasad

--

http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]]]]

--

--

--

diff --git a/web/pgAdmin4.py b/web/pgAdmin4.py
index 40ca3ec..556aa5c 100644
--- a/web/pgAdmin4.py
+++ b/web/pgAdmin4.py
@@ -53,9 +53,6 @@ if not os.path.isfile(config.SQLITE_PATH):
 # Create the app!
 app = create_app()
 
-if config.DEBUG:
-    app.debug = True
-
 # Start the web server. The port number should have already been set by the
 # runtime if we're running in desktop mode, otherwise we'll just use the
 # Flask default.
@@ -70,6 +67,10 @@ else:
     server_port = config.DEFAULT_SERVER_PORT
 
 try:
-    app.run(port=server_port)
+# Make sure reloader is disabled in debug mode
+    if config.DEBUG:
+        app.run(port=server_port,debug=True,use_reloader=False)
+    else:
+        app.run(port=server_port)
 except IOError:
     app.logger.error("Error starting the app server: %s", sys.exc_info())

---

From: Ashesh Vashi <[email-masked]>
Date: Sat, 24 Oct 2015 11:15:39 +0530

Hi Prasad,

Please check the current code.

--

Thanks & Regards,

Ashesh Vashi

On Sat, Oct 24, 2015 at 4:47 AM, Prasad Somwanshi <[email-masked]> wrote:

> It seems , Debug mode and running server in separate thread are not
> compatible in Flask. And for Debug mode reloader need to be disabled for
> such case. Othewise it give error. I've modified code to disable reloader
> in debug mode.
> The desktop runtime hasn't been tested in months afaik, so it's entirely
> possible something is broken at the moment. It is only PoC code right now.
>
> --
> Dave Page
> EnterpriseDB UK:http://www.enterprisedb.com[http://www.enterprisedb.com][
> http://www.enterprisedb.com/[http://www.enterprisedb.com/]]
>
> EnterpriseDB INDIA: Enterprise PostgreSQL Company[
> http://www.enterprisedb.com[http://www.enterprisedb.com][
> http://www.enterprisedb.com[http://www.enterprisedb.com]]]
>
> http://www.linkedin.com/in/asheshvashi[
> http://www.linkedin.com/in/asheshvashi][
> http://www.linkedin.com/in/asheshvashi[
> http://www.linkedin.com/in/asheshvashi]][
> http://www.linkedin.com/in/asheshvashi[
> http://www.linkedin.com/in/asheshvashi][
> http://www.linkedin.com/in/asheshvashi[
> http://www.linkedin.com/in/asheshvashi]]][
> http://www.linkedin.com/in/asheshvashi[
> http://www.linkedin.com/in/asheshvashi][
> http://www.linkedin.com/in/asheshvashi[
> http://www.linkedin.com/in/asheshvashi]][
> http://www.linkedin.com/in/asheshvashi[
> http://www.linkedin.com/in/asheshvashi][
> http://www.linkedin.com/in/asheshvashi[
> http://www.linkedin.com/in/asheshvashi]]]]
> regards,
> Prasad
>
>
> --
> Sent via pgadmin-hackers mailing list ([email-masked][
> [email-masked]][[email-masked][
> [email-masked]]])
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers]][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers]]][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers]][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers]]]]
>
>
> --
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers]][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers]]]
>
>
> --
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers][
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers]]
>
>
> --
> http://www.postgresql.org/mailpref/pgadmin-hackers[
> http://www.postgresql.org/mailpref/pgadmin-hackers]
>
>
> --

---

From: "Prasad Somwanshi" <[email-masked]>
Date: Sat, 24 Oct 2015 11:52:16 +0200

Ofcourse, it's fixed now.

thanks,
Prasad

Sent: Saturday, October 24, 2015 at 6:45 AM

Hi Prasad,

--
Thanks & Regards,

Ashesh Vashit's

On Sat, Oct 24, 2015 at 4:47 AM, Prasad Somwanshi <[email-masked][[email-masked]]> wrote:

thanks and regards,
Prasad Somwanshi

regards,
Prasad

From: "Dave Page" <[email-masked][[email-masked]]>'t

-- 
Dave Page
Blog: http://pgsnake.blogspot.com[http://pgsnake.blogspot.com][http://pgsnake.blogspot.com/[http://pgsnake.blogspot.com/][http://pgsnake.blogspot.com/[http://pgsnake.blogspot.com/]]]
Twitter: @pgsnake

EnterpriseDB UK:http://www.enterprisedb.com[http://www.enterprisedb.com][http://www.enterprisedb.com[http://www.enterprisedb.com]][http://www.enterprisedb.com/[http://www.enterprisedb.com/][http://www.enterprisedb.com/[http://www.enterprisedb.com/]]]

The Enterprise PostgreSQL Company
On 2 Oct 2015, at 07:25, Prasad Somwanshi <[email-masked][[email-masked]][[email-masked][[email-masked]]]> wrote:

regards,
Prasad

Sent: Thursday, October 01, 2015 at 10:09 AM
From: "Prasad Somwanshi" <[email-masked][[email-masked]][[email-masked][[email-masked]]]>
To: pgadmin-hackers <[email-masked][[email-masked]][[email-masked][[email-masked]]]>
Subject: Re: [pgadmin-hackers] Running pgAdmin4
I think, I did. Is there any specific settings I might have missed there ?

regards,
Prasad

Sent: Thursday, October 01, 2015 at 6:34 AM
From: "Ashesh Vashi" <[email-masked][[email-masked]][[email-masked][[email-masked]]]>
To: "Prasad Somwanshi" <[email-masked][[email-masked]][[email-masked][[email-masked]]]>
Cc: pgadmin-hackers <[email-masked][[email-masked]][[email-masked][[email-masked]]]>
Subject: Re: [pgadmin-hackers] Running pgAdmin4

On Thu, Oct 1, 2015 at 2:19 AM, Prasad Somwanshi <[email-masked][[email-masked]][[email-masked][[email-masked]]]> wrote:

Hi,

--
Thanks & Regards,

Ashesh VashiEnterpriseDB INDIA: Enterprise PostgreSQL Company[http://www.enterprisedb.com[http://www.enterprisedb.com][http://www.enterprisedb.com[http://www.enterprisedb.com]][http://www.enterprisedb.com[http://www.enterprisedb.com][http://www.enterprisedb.com[http://www.enterprisedb.com]]]]
 
http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]]]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi][http://www.linkedin.com/in/asheshvashi[http://www.linkedin.com/in/asheshvashi]]]]]
regards,
Prasad

--
Sent via pgadmin-hackers mailing list ([email-masked][[email-masked]][[email-masked][[email-masked]]][[email-masked][[email-masked]][[email-masked][[email-masked]]]])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]]]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers][http://www.postgresql.org/mailpref/pgadmin-hackers[http://www.postgresql.org/mailpref/pgadmin-hackers]]]]]