• Type: Bug
• Resolution: Not a bug
• Priority: Medium
• Fix Version/s: None
• Affects Version/s: master
• Component/s: Environment - Docker
• Labels:

  None

1. Screen Shot 2019-10-15 at 3.26.27 pm.png

   15/Oct/2019 5:10 AM

   115 kB

   Lei Wang

[SCALE-1] Confluence docker database configuration not working

Carlos Corredor made changes - 31/Oct/2019 10:13 PM

Resolution		New: Not a bug [ 12 ]
Status	Original: Needs Triage [ 10030 ]	New: Closed [ 6 ]

Dave Chevell made changes - 17/Oct/2019 1:46 AM

Description

Original: h3. Issue Summary Confluence docker was not able to start up by following the database configuration in https://hub.docker.com/r/atlassian/confluence-server. Keep getting *Setup Database Failed* error from UI. h3. Environment * Confluence docker h3. Steps to Reproduce {code} docker run --name="confluence" -d \ -p 8090:8090 \ -p 8091:8091 \ -v ~/docker-home/confluence-home:/var/atlassian/application-data/confluence \ -e ATL_JDBC_URL=jdbc:postgresql://postgres.testnet:5432/confluence \ -e ATL_JDBC_USER=username \ -e ATL_JDBC_PASSWORD= \ -e ATL_DB_TYPE=postgresql \ --network testnet \ atlassian/confluence-server:latest {code} h3. Expected Results Avoiding the need to do the database setup through the UI. h3. Actual Results !Screen Shot 2019-10-15 at 3.26.27 pm.png|width=500! h3. Note Here is the template of confluence.cfg.xml in /etc/atlassian/etc/confluence.cfg.xml.j2 {code} {% if atl_jdbc_url is defined %}       {% set databases = {            "mysql": ["com.mysql.jdbc.Driver", "MySQLDialect"],            "postgresql": ["org.postgresql.Driver", "PostgreSQLDialect"],            "mssql": ["com.microsoft.sqlserver.jdbc.SQLServerDriver", "SQLServerDialect"],            "oracle12c": ["oracle.jdbc.driver.OracleDriver", "OracleDialect"]           } %}       <property name="confluence.database.choice">{{ atl_db_type }}</property>       <property name="hibernate.connection.url">{{ atl_jdbc_url }}</property>       <property name="hibernate.connection.username">{{ atl_jdbc_user }}</property>       <property name="hibernate.connection.password">{{ atl_jdbc_password }}</property>       <property name="hibernate.connection.driver_class">{{ databases[atl_db_type][0] }}</property>       <property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.{{ databases[atl_db_type][1] }}</property> {code} h3. Workaround * A password must b

New: h3. Issue Summary Confluence docker was not able to start up by following the database configuration in https://hub.docker.com/r/atlassian/confluence-server. Keep getting *Setup Database Failed* error from UI. h3. Environment * Confluence docker h3. Steps to Reproduce {code} docker run --name="confluence" -d \ -p 8090:8090 \ -p 8091:8091 \ -v ~/docker-home/confluence-home:/var/atlassian/application-data/confluence \ -e ATL_JDBC_URL=jdbc:postgresql://postgres.testnet:5432/confluence \ -e ATL_JDBC_USER=username \ -e ATL_JDBC_PASSWORD= \ -e ATL_DB_TYPE=postgresql \ --network testnet \ atlassian/confluence-server:latest {code} h3. Expected Results Avoiding the need to do the database setup through the UI. h3. Actual Results !Screen Shot 2019-10-15 at 3.26.27 pm.png|width=500! h3. Note Here is the template of confluence.cfg.xml in /etc/atlassian/etc/confluence.cfg.xml.j2 {code} {% if atl_jdbc_url is defined %}       {% set databases = {            "mysql": ["com.mysql.jdbc.Driver", "MySQLDialect"],            "postgresql": ["org.postgresql.Driver", "PostgreSQLDialect"],            "mssql": ["com.microsoft.sqlserver.jdbc.SQLServerDriver", "SQLServerDialect"],            "oracle12c": ["oracle.jdbc.driver.OracleDriver", "OracleDialect"]           } %}       <property name="confluence.database.choice">{{ atl_db_type }}</property>       <property name="hibernate.connection.url">{{ atl_jdbc_url }}</property>       <property name="hibernate.connection.username">{{ atl_jdbc_user }}</property>       <property name="hibernate.connection.password">{{ atl_jdbc_password }}</property>       <property name="hibernate.connection.driver_class">{{ databases[atl_db_type][0] }}</property>       <property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.{{ databases[atl_db_type][1] }}</property> {code} h3. Workaround * A password must be specified using the {{ATL_JDBC_PASSWORD}} environment variable

