[Geoserver-users] Default roles not derived from JDBC groups to JDBC users

sredl · January 9, 2014, 5:18pm

Hi all,

We have a JDBC UserGroup Service and a Default Role service. Roles are assigned to the groups. This works. But no role is derived from the group to the users - members of the group. Any suggestion?

Thanks a lot,

Michal

Christian_Mueller · January 11, 2014, 10:38am

Hi

Please check if your role service is the current active role service.2) Assure that the group names in the db are identical to the names in the xml file. (roles.xml)

Cheers
Christian

···

On Thu, Jan 9, 2014 at 6:18 PM, <sredl@anonymised.com> wrote:

Hi all,

We have a JDBC UserGroup Service and a Default Role service. Roles are
assigned to the groups. This works. But no role is derived from the
group to the users - members of the group. Any suggestion?

Thanks a lot,

Michal

CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

sredl · January 13, 2014, 3:50pm

Hi Christian,

Dne 2014-01-11 11:38, Christian Mueller napsal:

Hi

1) Please check if your role service is the current active role
service.

Yes.

2) Assure that the group names in the db are identical to the names in
the xml file. (roles.xml)

Yes.

The role IS assigned to the group. (Please check the attateched file 'screenshot_aagroup.png', group name 'aagroup', role name 'ROLE_aagroup')

But the role is not derived to the group members. (Attached file 'screenshot_aagroup_member.png'. In the "Selected Groups" you see that 'aagroup' is selected. But the 'Derived roles' list is empty.)

Thanks a lot,

Michal

Cheers
Christian

On Thu, Jan 9, 2014 at 6:18 PM, <sredl@anonymised.com> wrote:

Hi all,

We have a JDBC UserGroup Service and a Default Role service. Roles
are
assigned to the groups. This works. But no role is derived from the
group to the users - members of the group. Any suggestion?

Thanks a lot,

Michal

------------------------------------------------------------------------------

CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In
Between.
Get a Quote or Start a Free Trial Today.

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

[1]
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users [2]

--

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:
------
[1]
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users

Christian_Mueller · January 14, 2014, 1:26pm

Strange. Can you make a quick check using the default user group service (xml). Not sure if this is a GUI bug.

Cheers
Christian

···

On Mon, Jan 13, 2014 at 4:50 PM, <sredl@anonymised.com> wrote:

Hi Christian,

Dne 2014-01-11 11:38, Christian Mueller napsal:

Hi

Please check if your role service is the current active role
service.

Yes.

Assure that the group names in the db are identical to the names in
the xml file. (roles.xml)

Yes.

The role IS assigned to the group. (Please check the attateched file ‘screenshot_aagroup.png’, group name ‘aagroup’, role name ‘ROLE_aagroup’)

But the role is not derived to the group members. (Attached file ‘screenshot_aagroup_member.png’. In the “Selected Groups” you see that ‘aagroup’ is selected. But the ‘Derived roles’ list is empty.)

Thanks a lot,

Michal

Cheers
Christian

On Thu, Jan 9, 2014 at 6:18 PM, <sredl@anonymised.com> wrote:

Hi all,

We have a JDBC UserGroup Service and a Default Role service. Roles
are
assigned to the groups. This works. But no role is derived from the
group to the users - members of the group. Any suggestion?

Thanks a lot,

Michal

CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In
Between.
Get a Quote or Start a Free Trial Today.

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

[1]

Geoserver-users mailing list
Geoserver-users@anonymised.comsourceforge.net

https://lists.sourceforge.net/lists/listinfo/geoserver-users [2]

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:

[1]
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

sredl · January 14, 2014, 4:56pm

Hi Christian,

when I create group and user in the default usergroup service and assign a role from the default role service, it works fine. When user and group is defined in JDBC and the role is assigned in roles.xml, it fails.

I should note, that the JDBC usergroup service is based on views, not tables, so they are read-only. The roles are assigned by editting the roles.xml.

Thanks a lot,

Michal

Dne 2014-01-14 14:26, Christian Mueller napsal:

Strange. Can you make a quick check using the default user group
service (xml). Not sure if this is a GUI bug.

Cheers
Christian

On Mon, Jan 13, 2014 at 4:50 PM, <sredl@anonymised.com> wrote:

Hi Christian,

Dne 2014-01-11 11:38, Christian Mueller napsal:

