Ask a Question related to Coldfusion Database Access, Design and Development.
-
Xtort #1
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
-
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... -
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... -
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... -
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... -
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... -
Xtort #2
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



Reply With Quote

