Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-05 Thread Shaheed Haque
This issue is tracked here: https://redmine.postgresql.org/issues/4143. On Thu, 4 Apr 2019 at 19:06, Shaheed Haque wrote: > > Thanks for the kind (and quick) replies. My last email crossed with > the ones from Dave and Murtaza... > > On Thu, 4 Apr 2019 at 19:03, Dave Page wrote: > > > > Downgrad

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
Thanks for the kind (and quick) replies. My last email crossed with the ones from Dave and Murtaza... On Thu, 4 Apr 2019 at 19:03, Dave Page wrote: > > Downgrade psycopg2 to 2.7.7 (or whatever came before 2.8). Apparently they > broke backwards compatibility:-( > > -- > Dave Page > Blog: http://

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
On Thu, 4 Apr 2019 at 17:57, Shaheed Haque wrote: > > Woah, rabbithole time... > > On Thu, 4 Apr 2019 at 17:33, Shaheed Haque wrote: > > > > I can login, but when I click on "Servers", nothing happens on screen > > and the error log gets this: > > > > [2019-04-04 16:10:10 +] [5850] [INFO] Sta

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Dave Page
Downgrade psycopg2 to 2.7.7 (or whatever came before 2.8). Apparently they broke backwards compatibility:-( -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK:http://www.enterprisedb.com The Enterprise PostgreSQL Company > On 4 Apr 2019, at 17:33, Shaheed Haque w

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
Woah, rabbithole time... On Thu, 4 Apr 2019 at 17:33, Shaheed Haque wrote: > > I can login, but when I click on "Servers", nothing happens on screen > and the error log gets this: > > [2019-04-04 16:10:10 +] [5850] [INFO] Starting gunicorn 19.9.0 > [2019-04-04 16:10:10 +] [5850] [INFO] Li

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
I can login, but when I click on "Servers", nothing happens on screen and the error log gets this: [2019-04-04 16:10:10 +] [5850] [INFO] Starting gunicorn 19.9.0 [2019-04-04 16:10:10 +] [5850] [INFO] Listening at: unix:/home/ubuntu/pgadmin.sock (5850) [2019-04-04 16:10:10 +] [5850] [IN

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Dave Page
Hi It worked fine when I tested it. If you don't get any errors and you get a login prompt, it should all be good. On Thu, Apr 4, 2019 at 3:01 PM Shaheed Haque wrote: > Hi Dave, > > I'm just migrating to the fixes in 4.4. Can I just double check one > thing? In my original hack, I needed to cre

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
Hi Dave, I'm just migrating to the fixes in 4.4. Can I just double check one thing? In my original hack, I needed to create a link "wsgi.py" -> "pgAdmin4.py", so the the corresponding gunicorn command is something like this: gunicorn ... --bind unix:/.../pgadmin.sock wsgi:application Now, in

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-03-05 Thread Dave Page
You're welcome. Sorry it took so long to realise the main issue was only applicable to Gunicorn! On Mon, Mar 4, 2019 at 6:29 PM Shaheed Haque wrote: > Dave, > > Thanks for taking this forward, I look forward to 4.4! I also noted with > interest that we can use "pgAdmin4:app" rather than my hacky

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-03-04 Thread Shaheed Haque
Dave, Thanks for taking this forward, I look forward to 4.4! I also noted with interest that we can use "pgAdmin4:app" rather than my hacky link to the pgAdmin4.wsgi, so that means a completely hack-free solution :-). Shaheed On Mon, 4 Mar 2019 at 16:33, Dave Page wrote: > Hi > > On Fri, Mar

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-03-04 Thread Dave Page
Hi On Fri, Mar 1, 2019 at 9:30 AM Shaheed Haque wrote: > OK, I got it working. This is how... > > On Mon, 25 Feb 2019 at 23:25, Shaheed Haque wrote: > > > > Hi, > > > > I'm a relative noob when it comes to the world of nginx, wsgi and so > forth, but I do have several other things working (a Dj

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-03-01 Thread Shaheed Haque
OK, I got it working. This is how... On Mon, 25 Feb 2019 at 23:25, Shaheed Haque wrote: > > Hi, > > I'm a relative noob when it comes to the world of nginx, wsgi and so forth, but I do have several other things working (a Django app under gunicorn and the RabbitMQ web UI directly behind nginx). H