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

This widget could not be displayed.

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.

This widget could not be displayed.

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?

This widget could not be displayed.

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!

This widget could not be displayed.

You may try https://confluence.atlassian.com/display/JIRA052/Using+the+JIRA+Configuration+Toolto test the connection to the correct schema.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

83 views 1 0
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