Well, it seems the mysql connector is there already, otherwise, SC would not even get started, because the datasource used for Userstore is initialized at the startup..
But the datasource / connection details defined for Cartridge subscription schema is not initialized at server startup, so I think this error comes because of some misconfiguration in database parameters related to cartridge subscription schema.. As I remember we recently moved those configuration to *-datasources.xml file.. didn't we? On Fri, Aug 30, 2013 at 11:42 AM, Isuru Haththotuwa <[email protected]> wrote: > Hi Manula, > > Please check if you have the mysql connector jar (mysql-connector-java v. > 5.1.25) in the repository/components/lib of Stratos Controller. If not you > need to put it there. > > > On Sat, Aug 31, 2013 at 12:03 AM, Manula Chathurika Thantriwatte < > [email protected]> wrote: > >> >> Hi, >> >> I'm getting following error when subscribing a cartridge in ec2 with >> updated carbon packs. >> >> >> [2013-08-30 18:28:17,180] ERROR >> {org.apache.stratos.adc.mgt.service.ApplicationManagementService} - Error >> when getting subscribed cartridges. com.mysql.jdbc.Driver >> java.sql.SQLException: com.mysql.jdbc.Driver >> at >> org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:254) >> at >> org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182) >> at >> org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702) >> at >> org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634) >> at >> org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:488) >> at >> org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144) >> at >> org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116) >> at >> org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103) >> at >> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127) >> at >> org.apache.stratos.adc.mgt.utils.StratosDBUtils.getConnection(StratosDBUtils.java:130) >> at >> org.apache.stratos.adc.mgt.utils.PersistenceManager.retrieveSubscribedCartridges(PersistenceManager.java:170) >> at >> org.apache.stratos.adc.mgt.service.ApplicationManagementService.getSubscribedCartridges(ApplicationManagementService.java:234) >> at >> org.apache.stratos.adc.mgt.service.ApplicationManagementService.getPagedSubscribedCartridges(ApplicationManagementService.java:212) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at >> org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:212) >> at >> org.apache.axis2.rpc.receivers.RPCMessageReceiver.invokeBusinessLogic(RPCMessageReceiver.java:117) >> at >> org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40) >> at >> org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110) >> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) >> at >> org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:169) >> at >> org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:82) >> at >> org.wso2.carbon.core.transports.local.CarbonLocalTransportSender.finalizeSendWithToAddress(CarbonLocalTransportSender.java:45) >> at >> org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:77) >> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) >> at >> org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:398) >> at >> org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:224) >> at >> org.apache.axis2.client.OperationClient.execute(OperationClient.java:149) >> at >> org.apache.stratos.adc.mgt.stub.ApplicationManagementServiceStub.getPagedSubscribedCartridges(ApplicationManagementServiceStub.java:3142) >> at >> org.apache.stratos.cartridge.mgt.ui.CartridgeAdminClient.getPagedSubscribedCartridges(CartridgeAdminClient.java:95) >> at >> org.apache.jsp.cartridge_002dmgt.subscribed_005fcartridges_005fajaxprocessor_jsp._jspService(org.apache.jsp.cartridge_002dmgt.subscribed_005fcartridges_005fajaxprocessor_jsp:118) >> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:403) >> at >> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:492) >> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:378) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:155) >> at org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:80) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:37) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749) >> at >> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487) >> at >> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412) >> at >> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339) >> at >> org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:30) >> at >> org.apache.stratos.redirector.servlet.ui.filters.AllPagesFilter.doFilter(AllPagesFilter.java:159) >> at >> org.eclipse.equinox.http.helper.FilterServletAdaptor.service(FilterServletAdaptor.java:37) >> at >> org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) >> at >> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >> at >> org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at >> org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61) >> 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:472) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:177) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:161) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >> at java.lang.Thread.run(Thread.java:662) >> >> >> -- >> Regards, >> Manula Chathurika Thantriwatte >> Software Engineer >> WSO2 Inc. : http://wso2.com >> lean . enterprise . middleware >> >> email : [email protected] / [email protected] >> phone : +94 772492511 >> blog : http://manulachathurika.blogspot.com/ >> >> >> >> >> >> >> >> >> >> > > > -- > Thanks and Regards, > > Isuru H. > > > -- *Sajith Kariyawasam* *Senior Software Engineer; WSO2, Inc.* *AMIE (SL)* *Blog: http://sajithblogs.blogspot.com/* *Mobile: +94772269575*