Dave Chevell made changes - 17/Oct/2019 1:45 AM

Description

Original: h3. Issue Summary Confluence docker was not able to start up by following the database configuration in https://hub.docker.com/r/atlassian/confluence-server. Keep getting *Setup Database Failed* error from UI. h3. Environment * Confluence docker h3. Steps to Reproduce {code} docker run --name="confluence" -d \ -p 8090:8090 \ -p 8091:8091 \ -v ~/docker-home/confluence-home:/var/atlassian/application-data/confluence \ -e ATL_JDBC_URL=jdbc:postgresql://postgres.testnet:5432/confluence \ -e ATL_JDBC_USER=username \ -e ATL_JDBC_PASSWORD= \ -e ATL_DB_TYPE=postgresql \ --network testnet \ atlassian/confluence-server:latest {code} h3. Expected Results Avoiding the need to do the database setup through the UI. h3. Actual Results !Screen Shot 2019-10-15 at 3.26.27 pm.png|width=500! h3. Note Here is the template of confluence.cfg.xml in /etc/atlassian/etc/confluence.cfg.xml.j2 {code} {% if atl_jdbc_url is defined %}       {% set databases = {            "mysql": ["com.mysql.jdbc.Driver", "MySQLDialect"],            "postgresql": ["org.postgresql.Driver", "PostgreSQLDialect"],            "mssql": ["com.microsoft.sqlserver.jdbc.SQLServerDriver", "SQLServerDialect"],            "oracle12c": ["oracle.jdbc.driver.OracleDriver", "OracleDialect"]           } %}       <property name="confluence.database.choice">{{ atl_db_type }}</property>       <property name="hibernate.connection.url">{{ atl_jdbc_url }}</property>       <property name="hibernate.connection.username">{{ atl_jdbc_user }}</property>       <property name="hibernate.connection.password">{{ atl_jdbc_password }}</property>       <property name="hibernate.connection.driver_class">{{ databases[atl_db_type][0] }}</property>       <property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.{{ databases[atl_db_type][1] }}</property> {code} h3. Workaround * Have to do it via UI.

New: h3. Issue Summary Confluence docker was not able to start up by following the database configuration in https://hub.docker.com/r/atlassian/confluence-server. Keep getting *Setup Database Failed* error from UI. h3. Environment * Confluence docker h3. Steps to Reproduce {code} docker run --name="confluence" -d \ -p 8090:8090 \ -p 8091:8091 \ -v ~/docker-home/confluence-home:/var/atlassian/application-data/confluence \ -e ATL_JDBC_URL=jdbc:postgresql://postgres.testnet:5432/confluence \ -e ATL_JDBC_USER=username \ -e ATL_JDBC_PASSWORD= \ -e ATL_DB_TYPE=postgresql \ --network testnet \ atlassian/confluence-server:latest {code} h3. Expected Results Avoiding the need to do the database setup through the UI. h3. Actual Results !Screen Shot 2019-10-15 at 3.26.27 pm.png|width=500! h3. Note Here is the template of confluence.cfg.xml in /etc/atlassian/etc/confluence.cfg.xml.j2 {code} {% if atl_jdbc_url is defined %}       {% set databases = {            "mysql": ["com.mysql.jdbc.Driver", "MySQLDialect"],            "postgresql": ["org.postgresql.Driver", "PostgreSQLDialect"],            "mssql": ["com.microsoft.sqlserver.jdbc.SQLServerDriver", "SQLServerDialect"],            "oracle12c": ["oracle.jdbc.driver.OracleDriver", "OracleDialect"]           } %}       <property name="confluence.database.choice">{{ atl_db_type }}</property>       <property name="hibernate.connection.url">{{ atl_jdbc_url }}</property>       <property name="hibernate.connection.username">{{ atl_jdbc_user }}</property>       <property name="hibernate.connection.password">{{ atl_jdbc_password }}</property>       <property name="hibernate.connection.driver_class">{{ databases[atl_db_type][0] }}</property>       <property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.{{ databases[atl_db_type][1] }}</property> {code} h3. Workaround * A password must b

Dave Chevell made changes - 17/Oct/2019 1:45 AM

Assignee

New: Dave Chevell [ dchevell ]

Adam Brokes made changes - 17/Oct/2019 12:51 AM

Priority

Original: Low [ 4 ]

New: Medium [ 3 ]

Adam Brokes made changes - 17/Oct/2019 12:50 AM

