Hi guys, I just got tomcat and openbd working on my mac. Next step, setting up datasource to test mysql connectivity.
I know my mysql is working, as I use it with CF and can access it via terminal as well. Problem is, When I set up the datasource in the openbd admin, i get the following error: Could not verify datasource: Server connection failure during transaction. Due to underlying exception: 'java.net.ConnectException: Connection refused'. ** BEGIN NESTED EXCEPTION ** java.net.ConnectException MESSAGE: Connection refused STACKTRACE: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:432) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect (Socket.java:469) at java.net.Socket.(Socket.java:366) at java.net.Socket.(Socket.java:209) at com.mysql.jdbc.StandardSocketFactory.connect (StandardSocketFactory.java:256) at com.mysql.jdbc.MysqlIO. (MysqlIO.java:271) at com.mysql.jdbc.Connection.createNewIO (Connection.java:2894) at com.mysql.jdbc.Connection.(Connection.java: 1553) at com.mysql.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java:285) at java.sql.DriverManager.getConnection (DriverManager.java:582) at java.sql.DriverManager.getConnection (DriverManager.java:185) 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 com.naryx.tagfusion.cfm.engine.cfJavaObjectData.invokeMethod(Unknown Source) at com.naryx.tagfusion.cfm.engine.cfJavaObjectData.getJavaData (Unknown Source) at com.naryx.tagfusion.expression.compile.cfFullVarExpression.Eval (Unknown Source) at com.naryx.tagfusion.expression.compile.cfFullVarExpression.evalNatural (Unknown Source) at com.naryx.tagfusion.expression.compile.cfFullVarExpression.Eval (Unknown Source) at com.naryx.tagfusion.expression.compile.CFAssignmentExpression.Eval (Unknown Source) at com.naryx.tagfusion.expression.compile.runTime.run (Unknown Source) at com.naryx.tagfusion.expression.compile.runTime.runExpression(Unknown Source) at com.naryx.tagfusion.expression.compile.runTime.runExpression (Unknown Source) at com.naryx.tagfusion.cfm.tag.cfSET.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTRY.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfSWITCH.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.renderToString(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfFUNCTION.realRun(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfFUNCTION.run(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfFUNCTION.run(Unknown Source) at com.naryx.tagfusion.cfm.script.userDefinedFunction.execute(Unknown Source) at com.naryx.tagfusion.cfm.engine.cfComponentData.invokeComponentFunction (Unknown Source) at com.naryx.tagfusion.cfm.engine.cfComponentData.invokeComponentFunction (Unknown Source) at com.naryx.tagfusion.expression.compile.cfFullVarExpression.Eval (Unknown Source) at com.naryx.tagfusion.expression.compile.cfFullVarExpression.evalNatural (Unknown Source) at com.naryx.tagfusion.expression.compile.cfFullVarExpression.Eval (Unknown Source) at com.naryx.tagfusion.expression.compile.CFAssignmentExpression.Eval (Unknown Source) at com.naryx.tagfusion.expression.compile.runTime.run (Unknown Source) at com.naryx.tagfusion.expression.compile.runTime.runExpression(Unknown Source) at com.naryx.tagfusion.expression.compile.runTime.runExpression (Unknown Source) at com.naryx.tagfusion.cfm.tag.cfSET.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTRY.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfLOOP.renderIndex(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfLOOP.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfSWITCH.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.renderToString(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfSILENT.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source) at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source) at com.naryx.tagfusion.cfm.engine.cfSession.onRequest(Unknown Source) at com.naryx.tagfusion.cfm.engine.cfEngine.service(Unknown Source) at com.naryx.tagfusion.cfm.cfServlet.service(Unknown Source) 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.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:128) 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:849) at org.apache.coyote.http11.Http11Protocol $Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 454) at java.lang.Thread.run(Thread.java:637) ** END NESTED EXCEPTION ** Attempted reconnect 3 times. Giving up. Not sure what that means, but it seems some sort of security issue. I have tomcat in /Library/Tomcat/webapps/openbd/... My mysql is local, so it should be localhost:3306. Not sure what else to do. Help guys --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
