What version of MySQL are you using? The CF MySQL 3 driver won't
connect to any of the recent releases.
At 01:36 PM 6/30/2006, you wrote:
I have a mysql server running on box B (windows 2000) and it works
well using localhost. I can do everything on it using a phpadmin
interface (127.0.0.1/myphp) and also via command line.
if I try http://servername/myphp i get this error
-------------------------------
The requested URL /mysql was not found on this server.
-------------------------------
I am trying to connect to it using cf 7. when I try to connect using
the mysql(3.x) I get this error message
-------------------------------
Connection verification failed for data source: aspfile
java.sql.SQLException: Cannot connect to MySQL server on
dal1nt21:3306. Is there a MySQL server running on the machine/port you
are trying to connect to? (java.net.ConnectException)
The root cause was that: java.sql.SQLException: Cannot connect to
MySQL server on dal1nt21:3306. Is there a MySQL server running on the
machine/port you are trying to connect to? (java.net.ConnectException)
-------------------------------
i've tried these instruction and I get an error
-------------------------------
Connection verification failed for data source: aspfiles
java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.SocketException: java.net.ConnectException:
Connection refused: connect ** BEGIN NESTED EXCEPTION **
java.net.SocketException MESSAGE: java.net.ConnectException:
Connection refused: connect STACKTRACE: java.net.SocketException:
java.net.ConnectException: Connection refused: connect at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:143)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:225) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1805) at
com.mysql.jdbc.Connection.(Connection.java:452) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at
coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562)
at
coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION **
The root cause was that: java.sql.SQLException: Unable to connect to
any hosts due to exception: java.net.SocketException:
java.net.ConnectException: Connection refused: connect ** BEGIN NESTED
EXCEPTION ** java.net.SocketException MESSAGE:
java.net.ConnectException: Connection refused: connect STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection
refused: connect at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:143)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:225) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1805) at
com.mysql.jdbc.Connection.(Connection.java:452) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at
coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562)
at
coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION **
-------------------------------
the mysql server is running but it looks like i can't get to it
remotely.... any ideas?
thanks
john
_______________________________________________
Reply to DFWCFUG: [email protected]
Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list
List
Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
