MySQL server running but can't be found

[Michael van K]

I get the following message when trying to set up a datasource in CF
Administrator.

Connection verification failed for data source: gmfg_fusebox
[]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?

MySQL server is running fine when I try to access the databases via MySQL
Browser but CF can't seem to see it.

Set up is CF MX PRO 2004 on XP with MySQL. CF running as localhost server.

Any ideas greatly appreciated.

[mpwoodward *TMM*]

On 2005-05-03 16:27:11 -0500, "Michael van K"
<webforumsuser@macromedia.com> said:

> I get the following message when trying to set up a datasource in CF
> Administrator.
>
> Connection verification failed for data source: gmfg_fusebox
> []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?
>
> MySQL server is running fine when I try to access the databases via
> MySQL Browser but CF can't seem to see it.
>
> Set up is CF MX PRO 2004 on XP with MySQL. CF running as localhost server.
>
> Any ideas greatly appreciated.

This has been covered several times before here (or possible in one of
the other forums)--do a search for MySQL and you should find plenty of
info. Also do a search on macromedia.com and you'll find a couple of
technotes related to this.

Long and short of it is that if you're using MySQL 4.1 the driver the
ships with CF can't use the password hashing routine in 4.1, so you
either need to use MySQL's JDBC drivers or change the hashing on your
passwords in your database.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[Michael van K]

Thanks Matt,

I did find the jdbc jar on the MySQL website and have tried to install it without much luck.

Any further help regarding methods of setting it all up?

Cheers. Michael.

[Michael van K]

I now get this message:

Unable to instantiate logger class 'com.mysql.jdbc.log.Log4JLogger', exception in constructor?

[mpwoodward *TMM*]

On 2005-05-03 19:35:40 -0500, "Michael van K"
<webforumsuser@macromedia.com> said:

> Thanks Matt,
>
> I did find the jdbc jar on the MySQL website and have tried to install
> it without much luck.
>
> Any further help regarding methods of setting it all up?
>
> Cheers. Michael.

Just to make sure you saw the most pertinent technote:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]

Beyond that you'll have to post exactly how you're setting things up,
the steps you're going through, the errors you're seeing, etc. to get
additional assistance. I use MySQL quite a lot with CF so once I see
where you're getting tripped up I'm sure I can walk you through it.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[EDUYork]

Originally posted by: Newsgroup User
On 2005-05-03 19:35:40 -0500, "Michael van K"
<webforumsuser@macromedia.com> said:

> Thanks Matt,
>
> I did find the jdbc jar on the MySQL website and have tried to install
> it without much luck.
>
> Any further help regarding methods of setting it all up?
>
> Cheers. Michael.

Just to make sure you saw the most pertinent technote:

Class: com.mysql.jdbc.Driver

Thanks,
Richard

[EDUYork]

Originally posted by: EDUYork
Originally posted by: Newsgroup User
On 2005-05-03 19:35:40 -0500, "Michael van K"
<webforumsuser@macromedia.com> said:
<snip>

This sounds to me like an error in the .class itself.

For the record, my exact setup is:
URL: jdbc:mysql://localhost:3306/[DS_Name]
Class: com.mysql.jdbc.Driver

Thanks,
Richard


My solution was to return to the download site and get the previous stable
version:
mysql-connector-java-3.0.16-ga-bin.jar
worked for me and I now have a verified connection to my MySQL 4.1 database

Richard

[nicher]

Thanks, this finally solved my problem too...

nic

[Allen Manning]

:D

This sorted me out as well. Thanks for posting folks.

Best,
al
[url]http://www.prismix.com/[/url]