Unfortunately, this is a typo in the Java code . I opened a jira issue: https://jira.codehaus.org/browse/GEOS-5079, the fix will be in beta 2.
Look at the edit page of your jdbc user/group service. There are two entry fields: 1) Data Definition Language (DDL) file 2) Data Manipulation Language (DML) file Both of them have the value "usersddl.xml". This is correct for 1) but the content for 2) has to be "usersdml.xml". Please correct 2), store your config and you should be able to work with your groupservice. The same problem exists for the jdbc role service. The only work around I can offer is to: 1) Go to your Geoserver Data Dir 2) Assuming your service is called "myroles", please open the file role/myroles/config.xml 3) Search for <propertyFileNameDML>rolesddl.xml</propertyFileNameDML and change to rolesdml.xml Hope that helps Cheers Christian Zitat von Hugo <[email protected]>: > Hello all, > > Just tried to repeat the same process but using JNDI instead. Nevertheless, > i get the same error when trying to add a new user, or a new role. > > Any hints/help are welcome :) > Kind regards, > Hugo > > On Fri, Apr 27, 2012 at 12:08 PM, Hugo <[email protected]> wrote: > >> Hello all, >> >> I'm testing the beta version of Geoserver 2.2 and specifically, all new >> things related with authentication and user login. I'm particularly >> interested in using postgresql jdbc for these purposes but i'm having some >> problems. >> >> I was able to create a User/Group Service, a Role Service and >> Authentication Provider (using >> jdbc:postgresql://localhost:5432/mydatabase). I've checked postgresql and >> all the tables were correclty created. However, if i try to edit the >> User/Group Service and then go to the users or group tabs i get the >> following errors which will not allow to add a new user: >> >> org.apache.wicket.WicketRuntimeException: Method onLinkClicked of >> interface org.apache.wicket.markup.html.link.ILinkListener targeted at >> component [MarkupContainer [Component id = link]] threw an exception at >> org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:193) >> at >> org.apache.wicket.request.target.component.listener.ListenerInterfaceRequestTarget.processEvents(ListenerInterfaceRequestTarget.java:73) >> at >> org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92) >> at >> org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250) >> at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329) at >> org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436) at >> org.apache.wicket.RequestCycle.request(RequestCycle.java:545) at >> org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484) >> at >> org.apache.wicket.protocol.http.WicketServlet.doGet(WicketServlet.java:138) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at >> org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:159) >> at >> org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) >> at >> org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) >> at >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) >> at >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) >> at >> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) >> at >> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74) >> at >> org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68) >> at >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) >> at >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68) >> at >> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) >> at >> org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:53) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68) >> at >> org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68) >> at >> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72) >> at >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) >> at >> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) >> at >> org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:96) >> at >> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) >> at >> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71) at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41) at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:46) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) >> at >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) >> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >> at java.lang.Thread.run(Unknown Source) Caused by: >> java.lang.reflect.InvocationTargetException at >> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at >> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at >> java.lang.reflect.Method.invoke(Unknown Source) at >> org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:182) >> ... 83 more Caused by: java.lang.RuntimeException: java.io.IOException: No >> sql statement for key : users.all at >> org.geoserver.security.web.user.UserListProvider.getItems(UserListProvider.java:161) >> at >> org.geoserver.web.wicket.GeoServerDataProvider.fullSize(GeoServerDataProvider.java:226) >> at >> org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.updateMatched(GeoServerTablePanel.java:522) >> at >> org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.<init>(GeoServerTablePanel.java:515) >> at >> org.geoserver.web.wicket.GeoServerTablePanel.<init>(GeoServerTablePanel.java:200) >> at >> org.geoserver.security.web.user.UserTablePanel.<init>(UserTablePanel.java:29) >> at org.geoserver.security.web.user.UserPanel$1.<init>(UserPanel.java:55) at >> org.geoserver.security.web.user.UserPanel.<init>(UserPanel.java:55) at >> org.geoserver.security.web.usergroup.UserGroupServicePanel$1.getPanel(UserGroupServicePanel.java:48) >> at >> org.apache.wicket.extensions.markup.html.tabs.TabbedPanel.setSelectedTab(TabbedPanel.java:356) >> at >> org.apache.wicket.extensions.markup.html.tabs.TabbedPanel$5.onClick(TabbedPanel.java:324) >> at org.apache.wicket.markup.html.link.Link.onLinkClicked(Link.java:224) ... >> 88 more Caused by: java.io.IOException: No sql statement for key : >> users.all at >> org.geoserver.security.jdbc.AbstractJDBCService.getJDBCStatement(AbstractJDBCService.java:175) >> at >> org.geoserver.security.jdbc.AbstractJDBCService.getDMLStatement(AbstractJDBCService.java:157) >> at >> org.geoserver.security.jdbc.JDBCUserGroupService.getUsers(JDBCUserGroupService.java:233) >> at >> org.geoserver.security.web.user.UserListProvider.getItems(UserListProvider.java:158) >> >> Is this a bug or something i'm doing wrong? I have Geoserver 2.2 beta1 >> deployed under Tomcat 6 in a windows 7 machine. >> Kind regards, >> >> -- >> Hugo Martins >> >> > > > -- > Hugo Martins > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
