My problem though is, I am not sure on Mac Leopard how to change the tcp-ip settings for mysql. Im guessing something to do with my.cnf, but not sure, tried googling but not getting something direct. I have tried bluedragon today on another mac machine with mysql and it worked without any extra configuration mind you.
Thanks for any help On Jul 30, 8:18 pm, Dozza <[email protected]> wrote: > 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 !! -~----------~----~----~----~------~----~------~--~---
