Thursday, September 05, 2013

coldfusion 6 with mysql 5.6.x on linux : communication error during handshake

coldfusion 6 with mysql 5.6.x on a linux box (i use centos)

adding a datasource in coldfusion using mysql driver will get you:
[]java.sql.SQLException: Communication failure during handshake...


to fix:

1. download mysql-connector-java-3.0.17-ga.tar.gz (using connector 5.x didnt work for me)
2. extract and copy mysql-connector-java-3.0.17-ga-bin.jar to /opt/coldfusionmx/wwwroot/WEB-INF/lib/
3. add classpath /opt/coldfusionmx/wwwroot/WEB-INF/lib/ in cf admin

4. restart cf
5. add datasource using other driver

jdbc url: jdbc:mysql://<host>:<port>/<database name>
driver class: com.mysql.jdbc.Driver
booyah!!

(reference: http://helpx.adobe.com/coldfusion/kb/configure-jdbc-driver-mysql-4.html)

No comments:

Post a Comment

SSH : No matching host key type found. Their offer: ssh-rsa,ssh-dss

Got this while connecting to my mikrotik router via ssh   Unable to negotiate with <ip address> port <ssh port>: no matching hos...