Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
7.5.0-EAP01
-
- JIRA 7.5
- PostgreSQL 9.3/9.6
-
7.05
-
4
-
Severity 3 - Minor
-
1
-
Description
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.