MySQL DSN fails during handshake

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default MySQL DSN fails during handshake

    I am trying to connect to a MySQL database that is on another network. The port
    has been opened, and I am able to connect to it via telnet (to test). I cannot
    connect to it from my CFML MX7 admin when I am trying to create a DSN. I get
    the following error.

    Connection verification failed for data source: MWEB
    java.sql.SQLException: Communication failure during handshake. Is there a
    server running on xxx.xxxx.com:3306?
    The root cause was that: java.sql.SQLException: Communication failure during
    handshake. Is there a server running on xxx.xxxx.com:3306?


    Could this be because I have an out of date java handler? I know the remote
    database is accessible from the computer, because I can connect to it via
    mysql-admin from the same server. Any help would be greatly appreciated.


    Xtort Guest

  2. Similar Questions and Discussions

    1. MySQL character-set-client-handshake
      Hi, Does anyone know how to pass this variable to mysql server? --character-set-client-handshake I have now 4.1.18 and i need it in order to...
    2. Trace SSL handshake
      Hi all, Is there any way to trace the SSL handshake, or to programmatically intercept some of the results. I'm interested in determining what...
    3. Two Way Handshake Verification
      Someone mentioned to be about using signed certificates to do a two way handshake verification. What is it actually? Is it the same as client SSL...
    4. Problem with PHP and MySQL, mysql_connect fails.
      Hello! I have just installed Apache V2.0.52 with PHP V4.3.4 and MySQL V4.1.5 in windows xp, with service pack 2 installed. Apache and PHP...
    5. DBD::mysql install fails - please help
      Trying to install Request Tracker on SuSE 8.0 + latest updates. Checking dependencies tells me DBD::mysql version 2.1018 required--this is only...
  3. #2

    Default Re: MySQL DSN fails during handshake

    Ok following the recommendations at this link
    [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170[/url] I am able
    to create the connection. Of course now it is saying that the username/password
    is a problem. I think this has to do with the database priveleges, or possibly
    how I am passing that information to the database.

    Connection verification failed for data source: MySQL_MWEB
    java.sql.SQLException: Access denied for user 'testuser'@'service.testnet.net'
    (using password: YES)
    The root cause was that: java.sql.SQLException: Access denied for user
    'testuser'@'service.testnet.net' (using password: YES)



    Xtort Guest

Posting Permissions

  • You may not post new threads
  • You may 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