Hi everyone!
I am trying to set up Mapstore2 + Geostore + Geoserver using this mauals:
java - jdk1.8.0_151
geoserver - 2.9.4
postgresql - 9.4
Geostore users, groups and roles are binded with GeoServer
Using Mapstore2 UI i can manage uers and groups, but if i want to edit or delete one of geostore groups, roles, users i get error like this:
On role add:
- org.geoserver.security.validation.RoleServiceException: Role 111 already exists
On geostore group delete
org.apache.wicket.WicketRuntimeException: Method onRequest of interface org.apache.wicket.behavior.IBehaviorListener targeted at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1@754df824 on component [AjaxSubmitLink [Component id = submit]] threw an exception
at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:268)
at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:241)
at org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.invokeListener(ListenerInterfaceRequestHandler.java:248)
at org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.respond(ListenerInterfaceRequestHandler.java:234)
...
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:258)
... 120 more
Caused by: java.lang.RuntimeException: java.io.IOException: org.postgresql.util.PSQLException: ??????: ??????? "id" ?? ??????????
Position: 33
at org.geoserver.security.web.group.SelectionGroupRemovalLink$1.onSubmit(SelectionGroupRemovalLink.java:90)
at org.geoserver.web.wicket.GeoServerDialog.submit(GeoServerDialog.java:169)
at org.geoserver.web.wicket.GeoServerDialog$4.onSubmit(GeoServerDialog.java:184)
at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:110)
at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior$AjaxFormSubmitter.onSubmit(AjaxFormSubmitBehavior.java:215)
at org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1307)
at org.apache.wicket.markup.html.form.Form.process(Form.java:974)
at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:795)
at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:171)
at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:155)
at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:588)
... 124 more
Caused by: java.io.IOException: org.postgresql.util.PSQLException: ??????: ??????? "id" ?? ??????????
Position: 33
at org.geoserver.security.jdbc.JDBCUserGroupStore.removeGroup(JDBCUserGroupStore.java:327)
at org.geoserver.security.validation.UserGroupStoreValidationWrapper.removeGroup(UserGroupStoreValidationWrapper.java:95)
at org.geoserver.security.web.group.SelectionGroupRemovalLink$1.onSubmit(SelectionGroupRemovalLink.java:85)
... 134 more
Caused by: org.postgresql.util.PSQLException: ??????: ??????? "id" ?? ??????????
Position: 33
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:160)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.geoserver.security.jdbc.JDBCUserGroupStore.removeGroup(JDBCUserGroupStore.java:324)
... 136 more
On user delete if user is in geostore group:
org.apache.wicket.WicketRuntimeException: Method onRequest of interface org.apache.wicket.behavior.IBehaviorListener targeted at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1@164472b0 on component [AjaxSubmitLink [Component id = submit]] threw an exception
at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:268)
at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:241)
...
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:258)
... 120 more
Caused by: java.lang.RuntimeException: java.io.IOException: org.postgresql.util.PSQLException: ??????: UPDATE ??? DELETE ? ??????? "gs_user" ???????? ??????????? ???????? ????? "fkfde460db62224f72" ??????? "gs_usergroup_members"
Detail: ?? ???? (id)=(29) ??? ??? ???? ?????? ? ??????? "gs_usergroup_members".
at org.geoserver.security.web.user.SelectionUserRemovalLink$1.onSubmit(SelectionUserRemovalLink.java:93)
at org.geoserver.web.wicket.GeoServerDialog.submit(GeoServerDialog.java:169)
at org.geoserver.web.wicket.GeoServerDialog$4.onSubmit(GeoServerDialog.java:184)
at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:110)
at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior$AjaxFormSubmitter.onSubmit(AjaxFormSubmitBehavior.java:215)
at org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1307)
at org.apache.wicket.markup.html.form.Form.process(Form.java:974)
at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:795)
at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:171)
at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:155)
at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:588)
... 124 more
Caused by: java.io.IOException: org.postgresql.util.PSQLException: ??????: UPDATE ??? DELETE ? ??????? "gs_user" ???????? ??????????? ???????? ????? "fkfde460db62224f72" ??????? "gs_usergroup_members"
Detail: ?? ???? (id)=(29) ??? ??? ???? ?????? ? ??????? "gs_usergroup_members".
at org.geoserver.security.jdbc.JDBCUserGroupStore.removeUser(JDBCUserGroupStore.java:259)
at org.geoserver.security.validation.UserGroupStoreValidationWrapper.removeUser(UserGroupStoreValidationWrapper.java:79)
at org.geoserver.security.web.user.SelectionUserRemovalLink$1.onSubmit(SelectionUserRemovalLink.java:88)
... 134 more
Caused by: org.postgresql.util.PSQLException: ??????: UPDATE ??? DELETE ? ??????? "gs_user" ???????? ??????????? ???????? ????? "fkfde460db62224f72" ??????? "gs_usergroup_members"
Detail: ?? ???? (id)=(29) ??? ??? ???? ?????? ? ??????? "gs_usergroup_members".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:160)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.geoserver.security.jdbc.JDBCUserGroupStore.removeUser(JDBCUserGroupStore.java:245)
... 136 more