-
Bug
-
Resolution: Incorrectly Filed
-
Low
-
None
-
2.11.2, 2.12.0
-
None
-
None
-
Severity 2 - Major
-
Summary
When connecting to a database on another server the setup wizard fails to connect.
Environment
- MySQL
- Crowd 2.12.0
Steps to Reproduce
- Run the setup wizard
- Try to connect to a db on another server
Expected Results
The setup wizard will use the credentials in the form.
Actual Results
The below exception is thrown in the atlassian-crowd.log file:
The error message in the log when the host is specified is:Caused by: java.sql.SQLException: Access denied for user 'confuser@172.20.52.46'@'anns-mbp.office.atlassian.com' (using password: YES)
If the username is put in with no parameters, the error message is:
Caused by: java.sql.SQLException: Access denied for user 'confuser'@'anns-mbp.office.atlassian.com' (using password: YES)
Notes
- The setup works fine with MySQL on localhost.
- See attached screen shot for the error in the UI.
Workaround
No workaround at this time.
[CWD-4941] Setup wizard appending local hostname to MySQL database user
Workflow | Original: Simplified Crowd Development Workflow v2 - restricted [ 2309961 ] | New: JAC Bug Workflow v3 [ 3365825 ] |
Symptom Severity | Original: Major [ 14431 ] | New: Severity 2 - Major [ 15831 ] |
Resolution | New: Incorrectly Filed [ 10100 ] | |
Status | Original: Open [ 1 ] | New: Closed [ 6 ] |
Affects Version/s | New: 2.11.2 [ 67342 ] |
Description |
Original:
h3. Summary
When connecting to a database on another server the setup wizard fails to connect. h3. Environment * MySQL * Crowd 2.12.0 h3. Steps to Reproduce # Run the setup wizard # Try to connect to a db on another server h3. Expected Results The setup wizard will use the credentials in the form. h3. Actual Results The below exception is thrown in the atlassian-crowd.log file: The error message in the log when the host is specified is: {code}Caused by: java.sql.SQLException: Access denied for user 'confuser@172.20.52.46'@'anns-mbp.office.atlassian.com' (using password: YES){code} If the username is put in with no parameters, the error message is: {code} Caused by: java.sql.SQLException: Access denied for user 'confuser'@'anns-mbp.office.atlassian.com' (using password: YES) {code} h3. Notes The setup works fine with MySQL on localhost. See attached screen shot for the error in the UI. h3.Workaround No workaround at this time. |
New:
h3. Summary
When connecting to a database on another server the setup wizard fails to connect. h3. Environment * MySQL * Crowd 2.12.0 h3. Steps to Reproduce # Run the setup wizard # Try to connect to a db on another server h3. Expected Results The setup wizard will use the credentials in the form. h3. Actual Results The below exception is thrown in the atlassian-crowd.log file: The error message in the log when the host is specified is: {code}Caused by: java.sql.SQLException: Access denied for user 'confuser@172.20.52.46'@'anns-mbp.office.atlassian.com' (using password: YES){code} If the username is put in with no parameters, the error message is: {code} Caused by: java.sql.SQLException: Access denied for user 'confuser'@'anns-mbp.office.atlassian.com' (using password: YES) {code} h3. Notes * The setup works fine with MySQL on localhost. * See attached screen shot for the error in the UI. h3.Workaround No workaround at this time. |
Description |
Original:
h3. Summary When connecting to a database on another server the setup wizard fails to connect. h3. Environment * MySQL * Crowd 2.12.0 h3. Steps to Reproduce # Run the setup wizard # Try to connect to a db on another server h3. Expected Results The setup wizard will use the credentials in the form. h3. Actual Results The below exception is thrown in the atlassian-crowd.log file: The error message in the log when the host is specified is: {code}Caused by: java.sql.SQLException: Access denied for user 'confuser@172.20.52.46'@'anns-mbp.office.atlassian.com' (using password: YES){code} If the username is put in with no parameters, the error message is: {code} Caused by: java.sql.SQLException: Access denied for user 'confuser'@'anns-mbp.office.atlassian.com' (using password: YES) {code} h3. Notes The setup works fine with MySQL on localhost. h3.Workaround No workaround at this time. |
New:
h3. Summary
When connecting to a database on another server the setup wizard fails to connect. h3. Environment * MySQL * Crowd 2.12.0 h3. Steps to Reproduce # Run the setup wizard # Try to connect to a db on another server h3. Expected Results The setup wizard will use the credentials in the form. h3. Actual Results The below exception is thrown in the atlassian-crowd.log file: The error message in the log when the host is specified is: {code}Caused by: java.sql.SQLException: Access denied for user 'confuser@172.20.52.46'@'anns-mbp.office.atlassian.com' (using password: YES){code} If the username is put in with no parameters, the error message is: {code} Caused by: java.sql.SQLException: Access denied for user 'confuser'@'anns-mbp.office.atlassian.com' (using password: YES) {code} h3. Notes The setup works fine with MySQL on localhost. See attached screen shot for the error in the UI. h3.Workaround No workaround at this time. |
Description | Original: When connecting to a database on another server teh setup wizard fails to connect |
New:
h3. Summary When connecting to a database on another server the setup wizard fails to connect. h3. Environment * MySQL * Crowd 2.12.0 h3. Steps to Reproduce # Run the setup wizard # Try to connect to a db on another server h3. Expected Results The setup wizard will use the credentials in the form. h3. Actual Results The below exception is thrown in the atlassian-crowd.log file: The error message in the log when the host is specified is: {code}Caused by: java.sql.SQLException: Access denied for user 'confuser@172.20.52.46'@'anns-mbp.office.atlassian.com' (using password: YES){code} If the username is put in with no parameters, the error message is: {code} Caused by: java.sql.SQLException: Access denied for user 'confuser'@'anns-mbp.office.atlassian.com' (using password: YES) {code} h3. Notes The setup works fine with MySQL on localhost. h3.Workaround No workaround at this time. |
Attachment | New: Screen Shot 2017-06-16 at 10.44.54 AM.png [ 284398 ] |
Description | New: When connecting to a database on another server teh setup wizard fails to connect |
Hey,
I have the same issue, but the resolution says incorrectly filed. Can anyone point me to a workaround or the reason for the error ?
Thanks