Jira stops after Database Setup. Nginx throws 502

[Deleted user]

I start Jira and get to the Setup instructions:

(Google example picture)

"Test connection" works fin.

I click next and get an 502 Error from Nginx and reload and anithing won´t work.
I tried to restart Jira but i didn´t help.

All files:

https://www.dropbox.com/sh/i6sq98gk50aousk/AAC5H5gtZkk33SGSNKUodpDZa?dl=0

[Deleted user]

I have tried it now with the built-in database. The setup has gone through with a few timeouts. Is it perhaps the two networks and the communication to the database?

[brbojorque]

Hi @[deleted] ,

It looks like the database is working perfectly fine, the problem is NGINX cannot access the localhost:8080.

You have to make sure that nginx can actually access the local instance of jira.

There is a command for it in linux.

[Deleted user]

Hi @brbojorque ,

Thanks for your quick reply.

At the beginning, Jira starts normally and can also be reached via the domain. 

jira.fancydomain.de 87.162.XX.XX - - 19 Jun 2019:22:33:20 +0000 GET /secure/SetupDatabase!default.jspa HTTP/2.0 200 6094 https://jira.fancydomain.de/secure/SetupMode!default.jspa Mozilla5.0 Windows NT 10.0; Win64; x64 AppleWebKit 537.36 KHTML, like Gecko Chrome 75.0.3770.100 Safari 537.36

I get a 200 response and the first setup screen from Jira. The problems seem to occur when Jira runs the Initzial database setup.

Was that what you mean or did I misunderstand?

Sincerely,

Luis

[brbojorque]

@[deleted] , can you check if the server has enough resources to run both Jira and docker within the same server?

Try to ping the instances locally in the server.

ping localhost:8080

--

Check also all the services if it is running.

netstat -ntpl

[Deleted user]

Nginx:

/app # ping localhost:8080
PING localhost:8080 (127.0.0.1): 56 data bytes
64 bytes from 127.0.0.1: seq=0 ttl=64 time=0.095 ms
64 bytes from 127.0.0.1: seq=1 ttl=64 time=0.059 ms
64 bytes from 127.0.0.1: seq=2 ttl=64 time=0.081 ms
64 bytes from 127.0.0.1: seq=3 ttl=64 time=0.089 ms
64 bytes from 127.0.0.1: seq=4 ttl=64 time=0.078 ms
64 bytes from 127.0.0.1: seq=5 ttl=64 time=0.062 ms

 /app # wget localhost:8080
--2019-06-21 08:11:25-- http://localhost:8080/
Resolving localhost... 127.0.0.1, ::1
Connecting to localhost|127.0.0.1|:8080... failed: Connection refused.
Connecting to localhost|::1|:8080... failed: Network unreachable.

 /app # netstat -tulpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.11:43336 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 28/nginx: master pr
tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN 28/nginx: master pr
udp 0 0 127.0.0.11:51088 0.0.0.0:* -

Host:

nmap -p 8080 localhost

Starting Nmap 7.40 ( https://nmap.org ) at 2019-06-21 10:23 CEST
Nmap scan report for localhost (127.0.0.1)
Host is up (0.00015s latency).
Other addresses for localhost (not scanned): ::1
PORT STATE SERVICE
8080/tcp open http-proxy

Nmap done: 1 IP address (1 host up) scanned in 0.33 seconds

netstat -tulpn
Aktive Internetverbindungen (Nur Server)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:5355 0.0.0.0:* LISTEN 248/systemd-resolve
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 78/rpcbind
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 2368/sshd
tcp6 0 0 :::5355 :::* LISTEN 248/systemd-resolve
tcp6 0 0 :::111 :::* LISTEN 78/rpcbind
tcp6 0 0 :::8080 :::* LISTEN 6819/docker-proxy
tcp6 0 0 :::80 :::* LISTEN 3853/docker-proxy
tcp6 0 0 :::22 :::* LISTEN 2368/sshd
tcp6 0 0 :::443 :::* LISTEN 3841/docker-proxy
udp 0 0 127.0.0.53:53 0.0.0.0:* 248/systemd-resolve
udp 0 0 0.0.0.0:111 0.0.0.0:* 78/rpcbind
udp 0 0 0.0.0.0:678 0.0.0.0:* 78/rpcbind
udp 0 0 0.0.0.0:5355 0.0.0.0:* 248/systemd-resolve
udp6 0 0 :::111 :::* 78/rpcbind
udp6 0 0 :::678 :::* 78/rpcbind
udp6 0 0 :::5355 :::* 248/systemd-resolve

System usage:

top - 10:28:00 up 3 days, 12:07, 3 users, load average: 0,00, 0,06, 0,10
Tasks: 57 total, 2 running, 55 sleeping, 0 stopped, 0 zombie
%Cpu(s): 2,1 us, 0,8 sy, 0,0 ni, 97,1 id, 0,0 wa, 0,0 hi, 0,0 si, 0,0 st
KiB Mem : 2097152 total, 50996 free, 1497852 used, 548304 buff/cache
KiB Swap: 0 total, 0 free, 0 used. 567480 avail Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6844 bin 20 0 4257580 1,204g 26732 S 1,0 60,2 3:30.14 java
4254 root 20 0 112720 6156 1380 S 0,7 0,3 0:12.97 docker-gen
3812 jarvisCi 20 0 349952 24740 1168 S 0,3 1,2 0:13.86 docker-compose
3954 root 20 0 14540 3112 1184 S 0,3 0,1 0:12.85 docker-gen
8072 root 20 0 42800 1996 1388 R 0,3 0,1 0:00.07 top
1 root 20 0 56996 3196 1940 S 0,0 0,2 0:08.85 systemd
2 root 20 0 0 0 0 S 0,0 0,0 0:00.00 kthreadd/283665
3 root 20 0 0 0 0 S 0,0 0,0 0:00.00 khelper
61 root 20 0 70672 13692 13380 S 0,0 0,7 0:19.52 systemd-journal
65 root 20 0 43152 684 264 S 0,0 0,0 0:07.45 systemd-udevd
73 systemd+ 20 0 48696 1636 1080 S 0,0 0,1 0:04.76 systemd-network
78 root 20 0 49860 504 0 S 0,0 0,0 0:00.52 rpcbind
132 root 20 0 29628 160 56 S 0,0 0,0 0:00.68 cron
134 root 20 0 250104 540 0 S 0,0 0,0 0:02.56 rsyslogd
206 root 20 0 68704 84 0 S 0,0 0,0 0:00.00 saslauthd
208 root 20 0 68704 88 0 S 0,0 0,0 0:00.00 saslauthd
248 systemd+ 20 0 49612 1068 884 S 0,0 0,1 0:07.48 systemd-resolve
264 root 20 0 20212 4 0 S 0,0 0,0 0:00.00 xinetd
2368 root 20 0 69944 568 416 S 0,0 0,0 0:34.61 sshd
2763 root 20 0 95172 1620 668 S 0,0 0,1 0:00.06 sshd
2776 jarvisCi 20 0 95172 1412 436 S 0,0 0,1 0:00.39 sshd
2777 jarvisCi 20 0 19912 1284 748 S 0,0 0,1 0:00.05 bash
3589 root 20 0 95172 1576 616 S 0,0 0,1 0:00.05 sshd
3595 jarvisCi 20 0 95172 1392 384 S 0,0 0,1 0:00.48 sshd
3596 jarvisCi 20 0 19916 1332 720 S 0,0 0,1 0:00.09 bash
3811 jarvisCi 20 0 12520 4136 0 S 0,0 0,2 0:00.22 docker-compose
3841 root 20 0 9212 2284 1160 S 0,0 0,1 0:00.01 docker-proxy
3853 root 20 0 8156 2288 1160 S 0,0 0,1 0:00.00 docker-proxy
3859 root 20 0 11776 3948 2876 S 0,0 0,2 0:00.79 containerd-shim
3877 root 20 0 11796 3912 84 S 0,0 0,2 0:00.79 forego
3951 root 20 0 6236 200 0 S 0,0 0,0 0:00.00 bash
3953 root 20 0 6232 196 0 S 0,0 0,0 0:00.00 bash
3959 root 20 0 65348 1488 268 S 0,0 0,1 0:00.17 nginx
3991 root 20 0 10720 3588 2576 S 0,0 0,2 0:00.23 containerd-shim
4011 root 20 0 2160 176 0 S 0,0 0,0 0:00.17 bash
4250 root 20 0 2664 1028 292 S 0,0 0,0 0:01.00 letsencrypt_ser
6250 message+ 20 0 45244 868 228 S 0,0 0,0 0:01.08 dbus-daemon
6386 root 20 0 317300 2580 820 S 0,0 0,1 0:01.91 packagekitd
6399 root 20 0 286184 836 0 S 0,0 0,0 0:00.15 polkitd
6405 root 20 0 46412 1644 1104 S 0,0 0,1 0:00.88 systemd-logind
6686 root 20 0 95172 1700 732 S 0,0 0,1 0:00.05 sshd
6692 jarvisCi 20 0 95172 1416 432 S 0,0 0,1 0:00.35 sshd
6693 jarvisCi 20 0 19916 1604 1000 S 0,0 0,1 0:00.13 bash
6711 root 20 0 14292 128 0 S 0,0 0,0 0:00.00 agetty
6712 root 20 0 12648 128 0 S 0,0 0,0 0:00.00 agetty
6788 jarvisCi 20 0 12520 4180 8 S 0,0 0,2 0:00.23 docker-compose
6789 jarvisCi 20 0 284416 27060 3828 R 0,0 1,3 0:04.27 docker-compose
6819 root 20 0 8156 2284 1160 S 0,0 0,1 0:00.00 docker-proxy
6825 root 20 0 10720 3900 2824 S 0,0 0,2 0:00.06 containerd-shim
6933 systemd+ 20 0 66028 2140 560 S 0,0 0,1 0:00.79 nginx
7424 root 20 0 1908 308 204 S 0,0 0,0 0:00.00 sleep
7478 root 20 0 435148 21492 4876 S 0,0 1,0 1:23.43 containerd
7602 root 20 0 50880 1184 768 S 0,0 0,1 0:00.02 su
7603 root 20 0 19972 2064 1424 S 0,0 0,1 0:00.14 bash
12502 root 20 0 591064 62112 22616 S 0,0 3,0 3:05.83 dockerd
14761 root 20 0 56384 2304 1432 S 0,0 0,1 0:01.20 systemd
14762 root 20 0 82520 1388 60 S 0,0 0,1 0:00.00 (sd-pam)

Nginx Stats:

CONTAINER ID NAME CPU % MEM USAGE / LIMIT MEM % NET I/O BLOCK I/O PIDS
f7121e8b5614 nginx 0.15% 14.86MiB / 2GiB 0.73% 19.1MB / 20.6MB 0B / 0B 19

 Jira Stats:

CONTAINER ID NAME CPU % MEM USAGE / LIMIT MEM % NET I/O BLOCK I/O PIDS
a212ccbd8062 jiraSoftware 3.37% 1.21GiB / 2GiB 60.51% 1.58MB / 12.8MB 0B / 0B 133 

[Deleted user]

Jira is currently running on the RAM based built-in database.

docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
a212ccbd8062 cptactionhank/atlassian-jira-software:8.1.0 "/docker-entrypoint.…" 2 hours ago Up About an hour 0.0.0.0:8080->8080/tcp jiraSoftware
b267c9ce9245 jrcs/letsencrypt-nginx-proxy-companion "/bin/bash /app/entr…" 2 hours ago Up 2 hours nginxLetsEncrypt
f7121e8b5614 jwilder/nginx-proxy:alpine "/app/docker-entrypo…" 2 hours ago Up 2 hours 0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp nginx

[brbojorque]

Hi @[deleted] ,

The configuration is a bit odd but for the most part, it is correct. Focus the troubleshooting in docker and networking, nginx. 

Other than that I can't help unless I recreate the environment and troubleshoot myself.