Hi

1) Please check if your role service is the current active role
service.

Yes.

2) Assure that the group names in the db are identical to the
names in
the xml file. (roles.xml)

Yes.

The role IS assigned to the group. (Please check the attateched
file 'screenshot_aagroup.png', group name 'aagroup', role name
'ROLE_aagroup')

But the role is not derived to the group members. (Attached file
'screenshot_aagroup_member.png'. In the "Selected Groups" you see
that 'aagroup' is selected. But the 'Derived roles' list is empty.)

Thanks a lot,

Michal

Cheers
Christian

On Thu, Jan 9, 2014 at 6:18 PM, <sredl@anonymised.com> wrote:

Hi all,

We have a JDBC UserGroup Service and a Default Role service. Roles
are
assigned to the groups. This works. But no role is derived from the
group to the users - members of the group. Any suggestion?

Thanks a lot,

Michal

------------------------------------------------------------------------------

CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In
Between.
Get a Quote or Start a Free Trial Today.

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

[1]

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users [2]
[2]

--

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:
------
[1]

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

[1]
[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users
[2]

--

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:
------
[1]
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users

Christian_Mueller · January 15, 2014, 11:47am

View or table makes no difference.

What is the SQL attribute type of your user/group names. Is it CHAR or VARCHAR ?

···

On Tue, Jan 14, 2014 at 5:56 PM, <sredl@anonymised.com> wrote:

Hi Christian,

when I create group and user in the default usergroup service and assign a role from the default role service, it works fine. When user and group is defined in JDBC and the role is assigned in roles.xml, it fails.

I should note, that the JDBC usergroup service is based on views, not tables, so they are read-only. The roles are assigned by editting the roles.xml.

Thanks a lot,

Michal

Dne 2014-01-14 14:26, Christian Mueller napsal:

Strange. Can you make a quick check using the default user group
service (xml). Not sure if this is a GUI bug.

Cheers
Christian

On Mon, Jan 13, 2014 at 4:50 PM, <sredl@anonymised.com> wrote:

Hi Christian,

Dne 2014-01-11 11:38, Christian Mueller napsal:

Hi

Please check if your role service is the current active role
service.

Yes.

Assure that the group names in the db are identical to the
names in
the xml file. (roles.xml)

Yes.

The role IS assigned to the group. (Please check the attateched
file ‘screenshot_aagroup.png’, group name ‘aagroup’, role name
‘ROLE_aagroup’)

But the role is not derived to the group members. (Attached file
‘screenshot_aagroup_member.png’. In the “Selected Groups” you see
that ‘aagroup’ is selected. But the ‘Derived roles’ list is empty.)

Thanks a lot,

Michal

Cheers
Christian

On Thu, Jan 9, 2014 at 6:18 PM, <sredl@anonymised.com> wrote:

Hi all,

We have a JDBC UserGroup Service and a Default Role service. Roles
are
assigned to the groups. This works. But no role is derived from the
group to the users - members of the group. Any suggestion?

Thanks a lot,

Michal

CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In
Between.
Get a Quote or Start a Free Trial Today.

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

[1]
[1]

Geoserver-users mailing list
Geoserver-users@anonymised.comsourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users [2]
[2]

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:

[1]

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

[1]
[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users
[2]

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:

[1]
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

sredl · January 15, 2014, 4:53pm

Hi Christian,

I am very sorry, my fault. The error was in the group view - the groups were not enabled... Now it works fine. Thanks a lot.

Cheers,

Michal

Dne 2014-01-15 12:47, Christian Mueller napsal:

View or table makes no difference.

What is the SQL attribute type of your user/group names. Is it CHAR or
VARCHAR ?

On Tue, Jan 14, 2014 at 5:56 PM, <sredl@anonymised.com> wrote:

Hi Christian,

when I create group and user in the default usergroup service and
assign a role from the default role service, it works fine. When
user and group is defined in JDBC and the role is assigned in
roles.xml, it fails.

I should note, that the JDBC usergroup service is based on views,
not tables, so they are read-only. The roles are assigned by
editting the roles.xml.

Thanks a lot,

Michal

Dne 2014-01-14 14:26, Christian Mueller napsal:

Strange. Can you make a quick check using the default user group
service (xml). Not sure if this is a GUI bug.

Cheers
Christian

On Mon, Jan 13, 2014 at 4:50 PM, <sredl@anonymised.com> wrote:

Hi Christian,

Dne 2014-01-11 11:38, Christian Mueller napsal:

Hi

1) Please check if your role service is the current active role
service.

Yes.

2) Assure that the group names in the db are identical to the
names in
the xml file. (roles.xml)

