tracker issue : CF-4126389

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

Connection to local MySQL database with port 3307 doesn't work

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/UserError

Reporter/Name(from Bugbase): Harry Klein / Harry Klein (Harry Klein)

Created: 03/09/2016

Components: Database

Versions: 2016

Failure Type: Unspecified

Found In Build/Fixed In Build: RC1_v12 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Win All

Vote Count: 0

Problem Description:
JDBC connection error

Steps to Reproduce:
Please try the MySQL connection in the CONTENS CMS installation I prepared for you. Just update the Express Version in this package to the latest version and try to connect to the database contens4!

Actual Result:
eb 11, 2016 10:25:45 AM Information [http-nio-8500-exec-1] - User admin added datasource contens4.
SQLException while attempting to connect: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up..
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Feb 11, 2016 10:25:49 AM Error [http-nio-8500-exec-6] - Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Feb 11, 2016 10:25:49 AM  [] -
SQLException while attempting to connect: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up..
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Feb 11, 2016 10:25:53 AM Error [http-nio-8500-exec-6] - Could not create connection to database server. Attempted reconnect 3 times. Giving up.

Expected Result:
Working connection

Any Workarounds:
No

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

Watson Bug ID:	4126389

External Customer Info:
External Company: CONTENS
External Customer Name: Harry Klein
External Customer Email: KLEIN@CONTENS.DE
External Test Config:

Attachments:

Comments:

