Installation of multiple products and handling of accounts

[Kevin Pham]

Hi Support team, I have couple questions related to deployment and haven't been able to search for a satisfying answer. Hopefully you guys can help clarify

1. Right now in our dev environment, we have confluence installed on mySQL 5.7x and JSD/JSW running in another database server running mySQL 5.6x. Can these applications run in the same version of mySQL? Which version would that be? I asked because I'd like to move to another installation that has only one database server to worry about.

2. Is it possible to install JSD/JSW/Confluence in an integrated deployment so that same end-user account can access all 3 applications instead of having to have 3 accounts? I'd prefer all 3 applications run from the same URL. I've been looking for a document that describes this install but haven't been able to find one that matches my intention.

Thanks!

[Nic Brough -Adaptavist- · Accepted solution]

I'm runnning all my Atlassian applications on a single Postgres server.  It's not an unusual set up.

Check the "supported platforms" page for each application to make sure you get the right version of the databases.

For the question of multiple servers, you need to run two services here.  One Confluence, and one JIRA, with Software and/or Service Desk added to it.

To get the same set of users, the easiest thing to do is hook the two services up to the same user directory.  If you don't have a service already, then the most simple setup is to tell JIRA to use Confluence as a directory, or the other way around.  The next step up would be to use Crowd (which makes SSO really easy), or go to LDAP or another directory product.

Finally, "on the same url" simply can't happen.  If I go to http://somewhere.com, which application is going to serve my pages?  However, you can do http://somewhere.com/jira and http://somewhere.com/confluence or other naming schemes - it's quite easy with a proxy server (it serves up all pages, but forwards information to and from separare applications depending on the requested pages)

[Kevin Pham]

Thanks for a quick response!!!

- For the URL part, I think I'm going with the https://domain.com/app so that I'll have to deal with only one SSL certificate. We do use reverse proxy so this shouldn't be hard.

- I double checked again, there's new version of jira and conf that both work on mySQL 5.7x so that's good news.

- I'll look into the option of using each other's user directory during installation. Thanks!

[Nic Brough -Adaptavist-]

Yes, a reverse proxy with all the SSL terminated in one place does make it easier!

On the user directory, I would generally not set that up during installation.  Get the basics working with an admin account with the internal directory separately for each application, then pick one and add the remote directory to it.  (I tend to use Confluence reading the JIRA directory, as I spend more time in JIRA than Confluence)