Re: Importing servers with setup.py --load-servers with the same server group name for multiple users

Hi

On Thu, Feb 21, 2019 at 12:59 PM Henk F. van Til <henk(dot)vantil(at)isp(dot)solcon(dot)nl>
wrote:

> Hi,
>
> We have pgadmin4 version 4.2 installed in server mode so it can be used by
> several people.
>
> When creating an account for a new user, no servers are defined.
>
>
> To setup these servers you can use the import functionality
>
> If you use the example from “
> https://www.pgadmin.org/docs/pgadmin4/dev/export_import_servers.html”
>
> you get the message:
>
> python setup.py --load-servers servers.json --user foo1(at)foo(dot)nl
> <foo(at)foo(dot)nl>
>
> Added 2 Server Group(s) and 2 Server(s).
>
>
> When you use the same json to import for an other user you get the message:
>
> python setup.py --load-servers servers.json --user foo2(at)foo(dot)nl
> <foo(at)foo(dot)nl>
>
> Added 0 Server Group(s) and 2 Server(s).
>
>
> No servers added. The second user does not see the servers, it looks like
> they are not created.
>
> If you use the same json but change the ‘Group’ names it will be imported
> correctly.
>
> So for each users the ‘Group’ names has to be unique.
>
>
> Is there a solution to import the same json import file for multiple users
> and for each user the ‘Group’ names will be the same?
>
>
>
Thanks for the report. I've fixed this for 4.3.

If you want to fix your existing installation, take a backup of the
setup.py file, then edit the original. Find the line (194 in the current
GIT head) that reads:

groups = ServerGroup.query.all()

and change it to:

groups = ServerGroup.query.filter_by(user_id=user_id)

Then find the line (around 254) that reads:

groups = ServerGroup.query.all()

and change it to:

groups = ServerGroup.query.filter_by(user_id=user_id)

You can see the diff at
https://redmine.postgresql.org/projects/pgadmin4/repository/revisions/73b144c45c991340f1b0c4ca70a6457be1fd5feb/diff/web/setup.py.

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

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