Professional Web Applications Themes

Connection of Coldfusion to a database MySQL - MySQL

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 ...

  1. #1

    Default Connection of Coldfusion to a database MySQL

    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 Guest

  2. #2

    Default Re: Connection of Coldfusion to a database MySQL

    Dede wrote: 
    Does your ODBC connection work at all? ie. test it outside of CF and
    see if it works?
    Jonathan Guest

  3. #3

    Default Re: Connection of Coldfusion to a database MySQL

    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
    <com> wrote:

     
    >Does your ODBC connection work at all? ie. test it outside of CF and
    >see if it works?[/ref]

    Dede Guest

  4. #4

    Default Re: Connection of Coldfusion to a database MySQL

    Dede wrote: 
    >[/ref]

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

  5. #5

    Default Re: Connection of Coldfusion to a database MySQL

    with MySQL administrator .... Yes

    But from outside of MySQL ... No


    On Wed, 27 Dec 2006 18:50:11 -0600, Jonathan Roberts
    <com> wrote:
     
    >>[/ref]
    >
    >Have you been able to access the database AT ALL? For example, try
    >PHPMYADMIN or similar.[/ref]

    Dede Guest

  6. #6

    Default Re: Connection of Coldfusion to a database MySQL

    Dede wrote: 

    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.
    Jonathan Guest

  7. #7

    Default Re: Connection of Coldfusion to a database MySQL

    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
    <com> wrote:
     
    >
    >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.[/ref]

    Dede Guest

  8. #8

    Default Re: Connection of Coldfusion to a database MySQL

    Dede wrote: 

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

Similar Threads

  1. connection to coldfusion middleware & MSSQL Database
    By Geno in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: October 31st, 07:19 AM
  2. Connection between ColdFusion and MySQL
    By besenok in forum Coldfusion Database Access
    Replies: 2
    Last Post: April 24th, 01:35 PM
  3. coldfusion mysql connection speed
    By dbhelp in forum Coldfusion - Advanced Techniques
    Replies: 31
    Last Post: September 2nd, 06:39 PM
  4. ColdFusion 6.1 and MySQL 4.1 Database
    By bob_mould in forum Coldfusion Database Access
    Replies: 3
    Last Post: April 11th, 02:28 PM
  5. aaaaargh grr coldfusion mysql connection
    By duncno1 in forum Coldfusion Database Access
    Replies: 3
    Last Post: April 7th, 10:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139