Re: [Geoserver-users] Geoserver 2.2 beta 1 JDBC authentication

[Hugo <hfp...@gm...>]

Hello Christian,

Thanks a lot for your feedback. In fact, making the changes you have
suggested solves the problems.
Everything is now being written to postgresql. However, after configuring
users/groups/roles and after setting the default role service as the jdbc
role service just created before, i'm no longer able to login in Geoserver
using those users.

When looking into the geoserver.log i can see that geoserver is failing
password authentication for root postgres user (used to define the
connections to the database). Here is the relevant part of the log file:

2012-04-30 11:57:04,423 WARN [org.geoserver] - Error connecting to
'geoauth'. Disabling.
2012-04-30 11:57:04,434 INFO [org.geoserver] -
java.io.IOException
at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:406)
at
org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java:37)
at
org.geoserver.config.GeoServerLoader.readCatalog(GeoServerLoader.java:344)
at
org.geoserver.config.GeoServerLoader.readCatalog(GeoServerLoader.java:222)
at
org.geoserver.config.DefaultGeoServerLoader.loadCatalog(DefaultGeoServerLoader.java:42)
at
org.geoserver.config.GeoServerLoader.postProcessBeforeInitialization(GeoServerLoader.java:116)
at
org.geoserver.config.GeoServerLoaderProxy.postProcessBeforeInitialization(GeoServerLoaderProxy.java:54)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1448)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at
org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:630)
at
org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
at
org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
at
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at
org.geoserver.platform.GeoServerContextLoaderListener.contextInitialized(GeoServerContextLoaderListener.java:18)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
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.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.lang.RuntimeException: Unable to obtain connection: Cannot
create PoolableConnectionFactory (FATAL: password authentication failed for
user "postgres")
at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1663)
at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:833)
at
org.geotools.data.store.ContentDataStore.getTypeNames(ContentDataStore.java:300)
at
org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:114)
at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:366)
... 57 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (FATAL: password authentication failed for user
"postgres")
at
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at
org.geotools.data.jdbc.datasource.AbstractManageableDataSource.getConnection(AbstractManageableDataSource.java:46)
at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1649)
... 61 more
Caused by: org.postgresql.util.PSQLException: FATAL: password
authentication failed for user "postgres"
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 65 more
2012-04-30 11:57:04,620 ERROR [geotools.jdbc] - There's code using JDBC
based datastore and not disposing them. This may lead to temporary loss of
database connections. Please make sure all data access code calls
DataStore.dispose() before freeing all references to it

Is this a bug or something that was not correctly configured?
Thanks once again.
Kind regards,

Hugo

On Sat, Apr 28, 2012 at 8:55 AM, <chr...@nv...> wrote:

> Unfortunately, this is a typo in  the Java code . I opened a jira issue:
>
> https://jira.codehaus.org/**browse/GEOS-5079<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 <hfp...@gm...>:
>
>
>  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 <hfp...@gm...> 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.**GeoServerAnonymousAuthenticati**
>>> onFilter.doFilter(**GeoServerAnonymousAuthenticati**onFilter.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.**
>>> SecurityContextPersistenceFilt**er.doFilter(**
>>> SecurityContextPersistenceFilt**er.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.**GeoServerSecurityFilterChainPr**oxy.doFilter(**
>>> GeoServerSecurityFilterChainPr**oxy.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.
>
>
>


-- 
Hugo Martins