CFMX 6.1 talking to MySQL question

[Russ]

I am trying to get CFMX 6.1 to talk to MySQL (4.1). I been using CF with MS
SQL Server (Windows) for years, but am attempting an install of MySQL (Windows)
and use CFMX (Windows) with MySQL. Do I need to install the MySQL Connector/J
to allow a CFMX datasource to connect to the MySQL database? Thanks for any
and all help. Russ....

[cf_menace]

The MySQL drivers that ship with CFMX 6/6.1/7 only work with MySQL 3.23 through
4.0.x (via ODBC).

The password algorithm was updated starting with MySQL 4.1, so you'll need to
use [url]http://dev.mysql.com/doc/mysql/en/old-client.html[/url]

[Russ]

The purpose of this exercise (installing MySQL) to work with CFMX is to see if
MySQL can be a replacement for our CFMX web applications that use SQL Server.
It was very easy to install the MySQL core, administrator, and query browser.
Now we come to the JDBC connector: the curent instructions I saw with this get
very confusing, very fast . Is there something you can get which you just
install like the MySQL core, administrator, and query browser. ? Thanks for
any and all help. russ....

[cf_menace]

If you want to use the new, stronger password algorithm that ships with MySQL
4.1, then follow the instructions in the first link. Takes about 5 mintues
depending on download time.

Otehrwise, install MySQL 4.1 and tell it to run using "old passwords" (you can
configure this via MySQL Administrator), then you can use the MySQL driver that
shipped with CFMX.

HTH

[Russ]

HTH.... Thanks for all your help. After first failing in connectivity with
4.1, I removed it and tried 4.0, which did not have the nice server setup that
4.1 has. Then I got your latest note and decided to try again. So, I removed
4.0, installed 4.1 (nothing special, standard vanilla install) and found (and
activated) the feature you mentioned to allow for old passwords. I now had
great hopes of getting my CFMX 6.1 to talk to MySQL. Wentto CFMX 6.1
administration (on same Windows server) and created a CFMX datasource using the
MySQL driver and using the correct server, db, user, and password in the
datasource, I get the following error: Connection verification failed for data
source: MySQL_dtsc-dev_CF []java.sql.SQLException: Communication failure during
handshake. Is there a server running on dtsc-dev:3306? The root cause was that:
java.sql.SQLException: Communication failure during handshake. Is there a
server running on dtsc-dev:3306? any thoughts? I checked, the MySQL service
is running) and thanks again for your help Russ Calif. Dept. of Toxic
Substances Control Sacramento, CA.

[Russ]

And addo to the previous message... I did restart the MySQL server after
activating the security feature to use the old password method. I also, just
in case, reboot the server. Still getting the same error. russ....

[cf_menace]

You created your DB User using the new 4.1 password method. Then you told MySQL
to bootup using the old password method. Now the User can't connect becuase the
stored password was created using the New method.

Update the user's password while MySQL is running using old_passwords and you
should be back on track.

[Russ]

What I have done since your lastest email was delete the user and re-created.

The CFMX datasource seems to have made the connection.

Thanks.