Thread: reg. running pgadmin in server mode and automatic login

reg. running pgadmin in server mode and automatic login

From
Sindhu S
Date:
hi, 

How can I run pgadmin4 in server mode and still have automatic login?

I have currently managed to run it in server mode by adding config_local.py in /web of the dmg I downloaded. 

My use case is that I develop using pgadmin and would not like to switch between apps and hence want pgadmin running as a server so that I can access it in the browser. Am the only user of this server mode and so would like it to automatically login. 

Thank you,

Sindhu

Re: reg. running pgadmin in server mode and automatic login

From
Aditya Toshniwal
Date:
Hi Sindhu,

You can open pgAdmin normally, go to File->Runtime->View log and find and copy the Application Server URL like: http://127.0.0.1:51250/?key=5c171d34-c329-4288-9db6-f3047302f5e4.
Until you close pgAdmin, the url will work in any browser. No changes need to be made.

On Wed, Sep 29, 2021 at 10:46 AM Sindhu S <sindhu@bytebeam.io> wrote:
hi, 

How can I run pgadmin4 in server mode and still have automatic login?

I have currently managed to run it in server mode by adding config_local.py in /web of the dmg I downloaded. 

My use case is that I develop using pgadmin and would not like to switch between apps and hence want pgadmin running as a server so that I can access it in the browser. Am the only user of this server mode and so would like it to automatically login. 

Thank you,

Sindhu


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"

Re: reg. running pgadmin in server mode and automatic login

From
Aditya Toshniwal
Date:
Hi Sindhu,

You can see the runtime options only when you run it in desktop mode as they're irrelevant when in browser.

On Thu, Sep 30, 2021 at 3:26 PM Sindhu S <sindhu@bytebeam.io> wrote:
hi, Aditya
Thank you for the quick response. 
On Wed, 29 Sept 2021 at 18:07, Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Sindhu,

You can open pgAdmin normally, go to File->Runtime->View log and find and copy the Application Server URL like: http://127.0.0.1:51250/?key=5c171d34-c329-4288-9db6-f3047302f5e4.
Until you close pgAdmin, the url will work in any browser. No changes need to be made.
Screenshot 2021-09-30 at 3.25.46 PM.png

I do not see the Runtime menu option under File. What am I missing?

-Sindhu
 


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"
Attachment

Re: reg. running pgadmin in server mode and automatic login

From
Sindhu S
Date:
Reposting because I missed asking the mailing list. Please see quoted mail.
Thank you

On Thu, 30 Sept 2021 at 16:31, Sindhu S <sindhu@bytebeam.io> wrote:
hi, 

The url (http://127.0.0.1:5050/?key=23ef84fc-f2c9-4b80-ab29-f55246800cca) changes every time pgadmin4 app is run. I do not want this. I want to be able to make:

1.pgadmin4 to run in server mode always (done by adding config)
2. pgadmin4 to have automatic login when running as server. 

For 2, I took a look at the code inside in /web dir, it should be possible to make a change in the routing logic to have server take "DESKTOP_USER" credentials. I can't tell exactly where to make this change though. 

Re: reg. running pgadmin in server mode and automatic login

From
Aditya Toshniwal
Date:
Hi Sindhu,

The URL will change and the key is passed as a security key for the runtime desktop app.
You can use the python wheel package of pgAdmin - https://www.pgadmin.org/download/pgadmin-4-python/ and configure it as per your requirement.

On Wed, Oct 13, 2021 at 8:20 PM Sindhu S <sindhu@bytebeam.io> wrote:
Reposting because I missed asking the mailing list. Please see quoted mail.
Thank you

On Thu, 30 Sept 2021 at 16:31, Sindhu S <sindhu@bytebeam.io> wrote:
hi, 

The url (http://127.0.0.1:5050/?key=23ef84fc-f2c9-4b80-ab29-f55246800cca) changes every time pgadmin4 app is run. I do not want this. I want to be able to make:

1.pgadmin4 to run in server mode always (done by adding config)
2. pgadmin4 to have automatic login when running as server. 

For 2, I took a look at the code inside in /web dir, it should be possible to make a change in the routing logic to have server take "DESKTOP_USER" credentials. I can't tell exactly where to make this change though. 


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"