Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bXOIC-0003Kq-Iz for pgadmin-hackers@arkaria.postgresql.org; Wed, 10 Aug 2016 07:51:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bXOIB-0002bB-Pm for pgadmin-hackers@arkaria.postgresql.org; Wed, 10 Aug 2016 07:51:11 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bXOIA-0002Y2-9z for pgadmin-hackers@postgresql.org; Wed, 10 Aug 2016 07:51:10 +0000 Received: from mail-it0-x22c.google.com ([2607:f8b0:4001:c0b::22c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bXOI7-0005wP-Jb for pgadmin-hackers@postgresql.org; Wed, 10 Aug 2016 07:51:09 +0000 Received: by mail-it0-x22c.google.com with SMTP id u186so32446101ita.0 for ; Wed, 10 Aug 2016 00:51:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=K2ftIj+vvkWoPUd9suxLluzlIAX+UC2GFIUD5AmpPUo=; b=jRPIxDVRJD6NVJWIoVI72KGkOecgLhrB574ioaiNCYk7ZX6ZDKcLevNDUVcZbubjKj fovV0RPu0LY2gKFsr+LodlgAcCXCJYwI6sJSK2mQGJcK0oWLrFj7+yz8+OlFNnM40QD3 LBbNbaXsqCVGSE0dMNnckanybOmVYkoS+zue5ojacaeRRH5SkeAocJwv3mwUcb6BIGBK zXSe4a0hVoenvmwxFsGZt10puLCMo5C7+0eqBWXfhBdZZG3xma8nfSuGOAMVOgn45PYd iV0+pcKAvegSlJCo0Jou5lVk9mJDktJ3k99c2N66Qykwqoht3LqcswLc+vu0HpljPgZT 5xFA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=K2ftIj+vvkWoPUd9suxLluzlIAX+UC2GFIUD5AmpPUo=; b=R0NAiQiQZb4UfQnH7rMZJDFOrJfPAGvQT/lhhMcNz4n4cQ0oM1gKD/G+LpKNggYRnE k6ueXgbiiViXab/LDpJsWf1QndlCwXRec76ZtGnDzK8YNoQaiKKLGvqt5rGfEwpyiN4I WNfjOhH+bB3Ofqt2GsPn9LdHSndakdpwBAmBMjwgc7JOsGIGYcnrDV3V0ne7cOFvk4ym o75gYKpEcY2vMPUbxJRTpRzE0JOxmZO3oMQkVIPQ9ZZ9sO1J4QkTq6EFv4KmoDFxskvy uBDXMQzGPkOnecT8yhADZfvhFryeFDhQ3oWK/7BC6Si10xd+FjHg/7cm+gnW2LFBrOIh NcIA== X-Gm-Message-State: AEkoouub6JuR1EMikEdELuEhyKFeM1htNM60TvSx5s9toU9vb6UlfeOr40GDazOzAlhLtHp0JQ4NVsfLiyMBfez4 X-Received: by 10.36.54.135 with SMTP id l129mr1650573itl.73.1470815466498; Wed, 10 Aug 2016 00:51:06 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.6.76 with HTTP; Wed, 10 Aug 2016 00:50:46 -0700 (PDT) In-Reply-To: References: From: Ashesh Vashi Date: Wed, 10 Aug 2016 13:20:46 +0530 Message-ID: Subject: Re: pgAdmin 4 as Web application To: Albe Laurenz Cc: "Dave Page *EXTERN*" , "pgadmin-hackers@postgresql.org" Content-Type: multipart/alternative; boundary=001a1143f352698aa30539b2e984 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --001a1143f352698aa30539b2e984 Content-Type: text/plain; charset=UTF-8 On Wed, Aug 10, 2016 at 12:58 PM, Albe Laurenz wrote: > Dave Page wrote: > >> There is no file "pgAdmin4.wsgi" available for download. > >> Did I miss something obvious? > > > > Hmm, no - looks like we did. I know people have been testing in web > > mode, so I wonder how this got missed! > > > > I don't have time to test right now, but I believe something like the > > following one liner should suffice as your wsgi file: > > > > from pgAdmin4 import app as application > > > > Make sure that's in the same directory as pgAdmin4.py (the web/ > > directory in the source tree), then point your Apache config to it. > > > > If you need any further quick hints (I'm going offline for the rest of > > the day in a minute), this may help: > > http://flask.pocoo.org/docs/0.11/deploying/mod_wsgi/ - but do pay > > close attention to the comments on threads/prcesses in the pgAdmin > > docs. > > > > Please let me know if it works. > > Thanks, that was very helpful indeed. > > I had to put more stuff into the wsgi file, probably because my > installation > is in some nonstandard location: > > import sys > sys.path.insert(0, '/home/laurenz/rpmbuild/pgadmin4-1.0-beta3/web') > from pgAdmin4 import app as application > > Now I'm getting to the same error as with the standalone version, see > https://www.postgresql.org/message-id/A737B7A37273E048B164557ADEF4A5 > 8B5388C035%40ntex2010i.host.magwien.gv.at Looks like the Python 2.6 compatibility has been broken. For now - can you use Python 2.7/3? -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi* > > > It would be good to improve the documentation for "Server deployment". > It should be mentioned that you don't need the binaries for that, and that > the "web" subdirectory contains all you need. > > > -- > Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-hackers > --001a1143f352698aa30539b2e984 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

On Wed, Aug 10, 2016 at 12:58 PM, A= lbe Laurenz <laurenz.albe@wien.gv.at> wrote:

Dave Page wrote:
>> There is no file "pgAdmin4.wsgi" available for download.=
>> Did I miss something obvious?
>
> Hmm, no - looks like we did. I know people have been testing in web > mode, so I wonder how this got missed!
>
> I don't have time to test right now, but I believe something like = the
> following one liner should suffice as your wsgi file:
>
> from pgAdmin4 import app as application
>
> Make sure that's in the same directory as pgAdmin4.py (the web/ > directory in the source tree), then point your Apache config to it. >
> If you need any further quick hints (I'm going offline for the res= t of
> the day in a minute), this may help:
> http://flask.pocoo.org/docs/0.11/dep= loying/mod_wsgi/ - but do pay
> close attention to the comments on threads/prcesses in the pgAdmin
> docs.
>
> Please let me know if it works.

Thanks, that was very helpful indeed.

I had to put more stuff into the wsgi file, probably because my installatio= n
is in some nonstandard location:

=C2=A0 =C2=A0import sys
=C2=A0 =C2=A0sys.path.insert(0, '/home/laurenz/rpmbuild/pgadmin4-1= .0-beta3/web')
=C2=A0 =C2=A0from pgAdmin4 import app as application

Now I'm getting to the same error as with the standalone version= , see
https://www.postgresql.org/message-id/A737B7A37273E048B1= 64557ADEF4A58B5388C035%40ntex2010i.host.magwien.gv.at
Looks like the Python 2.6 compatibility has been broken.

For now - can you use Python 2.7/3?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA:=C2=A0Enterprise PostgreSQL Company


http://www.linkedin.com/in/ashes= hvashi



It would be good to improve the documentation for "Server deployment&q= uot;.
It should be mentioned that you don't need the binaries for that, and t= hat
the "web" subdirectory contains all you need.


--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-ha= ckers

--001a1143f352698aa30539b2e984--