MYSQL DATASOURCE ERROR

[reya276]

I'm having some issues connecting MYSQL 5.0 DB to coldfusion mx 7, basiclly I
can't created a datasource. Oh and I get this error message.

Connection verification failed for data source: storedb
java.sql.SQLException: Communication failure during handshake. Is there a
server running on 127.0.0.1:3306?
The root cause was that: java.sql.SQLException: Communication failure during
handshake. Is there a server running on 127.0.0.1:3306? is there a way to fic
this??

[BKBK]

I suspect that the MySQL 5.0 service is not running. Make sure it is.

[reya276]

The server is running, this is a JDBC driver issue, anyone with this problem needs to download the version of the driver [url]http://www.mysql.com[/url]

[WaveRunner]

I have the same issue and downloaded the JDBC driver. But I am new to JDBC. CAn
anyone give an example of how it is configured via the CF Admin?
JDBC URL: is this the path to it on the server? C:JRUN\...
Driver Class: is this the Environmental Class path?
Driver Name: mysql-connector-java-3.1.2-bin.jar

Thanks in advance

[reya276]

dude here is the instructions, this should get you going if you have any other issues let me know.
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170[/url]

[Nick_KC]

Those directions are not detailed, and they do not work for me... I've been
programming for 6 years in Cold Fusion, never had to use MySQL until now but I
do know my way around and cannot get this DSN to connect.

[reya276]

Get the Driver here: [url]http://www.mysql.com/products/connector/j/[/url]

if you are running on a windows enviornment the path would be
C:\CFusionMX7\wwwroot\WEB-INF\lib

1. Place the mysql-connector-java-3.1.10-bin.jar in
C:\CFusionMX7\wwwroot\WEB-INF\lib

2. Then restart the coldfusion application server

3. Then open the CF admin and go to the datasource page and on the dropdown
select "Other" and enter a name for it.

For example:

Name the data source MySQL_test when it will connect to the test database.
Note: There is a test database installed by default in the MySQL server.
Select Other in the driver field to tell ColdFusion you will describe another
type of driver.
Click Add to add the data source and display the default driver window for
this driver.

4. Enter the following in the JDBC URL field:
jdbc:mysql://localhost:3306/DB name

5. Enter the following in the Driver Class field:
enter this (com.mysql.jdbc.Driver)

6. Enter a valid username and password in the Username and Password fields
Where the username and password are defined as user account information on the
database server.

(Optional) Enter the name of the driver in the Driver Name field.

this should get you going just follow these instructions. if it does not work
correctly I suggest using MYSQL 4.0 Unless you need to use Store Procedures
then you will have to wait until someone else comes up with a different answer
but I think you should be fine.

[Nick_KC]

I've seen those directions a hundred times now and again they don't work for
me! Thanks though, but I have NO trouble finding those same directions over
and over and over when I try to find an answer to why Cold Fusion MX does not
connect to MySQL 4.1 or 5.0 with ANY of the drivers I've downloaded. I guess I
need screenshots of every tiny little step because I am obviously not doing it
right if it works for everybody else but me... Is there some "special" way to
install a .jar file other than extracting a zip file and then copying the .jar
file into the right directory in Cold Fusion? I've tried every combination,
uninstalled and reinstalled MySQL 4.1 and 5.0 and tried all combinations of the
J connector. It's crazy...

[reya276]

Ok send me the screen shots of your Admin where you are entering the datasource
at [email]reya276@yahoo.com[/email] and see if we can figure this out, because I just
installed mysql 5.0 yesterday and corrected this problem I don't see no reason
why we can get it to work for you.

[Mountain Lover]

it does work nick...I've got MySQL 4.0, 4.1 and 5.0 all running on my
dev machine (WinXP CFMX7.01 IIS) using the
mysql-connector-java-3.1.12-bin.jar and no problems so far....don't give
up. Maybe it's a firewall or a port problem or TCPIP or old passwords?
I've run into many...post your detailed problems and one of us should be
able to help.

Good luck
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[Nick_KC]

You guys are awesome, motivating, and I appreciate the encouragement. My
apologies for getting frustrated and almost blowing a lid... I'm working on it
now and I'll get some screen shots in just a bit.

[Nick_KC]

I've sent both of you screenshots, if you can determine anything please let me know. I am open to anything at this point and very frustrated again...

[Charles Ng]

For this error :
Connection verification failed for data source: storedb
java.sql.SQLException: Communication failure during handshake. Is there a
server running on 127.0.0.1:3306?
The root cause was that: java.sql.SQLException: Communication failure during
handshake. Is there a server running on 127.0.0.1:3306? is there a way to fic
this??

There are a few significant steps to make it connecting...

1. Make sure you have installed stable connector version.
2. Use 'Other' driver instead of select the existing MySQL driver option in CF.

May this help -->
[url]http://www.talkingtree.com/blog/index.cfm?mode=entry&entry=25AA9A56-45A6-2844-7A[/url]
60CF5B3666D010

[WaveRunner]

All,

Thanks for the help!
I finally got it to work but had to use the updated (beta) 5.0 driver. 3.1.12
would not work.
Here is a note from [url]http://www.macromedia.com/go/tn_19170[/url]

Additional Information
Connector/J version 3.1 release 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 of the current release until this MySQL bug is fixed. All Connector/J
version 3.0 releases and all (currently beta) version 3.2 releases work with
ColdFusion MX 7.Texthttp://www.macromedia.com/go/tn_19170

I could not find 3.1.10 to use so I tried the 5.0.0 beta and have connected.

Regards

[Unregistered]

Get the Driver here: [url]http://www.mysql.com/products/connector/j/[/url]

if you are running on a windows enviornment the path would be
C:\CFusionMX7\wwwroot\WEB-INF\lib

1. Place the mysql-connector-java-3.1.10-bin.jar in
C:\CFusionMX7\wwwroot\WEB-INF\lib

2. Then restart the coldfusion application server

3. Then open the CF admin and go to the datasource page and on the dropdown
select "Other" and enter a name for it.

For example:

Name the data source MySQL_test when it will connect to the test database.
Note: There is a test database installed by default in the MySQL server.
Select Other in the driver field to tell ColdFusion you will describe another
type of driver.
Click Add to add the data source and display the default driver window for
this driver.

4. Enter the following in the JDBC URL field:
jdbc:mysql://localhost:3306/DB name

5. Enter the following in the Driver Class field:
enter this (com.mysql.jdbc.Driver)

6. Enter a valid username and password in the Username and Password fields
Where the username and password are defined as user account information on the
database server.

(Optional) Enter the name of the driver in the Driver Name field.

this should get you going just follow these instructions. if it does not work
correctly I suggest using MYSQL 4.0 Unless you need to use Store Procedures
then you will have to wait until someone else comes up with a different answer
but I think you should be fine.

This helped me, thank you so much! I'm on CF9.01 and trying to setup mySQL for the first time. I'm a MSSQL person :) I had the same connection problem some of the other above had.