Adding BUG AUDIT TRAIL ********action: updated fieldName: Fix By Product Milestone newValue: Blank oldValue: HF1 oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2016-03-03 05:47:51.0 action: updated fieldName: Date Closed newValue: 2016-02-24 01:48:41.0 oldValue: Blank oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-24 09:48:41.0 action: updated fieldName: Owner newValue: Blank oldValue: nimsharm oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-24 09:48:41.0 action: updated fieldName: State newValue: Closed oldValue: Open oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-24 09:48:41.0 action: updated fieldName: Closed By newValue: nimsharm oldValue: Blank oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-24 09:48:41.0 action: updated fieldName: Reason newValue: UserError oldValue: PRHaveInfo oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-24 09:48:41.0 action: updated fieldName: Status newValue: Withdrawn oldValue: ToTrack oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-24 09:48:41.0 action: updated fieldName: Reason newValue: PRHaveInfo oldValue: PRNeedInfo oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-24 09:06:35.0 action: updated fieldName: Status newValue: ToTrack oldValue: ToTrack oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-24 09:06:35.0 action: updated fieldName: State newValue: Open oldValue: Open oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-24 09:06:35.0 action: updated fieldName: Reason newValue: PRNeedInfo oldValue: PRHaveInfo oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-24 09:03:48.0 action: updated fieldName: Reason newValue: PRHaveInfo oldValue: PRNeedInfo oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-24 08:59:06.0 action: updated fieldName: State newValue: Open oldValue: Open oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-24 08:59:06.0 action: updated fieldName: Status newValue: ToTrack oldValue: ToTrack oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-24 08:59:06.0 action: updated fieldName: Reason newValue: PRNeedInfo oldValue: PRHaveInfo oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-24 05:03:05.0 action: updated fieldName: State newValue: Open oldValue: Open oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-16 09:44:15.0 action: updated fieldName: Status newValue: ToTrack oldValue: ToTrack oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-16 09:44:15.0 action: updated fieldName: Reason newValue: PRHaveInfo oldValue: PRNeedInfo oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-16 09:44:15.0 action: updated fieldName: Fix By Product Milestone newValue: HF1 oldValue: Blank oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2016-02-12 10:57:04.0 action: updated fieldName: Fix By Milestone newValue: Post Release oldValue: Blank oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2016-02-12 10:57:04.0 action: updated fieldName: Reason newValue: PRNeedInfo oldValue: PRHaveInfo oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-12 07:00:56.0 action: updated fieldName: Priority newValue: 2 oldValue: 0 oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-12 05:17:09.0 action: updated fieldName: State newValue: Open oldValue: Open oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-11 09:51:09.0 action: updated fieldName: Reason newValue: PRHaveInfo oldValue: PRNeedInfo oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-11 09:51:09.0 action: updated fieldName: Status newValue: ToTrack oldValue: ToTrack oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-11 09:51:09.0 action: updated fieldName: Reason newValue: PRNeedInfo oldValue: PRHaveInfo oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-11 09:44:18.0 action: updated fieldName: Reason newValue: PRHaveInfo oldValue: PRNeedInfo oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-11 09:36:43.0 action: updated fieldName: State newValue: Open oldValue: Open oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-11 09:36:43.0 action: updated fieldName: Status newValue: ToTrack oldValue: ToTrack oprid: prerelease recordName: RQ_DEFECT timpestamp: 2016-02-11 09:36:43.0 action: updated fieldName: Status newValue: ToTrack oldValue: Unverified oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-11 09:33:37.0 action: updated fieldName: Reason newValue: PRNeedInfo oldValue: Blank oprid: nimsharm recordName: RQ_DEFECT timpestamp: 2016-02-11 09:33:37.0
Comment by CFwatson U.
4304 | March 09, 2016 01:53:44 AM GMT
Added By:nimsharm Note Added: Thanks Harry for the confirmation. Date Added :2016-02-26 12:17:09.0 Added By: PreRelease User User Name:Harry Klein Note Added: This issue can be closed Date Added :2016-02-26 11:24:40.0 Added By:nimsharm Note Added: Thanks Harry. I will contact Hari and get the setup. Date Added :2016-02-24 09:13:29.0 Added By: PreRelease User User Name:Harry Klein Note Added: Yesterday to: 'Hari Krishna Kallae', S V Pavankumar In the past to: Kishore Balakrishnan, 'Piyush Kumar Nayak', Vamseekrishna Nanneboina Date Added :2016-02-24 09:06:35.0 Added By:nimsharm Note Added: Thanks Harry for the information. Where did you send the package? Did you upload the package in the prerelease forum? Date Added :2016-02-24 09:03:49.0 Added By: PreRelease User User Name:Harry Klein Note Added: >> I wanted to have access to the installation which you prepared for us I don't understand this statement - I send you the package several times, yesterday again - I also updated the package to new newest release? Date Added :2016-02-24 08:59:58.0 Added By: PreRelease User User Name:Harry Klein Note Added: Telnet returns: J 5.6.13 l{F)9#Cx2;Çx15;b5}8<dcFq+|Rmysql_native_password Date Added :2016-02-24 08:59:06.0 Added By:nimsharm Note Added: Harry, You said, "Please try the MySQL connection in the CONTENS CMS installation I prepared for you. " I wanted to have access to the installation which you prepared for us. As I said earlier, It looks like ColdFusion is unable to open a socket on port 3307. Please check if you are able to telnet to your mysql server from the machine where ColdFusion is installed? cmd: telnet <DB_IP_ADDRESS> <DB_PORT> Date Added :2016-02-24 05:03:07.0 Added By: PreRelease User User Name:Harry Klein Note Added: So please which information do you need? Date Added :2016-02-16 09:44:14.0 Added By: PreRelease User User Name:Harry Klein Note Added: - Date Added :2016-02-11 09:51:08.0 Added By: PreRelease User User Name:Harry Klein Note Added: Please try the MySQL connection in the CONTENS CMS installation I prepared for you. Just update the Express Version in this package to the latest version and try to connect to the database contens4! Date Added :2016-02-11 09:36:42.0 Added By: PreRelease User User Name:Harry Klein Note Added: Entered Bug. Date Added :2016-02-11 09:27:40.0
Comment by CFwatson U.
4305 | March 09, 2016 01:53:46 AM GMT