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; } } }

Moving JIRA

NickW

Hi All

I am moving our instance of JIRA to a more powerful machine. To do so I am currently installing the same software set up we currently use so that I can then copy the HOME and Install directories over.

The bit I am puzzling over is creating a new JIRA db on the new machine into which the db can be imported. For which i will use something like:

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on JIRADB.* TO 'jiradbuser'@'localhost' IDENTIFIED BY 'password';

flush privileges;

The bit I am wondering about is do "jiradbuser" and "password" have to match that when the original db was set up? If so is there anyway i can retrieve this as at the moment I cannot remember/locate them.

I looked at

https://confluence.atlassian.com/display/JIRAKB/JIRA+Unable+to+Update+MySQL

Which seems to imply they can be found in

<jira-install>/conf/server.xml

But I cannot see the information there.

Thanks for you help

Nick

Accepted answers

Peter Van de Voorde

Hi Nick,

Just a question: Why don't you simply install a new JIRA instance and use the restore backup option to import all data? It would simply be the following steps:

Install the same version of JIRA with the same plugins as in your old instance on the new server (using the new MYSQL Database)
Make a backup of the full Old JIRA Instance
Restore the backup into the new JIRA Instance
Copy over the data folder if needed from the old JIRA home directory to the new JIRA home directory.
Go home and have a beer to celebrate

Best regards,

Peter

All comments

Theinvisibleman

Hey there Nick,

You should be able to find the username and password used to connect to your DB inside the 'dbconfig.xml' file which is in your JIRA Home directory

NickW

Hi Joe,

Thanks for the quick reply. in dbconfig.xml I see:

<username>jiradbuser</username>

Does this mean no password Or is it obfuscated?

Nick

Nic Brough -Adaptavist-

That means you've no password set!

NickW

Thanks Nic

mmm now thats very odd and I suspect not good practice.

In someways my original question stands.. do the username & password I set here HAVE to match those that were set in the original database. If not then I can create this new DB with user and password to anything.

Nic Brough -Adaptavist-

>mmm now thats very odd and I suspect not good practice.

Well you should take that up with who did it! I'd never recommend it either!

>In someways my original question stands.. do the username & password I set here HAVE to match those that were set in the original database.

Yes, if you want to use the same database unchanged

>If not then I can create this new DB with user and password to anything.

If you import the whole database including all its settings, then you'll inherit username/password. Absolutley no reason you can't simply change it and use what you like.

NickW

Hi All sorry for the quiet period... Only just back on trying to move JIRA

OK: So I backed up the HOME and INSTALL Directories after exporting the data.

I transferred these to the new machine and imported the data. (first concern is that I got a server timed out message after 35 mins. When I started a browser things seemed to be there...

Anyway I then pressed on with copying over the HOME and INSTALL Directories.

The JIRA service seems to start OK (using services.msc on windows)

But when I fire up the browser I now get:

HTTP Status 500 - com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (Access denied for user 'jiradbuser'@'localhost' (using password: NO))

Then I remembered the original db didnt have a password and on this one I had set one. So I edited the dbconfig to reflect this.

Again restarting the service and opening a browser I get the same message... I am sure this is linked to what you wrote nic.. but I am at a loss

Any offers?

Vijay Khacharia

Can you try connection to DB using username and password using configuration utility? Here are steps from documentation.

JIRA configuration tool

Run the JIRA configuration tool as follows:
- Windows: Open a command prompt and runconfig.bat in the binsub-directory of the JIRA Installation Directory.
- Linux/Unix: Open a console and execute config.sh in the bin sub-directory of theJIRA Installation Directory.
  This may fail with the error as described in our Unable to Start JIRA Config Tool due to No X11 DISPLAY variable was set error KB article. Please refer to it for the workaround.
Navigate to the Database tab and set Database type to MySQL.
Fill out the fields, as described in the Database connection fieldssection below.
Test your connection and save.
Restart JIRA.

NickW

Thanks Vijay.. I had forgotten that tool. Just tried it and the toold says 'connection successful'

Peter Van de Voorde

Hi Nick,

Just a question: Why don't you simply install a new JIRA instance and use the restore backup option to import all data? It would simply be the following steps:

Install the same version of JIRA with the same plugins as in your old instance on the new server (using the new MYSQL Database)
Make a backup of the full Old JIRA Instance
Restore the backup into the new JIRA Instance
Copy over the data folder if needed from the old JIRA home directory to the new JIRA home directory.
Go home and have a beer to celebrate

Best regards,

Peter

NickW

Hi Peter

I thought thats what I have done..

1. Exported data

2. Installed MYSQL on new machine; created new empty database

3. Installed JIRA

4. Connected JIRA and imported the exported data

5. Over wrote new JIRA install and home directories with previous from spource machine

6. Try to connect and then get issue (described above)

Peter Van de Voorde

Go to you myssql and execute the following commands:

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on JIRADB.* TO 'jiradbuser'@'*' IDENTIFIED BY 'password';

flush privileges;

then update your dbconfig.xml to use the password.

restart JIRA, try again.

I thought you exported the database using the mysql tools, not the Jira tools.

Best regards,

Peter

Nic Brough -Adaptavist-

You said earlier that the import timed out, which could explain some of the problems you're getting.

Not the "unable to establish connection" message - that's happening before you hit any potentially damaged data.

As Peter says, you really should be using the database's own tools to get a full clean copy and import that (unless you're changing database or upgrading really old Jiras)

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration

administration