Hi Paul The Jdbc authentication provider has nothing to do with a Jdbc user group service.
The Jdbc authentication provider wants an existing Oracle user and not a user contained in your user/group service. Try to remove the provider and use the default provider. Cheers Christian On Tue, Sep 13, 2016 at 10:34 AM, Paul Wittle <p.wit...@dorsetcc.gov.uk> wrote: > Hi, > > > > I do have one but it works and is needed isn't it? My appsJDBC is linked > to a user group service called application_users which works and provides a > load of users to the application. These appear fine and when you test the > connection on the application users it says it is fine. > > > > There is an option to test the connection with a username and password but > it doesn't store those credentials. > > > > I currently run a provider chain that goes appsJDBC (which runs Authkey) > then default. My understanding is that if I delete the authentication > provider then Authkey would stop working. > > > > It seems odd to have a username and password error for a section of the > GeoServer which, as far as I can see, has nowhere to actually store any > username and password? > > > > Thanks, > > Paul > > > > *From:* Christian Mueller [mailto:christian.muel...@os-solutions.at] > *Sent:* 13 September 2016 09:03 > *To:* Paul Wittle > *Cc:* geoserver-users@lists.sourceforge.net > *Subject:* Re: [Geoserver-users] Understanding stack traces > > > > Hi > > > > Go to "Authentication", I think you will se a JDBC Authentication Provider > at the bottom of the page. Try to delete it. > > > > Cheers > > Chrilstian > > > > On Tue, Sep 13, 2016 at 9:47 AM, Paul Wittle <p.wit...@dorsetcc.gov.uk> > wrote: > > Hi folks, > > > > I get this error message frequently but everything seems to work. I assume > it is related to an old setting I no longer need but it does clog up the > log files. > > > > Is there any clue in this stack trace that would let me know which bit of > the data directory I should be looking in to find the incorrect login > details? > > > > WARN [geoserver.security] - JDBC connect error > > org.springframework.security.authentication.AuthenticationServiceException: > JDBC connect error > > at org.geoserver.security.jdbc.JDBCConnectAuthProvider. > authenticate(JDBCConnectAuthProvider.java:95) > > at org.geoserver.security.GeoServerAuthenticationProvide > r.authenticate(GeoServerAuthenticationProvider.java:58) > > at org.springframework.security.authentication. > ProviderManager.authenticate(ProviderManager.java:156) > > at org.springframework.security.web.authentication.www. > BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:168) > > at org.geoserver.security.filter.GeoServerCompositeFilter$ > NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73) > > at org.geoserver.security.filter.GeoServerCompositeFilter. > doFilter(GeoServerCompositeFilter.java:92) > > at org.geoserver.security.filter. > GeoServerBasicAuthenticationFilter.doFilter(GeoServerBasicAuthenticationFi > lter.java:83) > > at org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:323) > > at org.geoserver.security.filter.GeoServerCompositeFilter$ > NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69) > > at org.springframework.security.web.context. > SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt > er.java:87) > > at org.geoserver.security.filter. > GeoServerSecurityContextPersistenceFilter$1.doFilter( > GeoServerSecurityContextPersistenceFilter.java:53) > > at org.geoserver.security.filter.GeoServerCompositeFilter$ > NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73) > > at org.geoserver.security.filter.GeoServerCompositeFilter. > doFilter(GeoServerCompositeFilter.java:92) > > 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(GeoServerSecurityFilterChainProxy.java:135) > > 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:239) > > at org.apache.catalina.core.ApplicationFilterChain. > doFilter(ApplicationFilterChain.java:206) > > at org.geoserver.filters.LoggingFilter.doFilter( > LoggingFilter.java:87) > > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:239) > > at org.apache.catalina.core.ApplicationFilterChain. > doFilter(ApplicationFilterChain.java:206) > > at org.geoserver.filters.GZIPFilter.doFilter( > GZIPFilter.java:48) > > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:239) > > at org.apache.catalina.core.ApplicationFilterChain. > doFilter(ApplicationFilterChain.java:206) > > at org.geoserver.filters.SessionDebugFilter.doFilter( > SessionDebugFilter.java:48) > > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:239) > > at org.apache.catalina.core.ApplicationFilterChain. > doFilter(ApplicationFilterChain.java:206) > > at org.geoserver.filters.FlushSafeFilter.doFilter( > FlushSafeFilter.java:44) > > at org.apache.catalina.core.ApplicationFilterChain. > internalDoFilter(ApplicationFilterChain.java:239) > > 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:239) > > at org.apache.catalina.core.ApplicationFilterChain. > doFilter(ApplicationFilterChain.java:206) > > at org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:219) > > at org.apache.catalina.core.StandardContextValve.invoke( > StandardContextValve.java:106) > > at org.apache.catalina.authenticator. > AuthenticatorBase.invoke(AuthenticatorBase.java:501) > > at org.apache.catalina.core.StandardHostValve.invoke( > StandardHostValve.java:142) > > at org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:79) > > at org.apache.catalina.valves. > AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610) > > at org.apache.catalina.core.StandardEngineValve.invoke( > StandardEngineValve.java:88) > > at org.apache.catalina.connector.CoyoteAdapter.service( > CoyoteAdapter.java:537) > > at org.apache.coyote.http11.AbstractHttp11Processor. > process(AbstractHttp11Processor.java:1085) > > at org.apache.coyote.AbstractProtocol$ > AbstractConnectionHandler.process(AbstractProtocol.java:658) > > at org.apache.coyote.http11.Http11AprProtocol$ > Http11ConnectionHandler.process(Http11AprProtocol.java:277) > > at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor. > doRun(AprEndpoint.java:2407) > > at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor. > run(AprEndpoint.java:2396) > > at java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1145) > > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:615) > > at org.apache.tomcat.util.threads.TaskThread$ > WrappingRunnable.run(TaskThread.java:61) > > at java.lang.Thread.run(Thread.java:745) > > Caused by: java.sql.SQLException: ORA-01017: invalid username/password; > logon denied > > > > at oracle.jdbc.driver.T4CTTIoer. > processError(T4CTTIoer.java:447) > > at oracle.jdbc.driver.T4CTTIoer. > processError(T4CTTIoer.java:389) > > at oracle.jdbc.driver.T4CTTIoer. > processError(T4CTTIoer.java:382) > > at oracle.jdbc.driver.T4CTTIfun. > processError(T4CTTIfun.java:675) > > at oracle.jdbc.driver.T4CTTIoauthenticate.processError( > T4CTTIoauthenticate.java:448) > > at oracle.jdbc.driver.T4CTTIfun. > receive(T4CTTIfun.java:513) > > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > > at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH( > T4CTTIoauthenticate.java:383) > > at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH( > T4CTTIoauthenticate.java:776) > > at oracle.jdbc.driver.T4CConnection.logon( > T4CConnection.java:432) > > at oracle.jdbc.driver.PhysicalConnection.<init>( > PhysicalConnection.java:553) > > at oracle.jdbc.driver.T4CConnection.<init>( > T4CConnection.java:254) > > at oracle.jdbc.driver.T4CDriverExtension.getConnection( > T4CDriverExtension.java:32) > > at oracle.jdbc.driver.OracleDriver.connect( > OracleDriver.java:528) > > at java.sql.DriverManager.getConnection(DriverManager. > java:571) > > at java.sql.DriverManager.getConnection(DriverManager. > java:215) > > at org.geoserver.security.jdbc.JDBCConnectAuthProvider. > authenticate(JDBCConnectAuthProvider.java:90) > > ... 51 more > > > > Best Regards, > > > > Paul Wittle > > GIS Developer > > Ext: 710 8473 > > Tel: 01305 228473 > > > > "This e-mail is intended for the named addressee(s) only and may contain > information about individuals or other sensitive information and should be > handled accordingly. Unless you are the named addressee (or authorised to > receive it for the addressee) you may not copy or use it, or disclose it to > anyone else. If you have received this email in error, kindly disregard the > content of the message and notify the sender immediately. Please be aware > that all email may be subject to recording and/or monitoring in accordance > with relevant legislation." > > > ------------------------------------------------------------ > ------------------ > > _______________________________________________ > 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 > > > "This e-mail is intended for the named addressee(s) only and may contain > information about individuals or other sensitive information and should be > handled accordingly. Unless you are the named addressee (or authorised to > receive it for the addressee) you may not copy or use it, or disclose it to > anyone else. If you have received this email in error, kindly disregard the > content of the message and notify the sender immediately. Please be aware > that all email may be subject to recording and/or monitoring in accordance > with relevant legislation." > -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
