java - centos 5 上的队列计量学

Question

我正在尝试在 centos 5 上安装 queuemetrics，但我的浏览器上不断收到此错误消息:-

"Error JDBC:When opening jdbc:mysql://localhost/queuemetrics?sessionVariables=sql_mode=''&autoReconnect=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude got error:
-- Inner Exception --
- Exception: java.lang.ClassNotFoundException - Error: - com.mysql.jdbc.Driver - Stack trace: - java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
- at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1328)
- at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1175)
- at java.lang.Class.forName0(Native Method) - at java.lang.Class.forName(Class.java:188) - at it.loway.tpf.SQL.openConnection(SQL.java:55) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:545)
- at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:387)
- at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:231)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:618) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:301)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
- 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:503)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:74)
- 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:526)
- at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1017)
- at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:652)
- at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1575)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1533)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
- at java.lang.Thread.run(Thread.java:722) - -- End Inner Exception -- - "

Answer 1

您应该在 WEB-INF/libs 下下载并添加 MySQL JDBC 驱动程序。在 CentOS 下运行时你真正应该做的是:

wget -P /etc/yum.repos.d http://yum.loway.ch/loway.repo
yum install queuemetrics

这将处理所有细节。也可以在这里查看:https://github.com/Loway/QueueMetricsHowTos/blob/master/QueueMetricsInstall.md

QueueMetrics 非常好用，但入门可能需要一些时间。我们已经使用它 5 或 6 年了，对它非常满意。