SEO

Hello,

I Try to connect in cold fusion an database MySQL.

schema : test
user : test
pswd : test1234

One table : agent

Impossible to connect. I have the following error message:

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


Installation version of MySQL : 5.0.27
ColdFusion version: MX 6.01
Windows 2000 Professional

Actually, I have read the Adobe and MySQL Internet site and follow
all procedure. I have also downloaded the last and previous versions
of ODBC driver. If I use ODBC, the system hangs when I push on "test"
button.

file downloaded:

mysql-5.0.15-win32.zip
mysql-5.0.27-win32.zip

I tried the 2 versions (without result)

mysql-connector-java-3.1.11.zip
mysql-connector-java-3.1.14.zip
mysql-connector-java-5.0.4.zip

for the jar file, I tried the file in the following directories:

ColdFusion\wwwroot\WEB-INF\lib
ColdFusion\runtime\jre\lib
ColdFusion\runtime\jre\lib\ext
Java\jre1.5.0_05\lib
Java\jre1.5.0_05\lib\ext

(without result)

MyODBC-3.51.10-2-win.exe
MyODBC-3.51.11-1-win.exe
mysql-connector-odbc-3.51.12-win32.zip

Each file make the system to hang

I have tested all files above without result ....

What to do?????

I'm loss....

Help Help Help .....

Andre

Dede wrote:
> Hello,
>
> I Try to connect in cold fusion an database MySQL.
>
> schema : test
> user : test
> pswd : test1234
>
> One table : agent
>
> Impossible to connect. I have the following error message:
>
> Connection verification failed for data source: test
> []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?
>
>
> Installation version of MySQL : 5.0.27
> ColdFusion version: MX 6.01
> Windows 2000 Professional
>
> Actually, I have read the Adobe and MySQL Internet site and follow
> all procedure. I have also downloaded the last and previous versions
> of ODBC driver. If I use ODBC, the system hangs when I push on "test"
> button.
>
> file downloaded:
>
> mysql-5.0.15-win32.zip
> mysql-5.0.27-win32.zip
>
> I tried the 2 versions (without result)
>
> mysql-connector-java-3.1.11.zip
> mysql-connector-java-3.1.14.zip
> mysql-connector-java-5.0.4.zip
>
> for the jar file, I tried the file in the following directories:
>
> ColdFusion\wwwroot\WEB-INF\lib
> ColdFusion\runtime\jre\lib
> ColdFusion\runtime\jre\lib\ext
> Java\jre1.5.0_05\lib
> Java\jre1.5.0_05\lib\ext
>
> (without result)
>
> MyODBC-3.51.10-2-win.exe
> MyODBC-3.51.11-1-win.exe
> mysql-connector-odbc-3.51.12-win32.zip
>
> Each file make the system to hang
>
> I have tested all files above without result ....
>
> What to do?????
>
> I'm loss....
>
> Help Help Help .....
>
> Andre
>
Does your ODBC connection work at all? ie. test it outside of CF and
see if it works?

Hello,

I would like to thanks for your reaction.

I tried to connect the table Mysql under access, all is ok until I
push on the "Test" button for testing the connection. At this moment,
ODBC crash (not responding). If I don't push the button, the table is
added in access but I can't read any data.

Today, I have removed ColdFusion and MySQL and reinstall.
The problem stay !... I dont understand...


Now, other question:

ColdFusion MX 6.01 is compatible with MySQL 5.0???

Andre




On Tue, 26 Dec 2006 18:27:37 -0600, Jonathan Roberts
<gremln007@diynics.com> wrote:


