tracker issue : CF-4049903

select a category, or use search below
(searches all categories and all time range)
Title:

Database connection issue via CFIDE/admin & MAMP Pro

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): Mohammad kheirbakhsh / Mohammad kheirbakhsh (Mohammad kheirbakhsh)

Created: 09/04/2015

Components: Database

Versions: 11.0

Failure Type: Crash

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Mac 10.10

Vote Count: 0

Problem Description:

Steps to Reproduce:
start CF server via yosemite terminal on macbook Pro
go to http://127.0.0.1/CFIDE/administrator/index.cfm
under datasource click add datasource with MYSQL (DATADIRECT) driver 
enter Zigzagvalet for Data Source Name and Databse
server=localhost
port=3306
username=root
password= root 

Actual Result:

Connection verification failed for data source: ZigZagValet java.sql.SQLException: [Macromedia][MySQL JDBC Driver]Connections to MySQL Community Server are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version. The root cause was that: java.sql.SQLException: [Macromedia][MySQL JDBC Driver]Connections to MySQL Community Server are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.

Expected Result:
Database connecttion verified 

Any Workarounds:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4049903

External Customer Info:
External Company:  
External Customer Name: Mohammad kheirbakhsh
External Customer Email:  
External Test Config: My Hardware and Environment details:

MACbook Pro

OSX Yosemite 10.10.5

2.7 GHz Intel Core i5 Processor

Attachments:

Comments:

I'm trying to connect to my database I set up using MAMP Pro on yosemite...I can not set up the connection via cfide/admin area I have all the setup correctly becasue when I put a wrong password I get the following error: Connection verification failed for data source: ZigZagValet java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][MySQL JDBC Driver][MySQL]Access denied for user 'root'@'localhost' (using password: YES) The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][MySQL JDBC Driver][MySQL]Access denied for user 'root'@'localhost' (using password: YES) but whe I put the right password I get error explained in ACTUAL RESULT in description above I can also go to my database and tables via phpmyAdmin area of MAMP pro which both tells me the set up is correct I'm not sure what to do at this point
Comment by External U.
6035 | September 04, 2015 12:51:09 PM GMT
Hi Kheirbakhsh, MySQL(DataDirect) driver is supported only for MySQL Enterprise or Commercial versions. If you are using MySQL Community Edition, then please try creating data source with "MySQL5" and not with "MySQL(DataDirect)". Please let us know if you are still facing issue.
Comment by Nimit S.
6036 | September 04, 2015 10:42:59 PM GMT