Yes.

The role IS assigned to the group. (Please check the attateched
file 'screenshot_aagroup.png', group name 'aagroup', role name
'ROLE_aagroup')

But the role is not derived to the group members. (Attached file
'screenshot_aagroup_member.png'. In the "Selected Groups" you see
that 'aagroup' is selected. But the 'Derived roles' list is empty.)

Thanks a lot,

Michal

Cheers
Christian

On Thu, Jan 9, 2014 at 6:18 PM, <sredl@anonymised.com> wrote:

Hi all,

We have a JDBC UserGroup Service and a Default Role service. Roles
are
assigned to the groups. This works. But no role is derived from the
group to the users - members of the group. Any suggestion?

Thanks a lot,

Michal

------------------------------------------------------------------------------

CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In
Between.
Get a Quote or Start a Free Trial Today.

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
[2]

[1]

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users [1]
[2]

--

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:
------
[1]

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
[2]

[1]
[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users
[1]
[2]

--

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:
------
[1]

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
[2]
[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users [1]

--

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:
------
[1] https://lists.sourceforge.net/lists/listinfo/geoserver-users
[2]
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

Christian_Mueller · January 16, 2014, 9:34am

Happy end

Cheers
Christian

···

On Wed, Jan 15, 2014 at 5:53 PM, <sredl@anonymised.com> wrote:

Hi Christian,

I am very sorry, my fault. The error was in the group view - the groups were not enabled… Now it works fine. Thanks a lot.

Cheers,

Michal

Dne 2014-01-15 12:47, Christian Mueller napsal:

View or table makes no difference.

What is the SQL attribute type of your user/group names. Is it CHAR or
VARCHAR ?

On Tue, Jan 14, 2014 at 5:56 PM, <sredl@anonymised.com> wrote:

Hi Christian,

when I create group and user in the default usergroup service and
assign a role from the default role service, it works fine. When
user and group is defined in JDBC and the role is assigned in
roles.xml, it fails.

I should note, that the JDBC usergroup service is based on views,
not tables, so they are read-only. The roles are assigned by
editting the roles.xml.

Thanks a lot,

Michal

Dne 2014-01-14 14:26, Christian Mueller napsal:

Strange. Can you make a quick check using the default user group
service (xml). Not sure if this is a GUI bug.

Cheers
Christian

On Mon, Jan 13, 2014 at 4:50 PM, <sredl@anonymised.com> wrote:

Hi Christian,

Dne 2014-01-11 11:38, Christian Mueller napsal:

Hi

Please check if your role service is the current active role
service.

Yes.

Assure that the group names in the db are identical to the
names in
the xml file. (roles.xml)

Yes.

The role IS assigned to the group. (Please check the attateched
file ‘screenshot_aagroup.png’, group name ‘aagroup’, role name
‘ROLE_aagroup’)

But the role is not derived to the group members. (Attached file
‘screenshot_aagroup_member.png’. In the “Selected Groups” you see
that ‘aagroup’ is selected. But the ‘Derived roles’ list is empty.)

Thanks a lot,

Michal

Cheers
Christian

On Thu, Jan 9, 2014 at 6:18 PM, <sredl@anonymised.com> wrote:

Hi all,

We have a JDBC UserGroup Service and a Default Role service. Roles
are
assigned to the groups. This works. But no role is derived from the
group to the users - members of the group. Any suggestion?

Thanks a lot,

Michal

CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In
Between.
Get a Quote or Start a Free Trial Today.

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

[2]

[1]
[1]

Geoserver-users mailing list
Geoserver-users@anonymised.comsourceforge.net

https://lists.sourceforge.net/lists/listinfo/geoserver-users [1]

[2]
[2]

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:

[1]

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
[2]

[1]
[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users
[1]
[2]

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:

[1]

http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
[2]

[2] https://lists.sourceforge.net/lists/listinfo/geoserver-users [1]

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Links:

[1] https://lists.sourceforge.net/lists/listinfo/geoserver-users
[2]
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH