Jira 6.1.4 install on same postgreSQL 9.3 database but different schema

Hi,

Because of enterprise policies I tried to install two jira instances on same postgre database but different schemas. At the moment when I am supposed to save admin user I get following java exception:

java.lang.RuntimeException: com.atlassian.jira.exception.CreateException: com.atlassian.crowd.exception.runtime.OperationFailedException: No Crowd Application available. at com.atlassian.jira.web.action.setup.SetupAdminAccount.doExecute(SetupAdminAccount.java:184)

Are there any special requirements for this scenario?

Thank you.

4 answers

0 vote

That's not really much to do with the database, it's telling you the authentication stuff is broken. You don't need anything special for your situation (many places run one database with several applications using it for their data store)

You probably need to look into the log a bit more. But have a look at https://confluence.atlassian.com/display/JIRAKB/JIRA+is+Unable+to+Connect+to+Crowd+due+to+Application+failed+to+authenticate to start with.

But I do not have any kind of LDAP authentication.

If I install two JIRA instances on separate databases everything is working just fine.

I think that somehow Jira is messing data from different database schemas.

It very much sounds like it. Are the two settings definitely pointing at completely different schema?

I checked that with my collegues at least five times. Another interesting point is that we already have third instance running under different schema on same database, but that is upgrade from version 5.

DB Name: jiradatabase

jira instance _____ db role ________schema

jiraService _____ jiraService _____ jiraService

jiraTest _________jiradb_________ test

jiraProd _________jiraProd _______prod

Is there maybe rule about same name for role and schema?

Thank you for your help.

Andy Nguyen Atlassian Team Feb 06, 2014

Hi Dorde,

May I know how everything's going? Did you manage to resolve the issue somehow? Did you discover any relationships between jira instance, db role and schema?

Is jiraProd the first instance that worked and jiraTest the second that didn't work at first? How about jiraService?

Thanks in advance!

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,237 views 14 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot