How to connect local computers to a jira server pc ?

[Yusuf Can Anar]

Hi, 

I have followed this link : https://www.pro-productmanagement.com/software-jira/install-jira-on-windows to achieve installation of JIRA on windows database(my dekstop computer). I have succesfully created a database connected with JIRA software.

I was able to log in with 2 different account in the same desktop pc. However i want to connect my laptop(which is connected to the same local network(my wifi router) to the server through jira app(or any ways of connecting my local database).

What i want to learn is how can i log in as user(not using the server pc) from another laptop in the local network? 

Database: PostgreSQL with pgAdmin

Jira Software version 8.3.0 

Note: I have also installed jira software as service to my laptop. When go to localhost:8080 i can see the figure 1 and when i click "I'll set it up for myself" figure 2 comes and i fill them as my database created on the other pc. When i test the connection it pops an error.  

Figure 1Figure 2 

[Nic Brough -Adaptavist-]

There are two parts to this question.

The main one you have explicitly asked is "how do I connect another machine to the server" - there are several ways to do it, but the best option for getting started is simply a browser.  Let's say you have installed Jira on a server called "Charlie" with an ip address of 192.168.1.42, and not customised anything away from the defaults.  Another machine on your network will be able to use that Jira by firing up a browser and entering "http:charlie:8080" as the url.  If you have not got charlie in DNS, then you'll have to use the ip address directly, which would be "http:192.168.1.42:8080"

I always make sure this direct default route is working before I do the rest of the usual setup most people want - moving the url to be part of a site, getting rid of the port 8080 thing and shifting it to https.  (My Jira urls are almost always things like https://someones-website-with-other-things/jira")

However, that's jumping ahead.

Your second question is about connecting the server to a database - you have not completed the setup of Jira yet, so there's no point looking at the url or remote access yet (you could, but you'll get the same results).

It cannot connect to the postgres database you have told it to use.  This could be any number of things, but, in my experience, 5% of the failures I've seen are "our network does not allow traffic on the port postgres is listening on (default 5432)" and the other 95% are down to /etc/postgresql/<version>/main/pg_hba.conf disallowing the connection.

I'd start with a look at the local access to the database, and once that works, look to remote.

[Yusuf Can Anar]

Hey thanks for replying. I have cleared everything and made a new installation for microsoft sql. Database is connected with jira server. But when enter http:192.168.1.42:8080 ip of the my desktop from another pc it does not connect. The videos i have watched did the same thing i dont know what is wrong.  Should i need to make something for my non-server pc. I am stuck. 

[Nic Brough -Adaptavist-]

The most likely explanation is that there is a firewall blocking access to that.  Quite likely on the server itself - most OS's are now installed with active firewalls, especially systems intended to be server systems.

[Yusuf Can Anar]

How can i solve the issue about firewall ?

[Nic Brough -Adaptavist-]

I cannot tell you, I do not know anything about your server other than it can run Java and hence Atlassian software.

[Yusuf Can Anar]

I dont have java installed on my pc. I used setup wizard option when connecting to database to jira. Should i need to download java?

Also, i have enabled 1433 TCP port through firewall. 

And, which informations you need to know to help me i can list them here.

[Nic Brough -Adaptavist-]

No, you don't need to install Java, the installer bundles it.

I don't know why you've opened a random port when the url you connect to explicitly says 8080

[Yusuf Can Anar]

Not random Microsoft SQL uses 1433 TCP port. Probably this is SQL issue I can connect Jira on the desktop. 

[Nic Brough -Adaptavist-]

Why have you picked a totally random service that has nothing to do with your installation?  Instead of the http connection you are having the problem with?

[Yusuf Can Anar]

I have found few sources they are opening the 1433 port to connect a sql server from another pc. Not jira related. But they are directly connecting through sql server(studio) by entering the other pc's IP\username and password. I am really confused how jira works with SQL. 

[Yusuf Can Anar]

Hey, I have tried to open 8080 port and it actually worked for me. For anyone is need to connect to a local server from another computer in the local network;

I assume  you have installed sql and jira correctly.

1.open firewall

2. advance settings

3. Inbound Rules

4. New rule

5. Select port --> select tcp --> set specific port to 8080 --> next for other steps(dont forget to click to all networks)

Also I have changed profile of jira.exe files in the inbound rules to ALL.

Another thing i want to I ask how can i change website name? And where is the files uploaded to jira website in the server desktop?

[Nic Brough -Adaptavist-]

I'm still not sure why you looked at 1433 (you already said Jira was connected to Postgres), but I'm glad you got the http working on 8080

You don't need to think about jira.exe - that's not running here, Jira is a web-application that runs on Tomcat.  But it's working, so this is not causing you problems and doesn't matter.

To change the site name, you need to think about domains and networking.  You've now got a Jira system running on a computer that ends up with a url of something like 192.168.1.42 port 8080.  That will need to be added to DNS, or put behind a proxy server that is in DNS such that you can use its name on your network to reach it.  A proxy is also an easy way to drop the 8080 and run it on 443 (almost everything on the planet now assumes 443 when you put in https://something so it's work without needing a port any more)

I'm not sure what you mean by "files uploaded to Jira website" - the only upload to Jira I can think of is that you mean "attachments".  They're in a file store on the server, but it's not suitable for you to go rummaging around in, you should only access them via Jira.