Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-66178

Database Login fails when using special characters in the password in PostgreSQL 9.3 and 9.6

XMLWordPrintable

      Issue Summary

      * When using a password like with characters like '#μX)!]@-}' the login to the database fails in PostgreSQL 9.3 and 9.6.

      Steps to Reproduce
      • Configure JIRA to use a PostgreSQL database, having a user with a password containing special characters.
         
      Expected Behavior
      • JIRA Starts and it makes a successful login
         
      Actual Behavior
      • We receive a login failed error:
        2017-10-19 17:26:31,333 JIRA-Bootstrap ERROR      [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database: 
        org.postgresql.util.PSQLException: FATAL: password authentication failed for user "jirauser"
        	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:443)
        	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:217)
      Cause
      • Unknown.
      Workaround
      • Not using any special characters in the password
      • To use another database option.
      Notes
      • A similar issue was present before and was fixed in: JRASERVER-27796 although this time the issue is specific to PostgreSQL I tested in MySQL 5.7 and the issue is not present.

              Unassigned Unassigned
              rchiquete Rene C. [Atlassian Support] (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: