In some cases, force the SSL connection to the database could lead to Collation not being detected. Jdbc:postgresql://DB-Server:5432/jiradb?ssl=true JIRA 7.13 / postgreSQL driver below version 42.2.5: jdbc:postgresql://DB-Server:5432/jiradb?ssl=trueįor JIRA 8.5 / postgreSQL driver above version 42.2.5: jdbc:postgresql://DB-Server:5432/jiradb?sslmode=requireĭepending on the setup the following URLs may need to be used: jdbc:postgresql://DB-Server:5432/jiradb?sslmode=prefer jdbc:postgresql://DB-Server:5432/jiradb?sslmode=allow

Edit the dbconfig.xml (located at the jira-home directory) as follows:įor JIRA 7.13 / postgreSQL driver below version 42.2.5: Add the following parameter to the JDBC URL parameter: ssl=trueįor JIRA 8.5 / postgreSQL driver above version 42.2.5: Add the following parameter to the JDBC URL parameter: sslmode=require.

Product: Jira, Confluence, Bamboo, Bitbucket, Fisheye, Crucible, Crowd: Platform: Server.

This can happen when attempting to connect securely to other systems such as Active Directory, another Atlassian application, and mail servers. You will need to manually edit the dbconfig.xml to force the SSL connection. Attempting to access applications that are encrypted with SSL throws an exception and the connection is refused. This is being tracked in the following feature request: It is currently not possible to force the SSL connection to the database from the Jira Web UI. Please report this exception.Īt (Driver.java:275)Īt (DriverManager.java:664)Īt (DriverManager.java:247)Īt .DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:347)Īt .(JdbcDatasource.java:211)Īt .(DatabaseConfig.java:87)Īt .(SetupDatabase.java:225)Īt .(SetupDatabase.java:189)Īt .(SetupDatabase.java:121)Īt .invoke(Method.java:498)Īt $DefaultInjectionImpl.invoke(InjectionUtils.java:70)Īt (InjectionUtils.java:56)Īt .JiraActionSupport.execute(JiraActionSupport.java:63)Īt .service(HttpServlet.java:729)Īt .JiraSecurityFilter.lambda$doFilter$2(JiraSecurityFilter.java:78)Īt .JiraSecurityFilter.doFilter(JiraSecurityFilter.java:76)Īt .CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)Īt .MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)Īt .runWorker(ThreadPoolExecutor.java:1149)Īt $n(ThreadPoolExecutor.java:624)Īt .threads.TaskThread$n(TaskThread.java:61)Ĭaused by: Īt .(CategoryKey.java:32)Īt .getLogger(Hierarchy.java:266)Īt .getLogger(Hierarchy.java:247)Īt .getLogger(LogManager.java:228)Īt .getLogger(Logger.java:104)Īt .log(Logger.java:738)Īt 3.ConnectionFactoryImpl.log(ConnectionFactoryImpl.java:317)Īt 3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:261)Īt .openConnection(ConnectionFactory.java:49)Īt .(PgConnection.java:195)Īt (Driver.java:452)Īt (Driver.java:254) : Something unusual has occurred to cause the driver to fail. 15:25:48,747 http-nio-8080-exec-1 ERROR anonymous 925x38x1 92lmp6 10.53.222.101 /secure/SetupDatabase!connectionCheck.jspa Could not successfully test your database:

Error occurred while connecting to ssl