> From: seema...@hotmail.com > To: users@tomcat.apache.org > Subject: RE: Upgrade to Tomcat 7 Issues > Date: Mon, 12 Aug 2013 11:09:59 +0100 > > Sorry, I didn't realise it wouls remove the highlighted red. This is what I > have changed from 8080 to 8088: > > <Connector connectionTimeout="20000" port="8088" protocol="HTTP/1.1" > redirectPort="8443"/> > > This is what I have added just above the Host tag/element: > > <Realm className="org.apache.catalina.realm.JNDIRealm" > connectionURL="xxx://xxx:3268" > connectionName="xxx@xxx.local" connectionPassword="xxx" > referrals="follow" userBase="dc=xxx,dc=local" > userSearch="(sAMAccountName={0})" userSubtree="true" > roleBase="dc=xxx,dc=local" roleSearch="(member={0})" > roleName="cn" roleSubtree="true" /> > > Sorry again about that. >
I've added my application.xml file to Tomcat/conf/Catalina/localhost/ directory which contains all the database connection resources. This has removed the error I was getting in my 1st post for today. I now have this error: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.viatel.soportal.helpers.Database.getSopConnection(Database.java:18) at com.viatel.soportal.util.UserUtil.getUser(UserUtil.java:36) at com.viatel.soportal.P1_00Action.portalExecute(P1_00Action.java:60) at com.viatel.soportal.PortalBaseAction.execute(PortalBaseAction.java:200) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.viatel.soportal.RequestFilter.doFilter(RequestFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.viatel.commonlib.ADGroupFilter.doFilter(ADGroupFilter.java:62) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1714) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1559) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420) ... 37 more Do i need to add the my-sql-connector-java-5.0.8-bin jar somewhere? Or do I need to do something else? Thanks > > Date: Mon, 12 Aug 2013 12:05:51 +0200 > > From: a...@ice-sa.com > > To: users@tomcat.apache.org > > Subject: Re: Upgrade to Tomcat 7 Issues > > > > Seema Patel wrote: > > > > > ...> > > > Right, I've re-installed Tomcat 7.0.42. The only things I've changed are > > > in the server.xml file, here is what's in the server.xml file (what I > > > have added/changed are in red, > > > > Not the easiest to spot, for a list which works only with plain text > > messages and strips > > most attachments. > > > > Please check the recommendations in http://tomcat.apache.org/lists.html > > > > > > ... > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > > For additional commands, e-mail: users-h...@tomcat.apache.org > > >