Trying to play with Dave's Mach-II code (as well as some others), I thought I'd post the solution to a problem I encountered as I'm sure that many of you trying to set up a MySQL data source on CF7 will run into this issue.
Having been a while since installing MySQL on a windows box and trying to set up a MySQL datasource through the CF7 administrator. I came up with this error: Connection verification failed for data source: mysql_bad java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? Per the Adobe TechNote for CF MX, http://www.adobe.com/go/6ef0253 you will need to follow these steps to set up your MySQL db for CF. To connect to a MySQL 4.1 or 5 database from ColdFusion MX: 1. Download a current, stable version of the MySQL Connector J JDBC driver, available at: http://dev.mysql.com/downloads/ Note: Connector/J version 3.1.11 and higher cannot be used with ColdFusion MX 7 because of MySQL bug 13469. Connector/J 3.1.10 should be used instead for ColdFusion MX 7 until this MySQL bug is fixed. All Connector/J version 3.0 releases and all version 3.2 releases work with ColdFusion MX 7. 2. Extract the mysql-connector-java-3.{n}-bin.jar file from the downloaded archive file. 3. Save the mysql-connector-java-3.{n}-bin.jar file in thecf_root/WEB-INF/lib directory. 4. Restart the ColdFusion MX server. 5. Add a new data source to the ColdFusion MX Administrator, using the driver option Other. 6. Enter the JDBC URL: jdbc:mysql://[host]:[port]/[database] 7. Enter the Driver Class: com.mysql.jdbc.Driver 8. Complete username/password, and adjust other data source settings, if needed. 9. Submit the data source for verification. The exception being, to use the latest MySQL Connector. I hope this helps anybody who runs into this problem! Thanks, Joe Kelly _______________________________________________ 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.instantspot.com/ www.teksystems.com/
