I'm having issues with a new Ubuntu server running CFMX7 and Mysql5, both are up and running, Apache's happy, I can get to CF admin....I can connect to Mysql:3306 using Mysql Admin tool from my laptop, I can't however connect Datasources from cfadmin. Using the following:CF data source nametest DescriptionDriverMySQL JDBC URLjdbc:mysql://127.0.0.1:3306/mysql? Usernameroot Login timeout30 seconds Long text buffer size64000 Timeout1200 seconds Maintain connectionsYes Interval420 seconds Restricted SQL operationsDisable connectionsNo I get error out:Connection verification failed for data source: testjava.sql.SQLException: Communication failure during handshake. Is there a server running on 127.0.0.1:3306?I've also tried the connection using "localhost", but get the same error........Not sure what to do at this piont.........

Participant

Question

CFMX7 MySql5 Apache2.2 Ubuntu

Forum|Forum|16 years ago
December 9, 2009
1 reply
410 views

I'm having issues with a new Ubuntu server running CFMX7 and Mysql5, both are up and running, Apache's happy, I can get to CF admin....

I can connect to Mysql:3306 using Mysql Admin tool from my laptop, I can't however connect Datasources from cfadmin. Using the following:

CF data source name	test
Description
Driver	MySQL
JDBC URL	jdbc:mysql://127.0.0.1:3306/mysql?
Username	root
Login timeout	30 seconds
Long text buffer size	64000
Timeout	1200 seconds
Maintain connections	Yes
Interval	420 seconds
Restricted SQL operations
Disable connections	No

I get error out:

Connection verification failed for data source: test
java.sql.SQLException: Communication failure during handshake. Is there a server running on 127.0.0.1:3306?

I've also tried the connection using "localhost", but get the same error........

Not sure what to do at this piont.........