Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-4941

Setup wizard appending local hostname to MySQL database user

    • Icon: Bug Bug
    • Resolution: Incorrectly Filed
    • Icon: Low Low
    • None
    • 2.11.2, 2.12.0
    • None
    • None

      Summary

      When connecting to a database on another server the setup wizard fails to connect.

      Environment

      • MySQL
      • Crowd 2.12.0

      Steps to Reproduce

      1. Run the setup wizard
      2. 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

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 - restricted [ 2309961 ] New: JAC Bug Workflow v3 [ 3365825 ]
            Owen made changes -
            Symptom Severity Original: Major [ 14431 ] New: Severity 2 - Major [ 15831 ]

            Avinash added a comment -

            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

            Avinash added a comment - 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
            Ann Worley (Inactive) made changes -
            Resolution New: Incorrectly Filed [ 10100 ]
            Status Original: Open [ 1 ] New: Closed [ 6 ]
            Ann Worley (Inactive) made changes -
            Affects Version/s New: 2.11.2 [ 67342 ]
            Ann Worley (Inactive) made changes -
            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.
            Ann Worley (Inactive) made changes -
            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.
            Ann Worley (Inactive) made changes -
            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.
            Ann Worley (Inactive) made changes -
            Attachment New: Screen Shot 2017-06-16 at 10.44.54 AM.png [ 284398 ]
            Ann Worley (Inactive) made changes -
            Description New: When connecting to a database on another server teh setup wizard fails to connect

              Unassigned Unassigned
              aworley Ann Worley (Inactive)
              Affected customers:
              0 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: