I am facing similar problem with connecting to Jira on Confluence setup. Connection to Jira takes place at http://confluence.localhost/setup/connecttojira.action. This is the message I get:
Connection refused. Check if an instance of Jira 4.3 or later is running on the given url.
The aforementioned error on the page is very ambiguous and it does not tell me anything useful. I am using these versions:
- Jira Software 7.13.0
- Confluence 6.13.1 [build 7901]
- PostgreSQL 9.5
I suspect the problem caused due to the fact that a PostgreSQL database called "confluencedb" has No relations (completely empty). Does it has to be populated at this stage? I concluded so, because a similar database for Jira called "jiradb" is populated with tables right after the docker-compose finishes creating it. I provided the yml file below.
Another hint comes from the atlassian-confluence.log file and one of many error messages looks like this:
WARN [SiteSummaryCalculator:thread-1] [status.service.systeminfo.UsageInfo] getCountForQuery Unable to execute usage info query: SELECT COUNT(*) FROM users - ERROR: relation "users" does
Position: 22
-- referer: http://confluence.localhost/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 0024b35253227cb4 | userName: anonymous | action: setupdbtype
org.postgresql.util.PSQLException: ERROR: relation "users" does not exist
Also Configure Application Links page on Jira was tried to connect to Confluence by adding an IP address, but it does not work and gives an error:
Unable to reach the remote application
We couldn't resolve the hostname at http://confluence.localhost. There may be a DNS configuration problem, or the Application URL for the remote application may be incorrect or may have changed recently.
Please, suggest any ideas, since I run out of any now.
docker-compose.yml
version: '3'
services:
nginx:
container_name: root_nginx_1
restart: always
depends_on:
- jira
- confluence
- postgresql
image: nginx:mainline-alpine
ports:
- "80:80"
- "443:443"
volumes:
- ./nginx/:/etc/nginx/
networks:
- jiranet
jira:
container_name: root_jira_1
restart: always
depends_on:
- postgresql
image: blacklabelops/jira
networks:
- jiranet
volumes:
- jiradata:/var/atlassian/jira
ports:
- "8080:8080"
environment:
- 'JIRA_DATABASE_URL=postgresql://jira@postgresql/jiradb'
- 'JIRA_DB_PASSWORD=mypasswd'
- 'SETENV_JVM_MINIMUM_MEMORY=8g'
- 'SETENV_JVM_MAXIMUM_MEMORY=8g'
- 'JIRA_PROXY_NAME=jira.localhost'
- 'JIRA_PROXY_PORT=80'
- 'JIRA_PROXY_SCHEME=http'
- 'POSTGRES_DB=jiradb'
labels:
com.blacklabelops.description: "Atlassian Jira"
com.blacklabelops.service: "jira"
confluence:
container_name: root_confluence_1
restart: always
depends_on:
- postgresql
image: blacklabelops/confluence
networks:
- jiranet
ports:
- "8090:8090"
volumes:
- confluencedata:/var/atlassian/confluence
environment:
- 'CATALINA_OPTS= -Xms2g -Xmx5g -Dsynchrony.memory.max=4g ${CATALINA_OPTS}'
- 'CONFLUENCE_PROXY_NAME=confluence.localhost'
- 'CONFLUENCE_PROXY_PORT=80'
- 'CONFLUENCE_PROXY_SCHEME=http'
- 'CONFLUENCE_DELAYED_START='
- 'POSTGRES_DB=confluencedb'
labels:
com.blacklabelops.description: "Atlassian Confluence"
com.blakclabelops.service: "confluence"
postgresql:
container_name: root_postgresql_1
restart: always
image: blacklabelops/postgres
networks:
- jiranet
volumes:
- postgresqldata:/var/lib/postgresql/data
environment:
- 'POSTGRES_USER=jira'
- 'POSTGRES_PASSWORD=mypasswd'
- 'POSTGRES_DB=jiradb'
- 'POSTGRES_ENCODING=UTF8'
- 'POSTGRES_COLLATE=C'
- 'POSTGRES_COLLATE_TYPE=C'
labels:
com.blacklabelops.description: "PostgreSQL Database Server"
com.blacklabelops.service: "postgresql"
volumes:
confluencedata:
external: false
jiradata:
external: false
postgresqldata:
external: false
networks:
jiranet:
driver: bridge
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.