Component/s		New: Docker [ 59292 ]
Component/s	Original: Server - Platform [ 43206 ]
Key	Original: CONFSERVER-58996	New: SCALE-1
QA Demo Status	Original: Not Done [ 14330 ]
QA Kickoff Status	Original: Not Done [ 14234 ]
Symptom Severity	Original: Severity 3 - Minor [ 15832 ]	New: Severity 2 - Major [ 14431 ]
Affects Version/s		New: master [ 89990 ]
Affects Version/s	Original: 7.0.2 [ 89296 ]
Workflow	Original: CONFSERVER Bug Workflow v4 [ 3755476 ]	New: JAC Bug Workflow v3 [ 3757322 ]
Project	Original: Confluence Server [ 10470 ]	New: Server Deployments and Scale [ 20410 ]

Lei Wang made changes - 15/Oct/2019 5:26 AM

Description

Original: h3. Issue Summary Confluence docker was not able to start up by following the database configuration in https://hub.docker.com/r/atlassian/confluence-server. Keep getting *Setup Database Failed* error from UI. h3. Environment * Confluence docker h3. Steps to Reproduce {code} docker run --name="confluence" -d \ -p 8090:8090 \ -p 8091:8091 \ -v ~/docker-home/confluence-home:/var/atlassian/application-data/confluence \ -e ATL_JDBC_URL=jdbc:postgresql://postgres.testnet:5432/confluence \ -e ATL_JDBC_USER=username \ -e ATL_JDBC_PASSWORD= \ -e ATL_DB_TYPE=postgresql \ --network testnet \ atlassian/confluence-server:latest {code} h3. Expected Results Avoiding the need to do the database setup through the UI. h3. Actual Results !Screen Shot 2019-10-15 at 3.26.27 pm.png|width=500! h3. Note I noted the following in /etc/atlassian/etc/confluence.cfg.xml.j2 {code} {% if atl_jdbc_url is defined %}       {% set databases = {            "mysql": ["com.mysql.jdbc.Driver", "MySQLDialect"],            "postgresql": ["org.postgresql.Driver", "PostgreSQLDialect"],            "mssql": ["com.microsoft.sqlserver.jdbc.SQLServerDriver", "SQLServerDialect"],            "oracle12c": ["oracle.jdbc.driver.OracleDriver", "OracleDialect"]           } %}       <property name="confluence.database.choice">{{ atl_db_type }}</property>       <property name="hibernate.connection.url">{{ atl_jdbc_url }}</property>       <property name="hibernate.connection.username">{{ atl_jdbc_user }}</property>       <property name="hibernate.connection.password">{{ atl_jdbc_password }}</property>       <property name="hibernate.connection.driver_class">{{ databases[atl_db_type][0] }}</property>       <property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.{{ databases[atl_db_type][1] }}</property> {code} I think the *if* line should be defined as *atl_db_type* instead of *atl_jdbc_url*. h3. Workaround * Have to do it via UI.

New: h3. Issue Summary Confluence docker was not able to start up by following the database configuration in https://hub.docker.com/r/atlassian/confluence-server. Keep getting *Setup Database Failed* error from UI. h3. Environment * Confluence docker h3. Steps to Reproduce {code} docker run --name="confluence" -d \ -p 8090:8090 \ -p 8091:8091 \ -v ~/docker-home/confluence-home:/var/atlassian/application-data/confluence \ -e ATL_JDBC_URL=jdbc:postgresql://postgres.testnet:5432/confluence \ -e ATL_JDBC_USER=username \ -e ATL_JDBC_PASSWORD= \ -e ATL_DB_TYPE=postgresql \ --network testnet \ atlassian/confluence-server:latest {code} h3. Expected Results Avoiding the need to do the database setup through the UI. h3. Actual Results !Screen Shot 2019-10-15 at 3.26.27 pm.png|width=500! h3. Note Here is the template of confluence.cfg.xml in /etc/atlassian/etc/confluence.cfg.xml.j2 {code} {% if atl_jdbc_url is defined %}       {% set databases = {            "mysql": ["com.mysql.jdbc.Driver", "MySQLDialect"],            "postgresql": ["org.postgresql.Driver", "PostgreSQLDialect"],            "mssql": ["com.microsoft.sqlserver.jdbc.SQLServerDriver", "SQLServerDialect"],            "oracle12c": ["oracle.jdbc.driver.OracleDriver", "OracleDialect"]           } %}       <property name="confluence.database.choice">{{ atl_db_type }}</property>       <property name="hibernate.connection.url">{{ atl_jdbc_url }}</property>       <property name="hibernate.connection.username">{{ atl_jdbc_user }}</property>       <property name="hibernate.connection.password">{{ atl_jdbc_password }}</property>       <property name="hibernate.connection.driver_class">{{ databases[atl_db_type][0] }}</property>       <property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.{{ databases[atl_db_type][1] }}</property> {code} h3. Workaround * Have to do it via UI.

