Matthew Woodward wrote: > J.B. Mentzer wrote: >> That error has been consistent since I added "mysql.jar" to OBD's >> /lib. Prior to installing mysql.jar, I would receive a >> ConnectionException error with a page-filling StackTrace. >> > > As stated before, you do not need to add mysql.jar. Shouldn't cause > any issues either really, but please delete the jar file you added > just to eliminate that from the troubleshooting. I removed "mysql.jar" and rebooted OBD. I attempted to verify the datasource. The result is below. Note: this is the initial error I recieved using Railo and Oracle's Windows-based database migration tool. Here's the Stacktrace:
Add Datasource Could not verify datasource: Server connection failure during transaction. Due to underlying exception: 'java.net.UnknownHostException: locahost'. ** BEGIN NESTED EXCEPTION ** java.net.UnknownHostException MESSAGE: locahost STACKTRACE: java.net.UnknownHostException: locahost at java.net.InetAddress.getAllByName0(InetAddress.java:1150) at java.net.InetAddress.getAllByName(InetAddress.java:1072) at java.net.InetAddress.getAllByName(InetAddress.java:1008) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246) 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:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) 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:585) 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.expression.compile.CFFunctionExpression.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.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.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.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.cfTRY.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfIF.render(Unknown Source) at com.naryx.tagfusion.cfm.tag.cfIF.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:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:757) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:416) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:840) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:657) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:377) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:497) ** END NESTED EXCEPTION ** Attempted reconnect 3 times. Giving up. * * * * * * * * * * * * * * Should I put "mysql.jar" back in /lib? > What is the difference in how OBD connects to the database server vs. > how Navicat connects? > > Hate to sound like a broken record, but can you telnet to 3306? On my > Mac I have MySQL running and can telnet to 127.0.0.1 port 3306. If you > can't do that, there's still a problem. I can't telnet to 127.0.0.1:3306. As far as I can tell, the port is closed. Is there a command line procedure or command for opening the port? I googled, but couldn't find one. > I'm not familiar with Navicat so I'm not sure how it's doing what it's > doing. Ok. * JB * --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
