Cant create datasource

[rmorgan]

I having trouble creating a datasource. MySQL service is running, but when i
try to create the DS it fails with this error: I am running w2k, apache 2.0.52,
mysql 4.1.11. I also noticed that SQLYog will not connect either. Anyone have
any suggestions? TIA Connection verification failed for data source:
2005clubevent java.sql.SQLException: Cannot connect to MySQL server on
xxx.xxx.xxx.xxx: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 xxx.xxx.xxx.xxx:3306.
Is there a MySQL server running on the machine/port you are trying to connect
to? (java.net.ConnectException)

[Defuse]

CFMX doesn't support MySQL 4.1. You'll either have to use MySQL 4.0 or get the
MySQL JDBC driver and it link it that way.

It kind of sucks, because I like MySQL 4.1. I just hope it supports MySQL 5
when it's released.

[rmorgan]

That does suck, but I know someone that is usin 4.1.10 and it works fine with cfmx7, only difference really is he is using a *nix system.

[Defuse]

He's probably using different JDBC drivers. Find out which one he has and see if you can make it work. I'm not saying it won't work, but it's not too terribly easy.

[rmorgan]

I will look into it, but does that also explain why SQLyog will not connect as well?

[Defuse]

I'm not familiar with SQLyog, but if it's tied into MySQL in any way, probably.

[Jochem van Dieten - TMM]

rmorgan wrote:

> I having trouble creating a datasource. MySQL service is running, but when i
> try to create the DS it fails with this error: I am running w2k, apache 2.0.52,
> mysql 4.1.11. I also noticed that SQLYog will not connect either.

Then it is a MySQL error, not a CF error.

> Connection verification failed for data source:
> 2005clubevent java.sql.SQLException: Cannot connect to MySQL server on
> xxx.xxx.xxx.xxx:3306. Is there a MySQL server running on the machine/port you
> are trying to connect to?

That looks like a pretty clear error message to me. Is there a
MySQL server running on the machine/port you are trying to
connect to?


--
Jochem van Dieten
Team Macromedia Volunteer for ColdFusion, beer and fun.

[rmorgan]

Yes, there is a MySQL server running. CF, and SQLyog will not connect. SQLyog gives a bad handshake error. However, MySQL administrator connects to it just fine remotely.

[rmorgan]

Nevermind, found a solution. It seems like a band aid fix, but what can you do?

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]