nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change the schema that JIRA starts

Eduardo Menezes

I have installed a new UAT JIRA based on a restored database from Production.

Although I changed the dbconfig.xml with the correct schema, I am still not being able to login into the schema I need.

Every time I log, I get to the empty JIRA schema.

Can you help me?

Accepted answers

All comments

Nic Brough -Adaptavist-

All we can tell you here is that your dbconfig.xml is wrong, or the database that you have restored is not right. Could you tell us, in more detail, what you have done and what the errors/messages are as Jira starts up?

Eduardo Menezes

Hi Nic, thanks for your reply

The dbconfig.xml looks correct once confirmed with images

<?xml version="1.0" encoding="UTF-8"?>
<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>jiraschema</schema-name>
<jdbc-datasource>
<url>jdbc:jtds:sqlserver://W03133USQL0:1433/jiraDBGAM</url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<username>jiradbuser</username>
<password>******</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
</jdbc-datasource>
</jira-database-config>

the database has the schema that I want but it looks like I am missing someting to start the application under this new schema

because when I try to login with the user that is on this schema, it's not recognized

but if I log with the user that is on dbo. it works.

thanks for your timing.

Nic Brough -Adaptavist-

This has nothing to do with the database - the fact you get that login page means that Jira is up and running and connected to the database.

You should not be logging in there with the database connections, you should be logging in with a Jira account.

Eduardo Menezes

Hi Nic,

Can you let me know can I am logging into the Dana and and schema that I expect to, according to the database configured file?

Can you give me some directions or explain me what I am missing?

I have a database restored

I have a new installed environment

I expect that I could log into this restored database from this new environment created.

Can you help me?

Let me know if you need any additional information

Thanks in advance

Nic Brough -Adaptavist-

I've already explained most of that, but I will try again.

Your Jira is running, it has connected to the restored database fine and is fully started (if this were not the case, you would not get a log in prompt)

The problem now is that you are trying to log into Jira with a Jira account that either does not exist, or you have not got the right password for.

The database configuration is irrelevant to this, it's working fine. You need to use a known Jira account from the system you restored, not a database account.

Eduardo Menezes

Hi Nic

Imagine the following.

In this restored database I have two schemas and I have users on the following tables

dbo.cwd_user
jiraschema.cwd_user

When I log with the user on the dbo schema it works.

But when I log with user on the jiraschema schema it does not work.

Let me know if it was clear my issue?

Regards,

Eduardo Menezes

Nic Brough -Adaptavist-

You are still confusing database access with Jira access from what I can make out.

You log into a database with a database account. You log into Jira with a Jira account. I think you might be confused because someone set up one of your database accounts with the same credentials as a Jira account.

Stop looking at the database, we know that is working, because Jira is asking you to log in.

You need to log into that system with a Jira account. This account will be one of the accounts that was set up on the system you restored from. Again, NOT a database account.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

jira-software

database

scheme