Thread: reg. running pgadmin in server mode and automatic login
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
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"
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, AdityaThank 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.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
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.
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 youOn 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"