>>
>>
>> Installation version of MySQL : 5.0.27
>> ColdFusion version: MX 6.01
>> Windows 2000 Professional
>>
>> Actually, I have read the Adobe and MySQL Internet site and follow
>> all procedure. I have also downloaded the last and previous versions
>> of ODBC driver. If I use ODBC, the system hangs when I push on "test"
>> button.
>>
>> file downloaded:
>>
>> mysql-5.0.15-win32.zip
>> mysql-5.0.27-win32.zip
>>
>> I tried the 2 versions (without result)
>>
>> mysql-connector-java-3.1.11.zip
>> mysql-connector-java-3.1.14.zip
>> mysql-connector-java-5.0.4.zip
>>
>> for the jar file, I tried the file in the following directories:
>>
>> ColdFusion\wwwroot\WEB-INF\lib
>> ColdFusion\runtime\jre\lib
>> ColdFusion\runtime\jre\lib\ext
>> Java\jre1.5.0_05\lib
>> Java\jre1.5.0_05\lib\ext
>>
>> (without result)
>>
>> MyODBC-3.51.10-2-win.exe
>> MyODBC-3.51.11-1-win.exe
>> mysql-connector-odbc-3.51.12-win32.zip
>>
>> Each file make the system to hang
>>
>> I have tested all files above without result ....
>>
>> What to do?????
>>
>> I'm loss....
>>
>> Help Help Help .....
>>
>> Andre
>>
>Does your ODBC connection work at all? ie. test it outside of CF and
>see if it works?

Dede wrote:
> Hello,
>
> I would like to thanks for your reaction.
>
> I tried to connect the table Mysql under access, all is ok until I
> push on the "Test" button for testing the connection. At this moment,
> ODBC crash (not responding). If I don't push the button, the table is
> added in access but I can't read any data.
>
> Today, I have removed ColdFusion and MySQL and reinstall.
> The problem stay !... I dont understand...
>
>
> Now, other question:
>
> ColdFusion MX 6.01 is compatible with MySQL 5.0???
>
> Andre
>> Does your ODBC connection work at all? ie. test it outside of CF and
>> see if it works?
>

Have you been able to access the database AT ALL? For example, try
PHPMYADMIN or similar.

with MySQL administrator .... Yes

But from outside of MySQL ... No


On Wed, 27 Dec 2006 18:50:11 -0600, Jonathan Roberts
<gremln007@diynics.com> wrote:

>Dede wrote:
>> Hello,
>>
>> I would like to thanks for your reaction.
>>
>> I tried to connect the table Mysql under access, all is ok until I
>> push on the "Test" button for testing the connection. At this moment,
>> ODBC crash (not responding). If I don't push the button, the table is
>> added in access but I can't read any data.
>>
>> Today, I have removed ColdFusion and MySQL and reinstall.
>> The problem stay !... I dont understand...
>>
>>
>> Now, other question:
>>
>> ColdFusion MX 6.01 is compatible with MySQL 5.0???
>>
>> Andre
>>> Does your ODBC connection work at all? ie. test it outside of CF and
>>> see if it works?
>>
>
>Have you been able to access the database AT ALL? For example, try
>PHPMYADMIN or similar.

Dede wrote:
> with MySQL administrator .... Yes
>
> But from outside of MySQL ... No
>

Ok, that makes me think you have a listening/firewall issue. Have you
verified what port it is using? Also, make sure there are no firewalls
blocking access to the port.

Happy new year for you and your familly

Actualy, for testing MySQL, I have stopped ZoneAlarm because I don't
known how to open a port in ZoneAlarm.

Now, my brother have tested on other computer with the same OS
(Windows 2000) and all work fine. I don't understand.

It is possible a problem with Windows 2000???

Andre


On Thu, 28 Dec 2006 08:07:56 -0600, Jonathan Roberts
<gremln007@diynics.com> wrote:

>Dede wrote:
>> with MySQL administrator .... Yes
>>
>> But from outside of MySQL ... No
>>
>
>Ok, that makes me think you have a listening/firewall issue. Have you
>verified what port it is using? Also, make sure there are no firewalls
>blocking access to the port.

Dede wrote:
> Happy new year for you and your familly
>
> Actualy, for testing MySQL, I have stopped ZoneAlarm because I don't
> known how to open a port in ZoneAlarm.

Then I would next check your configuration and make sure it is on the
port you expect.