Lei Wang made changes - 15/Oct/2019 5:24 AM

Description

Original: h3. Issue Summary Confluence docker was not able to start up by following the database configuration in https://hub.docker.com/r/atlassian/confluence-server. Keep getting *Setup Database Failed* error from UI. h3. Environment * Confluence docker h3. Steps to Reproduce {code} docker run --name="confluence" -d \ -p 8090:8090 \ -p 8091:8091 \ -v ~/docker-home/confluence-home:/var/atlassian/application-data/confluence \ -e ATL_JDBC_URL=jdbc:postgresql://postgres.network:5432/confluence \ -e ATL_JDBC_USER=username \ -e ATL_JDBC_PASSWORD= \ -e ATL_DB_TYPE=postgresql \ --network testnet \ atlassian/confluence-server:latest {code} h3. Expected Results Avoiding the need to do the database setup through the UI. h3. Actual Results !Screen Shot 2019-10-15 at 3.26.27 pm.png|width=500! h3. Note I noted the following in /etc/atlassian/etc/confluence.cfg.xml.j2 {code} {% if atl_jdbc_url is defined %}       {% set databases = {            "mysql": ["com.mysql.jdbc.Driver", "MySQLDialect"],            "postgresql": ["org.postgresql.Driver", "PostgreSQLDialect"],            "mssql": ["com.microsoft.sqlserver.jdbc.SQLServerDriver", "SQLServerDialect"],            "oracle12c": ["oracle.jdbc.driver.OracleDriver", "OracleDialect"]           } %}       <property name="confluence.database.choice">{{ atl_db_type }}</property>       <property name="hibernate.connection.url">{{ atl_jdbc_url }}</property>       <property name="hibernate.connection.username">{{ atl_jdbc_user }}</property>       <property name="hibernate.connection.password">{{ atl_jdbc_password }}</property>       <property name="hibernate.connection.driver_class">{{ databases[atl_db_type][0] }}</property>       <property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.{{ databases[atl_db_type][1] }}</property> {code} I think the *if* line should be defined as *atl_db_type* instead of *atl_jdbc_url*. h3. Workaround * Have to do it via UI.

New: h3. Issue Summary Confluence docker was not able to start up by following the database configuration in https://hub.docker.com/r/atlassian/confluence-server. Keep getting *Setup Database Failed* error from UI. h3. Environment * Confluence docker h3. Steps to Reproduce {code} docker run --name="confluence" -d \ -p 8090:8090 \ -p 8091:8091 \ -v ~/docker-home/confluence-home:/var/atlassian/application-data/confluence \ -e ATL_JDBC_URL=jdbc:postgresql://postgres.testnet:5432/confluence \ -e ATL_JDBC_USER=username \ -e ATL_JDBC_PASSWORD= \ -e ATL_DB_TYPE=postgresql \ --network testnet \ atlassian/confluence-server:latest {code} h3. Expected Results Avoiding the need to do the database setup through the UI. h3. Actual Results !Screen Shot 2019-10-15 at 3.26.27 pm.png|width=500! h3. Note I noted the following in /etc/atlassian/etc/confluence.cfg.xml.j2 {code} {% if atl_jdbc_url is defined %}       {% set databases = {            "mysql": ["com.mysql.jdbc.Driver", "MySQLDialect"],            "postgresql": ["org.postgresql.Driver", "PostgreSQLDialect"],            "mssql": ["com.microsoft.sqlserver.jdbc.SQLServerDriver", "SQLServerDialect"],            "oracle12c": ["oracle.jdbc.driver.OracleDriver", "OracleDialect"]           } %}       <property name="confluence.database.choice">{{ atl_db_type }}</property>       <property name="hibernate.connection.url">{{ atl_jdbc_url }}</property>       <property name="hibernate.connection.username">{{ atl_jdbc_user }}</property>       <property name="hibernate.connection.password">{{ atl_jdbc_password }}</property>       <property name="hibernate.connection.driver_class">{{ databases[atl_db_type][0] }}</property>       <property name="hibernate.dialect">com.atlassian.confluence.impl.hibernate.dialect.{{ databases[atl_db_type][1] }}</property> {code} I think the *if* line should be defined as *atl_db_type* instead of *atl_jdbc_url*. h3. Workaround * Have to do it via UI.

Lei Wang created issue - 15/Oct/2019 5:16 AM